C_MX_JrnlEntrItmPaytDetailsC

Journal Entries Items with Payments Cube | view: CMXJEPAYMDETC | TRAN | Extraction: Not supported | Component: Financials Mexico
Column Name Description
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
AccountingDocument Journal Entry
GLAccount G/L Account
DocumentItemText Item Text
FiscalYear Fiscal Year
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
Column Name Description
💲 Currency Key (PaymentCurrency):
PaidAmountInPaytCurrency Amount Paid in the Payment Currency
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
PaymentMethodIsUsedForCheck Indicator: Is a Check Created Using This Payment Method? Show values
PaytMethIsUsdForBillOfExchange Indicator: Create a bill of Exchange Posting? Show values
PaytMethIsUsdForChkBillOfExch Indicator: Payment Method for Check/Bill of Exchange? Show values
MX_ExternalPaymentMethod External Payment Method for Mexico Show values
PaymentTransaction Payment Type Show values
Column Name Description Domain name
AccountingDocumentItem null
Cheque Check number CHCKN
OutgoingCheque Check number CHCKN
ExchangeRate null
BankAccount Our account number at the bank BANKN
PayeeBankAccount Bank account number of the payee BANKN
Bank Bank number of our bank BANKL
PayeeBank Bank number of the payee's bank BANKL
BankName Name of Financial Institution TEXT60
PayeeBankName Name of Financial Institution TEXT60
OrganizationBPName1 Name 1 TEXT40
TaxNumber1 Tax Number 1 STCD1
PaymentRecipient Payment Recipient EMPFG
TransactionCode Transaction Code TCODE
LedgerGLLineItem null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_MX_JRNLENTRITMPAYTDETAILSC.COMPANYCODE == T001.BUKRS
  • C_MX_JRNLENTRITMPAYTDETAILSC.MANDT == T001.MANDT
ID for Account Details
  • ID for Account Details
  • ?
  • Client
  • ?
  • C_MX_JRNLENTRITMPAYTDETAILSC.HOUSEBANKACCOUNT == T012K.HKTID
  • C_MX_JRNLENTRITMPAYTDETAILSC.[column in domain "HBKID"] == T012K.HBKID
  • C_MX_JRNLENTRITMPAYTDETAILSC.MANDT == T012K.MANDT
  • C_MX_JRNLENTRITMPAYTDETAILSC.[column in domain "BUKRS"] == T012K.BUKRS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Payment Method
  • ?
  • Client
  • Payment Method
  • C_MX_JRNLENTRITMPAYTDETAILSC.[column in domain "LAND1"] == T042Z.LAND1
  • C_MX_JRNLENTRITMPAYTDETAILSC.MANDT == T042Z.MANDT
  • C_MX_JRNLENTRITMPAYTDETAILSC.PAYMENTMETHOD == T042Z.ZLSCH
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Reporting Entity
  • Reporting Entity
  • Client
  • C_MX_JRNLENTRITMPAYTDETAILSC.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_MX_JRNLENTRITMPAYTDETAILSC.MANDT == SRF_RPG_ENT.MANDT