PDK10500 - PDK Employee Expense HDR | Prospr - Dynamics GP Table Reference

PDK10500 - PDK Employee Expense HDR

Query Builder

Select * from PDK10500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PDK_EE_Trx_Type	PDK EE Trx Type	Integer	2	View
PDK_EE_No	PDK EE No.	String	32	View
PDK_Ref_Doc_No	PDK Reference Document No.	String	32	View
PDK_Document_Status	PDK Document Status	Integer	2	View
PDK_Trx_Source	PDK Trx Source	Integer	2	View
PDK_Remote_Change	PDK Remote Change	Boolean	2	View
PADOCDT	PA Document Date	Date	4	View
PAYR	PA Year	Integer	2	View
EMPLOYID	Employee ID	String	16	View
PAStartDate	PA Start Date	Date	4	View
PAEnDate	PA End Date	Date	4	View
PACOMM	PA Comment	String	52	View
PAUD1	PA User Defined 1	String	22	View
PAUD2	PA User Defined 2	String	22	View
PDK_Total_Quantity	PDK Total Quantity	Currency	10	View
PAEXTCOST	PA Extended Cost	Currency	10	View
OREXTCST	Originating Extended Cost	Currency	10	View
PAtotcosts	PA Total Costs	Currency	10	View
PATACRV	PA Total Accrued Revenues	Currency	10	View
DOCAMNT	Document Amount	Currency	10	View
TEN99AMNT	1099 Amount	Currency	10	View
PAVENADDRESSID	PA Vendor Address ID	String	16	View
PYMTRMID	Payment Terms ID	String	22	View
DUEDATE	Due Date	Date	4	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DISCDATE	Discount Date	Date	4	View
DISAMTAV	Discount Amount Available	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
BKTPURAM	Backout Purchases Amount	Currency	10	View
SHIPMTHD	Shipping Method	String	16	View
PRCTDISC	Percent Discount	Integer	2	View
TRDISAMT	Trade Discount Amount	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
MSCCHAMT	Misc Charges Amount	Currency	10	View
UN1099AM	Unapplied 1099 Amount	Currency	10	View
PAPD	PA Post Date	Date	4	View
CARDNAME	Card Name	String	16	View
CRCRDAMT	Credit Card Amount	Currency	10	View
CRCARDDT	Credit Card Date	Date	4	View
CCRCTNUM	Credit Card Receipt Number	String	22	View
TAXAMNT	Tax Amount	Currency	10	View
TAXSCHID	Tax Schedule ID	String	16	View
PAFreight_Taxable_P	PA Freight Taxable - Purchase	Integer	2	View
FRTSCHID	Freight Schedule ID	String	16	View
FRTTXAMT	Freight Tax Amount	Currency	10	View
PAMisc_Taxable_P	PA Misc Taxable - Purchase	Integer	2	View
MSCSCHID	Misc Schedule ID	String	16	View
MSCTXAMT	Misc Tax Amount	Currency	10	View
CHRGAMNT	Charge Amount	Currency	10	View
NOTEID	Note ID	String	32	View
PDK_Reporting_Suffix	PDK Reporting Suffix	String	6	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
MANAGER	Manager	String	16	View
Manager_Approval_Status	Manager Approval Status	Integer	2	View
SUPERVISOR	Supervisor	String	32	View
Sup_Approval_Status	Supervisor Approval Status	Integer	2	View
Administrator	Administrator	String	16	View
Admin_Approval_Status	Admin Approval Status	Integer	2	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = 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	View
ORDOCAMT	Originating Document Amount	Currency	10	View
OR1099AM	Originating 1099 Amount	Currency	10	View
ORDDLRAT	Originating Discount Dollar Amount	Currency	10	View
ODISAMTAV	Originating Discount Amount Available	Currency	10	View
ORDISTKN	Originating Discount Taken Amount	Currency	10	View
ORDAVFRT	Originating Discount Available Freight	Currency	10	View
ODAVPUR	Originating Discount Available Purchases	Currency	10	View
ORDAVMSC	Originating Discount Available Misc	Currency	10	View
OBKPURAMT	Originating Backout Purchases Amount	Currency	10	View
ORTDISAM	Originating Trade Discount Amount	Currency	10	View
PAORIGTOTCOSTS	PA Originating Total Costs	Currency	10	View
PAORIACCRREV	PA Originating Accrued Revenues	Currency	10	View
ORCCDAMT	Originating Credit Card Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
ORFRTAMT	Originating Freight Amount	Currency	10	View
ORFRTTAX	Originating Freight Tax Amount	Currency	10	View
OMISCAMT	Originating Misc Charges Amount	Currency	10	View
ORMSCTAX	Originating Misc Tax Amount	Currency	10	View
OCHGAMT	Originating Charge Amount	Currency	10	View
PAReimbursableAmount	PA Reimbursable Amount	Currency	10	View
PAOrigReimbursableAmt	PA Originating Reimbursable Amount	Currency	10	View
BCKTXAMT	Backout Tax Amount	Currency	10	View
OBTAXAMT	Originating Backout Tax Amount	Currency	10	View
PAREIMBURSTAXAMT	PA Reimbursable Tax Amount	Currency	10	View
PAORIGREIMTAXAMT	PA Originating Reimbursable Tax Amount	Currency	10	View
PAerdocnumber	PA Empl Expense Document No.	String	18	View
PAREFNO	PA Reference Document No.	String	18	View
PDK_Proxy_ID	PDK Proxy ID	String	16	View
PDK_EE_App_Update	PDK EE App Update	Integer	2	View
MODIFDT	Modified Date	Date	4	View
Modified_Time	Modified Time	Time	4	View
Tax_Date	Tax Date	Date	4	View
TaxInvRecvd	Tax Invoice Received	Boolean	2	View
TaxInvReqd	Tax Invoice Required	Boolean	2	View
CAMCBKID	Cash Amount Checkbook ID	String	16	View
CDOCNMBR	Cash Document Number	String	22	View
CAMTDATE	Cash Amount Date	Date	4	View
CASHAMNT	Cash Amount	Currency	10	View
ORCASAMT	Originating Cash Amount	Currency	10	View
CHAMCBID	Check Amount Checkbook ID	String	16	View
CHEKNMBR	Check Number	String	22	View
CHEKDATE	Check Date	Date	4	View
CHEKAMNT	Check Amount	Currency	10	View
ORCHKAMT	Originating Check Amount	Currency	10	View
APRVLUSERID	Approval User ID	String	16	View
APPRVLDT	Approval Date	Date	4	View
TEN99TYPE	1099 Type 1 – Not a 1099 vendor 2 – Dividend 3 – Interest 4 - Miscellaneous	Integer	2	View
TEN99BOXNUMBER	1099 Box Number	Integer	2	View

PDK10500 - PDK Employee Expense HDR

Query Builder

Customer Service

Information

My Account

Contact Us