| PABILLTRXT |
smallint
0
|
|
|
|
|
| PADocnumber20 |
char(17)
''
|
|
|
|
|
| PADOCDT |
datetime
'1/1/1900'
|
|
|
|
|
| PAREFNO |
char(17)
''
|
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
|
|
|
| CUSTNMBR |
char(15)
''
|
Customer c...(more) Join Now
|
|
|
join ... more text available
|
| PACONTNUMBER |
char(11)
''
|
PA Contrac...(more) Join Now
|
|
|
|
| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PAProjectType |
smallint
0
|
Project ty...(more) Join Now
|
|
|
|
| PApurordnum |
char(17)
''
|
The purcha...(more) Join Now
|
|
|
|
| PABillingAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PATMbillamount |
numeric(19,5)
0.00
|
|
|
|
|
| PAFFbillamount |
numeric(19,5)
0.00
|
|
|
|
|
| PAFeebillamount |
numeric(19,5)
0.00
|
|
|
|
|
| PAtotbillings |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Discount_Type |
smallint
0
|
|
|
|
|
| TRDISAMT |
numeric(19,5)
0.00
|
Trade Disc...(more) Join Now
|
|
|
|
| PA_Trade_Discount_Pcnt |
smallint
0
|
|
|
|
|
| PATOTTAX |
numeric(19,5)
0.00
|
|
|
|
|
| PATMtaxamt |
numeric(19,5)
0.00
|
|
|
|
|
| PAFFtaxamt |
numeric(19,5)
0.00
|
|
|
|
|
| PAFeetaxamount |
numeric(19,5)
0.00
|
|
|
|
|
| PABACKBILL |
numeric(19,5)
0.00
|
|
|
|
|
| PATMbckoutbillamt |
numeric(19,5)
0.00
|
|
|
|
|
| PAPBbckoutbillamt |
numeric(19,5)
0.00
|
|
|
|
|
| PAFeebckoutbillamt |
numeric(19,5)
0.00
|
|
|
|
|
| APPLDAMT |
numeric(19,5)
0.00
|
|
|
|
|
| ACCTAMNT |
numeric(19,5)
0.00
|
Account Am...(more) Join Now
|
|
|
|
| PARetentionFeeAmount |
numeric(19,5)
0.00
|
PA Retenti...(more) Join Now
|
|
|
|
| PARetainer_Fee_Amount |
numeric(19,5)
0.00
|
PA Project...(more) Join Now
|
|
|
|
| PABill_Line_Errors |
binary(4)
0
|
|
|
|
|
| PA_Applied_Retainer |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Retainer_Applied |
tinyint
0
|
|
|
|
|
| PA_Applied_Freight_Misc |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Trade_IDX |
int
0
|
|
|
|
|
| TAXSCHID |
char(15)
''
|
|
|
|
join ... more text available
|
| PAOrigBillAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigBillingAmtTM |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigBillingAmtFF |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigBillingAmtFee |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigTotalBilings |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigTotalTaxAmt |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigTaxAmtTM_ |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigTaxAmtFF |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigTaxAmtFee |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigBackoutBillAmt |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigBackoutBillTM |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigBackoutBillFF |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigBackoutBillFee |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigRetentionFeeAmt |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigRetainerFeeAmt |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigAppliedDocAmt |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigAppliedFreightMisc |
numeric(19,5)
0.00
|
|
|
|
|
| ORTDISAM |
numeric(19,5)
0.00
|
Orig Trade...(more) Join Now
|
POP10300.ORTDISAM
|
|
|
| ORAPPAMT |
numeric(19,5)
0.00
|
|
|
|
|
| ORACTAMT |
numeric(19,5)
0.00
|
Orig Accou...(more) Join Now
|
SOP30200.ORACTAMT
|
|
|
| BCKTXAMT |
numeric(19,5)
0.00
|
Backout Ta...(more) Join Now
|
POP10100.BCKTXAMT
|
|
|
| OBTAXAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
POP10100.OBTAXAMT
|
|
|
| PA_Third_Party_CB |
tinyint
0
|
|
|
|
|
| BackoutTradeDiscTax |
numeric(19,5)
0.00
|
Backout Tr...(more) Join Now
|
POP10100.BackoutTradeDiscTax
|
|
|
| OrigBackoutTradeDiscTax |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
POP10100.OrigBackoutTradeDiscTax
|
|
|
| PA_Backout_Retention_Tax |
numeric(19,5)
0.00
|
|
|
|
|
| PA_OrigBackRetentionTax |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|