I_PaymentAdviceTP

Payment Advice Header | view: IPAYTADVCTP | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: AVIKT001ST001TKA02KNA1KNB1KNB5T053AT053BT053VT053WADCPADR2ADR3ADR6ADRPUSR21
Column Name Description
CompanyCode FK Company Code
PaymentAdviceAccountType Payment Advice Account Type Show values
PaymentAdviceAccount Customer ID
PaymentAdvice Payment Advice Number
Column Name Description
💲 Payment Currency Key (PaymentCurrency):
PaidAmountInPaytCurrency Payment Amount from the Payment Advice Header
CashDiscountAmountInPaytCrcy Cash Discount Amount
PaymentAdviceItemTotalAmount Total of Payment Amounts for All Payment Advice Items
Column Name Description
Column Name Description
PaymentDate Payment Date
CreationDate Date on which the record was created
LastChangeDate Last Changed On
CreationTime Time of Entry
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type Show values
PaytAdviceAccountTypeForEdit Payment Advice Account Type Show values
PaymentAdviceType Payment Advice Type Show values
PaymentAdviceExtractionStatus Payment advice extraction status Show values
Column Name Description Domain name
PaymentAdviceAccountForEdit Customer ID KUNNR
PaymentAdviceForEdit Payment Advice Number AVSID
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
PaymentAdviceTypeName Short Text for Fixed Values DDTEXT
PaymentAdviceStatus Payment Advice Status CHAR1
PaytAdvcDiffDetnRuleDesc Reason Code Conversion Version Name TXT30
PaytAdviceSelectionRuleDesc Text (25, obsolete)
OriginalReferenceDocument Reference Key AWKEY
CustomerName Customer Full Name TEXT220
FullName Full Name of Person TEXT80
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
CompanyCodeName Name of Company Code or Company TEXT25
PaymentAdviceIsExtracted Manage payment advices ML processing indicator CHAR1
PaytAdviceExtractorConfidence Manage payment advices ML Confidence AVIK_ML_CONFIDENCE
PaymentAdviceExtractorUUID Manage Payment advices ML UUID CHAR36
PaymentAdviceUUID Payment advice UUID OBJKY
PaytAdviceTotalNumberOfPages Total Number of Pages
UxFcPaymentAdviceAccount UI Field Control Byte (Should be defined centrally) INT1
AccountingClerkName Accounting Clerk Name TEXT30
Customer Account Number KTONR
BankReference Payment Reference CHAR35
BusinessPartnerName Extracted Customer Name CHAR55
Master Data Relations Join Conditions
Accounting Clerk
  • Client
  • Company Code
  • Company Code
  • Accounting Clerk
  • I_PAYMENTADVICETP.MANDT == T001S.MANDT
  • I_PAYMENTADVICETP.COMPANYCODEFOREDIT == T001S.BUKRS
  • I_PAYMENTADVICETP.COMPANYCODE == T001S.BUKRS
  • I_PAYMENTADVICETP.ACCOUNTINGCLERK == T001S.BUSAB
Company Code
  • Client
  • Company Code
  • Company Code
  • I_PAYMENTADVICETP.MANDT == T001.MANDT
  • I_PAYMENTADVICETP.COMPANYCODEFOREDIT == T001.BUKRS
  • I_PAYMENTADVICETP.COMPANYCODE == T001.BUKRS
Company Code
  • Client
  • Company Code
  • Company Code
  • I_PAYMENTADVICETP.MANDT == T001.MANDT
  • I_PAYMENTADVICETP.COMPANYCODEFOREDIT == T001.BUKRS
  • I_PAYMENTADVICETP.COMPANYCODE == T001.BUKRS
Selection Rule for Payment Advices
  • Client
  • Selection Rule for Payment Advices
  • I_PAYMENTADVICETP.MANDT == T053A.MANDT
  • I_PAYMENTADVICETP.PAYMENTADVICESELECTIONRULE == T053A.SREGL
Payment Currency Key
  • Client
  • Payment Currency Key
  • I_PAYMENTADVICETP.MANDT == TCURC.MANDT
  • I_PAYMENTADVICETP.PAYMENTCURRENCY == TCURC.WAERS
Reason Code Conversion Version
  • Client
  • Reason Code Conversion Version
  • I_PAYMENTADVICETP.MANDT == T053V.MANDT
  • I_PAYMENTADVICETP.PAYTADVCDIFFDETERMINATIONRULE == T053V.VRSDG