Encumbrance AA Purchase Order Line (ENCAA10110)

azurecurve Products Encumbrance Management (3258)PurchasingEncumbrance AA Purchase Order Line (ENCAA10110)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ENCAA10110

Product: Encumbrance Management (3258)
Series:

Display Name: Encumbrance AA Purchase Order Line
Physical Name: ENCAA10110
Technical Name: ENC_aaPOLine

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	PONUMBER	PO Number	String	STR17_POP_Number	17
2	POLNENUM	PO Line Number	Long Integer	LI_Sequence_Number	10
3	aaSubLedgerHdrID	aaSubLedgerHdrID	Long Integer	aaLONG_INT	8
4	aaSubLedgerDistID	aaSubLedgerDistID	Long Integer	aaLONG_INT	8
5	aaSubLedgerAssignID	aaSubLedgerAssignID	Long Integer	aaLONG_INT	8
6	aaTrxDimID	aaTrxDimID	Long Integer	aaLONG_INT	8
7	aaTrxDimCodeID	aaTrxDimCodeID	Long Integer	aaLONG_INT	8
8	aaCodeSequence	aaCodeSequence	Long Integer	aaLONG_INT	8
9	POLNESTA	PO Line Status	Integer	DDL_PO_Line_Status	0
10	ENCBSTAT	Encumbrance Status	Integer	Encumbrance Status	0
11	ENCMBAMT	Encumbered Amount	Currency	DLR19_$S2	19
12	LIQUDAMT	Liquidated Amount	Currency	DLR19_$S2	19
13	Balance	Balance	Currency	DLR19_$S2	19
14	aaAssignedPercent	aaAssignedPercent	Long Integer	aaPercent32	5
15	LIQUIDAT	Liquidated	Boolean	Liquidated	0
16	INVINDX	Inventory Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Encumbrance AA Purchase Order Line'].INVINDX AS 'Encumbrance AA Purchase Order Line-Inventory Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ENCAA10110 AS ['Encumbrance AA Purchase Order Line'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Encumbrance AA Purchase Order Line'].INVINDX = ['Account Index Master'].ACTINDX
17	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Encumbrance AA Purchase Order Line'].ITEMNMBR AS 'Encumbrance AA Purchase Order Line-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM ENCAA10110 AS ['Encumbrance AA Purchase Order Line'] INNER JOIN IV00101 AS ['Item Master'] ON ['Encumbrance AA Purchase Order Line'].ITEMNMBR = ['Item Master'].ITEMNMBR
18	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['Encumbrance AA Purchase Order Line'].VENDORID AS 'Encumbrance AA Purchase Order Line-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM ENCAA10110 AS ['Encumbrance AA Purchase Order Line'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['Encumbrance AA Purchase Order Line'].VENDORID = ['PM Vendor Master File'].VENDORID
19	UOFM	U Of M	String	U_Of_M	8
20	UMQTYINB	U Of M QTY In Base	Currency	DLR17_QTY_RBS0_STR	17
21	QUANTITY	QTY	Currency	DLR17_QTY_RBS0_STR	17
22	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
23	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
24	UNITCOST	Unit Cost	Currency	DLR17_RBS0_UTR$	17
25	EXTDCOST	Extended Cost	Currency	DLR17_RBS0_UTR$	17
26	YEAR1	Year	Integer	Year	4
27	PERIODID	Period ID	Integer	INT3	3
28	REQDATE	Required Date	Date	DATE_L	0
29	ENCBDATE	Encumbered Date	Date	DT	8
30	CRUSRID	Created User ID	String	STR15_User_ID	15
31	CREATDDT	Created Date	Date	DT	8
32	MDFUSRID	Modified User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Encumbrance AA Purchase Order Line'].MDFUSRID AS 'Encumbrance AA Purchase Order Line-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ENCAA10110 AS ['Encumbrance AA Purchase Order Line'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Encumbrance AA Purchase Order Line'].MDFUSRID = ['Users Master'].USERID
33	MODIFDT	Modified Date	Date	DT	8
34	DOCDATE	Document Date	Date	DT	8
35	LINEORIGIN	Line Origin	Integer	DDL_Line_Origin	0
36	POTYPE	PO Type	Integer	DDL_POP_PO_Type	0
37	LineNumber	LineNumber	Integer	INT	0
38	ProjNum	Project Number	String	STR15_LBAU	15
39	CostCatID	Cost Category ID	String	STR15_LBAU	15

azurecurve Products Encumbrance Management (3258)PurchasingEncumbrance AA Purchase Order Line (ENCAA10110)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply