Link table for Vendors and Parts
Field Name |
Caption |
Mask |
Description |
Field Type |
PE_CRT_BY |
Created By |
25x |
Created By |
Text |
PE_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PE_DESC |
Description |
75x |
Description: |
Text |
PE_DOC_FLG |
Document Available |
|
Doc Available: Doc Flag |
Boolean |
PE_END_DT |
End Date |
mm/dd/yyyy |
Preferred Vendor Expiration Date |
Date/Time |
PE_ID |
|
|
Unique Identifier: |
Long Integer |
PE_IMG_FLG |
|
|
Image Available: Image open 0 = False, 1 = True |
Boolean |
PE_MOD_BY |
Last Modified By |
25x |
Modified By : Person that Last Modified Record |
Text |
PE_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Modified Date : Date Record Last Modified |
Date/Time |
PE_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PE_MOV_FLG |
|
|
Movie Available: Movie open 0 = False, 1 = True |
Boolean |
PE_NUMBER |
Vendor Part ID |
20x |
Vendors part Number: |
Text |
PE_PA_ID |
Part Rec # |
nnnnnnnn |
Long Integer |
|
PE_PV_ID |
Vendor Rec # |
nnnnnnnn |
Long Integer |
|
PE_RANK |
Rank |
nnnnn |
Rank of Vendor for this Part |
Integer |
PE_RATIO |
Ratio |
nnnnn.nnn |
Ratio of Vendor Units to Parts Units |
Double |
PE_ROWVER |
|
|
Rowversion for optimistic locking |
TimeStamp |
PE_SHIP_D |
Shipping Dimen. |
30x |
Shipping Dimensions |
Text |
PE_SHIP_W |
Shipping Weight |
nnnnnn.nn |
Shipping Weight |
Double |
PE_UPC |
UPC Code |
50x |
UPC Code |
Text |
PE_VUCOST |
Vendor Unit Cost |
nnnnnnn.nn |
Vendor Unit Cost |
Double |
PE_VUOM_CD |
Vendor UOM |
5x |
Vendor UOM |
Text |
PE_VUOM_TY |
Vendor UOM Text |
25x |
Vendor UOM Text |
Text |