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 |
|