| Column | Description | Data Type | Length | Tables This Field Is In | In Query () | 
| PACHGORDNO | PA Change Order Number  | 
									String | 18 | View | |
| PACREATEADDFLY | PA Created Add On the Fly  | 
									Boolean | 2 | View | |
| PACONTNUMBER | PA Contract Number  | 
									String | 12 | View | |
| CUSTNMBR | Customer Number  | 
									String | 16 | View | |
| PADOCDT | PA Document Date  | 
									Date | 4 | View | |
| PACODESC | PA Change Order Description  | 
									String | 32 | View | |
| PACOCUSTNO | PA Change Order Customer Number  | 
									String | 22 | View | |
| PACOTYPE | PA Change Order Type  | 
									Integer | 2 | View | |
| PACOSTATUS | PA Change Order Status  | 
									Integer | 2 | View | |
| REQSTDBY | Requested By  | 
									String | 22 | View | |
| PAESTBY | PA Estimated By  | 
									String | 22 | View | |
| PAREVBY | PA Revise By  | 
									String | 16 | View | |
| PAREVPOSITION | PA Revision Position  | 
									String | 32 | View | |
| PALSTREVSEDATE | PA Last Revised Date  | 
									Date | 4 | View | |
| LSTUSRED | Last User to Edit  | 
									String | 16 | View | |
| PAPREVBEGINDT | PA Prev Begin Date  | 
									Date | 4 | View | |
| PAbegindate | PA Begin Date  | 
									Date | 4 | View | |
| PAPREVENDDT | PA Prev End Date  | 
									Date | 4 | View | |
| PAEnDate | PA End Date  | 
									Date | 4 | View | |
| PAAPPROVBY | PA Approved By  | 
									String | 16 | View | |
| DSCRIPTN | Description  | 
									String | 32 | View | |
| APPRVLDT | Approval Date  | 
									Date | 4 | View | |
| PAGBTRKCHG | PA GB Track Changes  | 
									Integer | 2 | View | |
| PAREVSBUDGMT | PA CO Revised Budget Amount  | 
									Currency | 10 | View | |
| PACOREVSFEEAMT | PA CO Revised Fee Amount  | 
									Currency | 10 | View | |
| PATOTCHGORDAMT | PA Total Change Order Amount  | 
									Currency | 10 | View | |
| PAPREVPROJAMT | PA Prev Project Amount  | 
									Currency | 10 | View | |
| PAVARPROFAMT | PA Variance Profit Amount  | 
									Currency | 10 | View | |
| PAREVPROJAMT | PA Revise Project Amount  | 
									Currency | 10 | View | |
| PAProject_Amount | PA Project Amount  | 
									Currency | 10 | View | |
| PAREVREASON | PA Revision Reason  | 
									String | 32 | View | |
| PADOCSTATUS | PA Document Status  | 
									Integer | 2 | View | |
| PAsequencenumber | PA Sequence Number 1  | 
									Integer | 2 | View | |
| NOTEINDX | Note Index  | 
									Currency | 10 | View | |
| NOTEINDX2 | Note Index2  | 
									Currency | 10 | View | |
| PACOTOTCOST | PA Change Order Total Cost  | 
									Currency | 10 | View | |
| PACOTOTBILL | PA Change Order Total Billings  | 
									Currency | 10 | View | |
| PACOTOTQTY | PA Change Order Total Qty  | 
									Currency | 10 | View | |
| PAVARTOTBILLINGS | PA Variance Total Billings  | 
									Currency | 10 | View | |
| PAVARTOTCOST | PA Variance Total Cost  | 
									Currency | 10 | View | |
| PAVARTOTQTY | PA Variance Total Qty  | 
									Currency | 10 | View |