GP Tables

PDK10500 - PDK Employee Expense HDR

Dynamics GP table PDK10500 (PDK Employee Expense HDR) contains 116 columns including PDK_EE_Trx_Type, PDK_EE_No, PDK_Ref_Doc_No....

SQL Query Builder

116 Columns

Column Description Type Length
PDK_EE_Trx_Type PDK EE Trx Type Integer 2
PDK_EE_No PDK EE No. String 32
PDK_Ref_Doc_No PDK Reference Document No. String 32
PDK_Document_Status PDK Document Status Integer 2
PDK_Trx_Source PDK Trx Source Integer 2
PDK_Remote_Change PDK Remote Change Boolean 2
PADOCDT PA Document Date Date 4
PAYR PA Year Integer 2
EMPLOYID Employee ID String 16
PAStartDate PA Start Date Date 4
PAEnDate PA End Date Date 4
PACOMM PA Comment String 52
PAUD1 PA User Defined 1 String 22
PAUD2 PA User Defined 2 String 22
PDK_Total_Quantity PDK Total Quantity Currency 10
PAEXTCOST PA Extended Cost Currency 10
OREXTCST Originating Extended Cost Currency 10
PAtotcosts PA Total Costs Currency 10
PATACRV PA Total Accrued Revenues Currency 10
DOCAMNT Document Amount Currency 10
TEN99AMNT 1099 Amount Currency 10
PAVENADDRESSID PA Vendor Address ID String 16
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
DISTKNAM Discount Taken Amount Currency 10
BKTPURAM Backout Purchases Amount Currency 10
SHIPMTHD Shipping Method String 16
PRCTDISC Percent Discount Integer 2
TRDISAMT Trade Discount Amount Currency 10
FRTAMNT Freight Amount Currency 10
MSCCHAMT Misc Charges Amount Currency 10
UN1099AM Unapplied 1099 Amount Currency 10
PAPD PA Post Date Date 4
CARDNAME Card Name String 16
CRCRDAMT Credit Card Amount Currency 10
CRCARDDT Credit Card Date Date 4
CCRCTNUM Credit Card Receipt Number String 22
TAXAMNT Tax Amount Currency 10
TAXSCHID Tax Schedule ID String 16
PAFreight_Taxable_P PA Freight Taxable - Purchase Integer 2
FRTSCHID Freight Schedule ID String 16
FRTTXAMT Freight Tax Amount Currency 10
PAMisc_Taxable_P PA Misc Taxable - Purchase Integer 2
MSCSCHID Misc Schedule ID String 16
MSCTXAMT Misc Tax Amount Currency 10
CHRGAMNT Charge Amount Currency 10
NOTEID Note ID String 32
PDK_Reporting_Suffix PDK Reporting Suffix String 6
LNITMSEQ Line Item Sequence Long Integer 4
MANAGER Manager String 16
Manager_Approval_Status Manager Approval Status Integer 2
SUPERVISOR Supervisor String 32
Sup_Approval_Status Supervisor Approval Status Integer 2
Administrator Administrator String 16
Admin_Approval_Status Admin Approval Status Integer 2
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
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
ORDOCAMT Originating Document Amount Currency 10
OR1099AM Originating 1099 Amount Currency 10
ORDDLRAT Originating Discount Dollar Amount Currency 10
ODISAMTAV Originating Discount Amount Available 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
OBKPURAMT Originating Backout Purchases Amount Currency 10
ORTDISAM Originating Trade Discount Amount Currency 10
PAORIGTOTCOSTS PA Originating Total Costs Currency 10
PAORIACCRREV PA Originating Accrued Revenues Currency 10
ORCCDAMT Originating Credit Card Amount Currency 10
ORTAXAMT Originating Tax Amount Currency 10
ORFRTAMT Originating Freight Amount Currency 10
ORFRTTAX Originating Freight Tax Amount Currency 10
OMISCAMT Originating Misc Charges Amount Currency 10
ORMSCTAX Originating Misc Tax Amount Currency 10
OCHGAMT Originating Charge Amount Currency 10
PAReimbursableAmount PA Reimbursable Amount Currency 10
PAOrigReimbursableAmt PA Originating Reimbursable Amount Currency 10
BCKTXAMT Backout Tax Amount Currency 10
OBTAXAMT Originating Backout Tax Amount Currency 10
PAREIMBURSTAXAMT PA Reimbursable Tax Amount Currency 10
PAORIGREIMTAXAMT PA Originating Reimbursable Tax Amount Currency 10
PAerdocnumber PA Empl Expense Document No. String 18
PAREFNO PA Reference Document No. String 18
PDK_Proxy_ID PDK Proxy ID String 16
PDK_EE_App_Update PDK EE App Update Integer 2
MODIFDT Modified Date Date 4
Modified_Time Modified Time Time 4
Tax_Date Tax Date Date 4
TaxInvRecvd Tax Invoice Received Boolean 2
TaxInvReqd Tax Invoice Required Boolean 2
CAMCBKID Cash Amount Checkbook ID String 16
CDOCNMBR Cash Document Number String 22
CAMTDATE Cash Amount Date Date 4
CASHAMNT Cash Amount Currency 10
ORCASAMT Originating Cash Amount Currency 10
CHAMCBID Check Amount Checkbook ID String 16
CHEKNMBR Check Number String 22
CHEKDATE Check Date Date 4
CHEKAMNT Check Amount Currency 10
ORCHKAMT Originating Check Amount Currency 10
APRVLUSERID Approval User ID String 16
APPRVLDT Approval Date Date 4
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

Related Tables

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

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

LNITMSEQ

ASIEXP20 ASIEXP25 ASIEXP26 DO10100 EDCEI006 EEPAIVRQ ERB10300 ERB10700

XCHGRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

DENXRATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

EXGTBLID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

EXCHDATE

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

MCTRXSTT

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07