ENCAA10210V - Encumbrance AA Transactions | Prospr

ENCAA10210V - Encumbrance AA Transactions

Select * from ENCAA10210V

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
HISTORY	History	Boolean	2	View
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
Status	Status	Integer	2	View
POTYPE	PO Type 1 = Standard 2 = Drop Ship 3 = Blanket 4 = Blanket Drop Ship	Integer	2	View
EXTDCOST	Extended Cost	Currency	10	View
ENCMBAMT	Encumbered Amount	Currency	10	View
aaAssignedPercent	aaAssignedPercent	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
aaTrxDimCode	aaTrxDimCode	String	32	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
DECPLACS	Decimal Places	Integer	2	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	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