I_CashJournalDocument

View for table TCJ_DOCUMENTS | view: ICASHJNLDOC | TRAN | Extraction: Not supported | Component: Information System
Column Name Description
CompanyCode FK Company Code
CashJournal FK Cash Journal Number
FiscalYear Fiscal Year
CashJournalDocumentInternalID Cash Journal Document Number
Language FK Language Key
Column Name Description
💲 Currency Key (Currency):
TaxAmountInTransCrcy Tax Amount in Document Currency
CashJournalDocumentNetAmount Cash Journal Document Net Amount - Document Currency
WhldgTaxDeductedNetPaymentAmt Net Payment Amount (Withholding Tax Deducted)
CashJournalReceiptAmount Cash Journal Amount Field with +/- Sign
CashJournalPaymentAmount Cash Journal Amount Field with +/- Sign
AmountInTransactionCurrency null
Column Name Description
Column Name Description
DocumentDate Document Date in Document
PostingDate Posting Date in the Document
ValueDate Value date
TaxReportingDate Tax Reporting Date
Column Name Description
CashJournalDocumentStatus Cash Journal Entry Document Status Show values
CashJournalIsPrinted Cash Journal Print Indicator Show values
CashJournalChequePostingSts Posting Status for Checks in Cash Journal Show values
CashJournalDocumentIsSplit Split Information for Cash Journal Document Show values
Column Name Description Domain name
ReceiptRecipientName Name of Receipt Recipient NAME
CashJournalDocument Cash Journal Document Number for Display BELNR
AccountingDocExternalReference Reference Document Number XBLNR1
CreatedByUser User Name XUBNAME
TaxRate Tax rate PRZ43V
CashJournalDocumentText1 Additional Field 1 for Cash Journal Document Header TEXT100
CashJournalDocumentText2 Additional Field 2 for Cash Journal Document Header TEXT30
Cheque 13-Digit Check Number NUMC13
CashJournalChequeIssuer Check Issuer (Cash Journal) TEXT14
BankKey Bank Keys BANKK
BankAccount Bank account number BANKN
BankCountry Country/Region Key of Bank LAND1
CashJournalChequeLot Number of Check Lot in Cash Journal CHAR8
CashJournalReversalDocument Reversal Document Number for Cash Journal Document BELNR
ExchangeRate Exchange rate KURSF
BusinessPlace Business Place J_1BBRANCH
BusinessSectionCode Section Code SECCO
ChequeLotFiscalYear Fiscal Year of Check Deposit GJAHR
Master Data Relations Join Conditions
Cash Journal Number
  • Company Code
  • Cash Journal Number
  • Client
Company Code
  • Company Code
  • Client
  • I_CASHJOURNALDOCUMENT.COMPANYCODE == T001.BUKRS
  • I_CASHJOURNALDOCUMENT.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • I_CASHJOURNALDOCUMENT.CURRENCY == TCURC.WAERS
  • I_CASHJOURNALDOCUMENT.MANDT == TCURC.MANDT
Language Key I_CASHJOURNALDOCUMENT.LANGUAGE == T002.SPRAS
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • I_CASHJOURNALDOCUMENT.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • I_CASHJOURNALDOCUMENT.MANDT == T015L.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • I_CASHJOURNALDOCUMENT.SUPPLYINGCOUNTRY == T005.LAND1
  • I_CASHJOURNALDOCUMENT.MANDT == T005.MANDT