I_PaymentAdvice

Payment Advice Header | view: IPAYTADVC | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: AVIK
Column Name Description
CompanyCode FK Company Code
PaymentAdviceAccountType Payment Advice Account Type Show values
PaymentAdviceAccount Account Number
PaymentAdvice Payment Advice Number
Column Name Description
💲 Payment Currency Key (PaymentCurrency):
PaidAmountInPaytCurrency Payment Amount from the Payment Advice Header
CashDiscountAmountInPaytCrcy Cash Discount Amount
FeeAmountInTransactionCrcy Fees in Account Currency
Column Name Description
Column Name Description
PaymentDate Payment Date
BillOfExchangeDueDate Bill of Exchange Due Date
CreationDate Date on which the record was created
LastChangeDate Last Changed On
CreationTime Time of Entry
BankPostingDate Posting Date at the Bank
BillOfExchangeFailureDate Date of Failed Bills of Exchange in Japan
ValueDate Value date
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type Show values
IsOutgoingPayment Indicator: Outgoing Payment Using Payment Advice? Show values
PaymentAdviceType Payment Advice Type Show values
PaymentAdviceIsHeld Indicator: Hold Payment Advice in the System? Show values
PaymentAdviceHasSingleAccount Indicator: Specific Account/Company Code in Payment Advice? Show values
Column Name Description Domain name
PaymentDocument Payment Document Number BELNR
AccountByShipper Payee's Account at the Customer CHAR12
PaymentMethod Payment Method for This Payment ZLSCH
PartnerBank Bank Number of the Payee BANKL
PartnerBankAccount Bank Account Number of the Payee BANKN
PartnerBankCountry Country/Region Key of Partner Bank LAND1
PartnerBankSWIFTCode SWIFT Code of Partner Bank SWIFT
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
PaymentAdviceHeaderText Payment Advice Header Text TEXT25
PaymentAdviceStatus Payment Advice Status CHAR1
OriginalReferenceDocument Reference Key AWKEY
ReferenceDocumentType Reference procedure AWTYP
BankReference Bank Reference Number CHAR35
ValueDateTime Value Date Time TIME6
PaymentTransaction Business Transaction Code CHAR3
ExchangeRate Accounting Exchange Rate
Cheque Check number CHCKN
BusinessPartnerName Business Partner CHAR55
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_PAYMENTADVICE.COMPANYCODE == T001.BUKRS
  • I_PAYMENTADVICE.MANDT == T001.MANDT
Selection Rule for Payment Advices
  • Client
  • Selection Rule for Payment Advices
  • I_PAYMENTADVICE.MANDT == T053A.MANDT
  • I_PAYMENTADVICE.PAYMENTADVICESELECTIONRULE == T053A.SREGL
Payment Currency Key
  • Client
  • Payment Currency Key
  • I_PAYMENTADVICE.MANDT == TCURC.MANDT
  • I_PAYMENTADVICE.PAYMENTCURRENCY == TCURC.WAERS
Reason Code Conversion Version
  • Client
  • Reason Code Conversion Version
  • I_PAYMENTADVICE.MANDT == T053V.MANDT
  • I_PAYMENTADVICE.PAYTADVCDIFFDETERMINATIONRULE == T053V.VRSDG