WKPROJFCPD

Field Name

Caption

Mask

Description

Field Type

ID_CRT_BY

Created By

25x

Created By

Text

ID_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

ID_FE_ID

PO Detail Rec #

nnnnnnnn

Link to WKPROJFD.FE_ID

Long Integer

ID_FN_ID

PO Rec #

nnnnnnnn

Link to WKPROJF.FN_ID

Long Integer

ID_IC_ID

Invoice PO Detail Rec #

nnnnnnnn

Link to WKPROJFCPP.IC_ID

Long Integer

ID_ID

Invoice Detail Rec #

nnnnnnnn

Invoice Detail Rec #

Long Integer

ID_ITCOST

Invoice Total Cost

-nnnnnnnn.nn

Invoice Total Cost

Double

ID_IUNITS

Invoice Units

-nnnnnnnn.n

Invoice Units

Double

ID_LITEM

Line Item

nnnn

Line Item

Integer

ID_MOD_BY

Last Modified By

25x

Last Modified By

Text

ID_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

ID_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

ID_POTCOST

PO Total Cost

-nnnnnnnn.nn

PO Total Cost

Double

ID_POUCOST

PO Unit Cost

-nnnnnnnn.nn

PO Unit Cost

Double

ID_POUNITS

PO Units

-nnnnnnnn.n

PO Units

Double

ID_PRODESC

Product Description

255x

Product Description

Text

ID_PTCOST

Previous Total Cost

-nnnnnnnn.nn

Previous Total Cost

Double

ID_PUNITS

Previous Units

-nnnnnnnn.n

Previous Units

Double

ID_ROWVER

Rowversion for optimistic locking

Date/Time

ID_RTCOST

Remaining Total Cost

-nnnnnnnn.nn

Remaining Total Cost

Double

ID_RUNITS

Remaining Units

-nnnnnnnn.n

Remaining Units

Double

ID_UOM_CD

Unit of Measure

5x

PO Unit of Measure

Text

ID_UOM_TY

Unit of Measure Text

25x

PO Unit of Measure Text

Text