| 1 |
Contract # |
The contract number |
string(50) |
Yes/Yes |
|
| 2 |
Contract Name |
The name of the contract |
string(100) |
Yes/Yes |
|
| 3 |
Content Groups |
The content groups that can view this contract |
string |
No/No |
|
| 4 |
Status |
The status of the contract |
string(50) |
Yes/No |
|
| 5 |
Supplier |
The supplier ID assocaited with the contract |
integer(11) |
No/No |
|
| 6 |
Supplier Number |
Supplier Number |
string(255) |
No/No |
|
| 7 |
Supplier Account # |
The supplier account for the contract |
string(255) |
No/No |
|
| 8 |
Starts |
The date the contract begins |
datetime |
Yes/No |
|
| 9 |
Expires |
The date the contract expires |
datetime |
No/No |
|
| 10 |
Owner |
The currency ID associated with the contract |
integer(11) |
No/No |
|
| 11 |
Owner Login |
The user login that owns the contract |
string(255) |
No/No |
|
| 12 |
Currency Code |
Currency Code |
string(6) |
No/No |
|
| 13 |
Savings % |
The % savings created by the contract |
decimal(8,2) |
No/No |
|
| 14 |
Version |
The version number of the contract |
integer |
No/No |
|
| 15 |
Created By |
The user ID that created the contract |
integer |
No/No |
|
| 16 |
Created By Login |
Created By Login |
string(255) |
No/No |
|
| 17 |
Created Date |
The date the contract was created |
datetime |
No/No |
|
| 18 |
Updated By |
The user ID that most recently updated the contract |
integer(11) |
No/No |
|
| 19 |
Updated By Login |
The user login that most recently updated the contract |
string(255) |
No/No |
|
| 20 |
Updated Date |
The date the contract was most recently updated |
datetime |
No/No |
|
| 21 |
Submitted Date |
The date the contract was submitted |
datetime |
No/No |
|
| 22 |
Submitted By |
The user ID of the person that submitted the contract |
integer(11) |
No/No |
|
| 23 |
Submitted By Login |
Ther user login that submitted the approval |
string(255) |
No/No |
|
| 24 |
Is Default |
Is this the detault (Y/N) |
boolean |
No/No |
|
| 25 |
Default Account ID |
The default account ID for the contract |
integer(11) |
No/No |
|
| 26 |
Default Account Code |
The default account code for the contract |
string(21024) |
No/No |
|
