Parts Imported Review
Field Name |
Caption |
Mask |
Description |
Field Type |
PZ_APP_BY |
Approved By |
25x |
Approved By |
Text |
PZ_APP_DT |
Approved Date |
mm/dd/yyyy |
Approved Date |
Date/Time |
PZ_COST |
Unit Cost |
nnnnnnn.nn |
Unit Cost of Transaction |
Double |
PZ_CRT_BY |
Created By |
25x |
Created By |
Text |
PZ_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PZ_DESC |
Description |
100x |
Description: |
Text |
PZ_DT |
Date |
mm/dd/yyyy |
Transaction Date |
Date/Time |
PZ_ERROR |
Process Error |
100x |
Error message from last process |
Text |
PZ_ID |
|
|
Unique Identifier: |
Long Integer |
PZ_INVALID |
Validation Failed |
|
Validation Failed so No Transaction Posted |
Boolean |
PZ_LCODE |
Location Barcode |
30x |
Location Code |
Text |
PZ_LCODE2 |
Location 2 Barcode |
30x |
To Location Code |
Text |
PZ_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
PZ_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
PZ_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PZ_PA_ID |
Part Rec # |
|
Long Integer |
|
PZ_PCODE |
Part Barcode |
30x |
Part Code |
Text |
PZ_PL_ID |
From Location Rec # |
|
Link to PTLOCATION.PL_ID for From Location |
Long Integer |
PZ_PL2_ID |
To Location Rec # |
|
Link to PTLOCATION.PL_ID for To Location |
Long Integer |
PZ_PO |
PO Number |
15x |
PO Number |
Text |
PZ_PROC |
Processed |
|
Processed |
Boolean |
PZ_PT_ID |
Transaction Rec # |
|
Long Integer |
|
PZ_QTY |
Quantity Entered |
nnnnnnn.nn |
Quantity of Transaction |
Double |
PZ_REFER |
Reference |
30x |
Reference: |
Text |
PZ_ROWVER |
|
|
Rowversion for optimistic locking |
TimeStamp |
PZ_SQTY |
System Quantity |
-nnnnnnn.nn |
System Quantity |
Double |
PZ_TCOST |
Transact Unit Cost |
nnnnnnn.nn |
Transaction Unit Cost |
Double |
PZ_TM |
Time |
hh:mm am |
Transaction Time |
Date/Time |
PZ_TQTY |
Transact Quantity |
-nnnnnnn.nnn |
Transaction Quantity |
Double |
PZ_TYPE |
Entered Transact |
10x |
Transaction Type: |
Text |
PZ_TYPE_CD |
Logged Transact |
nnn |
Transaction Type |
Integer |
PZ_TYPE_TY |
Logged Transact Text |
25x |
Transaction Type Text |
Text |
PZ_USER |
User Name |
25x |
User Initiating Transaction |
Text |