TCJ_DOCUMENTS

Cash Journal Documents (Header Data) | #transactional | Component: Payment Transactions
Column Name Description
MANDT FK Client
COMP_CODE FK Company Code
CAJO_NUMBER FK Cash Journal Number
FISC_YEAR Fiscal Year
POSTING_NUMBER Cash Journal Document Number
Column Name Description
💲 Currency Key (CURRENCY):
H_RECEIPTS Cash Journal Amount Field with +/- Sign
H_PAYMENTS Cash Journal Amount Field with +/- Sign
H_NET_AMOUNT Cash Journal Document Net Amount - Document Currency
H_NET_PAYMENT_WT Net Payment Amount (Withholding Tax Deducted)
H_TAX_AMOUNT Tax Amount in Document Currency
Column Name Description
Column Name Description
DOCUMENT_DATE Document Date in Document
POSTING_DATE Posting Date in the Document
VALUTA_DATE Value date
VATDATE Tax Reporting Date
FULFILLDATE Tax Fulfillment Date
Column Name Description
DOCUMENT_STATUS Cash Journal Entry Document Status Show values
PRINT_IND Cash Journal Print Indicator Show values
MEANS_OF_PAYMENT Cash Journal Means of Payment Show values
CHECK_STATUS Posting Status for Checks in Cash Journal Show values
SPLIT Split Information for Cash Journal Document Show values
Column Name Description Domain name
BP_NAME Name of Receipt Recipient NAME
DOCUMENT_NUMBER Reference Document Number XBLNR1
ACCOUNTANT User Name XUBNAME
TAX_PERCENT Tax rate PRZ43V
D_POSTING_NUMB Cash Journal Document Number for Display BELNR
TEXT1 Additional Field 1 for Cash Journal Document Header TEXT100
TEXT2 Additional Field 2 for Cash Journal Document Header TEXT30
CHECK_NUMBER 13-Digit Check Number NUMC13
CHECK_ISSUER Check Issuer (Cash Journal) TEXT14
BANK_KEY Bank Keys BANKK
BANK_ACCT Bank account number BANKN
BANK_CTRY Country/Region Key of Bank LAND1
CHECK_STACK Number of Check Lot in Cash Journal CHAR8
REVBELNR Reversal Document Number for Cash Journal Document BELNR
EXCH_RATE Exchange rate KURSF
BUPLA Business Place J_1BBRANCH
SECCO Section Code SECCO
CHECK_FY Fiscal Year of Check Deposit GJAHR
BKONT Bank Control Key BKONT
BKREF Reference Details for Bank Details CHAR20
IBAN IBAN (International Bank Account Number) IBAN
CJ_ENTRY Transaction code TCODEL
Master Data Relations Join Conditions
Cash Journal Number
  • Company Code
  • Cash Journal Number
Company Code
  • TCJ_DOCUMENTS.MANDT == T001.MANDT
  • TCJ_DOCUMENTS.COMP_CODE == T001.BUKRS
Currency Key
  • TCJ_DOCUMENTS.MANDT == TCURC.MANDT
  • TCJ_DOCUMENTS.CURRENCY == TCURC.WAERS
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • TCJ_DOCUMENTS.LANDL == T005.LAND1
  • TCJ_DOCUMENTS.MANDT == T005.MANDT
State Central Bank Indicator
  • TCJ_DOCUMENTS.MANDT == T015L.MANDT
  • TCJ_DOCUMENTS.LZBKZ == T015L.LZBKZ
Client TCJ_DOCUMENTS.MANDT == T000.MANDT