WKPROJFDDD

Project PO Details Line Items Linked to Invoices

Field Name

Caption

Mask

Description

Field Type

FG_CP_ID

 

 

Link to WKPROJFCP.CP_ID

Long Integer

FG_CRT_BY

 

25x

Created By

String

FG_CRT_DTTM

 

mm/dd/yyyy hh:mm am

Creation Date Time

DateTime

FG_FE_ID

 

 

Link to WKPROJFD.FE_ID

Long Integer

FG_FF_ID

 

 

Link to WKPROJFDD.FF_ID

Long Integer

FG_ID

 

 

PO Detail Line Rec # that contains Invoice and Invoice Payment data

Long Integer

FG_ID_ID

 

 

Link to WKPROJFCPD.ID_ID

Long Integer

FG_INVPERC

 

 

Invoice amount based on the percentage going to this Project

Double

FG_MOD_BY

 

25x

Last Modified By

String

FG_MOD_DT

 

mm/dd/yyyy hh:mm am

Last Modified Date

DateTime

FG_MOD_TM

 

mm/dd/yyyy hh:mm am

Modified Time

DateTime

FG_PAIDPER

 

 

Invoice Paid Amount for the Project as a percentage of the line item

Double

FG_PERCENT

 

 

Invoice amount based on the percentage going to this Project

Double

FG_PJ_ID

 

 

Link to WKPROJ.PJ_ID

Long Integer

FG_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp

FG_VP_ID

 

 

Link to WKPROJIP.VP_ID

Long Integer