GP Tables

PA33200 - PA Billing Detail HIST

Dynamics GP table PA33200 (PA Billing Detail HIST) contains 61 columns including PABILLTRXT, PADocnumber20, PADOCDT....

SQL Query Builder

61 Columns

Column Description Type Length
PABILLTRXT PA Biller Trx Type Integer 2
PADocnumber20 PA Document No. String 18
PADOCDT PA Document Date Date 4
PAREFNO PA Reference Document No. String 18
LNITMSEQ Line Item Sequence Long Integer 4
CUSTNMBR Customer Number String 16
PACONTNUMBER PA Contract Number String 12
PAPROJNUMBER PA Project Number String 16
PAProjectType PA Project Type Integer 2
PApurordnum PA Purchase Order No. String 18
PABillingAmount PA Billing Amount Currency 10
PATMbillamount PA Billing Amount - TM Currency 10
PAFFbillamount PA Billing Amount - FF Currency 10
PAFeebillamount PA Billing Amount - Fee Currency 10
PAtotbillings PA Total Billings Currency 10
PA_Discount_Type PA Discount Type Integer 2
TRDISAMT Trade Discount Amount Currency 10
PA_Trade_Discount_Pcnt PA Trade Discount Percent Integer 2
PATOTTAX PA Total Tax Currency 10
PATMtaxamt PA Tax Amt - TM Currency 10
PAFFtaxamt PA Tax Amt - FF Currency 10
PAFeetaxamount PA Tax Amt - Fee Currency 10
PABACKBILL PA Backout Bill Amount Currency 10
PATMbckoutbillamt PA Backout Bill Amt - TM Currency 10
PAPBbckoutbillamt PA Backout Bill Amt - FF Currency 10
PAFeebckoutbillamt PA Backout Bill Amt - Fee Currency 10
APPLDAMT Applied Amount Currency 10
ACCTAMNT Account Amount Currency 10
PARetentionFeeAmount PA Retention Fee Amount Currency 10
PARetainer_Fee_Amount PA Retainer Fee Amount Currency 10
PA_Applied_Retainer PA Applied Document Amt Currency 10
PA_Applied_Freight_Misc PA Applied Freight Misc Currency 10
PA_Trade_IDX PA Trade IDX Long Integer 4
TAXSCHID Tax Schedule ID String 16
PAOrigBillAmount PA Originating Billing Amount Currency 10
PAOrigBillingAmtTM PA Originating Billing Amount - TM Currency 10
PAOrigBillingAmtFF PA Originating Billing Amount - FF Currency 10
PAOrigBillingAmtFee PA Originating Billing Amount - Fee Currency 10
PAOrigTotalBilings PA Originating Total Billings Currency 10
PAOrigTotalTaxAmt PA Originating Total Tax Currency 10
PAOrigTaxAmtTM_ PA Originating Tax Amt - TM Currency 10
PAOrigTaxAmtFF PA Originating Tax Amt - FF Currency 10
PAOrigTaxAmtFee PA Originating Tax Amt - Fee Currency 10
PAOrigBackoutBillAmt PA Originating Backout Bill Amt Currency 10
PAOrigBackoutBillTM PA Originating Backout Bill Amt - TM Currency 10
PAOrigBackoutBillFF PA Originating Backout Bill Amt - FF Currency 10
PAOrigBackoutBillFee PA Originating Backout Bill Amt - Fee Currency 10
PAOrigRetentionFeeAmt PA Originating Retention Fee Amt Currency 10
PAOrigRetainerFeeAmt PA Originating Retainer Fee Amt Currency 10
PAOrigAppliedDocAmt PA Originating Applied Document Amt Currency 10
PAOrigAppliedFreightMisc PA Originating Applied Freight Misc Currency 10
ORTDISAM Originating Trade Discount Amount Currency 10
ORAPPAMT Originating Applied Amount Currency 10
ORACTAMT Originating Account Amount Currency 10
BCKTXAMT Backout Tax Amount Currency 10
OBTAXAMT Originating Backout Tax Amount Currency 10
PA_Third_Party_CB PA Third Party CB Boolean 2
BackoutTradeDiscTax Backout Trade Discount Tax Amount Currency 10
OrigBackoutTradeDiscTax Originating Backout Trade Discount Tax Amount Currency 10
PA_Backout_Retention_Tax PA Backout Retention Tax Amount Currency 10
PA_OrigBackRetentionTax PA Originating Backout Retention Tax Amount Currency 10

Related Tables

Tables that share columns with PA33200. Click "Join" to add to your query.

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

LNITMSEQ

ASIEXP20 ASIEXP25 ASIEXP26 DO10100 EDCEI006 EEPAIVRQ ERB10300 ERB10700

PAPROJNUMBER

PA00402 PA00502 PA00503 PA01201 PA01221 PA01241 PA01251 PA01301

TAXSCHID

ASIEXP02 ASIEXP03 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP11 ASIEXP15

TRDISAMT

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP20 ASIEXP21 ASIEXP25 ASIEXP26

PACONTNUMBER

PA01101 PA01121 PA01141 PA01161 PA01201 PA10001 PA10101 PA10201

PAREFNO

PA10000 PA10001 PA10100 PA10101 PA10200 PA10201 PA10500 PA10501

ORTDISAM

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP20 ASIEXP21 ASIEXP27 MC020102

BCKTXAMT

ASIEXP06 ASIEXP07 ASIEXP20 ASIEXP25 ASIEXP27 IVC10100 PA10500 PA10501

OBTAXAMT

ASIEXP06 ASIEXP07 ASIEXP20 ASIEXP27 PA10500 PA10501 PA13100 PA13200