PA11801 - PA Combined History Detail File | Prospr

PA11801 - PA Combined History Detail File

Query Builder

Select * from PA11801

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PATU	PA Transaction Usage 1 = Timesheet 2 = Equipment Log 3 = Miscellaneous Log 4 = Purchases/Material 5 = Employee Expense	Integer	2	View
PADocnumber20	PA Document No.	String	18	View
PAREFNO	PA Reference Document No.	String	18	View
PADT	PA Date	Date	4	View
PApurordnum	PA Purchase Order No.	String	18	View
PACONTNUMBER	PA Contract Number	String	12	View
PAPROJNUMBER	PA Project Number	String	16	View
PACOSTCATID	PA Cost Category ID	String	16	View
PAContMgrID	PA Contract Manager ID	String	16	View
PAitemnumber	PA Item Number	String	32	View
EMPLOYID	Employee ID	String	16	View
PACOSTOWNER	PA Cost Owner	String	32	View
CUSTNMBR	Customer Number	String	16	View
PAprojmngrid	PA Project Manager ID	String	16	View
PAProjectType	PA Project Type	Integer	2	View
SLPRSNID	Salesperson ID	String	16	View
PATB	PA Time Begin	Time	4	View
PATE	PA Time End	Time	4	View
PAconvtmints	PA Converted Minutes	Integer	2	View
PAbillnoteidx	PA Billing Note Index	Currency	10	View
PAQtyQ	PA 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
PAOverhead_Amount	PA Overhead Amount	Currency	10	View
PAORIGOVHDAMT	PA Originating Overhead Amount	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
PATOTCST	PA Total Cost	Currency	10	View
PAORIGTOTCOST	PA Originating Total Cost	Currency	10	View
PAbllngtype	PA Billing Type	Integer	2	View
BKTPURAM	Backout Purchases Amount	Currency	10	View
PABILRATE	PA Billing Rate	Currency	10	View
PAORIGBILLRATE	PA Originating Billing Rate	Currency	10	View
PA_Base_Billing_Rate	PA Base Billing Rate	Currency	10	View
PAORIGBSBILLRTE	PA Originating Base 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
PASplit_NC	PA Split NC Qty	Currency	10	View
PANB_Qty	PA NB Qty	Currency	10	View
PAPurchase_Tax_Options	PA Purchase Tax Options	Integer	2	View
ITMTSHID	Item Tax Schedule ID	String	16	View
TRDISAMT	Trade Discount Amount	Currency	10	View
FRTAMNT	Freight Amount	Currency	10	View
MSCCHAMT	Misc Charges Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
PAReference_Line_Seq_N	PA Reference Line Seq No	Long Integer	4	View
PAexptdate	PA Export Date	Date	4	View
PABilling_StatusN	PA Billing Status 1 = Billable 2 = In Process 3 = Closed 4 = Non-Billable 5 = Fixed Fee Trx	Integer	2	View
PAUD1	PA User Defined 1	String	22	View
PAUD2	PA User Defined 2	String	22	View
PAprjclsid	PA Project Class ID	String	16	View
CUSTCLAS	Customer Class	String	16	View
PAcontclassid	PA Contract Class ID	String	16	View
PACOSTCATCLASID	PA Cost Category Class ID	String	16	View
PAPayCode	PA Pay Code	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
PASalary_Posting_Type	PA Salary Posting Type	Integer	2	View
PAJob_Title	PA Job Title	String	8	View
PADepartment	PA Department	String	8	View
PABilled_QtyN	PA Billed Qty	Currency	10	View
PABilledTax	PA Billed Tax	Currency	10	View
PABilled_Misc	PA Billed Misc	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
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
PAApproved_Quantity	PA Approved Quantity	Currency	10	View
PAAPPROVBILLRATE	PA Approved Billing Rate	Currency	10	View
PAAPPROVMKUPPCT	PA Approved Markup Percentage	Currency	10	View
PAApproved_Billing_Amou	PA Approved Billing Amount	Currency	10	View
PA_Billed_Profit_Amount_	PA Billed Profit Amount Average	Currency	10	View
PABilledProfitPercentage	PA Billed Profit Percentage Average	Currency	10	View
PABilled_Amount	PA Billed Amount	Currency	10	View
PABilled_Freight	PA Billed Freight	Currency	10	View
PABilled_Discount	PA Billed Discount	Currency	10	View
PAWrite_UpDown_Amount	PA Write Up/Down Amount	Currency	10	View
PAWrite_UpDown_Percenta	PA Write Up/Down Percentage	Long Integer	4	View
PAApprover_ID	PA Approver ID	String	16	View
PAApprover_Type	PA Approver Type	Integer	2	View
PAPartial_Bill	PA Partial Bill	Boolean	2	View
PACGBWIPIDX	PA WIP IDX	Long Integer	4	View
PAUnbilled_AR_Idx	PA Unbilled AR IDX	Long Integer	4	View
PAUnbilled_Proj_Rev_Idx	PA Unbilled Proj Rev IDX	Long Integer	4	View
PAOverhead_IDX	PA Overhead IDX	Long Integer	4	View
PAContra_Account_IDX	PA Contra Account IDX	Long Integer	4	View
PACogs_Idx	PA COGS IDX	Long Integer	4	View
PAPaymentMethod	PA Payment Method	Integer	2	View
PAExpenseType	PA Expense Type	Integer	2	View
LOCNCODE	Location Code	String	12	View
PRICELVL	Price Level	String	16	View
IVIVINDX	IV IV Index	Long Integer	4	View
IVIVOFAC_1	IV IV Offset Account:Account_Segment_Pool1	String	10	View
IVIVOFAC_2	IV IV Offset Account:Account_Segment_Pool2	String	10	View
IVIVOFAC_3	IV IV Offset Account:Account_Segment_Pool3	String	10	View
IVIVOFAC_4	IV IV Offset Account:Account_Segment_Pool4	String	10	View
IVIVOFAC_5	IV IV Offset Account:Account_Segment_Pool5	String	10	View

PA11801 - PA Combined History Detail File

Query Builder

Customer Service

Information

My Account

Contact Us