FARMLVD_CLRPAYMTADV

Cleared Payment Advice based on Cleared BS and Invoice | view: FMLVCLRPA | Extraction: Not supported | Component: Financial Cash Application Intelligence
Tables used: AVIKAVIPBSEGT001TKA02T005T001T014
Column Name Description
Column Name Description
PaidAmountInPaytCurrency Payment Amount from the Payment Advice Header
💲 Currency Key (Currency):
NetPaymentAmountInPaytCurrency Net Payment Amount with +/- Sign
GrossAmountInPaymentCurrency Gross Amount
Column Name Description
Column Name Description
CreationDate Date on which the record was created
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type Show values
PaymentAdviceAltvAccountType Account Type Show values
Column Name Description Domain name
PaymentAdviceAccount Account Number KTONR
PaymentAdvice Payment Advice Number AVSID
PaymentAdviceItem Payment Advice Item AVSPO
FiscalYear Fiscal Year GJAHR
AccountingDocument Document Number of an Accounting Document BELNR
BillingDocument Billing Document VBELN
DocumentReferenceID Reference Document XBLNR1
AssignmentReference Assignment number ZUONR
Reference1IDByBusinessPartner Business Partner Reference Key 1 CHAR12
Reference2IDByBusinessPartner Business Partner Reference Key 2 CHAR12
DocumentItemText Item Text TEXT50
PaymentReference Payment Reference CHAR30
PurchasingDocReferenceByCust Customer Reference BSTNK
PaymentAdviceAltvAccount Alternative Account (Payment Advice Management) KTONR
PaytDifferenceReasonExtCode External Reason Code for Payment Differences CHAR3
BankStatementKey null
ReceivableKey null
PaymentAdviceKey null
Master Data Relations Join Conditions
Alternative Company Code (Payment Advice Management)
  • Alternative Company Code (Payment Advice Management)
  • Client
  • FARMLVD_CLRPAYMTADV.ALTERNATIVECOMPANYCODE == T001.BUKRS
  • FARMLVD_CLRPAYMTADV.MANDT == T001.MANDT
Company Code
  • Client
  • Company Code
  • FARMLVD_CLRPAYMTADV.MANDT == T001.MANDT
  • FARMLVD_CLRPAYMTADV.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • FARMLVD_CLRPAYMTADV.MANDT == T005.MANDT
  • FARMLVD_CLRPAYMTADV.COUNTRYKEY == T005.LAND1
Currency Key
  • Client
  • Currency Key
  • FARMLVD_CLRPAYMTADV.MANDT == TCURC.MANDT
  • FARMLVD_CLRPAYMTADV.CURRENCY == TCURC.WAERS
Reason Code for Payments
  • Alternative Company Code (Payment Advice Management)
  • Client
  • Reason Code for Payments
  • FARMLVD_CLRPAYMTADV.ALTERNATIVECOMPANYCODE == T053R.BUKRS
  • FARMLVD_CLRPAYMTADV.MANDT == T053R.MANDT
  • FARMLVD_CLRPAYMTADV.PAYMENTDIFFERENCEREASON == T053R.RSTGR