PAPROJNUMBER | char(15) | No | PA Project Number | IN |
PACOSTCATID | char(15) | No | PA Cost Category ID | IN |
PASTAT | smallint | No | PA Status 1=Open,2=On Hold, 3=Closed,4=Estimate,5=Completed | IN |
PAProfitType | smallint | No | PA Profit Type | IN |
PAbllngtype | smallint | No | PA Billing Type | IN |
PABBeginDate | datetime | No | PA Begin Date | IN |
PABEndDate | datetime | No | PA End Date | IN |
LNITMSEQ | int | No | Line Item Sequence | IN |
PALineItemSeq | int | No | PA Line Item Sequence | IN |
PABQuantity | numeric(19,5) | No | PA Baseline Quantity | IN |
PABUnitCost | numeric(19,5) | No | PA Baseline Cost | IN |
PABProfitAmt | numeric(19,5) | No | PA Baseline Profit Amount | IN |
PABProfitPcnt | numeric(19,5) | No | PA Baseline Profit Percent | IN |
PABTotalCost | numeric(19,5) | No | PA Baseline Total Cost | IN |
PABaselineOvhdAmtPerUnit | numeric(19,5) | No | PA Baseline Overhead Amount per Unit | IN |
PABaselineOvrhdPct | numeric(19,5) | No | PA Baseline Overhead Percent | IN |
PABaselinePTaxOptions | smallint | No | PA Baseline Purchase Tax Options | IN |
PABaselineCTaxSchedID | char(15) | No | PA Baseline Cost Tax Schedule ID | IN |
PABaselineSTaxOptions | smallint | No | PA Baseline Sales Tax Options | IN |
PABaselineBTaxSchedID | char(15) | No | PA Baseline Billings Tax Schedule ID | IN |
PAFQuantity | numeric(19,5) | No | PA Forecast Quantity | IN |
PAFUnitCost | numeric(19,5) | No | PA Forecast Cost | IN |
PAFTotalCost | numeric(19,5) | No | PA Forecast Profit Amount | IN |
PAFProfitAmt | numeric(19,5) | No | PA Forecast Profit Amount | IN |
PAFProfitPcnt | numeric(19,5) | No | PA Forecast Profit Percent | IN |
PAForecastOvrhdAmtPerUnt | numeric(19,5) | No | PA Forecast Overhead Amount per Unit | IN |
PAForecastOvrhdPct | numeric(19,5) | No | PA Forecast Overhead Percent | IN |
PAForecastPTaxOptions | smallint | No | PA Forecast Purchase Tax Options | IN |
PAForecastCTaxSchedID | char(15) | No | PA Forecast Cost Tax Schedule ID | IN |
PAForecastSTaxOptions | smallint | No | PA Forecast Sales Tax Options | IN |
PAForecastBTaxSchedID | char(15) | No | PA Forecast Billings Tax Schedule ID | IN |
PAFBeginDate | datetime | No | PA Forecast Begin Date | IN |
PAFEndDate | datetime | No | PA Forecast End Date | IN |
PAUnit_of_Measure | char(9) | No | PA Unit of Measure | IN |
UOMSCHDL | char(11) | No | Unit of Measure Schedule | IN |
PAPay_Code_Hourly | char(7) | No | PA Pay Code Hourly | IN |
PAPay_Code_Salary | char(7) | No | PA Pay Code Salarly | IN |
UpdateExisting | tinyint | No | Used to update existing transaction - 0=New Transaction; 1=Update Existing | IN |
RollUpEst_to_Forecast | tinyint | No | Flag that determines whether or not changes made in Estimate status rollup to Forecast values | 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 |