Purchasing Payment Document Settlement Header (RVLPD027)

azurecurve Products Payment Document Management (2150)PurchasingPurchasing Payment Document Settlement Header (RVLPD027)

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

Product: Payment Document Management (2150)
Series:

Display Name: Purchasing Payment Document Settlement Header
Physical Name: RVLPD027
Technical Name: rvlpmPmntDocTRXHDR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	REMTYPE	RemitType	Integer	RemitType	0
2	REMITID	RemitID	String	RemitID	15
3	PMTDOCID	PmntDocID	String	PmntDocID	15
4	OrigPmntDocStatus	OrigPmntDocStatus	Integer	GB	0
5	ORICBOOK	OrigCheckbookID	String	STR15_Checkbook_ID	15
6	DESCBOOK	DestCheckbookID	String	STR15_Checkbook_ID	15
7	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchasing Payment Document Settlement Header'].CURNCYID AS 'Purchasing Payment Document Settlement Header-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM RVLPD027 AS ['Purchasing Payment Document Settlement Header'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchasing Payment Document Settlement Header'].CURNCYID = ['Currency Setup'].CURNCYID
8	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchasing Payment Document Settlement Header'].CURRNIDX AS 'Purchasing Payment Document Settlement Header-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM RVLPD027 AS ['Purchasing Payment Document Settlement Header'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchasing Payment Document Settlement Header'].CURRNIDX = ['Currency Setup'].CURRNIDX
9	MCSTRUCT	MC Def Structure	MC_Def_Structure	Composite	0
10	MCSTRUCT_1	MC Def Structure:Currency ID	String	STR15_Currency_ID	15
11	MCSTRUCT_2	MC Def Structure:Currency Index	Integer	INT3	3
12	MCSTRUCT_3	MC Def Structure:Rate Type ID	String	STR15_Rate_Type_ID	15
13	MCSTRUCT_4	MC Def Structure:Exchange Table ID	String	STR15_Exchange_Table_ID	15
14	MCSTRUCT_5	MC Def Structure:Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
15	MCSTRUCT_6	MC Def Structure:Exchange Date	Date	DT_Date	6
16	MCSTRUCT_7	MC Def Structure:Decimal Places	Integer	DDL_Decimal_Places	0
17	MCSTRUCT_8	MC Def Structure:Time	Time	TM6	6
18	MCSTRUCT_9	MC Def Structure:Rate Calc Method	Integer	INT	0
19	MCSTRUCT_10	MC Def Structure:View Mode	Integer	INT	0
20	MCSTRUCT_11	MC Def Structure:IS MC Trx	Integer	INT	0
21	MCSTRUCT_12	MC Def Structure:Expiration Date	Date	DT_Date	6
22	MCSTRUCT_13	MC Def Structure:Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
23	MCSTRUCT_14	MC Def Structure:MC Transaction State	Integer	INT1	1
24	TRXDATE	TRX Date	Date	DT_Date	6
25	PSTGDATE	Posting Date	Date	DT	8
26	BANKACCT	BankAcct	String	BankAcct	35
27	COMMAMNT	Commission Amount	Currency	DLR17_RBS0_STR$	17
28	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Purchasing Payment Document Settlement Header'].ACTINDX AS 'Purchasing Payment Document Settlement Header-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM RVLPD027 AS ['Purchasing Payment Document Settlement Header'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Purchasing Payment Document Settlement Header'].ACTINDX = ['Account Index Master'].ACTINDX
29	REMTSTAT	RemitStatus	Integer	INT2	2
30	NUMOFTRX	Number Of TRX	Long Integer	LI6_U0	6
31	FUNCTAMT	Functional Amount	Currency	DLR19_$S2	19
32	ORIGAMT	Originating Amount	Currency	DLR19_$S2	19
33	CMRecordNumber	CMRecordNumber	Currency	DLR_Document_Number	19
34	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Purchasing Payment Document Settlement Header'].NOTEINDX AS 'Purchasing Payment Document Settlement Header-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM RVLPD027 AS ['Purchasing Payment Document Settlement Header'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Purchasing Payment Document Settlement Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX

azurecurve Products Payment Document Management (2150)PurchasingPurchasing Payment Document Settlement Header (RVLPD027)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply