Encumbrance Audit List Temp (ENCAUDIT10)

azurecurve Products Encumbrance Management (3258)PurchasingEncumbrance Audit List Temp (ENCAUDIT10)

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

Product: Encumbrance Management (3258)
Series:

Display Name: Encumbrance Audit List Temp
Physical Name: ENCAUDIT10
Technical Name: ENC_AuditList_Temp

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Encumbrance Audit List Temp'].USERID AS 'Encumbrance Audit List Temp-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM ENCAUDIT10 AS ['Encumbrance Audit List Temp'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Encumbrance Audit List Temp'].USERID = ['Users Master'].USERID
2	WINDOW	Window	Integer	INT	0
3	PONUMBER	PO Number	String	STR17_POP_Number	17
4	POLNENUM	PO Line Number	Long Integer	LI_Sequence_Number	10
5	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10
6	POPRCTNM	POP Receipt Number	String	STR17_POP_Number	17
7	RCPTLNNM	Receipt Line Number	Long Integer	LI_Sequence_Number	10
8	POPTYPE	POP Type	Integer	DDL_POP_Type	0
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	ITEMNMBR	Item Number	String	STR30_Item_Number	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['Encumbrance Audit List Temp'].ITEMNMBR AS 'Encumbrance Audit List Temp-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM ENCAUDIT10 AS ['Encumbrance Audit List Temp'] INNER JOIN IV00101 AS ['Item Master'] ON ['Encumbrance Audit List Temp'].ITEMNMBR = ['Item Master'].ITEMNMBR
14	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['Encumbrance Audit List Temp'].VENDORID AS 'Encumbrance Audit List Temp-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM ENCAUDIT10 AS ['Encumbrance Audit List Temp'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['Encumbrance Audit List Temp'].VENDORID = ['PM Vendor Master File'].VENDORID
15	INVINDX	Inventory Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Encumbrance Audit List Temp'].INVINDX AS 'Encumbrance Audit List Temp-Inventory Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ENCAUDIT10 AS ['Encumbrance Audit List Temp'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Encumbrance Audit List Temp'].INVINDX = ['Account Index Master'].ACTINDX
16	ACTNUMBR_1	Account Number:Account_Segment_Pool1	String	Account_Segment_Pool1	6
17	ACTNUMBR_2	Account Number:Account_Segment_Pool2	String	Account_Segment_Pool2	6
18	ACTNUMBR_3	Account Number:Account_Segment_Pool3	String	Account_Segment_Pool3	6
19	ACTNUMBR_4	Account Number:Account_Segment_Pool4	String	Account_Segment_Pool4	6
20	ACTNUMBR_5	Account Number:Account_Segment_Pool5	String	Account_Segment_Pool5	6
21	ACTNUMBR_6	Account Number:Account_Segment_Pool6	String	Account_Segment_Pool6	6
22	ACTNUMBR_7	Account Number:Account_Segment_Pool7	String	Account_Segment_Pool7	6
23	ACTNUMBR_8	Account Number:Account_Segment_Pool8	String	Account_Segment_Pool8	6
24	ACTNUMBR_9	Account Number:Account_Segment_Pool9	String	Account_Segment_Pool9	6
25	ACTNUMBR_10	Account Number:Account_Segment_Pool10	String	Account_Segment_Pool10	6
26	DECPLCUR	Decimal Places Currency	Integer	DDL_Decimal_Places_Dollars	0
27	DECPLQTY	Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
28	REQDATE	Required Date	Date	DATE_L	0
29	TRXDATE	TRX Date	Date	DT_Date	6
30	CRUSRID	Created User ID	String	STR15_User_ID	15
31	QTYORDER	QTY Ordered	Currency	DLR17_QTY_RBS0_UTR	17
32	QTYCANCE	QTY Canceled	Currency	DLR17_QTY_RBS0_UTR	17
33	QTYSHPPD	QTY Shipped	Currency	DLR17_QTY_RBS0_UTR	17
34	QTYINVCD	QTY Invoiced	Currency	DLR17_QTY_RBS0_UTR	17
35	UNITCOST	Unit Cost	Currency	DLR17_RBS0_UTR$	17
36	UOFM	U Of M	String	U_Of_M	8
37	LINEORIGIN	Line Origin	Integer	DDL_Line_Origin	0
38	POTYPE	PO Type	Integer	DDL_POP_PO_Type	0
39	LineNumber	LineNumber	Integer	INT	0
40	aaSubLedgerHdrID	aaSubLedgerHdrID	Long Integer	aaLONG_INT	8
41	aaSubLedgerDistID	aaSubLedgerDistID	Long Integer	aaLONG_INT	8
42	aaSubLedgerAssignID	aaSubLedgerAssignID	Long Integer	aaLONG_INT	8
43	aaTrxDimID	aaTrxDimID	Long Integer	aaLONG_INT	8
44	aaTrxDimCodeID	aaTrxDimCodeID	Long Integer	aaLONG_INT	8
45	ERRDESCR	Error Description	String	STR130	130
46	ORD	Ord	Long Integer	LI_Sequence_Number	10
47	aaCodeSequence	aaCodeSequence	Long Integer	aaLONG_INT	8
48	aaBudgetLevel	aaBudgetLevel	Text	TX500	500

azurecurve Products Encumbrance Management (3258)PurchasingEncumbrance Audit List Temp (ENCAUDIT10)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply