GP Tables

PA33100 - PA Billing Header HIST

Dynamics GP table PA33100 (PA Billing Header HIST) contains 114 columns including PABILLTRXT, PADocnumber20, NOTEINDX....

SQL Query Builder

114 Columns

Column Description Type Length
PABILLTRXT PA Biller Trx Type Integer 2
PADocnumber20 PA Document No. String 18
NOTEINDX Note Index Currency 10
PADOCDT PA Document Date Date 4
PAPD PA Post Date Date 4
BACHNUMB Batch Number String 16
BCHSOURC Batch Source String 16
TRXSORCE TRX Source String 14
PAuserid PA User ID String 16
LSTEDTDT Last Edit Date Date 4
LSTUSRED Last User to Edit String 16
PAREFNO PA Reference Document No. String 18
CUSTNMBR Customer Number String 16
CSTPONBR Customer PO Number String 22
PRBTADCD Primary Billto Address Code String 16
PYMTRMID Payment Terms ID String 22
PABILLFORMAT PA Bill Format String 16
PACOMM PA Comment String 52
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
PAUD1 PA User Defined 1 String 22
PAUD2 PA User Defined 2 String 22
CASHAMNT Cash Amount Currency 10
CBKIDCSH Checkbook ID Cash String 16
CASHDATE Cash Date Date 4
DCNUMCSH Document Number Cash String 22
CHEKAMNT Check Amount Currency 10
CBKIDCHK Checkbook ID Check String 16
CHEKNMBR Check Number String 22
CHEKDATE Check Date Date 4
DCNUMCHK Document Number Check String 22
CRCRDAMT Credit Card Amount Currency 10
CRCRDNAM Credit Card Name String 16
RCTNCCRD Receipt Number Credit Card String 22
CRCARDDT Credit Card Date Date 4
DCNUMCRD Document Number Credit Card String 22
DSCPCTAM Discount Percent Amount Integer 2
DSCDLRAM Discount Dollar Amount Currency 10
DISAVAMT Discount Available Amount Currency 10
DISCAMNT Discount Amount Currency 10
DISCDATE Discount Date Date 4
DISTKNAM Discount Taken Amount Currency 10
DISCRTND Discount Returned Currency 10
PABillingAmount PA Billing Amount Currency 10
TRDISAMT Trade Discount Amount Currency 10
PA_Freight_Amount PA Freight Amount Currency 10
PA_Misc_Amount PA Misc Amount Currency 10
FRTTXAMT Freight Tax Amount Currency 10
MSCTXAMT Misc Tax Amount Currency 10
PATOTTAX PA Total Tax Currency 10
PABACKBILL PA Backout Bill Amount Currency 10
BKTFRTAM Backout Freight Amount Currency 10
BKTMSCAM Backout Misc Amount Currency 10
DOCAMNT Document Amount Currency 10
DUEDATE Due Date Date 4
APPLDAMT Applied Amount Currency 10
PALastDateApplied PA Last Date Applied Date 4
SLPRSNID Salesperson ID String 16
SALSTERR Sales Territory String 16
TAXSCHID Tax Schedule ID String 16
COMDLRAM Commission Dollar Amount Currency 10
COMAPPTO Commission Applied To Integer 2
LNITMSEQ Line Item Sequence Long Integer 4
CUTOFDAT Cutoff Date Date 4
SHIPMTHD Shipping Method String 16
MSCSCHID Misc Schedule ID String 16
MISCTXBL Misc Taxable1 = Taxable2 = Nontaxable3 = Base on customers Integer 2
FRTSCHID Freight Schedule ID String 16
FRGTTXBL Freight Taxable1 = Taxable2 = Nontaxable3 = Base on customers Integer 2
PARetentionFeeAmount PA Retention Fee Amount Currency 10
PARetainer_Fee_Amount PA Retainer Fee Amount Currency 10
PAtotbillings PA Total Billings Currency 10
PAlastprtby PA Last Printed By String 16
PAlastprtdate PA Last Printed Date Date 4
ORCASAMT Originating Cash Amount Currency 10
ORCHKAMT Originating Check Amount Currency 10
ORCCDAMT Originating Credit Card Amount Currency 10
ORDDLRAT Originating Discount Dollar Amount Currency 10
ORDAVAMT Originating Discount Available Amount Currency 10
ORTDISAM Originating Trade Discount Amount Currency 10
ORFRTTAX Originating Freight Tax Amount Currency 10
ORMSCTAX Originating Misc Tax Amount Currency 10
ORBKTFRT Originating Backout Freight Amount Currency 10
ORBKTMSC Originating Backout Misc Amount Currency 10
ORDOCAMT Originating Document Amount Currency 10
ORAPPAMT Originating Applied Amount Currency 10
ORCOMAMT Originating Commission Dollar Amount Currency 10
PAOrigBillAmount PA Originating Billing Amount Currency 10
PAOrigFreightAmt PA Originating Freight Amount Currency 10
PAOrigMiscAmt PA Originating Misc Amount Currency 10
PAOrigTotalTaxAmt PA Originating Total Tax Currency 10
PAOrigBackoutBillAmt PA Originating Backout Bill Amt Currency 10
PAOrigRetentionFeeAmt PA Originating Retention Fee Amt Currency 10
PAOrigRetainerFeeAmt PA Originating Retainer Fee Amt Currency 10
PAOrigTotalBilings PA Originating Total Billings Currency 10
PAOrigDiscTakenAmt PA Originating Discount Taken Amt Currency 10
PAOrigDiscRetAmt PA Originating Discount Returned Amt Currency 10
CURRNIDX Currency Index Integer 2
RATETPID Rate Type ID String 16
EXGTBLID Exchange Table ID String 16
XCHGRATE Exchange Rate Currency (Variable) 10
EXCHDATE Exchange Date Date 4
TIME1 Time Time 4
RTCLCMTD Rate Calculation Method Integer 2
DENXRATE Denomination Exchange Rate Currency (Variable) 10
MCTRXSTT MC Transaction State0 = Euro currency is not created or no denomination currencies are enabled.1 = Originating is not a denomination; Functional is not a denomination2 = Originating is not a denomination; Functional is the Euro currency.3 = Originating is not a denomination; Functional is a denomination.4 = Originating is a denomination; Functional is not a denomination.5 = Originating is a denomination; Functional is a denomination.6 = Originating is a denomination; Functional is the Euro currency.7 = Originating is the Euro currency; Functional is a denomination.8 = Originating is the Euro currency; Functional is not a denomination. Integer 2
PAPostoDynRM PA Post to Dyn Receivables Mgmt Boolean 2
Tax_Date Tax Date Date 4
PA_Third_Party_CB PA Third Party CB Boolean 2
BCKTXAMT Backout Tax Amount Currency 10
OBTAXAMT Originating Backout Tax Amount Currency 10
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 PA33100. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

CURRNIDX

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

TIME1

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

RATETPID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP02 ASIEXP03

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

LNITMSEQ

ASIEXP20 ASIEXP25 ASIEXP26 DO10100 EDCEI006 EEPAIVRQ ERB10300 ERB10700

TRXSORCE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP18 ASIEXP19

XCHGRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

DENXRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07