GP Tables

PA11801 - PA Combined History Detail File

Dynamics GP table PA11801 (PA Combined History Detail File) contains 111 columns including PATU, PADocnumber20, PAREFNO....

SQL Query Builder

111 Columns

Column Description Type Length
PATU PA Transaction Usage1 = Timesheet2 = Equipment Log3 = Miscellaneous Log4 = Purchases/Material5 = Employee Expense Integer 2
PADocnumber20 PA Document No. String 18
PAREFNO PA Reference Document No. String 18
PADT PA Date Date 4
PApurordnum PA Purchase Order No. String 18
PACONTNUMBER PA Contract Number String 12
PAPROJNUMBER PA Project Number String 16
PACOSTCATID PA Cost Category ID String 16
PAContMgrID PA Contract Manager ID String 16
PAitemnumber PA Item Number String 32
EMPLOYID Employee ID String 16
PACOSTOWNER PA Cost Owner String 32
CUSTNMBR Customer Number String 16
PAprojmngrid PA Project Manager ID String 16
PAProjectType PA Project Type Integer 2
SLPRSNID Salesperson ID String 16
PATB PA Time Begin Time 4
PATE PA Time End Time 4
PAconvtmints PA Converted Minutes Integer 2
PAbillnoteidx PA Billing Note Index Currency 10
PAQtyQ PA Quantity Currency 10
PABase_Qty PA Base Qty Currency 10
PAUnit_of_Measure PA Unit of Measure String 10
UOMSCHDL U Of M Schedule String 12
PAUNITCOST PA Unit Cost Currency 10
ORUNTCST Originating Unit Cost Currency 10
PABase_Unit_Cost PA Base Unit Cost Currency 10
PAORGBSUNITCST PA Originating Base Unit Cost Currency 10
PAOverhead_Amount PA Overhead Amount Currency 10
PAORIGOVHDAMT PA Originating Overhead Amount Currency 10
PAOverheaPercentage PA Overhead Percentage Currency 10
PATOTALOVERH PA Total Overhead Currency 10
PAORIGTOTOVRHD PA Originating Total Overhead Currency 10
PATOTCST PA Total Cost Currency 10
PAORIGTOTCOST PA Originating Total Cost Currency 10
PAbllngtype PA Billing Type Integer 2
BKTPURAM Backout Purchases Amount Currency 10
PABILRATE PA Billing Rate Currency 10
PAORIGBILLRATE PA Originating Billing Rate Currency 10
PA_Base_Billing_Rate PA Base Billing Rate Currency 10
PAORIGBSBILLRTE PA Originating Base Billing Rate Currency 10
PAMARKPERCENT PA Markup Percentage Currency 10
PAACREV PA Accrued Revenues Currency 10
PAORIACCRREV PA Originating Accrued Revenues Currency 10
PASTD_Qty PA STD Qty Currency 10
PANC_Qty PA NC Qty Currency 10
PASplit_NC PA Split NC Qty Currency 10
PANB_Qty PA NB Qty Currency 10
PAPurchase_Tax_Options PA Purchase Tax Options Integer 2
ITMTSHID Item Tax Schedule ID String 16
TRDISAMT Trade Discount Amount Currency 10
FRTAMNT Freight Amount Currency 10
MSCCHAMT Misc Charges Amount Currency 10
TAXAMNT Tax Amount Currency 10
LNITMSEQ Line Item Sequence Long Integer 4
PAReference_Line_Seq_N PA Reference Line Seq No Long Integer 4
PAexptdate PA Export Date Date 4
PABilling_StatusN PA Billing Status1 = Billable2 = In Process3 = Closed4 = Non-Billable5 = Fixed Fee Trx Integer 2
PAUD1 PA User Defined 1 String 22
PAUD2 PA User Defined 2 String 22
PAprjclsid PA Project Class ID String 16
CUSTCLAS Customer Class String 16
PAcontclassid PA Contract Class ID String 16
PACOSTCATCLASID PA Cost Category Class ID String 16
PAPayCode PA Pay Code String 8
STATECD State Code String 4
LOCLCODE Local Code String 8
SUTASTAT Suta State String 4
WRKRCOMP Workers Comp String 8
PASalary_Posting_Type PA Salary Posting Type Integer 2
PAJob_Title PA Job Title String 8
PADepartment PA Department String 8
PABilled_QtyN PA Billed Qty Currency 10
PABilledTax PA Billed Tax Currency 10
PABilled_Misc PA Billed Misc Currency 10
PAProfitType PA Profit Type1 = Billing Rate2 = Markup3 = Profit/Unit Fixed4 = Profit/Unit Variable5 = Total Profit6 = % of Baseline7 = % of Actual8 = None9 = Price Level Integer 2
PAProfitAmount PA Profit Amount Currency 10
PAORIGPROFAMT PA Originating Profit Amount Currency 10
PAProfitPercent PA Profit Percent Currency 10
PATotalProfit PA Total Profit Currency 10
PAORIGTOTPROF PA Originating Total Profit Currency 10
PAApproved_Quantity PA Approved Quantity Currency 10
PAAPPROVBILLRATE PA Approved Billing Rate Currency 10
PAAPPROVMKUPPCT PA Approved Markup Percentage Currency 10
PAApproved_Billing_Amou PA Approved Billing Amount Currency 10
PA_Billed_Profit_Amount_ PA Billed Profit Amount Average Currency 10
PABilledProfitPercentage PA Billed Profit Percentage Average Currency 10
PABilled_Amount PA Billed Amount Currency 10
PABilled_Freight PA Billed Freight Currency 10
PABilled_Discount PA Billed Discount Currency 10
PAWrite_UpDown_Amount PA Write Up/Down Amount Currency 10
PAWrite_UpDown_Percenta PA Write Up/Down Percentage Long Integer 4
PAApprover_ID PA Approver ID String 16
PAApprover_Type PA Approver Type Integer 2
PAPartial_Bill PA Partial Bill Boolean 2
PACGBWIPIDX PA WIP IDX Long Integer 4
PAUnbilled_AR_Idx PA Unbilled AR IDX Long Integer 4
PAUnbilled_Proj_Rev_Idx PA Unbilled Proj Rev IDX Long Integer 4
PAOverhead_IDX PA Overhead IDX Long Integer 4
PAContra_Account_IDX PA Contra Account IDX Long Integer 4
PACogs_Idx PA COGS IDX Long Integer 4
PAPaymentMethod PA Payment Method Integer 2
PAExpenseType PA Expense Type Integer 2
LOCNCODE Location Code String 12
PRICELVL Price Level String 16
IVIVINDX IV IV Index Long Integer 4
IVIVOFAC_1 IV IV Offset Account:Account_Segment_Pool1 String 10
IVIVOFAC_2 IV IV Offset Account:Account_Segment_Pool2 String 10
IVIVOFAC_3 IV IV Offset Account:Account_Segment_Pool3 String 10
IVIVOFAC_4 IV IV Offset Account:Account_Segment_Pool4 String 10
IVIVOFAC_5 IV IV Offset Account:Account_Segment_Pool5 String 10

Related Tables

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

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

LNITMSEQ

ASIEXP20 ASIEXP25 ASIEXP26 DO10100 EDCEI006 EEPAIVRQ ERB10300 ERB10700

PAPROJNUMBER

PA00402 PA00502 PA00503 PA01201 PA01221 PA01241 PA01251 PA01301

TAXAMNT

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP20 ASIEXP21 ASIEXP25 ASIEXP26

TRDISAMT

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP20 ASIEXP21 ASIEXP25 ASIEXP26

UOMSCHDL

AAG00400 ADItemP2 ADItemPr ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21

PACONTNUMBER

PA01101 PA01121 PA01141 PA01161 PA01201 PA10001 PA10101 PA10201

LOCNCODE

ASIEXP04 ASIEXP06 ASIEXP11 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23

PACOSTCATID

PA01001 PA01301 PA01303 PA01304 PA01341 PA01342 PA10001 PA10101

EMPLOYID

AAG10001 AAG20001 AAG30001 AAG40001 AHPSLH01 ASIEXP05 ASIEXP10 ASIEXP18