TP Project XML LN resource elements mapping rules

These table list the mapping rules of the XML task elements for the cost objects and also the related Trade Group and Employee:

XML Task ElementsMapping ruleMaterialSub.
(internal) resource typequantityquantity/time
NameMAT.[PROJ.]SUB.
tppdm005.itemtppdm035.csub
tppdm635.csub
ItemSub
Typedepends on resource type0 or 1
CalendarUIDcalendar uicalendar ui
CalendarCalendar
avail type uiavail type ui
CreationDateutc.num()utc.num()
MaterialLabeldepends on resource typetcibd001.cunitppdm635.cuni
tppdm035.cuni
Unit
tppdm635.cuti
tppdm035.cuti
Time Unit
Codetppdm005.itemtppdm035.csub
tppdm635.csub
ItemSub
MaxUnitsdepends on resource type0 or 1
XML Task ElementsMapping ruleMaterialSub.
IsCostResource0
StandardRatecalculation *tppdm005.cpmctppdm635.pric
tppdm035.pric
Manual Unit CostUnit Cost
ticpr007.ecprtppdm035.pric
Estimated Standard Cost
StandardRate Formatdepends on resource type88 or 2
NT Account
EmailAddress
Text1LN Primary KeyLN Primary Key

 

XML Task ElementsMapping ruleEquipmentSundryLabor
(internal) resource typetimequantitytime
Name[PROJ.]EQU[PROJ.]SUN[PROJ.]LAB
tppdm025 .cequtppdm040 .cicotppdm015 .task
tppdm625 .cequtppdm640 .cicotppdm615 .task
EquipmentSundry CostLabor
Typedepends on resource type101
CalendarUIDtppdm025.ccalcalendar uicalendar ui
tppdm625.ccal
XML Task ElementsMapping ruleEquipmentSundryLabor
CalendarCalendarCalendar
avail type uiavail type uiavail type ui
CreationDateutc.num()utc.num()utc.num()
MaterialLabeldepends on resource typetppdm640.cuni
tppdm040.cuni
Unit
Codetppdm025 .cequtppdm040 .cicotppdm015. task
tppdm625 .cequtppdm640 .cicotppdm615 .task
EquipmentSundry CostLabor
MaxUnitsdepends on resource type101
IsCostResource000
StandardRatecalculation *tppdm625 .ratctppdm640 .prictppdm615 .ratc
tppdm025 .ratctppdm040 .prictppdm015 .ratc
Cost RateUnit CostCost Rate
tppdm025 .cccrtppdm040 .prictppdm615 .ratc
Unit CostCost Rate
XML Task ElementsMapping ruleEquipmentSundryLabor
StandardRate Formatdepends on resource type882
NT Account
EmailAddress
Text1LN Primary KeyLN Primary KeyLN Primary Key

 

XML Task ElementsMapping ruleTrade GroupEmployee
(internal) resource typetimetime
NameTRGEMP
tppdm016 .ctrgtccom001 .nama
Trade GroupName
Typedepends on resource type11
CalendarUIDtppdm016 .ccaltppdm016 .ccal
Calendar CodeCalendar Code
avail type uiavail type ui
CreationDateutc.num()utc.num()
MaterialLabeldepends on resource type
Codetppdm016 .ctrgtppdm801 .emno
Trade GroupEmployee
MaxUnitsdepends on resource type11
IsCostResource00
StandardRatecalculation *tppdm016 .clrttccom001 .clrt
Labor RateLabor Rate
StandardRate Formatdepends on resource type22
NT Accounttccom001.loco
Logon Code
EmailAddressbpmdm001.mail
E-Mail
Text1LN Primary KeyLN Primary Key