A_PaymentAdvice

Payment Advice | view: APAYTADVC | 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
CreationDate Date on which the record was created
CreationTime Time of Entry
LastChangeDate Last Changed On
BillOfExchangeFailureDate Date of Failed Bills of Exchange in Japan
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type Show values
PaymentAdviceType Payment Advice Type Show values
Column Name Description Domain name
PaymentDocument Payment Document Number BELNR
AccountByShipper Payee's Account at the Customer CHAR12
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
PaymentTransaction Business Transaction Code CHAR3
ExchangeRate Accounting Exchange Rate
BankReference Bank Reference Number CHAR35
BusinessPartnerName Business Partner CHAR55
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • A_PAYMENTADVICE.MANDT == T001.MANDT
  • A_PAYMENTADVICE.COMPANYCODE == T001.BUKRS
Selection Rule for Payment Advices
  • Client
  • Selection Rule for Payment Advices
  • A_PAYMENTADVICE.MANDT == T053A.MANDT
  • A_PAYMENTADVICE.PAYMENTADVICESELECTIONRULE == T053A.SREGL
Payment Currency Key
  • Client
  • Payment Currency Key
  • A_PAYMENTADVICE.MANDT == TCURC.MANDT
  • A_PAYMENTADVICE.PAYMENTCURRENCY == TCURC.WAERS
Reason Code Conversion Version
  • Client
  • Reason Code Conversion Version
  • A_PAYMENTADVICE.MANDT == T053V.MANDT
  • A_PAYMENTADVICE.PAYTADVCDIFFDETERMINATIONRULE == T053V.VRSDG