Parts Transactions
Field Name |
Caption |
Mask |
Description |
Field Type |
PT_ALOCID |
Allocation |
nnnnnnnn |
Allocation Record ID: |
Long Integer |
PT_CONSUM |
Consumable |
|
Consumable |
Boolean |
PT_COST |
Unit Cost |
nnnnnn.nnnn |
Unit Cost of Transaction |
Double |
PT_COUNT |
Count |
nnnnnnnnn.nn |
Count |
Double |
PT_CRT_BY |
Created By |
25x |
Created By |
Text |
PT_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
PT_DATE |
Date |
mm/dd/yyyy |
Date Transaction was recorded |
Date/Time |
PT_DESC |
Description |
100x |
Description: |
Text |
PT_DESC_CD |
Transaction Descript |
nnn |
Transaction Type |
Integer |
PT_DESC_TY |
Transaction Descript Text |
40x |
Transaction Type Text |
Text |
PT_EM_ID |
Employee Rec No |
nnnnnnnn |
Employee Unique Identifier |
Long Integer |
PT_ID |
AutoNumber |
nnnnnnnn |
Unique Identifier: |
Long Integer |
PT_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
PT_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
PT_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
PT_ORGQTY |
Original Quantity |
nnnnnnnnn.nn |
Original Quantity before Count |
Double |
PT_PA_ID |
Part Rec # |
nnnnnnnn |
Long Integer |
|
PT_PL_ID |
Loc Rec # |
nnnnnnnn |
Long Integer |
|
PT_PTCSTID |
Part Cost Rec # |
nnnnnnnn |
Link to PTPARTCOST.PC_ID - Part Cost |
Long Integer |
PT_PTCTID2 |
Part Cost Rec # |
|
Link to PTPARTCOST.PC_ID - Part Replacement Cost |
Long Integer |
PT_PV_ID |
Vendor Rec # |
nnnnnnnn |
Long Integer |
|
PT_QTY |
Qty. |
nnnnnnnnn.nn |
Quantity of Transaction |
Double |
PT_REFER |
Reference |
30x |
Reference: |
Text |
PT_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
PT_TKID |
WO Task Rec # |
|
Long Integer |
|
PT_TOLOCID |
To Location |
nnnnnnnn |
Unique Identifier of the Location Part Transferred to: |
Long Integer |
PT_TRAN_TM |
Transaction Time |
hh:mm am |
Transaction Time |
Date/Time |
PT_TYPE |
Transaction Type |
30x |
Transaction Type: |
Text |
PT_TYPE_CD |
Transaction Type |
nnn |
Transaction Type |
Integer |
PT_TYPE_TY |
Transaction Type Text |
25x |
Transaction Type Text |
Text |
PT_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
PT_USER1TY |
User 1 Text |
40x |
User 1 Text |
Text |
PT_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
PT_USER2TY |
User 2 Text |
40x |
User 2 Text |
Text |
PT_USERID |
Created By |
25x |
Initials of the User that made the transaction |
Text |
PT_WOID |
Work Order Rec # |
nnnnnnnn |
Long Integer |
|
PT_WR_ID |
Link to Work Resource |
nnnnnnnn |
Long Integer |