I_PaymentProposalForm

Payment Proposal Form Data Provider | view: IPAYTPRPSLFORM | Extraction: Not supported | Component: Payment Progam / Payment transfer (DE, JP, US)
Column Name Description
PaymentRunDate Date on Which the Program Is to Be Run
PaymentRunID Auto Payment Run ID
PaymentRunIsProposal Auto Payment Is Proposal Show values
PayingCompanyCode FK Paying Company Code
Supplier FK Supplier
Customer FK Customer Number
PaymentRecipient Payment Recipient
PaymentDocument Payment Document Number
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Currency for Automatic Payment (PaymentCurrency):
PaidAmountInPaytCurrency Amount Paid in Foreign Currency
AmountInTransactionCurrency Gross Amount in Foreign Currency
TotDeductionAmtInTransacCrcy Total Deductions in Foreign Currency
NetAmountInTransacCurrency Net Amount in Foreign Currency
WhldgTaxAmtInPaytCrcy Withholding Tax in Foreign Currency
CashDiscountAmountInPaytCrcy Cash Discounts in Foreign Currency
LostCashDiscountInPaytCrcy Lost Cash Discounts in Foreign Currency
WhldgTaxAmtInTransacCrcy Withholding Tax in Foreign Currency
CashDiscountAmtInTransacCrcy Cash Discounts in Foreign Currency
LostCashDiscountInTransacCrcy Lost Cash Discounts in Foreign Currency
💲 Currency Key (CompanyCodeCurrency):
PaytAmountInCoCodeCurrency Amount Paid in Local Currency
PaidWhldgTaxAmtInCoCodeCrcy Withholding Tax in Local Currency
PaidCashDiscountInCoCodeCrcy Cash Discounts in Local Currency
LostCshDiscAmtInDspCrcy Lost Cash Discounts in Local Currency
GrossAmountInCoCodeCurrency Gross Amount in Local Currency
WhldgTaxAmtInCoCodeCrcy Withholding Tax in Local Currency
CashDiscountAmtInCoCodeCrcy Cash Discounts in Local Currency
LostCashDiscountInCoCodeCrcy Lost Cash Discounts in Local Currency
Column Name Description
Column Name Description
PaymentRunDate Date on Which the Program Is to Be Run
DocumentDate Journal Entry Date
Column Name Description
PaymentRunIsProposal Auto Payment Is Proposal Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
BankAccountHolderName Account Holder Name KOINH
PayeePaymentSystem Payee Payment System PAYMENT_SYSTEM
PayeeAliasType Payee Alias Type ALIAS_TYPE
PayeeAliasName Payee Alias BANK_ALIAS
PaymentSystemText Payment System Text PAYMENT_SYSTEM_TEXT
AliasTypeText Alias Type Text ALIAS_TYPE_TEXT
PaymentTerms Terms of Payment Key ZTERM
HouseBankName Name of Financial Institution TEXT60
HouseBankAccountDescription Account Description TEXT60
PaymentMethodName Description of Payment Method in Logon Language TEXT30
PayingCompanyCodeName Paying Company Code Name TEXT25
CompanyCodeName Name of Company Code or Company TEXT25
SupplierName Name of Supplier TEXT80
CustomerName Name of Customer TEXT80
BankPaymentGroupingOrigin Payment Media Origin FIBL_ORIGIN
SWIFTTransactionReferenceUUID Unique Transaction Reference (UETR) SMUM_C36
AssignmentReference Assignment Reference ZUONR
AccountingDocExternalReference Reference Document XBLNR
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_PAYMENTPROPOSALFORM.MANDT == T003.MANDT
  • I_PAYMENTPROPOSALFORM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Business Area
  • Business Area
  • Client
  • I_PAYMENTPROPOSALFORM.BUSINESSAREA == TGSB.GSBER
  • I_PAYMENTPROPOSALFORM.MANDT == TGSB.MANDT
Company Code
  • Client
  • Company Code
  • I_PAYMENTPROPOSALFORM.MANDT == T001.MANDT
  • I_PAYMENTPROPOSALFORM.COMPANYCODE == T001.BUKRS
Customer Number
  • Customer Number
  • Client
  • I_PAYMENTPROPOSALFORM.CUSTOMER == KNA1.KUNNR
  • I_PAYMENTPROPOSALFORM.MANDT == KNA1.MANDT
Short Key for a House Bank
  • Paying Company Code
  • Short Key for a House Bank
  • Client
  • I_PAYMENTPROPOSALFORM.PAYINGCOMPANYCODE == T012.BUKRS
  • I_PAYMENTPROPOSALFORM.HOUSEBANK == T012.HBKID
  • I_PAYMENTPROPOSALFORM.MANDT == T012.MANDT
ID for Account Details
  • Paying Company Code
  • Short Key for a House Bank
  • ID for Account Details
  • Client
  • I_PAYMENTPROPOSALFORM.PAYINGCOMPANYCODE == T012K.BUKRS
  • I_PAYMENTPROPOSALFORM.HOUSEBANK == T012K.HBKID
  • I_PAYMENTPROPOSALFORM.HOUSEBANKACCOUNT == T012K.HKTID
  • I_PAYMENTPROPOSALFORM.MANDT == T012K.MANDT
Paying Company Code
  • Paying Company Code
  • Client
  • I_PAYMENTPROPOSALFORM.PAYINGCOMPANYCODE == T001.BUKRS
  • I_PAYMENTPROPOSALFORM.MANDT == T001.MANDT
Currency for Automatic Payment
  • Currency Key
  • Currency for Automatic Payment
  • Client
  • I_PAYMENTPROPOSALFORM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PAYMENTPROPOSALFORM.PAYMENTCURRENCY == TCURC.WAERS
  • I_PAYMENTPROPOSALFORM.MANDT == TCURC.MANDT
Payment Method for This Payment
  • Client
  • Payment Method for This Payment
  • ?
  • I_PAYMENTPROPOSALFORM.MANDT == T042Z.MANDT
  • I_PAYMENTPROPOSALFORM.PAYMENTMETHOD == T042Z.ZLSCH
  • I_PAYMENTPROPOSALFORM.[column in domain "LAND1"] == T042Z.LAND1
Posting Key
  • Client
  • Posting Key
  • I_PAYMENTPROPOSALFORM.MANDT == TBSL.MANDT
  • I_PAYMENTPROPOSALFORM.POSTINGKEY == TBSL.BSCHL
Supplier
  • Client
  • Supplier
  • I_PAYMENTPROPOSALFORM.MANDT == LFA1.MANDT
  • I_PAYMENTPROPOSALFORM.SUPPLIER == LFA1.LIFNR