Part Location Quantities
Field Name |
Caption |
Mask |
Description |
Field Type |
PI_CRT_BY |
Created By |
25x |
Created By |
Text |
PI_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PI_ID |
AutoNumber |
nnnnnnnn |
Unique Identifier: |
Long Integer |
PI_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
PI_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
PI_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PI_PA_ID |
Part Rec # |
nnnnnnnn |
Long Integer |
|
PI_PL_ID |
Location Rec # |
nnnnnnnn |
Long Integer |
|
PI_QTY |
Quantity |
-nnnnnnnnn.nnnn |
Quantity of this part# in the Location: |
Double |
PI_REORDER |
Reorder Point |
nnnnn.nn |
Reorder Point of this part# in the Location: |
Double |
PI_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |