PTPODETAIL

Field Name

Caption

Mask

Description

Field Type

PD_COST

Inv. Unit Price

nnnnnnnn.nn

Cost

Double

PD_CRT_BY

25x

Created By

Text

PD_CRT_DTTM

Creation Date Time

Date/Time

PD_DATRCVD

Date Received

mm/dd/yyyy

Date Received

Date/Time

PD_EQVQTY

Part Units

nnnnnnnnn.nn

Equivalent Part Quantity:

Double

PD_ID

Rec #

nnnnnnnn

Unique Identifier:

Long Integer

PD_LOGGED

Are Parts Logged:

Boolean

PD_MOD_BY

25x

Last Modified By

Text

PD_MOD_DT

Last Modified Date

Date/Time

PD_MOD_TM

Modified Time

Date/Time

PD_PA_ID

Part Rec #

nnnnnnnn

Link to PTPARTS.PA_ID

Long Integer

PD_PA_NBR

Part Number

15x

PartNumber

Text

PD_PE_ID

Vendor Part Rec #

nnnnnnnn

Link to PTVPART.PE_ID

Long Integer

PD_PE_NBR

Vendor Part No

20x

Redundantly stored to allow filter on it

Text

PD_PL_ID

Location Placed

nnnnnnnn

Link to PTLOCATION.PL_ID

Long Integer

PD_POID

PO Unique Identifier:

Long Integer

PD_PQTYREM

Parts Remaining

nnnnnnnnn.nn

Parts Quantity Remaining to be received in Parts UOM

Double

PD_PUOM_CD

Part UOM

5x

Part UOM

Text

PD_PUOM_TY

Part UOM Text

25x

Part UOM Text

Text

PD_QTY

Vendor Units

nnnnn.nn

Quantity:

Double

PD_RATIO

Ratio

nnnnn.nnn

Ratio

Double

PD_RECVD

Part Units rec'vd

nnnnn.nn

Received:

Double

PD_REFER

Reference

30x

Store Ref Num to link to partcost in case they need to go back and adjust cost

Text

PD_ROWVER

Rowversion for optimistic locking

TimeStamp

PD_SUBTTL

Sub Total

nnnnnnn.nn

Sub Total:

Double

PD_UNITPRC

Vendor Unit Cost

nnnnnnnn.nn

Unit Cost:

Double

PD_UNTPPT

Part Unit Cost

nnnnnn.nn

Unit Cost in Warehouse Terms

Double

PD_UOM_DS

Part UOM

10x

Unit of Measure as distributed

Text

PD_UOM_PR

Vendor UOM

10x

Unit of Measure as purchased

Text

PD_UPC

UPC Code

50x

UPC Code

Text

PD_VQTYREM

Vendor Remaining

nnnnnnnnn.nn

Vendor Quantity Remaining to be received in Vendor UOM

Double

PD_VRECVD

Vend Units Recv'd

nnnnnnn.nn

Vendor Units Received

Double

PD_VUOM_CD

Vendor UOM

5x

Vendor UOM

Text

PD_VUOM_TY

Vendor UOM Text

25x

Vendor UOM Text

Text