PDK10001 - PDK Timesheet LINE | Prospr - Dynamics GP Table Reference

PDK10001 - PDK Timesheet LINE

Query Builder

Select * from PDK10001

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PDK_TS_No	PDK TS No.	String	32	View
EMPLOYID	Employee ID	String	16	View
PADT	PA Date	Date	4	View
PAPROJNUMBER	PA Project Number	String	16	View
PACOSTCATID	PA Cost Category ID	String	16	View
PATB	PA Time Begin	Time	4	View
PATE	PA Time End	Time	4	View
PDK_Quantity	PDK Quantity	Currency	10	View
PABase_Qty	PA Base Qty	Currency	10	View
PAUnit_of_Measure	PA Unit of Measure	String	10	View
UOMSCHDL	U Of M Schedule	String	12	View
PAUNITCOST	PA Unit Cost	Currency	10	View
ORUNTCST	Originating Unit Cost	Currency	10	View
PABase_Unit_Cost	PA Base Unit Cost	Currency	10	View
PAORGBSUNITCST	PA Originating Base Unit Cost	Currency	10	View
PAEXTCOST	PA Extended Cost	Currency	10	View
OREXTCST	Originating Extended Cost	Currency	10	View
PATOTCST	PA Total Cost	Currency	10	View
PAORIGTOTCOST	PA Originating Total Cost	Currency	10	View
PAOverhead_Amount	PA Overhead Amount	Currency	10	View
PAORIGOVHDAMT	PA Originating Overhead Amount	Currency	10	View
PABaseOvhdCost	PA Base Overhead Cost	Currency	10	View
PAORIGBASEOVRHCST	PA Originating Base Overhead Cost	Currency	10	View
PAOverheaPercentage	PA Overhead Percentage	Currency	10	View
PATOTALOVERH	PA Total Overhead	Currency	10	View
PAORIGTOTOVRHD	PA Originating Total Overhead	Currency	10	View
PA_Base_Billing_Rate	PA Base Billing Rate	Currency	10	View
PAORIGBSBILLRTE	PA Originating Base Billing Rate	Currency	10	View
PABILRATE	PA Billing Rate	Currency	10	View
PAORIGBILLRATE	PA Originating Billing Rate	Currency	10	View
PAMARKPERCENT	PA Markup Percentage	Currency	10	View
PAACREV	PA Accrued Revenues	Currency	10	View
PAORIACCRREV	PA Originating Accrued Revenues	Currency	10	View
PASTD_Qty	PA STD Qty	Currency	10	View
PANC_Qty	PA NC Qty	Currency	10	View
PANB_Qty	PA NB Qty	Currency	10	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
PAREFNO	PA Reference Document No.	String	18	View
PAReference_Line_Seq_N	PA Reference Line Seq No	Long Integer	4	View
PAbllngtype	PA Billing Type	Integer	2	View
PACONTNUMBER	PA Contract Number	String	12	View
PAPayCode	PA Pay Code	String	8	View
PASalary_Posting_Type	PA Salary Posting Type	Integer	2	View
PAJob_Title	PA Job Title	String	8	View
PADepartment	PA Department	String	8	View
STATECD	State Code	String	4	View
LOCLCODE	Local Code	String	8	View
SUTASTAT	Suta State	String	4	View
WRKRCOMP	Workers Comp	String	8	View
PAProfitAmount	PA Profit Amount	Currency	10	View
PAORIGPROFAMT	PA Originating Profit Amount	Currency	10	View
PAProfitPercent	PA Profit Percent	Currency	10	View
PATotalProfit	PA Total Profit	Currency	10	View
PAORIGTOTPROF	PA Originating Total Profit	Currency	10	View
PAProfitType	PA Profit Type 1 = Billing Rate 2 = Markup 3 = Profit/Unit Fixed 4 = Profit/Unit Variable 5 = Total Profit 6 = % of Baseline 7 = % of Actual 8 = None 9 = Price Level	Integer	2	View
PAROUNDAMT	PA Round Amount	Currency	10	View
PABilling_StatusN	PA Billing Status 1 = Billable 2 = In Process 3 = Closed 4 = Non-Billable 5 = Fixed Fee Trx	Integer	2	View
PDK_Billing_Note_ID	PDK Billing Note ID	String	42	View
PACHGORDNO	PA Change Order Number	String	18	View
PAMCCURNCYID	PA MC Currency ID	String	16	View
PA_MC_Billing_Rate	PA MC Billing Rate	Currency	10	View
PA_MC_Base_Billing_Rate	PA MC Base Billing Rate	Currency	10	View
PA_MC_Accrued_Revenue	PA MC Accrued Revenue	Currency	10	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
RATECALC	Rate Calc 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

PDK10001 - PDK Timesheet LINE

Query Builder

Customer Service

Information

My Account

Contact Us