| CMPANYID |
smallint
|
Company ID...(more) Join Now
|
WPPU0114.CMPANYID
|
|
join ... more text available
|
| USERID |
char
|
The user t...(more) Join Now
|
|
|
join ... more text available
|
| LNITMSEQ |
int
|
Line Item ...(more) Join Now
|
PA11801.LNITMSEQ
|
|
|
| PAAcctgMethod |
smallint
|
1=WHEN PER...(more) Join Now
|
PA01101.PAAcctgMethod
|
|
|
| PAACREV |
numeric
|
|
|
|
|
| PAAmount_Earned |
numeric
|
|
|
|
|
| PAApproved_Billing_Amou |
numeric
|
|
|
|
|
| PAAPPROVBILLRATE |
numeric
|
|
|
|
|
| PAAPPROVMKUPPCT |
numeric
|
|
|
|
|
| PAApproved_Quantity |
numeric
|
PA Approve...(more) Join Now
|
PA11801.PAApproved_Quantity
|
|
|
| PAAR_IDX |
int
|
From the R...(more) Join Now
|
PA13203.PAAR_IDX
|
|
|
| PABACKBILL |
numeric
|
|
|
|
|
| PABPSE |
binary
|
|
|
|
|
| PABillSublineErrors |
binary
|
|
|
|
|
| PABILLTRXT |
smallint
|
|
|
|
|
| PAFeebillamount |
numeric
|
|
|
|
|
| PAFFbillamount |
numeric
|
|
|
|
|
| PABillingDTLLineItemSeq |
int
|
|
|
|
|
| PAbillnoteidx |
numeric
|
PA Billing...(more) Join Now
|
PA01101.PAbillnoteidx
|
|
|
| PABILRATE |
numeric
|
|
|
|
|
| PAbilltaxscheduleid |
char
|
PA Billing...(more) Join Now
|
PA23201.PAbilltaxscheduleid
|
|
|
| PAbllngtype |
smallint
|
PA Billing...(more) Join Now
|
PA11801.PAbllngtype
|
|
|
| PABillRevAcctIdx |
int
|
|
|
|
|
| PACHGORDNO |
char
|
PA Change ...(more) Join Now
|
PA05200.PACHGORDNO
|
|
|
| PACogs_Idx |
int
|
ACTIDX of ...(more) Join Now
|
PA30101.PACogs_Idx
|
|
|
| PACONTNUMBER |
char
|
PA Contrac...(more) Join Now
|
PA01101.PACONTNUMBER
|
|
|
| PACOSTCATCLASNME |
char
|
|
|
|
|
| PACOSTCATID |
char
|
PA Cost Ca...(more) Join Now
|
PA11801.PACOSTCATID
|
|
|
| PACOSTCATNME |
char
|
|
|
|
|
| PACOSTDATE |
datetime
|
|
|
|
|
| PACOSTDOCNO |
char
|
|
|
|
|
| PACOSTOWNER |
char
|
|
|
|
|
| PA_Cost_Owner_Class_Name |
char
|
|
|
|
|
| PACost_Owner_Name |
char
|
|
|
|
|
| PACostPcntCompleted |
numeric
|
PA Cost Pe...(more) Join Now
|
PA01101.PACostPcntCompleted
|
|
|
| PACOSTSEQNO |
int
|
|
|
|
|
| PADocnumber20 |
char
|
|
|
|
|
| PAFeeID |
char
|
PA Fee ID ...(more) Join Now
|
PA05200.PAFeeID
|
|
|
| PAFeeName |
char
|
The descri...(more) Join Now
|
PA02101.PAFeeName
|
|
|
| PAFeeType |
smallint
|
In additio...(more) Join Now
|
PA02101.PAFeeType
|
|
|
| PAJob_Title |
char
|
|
|
|
|
| PAJobTitleDescription |
char
|
|
|
|
|
| PAMARKPERCENT |
numeric
|
|
|
|
|
| PAObservedPcntCompleted |
numeric
|
|
|
|
|
| PAORIACCRREV |
numeric
|
|
|
|
|
| PAOrigAmtEarned |
numeric
|
|
|
|
|
| PAOrigApprBillAmt |
numeric
|
|
|
|
|
| PAOrigApprBillRate |
numeric
|
|
|
|
|
| PAOrigBackoutBillAmt |
numeric
|
|
|
|
|
| PAOrigBillingAmtFee |
numeric
|
|
|
|
|
| PAOrigBillingAmtFF |
numeric
|
|
|
|
|
| PAORIGBILLRATE |
numeric
|
|
|
|
|
| PAOrigPrevBill |
numeric
|
|
|
|
|
| PAOPREVRETENTION |
numeric
|
|
|
|
|
| PAOrigRecogRevenue |
numeric
|
|
|
|
|
| PAOrigRetentionFeeAmt |
numeric
|
|
|
|
|
| PAOrigTaxAmtFee |
numeric
|
|
|
|
|
| PAOrigTaxAmtFF |
numeric
|
|
|
|
|
| PAOrigTaxAmtTM_ |
numeric
|
|
|
|
|
| PAORIGTOTCOST |
numeric
|
|
|
|
|
| PAORIGTOTOVRHD |
numeric
|
|
|
|
|
| PAOrigTradeDiscAmt |
numeric
|
|
|
|
|
| PAOrigUnitCost |
numeric
|
|
|
|
|
| PAOrigWUDAmt |
numeric
|
|
|
|
|
| PAPercentCompleted |
numeric
|
|
|
|
|
| PA_Previous_Retention |
numeric
|
|
|
|
|
| PAPreviously_Billed |
numeric
|
|
|
|
|
| PAProfitType |
smallint
|
PA Profit ...(more) Join Now
|
PA11801.PAProfitType
|
|
|
| PAPROJNUMBER |
char
|
PA Project...(more) Join Now
|
PA11801.PAPROJNUMBER
|
|
join ... more text available
|
| PAQtyQ |
numeric
|
|
|
|
|
| PAQuantityPcntCompleted |
numeric
|
PA Quantit...(more) Join Now
|
PA01101.PAQuantityPcntCompleted
|
|
|
| PARecognizedRevenue |
numeric
|
|
|
|
|
| PArecordid |
char
|
|
|
|
|
| PAREFNO |
char
|
|
|
|
|
| PAReference_Line_Seq_N |
int
|
|
|
|
|
| PARetentionFeeAmount |
numeric
|
PA Retenti...(more) Join Now
|
PA01101.PARetentionFeeAmount
|
|
|
| PARev_IDX |
int
|
|
|
|
|
| PAsfid |
smallint
|
|
|
|
|
| PASSN |
int
|
|
|
|
|
| PAFeetaxamount |
numeric
|
|
|
|
|
| PAFFtaxamt |
numeric
|
|
|
|
|
| PATMtaxamt |
numeric
|
|
|
|
|
| PATOTCST |
numeric
|
|
|
|
|
| PATOTALOVERH |
numeric
|
|
|
|
|
| PATQTY |
numeric
|
|
|
|
|
| PA_Trade_Discount_Amount |
numeric
|
|
|
|
|
| PATU |
smallint
|
PA Transac...(more) Join Now
|
PA11801.PATU
|
|
|
| PAUnbilled_AR_Idx |
int
|
|
|
|
|
| PAUnbilled_Proj_Rev_Idx |
int
|
|
|
|
|
| PAUNITCOST |
numeric
|
PA Unit Co...(more) Join Now
|
PA11801.PAUNITCOST
|
|
|
| PAUnit_of_Measure |
char
|
PA Unit of...(more) Join Now
|
PA11801.PAUnit_of_Measure
|
|
|
| PAUD1 |
char
|
PA User De...(more) Join Now
|
PA11801.PAUD1
|
|
|
| PAUD2 |
char
|
PA User De...(more) Join Now
|
PA11801.PAUD2
|
|
|
| PACGBWIPIDX |
int
|
ACTIDX of ...(more) Join Now
|
PA30101.PACGBWIPIDX
|
|
|
| PAWrite_UpDown_Amount |
numeric
|
PA Write U...(more) Join Now
|
PA11801.PAWrite_UpDown_Amount
|
|
|
| PAWrite_UpDown_Percenta |
int
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|