Project Contract Details
Field Name |
Caption |
Mask |
Description |
Field Type |
XD_CRT_BY |
Created By |
25x |
Created By |
Text |
XD_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
XD_ID |
Contract Detail Rec # |
nnnnnnnn |
Contract Details Rec # |
Long Integer |
XD_LITEM |
Contract Line Item |
nnnn |
Line Item |
Integer |
XD_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
XD_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
XD_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
XD_NAME |
Name |
255x |
Name |
Text |
XD_NPRICE |
Net Price |
-nnnnnnnn.nn |
Net Price |
Double |
XD_POST_DT |
Posted Date |
mm/dd/yyyy |
Posted Date |
Date/Time |
XD_PRODESC |
Product Description |
255x |
Product Description |
Text |
XD_QUANT |
Quantity |
nnnnnnnn.nn |
Quantity |
Double |
XD_RELEA |
Item Released |
1x |
Item Released |
Text |
XD_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
XD_RQUANT |
Released Quantity |
-nnnnnnnn.nn |
Released Quantity |
Double |
XD_RVALUE |
Released Value |
-nnnnnnnn.nn |
Released Value |
Double |
XD_TPRICE |
Total Price |
nnnnnnnn.nn |
Total Price |
Double |
XD_TQUANT |
Target Quantity |
-nnnnnnnn.nn |
Target Quantity |
Double |
XD_TVALUE |
Target Value |
-nnnnnnnn.nn |
Target Value |
Double |
XD_UOM_CD |
Order Unit |
5x |
Order Unit |
Text |
XD_UOM_TY |
Order Unit Text |
25x |
Order Unit Text |
Text |
XD_UPRICE |
Unit Price |
-nnnnnnnn.nn |
Unit Price |
Double |
XD_USER1 |
User 1 - Text |
50x |
User 1 - Text |
String |
XD_USER2 |
User 2 - Text |
50x |
User 2 - Text |
String |
XD_USER3 |
User 3 - Text |
50x |
User 3 - Text |
String |
XD_USER4 |
User 4 - Numeric |
nnnnnnnn.nn |
User 4 - Numeric |
Double |
XD_USER5 |
User 5 - Numeric |
nnnnnnnn.nn |
User 5 - Numeric |
Double |
XD_USER6 |
User 6 - Numeric |
nnnnnnnn.nn |
User 6 - Numeric |
Double |
XD_VPE_DT |
Validity Period End |
mm/dd/yyyy |
Validity Period End |
Date/Time |
XD_VPS_DT |
Validity Period Start |
mm/dd/yyyy |
Validity Period Start |
Date/Time |
XD_XC_ID |
Contract Rec # |
nnnnnnnn |
Long Integer |