Linking table for Parts/Components
Field Name |
Caption |
Mask |
Description |
Field Type |
PC_COMMENT1 |
Long Note |
|
Long Note |
Memo |
PC_COMP_CD |
Component |
nnn |
Component |
Integer |
PC_COMP_TY |
Component Text |
25x |
Component Text |
Text |
PC_CRT_BY |
Created By |
25x |
Created By |
Text |
PC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PC_DESC |
Description |
50x |
Description |
Text |
PC_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
PC_FL_ID |
Fleet Rec # |
-nnnnnnnn |
Long Integer |
|
PC_ID |
Part Equip Rec # |
-nnnnnnnn |
AutoID Number |
Long Integer |
PC_INAC_DT |
Inactive Date |
mm/dd/yyyy |
Inactive Date |
Date/Time |
PC_INST_DT |
Install Date |
mm/dd/yyyy |
Installed Date |
Date/Time |
PC_MAN_CD |
Manufacturer |
12x |
Manufacturer |
Text |
PC_MAN_TY |
Manufacturer Text |
60x |
Manufacturer Text |
Text |
PC_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
PC_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modification Date |
Date/Time |
PC_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PC_MODEL |
Model |
30x |
Model |
Text |
PC_QUAN |
Quantity |
nnnn.nn |
Quantity |
Double |
PC_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
PC_SERIAL |
Serial Number |
30x |
Serial Number |
Text |
PC_SPEC |
Spec |
80x |
Spec |
Text |
PC_STAT_CD |
Status |
nnn |
Status |
Integer |
PC_STAT_TY |
Status Text |
25x |
Status Text |
Text |
PC_YEAR |
Year |
30x |
Year |
Text |