Project Contract Estimates
Field Name |
Caption |
Mask |
Description |
Field Type |
XE_ADR_B2 |
Street Post Bldg No |
8x |
Street Post Building No |
Text |
XE_ADR_BDG |
Address |
nnnnnn |
Address : Building Number |
Long Integer |
XE_ADR_DIR |
Street Direction |
2x |
Street Direction |
Text |
XE_ADR_PT |
Street Prefix Type |
5x |
Street Prefix Type |
Text |
XE_ADR_SFX |
Street Suffix |
5x |
Street Suffix |
Text |
XE_ADR_STR |
Street Name |
50x |
Street Name |
Text |
XE_ADR_TY |
Street Type |
5x |
Street Type |
Text |
XE_APPRVD |
Approved |
|
Approved |
Boolean |
XE_COMMENT1 |
Long Note |
|
Long Note |
Memo |
XE_CRT_BY |
Created By |
25x |
Created By |
Text |
XE_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
XE_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
XE_EST_BY |
Estimated By |
40x |
Estimated By |
Text |
XE_EST_DT |
Estimated Date |
mm/dd/yyyy |
Estimated Date |
Date/Time |
XE_ESTTOTAL |
Estimated Total |
nnnnnnnnn.nn |
Estimated Total |
Double |
XE_ESTTP |
Est Total plus |
nnnnnnnnn.nn |
Est Total plus |
Double |
XE_FN_ID |
Project PO Rec # |
nnnnnnnn |
Long Integer |
|
XE_GENLOC |
General Location |
200x |
General Location |
Text |
XE_ID |
Contract Estimate Rec # |
nnnnnnnn |
Contract Estimate Rec # |
Long Integer |
XE_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
XE_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
XE_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
XE_NUMBER |
Estimate Number |
25x |
Estimate Number |
Text |
XE_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
XE_STAT_CD |
Status |
6x |
Status |
Text |
XE_STAT_TY |
Status Text |
30x |
Status Text |
Text |
XE_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
XE_USER1TY |
User 1 Type |
50x |
User 1 Type |
String |
XE_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
XE_USER2TY |
User 2 Type |
50x |
User 2 Type |
String |
XE_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
XE_USER3TY |
User 3 Type |
50x |
User 3 Type |
String |
XE_USER4 |
User 4 |
50x |
User 4 |
String |
XE_USER5 |
User 5 |
50x |
User 5 |
String |
XE_USER6 |
User 6 |
50x |
User 6 |
String |
XE_USER7 |
User 7 |
nnnnnnnn.nn |
User 7 |
Double |
XE_USER8 |
User 8 |
nnnnnnnn.nn |
User 8 |
Double |
XE_USER9 |
User 9 |
nnnnnnnn.nn |
User 9 |
Double |
XE_USER10 |
User 10 |
mm/dd/yyyy hh:mm am |
User 10 |
DateTime |
XE_USER11 |
User 11 |
mm/dd/yyyy hh:mm am |
User 11 |
DateTime |
XE_USER12 |
User 12 |
mm/dd/yyyy hh:mm am |
User 12 |
DateTime |
XE_USER13 |
User 13 |
|
User 13 |
Boolean |
XE_USER14 |
User14 |
|
User14 |
Boolean |
XE_USER15 |
User 15 |
|
User 15 |
Boolean |
XE_X_COORD |
Loc X Coord. |
-nnnnnnnnn.nnnnnnnn |
X Coordinate |
Double |
XE_XC_ID |
Contract Rec # |
nnnnnnnn |
Long Integer |
|
XE_Y_COORD |
Loc Y Coord. |
-nnnnnnnnn.nnnnnnnn |
Y Coordinate |
Double |