Equipment Costs
Field Name |
Caption |
Mask |
Description |
Field Type |
GC_ACCOUNT |
Account # |
45x |
Account # |
Text |
GC_AMOUNT |
Amount |
nnnnnnnn.nn |
Amount of Cost |
Double |
GC_CRT_BY |
Created By |
25x |
Created By |
Text |
GC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
GC_CSDC_CD |
Cost Desc |
nnn |
Cost Description Code |
Integer |
GC_CSDC_TY |
Cost Desc Text |
25x |
Cost Description Text |
Text |
GC_DATE |
Date |
mm/dd/yyyy |
Date of Cost |
Date/Time |
GC_GE_ID |
Equipment Rec # |
-nnnnnnnn |
Long Integer |
|
GC_ID |
Equip Cost Rec # |
-nnnnnnnn |
Unique ID |
Long Integer |
GC_MOD_BY |
Last Modified By |
25x |
Modified By |
Text |
GC_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modification Date |
Date/Time |
GC_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
GC_NOTE |
Comment |
255x |
Note |
Text |
GC_PNUMACT |
Proj No - Acct |
40x |
Proj No - Acct |
Text |
GC_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |