GP Tables

PA10500 - PA Employee Expense Header File

Dynamics GP table PA10500 (PA Employee Expense Header File) contains 113 columns including PAertrxtype, PAerdocnumber, PDK_EE_No....

SQL Query Builder

113 Columns

Column Description Type Length
PAertrxtype PA Empl Expense TRX Type Integer 2
PAerdocnumber PA Empl Expense Document No. String 18
PDK_EE_No PDK EE No. String 32
PADOCDT PA Document Date Date 4
USERID User ID String 16
BACHNUMB Batch Number String 16
BCHSOURC Batch Source String 16
TRXSORCE TRX Source String 14
PAREFNO PA Reference Document No. String 18
SHIPMTHD Shipping Method String 16
PAUD1 PA User Defined 1 String 22
PAUD2 PA User Defined 2 String 22
EMPLOYID Employee ID String 16
PAVENADDRESSID PA Vendor Address ID String 16
PAStartDate PA Start Date Date 4
PAEnDate PA End Date Date 4
PAreptsuff PA Reporting Suffix String 6
PAYR PA Year Integer 2
PYMTRMID Payment Terms ID String 22
DUEDATE Due Date Date 4
DSCDLRAM Discount Dollar Amount Currency 10
ORDDLRAT Originating Discount Dollar Amount Currency 10
DISCDATE Discount Date Date 4
DISAMTAV Discount Amount Available Currency 10
ODISAMTAV Originating Discount Amount Available Currency 10
PRCTDISC Percent Discount Integer 2
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
CURRNIDX Currency Index Integer 2
PATQTY PA Total Quantity Currency 10
PAEXTCOST PA Extended Cost Currency 10
OREXTCST Originating Extended Cost Currency 10
PAtotcosts PA Total Costs Currency 10
PAORIGTOTCOSTS PA Originating Total Costs Currency 10
PAREIMBURSTAXAMT PA Reimbursable Tax Amount Currency 10
PAORIGREIMTAXAMT PA Originating Reimbursable Tax Amount Currency 10
BKTPURAM Backout Purchases Amount Currency 10
PATACRV PA Total Accrued Revenues Currency 10
PAORIACCRREV PA Originating Accrued Revenues Currency 10
TRDISAMT Trade Discount Amount Currency 10
ORTDISAM Originating 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
ORFRTAMT Originating Freight Amount Currency 10
FRTTXAMT Freight Tax Amount Currency 10
ORFRTTAX Originating 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
OMISCAMT Originating Misc Charges Amount Currency 10
MSCTXAMT Misc Tax Amount Currency 10
ORMSCTAX Originating Misc Tax Amount Currency 10
DOCAMNT Document Amount Currency 10
ORDOCAMT Originating Document Amount Currency 10
TEN99AMNT 1099 Amount Currency 10
OR1099AM Originating 1099 Amount Currency 10
UN1099AM Unapplied 1099 Amount Currency 10
CASHAMNT Cash Amount Currency 10
ORCASAMT Originating 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
CHRGAMNT Charge Amount Currency 10
OCHGAMT Originating Charge Amount Currency 10
CHEKAMNT Check Amount Currency 10
ORCHKAMT Originating 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
CARDNAME Card Name String 16
CRCRDAMT Credit Card Amount Currency 10
ORCCDAMT Originating Credit Card Amount Currency 10
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
ORDISTKN Originating Discount Taken Amount Currency 10
ORDAVFRT Originating Discount Available Freight Currency 10
ODAVPUR Originating Discount Available Purchases Currency 10
ORDAVMSC Originating Discount Available Misc Currency 10
TAXSCHID Tax Schedule ID String 16
TAXAMNT Tax Amount Currency 10
ORTAXAMT Originating Tax Amount Currency 10
BCKTXAMT Backout Tax Amount Currency 10
OBTAXAMT Originating Backout Tax Amount Currency 10
PAReimbursableAmount PA Reimbursable Amount Currency 10
PAOrigReimbursableAmt PA Originating Reimbursable Amount Currency 10
PAPD PA Post Date Date 4
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
PA_EE_HDR_Errors PA EE HDR Errors Long Integer 4
PA_EE_Dist_Errors PA EE Distribution Errors Long Integer 4
PA_MC_EE_Posting_Errors PA MC EE Posting Errors Long Integer 4
PApostoDynPM PA Post to Dyn Payables Mgmt Boolean 2
Tax_Date Tax Date Date 4
NOTEINDX Note Index Currency 10
TaxInvRecvd Tax Invoice Received Boolean 2
TaxInvReqd Tax Invoice Required Boolean 2
Correcting_Trx_Type Correcting Trx Type Integer 2
PAORIGINLDOCNUM PA Original Document Number String 18
TEN99TYPE 1099 Type1 – Not a 1099 vendor2 – Dividend3 – Interest4 - Miscellaneous Integer 2
1099 Type values (5)
1 = Not a 1099 Vendor2 = Dividend3 = Interest4 = Miscellaneous5 = Nonemployee Compensation
TEN99BOXNUMBER 1099 Box Number Integer 2
CREATDDT Created Date Date 4
CRUSRID Created User ID String 16

Related Tables

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

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

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