ENC10119 - Encumbrance Purchase Orders | Prospr

ENC10119 - Encumbrance Purchase Orders

Select * from ENC10119

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
HISTORY	History	Boolean	2	View
PONUMBER	PO Number	String	18	View
ORD	Ord	Long Integer	4	View
POLNESTA	PO Line Status 1 – New 2 – Released 3 – Change Order 4 – Received 5 – Closed 6 – Canceled	Integer	2	View
Status	Status	Integer	2	View
POTYPE	PO Type 1 = Standard 2 = Drop Ship 3 = Blanket 4 = Blanket Drop Ship	Integer	2	View
QTYORDER	QTY Ordered	Currency	10	View
QTYCANCE	QTY Canceled	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
REQDATE	Required Date	Date	4	View
YEAR1	Year	Integer	2	View
PERIODID	Period ID	Integer	2	View
INVINDX	Inventory Index	Long Integer	4	View
ACCTTYPE	Account Type Field values: 1 = Posting Account 2 = Unit Account 3 = Posting Allocation Account 4 = Unit Allocation Account	Integer	2	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
VENDORID	Vendor ID	String	16	View
ACTNUMST	Account Number String	String	130	View
LineNumber	LineNumber	Integer	2	View