PTPARTCOST

Part Cost

Field Name

Caption

Mask

Description

Field Type

PC_COSTAVG

Avg. Cost

nnnnnnnnn.nn

Average Cost per Unit

Double

PC_COSTUNT

Cost per Unit

nnnnnn.nnnn

Cost per unit

Double

PC_CRT_BY

Created By

25x

Created By

Text

PC_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

PC_CURRQTY

Current Qty.

-nnnnnnnnn.nnnn

Current Quantity

Double

PC_DATE

Inventoried Date

mm/dd/yyyy

Date

Date/Time

PC_ID

AutoNumber

nnnnnnnn

Unique Identifier:

Long Integer

PC_MOD_BY

Last Modified By

25x

Last Modified By

Text

PC_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

PC_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

PC_ORIGQTY

Original Qty.

nnnnn.nn

Original Quantity

Double

PC_PA_ID

Part Rec #

nnnnnnnn

Link to PTPARTS.PA_ID

Long Integer

PC_PONUM

PO Number

50x

 

Text

PC_PROCDT

Process Date

mm/dd/yyyy

 

Date/Time

PC_ROWVER

 

 

Rowversion for optimistic locking

Date/Time