CUSTNMBR | char(15) | No | Customer Number | IN |
PACONTNUMBER | char(11) | No | PA Contract Number | IN |
PAprojid | char(15) | No | PA Project ID | IN |
PAprojname | char(31) | No | PA Project Name | IN |
PAPROJNUMBER | char(15) | No | PA Project Number | IN |
PAProjectType | smallint | No | PA Project Type 1=Time and Materials,2=Cost Plus and 3=Fixed Price | IN |
PAAcctgMethod | smallint | No | PA Accounting Method 1=When Performed,2=When Billed, 3=Cost to Cost, | IN |
PASTAT | smallint | No | PA Status 1=Open,2=On Hold, 3=Closed,4=Estimate,5=Completed | IN |
PABBeginDate | datetime | No | PA Baseline Begin Date | IN |
PABEndDate | datetime | No | PA Baseline End Date | IN |
PAprjclsid | char(15) | No | PA Project Class ID | IN |
PApurordnum | char(17) | No | PA Purchase Order Number | IN |
PAcloseProjcosts | smallint | No | PA Close to Project Costs | IN |
PAclosetobillings | smallint | No | PA Close to Billings | IN |
PADepartment | char(7) | No | PA Department | IN |
PAEstimatorID | char(15) | No | PA Estimator ID | IN |
PAprojmngrid | char(15) | No | PA Project Manager ID | IN |
PABusMgrID | char(15) | No | PA Business Manager ID | IN |
PALabor_Rate_Table_ID | char(31) | No | PA Labor Rate Table ID | IN |
PALabor_RateTable_Type | smallint | No | PA Labor Rate Table Type | IN |
PALabor_Rate_Table_Acc | smallint | No | PA Labor Rate Table Accept Replacements | IN |
PAEquip_Rate_Table_ID | char(31) | No | PA Equipment Rate Table ID | IN |
PAEquip_Rate_Table_Acc | smallint | No | PA Equipment Rate Table Accept Replacements | IN |
PAbllngtype | smallint | No | PA Billing Type 1=STD, 2=N/C or 3=N/B | IN |
PABILLFORMAT | char(15) | No | PA Billing Format | IN |
DSCPCTAM | smallint | No | Discount Percent Amount | IN |
PA_Retention_Percent | numeric(19,5) | No | PA Retention Percent | IN |
PAUD1Proj | char(51) | No | PA User Defined 1 | IN |
PAUD2_Proj | char(51) | No | PA User Defined 2 | IN |
PASegmentCB | smallint | No | PA Segment Checkbox | IN |
PRBTADCD | char(15) | No | Primary Bill to Address Code | IN |
PAbillnoteDefault | char(1000) | No | PA Billing note - Default Billing Note | IN |
PAbillnoteTS | char(1000) | No | PA Billing note - Timesheets | IN |
PAbillnoteEL | char(1000) | No | PA Billing note - Equipment Logs | IN |
PAbillnoteML | char(1000) | No | PA Billing note - Miscellaneous Logs | IN |
PAbillnoteVI | char(1000) | No | PA Billing note - VI | IN |
PAbillnoteEE | char(1000) | No | PA Billing note - Employee Expense | IN |
PAbillnoteINV | char(1000) | No | PA Billing note - Inventory | IN |
PAbillnoteFEE | char(1000) | No | PA Billing note - Fee | IN |
PABILLCYCLEID1 | char(15) | No | PA Billing Cycle ID | IN |
PA_RestrictCustomerList | smallint | No | PA Restrict Customer List | IN |
WRKRCOMP | char(7) | No | Workers Comp ID | IN |
SUTASTAT | char(3) | No | SUTA State ID | IN |
PATRKCHGORDS | smallint | No | PA Track Change Orders | IN |
PATRKCOBDGADDFLY | smallint | No | PA Track Change Orders for new Budget add on fly | IN |
UpdateExisting | tinyint | No | Used to update existing transaction - 0=New Transaction; 1=Update Existing | IN |
RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true than populates Requester shadow table | IN |
USRDEFND1 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND2 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND3 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND4 | varchar(8000) | No | User Defined field - developer use only | IN |
USRDEFND5 | varchar(8000) | No | User Defined field - developer use only | IN |
ErrorState | int | No | Error Code | INOUT |
oErrString | varchar(255) | No | Comma separated list of errors encountered | INOUT |