GP Tables

PA12000 - PA Change Order Header WORK

Dynamics GP table PA12000 (PA Change Order Header WORK) contains 41 columns including PACHGORDNO, PACREATEADDFLY, PACONTNUMBER....

SQL Query Builder

41 Columns

Column Description Type Length
PACHGORDNO PA Change Order Number String 18
PACREATEADDFLY PA Created Add On the Fly Boolean 2
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
PAPREVBEGINDT PA Prev Begin Date Date 4
PAbegindate PA Begin Date Date 4
PAPREVENDDT PA Prev End 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
PAPREVPROJAMT PA Prev Project Amount Currency 10
PAVARPROFAMT PA Variance Profit Amount Currency 10
PAREVPROJAMT PA Revise Project Amount Currency 10
PAProject_Amount PA Project 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
PACOTOTCOST PA Change Order Total Cost Currency 10
PACOTOTBILL PA Change Order Total Billings 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 PA12000. 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 PA13100 PA13200

LSTUSRED

ASIEXP08 ASIEXP25 CN01400 ICJC9000 IVC10100 IVC30101 PA13100 PA23100

PAEnDate

PA02101 PA10500 PA12001 PA12101 PA12102 PA23400 PA23401 PA30500

PAProject_Amount

PA00501 PA01101 PA01201 PA01301 PA11901 PA12001 PA23302 PA23400

PAbegindate

PA02101 PA12001 PA12101 PA12102 PA23400 PA23401 PA33701 PA33702