Encumbrance AA Transactions (ENCAA10210V)

azurecurve Products Encumbrance Management (3258)PurchasingEncumbrance AA Transactions (ENCAA10210V)

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

Product: Encumbrance Management (3258)
Series:

Display Name: Encumbrance AA Transactions
Physical Name: ENCAA10210V
Technical Name: ENC_aaTrx

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	HISTORY	History	Boolean	CB_History	0
2	PONUMBER	PO Number	String	STR17_POP_Number	17
3	POLNENUM	PO Line Number	Long Integer	LI_Sequence_Number	10
4	POLNESTA	PO Line Status	Integer	DDL_PO_Line_Status	0
5	Status	Status	Integer	INT	0
6	POTYPE	PO Type	Integer	DDL_POP_PO_Type	0
7	EXTDCOST	Extended Cost	Currency	DLR17_RBS0_UTR$	17
8	ENCMBAMT	Encumbered Amount	Currency	DLR19_$S2	19
9	aaAssignedPercent	aaAssignedPercent	Long Integer	aaPercent32	5
10	aaSubLedgerHdrID	aaSubLedgerHdrID	Long Integer	aaLONG_INT	8
11	aaSubLedgerDistID	aaSubLedgerDistID	Long Integer	aaLONG_INT	8
12	aaSubLedgerAssignID	aaSubLedgerAssignID	Long Integer	aaLONG_INT	8
13	aaTrxDimID	aaTrxDimID	Long Integer	aaLONG_INT	8
14	aaTrxDimCodeID	aaTrxDimCodeID	Long Integer	aaLONG_INT	8
15	aaTrxDimCode	aaTrxDimCode	String	aaSTR30_LBAU	30
16	REQDATE	Required Date	Date	DATE_L	0
17	YEAR1	Year	Integer	Year	4
18	PERIODID	Period ID	Integer	INT3	3
19	INVINDX	Inventory Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Encumbrance AA Transactions'].INVINDX AS 'Encumbrance AA Transactions-Inventory Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ENCAA10210V AS ['Encumbrance AA Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Encumbrance AA Transactions'].INVINDX = ['Account Index Master'].ACTINDX
20	ACCTTYPE	Account Type	Integer	DDL_Account_Type	0
21	DECPLACS	Decimal Places	Integer	DDL_Decimal_Places	0
22	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Encumbrance AA Transactions'].CURNCYID AS 'Encumbrance AA Transactions-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM ENCAA10210V AS ['Encumbrance AA Transactions'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Encumbrance AA Transactions'].CURNCYID = ['Currency Setup'].CURNCYID
23	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Encumbrance AA Transactions'].CURRNIDX AS 'Encumbrance AA Transactions-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM ENCAA10210V AS ['Encumbrance AA Transactions'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Encumbrance AA Transactions'].CURRNIDX = ['Currency Setup'].CURRNIDX
24	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Encumbrance AA Transactions'].ITEMNMBR AS 'Encumbrance AA Transactions-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM ENCAA10210V AS ['Encumbrance AA Transactions'] INNER JOIN IV00101 AS ['Item Master'] ON ['Encumbrance AA Transactions'].ITEMNMBR = ['Item Master'].ITEMNMBR
25	ITEMDESC	Item Description	String	STR100	100
26	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['Encumbrance AA Transactions'].VENDORID AS 'Encumbrance AA Transactions-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM ENCAA10210V AS ['Encumbrance AA Transactions'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['Encumbrance AA Transactions'].VENDORID = ['PM Vendor Master File'].VENDORID
27	ACTNUMST	Account Number String	String	STR128_LBU	128
28	LineNumber	LineNumber	Integer	INT	0

azurecurve Products Encumbrance Management (3258)PurchasingEncumbrance AA Transactions (ENCAA10210V)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply