SAP Table J_3RCLRSEL (Vendor/customer open item auto clearing program structure)

Field Description Data Type Length Decimals Checktable Data Element
LINK Text field length 200 CHAR 200 0 CHAR200
KUNNR Customer Number CHAR 10 0 KUNNR
LIFNR Account Number of Supplier CHAR 10 0 LIFNR
BUKRS Company Code CHAR 4 0 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
BLDAT Document Date in Document DATS 8 0 BLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT
UMSKZ Special G/L Indicator CHAR 1 0 UMSKZ
UMSKS Special G/L Transaction Type CHAR 1 0 UMSKS
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
DMBTR Amount in local currency CURR 23 2 DMBTR
WRBTR Amount in document currency CURR 23 2 WRBTR
CLRNG Clearing currency amount CURR 23 2 J_3RCLRNG
WAERS Currency Key CUKY 5 0 WAERS
BEDG1 Criterion 1 CHAR 30 0 BED1_F123
BEDG2 Criterion 2 CHAR 30 0 BED2_F123
BEDG3 Criterion 3 CHAR 30 0 BED3_F123
BEDG4 Criterion 4 CHAR 30 0 BED4_F123
BEDG5 Criterion 5 CHAR 30 0 BED5_F123
DIFSUMMA Cleared CURR 23 2 J_3RCLEAR
REBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
REBZZ Line Item in the Relevant Invoice NUMC 3 0 REBZZ
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) NUMC 4 0 REBZJ
REBZT Follow-On Document Type CHAR 1 0 REBZT
SRTPR Individual, User-Defined Character CHAR 1 0 CHAR0001
QUANT Iteration quantity CHAR 3 0 J_3RFCHAR3
NUCLR Clearing document sequence number CHAR 10 0 J_3RFCLRNUM
USTXT Document Header Text CHAR 25 0 BKTXT
DE_CR Individual, User-Defined Character CHAR 1 0 CHAR0001
CLRPS Individual, User-Defined Character CHAR 1 0 CHAR0001
DSBLE Individual, User-Defined Character CHAR 1 0 CHAR0001
DSBBT Individual, User-Defined Character CHAR 1 0 CHAR0001
GJAHR Fiscal Year NUMC 4 0 GJAHR
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
XZAHL Indicator: Is Posting Key Used in a Payment Transaction? CHAR 1 0 XZAHL
XZAHR Indicator: Is Posting Key Used in a Payment Transaction? CHAR 1 0 XZAHL
XZAHM Indicator: Is Posting Key Used in a Payment Transaction? CHAR 1 0 XZAHL
BILDVAL Undefined range (can be used for patch levels) CHAR 4 0 CHAR4
HWAER Local Currency CUKY 5 0 HWAER
CLWRS Clearing currency CUKY 5 0 J_3RCLCUR
KURSF Exchange rate DEC 9 5 KURSF
WWERT Translation date DATS 8 0 WWERT_D
KURSR Exchange rate DEC 9 5 KURSF
KURSC Exchange rate DEC 9 5 KURSF
DOCLR Document Number of the Clearing Document CHAR 10 0 AUGBL
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAMEOLD Name 1 CHAR 35 0 NAME1_GP
FLAG_FILL Individual, User-Defined Character CHAR 1 0 CHAR0001
HKONT General Ledger Account CHAR 10 0 HKONT
XPROC Indicator CHAR 1 0 FLAG_X
INTCNUM Internal Contract Number CHAR 18 0 J_3RF_INTCNTNUM
EXTCNUM External Contract Number CHAR 40 0 J_3RF_EXTCNTNUM
CNTDATE Contract Date DATS 8 0 J_3RF_CNTDAT
AWKEY Reference Key CHAR 20 0 AWKEY
ERR_NO Message Number NUMC 3 0 SYMSGNO
ERR_DESC Error Description CHAR 120 0 J_3RFCLRDESC