Description
|
PM Table
|
Accounting Table
|
Notes
|
|
PROJMGMT
|
ESTDETL
|
|
Detail Item Record Type
1=BuyoutItem
2=Production Item
|
MiscInt11
|
ImportItemType
|
Used on IMPORTED records only; MiscInt11 is used to determine if the item is a Production Unit or a Buyout Item
|
Bid Item No
|
MiscFloat15
|
ScheduleTask3A
|
Production Item Only
|
Bid Item Type
0=Master
1=Task
|
MiscFloat16
|
ScheduleTask3B
|
Production Item Only
|
Bid Item Task No
|
MiscFloat17
|
ProdUnitTaskNumber
|
Production Item Only
|
Item No
|
MiscFloat18
|
ScheduleTask3C
|
Production Item Only
MiscFloat18 is needed when the item is NOT linked to accounting; value 7 = linked; ONCE LINKED, this field is no longer valid in terms of the link to ESTDETL. EstDetl.ScheduleTask3C = Estdetl.Item when item is linked to accounting.
|
COR Item Type
0=Both
1=Cost
2=Billing
|
MiscInt10
|
|
|
|
PMEstDetlItemNo
|
Item
|
ESTDETL item number when linked to accounting
|
|
MiscInt3
|
|
|
|
PMID
|
PMCORPMID
|
|
Billing Phase
|
Bill_Phase
|
Bill_Phase
|
|
Billing Description
|
MiscMemo
|
Bill_Desc
|
|
Phase
|
Phase
|
Phase
|
|
Expense Account
|
MiscFloat11
|
ExpenseGLAcct
|
|
|
|
Item_Desc
|
Example: COR:9 - PMID REF:73138
|
Revenue Account
|
MiscFloat12
|
Rev_Acct
|
|
Estimated Cost
|
PMAmount3
|
Est_Cost
|
|
Estimated Hours
|
PMAmount4
|
Est_Units
|
|
|
PMAmount5
|
N/A
|
|
|
PMAmount6
|
N/A
|
|
Billing Amount
|
PMAmount7
|
Item_Contr
|
|
Estimated Production Units
|
PMAmount8
|
Item_ContrUnits
|
|
|
PMPercent8
|
|
|
Unit of Measure
|
PMDesc4
|
Item_ContrUnitCost
|
|
|
PMCalcMethod1
|
N/A
|
|
|
PMCalcMethod2
|
N/A
|
|
|
PMCalcMethod3
|
N/A
|
|
Total Markup and Overhead
|
MiscFloat3
|
|
|
|
|
|
|
|
|
|
|