C_PaymentAdviceItem

Payment Advice Item | view: CPAYTADVCITM | Extraction: Not supported | Component: Fiori FXU Accounts Receivable FI-FIO-AR
Tables used: AVIPAVIRBSEGTGSBTGSBTT001TKA02T005T053RT053ST014
Column Name Description
CompanyCode FK Company Code
PaymentAdviceAccountType Payment Advice Account Type Show values
PaymentAdviceAccount Customer ID
PaymentAdvice Payment Advice Number
PaymentAdviceItem Payment Advice Item
Column Name Description
💲 Currency Key (Currency):
NetPaymentAmountInPaytCurrency Net Payment Amount with +/- Sign
CashDiscountAmountInPaytCrcy Cash Discount Amount with +/- Sign
GrossAmountInPaymentCurrency Gross Amount
DifferenceAmount Amount Difference in Foreign Currency
DeductionAmountInPaytCurrency Deduction Amount
💲 Currency Key (CompanyCodeCurrency):
DifferenceAmountInCoCodeCrcy Amount Difference in Local Currency
TaxAmountInCoCodeCrcy Tax Amount in Local 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 Journal Entry Date
InvoiceDate Document Date
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type Show values
PaytAdviceAccountTypeForEdit 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
PaymentAdviceAccountForEdit Customer ID KUNNR
PaymentAdviceForEdit Payment Advice Number AVSID
PaymentAdviceItemForEdit Payment Advice Item AVSPO
AccountingDocument Document BELNR
AccountingDocumentItem Posting View Item BUZEI
BillingDocument Billing Document VBELN
BranchAccount Account Number of the Branch MAXKK
BusinessAreaName Business Area Description TEXT30
CashDiscountDays Selected cash discount days ZBDXT
PaymentAdviceAltvAccount Alternative Account (Payment Advice Management) KTONR
DocumentReferenceID Reference Document XBLNR1
AssignmentReference Assignment number ZUONR
PaytDifferenceReasonExtCode External Reason Code for Payment Differences CHAR3
DocumentItemText Item Description TEXT50
FiscalYear Fiscal Year GJAHR
CashDiscountPercent Selected Cash Discount Percentage Rate PRZ23
PaymentDifferenceReasonName Reason Code Short Text TXT20
PaymentDifferenceReasonDesc Payment Difference Reason Code Description TXT40
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
TotalCount Number of Subitems FARP_NUMBER_OF_SUBITEMS
Master Data Relations Join Conditions
Alternative Company Code (Payment Advice Management)
  • Alternative Company Code (Payment Advice Management)
  • Client
  • C_PAYMENTADVICEITEM.ALTERNATIVECOMPANYCODE == T001.BUKRS
  • C_PAYMENTADVICEITEM.MANDT == T001.MANDT
Business Area
  • Client
  • Business Area
  • C_PAYMENTADVICEITEM.MANDT == TGSB.MANDT
  • C_PAYMENTADVICEITEM.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • Company Code
  • C_PAYMENTADVICEITEM.MANDT == T001.MANDT
  • C_PAYMENTADVICEITEM.COMPANYCODEFOREDIT == T001.BUKRS
  • C_PAYMENTADVICEITEM.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • C_PAYMENTADVICEITEM.MANDT == TCURC.MANDT
  • C_PAYMENTADVICEITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PAYMENTADVICEITEM.CURRENCY == TCURC.WAERS
Company Code
  • Client
  • Company Code
  • Company Code
  • C_PAYMENTADVICEITEM.MANDT == T001.MANDT
  • C_PAYMENTADVICEITEM.COMPANYCODEFOREDIT == T001.BUKRS
  • C_PAYMENTADVICEITEM.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • C_PAYMENTADVICEITEM.MANDT == TCURC.MANDT
  • C_PAYMENTADVICEITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PAYMENTADVICEITEM.CURRENCY == TCURC.WAERS
Reason Code for Payments
  • Alternative Company Code (Payment Advice Management)
  • Client
  • Reason Code for Payments
  • C_PAYMENTADVICEITEM.ALTERNATIVECOMPANYCODE == T053R.BUKRS
  • C_PAYMENTADVICEITEM.MANDT == T053R.MANDT
  • C_PAYMENTADVICEITEM.PAYMENTDIFFERENCEREASON == T053R.RSTGR
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • ?
  • ?
  • C_PAYMENTADVICEITEM.TAXCALCULATIONPROCEDURE == T683.KALSM
  • C_PAYMENTADVICEITEM.MANDT == T683.MANDT
  • C_PAYMENTADVICEITEM.[column in domain "KVEWE"] == T683.KVEWE
  • C_PAYMENTADVICEITEM.[column in domain "KAPPL"] == T683.KAPPL
Tax on sales/purchases code
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • Tax on sales/purchases code
  • C_PAYMENTADVICEITEM.TAXCALCULATIONPROCEDURE == T007A.KALSM
  • C_PAYMENTADVICEITEM.MANDT == T007A.MANDT
  • C_PAYMENTADVICEITEM.TAXCODE == T007A.MWSKZ