ENCAA10110 - Encumbrance AA Purchase Order Line | Prospr

ENCAA10110 - Encumbrance AA Purchase Order Line

Query Builder

Select * from ENCAA10110

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
aaSubLedgerHdrID	aaSubLedgerHdrID	Long Integer	4	View
aaSubLedgerDistID	aaSubLedgerDistID	Long Integer	4	View
aaSubLedgerAssignID	aaSubLedgerAssignID	Long Integer	4	View
aaTrxDimID	aaTrxDimID	Long Integer	4	View
aaTrxDimCodeID	aaTrxDimCodeID	Long Integer	4	View
aaCodeSequence	aaCodeSequence	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
LIQUDAMT	Liquidated Amount	Currency	10	View
Balance	Balance	Currency	10	View
aaAssignedPercent	aaAssignedPercent	Long Integer	4	View
LIQUIDAT	Liquidated	Boolean	2	View
INVINDX	Inventory Index	Long Integer	4	View
ITEMNMBR	Item Number	String	32	View
VENDORID	Vendor ID	String	16	View
UOFM	U Of M	String	10	View
UMQTYINB	U Of M QTY In Base	Currency	10	View
QUANTITY	QTY	Currency	10	View
DECPLCUR	Decimal Places Currency	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
UNITCOST	Unit Cost	Currency	10	View
EXTDCOST	Extended Cost	Currency	10	View
YEAR1	Year	Integer	2	View
PERIODID	Period ID	Integer	2	View
REQDATE	Required Date	Date	4	View
ENCBDATE	Encumbered 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
DOCDATE	Document 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

ENCAA10110 - Encumbrance AA Purchase Order Line

Query Builder

Customer Service

Information

My Account

Contact Us