P_MX_JrnlEntrItmInvcDetails

OperationalAcct with mexico invoice data | view: PMXJEINVDET | 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
StatryRptCategory FK Report Category ID
StatryRptgEntity FK Reporting Entity
StatryRptRunID Report Run ID
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
Column Name Description
Column Name Description
PostingDate Posting Date
ClearingDate Clearing Date
Column Name Description
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
Column Name Description Domain name
AccountingDocumentItem Journal Entry Posting View Item BUZEI
ClearingAccountingDocument Clearing Journal Entry BELNR
ExchangeRate Exchange rate KURSF
ElectronicInvoiceUUID Mexico Compensation UUID for Electronic Accounting
JrnlEntryCntrySpecificRef5 Manual Payment Details for Mexico
Country Country/Region Key LAND1
TaxNumber1 Tax Number 1 STCD1
TaxNumberLineItem ID of Reference 3 by Business Partner CHAR20
DocumentReferenceID Document Reference ID XBLNR1
DigInvcOp1 null
DigInvcOp2 null
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
InvoiceReferenceFiscalYear Fiscal Year FIS_GJAHR_NO_CONV
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocument Reference document number AWREF
IsFormatedForDigitalInvoice null
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_MX_JRNLENTRITMINVCDETAILS.MANDT == T003.MANDT
  • P_MX_JRNLENTRITMINVCDETAILS.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Client
  • Company Code
  • P_MX_JRNLENTRITMINVCDETAILS.MANDT == T001.MANDT
  • P_MX_JRNLENTRITMINVCDETAILS.COMPANYCODE == T001.BUKRS
Customer Number
  • Customer Number
  • Client
  • P_MX_JRNLENTRITMINVCDETAILS.CUSTOMER == KNA1.KUNNR
  • P_MX_JRNLENTRITMINVCDETAILS.MANDT == KNA1.MANDT
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Payment Method
  • ?
  • Payment Method
  • Client
  • P_MX_JRNLENTRITMINVCDETAILS.[column in domain "LAND1"] == T042Z.LAND1
  • P_MX_JRNLENTRITMINVCDETAILS.PAYMENTMETHOD == T042Z.ZLSCH
  • P_MX_JRNLENTRITMINVCDETAILS.MANDT == T042Z.MANDT
Reference Document Type P_MX_JRNLENTRITMINVCDETAILS.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Reporting Entity
  • Reporting Entity
  • Client
  • P_MX_JRNLENTRITMINVCDETAILS.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • P_MX_JRNLENTRITMINVCDETAILS.MANDT == SRF_RPG_ENT.MANDT
Supplier
  • Supplier
  • Client
  • P_MX_JRNLENTRITMINVCDETAILS.SUPPLIER == LFA1.LIFNR
  • P_MX_JRNLENTRITMINVCDETAILS.MANDT == LFA1.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • P_MX_JRNLENTRITMINVCDETAILS.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_MX_JRNLENTRITMINVCDETAILS.MANDT == TCURC.MANDT