| PABILLTRXT |
smallint
0
|
|
|
|
|
| PADocnumber20 |
char(17)
''
|
|
|
|
|
| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| CUTOFDAT |
datetime
'1/1/1900'
|
|
|
|
|
| PACOSTCATID |
char(15)
''
|
PA Cost Ca...(more) Join Now
|
|
|
|
| PATU |
smallint
0
|
PA Transac...(more) Join Now
|
|
|
|
| PAAcctgMethod |
smallint
0
|
Useful in ...(more) Join Now
|
|
|
|
| PATOTCST |
numeric(19,5)
0.00
|
|
|
|
|
| PATQTY |
numeric(19,5)
0.00
|
|
|
|
|
| PAPercentCompleted |
numeric(19,5)
0.00
|
|
|
|
|
| PAFFbillamount |
numeric(19,5)
0.00
|
|
|
|
|
| PAbillnoteidx |
numeric(19,5)
0.00
|
PA Billing...(more) Join Now
|
|
|
|
| PAbilltaxscheduleid |
char(15)
''
|
PA Billing...(more) Join Now
|
|
|
|
| PAFFtaxamt |
numeric(19,5)
0.00
|
|
|
|
|
| PACostPcntCompleted |
numeric(19,5)
0.00
|
PA Cost Pe...(more) Join Now
|
|
|
|
| PAQuantityPcntCompleted |
numeric(19,5)
0.00
|
PA Quantit...(more) Join Now
|
|
|
|
| PAObservedPcntCompleted |
numeric(19,5)
0.00
|
|
|
|
|
| PAPreviously_Billed |
numeric(19,5)
0.00
|
|
|
|
|
| PAAmount_Earned |
numeric(19,5)
0.00
|
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
|
|
|
| PABACKBILL |
numeric(19,5)
0.00
|
|
|
|
|
| PAAR_IDX |
int
0
|
From the R...(more) Join Now
|
|
|
|
| PABillRevAcctIdx |
int
0
|
|
|
|
|
| PABPSE |
binary(4)
0
|
|
|
|
|
| PARetentionFeeAmount |
numeric(19,5)
0.00
|
PA Retenti...(more) Join Now
|
|
|
|
| PA_Trade_Discount_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Retention_IDX |
int
0
|
|
|
|
|
| PAORIGTOTCOST |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigBillingAmtFF |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigTaxAmtFF |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigPrevBill |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigAmtEarned |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigBackoutBillAmt |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigRetentionFeeAmt |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigTradeDiscAmt |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Previous_Retention |
numeric(19,5)
0.00
|
|
|
|
|
| PAOPREVRETENTION |
numeric(19,5)
0.00
|
|
|
|
|
| PACHGORDNO |
char(17)
''
|
PA Change ...(more) Join Now
|
|
|
|
| PA_Backout_Retention_Amt |
numeric(19,5)
0.00
|
|
|
|
|
| PA_OrigBackRetentionAmt |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|