I_PaymentAdviceItem

Payment Advice Item | view: IPAYTADVCITM | TRAN | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: AVIPBSEGT001TKA02T005T001T014
Column Name Description
CompanyCode FK Company Code
PaymentAdviceAccountType Payment Advice Account Type Show values
PaymentAdviceAccount Account Number
PaymentAdvice Payment Advice Number
PaymentAdviceItem Payment Advice Item
Column Name Description
💲 Currency Key (Currency):
TaxAmountInCoCodeCrcy Tax Amount in Local Currency
GrossAmountInPaymentCurrency Gross Amount
NetPaymentAmountInPaytCurrency Net Payment Amount with +/- Sign
CashDiscountAmountInPaytCrcy Cash Discount Amount with +/- Sign
DifferenceAmountInCoCodeCrcy Amount Difference in Local Currency
DeductionAmountInPaytCurrency Deduction Amount
💲 Currency Key (CompanyCodeCurrency):
DifferenceAmount Amount Difference in Foreign Currency
💲 Additional Currency 1 (AdditionalCurrency1):
DiffAmtInAdditionalCurrency1 Amount Difference in Second Local Currency
💲 Additional Currency 2 (AdditionalCurrency2):
DiffAmtInAdditionalCurrency2 Amount Difference in Third Local Currency
Column Name Description
Column Name Description
AccountingDocumentCreationDate Accounting Document Entry Date
InvoiceDate Document Date
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type Show values
PaymentAdviceAltvAccountType Account Type Show values
ItemIsActivated Indicator: Items Activated? Show values
CashDiscountIsActivated Flag whether Cash Discount is Active Show values
IsPartialPayment Indicator: Partial Payments Show values
PaytDiffRsdlBalIsCarriedFwd Indicator: Carryforward Residual Bal. for Payt Difference? Show values
IsPostedOnAccount Indicator: Posting on Account Show values
Column Name Description Domain name
PaymentAdviceAltvAccount Alternative Account (Payment Advice Management) KTONR
AccountingDocument Document Number of an Accounting Document BELNR
DocumentReferenceID Reference Document XBLNR1
LockboxInvoiceReference Lockbox Invoice Reference LBINVREF
BillingDocument Billing Document VBELN
BranchAccount Account Number of the Branch MAXKK
AssignmentReference Assignment number ZUONR
PaytDifferenceReasonExtCode External Reason Code for Payment Differences CHAR3
DocumentItemText Item Text TEXT50
FiscalYear Fiscal Year GJAHR
AccountingDocumentItem Posting View Item BUZEI
CashDiscountPercent Selected Cash Discount Percentage Rate PRZ23
CashDiscountDays Selected cash discount days ZBDXT
Reference1IDByBusinessPartner Business Partner Reference Key 1 CHAR12
Reference2IDByBusinessPartner Business Partner Reference Key 2 CHAR12
DeliveryDocument Delivery VBELN
PurchasingDocReferenceByCust Customer Reference BSTNK
PaymentAdviceStatus Payment Advice Status CHAR1
PaymentReference Payment Reference CHAR30
PaymentAdviceSelectionField Name of Selection Field FDNAME
PaymentAdviceSelectionValue Selection Value (Payment Advice Management) CHAR30
PaytAdvcExternalSelectionField Name of External Selection Field Specified FDNAME
Master Data Relations Join Conditions
Alternative Company Code (Payment Advice Management)
  • Alternative Company Code (Payment Advice Management)
  • Client
  • I_PAYMENTADVICEITEM.ALTERNATIVECOMPANYCODE == T001.BUKRS
  • I_PAYMENTADVICEITEM.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • I_PAYMENTADVICEITEM.BUSINESSAREA == TGSB.GSBER
  • I_PAYMENTADVICEITEM.MANDT == TGSB.MANDT
Company Code
  • Company Code
  • Client
  • I_PAYMENTADVICEITEM.COMPANYCODE == T001.BUKRS
  • I_PAYMENTADVICEITEM.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • I_PAYMENTADVICEITEM.CURRENCY == TCURC.WAERS
  • I_PAYMENTADVICEITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PAYMENTADVICEITEM.MANDT == TCURC.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • I_PAYMENTADVICEITEM.CURRENCY == TCURC.WAERS
  • I_PAYMENTADVICEITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PAYMENTADVICEITEM.MANDT == TCURC.MANDT
Reason Code for Payments
  • Reason Code for Payments
  • Alternative Company Code (Payment Advice Management)
  • Client
  • I_PAYMENTADVICEITEM.PAYMENTDIFFERENCEREASON == T053R.RSTGR
  • I_PAYMENTADVICEITEM.ALTERNATIVECOMPANYCODE == T053R.BUKRS
  • I_PAYMENTADVICEITEM.MANDT == T053R.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • I_PAYMENTADVICEITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
  • I_PAYMENTADVICEITEM.[column in domain "KVEWE"] == T683.KVEWE
  • I_PAYMENTADVICEITEM.[column in domain "KAPPL"] == T683.KAPPL
  • I_PAYMENTADVICEITEM.MANDT == T683.MANDT
Tax on sales/purchases code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Tax on sales/purchases code
  • Client
  • I_PAYMENTADVICEITEM.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • I_PAYMENTADVICEITEM.TAXCODE == T007A.MWSKZ
  • I_PAYMENTADVICEITEM.MANDT == T007A.MANDT