<PAProjectsType>
<taPAProjects>
<CUSTNMBR> </CUSTNMBR><!-- (REQUIRED) string(15) Customer number-->
<PACONTNUMBER> </PACONTNUMBER><!-- (REQUIRED) string(11) PA contract number-->
<PAprojid> </PAprojid><!-- (REQUIRED) string(15) PA project ID-->
<PAprojname> </PAprojname><!-- (REQUIRED) string(31) PA project name-->
<PAPROJNUMBER> </PAPROJNUMBER><!-- (REQUIRED) string(15) PA project number-->
<PAProjectType> </PAProjectType><!-- i4 PA project type:-->
<!-- 1=Time and materials;-->
<!-- 2=Cost plus;-->
<!-- 3=Fixed price-->
<PAAcctgMethod> </PAAcctgMethod><!-- i4 PA account method:-->
<!-- 1=When performed;-->
<!-- 2=When billed;-->
<!-- 3=Cost to cost;-->
<!-- 4=Effort expended;-->
<!-- 5=Completed;-->
<!-- 6=Effort expended labor only-->
<PASTAT> </PASTAT><!-- i4 PA status:-->
<!-- 1=Open;-->
<!-- 2=On hold;-->
<!-- 3=Closed;-->
<!-- 4=Estimate;-->
<!-- 5=Completed-->
<PABBeginDate> </PABBeginDate><!-- datetime PA baseline begin date-->
<PABEndDate> </PABEndDate><!-- datetime PA baseline end date-->
<PAprjclsid> </PAprjclsid><!-- string(15) PA project class ID-->
<PApurordnum> </PApurordnum><!-- string(17) PA purchase order number-->
<PAcloseProjcosts> </PAcloseProjcosts><!-- i4 PA close to project costs-->
<PAclosetobillings> </PAclosetobillings><!-- i4 PA close to billings-->
<PADepartment> </PADepartment><!-- string(7) PA department-->
<PAEstimatorID> </PAEstimatorID><!-- string(15) PA estimator ID-->
<PAprojmngrid> </PAprojmngrid><!-- string(15) PA project manager ID-->
<PABusMgrID> </PABusMgrID><!-- string(15) PA business manager ID-->
<PALabor_Rate_Table_ID> </PALabor_Rate_Table_ID><!-- string(31) PA labor rate table ID-->
<PALabor_RateTable_Type> </PALabor_RateTable_Type><!-- i4 PA labor rate table type-->
<PALabor_Rate_Table_Acc> </PALabor_Rate_Table_Acc><!-- i4 PA labor rate table accept replacements-->
<PAEquip_Rate_Table_ID> </PAEquip_Rate_Table_ID><!-- string(31) PA equipment rate table ID-->
<PAEquip_Rate_Table_Acc> </PAEquip_Rate_Table_Acc><!-- i4 PA equipment rate table accept replacements-->
<PAbllngtype> </PAbllngtype><!-- i4 PA billing type:-->
<!-- 1=Standard;-->
<!-- 2=No charge;-->
<!-- 3=No billing-->
<PABILLFORMAT> </PABILLFORMAT><!-- string(15) PA billing format-->
<DSCPCTAM> </DSCPCTAM><!-- i4 Discount percent amount-->
<PA_Retention_Percent> </PA_Retention_Percent><!-- number PA retention percent-->
<PAUD1Proj> </PAUD1Proj><!-- string(51) PA user defined 1-->
<PAUD2_Proj> </PAUD2_Proj><!-- string(51) PA user defined 2-->
<PASegmentCB> </PASegmentCB><!-- i4 PA segment check box-->
<PRBTADCD> </PRBTADCD><!-- string(15) Primary bill to address code-->
<PAbillnoteTS> </PAbillnoteTS><!-- string(1000) PA billing note—timesheets-->
<PAbillnoteEL> </PAbillnoteEL><!-- string(1000) PA billing note—equipment logs-->
<PAbillnoteML> </PAbillnoteML><!-- string(1000) PA billing note—miscellaneous logs-->
<PAbillnoteVI> </PAbillnoteVI><!-- string(1000) PA billing note—VI-->
<PAbillnoteEE> </PAbillnoteEE><!-- string(1000) PA billing note—employee expense-->
<PAbillnoteINV> </PAbillnoteINV><!-- string(1000) PA billing note—inventory-->
<PAbillnoteFEE> </PAbillnoteFEE><!-- string(1000) PA billing note—fee-->
<PABILLCYCLEID1> </PABILLCYCLEID1><!-- string(15) PA billing cycle ID-->
<PA_RestrictCustomerList> </PA_RestrictCustomerList><!-- i4 PA restrict customer list-->
<WRKRCOMP> </WRKRCOMP><!-- string(7) Workers' compensation ID-->
<SUTASTAT> </SUTASTAT><!-- string(3) SUTA state ID-->
<PATRKCHGORDS> </PATRKCHGORDS><!-- i4 PA track change orders-->
<PATRKCOBDGADDFLY> </PATRKCOBDGADDFLY><!-- i4 PA track change orders for new budget on the fly-->
<UpdateExisting> </UpdateExisting><!-- i4 Update functionality does not exist at this time; this will be used for future release-->
<RequesterTrx> </RequesterTrx><!-- i4 Requester transaction:-->
<!-- 0=False;-->
<!-- 1=True (if True, it populates requester shadow table)-->
<USRDEFND1> </USRDEFND1><!-- string User-defined field—developer use only-->
<USRDEFND2> </USRDEFND2><!-- string User-defined field—developer use only-->
<USRDEFND3> </USRDEFND3><!-- string User-defined field—developer use only-->
<USRDEFND4> </USRDEFND4><!-- string(8000) User-defined field—developer use only-->
<USRDEFND5> </USRDEFND5><!-- string(8000) User-defined field—developer use only-->
</taPAProjects>
</PAProjectsType>
Steve Gray, MCDBA
Technical Editor
steve@VSToolsForum.com