Closeout Screen - Field Assignments |
Top Previous Next |
MAR Class Code: 381
LogTypeID = 5 (Closeout LOG Record)
Screen Field Name Database Field Name (ProjMgmt)
General Information Closeout Number LogNo Description LogDescription Notes Comments Closed StatusCode User Defined Fields (all logs same)
Internal Fields:
PMID – This field is used to link closeout items in the PMCODetail Table by linking to the same field (PMID) in the PMCODetail Table.
Close Out Items: NOTE: These tables are linked together via PMID Field
Screen Field Name Database Field Name (PMCODetail)
Category Category Contractor ContractorNANO Section Section Description Description Work Area MiscFloat1 (PMAreas table lookup) Qty. Required Misc6 Status Status Compl. Date Date Notes Notes
Internal Fields:
CloseOutID – This UNIQUE key field is used to link submittal records in the PROJMGMT Table (Main PM Log) to the COLOGNO field in PROJMGMT table
Submittal Items:
Screen Field Name Database Field Name (ProjMgmt)
Submittal # LogNo Description LogDescription Status StatusCode (See Submittal Log Status Codes) Status Date Status Date
Internal Fields:
COLogNo – This field will hold the UNIQUE key field called CloseOutID in the PMCODetail Tabl with the submittal record (PROJMGMT) is linked to a closeout log
|