Deferral Amounts Temporary (PP50101)

azurecurve Products Revenue Expense Deferrals (1045)FinancialDeferral Amounts Temporary (PP50101)

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

Product: Revenue Expense Deferrals (1045)
Series:

Display Name: Deferral Amounts Temporary
Physical Name: PP50101
Technical Name: PP_Allocation_Register_WORK

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 ['Deferral Amounts Temporary'].USERID AS 'Deferral Amounts Temporary-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PP50101 AS ['Deferral Amounts Temporary'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Deferral Amounts Temporary'].USERID = ['Users Master'].USERID
2	BCHSOURC	Batch Source	String	STR15	15
3	BACHNUMB	Batch Number	String	STR15_LBAU	15
4	JRNENTRY	Journal Entry	Long Integer	LI8_U0	8
5	SQNCLINE	Sequence Line	Currency	DLR19_$S2	19
6	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Deferral Amounts Temporary'].ACTINDX AS 'Deferral Amounts Temporary-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM PP50101 AS ['Deferral Amounts Temporary'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Deferral Amounts Temporary'].ACTINDX = ['Account Index Master'].ACTINDX
7	OFFINDX	Offset Account Index	Long Integer	LI_14	14
8	TRXAMNT	TRX Amount	Currency	DLR19_$S2	19
9	GLLINMSG	GL LINE Messages	Long Integer	ML_GL_LINE_Messages	0
10	GLLINMS2	GL LINE Messages2	Long Integer	ML_GL_LINE_Messages2	0
11	TRXDATE	TRX Date	Date	DT_Date	6
12	ACCTTYPE	Account Type	Integer	DDL_Account_Type	0
13	DSCRIPTN	Description	String	STR30	30
14	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Deferral Amounts Temporary'].CURNCYID AS 'Deferral Amounts Temporary-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM PP50101 AS ['Deferral Amounts Temporary'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Deferral Amounts Temporary'].CURNCYID = ['Currency Setup'].CURNCYID
15	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Deferral Amounts Temporary'].CURRNIDX AS 'Deferral Amounts Temporary-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM PP50101 AS ['Deferral Amounts Temporary'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Deferral Amounts Temporary'].CURRNIDX = ['Currency Setup'].CURRNIDX
16	FUNCRIDX	Functional Currency Index	Integer	INT3	3
17	ORIGAMT	Originating Amount	Currency	DLR19_$S2	19
18	DOCNUMBR	Document Number	String	STR20_Document_Number	20
19	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Deferral Amounts Temporary'].CUSTNMBR AS 'Deferral Amounts Temporary-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM PP50101 AS ['Deferral Amounts Temporary'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Deferral Amounts Temporary'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
20	CUSTNAME	Customer Name	String	STR64_Customer_Name	64
21	DOCDATE	Document Date	Date	DT	8

azurecurve Products Revenue Expense Deferrals (1045)FinancialDeferral Amounts Temporary (PP50101)

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