Permit and WO Link table
Field Name |
Caption |
Mask |
Description |
Field Type |
WP_CRT_BY |
Created By |
25x |
Created By |
Text |
WP_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
WP_ID |
Link Rec # |
nnnnnnnn |
Autonumber |
Long Integer |
WP_MOD_BY |
LastModifiedBy |
25x |
Last Modified By |
Text |
WP_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
WP_MOD_TM |
LastModifiedTime |
hh:mm am |
Modified Time |
Date/Time |
WP_PP_ID |
Permit Rec # |
nnnnnnnn |
Long Integer |
|
WP_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
WP_WO_ID |
Work Order Rec # |
nnnnnnnn |
Long Integer |