FARMLVD_PAYMTADV

Payment Advice Information | view: FMLVPAYMADV | Extraction: Not supported | Component: Financial Cash Application Intelligence
Tables used: AVIKAVIPBSEGT001TKA02T005KNA1T001T014
Column Name Description
Column Name Description
PaidAmountInPaytCurrency Payment Amount from the Payment Advice Header
💲 Currency Key (Currency):
NetPaymentAmountInPaytCurrency Net Payment Amount with +/- Sign
DeductionAmountInPaytCurrency Deduction Amount
Column Name Description
Column Name Description
CreationDate Date on which the record was created
InvoiceDate Document Date
Column Name Description
PaymentAdviceAccountType Payment Advice Account Type Show values
Column Name Description Domain name
PaymentAdvice Payment Advice Number AVSID
PaymentAdviceItem Payment Advice Item AVSPO
PaymentAdviceAccount Account Number KTONR
PaymentAdviceSelectionField Name of Selection Field FDNAME
PaytAdvcExternalSelectionField Name of External Selection Field Specified FDNAME
AccountingDocument Document Number of an Accounting Document BELNR
DocumentReferenceID Reference Document XBLNR1
AssignmentReference Assignment number ZUONR
FiscalYear Fiscal Year GJAHR
CustomerName Name of Customer TEXT80
CityName City TEXT35
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • FARMLVD_PAYMTADV.COMPANYCODE == T001.BUKRS
  • FARMLVD_PAYMTADV.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • FARMLVD_PAYMTADV.CURRENCY == TCURC.WAERS
  • FARMLVD_PAYMTADV.MANDT == TCURC.MANDT
Reason Code for Payments
  • Client
  • ?
  • Reason Code for Payments
  • FARMLVD_PAYMTADV.MANDT == T053R.MANDT
  • FARMLVD_PAYMTADV.[column in domain "BUKRS"] == T053R.BUKRS
  • FARMLVD_PAYMTADV.PAYMENTDIFFERENCEREASON == T053R.RSTGR