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 |