ENCAUDIT10 - Encumbrance Audit List Temp | Prospr

ENCAUDIT10 - Encumbrance Audit List Temp

Query Builder

Select * from ENCAUDIT10

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
USERID	User ID	String	16	View
WINDOW	Window	Integer	2	View
PONUMBER	PO Number	String	18	View
POLNENUM	PO Line Number	Long Integer	4	View
SEQNUMBR	Sequence Number	Long Integer	4	View
POPRCTNM	POP Receipt Number	String	18	View
RCPTLNNM	Receipt Line Number	Long Integer	4	View
POPTYPE	POP Type	Integer	2	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
ITEMNMBR	Item Number	String	32	View
VENDORID	Vendor ID	String	16	View
INVINDX	Inventory Index	Long Integer	4	View
ACTNUMBR_1	Account Number:Account_Segment_Pool1	String	10	View
ACTNUMBR_2	Account Number:Account_Segment_Pool2	String	10	View
ACTNUMBR_3	Account Number:Account_Segment_Pool3	String	10	View
ACTNUMBR_4	Account Number:Account_Segment_Pool4	String	10	View
ACTNUMBR_5	Account Number:Account_Segment_Pool5	String	10	View
DECPLCUR	Decimal Places Currency	Integer	2	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
REQDATE	Required Date	Date	4	View
TRXDATE	TRX Date	Date	4	View
CRUSRID	Created User ID	String	16	View
QTYORDER	QTY Ordered	Currency	10	View
QTYCANCE	QTY Canceled	Currency	10	View
QTYSHPPD	QTY Shipped	Currency	10	View
QTYINVCD	QTY Invoiced	Currency	10	View
UNITCOST	Unit Cost	Currency	10	View
UOFM	U Of M	String	10	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
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
ERRDESCR	Error Description	String	132	View
ORD	Ord	Long Integer	4	View
aaCodeSequence	aaCodeSequence	Long Integer	4	View
aaBudgetLevel	aaBudgetLevel	Text	2	View

ENCAUDIT10 - Encumbrance Audit List Temp

Query Builder

Customer Service

Information

My Account

Contact Us