PTINVLOG

Part Location Logs

Field Name

Caption

Mask

Description

Field Type

PQL_AVECOST

 

nnnnnnnn.nn

Average part cost

Double

PQL_CRT_BY

 

25x

Created By

String

PQL_CRT_DTTM

 

mm/dd/yyyy hh:mm am

Date time

DateTime

PQL_ID

 

nnnnnnnn

Unique Key

Long Integer

PQL_NOTES

 

50x

Special notes

String

PQL_PA_ID

 

nnnnnnnn

Link to PTPARTS.PA_ID

Long Integer

PQL_PI_ID

 

nnnnnnnn

Link to PTINV.PI_ID

Long Integer

PQL_QTY

 

nnnnnnnn.nn

New Quantity

Double

PQL_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp