Purchase Order Receipt Details
Field Name |
Caption |
Mask |
Description |
Field Type |
PS_CRT_BY |
|
25x |
Created By |
Text |
PS_CRT_DTTM |
|
|
Creation Date Time |
Date/Time |
PS_DAMAGED |
|
|
Damaged |
Boolean |
PS_ID |
|
|
AutoID |
Long Integer |
PS_LOGGED |
|
|
|
Boolean |
PS_MOD_BY |
|
25x |
Last Modified By |
Text |
PS_MOD_DT |
|
|
Last Modified Date |
Date/Time |
PS_MOD_TM |
|
|
Modified Time |
Date/Time |
PS_PA_ID |
Part Rec # |
|
Long Integer |
|
PS_PD_ID |
PO Detail Rec # |
|
Long Integer |
|
PS_PE_ID |
Vendor Rec # |
nnnnnnnn |
Long Integer |
|
PS_PE_NBR |
Vendor Number |
15x |
Vendor Number |
Text |
PS_PL_DESC |
Location Desc |
50x |
Location Desc |
Text |
PS_PL_ID |
Location Rec # |
nnnnn |
Long Integer |
|
PS_PL_NUMB |
Location Number |
15x |
Location Number |
Text |
PS_PR_ID |
PO Receipt Rec # |
|
Long Integer |
|
PS_QTY |
Part Quantity |
nnnnnn.nn |
Received Quantity |
Double |
PS_ROWVER |
|
|
Rowversion for optimistic locking |
TimeStamp |
PS_TOTAL |
Total Cost |
nnnnnnn.nn |
Vendor Total Cost |
Double |
PS_UNTCST |
Part Unit Cost |
nnnnnn.nn |
Unit Cost |
Double |
PS_VQTY |
Vendor Qty |
nnnnnnn.nn |
Vendor Quantity |
Double |
PS_VUCOST |
Vendor Unit Cost |
nnnnnnn.nn |
Vendor Unit Cost |
Double |
PS_WHDESC |
Warehouse Desc |
50x |
Warehouse Description. |
Text |
PS_WHID |
|
|
Link to warehouse (not used yet, only stored in case it might be in the future.) |
Long Integer |
PS_WHNUMB |
Warehouse ID |
20x |
Warehouse Number |
Text |