| CUSTNMBR |
char(15)
''
|
Customer c...(more) Join Now
|
|
|
join ... more text available
|
| PACONTNUMBER |
char(11)
''
|
PA Contrac...(more) Join Now
|
|
|
|
| PAcontid |
char(15)
''
|
The ID for...(more) Join Now
|
|
|
|
| PAprojid |
char(15)
''
|
Project ID...(more) Join Now
|
|
|
|
| PAprojname |
char(31)
''
|
Project Na...(more) Join Now
|
|
|
|
| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
|
| PAprjclsid |
char(15)
''
|
Project Cl...(more) Join Now
|
|
|
|
| PAProjectType |
smallint
0
|
Project ty...(more) Join Now
|
|
|
|
| PAAcctgMethod |
smallint
0
|
Useful in ...(more) Join Now
|
|
|
|
| PASTAT |
smallint
0
|
Contains t...(more) Join Now
|
|
|
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| PApurordnum |
char(17)
''
|
The purcha...(more) Join Now
|
|
|
|
| PABBeginDate |
datetime
'1/1/1900'
|
The beginn...(more) Join Now
|
|
|
|
| PABEndDate |
datetime
'1/1/1900'
|
The beginn...(more) Join Now
|
|
|
|
| PABQuantity |
numeric(19,5)
0.00
|
Contains t...(more) Join Now
|
|
|
|
| PABTotalCost |
numeric(19,5)
0.00
|
Total cost...(more) Join Now
|
|
|
|
| PABProfit |
numeric(19,5)
0.00
|
Baseline p...(more) Join Now
|
|
|
|
| PABBillings |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
|
|
|
| PABTaxPaidAmt |
numeric(19,5)
0.00
|
The sum of...(more) Join Now
|
|
|
|
| PABTaxChargedAmt |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
|
|
|
| PABaselineOvhdCost |
numeric(19,5)
0.00
|
PA Baselin...(more) Join Now
|
|
|
|
| PAACTUALBEGDATE |
datetime
'1/1/1900'
|
The beginn...(more) Join Now
|
|
|
|
| PA_Actual_End_Date |
datetime
'1/1/1900'
|
The beginn...(more) Join Now
|
|
|
|
| PAFBeginDate |
datetime
'1/1/1900'
|
The beginn...(more) Join Now
|
|
|
|
| PAFEndDate |
datetime
'1/1/1900'
|
The beginn...(more) Join Now
|
|
|
|
| PAFQuantity |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFTotalCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFProfit |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFBillings |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFTaxPaidAmt |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAFTaxChargedAmt |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAForecastOvhdCost |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAcloseProjcosts |
tinyint
0
|
Allow or d...(more) Join Now
|
|
|
|
| PAclosetobillings |
tinyint
0
|
Allow or d...(more) Join Now
|
|
|
|
| PADepartment |
char(7)
''
|
Department...(more) Join Now
|
|
|
|
| PAEstimatorID |
char(15)
''
|
Estimator ...(more) Join Now
|
|
|
|
| PAprojmngrid |
char(15)
''
|
Project Ma...(more) Join Now
|
|
|
|
| PABusMgrID |
char(15)
''
|
The busine...(more) Join Now
|
|
|
|
| LOCATNID |
char(15)
''
|
The locati...(more) Join Now
|
|
|
join ... more text available
|
| SLPRSNID |
char(15)
''
|
Used only ...(more) Join Now
|
|
|
join ... more text available
|
| SALSTERR |
char(15)
''
|
Defaults w...(more) Join Now
|
|
|
join ... more text available
|
| COMPRCNT |
smallint
0
|
The Commis...(more) Join Now
|
|
|
|
| COMAPPTO |
smallint
0
|
The method...(more) Join Now
|
|
|
|
| CNTCPRSN |
char(61)
''
|
Contact pe...(more) Join Now
|
|
|
|
| PRBTADCD |
char(15)
''
|
The addres...(more) Join Now
|
|
|
join ... more text available
|
| PALabor_Rate_Table_ID |
char(31)
''
|
PA Labor R...(more) Join Now
|
PA01301.PALabor_Rate_Table_ID
|
|
|
| PALabor_RateTable_Type |
smallint
0
|
PA Labor R...(more) Join Now
|
PA01301.PALabor_RateTable_Type
|
|
|
| PALabor_Rate_Table_Acc |
tinyint
0
|
PA Labor R...(more) Join Now
|
PA01301.PALabor_Rate_Table_Acc
|
|
|
| PAEquip_Rate_Table_ID |
char(31)
''
|
PA Equip R...(more) Join Now
|
PA01301.PAEquip_Rate_Table_ID
|
|
|
| PAEquip_Rate_Table_Acc |
tinyint
0
|
PA Equip R...(more) Join Now
|
PA01301.PAEquip_Rate_Table_Acc
|
|
|
| PAbllngtype |
smallint
0
|
1=Billable...(more) Join Now
|
|
|
|
| PAService_Fee_Amount |
numeric(19,5)
0.00
|
PA Service...(more) Join Now
|
|
|
|
| PAProject_Fee_Amount |
numeric(19,5)
0.00
|
PA Project...(more) Join Now
|
|
|
|
| PARetainer_Fee_Amount |
numeric(19,5)
0.00
|
PA Project...(more) Join Now
|
|
|
|
| PARetentionFeeAmount |
numeric(19,5)
0.00
|
PA Retenti...(more) Join Now
|
|
|
|
| PAProject_Amount |
numeric(19,5)
0.00
|
PA Project...(more) Join Now
|
|
|
|
| ACCTAMNT |
numeric(19,5)
0.00
|
Account Am...(more) Join Now
|
|
|
|
| PABILLFORMAT |
char(15)
''
|
The defaul...(more) Join Now
|
|
|
|
| DSCPCTAM |
smallint
0
|
Discount P...(more) Join Now
|
|
|
|
| PA_Retention_Percent |
numeric(19,5)
0.00
|
PA Retenti...(more) Join Now
|
|
|
|
| PAtotcbts |
tinyint
0
|
PA Label C...(more) Join Now
|
|
|
|
| PAtotcbEL |
tinyint
0
|
PA Label C...(more) Join Now
|
|
|
|
| PAtotcbML |
tinyint
0
|
PA Label C...(more) Join Now
|
|
|
|
| PAtotcbvi |
tinyint
0
|
PA Label C...(more) Join Now
|
|
|
|
| PAtotcber |
tinyint
0
|
PA Label C...(more) Join Now
|
|
|
|
| PAtotcbinv |
tinyint
0
|
PA Label C...(more) Join Now
|
|
|
|
| PAtotcbfee |
tinyint
0
|
PA Label C...(more) Join Now
|
|
|
|
| PAUD1Proj |
char(51)
''
|
User Defin...(more) Join Now
|
|
|
|
| PAUD2_Proj |
char(51)
''
|
User Defin...(more) Join Now
|
|
|
|
| PASegmentCB |
tinyint
0
|
Combine ea...(more) Join Now
|
|
|
|
| PAbillnoteidx |
numeric(19,5)
0.00
|
PA Billing...(more) Join Now
|
|
|
|
| PAbillnoteidxts |
numeric(19,5)
0.00
|
Default tr...(more) Join Now
|
|
|
|
| PAELbillniteidx |
numeric(19,5)
0.00
|
Default tr...(more) Join Now
|
|
|
|
| PAbillnoteidxML |
numeric(19,5)
0.00
|
Default tr...(more) Join Now
|
|
|
|
| PAbillnoteidxvi |
numeric(19,5)
0.00
|
Default tr...(more) Join Now
|
|
|
|
| PAbillnoteidxee |
numeric(19,5)
0.00
|
Default tr...(more) Join Now
|
|
|
|
| PAbillnoteidxinv |
numeric(19,5)
0.00
|
Stores the...(more) Join Now
|
|
|
|
| PAbillnoteidxfee |
numeric(19,5)
0.00
|
Stores the...(more) Join Now
|
|
|
|
| PAUnpostedQty |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostedTotalCostN |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnposted_Overhead |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostedProfitN |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnposted_Tax_Amount |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostAccrRevN |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostedRecogRevN |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostedCommitedQty |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostedCommitedCost |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnpostedCommitedTaxAmt |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnposted_Project_Fee |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnposted_Retainer_Fee |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnposted_Service_Fee |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUNPOSTRETAMT |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUNPOSTBIEEAMOUNT |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUNPEIEBAMOUNT |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PA_Unposted_Billed_Reten |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAPostedQty |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostedTotalCostN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostedProfitN |
numeric(19,5)
0.00
|
PA Actual Profit PA Actual profit is computed as:
PA Actual Profit = PA Actual Billings – PA Actual Total Cost
|
|
|
|
| PAPosted_Tax_Amount |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Accr_RevN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostRecogRevN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostedCommitedQty |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostedCommitedCost |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPostedCommitedTaxAmt |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Project_Fee |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Retainer_Fee |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPosted_Service_Fee |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPOSTRETAMT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPOSBIEEAMOUNT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAPOSEIEBAMOUNT |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PA_Actual_Billed_Retenti |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAWrite_UpDown_Amount |
numeric(19,5)
0.00
|
PA Write U...(more) Join Now
|
|
|
|
| PABilled_QtyN |
numeric(19,5)
0.00
|
PA Billed ...(more) Join Now
|
|
|
|
| PABilled_Cost |
numeric(19,5)
0.00
|
PA Billed Cost The total billed cost for the contract. Currency storage type, keyable length: 17, storage size: 10.
|
|
|
|
| PABilled_Accrued_Revenu |
numeric(19,5)
0.00
|
PA Billed ...(more) Join Now
|
|
|
|
| PACostPcntCompleted |
numeric(19,5)
0.00
|
PA Cost Pe...(more) Join Now
|
|
|
|
| PAQuantityPcntCompleted |
numeric(19,5)
0.00
|
PA Quantit...(more) Join Now
|
|
|
|
| PA_Receipts_Amount |
numeric(19,5)
0.00
|
PA Receipt...(more) Join Now
|
|
|
|
| PA_Actual_Receipts_Amoun |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PA_Earnings |
numeric(19,5)
0.00
|
PA Earning...(more) Join Now
|
|
|
|
| PA_Cost_of_Earnings |
numeric(19,5)
0.00
|
table styl...(more) Join Now
|
|
|
|
| PAUnpostBillN |
numeric(19,5)
0.00
|
PA Unposted Billings The sum of all unposted billings for the contract. Currency storage type, keyable length: 17, storage size: 10.
|
|
|
|
| PAUnpostDiscDolAmtN |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAUnposted_Sales_Tax_Am |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAPostedBillingsN |
numeric(19,5)
0.00
|
Posted Bil...(more) Join Now
|
|
|
|
| PAPostedDiscDolAmtN |
numeric(19,5)
0.00
|
|
|
|
|
| PAPosted_Sales_Tax_Amou |
numeric(19,5)
0.00
|
|
|
|
|
| PABCWPAMT |
numeric(19,5)
0.00
|
PA BCWP Am...(more) Join Now
|
|
|
|
| PABCWSAMT |
numeric(19,5)
0.00
|
PA BCWS Amount Currency storage type, keyable length: 17, storage size: 10.
|
|
|
|
| PAACWPAMT |
numeric(19,5)
0.00
|
PA ACWP Am...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| PAPosted_Overhead |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAApproved_Accrued_Reve |
numeric(19,5)
0.00
|
PA Approve...(more) Join Now
|
|
|
|
| PAApproved_Cost |
numeric(19,5)
0.00
|
PA Approve...(more) Join Now
|
|
|
|
| PAApproved_Quantity |
numeric(19,5)
0.00
|
PA Approve...(more) Join Now
|
|
|
|
| WROFAMNT |
numeric(19,5)
0.00
|
Write Off ...(more) Join Now
|
|
|
|
| ActualWriteOffAmount |
numeric(19,5)
0.00
|
Actual Wri...(more) Join Now
|
|
|
|
| DISTKNAM |
numeric(19,5)
0.00
|
Discount T...(more) Join Now
|
|
|
|
| ActualDiscTakenAmount |
numeric(19,5)
0.00
|
Actual Dis...(more) Join Now
|
|
|
|
| PACommitted_Costs |
numeric(19,5)
0.00
|
PA Committ...(more) Join Now
|
|
|
|
| PACommitted_Qty |
numeric(19,5)
0.00
|
PA Committ...(more) Join Now
|
|
|
|
| PAPOCost |
numeric(19,5)
0.00
|
PA PO Cost...(more) Join Now
|
|
|
|
| PAPOQty |
numeric(19,5)
0.00
|
PA PO Qty ...(more) Join Now
|
|
|
|
| PAPOPostedCost |
numeric(19,5)
0.00
|
PA PO Actu...(more) Join Now
|
|
|
|
| PAPOPostedQty |
numeric(19,5)
0.00
|
PA PO Actu...(more) Join Now
|
|
|
|
| PAtaxpaidamt |
numeric(19,5)
0.00
|
PA Tax Pai...(more) Join Now
|
|
|
|
| PAPostedTaxPaidN |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PApretainage |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAunpretainage |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PA_Write_Off_Tax_Amount |
numeric(19,5)
0.00
|
PA Write O...(more) Join Now
|
|
|
|
| PAActualWOTaxAmt |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PA_Terms_Taken_Tax_Amt |
numeric(19,5)
0.00
|
PA Terms T...(more) Join Now
|
|
|
|
| PAActualTermsTakenTax |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| WRKRCOMP |
char(7)
''
|
Workers Co...(more) Join Now
|
JC00701.WRKRCOMP
|
|
|
| SUTASTAT |
char(3)
''
|
Suta State...(more) Join Now
|
UPR00401.SUTASTAT
|
|
|
| PA_Actual_Billing_not_RM |
numeric(19,5)
0.00
|
|
|
|
|
| PA_ActualDiscnotRM |
numeric(19,5)
0.00
|
|
|
|
|
| PA_RestrictCustomerList |
tinyint
0
|
PA Restric...(more) Join Now
|
|
|
|
| PAPosted_Earnings |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAActualCostofEarnings |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAUnpostedLossAmount |
numeric(19,5)
0.00
|
PA Unposte...(more) Join Now
|
|
|
|
| PAActualLossAmount |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAFQLaborOnly |
numeric(19,5)
0.00
|
PA Forecas...(more) Join Now
|
|
|
|
| PAAQLaborOnly |
numeric(19,5)
0.00
|
PA Actual ...(more) Join Now
|
|
|
|
| PAMCCURNCYID |
char(15)
''
|
PA MC Curr...(more) Join Now
|
|
|
|
| PAMCProjectAmount |
numeric(19,5)
0.00
|
PA MC Proj...(more) Join Now
|
|
|
|
| PAMCUnpostBillN |
numeric(19,5)
0.00
|
PA MC Unpo...(more) Join Now
|
|
|
|
| PAMCUnpostedSalesTax |
numeric(19,5)
0.00
|
PA MC Unpo...(more) Join Now
|
|
|
|
| PAMCUnpostedDiscount |
numeric(19,5)
0.00
|
PA MC Unpo...(more) Join Now
|
|
|
|
| PAMCActualBillings |
numeric(19,5)
0.00
|
PA MC Actu...(more) Join Now
|
|
|
|
| PAMCActualSalesTaxAmt |
numeric(19,5)
0.00
|
PA MC Actu...(more) Join Now
|
|
|
|
| PAMCActualDiscountAmt |
numeric(19,5)
0.00
|
PA MC Actu...(more) Join Now
|
|
|
|
| PAMCBBillings |
numeric(19,5)
0.00
|
PA MC Base...(more) Join Now
|
|
|
|
| PAMCFBillings |
numeric(19,5)
0.00
|
PA MC Fore...(more) Join Now
|
|
|
|
| PA_MC_Project_Fee_Amount |
numeric(19,5)
0.00
|
PA MC Proj...(more) Join Now
|
|
|
|
| PA_MC_Service_Fee_Amount |
numeric(19,5)
0.00
|
PA MC Serv...(more) Join Now
|
|
|
|
| PA_MC_Retainer_Fee_Amt |
numeric(19,5)
0.00
|
PA MC Reta...(more) Join Now
|
|
|
|
| PA_MC_UnpostedProjectFee |
numeric(19,5)
0.00
|
PA MC Unpo...(more) Join Now
|
|
|
|
| PA_MC_Unposted_Retainer |
numeric(19,5)
0.00
|
PA MC Unpo...(more) Join Now
|
|
|
|
| PA_MC_UnpostedServiceFee |
numeric(19,5)
0.00
|
Contains t...(more) Join Now
|
|
|
|
| PA_MC_Actual_Project_Fee |
numeric(19,5)
0.00
|
PA MC Actu...(more) Join Now
|
|
|
|
| PA_MC_Actual_RetainerFee |
numeric(19,5)
0.00
|
PA MC Actu...(more) Join Now
|
|
|
|
| PA_MC_Actual_Service_Fee |
numeric(19,5)
0.00
|
PA MC Actu...(more) Join Now
|
|
|
|
| PANOTIFBILL |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|