RM Apply Open File (RM20201)

azurecurve Products Microsoft Dynamics GP (0)SalesRM Apply Open File (RM20201)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Apply Open File
Physical Name: RM20201
Technical Name: RM_Applied_OPEN

Group Display Name: Receivables Open Transaction Files
Group Technical Name: RM_Open_Transaction_Logical_File

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['RM Apply Open File'].CUSTNMBR AS 'RM Apply Open File-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM RM20201 AS ['RM Apply Open File'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['RM Apply Open File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	CPRCSTNM	Corporate Customer Number	String	STR15_RM_Customer_Number	15
3	TRXSORCE	TRX Source	String	STR13	13
4	DATE1	Date	Date	DT6	6
5	TIME1	Time	Time	TM6	6
6	GLPOSTDT	GL Posting Date	Date	DT	8
7	POSTED	Posted	Boolean	True/False	0
8	TAXDTLID	Tax Detail ID	String	STR15_Tax_Detail_ID	15
	Key to the Sales/Purchases Tax Master (TX00201). Click to show/hide SELECT ['RM Apply Open File'].TAXDTLID AS 'RM Apply Open File-Tax Detail ID' ,['Sales/Purchases Tax Master'].TAXDTLID AS 'Sales/Purchases Tax Master-Tax Detail ID' FROM RM20201 AS ['RM Apply Open File'] INNER JOIN TX00201 AS ['Sales/Purchases Tax Master'] ON ['RM Apply Open File'].TAXDTLID = ['Sales/Purchases Tax Master'].TAXDTLID
9	APTODCNM	Apply To Document Number	String	STR20_Document_Number	20
10	APTODCTY	Apply To Document Type	Integer	DDL_Document_Type	0
11	APTODCDT	Apply To Document Date	Date	DT	8
12	ApplyToGLPostDate	Apply To GL Posting Date	Date	DT	8
13	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['RM Apply Open File'].CURNCYID AS 'RM Apply Open File-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM RM20201 AS ['RM Apply Open File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['RM Apply Open File'].CURNCYID = ['Currency Setup'].CURNCYID
14	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['RM Apply Open File'].CURRNIDX AS 'RM Apply Open File-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM RM20201 AS ['RM Apply Open File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['RM Apply Open File'].CURRNIDX = ['Currency Setup'].CURRNIDX
15	APPTOAMT	Apply To Amount	Currency	DLR17_RBS0_UTR$	17
16	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
17	DISAVTKN	Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
18	WROFAMNT	Write Off Amount	Currency	DLR17_RBS0_STR$	17
19	ORAPTOAM	Originating Apply To Amount	Currency	DLR17_RBS0_UTR$	17
20	ORDISTKN	Originating Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
21	ORDATKN	Originating Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
22	ORWROFAM	Originating Write Off Amount	Currency	DLR17_RBS0_STR$	17
23	APTOEXRATE	Apply To Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
24	APTODENRATE	Apply To Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
25	APTORTCLCMETH	Apply To Rate Calc Method	Integer	INT	0
26	APTOMCTRXSTT	Apply To MC Transaction State	Integer	INT	0
27	APFRDCNM	Apply From Document Number	String	STR20_Document_Number	20
28	APFRDCTY	Apply From Document Type	Integer	INT2	2
29	APFRDCDT	Apply From Document Date	Date	DT	8
30	ApplyFromGLPostDate	Apply From GL Posting Date	Date	DT	8
31	FROMCURR	Apply From Currency ID	String	STR15_Currency_ID	15
32	APFRMAPLYAMT	Apply From Apply Amount	Currency	DLR17_RBS0_UTR$	17
33	APFRMDISCTAKEN	Apply From Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
34	APFRMDISCAVAIL	Apply From Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
35	APFRMWROFAMT	Apply From Write Off Amount	Currency	DLR17_RBS0_UTR$	17
36	ActualApplyToAmount	Actual Apply To Amount	Currency	DLR17_RBS0_UTR$	17
37	ActualDiscTakenAmount	Actual Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
38	ActualDiscAvailTaken	Actual Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
39	ActualWriteOffAmount	Actual Write Off Amount	Currency	DLR17_RBS0_UTR$	17
40	APFRMEXRATE	Apply From Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
41	APFRMDENRATE	Apply From Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
42	APFRMRTCLCMETH	Apply From Rate Calc Method	Integer	INT	0
43	APFRMMCTRXSTT	Apply From MC Transaction State	Integer	INT	0
44	APYFRMRNDAMT	Apply From Round Amount	Currency	DLR17_RBS0_STR$	17
45	APYTORNDAMT	Apply To Round Amount	Currency	DLR17_RBS0_STR$	17
46	APYTORNDDISC	Apply To Round Discount	Currency	DLR17_RBS0_STR$	17
47	OAPYFRMRNDAMT	Originating Apply From Round Amount	Currency	DLR17_RBS0_STR$	17
48	OAPYTORNDAMT	Originating Apply To Round Amount	Currency	DLR17_RBS0_STR$	17
49	OAPYTORNDDISC	Originating Apply To Round Discount	Currency	DLR17_RBS0_STR$	17
50	GSTDSAMT	GST Discount Amount	Currency	DLR17_RBS0_STR$	17
51	PPSAMDED	PPS Amount Deducted	Currency	DLR17_RBS0_UTR$	17
52	RLGANLOS	Realized Gain-Loss Amount	Currency	DLR19_$S2	19
53	Settled_Gain_CreditCurrT	Settled Gain CreditCurrTrx	Currency	DLR19_$S2	19
54	Settled_Loss_CreditCurrT	Settled Loss CreditCurrTrx	Currency	DLR19_$S2	19
55	Settled_Gain_DebitCurrTr	Settled Gain DebitCurrTrx	Currency	DLR19_$S2	19
56	Settled_Loss_DebitCurrTr	Settled Loss DebitCurrTrx	Currency	DLR19_$S2	19
57	Settled_Gain_DebitDiscAv	Settled Gain DebitDiscAvail	Currency	DLR19_$S2	19
58	Settled_Loss_DebitDiscAv	Settled Loss DebitDiscAvail	Currency	DLR19_$S2	19
59	Revaluation_Status	Revaluation Status	Integer	INT	0

azurecurve Products Microsoft Dynamics GP (0)SalesRM Apply Open File (RM20201)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply