SAP ABAP Table REXCJP_PYMNTREC (Payment record (contract data plus payments))

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ GLO_REFX_JP (Package) Localization Flexible Real Estate Japan

Basic Data

Table Category	INTTAB	Structure
Structure	REXCJP_PYMNTREC	Table Relationship Diagram
Short Description	Payment record (contract data plus payments)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Contract specific data
2	CNBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	RECNR	☐	RECNNUMBER	RECNNUMBER	CHAR	13	0	Contract Number
4	VENDORID	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
5	PYMENTCAT	☐	REXCJPPCRCAT	REXCJPPCRCAT	CHAR	3	0	Payment Category
6	RECNTYPE	☐	RECNCONTRACTTYPE	SMVART	CHAR	4	0	Contract Type	*
7	BP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
8	BP_TYPE	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
9	BP_ROLE	☐	BU_ROLE	BU_RLTYP	CHAR	6	0	BP role	*
10	BP_NAME	☐	REXCJP_PAYEE_NAME	TEXT30	CHAR	30	0	Name of Payee
11	BPADDR	☐	REXCJP_PAYEE_ADDR	TEXT120	CHAR	120	0	Payee's Address
12	BP_COUNTRY	☐	REXCJP_BP_COUNTRY	LAND1	CHAR	3	0	Payee's Country	*
13	FLOWTYPE	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
14	AGENT	☐	REXCJPAGENTBP	BU_PARTNER	CHAR	10	0	Real Estate Agent's Business Partner	*
15	AGENT_NAME	☐	REXCJP_BR_NAME	TEXT30	CHAR	30	0	Real Estate Agent's Name
16	AGENTADDR	☐	REXCJP_AGENT_ADDR	TEXT120	CHAR	120	0	Real Estate Agent's Address
17	AGENT_COUNTRY	☐	REXCJP_AGENT_COUNTRY	LAND1	CHAR	3	0	Real Estate Agent's Country	*
18	AGENT_TYPE	☐	REXCJP_BR_TYPE	BU_TYPE	CHAR	1	0	Real Estate Agent's BP Type
19	RECNINTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
20	REOBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
21	XIDENT	☐	RECAXIDENT	TEXT80	CHAR	80	0	Object ID, for Example, Business Entity 1000/123
22	XOBJTYPE	☐	RECAXOBJTYPE	CHAR3	CHAR	3	0	Partial Object Type ID, for example "BE"
23	OBJADDR	☐	REXCJPOBJADDR	TEXT120	CHAR	120	0	Object address (merged)
24	COMMISSION	☐	REXCJP_COMMISSION	RECABOOL	CHAR	1	0	Agent commission
25	BASIS	☐	REXCJP_PR_BASIS	CHAR15	CHAR	15	0	Basis for Calculation
26	DETAIL	☐	REXCJP_PR_DETAIL	CHAR15	CHAR	15	0	Payment Details
27	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
28	.INCLUDE	☐				0	0	Data structure defined for PDF output
29	PDF_BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
30	.INCLUDE	☐				0	0	Payment data for the output into a file
31	N01_REPTYPE	☐	REXCJP_REPTYPE	CHAR3	CHAR	3	0	Type of Payment Report
32	N02_REFNR1	☐	REXCJP_REF_NUM_1	CHAR10	CHAR	10	0	Company Reference Number 1
33	N03_OFFCAT	☐	REXCJP_OFF_CAT	CHAR5	CHAR	5	0	Reporting Office Category
34	N04RESP_ADDR	☐	REXCJP_RESP1_ADDR	TEXT120	CHAR	120	0	Responsible Filer's Address
35	N05_REP1	☐	REXCJP_RESP_NAME	TEXT30	CHAR	30	0	Responsible Filer's Name
36	N06_REP1TEL	☐	REXCJP_RESP_TEL	CHAR30	CHAR	30	0	Responsible Filer's Telephone Number
37	N07_REFNR2	☐	REXCJP_REF_NUM_2	CHAR13	CHAR	13	0	Company Reference Number 2
38	N08FILER_ADDR	☐	REXCJP_FILER_ADDR	TEXT120	CHAR	120	0	Filer's address
39	N09_REP2	☐	REXCJP_FILER_NAME	TEXT30	CHAR	30	0	Filer's name
40	N10_CORRIND	☐	REXCJP_CORRIND	CHAR1	CHAR	1	0	Correction indicator
41	N11_REPERA	☐	REXCJP_RYEARERAW	CHAR20	CHAR	20	0	Reporting year era (in Wareki)
42	N11_REPYEAR	☐	REXCJP_RYEARW	CHAR3	CHAR	3	0	Reporting Year (in Wareki)
43	N12PAYEE_ADDR	☐	REXCJP_PAYEE_ADDR	TEXT120	CHAR	120	0	Payee's Address
44	N13_PAYFA	☐	REXCJP_PYFA_IND	REXCJP_FAIND	CHAR	1	0	Payee's Foreign Address Indicator
45	N14_PAYEE	☐	REXCJP_PAYEE_NAME	TEXT30	CHAR	30	0	Name of Payee
46	N15_PAYEECAT	☐	REXCJP_PAYEE_CAT	CHAR1	CHAR	1	0	Private/Corporate Category
47	N16_PYMNTCAT1	☐	REXCJPXPCRCAT	TEXT15	CHAR	15	0	Payment Category Description
48	N17PYMNT1_ADDR	☐	REXCJP_PYMNT1_ADDR	TEXT120	CHAR	120	0	Address of 1st Charged Object
49	N18_PYMNTDET1	☐	REXCJP_PR_DETAIL	CHAR15	CHAR	15	0	Payment Details
50	N19_PYMNTBAS1	☐	REXCJP_PR_BASIS	CHAR15	CHAR	15	0	Basis for Calculation
51	N20_PYMNTAM1	☐	REXCJP_PYMNTAM	WERT7	CURR	13	2	Payment Amount
52	N21_PYMNTCAT2	☐	REXCJPXPCRCAT	TEXT15	CHAR	15	0	Payment Category Description
53	N22PYMNT2_ADDR	☐	REXCJP_PYMNT2_ADDR	TEXT120	CHAR	120	0	Address of 2nd Charged Object
54	N23_PYMNTDET2	☐	REXCJP_PR_DETAIL	CHAR15	CHAR	15	0	Payment Details
55	N24_PYMNTBAS2	☐	REXCJP_PR_BASIS	CHAR15	CHAR	15	0	Basis for Calculation
56	N25_PYMNTAM2	☐	REXCJP_PYMNTAM	WERT7	CURR	13	2	Payment Amount
57	N26_PYMNTCAT3	☐	REXCJPXPCRCAT	TEXT15	CHAR	15	0	Payment Category Description
58	N27PYMNT3_ADDR	☐	REXCJP_PYMNT3_ADDR	TEXT120	CHAR	120	0	Address of 3rd Charged Object
59	N28_PYMNTDET3	☐	REXCJP_PR_DETAIL	CHAR15	CHAR	15	0	Payment Details
60	N29_PYMNTBAS3	☐	REXCJP_PR_BASIS	CHAR15	CHAR	15	0	Basis for Calculation
61	N30_PYMNTAM3	☐	REXCJP_PYMNTAM	WERT7	CURR	13	2	Payment Amount
62	N31AGENT_ADDR	☐	REXCJP_AGENT_ADDR	TEXT120	CHAR	120	0	Real Estate Agent's Address
63	N32_BRFA	☐	REXCJP_BRFA_IND	REXCJP_FAIND	CHAR	1	0	Real Estate Agent's foreign address indicator
64	N33_BRNAME	☐	REXCJP_BR_NAME	TEXT30	CHAR	30	0	Real Estate Agent's Name
65	N34_BRCAT	☐	REXCJP_BR_CAT	CHAR1	CHAR	1	0	Agent's Private/Corporate Category
66	N35_BRYEAR	☐	REXCJP_BRYEARW	CHAR3	CHAR	3	0	Year of Payment Confirmed (in Wareki)
67	N35_BRMONTH	☐	REXCJP_BRMONTHW	CHAR2	CHAR	2	0	Month of Payment Confirmed
68	N35_BRDAY	☐	REXCJP_BRDAYW	CHAR2	CHAR	2	0	Day of Payment Confirmed
69	N38_BRFEE	☐	REXCJP_BRFEE	WERT7	CURR	13	2	Agent's Fee
70	N39_REMARK	☐	REXCJP_REMARKS	CHAR40	CHAR	40	0	Remarks
71	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
72	N04RESP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
73	N08FILER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
74	N12PAYEE	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
75	N17PYMNT1	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
76	N22PYMNT2	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
77	N27PYMNT3	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
78	N31AGENT	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
79	N40_TAX_OFFICE	☐	REXCJP_TAX_OFFICE	CHAR10	CHAR	10	0	Tax Office Number
80	.INCLUDE	☐				0	0	Payment specific data
81	.INCLUDE	☐				0	0	Accounting: Secondary Index for Vendors (Cleared Items)
82	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
83	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	LFB1
84	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
85	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
86	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
87	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
88	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
89	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
90	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
91	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
92	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
93	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
94	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
95	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
96	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
97	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
98	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
99	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
100	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
101	ZUMSK	☐	DZUMSK	UMSKZ	CHAR	1	0	Target Special G/L Indicator	*
102	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
103	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
104	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
105	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
106	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
107	MWSTS	☐	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
108	WMWST	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
109	BDIFF	☐	BDIFF	WRTV7	CURR	13	2	Valuation Difference
110	BDIF2	☐	BDIF2	WRTV7	CURR	13	2	Valuation Difference for the Second Local Currency
111	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
112	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
113	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
114	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
115	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
116	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
117	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
118	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
119	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
120	FKONT	☐	FIPLS	FIPLS	NUMC	3	0	Financial Budget Item
121	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
122	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
123	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
124	ZBD1T	☐	DZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
125	ZBD2T	☐	DZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
126	ZBD3T	☐	DZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
127	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
128	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
129	SKFBT	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
130	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
131	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
132	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
133	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
134	ZBFIX	☐	DZBFIX	ZBFIX	CHAR	1	0	Fixed Payment Terms
135	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
136	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
137	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
138	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
139	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
140	SAMNR	☐	SAMNR	SAMNR	NUMC	8	0	Invoice List Number
141	ZOLLT	☐	DZOLLT	ZOLLT	CHAR	8	0	Customs Tariff Number
142	ZOLLD	☐	DZOLLD	DATUM	DATS	8	0	Customs Date
143	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	*
144	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country	*
145	DIEKZ	☐	DIEKZ	DIEKZ	CHAR	1	0	Service indicator (foreign payment)
146	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
147	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	*
148	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
149	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
150	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
151	XNETB	☐	XNETB	XFELD	CHAR	1	0	Indicator: Document posted net ?
152	XANET	☐	XANET	XFELD	CHAR	1	0	Indicator: Down Payment in Net Procedure?
153	XCPDD	☐	XCPDD	XFELD	CHAR	1	0	Indicator: Address and Bank Data Set Individually
154	XESRD	☐	XESRD	XFELD	CHAR	1	0	Indicator: Is any ISR data set in the document ?
155	XZAHL	☐	XZAHL	XFELD	CHAR	1	0	Indicator: Is Posting Key Used in a Payment Transaction?
156	MWSK1	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	*
157	DMBT1	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
158	WRBT1	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
159	MWSK2	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	*
160	DMBT2	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
161	WRBT2	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
162	MWSK3	☐	MWSKX	MWSKZ	CHAR	2	0	Tax Code for Distribution	*
163	DMBT3	☐	DMBTX	WRTV7	CURR	13	2	Amount in Local Currency for Tax Distribution
164	WRBT3	☐	WRBTX	WRTV7	CURR	13	2	Amount in foreign currency for tax breakdown
165	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
166	QSSHB	☐	QSSHB	WERT7	CURR	13	2	Withholding Tax Base Amount
167	QBSHB	☐	QBSHB	WERT7	CURR	13	2	Withholding Tax Amount (in Document Currency)
168	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
169	ANFBN	☐	ANFBN	BELNR	CHAR	10	0	Document Number of the Bill of Exchange Payment Request
170	ANFBJ	☐	ANFBJ	GJAHR	NUMC	4	0	Fiscal Year of the Bill of Exchange Payment Request Document
171	ANFBU	☐	ANFBU	BUKRS	CHAR	4	0	Company Code in Which Bill of Exch.Payment Request Is Posted	*
172	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
173	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
174	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
175	EGBLD	☐	EGBLD	LAND1	CHAR	3	0	Country of Destination for Delivery of Goods	*
176	EGLLD	☐	EGLLD	LAND1	CHAR	3	0	Supplying Country for Delivery of Goods	*
177	QSZNR	☐	QSZNR	CHAR10	CHAR	10	0	Certificate Number of the Withholding Tax Exemption
178	QSFBT	☐	QSFBT	WERT7	CURR	13	2	Withholding Tax-Exempt Amount (in Document Currency)
179	XINVE	☐	XINVE	XFELD	CHAR	1	0	Indicator: Capital Goods Affected?
180	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
181	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
182	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
183	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
184	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
185	XEGDR	☐	XEGDR	XFELD	CHAR	1	0	Indicator: Triangular deal within the EU ?
186	DMBE2	☐	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
187	DMBE3	☐	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
188	DMB21	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
189	DMB22	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
190	DMB23	☐	DMB2X	WRTV7	CURR	13	2	Amount in Second Local Currency for Tax Breakdown
191	DMB31	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
192	DMB32	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
193	DMB33	☐	DMB3X	WRTV7	CURR	13	2	Amount in Third Local Currency for Tax Breakdown
194	MWST2	☐	MWST2	WERT7	CURR	13	2	Tax Amount in Second Local Currency
195	MWST3	☐	MWST3	WERT7	CURR	13	2	Tax Amount in Third Local Currency
196	SKNT2	☐	SKNT2	WERT7	CURR	13	2	Cash Discount Amount in Second Local Currency
197	SKNT3	☐	SKNT3	WERT7	CURR	13	2	Cash Discount Amount in Third Local Currency
198	BDIF3	☐	BDIF3	WRTV7	CURR	13	2	Valuation Difference for the Third Local Currency
199	XRAGL	☐	XRAGL	XFELD	CHAR	1	0	Indicator: Clearing was Reversed
200	RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	*
201	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
202	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
203	LNRAN	☐	LNRAN	LNRAN	NUMC	5	0	Sequence Number of Asset Line Items in Fiscal Year	ANEK
204	XSTOV	☐	XSTOV	XFELD	CHAR	1	0	Indicator: Document is flagged for reversal
205	KZBTR	☐	KZBTR_FI	WERT7	CURR	13	2	Original Reduction Amount in Local Currency
206	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
207	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
208	XARCH	☐	XARCH	XFELD	CHAR	1	0	Indicator: Document already archived ?
209	PSWSL	☐	PSWSL	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	TCURC
210	PSWBT	☐	PSWBT	WERT7	CURR	13	2	Amount for Updating in General Ledger
211	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
212	ZEKKN	☐	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
213	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
214	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
215	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
216	XNEGP	☐	XNEGP	XFELD	CHAR	1	0	Indicator: Negative posting
217	EMPFB	☐	EMPFB	MAXKK	CHAR	10	0	Payee/Payer
218	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
219	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
220	DTWS1	☐	DTAT16	DTWSX	NUMC	2	0	Instruction key 1	*
221	DTWS2	☐	DTAT17	DTWSX	NUMC	2	0	Instruction key 2	*
222	DTWS3	☐	DTAT18	DTWSX	NUMC	2	0	Instruction key 3	*
223	DTWS4	☐	DTAT19	DTWSX	NUMC	2	0	Instruction key 4	*
224	XPYPR	☐	XPYPR	XFELD	CHAR	1	0	Indicator: Items from Payment Program Blocked
225	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
226	PYCUR	☐	PYCUR	WAERS	CUKY	5	0	Currency for Automatic Payment	*
227	PYAMT	☐	PYAMT	WERT7	CURR	13	2	Amount in Payment Currency
228	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
229	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	*
230	PPDIFF	☐	PPDIFF	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)
231	PPDIF2	☐	PPDIF2	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)
232	PPDIF3	☐	PPDIF3	WRTV7	CURR	13	2	Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)
233	PENLC1	☐	PENALTY1	WERT13	CURR	13	2	Penalty Charge Amount in First Local Currency
234	PENLC2	☐	PENALTY2	WERT13	CURR	13	2	Penalty Charge Amount in Second Local Currency
235	PENLC3	☐	PENALTY3	WERT13	CURR	13	2	Penalty Charge Amount in Third Local Currency
236	PENFC	☐	PENALTY	WERT13	CURR	13	2	Penalty Charge Amount in Document Currency
237	PENDAYS	☐	PDAYS	INT4	INT4	10	0	Number of Days for Penalty Charge Calculation
238	PENRC	☐	PENRC	CHAR2	CHAR	2	0	Reason for Late Payment
239	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
240	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
241	VBEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
242	KBLNR	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds	*
243	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
244	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
245	GMVKZ	☐	FM_GMVKZ	FM_GMVKZ	CHAR	1	0	Item is in Execution
246	SRTYPE	☐	FM_SRTYPE	FM_SRTYPE	CHAR	2	0	Type of Additional Receivable
247	LOTKZ	☐	PSO_LOTKZ	LOTKZ	CHAR	10	0	Lot Number for Requests
248	ZINKZ	☐	DZINKZ	ZINKZ	CHAR	2	0	Exempted from Interest Calculation
249	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
250	INTRENO	☐	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
251	PPRCT	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
252	BUZID	☐	BUZID	CHAR1	CHAR	1	0	Identification of the Line Item
253	AUGGJ	☐	AUGGJ	GJAHR	NUMC	4	0	Fiscal Year of Clearing Document
254	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	*
255	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
256	.INCLU--AP	☐				0	0	IS-PS: Data appendix of cleared items vendor
257	KONTT	☐	KONTT_FI	KONTT_FI	CHAR	2	0	Account Assignment Category for Industry Solution
258	KONTL	☐	KONTL_FI	CHAR50	CHAR	50	0	Acct assignment string for industry-specific acct assignmnts
259	UEBGDAT	☐	UEBGDAT	DATUM	DATS	8	0	Transfer date of an item to legal dunning proceeding
260	.INCLU--AP	☐				0	0	Joint Venture Fields
261	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
262	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	T8JF
263	BTYPE	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	T8JA
264	.INCLU--AP	☐				0	0	Append zur Mandatsverwaltung BSAK
265	.INCLUDE	☐				0	0	Append Struktur für die Mandatsnummer
266	PROPMANO	☐	REHORECNNRM	RECNNR	CHAR	13	0	Mandate, Mandate-Opening Contract
267	WRBTRV	☐	REXCJP_AMOUNT	WERTV7	CURR	13	2	Signed Amount in Document Currency
268	PAYMENTCAT	☐	REXCJPPCRCAT	REXCJPPCRCAT	CHAR	3	0	Payment Category
269	PAYMENTCATT	☐	REXCJPXPCRCAT	TEXT15	CHAR	15	0	Payment Category Description
270	LOCATION	☐	REXCJP_LOC_ADDR	TEXT120	CHAR	120	0	Payment's location
271	OBJECTNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
272	CONTRACTINTRENO	☐	RECAINTRENO	RECAINTRENO	CHAR	13	0	Internal Key of Real Estate Object
273	PYMNTCATOK	☐	RECABOOL	RECABOOL	CHAR	1	0	General Yes/No Field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	REXCJP_PYMNTREC	BTYPE	T8JA	BILIND	REF	C	CN
2	REXCJP_PYMNTREC	BUKRS	LFB1	BUKRS	KEY	1	CN
3	REXCJP_PYMNTREC	EGRUP	T8JF	EGRUP	REF	C	CN
4	REXCJP_PYMNTREC	LIFNR	LFA1	LIFNR	KEY	1	CN
5	REXCJP_PYMNTREC	LNRAN	ANEK	LNRAN	REF	C	CN
6	REXCJP_PYMNTREC	PSWSL	TCURC	WAERS	REF	C	CN
7	REXCJP_PYMNTREC	UZAWE	T042F	UZAWE	REF	C	CN
8	REXCJP_PYMNTREC	VNAME	T8JV	VNAME	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	700