I_CN_CADEJournalEntry

CADE Journal Entry | view: ICADEJOURNLENTRY | Extraction: Not supported | Component: Golden Audit Interface China
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
AccountingDocumentItem Ledger Journal Entry Item
FiscalYear Fiscal Year
Ledger FK Ledger in General Ledger Accounting
CN_CADENatlStdRelVersion National Standard Release Version for CADE Show values
Column Name Description
💲 Currency Key (Currency):
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
CN_CADECreditQuantity Quantity
Column Name Description
PostingDate Posting Date
Column Name Description
CN_CADENatlStdRelVersion National Standard Release Version for CADE Show values
DebitCreditCode Debit/Credit Code Show values
AccountingDocumentCategory Journal Entry Category Show values
IsReversed Indicator: Item is Reversed Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
LedgerGLLineItem Posting View Item BUZEI
AccountingDocumentHeaderText Document Header Text TEXT25
ExchangeRate Exchange Rate
DocumentItemText Item Text TEXT50
AccountingDocCreatedByUser User that created the journal entry
AlternativeReferenceDocument Alternative Reference Document FIS_XBLNR_ALT_WO_EXIT
CN_CADEOriginalPaymentDocument Bill of exchange Number BOE_NUMBER
CN_CADEOriginalPaymentDocType Short Text for Fixed Values DDTEXT
PaymentDocumentPostingDate null
CN_CADEJournalEntryBookKeeper Journal Entry Bookkeeper for CADE
CN_CADEJournalEntryReviewer Journal Entry Reviewer for CADE
AlternativeGLAccountExternal Alternative Account Number in Company Code SAKNR
NmbrOfPages Number of pages of invoice J_1ANOPG
Supplier Supplier LIFNR
Customer Customer Number KUNNR
CostCenter Cost Center KOSTL
InternalOrder Order ID AUFNR
BillToParty Bill-to Party KUNNR
BusinessArea Business Area GSBER
BusinessProcess Business Process CO_PRZNR
ControllingArea Controlling Area CACCD
CustomerGroup Customer Group KDGRP
DistributionChannel Distribution Channel VTWEG
FunctionalArea Functional Area FKBER
Fund Fund BP_GEBER
FundsCenter Funds Management Center FISTL
HouseBank House Bank Key HBKID
HouseBankAccount House Bank Account HKTID
Material Material Number MATNR
MaterialGroup Product Sold Group MATKL
Plant Plant WERKS
ProfitCenter Profit Center PRCTR
Project Project FIS_PROJECT
ProjectNetwork Network Number for Account Assignment AUFNR
SalesDistrict Sales District BZIRK
SalesOrganization Sales Organization VKORG
Segment Segment for Segmental Reporting FB_SEGMENT
ShipToParty Ship-to Party KUNNR
SoldMaterial Sold Material MATNR
WBSElement WBS Element FIS_WBS
Language Language Key SPRAS
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_CN_CADEJOURNALENTRY.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_CN_CADEJOURNALENTRY.MANDT == T003.MANDT
Alternative G/L Account Number In Company Code
  • ?
  • Alternative G/L Account Number In Company Code
  • Client
  • I_CN_CADEJOURNALENTRY.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_CN_CADEJOURNALENTRY.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • I_CN_CADEJOURNALENTRY.MANDT == SKA1.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_CN_CADEJOURNALENTRY.MANDT == T006.MANDT
  • I_CN_CADEJOURNALENTRY.BASEUNIT == T006.MSEHI
Company Code
  • Company Code
  • Client
  • I_CN_CADEJOURNALENTRY.COMPANYCODE == T001.BUKRS
  • I_CN_CADEJOURNALENTRY.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • I_CN_CADEJOURNALENTRY.CURRENCY == TCURC.WAERS
  • I_CN_CADEJOURNALENTRY.MANDT == TCURC.MANDT
Supplier
  • Supplier
  • Client
  • I_CN_CADEJOURNALENTRY.FREIGHTSUPPLIER == LFA1.LIFNR
  • I_CN_CADEJOURNALENTRY.MANDT == LFA1.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • I_CN_CADEJOURNALENTRY.COMPANYCODE == SKB1.BUKRS
  • I_CN_CADEJOURNALENTRY.GLACCOUNT == SKB1.SAKNR
  • I_CN_CADEJOURNALENTRY.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Customer Number
  • Customer Number
  • Client
  • I_CN_CADEJOURNALENTRY.SITECUSTOMER == KNA1.KUNNR
  • I_CN_CADEJOURNALENTRY.MANDT == KNA1.MANDT