Field setup table for Asset default values
Field Name |
Caption |
Mask |
Description |
Field Type |
AI_CAT_CD |
Category |
10x |
Category |
String |
AI_CAT_ID |
Link to WKCat |
nnnnnnnn |
Long Integer |
|
AI_CAT_TY |
Category Text |
60x |
Category Text |
String |
AI_CATINV |
Link to WKCatInv |
nnnnnnnn |
Link to WKCATINV.CI_ID |
Long Integer |
AI_CATINV_TY |
WKCatInv Name |
50x |
WKCatInv Name |
String |
AI_CRT_BY |
Created By |
25x |
Created By |
String |
AI_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
AI_ID |
Autonumber |
nnnnnnnn |
Autonumber |
Long Integer |
AI_MOD_BY |
Last Modified By |
25x |
Last Modified By |
String |
AI_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
AI_MOD_TM |
Last Modified Time |
mm/dd/yyyy hh:mm am |
Last Modified Time |
DateTime |
AI_ROWVER |
|
|
Rowversion for optimistic locking |
TimeStamp |
AI_TYPE |
Asset Type |
nnn |
Asset Type |
Integer |