GP Tables

PA33701 - PA Change Order Header HIST

Dynamics GP table PA33701 (PA Change Order Header HIST) contains 34 columns including PACHGORDNO, PACONTNUMBER, CUSTNMBR....

SQL Query Builder

34 Columns

Column Description Type Length
PACHGORDNO PA Change Order Number String 18
PACONTNUMBER PA Contract Number String 12
CUSTNMBR Customer Number String 16
PADOCDT PA Document Date Date 4
PACODESC PA Change Order Description String 32
PACOCUSTNO PA Change Order Customer Number String 22
PACOTYPE PA Change Order Type Integer 2
PACOSTATUS PA Change Order Status Integer 2
REQSTDBY Requested By String 22
PAESTBY PA Estimated By String 22
PAREVBY PA Revise By String 16
PAREVPOSITION PA Revision Position String 32
PALSTREVSEDATE PA Last Revised Date Date 4
LSTUSRED Last User to Edit String 16
PAbegindate PA Begin Date Date 4
PAEnDate PA End Date Date 4
PAAPPROVBY PA Approved By String 16
DSCRIPTN Description String 32
APPRVLDT Approval Date Date 4
PAGBTRKCHG PA GB Track Changes Integer 2
PAREVSBUDGMT PA CO Revised Budget Amount Currency 10
PACOREVSFEEAMT PA CO Revised Fee Amount Currency 10
PATOTCHGORDAMT PA Total Change Order Amount Currency 10
PAREVREASON PA Revision Reason String 32
PADOCSTATUS PA Document Status Integer 2
PAsequencenumber PA Sequence Number 1 Integer 2
NOTEINDX Note Index Currency 10
NOTEINDX2 Note Index2 Currency 10
PACOTOTBILL PA Change Order Total Billings Currency 10
PACOTOTCOST PA Change Order Total Cost Currency 10
PACOTOTQTY PA Change Order Total Qty Currency 10
PAVARTOTBILLINGS PA Variance Total Billings Currency 10
PAVARTOTCOST PA Variance Total Cost Currency 10
PAVARTOTQTY PA Variance Total Qty Currency 10

Related Tables

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

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

PACONTNUMBER

PA01101 PA01121 PA01141 PA01161 PA01201 PA10001 PA10101 PA10201

PACHGORDNO

PA01301 PA01303 PA02101 PA05200 PA10001 PA10101 PA10201 PA10501

DSCRIPTN

AHR2AP02 AHR2AP12 ASIEXP08 ASIEXP12 ASIEXP22 ASIEXP26 BE010130 BE020230

PADOCDT

PA10000 PA10100 PA10200 PA10500 PA10900 PA11800 PA12000 PA13100

LSTUSRED

ASIEXP08 ASIEXP25 CN01400 ICJC9000 IVC10100 IVC30101 PA12000 PA13100

PAEnDate

PA02101 PA10500 PA12000 PA12001 PA12101 PA12102 PA23400 PA23401

PAbegindate

PA02101 PA12000 PA12001 PA12101 PA12102 PA23400 PA23401 PA33702

APPRVLDT

BM30100 PA12000 PA12001 PA23400 PA23401 PA33702 PDK10500 POA40003