ENC10111 - Encumbrance Purchase Order Line Changes | Prospr

ENC10111 - Encumbrance Purchase Order Line Changes

Select * from ENC10111

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PONUMBER	PO Number	String	18	View
POLNENUM	PO Line Number	Long Integer	4	View
POLNESTA	PO Line Status 1 – New 2 – Released 3 – Change Order 4 – Received 5 – Closed 6 – Canceled	Integer	2	View
ENCBSTAT	Encumbrance Status	Integer	2	View
ENCMBAMT	Encumbered Amount	Currency	10	View
LIQUIDAT	Liquidated	Boolean	2	View
ITEMNMBR	Item Number	String	32	View
VENDORID	Vendor ID	String	16	View
NONINVEN	Non IV	Integer	2	View
INVINDX	Inventory Index	Long Integer	4	View
YEAR1	Year	Integer	2	View
PERIODID	Period ID	Integer	2	View
UOFM	U Of M	String	10	View
UMQTYINB	U Of M QTY In Base	Currency	10	View
QTYORDER	QTY Ordered	Currency	10	View
QTYCANCE	QTY Canceled	Currency	10	View
DECPLCUR	Decimal Places Currency	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
UNITCOST	Unit Cost	Currency	10	View
TRXDATE	TRX Date	Date	4	View
REQDATE	Required Date	Date	4	View
DOCDATE	Document Date	Date	4	View
CRUSRID	Created User ID	String	16	View
CREATDDT	Created Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View
MODIFDT	Modified Date	Date	4	View
LINEORIGIN	Line Origin	Integer	2	View
POTYPE	PO Type 1 = Standard 2 = Drop Ship 3 = Blanket 4 = Blanket Drop Ship	Integer	2	View
LineNumber	LineNumber	Integer	2	View
aaDimID	aaDimID	Long Integer	4	View
aaTrxDimID	aaTrxDimID	Long Integer	4	View