P_MX_JrnlEntrItmPaytDetailsC

Journal Entries Items with Payments | view: PMXJEPAYMDETC | 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
FiscalYear Fiscal Year
AccountingDocumentItem null
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency null
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
FinancialAccountType Account Type Show values
MX_ExternalPaymentMethod External Payment Method for Mexico Show values
Column Name Description Domain name
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
AccountingDocumentHeaderText Document Header Text TEXT25
PaymentRunDate null
PaymentRunID null
OrganizationBPName1 Name 1 TEXT40
TaxNumber1 Tax Number 1 STCD1
ExchangeRate Exchange rate KURSF
Bank Bank number of our bank BANKL
BankAccount Our account number at the bank BANKN
Cheque Check number CHCKN
JrnlEntryCntrySpecificRef5 Manual Payment Details for Mexico
TransactionCode Transaction Code TCODE
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_MX_JRNLENTRITMPAYTDETAILSC.COMPANYCODE == T001.BUKRS
  • P_MX_JRNLENTRITMPAYTDETAILSC.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • P_MX_JRNLENTRITMPAYTDETAILSC.CUSTOMER == KNA1.KUNNR
  • P_MX_JRNLENTRITMPAYTDETAILSC.MANDT == KNA1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Payment Method
  • Client
  • ?
  • Payment Method
  • P_MX_JRNLENTRITMPAYTDETAILSC.MANDT == T042Z.MANDT
  • P_MX_JRNLENTRITMPAYTDETAILSC.[column in domain "LAND1"] == T042Z.LAND1
  • P_MX_JRNLENTRITMPAYTDETAILSC.PAYMENTMETHOD == T042Z.ZLSCH
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Reporting Entity
  • Reporting Entity
  • Client
  • P_MX_JRNLENTRITMPAYTDETAILSC.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • P_MX_JRNLENTRITMPAYTDETAILSC.MANDT == SRF_RPG_ENT.MANDT
Supplier
  • Supplier
  • Client
  • P_MX_JRNLENTRITMPAYTDETAILSC.SUPPLIER == LFA1.LIFNR
  • P_MX_JRNLENTRITMPAYTDETAILSC.MANDT == LFA1.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • P_MX_JRNLENTRITMPAYTDETAILSC.MANDT == TCURC.MANDT
  • P_MX_JRNLENTRITMPAYTDETAILSC.TRANSACTIONCURRENCY == TCURC.WAERS