Encumbrance Received Transactions (ENC10500)

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

Display Name: Encumbrance Received Transactions
Physical Name: ENC10500
Technical Name: ENC_PORcptApply

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	POPTYPE	POP Type	Integer	DDL_POP_Type	0
4	POPRCTNM	POP Receipt Number	String	STR17_POP_Number	17
5	RCPTLNNM	Receipt Line Number	Long Integer	LI_Sequence_Number	10
6	Status	Status	Integer	INT	0
7	GLPOSTDT	GL Posting Date	Date	DT	8
8	TRXDATE	TRX Date	Date	DT_Date	6
9	YEAR1	Year	Integer	Year	4
10	PERIODID	Period ID	Integer	INT3	3
11	QTYSHPPD	QTY Shipped	Currency	DLR17_QTY_RBS0_UTR	17
12	QTYINVCD	QTY Invoiced	Currency	DLR17_QTY_RBS0_UTR	17
13	QTYRESERVED	QTY Reserved	Currency	DLR17_QTY_RBS0_UTR	17
14	INVINDX	Inventory Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Encumbrance Received Transactions'].INVINDX AS 'Encumbrance Received Transactions-Inventory Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM ENC10500 AS ['Encumbrance Received Transactions'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Encumbrance Received Transactions'].INVINDX = ['Account Index Master'].ACTINDX
15	UOFM	U Of M	String	U_Of_M	8
16	UMDPQTYS	U Of M Decimal Places QTYS	Integer	DDL_Decimal_Places_QTYS	0
17	UMQTYINB	U Of M QTY In Base	Currency	DLR17_QTY_RBS0_STR	17
18	OREXTCST	Originating Extended Cost	Currency	DLR17_RBS0_UTR$	17
19	LIQUDAMT	Liquidated Amount	Currency	DLR19_$S2	19
20	REQDATE	Required Date	Date	DATE_L	0
21	aaDimID	aaDimID	Long Integer	aaLONG_INT	8
22	aaTrxDimID	aaTrxDimID	Long Integer	aaLONG_INT	8