TCJ_DOCUMENTS - Cash Journal Documents (Header Data)
Cash Journal Documents (Header Data) information is stored in SAP table TCJ_DOCUMENTS.
It is part of development package CAJO in software component FI-BL-PT. This development package consists of objects that can be grouped under "Cash Journal Development".
It is part of development package CAJO in software component FI-BL-PT. This development package consists of objects that can be grouped under "Cash Journal Development".
Fields for table TCJ_DOCUMENTS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| COMP_CODE | Company Code | X | BUKRS | CHAR | 8 | T001 |
| CAJO_NUMBER | Cash Journal Number | X | CJNR | CHAR | 8 | TCJ_C_JOURNALS |
| FISC_YEAR | Fiscal Year | X | GJAHR | NUMC | 8 | |
| POSTING_NUMBER | Cash Journal Document Number | X | CJBELNR | CHAR | 20 | |
| CURRENCY | Currency Key | WAERS | CUKY | 10 | TCURC | |
| H_RECEIPTS | Cash Journal Amount Field with +/- Sign | CJAMOUNT | CURR | 12 | ||
| H_PAYMENTS | Cash Journal Amount Field with +/- Sign | CJAMOUNT | CURR | 12 | ||
| H_NET_AMOUNT | Cash Journal Document Net Amount - Document Currency | CJNET_AMOUNT | CURR | 12 | ||
| H_NET_PAYMENT_WT | Net Payment Amount (Withholding Tax Deducted) | CJNET_PAYMENT_WT | CURR | 12 | ||
| H_TAX_AMOUNT | Tax Amount in Document Currency | WMWST | CURR | 12 | ||
| BP_NAME | Name of Receipt Recipient | CJBPNAME | CHAR | 70 | ||
| DOCUMENT_DATE | Document Date in Document | BLDAT | DATS | 16 | ||
| DOCUMENT_NUMBER | Reference Document Number | XBLNR1 | CHAR | 32 | ||
| POSTING_DATE | Posting Date in the Document | BUDAT | DATS | 16 | ||
| DOCUMENT_STATUS | Cash Journal Entry Document Status | CJDOCSTAT | CHAR | 4 | ||
| ACCOUNTANT | User Name | USNAM | CHAR | 24 | ||
| PRINT_IND | Cash Journal Print Indicator | CJPRINTIND | CHAR | 2 | ||
| TAX_PERCENT | Tax rate | MSATZ_F05L | DEC | 4 | ||
| D_POSTING_NUMB | Cash Journal Document Number for Display | CJBELNR_DISP | CHAR | 20 | ||
| TEXT1 | Additional Field 1 for Cash Journal Document Header | CJDOCTEXT100 | CHAR | 200 | ||
| TEXT2 | Additional Field 2 for Cash Journal Document Header | CJDOCTEXT30 | CHAR | 60 | ||
| MEANS_OF_PAYMENT | Cash Journal Means of Payment | CJMOFPAYM | CHAR | 2 | ||
| CHECK_NUMBER | 13-Digit Check Number | SCKNR_EB | NUMC | 26 | ||
| CHECK_ISSUER | Check Issuer (Cash Journal) | CJCHECKISSUER | CHAR | 28 | ||
| BANK_KEY | Bank Keys | BANKK | CHAR | 30 | ||
| BANK_ACCT | Bank account number | BANKN | CHAR | 36 | ||
| BANK_CTRY | Country/Region Key of Bank | BANKS | CHAR | 6 | ||
| CHECK_STACK | Number of Check Lot in Cash Journal | CJCHECKSTACK | CHAR | 16 | ||
| CHECK_STATUS | Posting Status for Checks in Cash Journal | CJCHECKSTATUS | CHAR | 2 | ||
| REVBELNR | Reversal Document Number for Cash Journal Document | CJREVBELNR | CHAR | 20 | ||
| EXCH_RATE | Exchange rate | KURSF | DEC | 5 | ||
| BUPLA | Business Place | BUPLA | CHAR | 8 | ||
| SECCO | Section Code | SECCO | CHAR | 8 | ||
| SPLIT | Split Information for Cash Journal Document | CJDOCSPLIT | CHAR | 2 | ||
| LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 6 | T015L | |
| LANDL | Supplying Country/Region | LANDL | CHAR | 6 | T005 | |
| CHECK_FY | Fiscal Year of Check Deposit | CJCHECKSTACKFY | NUMC | 8 | ||
| VALUTA_DATE | Value date | VALUT | DATS | 16 | ||
| VATDATE | Tax Reporting Date | VATDATE | DATS | 16 | ||
| BKONT | Bank Control Key | BKONT | CHAR | 4 | ||
| BKREF | Reference Details for Bank Details | BKREF | CHAR | 40 | ||
| IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 68 | ||
| CJ_ENTRY | Transaction code | TCODEL | CHAR | 80 | ||
| FULFILLDATE | Tax Fulfillment Date | FOT_FULFILLDATE | DATS | 16 |