PA23400 - PA Change Order Header OPEN | Prospr

PA23400 - PA Change Order Header OPEN

Query Builder

Select * from PA23400

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PACHGORDNO	PA Change Order Number	String	18	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
PAbegindate	PA Begin 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
PAProject_Amount	PA Project Amount	Currency	10	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
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
PACOTOTBILL	PA Change Order Total Billings	Currency	10	View
PACOTOTCOST	PA Change Order Total Cost	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

PA23400 - PA Change Order Header OPEN

Query Builder

Customer Service

Information

My Account

Contact Us