GP Tables

PA11800 - PA Combined History Header file

Dynamics GP table PA11800 (PA Combined History Header file) contains 84 columns including PATU, PADocnumber20, PATRXType....

SQL Query Builder

84 Columns

Column Description Type Length
PATU PA Transaction Usage1 = Timesheet2 = Equipment Log3 = Miscellaneous Log4 = Purchases/Material5 = Employee Expense Integer 2
PADocnumber20 PA Document No. String 18
PATRXType PA TRX Type Integer 2
PADOCDT PA Document Date Date 4
USERID User ID String 16
BACHNUMB Batch Number String 16
PAREFNO PA Reference Document No. String 18
PAUD1 PA User Defined 1 String 22
PAUD2 PA User Defined 2 String 22
VENDORID Vendor ID String 16
PACOSTOWNER PA Cost Owner String 32
PAREPD PA Reporting Period Integer 2
PAREPDT PA Reporting Date Date 4
PAreptsuff PA Reporting Suffix String 6
PAYR PA Year Integer 2
PAVENINVNO PA Vendor Invoice Number String 22
PAVENADDRESSID PA Vendor Address ID String 16
PACOMM PA Comment String 52
PYMTRMID Payment Terms ID String 22
DUEDATE Due Date Date 4
DSCDLRAM Discount Dollar Amount Currency 10
DISCDATE Discount Date Date 4
DISAMTAV Discount Amount Available Currency 10
PRCTDISC Percent Discount Integer 2
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
SHIPMTHD Shipping Method String 16
PATQTY PA Total Quantity Currency 10
PAtotcosts PA Total Costs Currency 10
BKTPURAM Backout Purchases Amount Currency 10
PATACRV PA Total Accrued Revenues Currency 10
TRDISAMT Trade Discount Amount Currency 10
PAFreight_Taxable_P PA Freight Taxable - Purchase Integer 2
FRTSCHID Freight Schedule ID String 16
FRTAMNT Freight Amount Currency 10
FRTTXAMT Freight Tax Amount Currency 10
PAMisc_Taxable_P PA Misc Taxable - Purchase Integer 2
MSCSCHID Misc Schedule ID String 16
MSCCHAMT Misc Charges Amount Currency 10
MSCTXAMT Misc Tax Amount Currency 10
TAXAMNT Tax Amount Currency 10
DOCAMNT Document Amount Currency 10
TEN99AMNT 1099 Amount Currency 10
UN1099AM Unapplied 1099 Amount Currency 10
CASHAMNT Cash Amount Currency 10
CAMCBKID Cash Amount Checkbook ID String 16
CDOCNMBR Cash Document Number String 22
CAMTDATE Cash Amount Date Date 4
CAMPMTNM Cash Amount Payment Number String 22
CHEKAMNT Check Amount Currency 10
CHEKNMBR Check Number String 22
CHEKDATE Check Date Date 4
CAMPYNBR Check Amount Payment Number String 22
CHAMCBID Check Amount Checkbook ID String 16
CRCRDAMT Credit Card Amount Currency 10
CARDNAME Card Name String 16
CRCARDDT Credit Card Date Date 4
CCAMPYNM Credit Card Amount Payment Number String 22
CCRCTNUM Credit Card Receipt Number String 22
DISTKNAM Discount Taken Amount Currency 10
CHRGAMNT Charge Amount Currency 10
LNITMSEQ Line Item Sequence Long Integer 4
PAPD PA Post Date Date 4
VOIDSTTS Void Status0 = Document has not been voided.1 = Document has been voided.2 = Document has been marked NSF and voided. Integer 2
Void Status values (2)
0 = Normal1 = Voided
VOIDDATE Void Date Date 4
NOTEINDX Note Index Currency 10
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
PAORIGTOTCOSTS PA Originating Total Costs Currency 10
PAORIACCRREV PA Originating Accrued Revenues Currency 10
DISAVAMT Discount Available Amount Currency 10
TAXSCHID Tax Schedule ID String 16
PYMNTTRM Payment Terms String 16
POPTYPE POP Type Integer 2
VNDDOCNM Vendor Document Number String 22
ACTLSHIP Actual Ship Date Date 4
GLPOSTDT GL Posting Date Date 4
DSCPCTAM Discount Percent Amount Integer 2
TRXSORCE TRX Source String 14
VCHRNMBR Voucher Number String 22

Related Tables

Tables that share columns with PA11800. 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

USERID

AAG50001 AAG60001 AAG70001 ACTIVITY AHPSLH01 ASIEXP100 ASIEXP85 CAM10200

TIME1

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

RATETPID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP02 ASIEXP03

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

BACHNUMB

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25