I_PaymentProposalPayment

Payment Proposal Payment | view: IPAYTPRPSLPAYT | TRAN | 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
Column Name Description
💲 Currency for Automatic Payment (PaymentCurrency):
CashDiscountAmountInPaytCrcy Cash Discounts in Foreign Currency
PaymentAmountInPaytCurrency Amount Paid in Foreign Currency
LostCashDiscountInPaytCrcy Lost Cash Discounts in Foreign Currency
💲 Currency Key (CompanyCodeCurrency):
CashDiscountAmtInCoCodeCrcy Cash Discounts in Local Currency
PaytAmountInCoCodeCurrency Amount Paid in Local Currency
LostCashDiscountInCoCodeCrcy Lost Cash Discounts in Local Currency
💲 Functional Currency (FunctionalCurrency):
PaymentAmountInFunctionalCrcy Payment Amount in Functional Currency
CashDiscountAmountInFuncnlCrcy Cash Discount in Functional Currency
💲 Additional Currency 1 (AdditionalCurrency1):
PaymentAmountInAdditionalCrcy1 Payment Amount in Additional Currency 1
CashDiscountAmtInAddlCrcy1 Payment Transaction Discount Amount in Additional Currency 1
💲 Additional Currency 2 (AdditionalCurrency2):
PaymentAmountInAdditionalCrcy2 Payment Amount in Additional Currency 2
CashDiscountAmtInAddlCrcy2 Payment Transaction Discount Amount in Additional Currency 2
Column Name Description
Column Name Description
PaymentRunDate Date on Which the Program Is to Be Run
PaymentDueDate Due Date
PostingDate Posting Date of Payment Document
ValueDate Value date
BillOfExchangeIssueDate Bill of Exchange Issue Date
BillOfExchangeDueDate Bill of Exchange Due Date
Column Name Description
PaymentRunIsProposal Auto Payment Is Proposal Show values
FinancialAccountType Account Type Show values
DirectDebitType Local Instrument Code Show values
PaymentsGroupingCriterion Grouping Criterion for Payments Show values
PayeeSEPASequenceType SEPA: Sequence Type Show values
EDIPaymentOrderStatus EDI Payment Order Status Show values
EDIPaymentAdviceStatus EDI Payment Advice Status Show values
BankChainBank1Type Type of Bank 1 in a Bank Chain (Correspondent, Intermediary) Show values
BankChainBank2Type Type of Bank 2 in a Bank Chain (Correspondent, Intermediary) Show values
BankChainBank3Type Type of Bank 3 in a Bank Chain (Correspondent, Intermediary) Show values
Column Name Description Domain name
PaymentRequestPaymentGroup Grouping Field for Automatic Payments CHAR20
NumberOfTextLines Number of Text Lines for Items Paid PACK3
NumberOfPaidItems Item Included PACK3
PaymentReference Payment Reference CHAR30
PersonnelNumber Personnel Number PERNR
PaymentOrder Payment Order PYORD
ExchangeRate Exchange Rate FIS_UKURS
PaymentOrigin Payment Media Origin FIBL_ORIGIN
SWIFTTransactionReferenceUUID Unique Transaction Reference (UETR) SMUM_C36
BusinessPlace Business Place J_1BBRANCH
AccountByShipper Shipper Account CHAR12
AddressID Address Number AD_ADDRNUM
Region Region (State, Province, County) REGIO
CityName City TEXT35
StreetAddressName Street and House Number TEXT35
PostalCode Postal Code PSTLZ
POBox PO Box PFACH
POBoxPostalCode P.O. Box Postal Code PSTLZ
POBoxDeviatingCityName City of payee's PO box TEXT35
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
OrganizationBPName3 Name 3 NAME
OrganizationBPName4 Name 4 NAME
BankControlKey Bank control key at our bank BKONT
Bank Bank number of our bank BANKL
BankInternalID Bank Key of Our Bank BANKK
BankAccount Our account number at the bank BANKN
BankAccountLongID Bank Account Number BANKN35
IBAN IBAN at Our House Bank IBAN
PayeeTitle Title of the payee TEXT15
PayeeName Name of the payee TEXT35
PayeeAdditionalName Name of the payee TEXT35
PayeeCityName City of the payee TEXT35
PayeeDistrictName Location from payee's address TEXT35
PayeeStreet Street and house number of the payee TEXT35
PayeePostalCode Postal Code of the Payee PSTLZ
PayeePOBox P.O. box of the payee PFACH
PayeePOBoxPostalCode P.O. box postal code of the payee PSTLZ
PayeeBankControlKey Bank Control Key of the Payee's Bank BKONT
PayeeBank Bank number of the payee's bank BANKL
PayeeBankKey Bank key of the payee's bank BANKK
PayeeBankAccount Bank account number of the payee BANKN
PayeeBankAccountLongID Payee's Bank Account Number BANKN35
PayeeSEPAMandateUUID SEPA Mandate: GUID of Mandate
PayeeIBAN IBAN of the Payee IBAN
PayeeSWIFTCode SWIFT/BIC for International Payments SWIFT
PayeeBankDetailReference Reference Details for Bank Details CHAR20
PayeeBankAccountHolderName Account Holder Name KOINH
DataExchangeInstructionKey Instruction Key for Data Medium Exchange DTAWS
DataExchangeInstruction1 Instruction Key 1 DTWSX
DataExchangeInstruction2 Instruction Key 2 DTWSX
DataExchangeInstruction3 Instruction key 3 DTWSX
DataExchangeInstruction4 Instruction key 4 DTWSX
BankChainBank1Country Country/Region Key of Bank 1 in a Bank Chain LAND1
BankChainBank1 Bank Key of Bank 1 in a Bank Chain BANKK
BankChainBank1BankAccount Bank Account Number of Bank 1 in a Bank Chain BANKN
BankChainBank1ControlKey Bank Control Key of Bank 1 in a Bank Chain BKONT
BankChainBank1DetailReference Reference Specifications for Bank Details of Bank 1 CHAR20
BankChainBank1IBAN International Bank Account Number of Bank 1 in a Bank Chain IBAN
BankChainBank2Country Country/Region Key of Bank 2 in a Bank Chain LAND1
BankChainBank2 Bank Key of Bank 2 in a Bank Chain BANKK
BankChainBank2BankAccount Bank Account Number of Bank 2 in a Bank Chain BANKN
BankChainBank2ControlKey Bank Control Key of Bank 2 in a Bank Chain BKONT
BankChainBank2DetailReference Reference Specifications for Bank Details of Bank 2 CHAR20
BankChainBank2IBAN International Bank Account Number of Bank 2 in a Bank Chain IBAN
BankChainBank3Country Country/Region Key of Bank 3 in a Bank Chain LAND1
BankChainBank3 Bank Key of Bank 3 in a Bank Chain BANKK
BankChainBank3BankAccount Bank Account Number of Bank 3 in a Bank Chain BANKN
BankChainBank3ControlKey Bank Control Key of Bank 3 in a Bank Chain BKONT
BankChainBank3DetailReference Reference Specifications for Bank Details of Bank 3 CHAR20
BankChainBank3IBAN International Bank Account Number of Bank 3 in a Bank Chain IBAN
PayeePaymentSystem Payee Payment System PAYMENT_SYSTEM
PayeeAliasType Payee Alias Type ALIAS_TYPE
PayeeAliasName Payee Alias BANK_ALIAS
Master Data Relations Join Conditions
Accounting Clerk
  • Sending Company Code
  • Client
  • Accounting Clerk
  • I_PAYMENTPROPOSALPAYMENT.SENDINGCOMPANYCODE == T001S.BUKRS
  • I_PAYMENTPROPOSALPAYMENT.MANDT == T001S.MANDT
  • I_PAYMENTPROPOSALPAYMENT.ACCOUNTINGCLERK == T001S.BUSAB
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • I_PAYMENTPROPOSALPAYMENT.BANKCOUNTRY == T005.LAND1
  • I_PAYMENTPROPOSALPAYMENT.MANDT == T005.MANDT
Business Area
  • Business Area
  • Client
  • I_PAYMENTPROPOSALPAYMENT.BUSINESSAREA == TGSB.GSBER
  • I_PAYMENTPROPOSALPAYMENT.MANDT == TGSB.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • I_PAYMENTPROPOSALPAYMENT.COMPANYCODECOUNTRY == T005.LAND1
  • I_PAYMENTPROPOSALPAYMENT.COUNTRY == T005.LAND1
  • I_PAYMENTPROPOSALPAYMENT.MANDT == T005.MANDT
Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Client
  • I_PAYMENTPROPOSALPAYMENT.COMPANYCODECOUNTRY == T005.LAND1
  • I_PAYMENTPROPOSALPAYMENT.COUNTRY == T005.LAND1
  • I_PAYMENTPROPOSALPAYMENT.MANDT == T005.MANDT
Customer Number
  • Client
  • Customer Number
  • I_PAYMENTPROPOSALPAYMENT.MANDT == KNA1.MANDT
  • I_PAYMENTPROPOSALPAYMENT.CUSTOMER == KNA1.KUNNR
Short Key for a House Bank
  • Paying Company Code
  • Client
  • Short Key for a House Bank
  • I_PAYMENTPROPOSALPAYMENT.PAYINGCOMPANYCODE == T012.BUKRS
  • I_PAYMENTPROPOSALPAYMENT.MANDT == T012.MANDT
  • I_PAYMENTPROPOSALPAYMENT.HOUSEBANK == T012.HBKID
ID for Account Details
  • Paying Company Code
  • Client
  • Short Key for a House Bank
  • ID for Account Details
  • I_PAYMENTPROPOSALPAYMENT.PAYINGCOMPANYCODE == T012K.BUKRS
  • I_PAYMENTPROPOSALPAYMENT.MANDT == T012K.MANDT
  • I_PAYMENTPROPOSALPAYMENT.HOUSEBANK == T012K.HBKID
  • I_PAYMENTPROPOSALPAYMENT.HOUSEBANKACCOUNT == T012K.HKTID
Country/Region Key
  • Client
  • Country/Region Key
  • I_PAYMENTPROPOSALPAYMENT.MANDT == T005.MANDT
  • I_PAYMENTPROPOSALPAYMENT.PAYEEBANKCOUNTRY == T005.LAND1
Country/Region Key
  • Country/Region Key
  • Client
  • I_PAYMENTPROPOSALPAYMENT.PAYEECOUNTRY == T005.LAND1
  • I_PAYMENTPROPOSALPAYMENT.MANDT == T005.MANDT
Language key of the payee I_PAYMENTPROPOSALPAYMENT.PAYEELANGUAGE == T002.SPRAS
Regional code of the payee
  • Country/Region Key
  • Client
  • Regional code of the payee
  • I_PAYMENTPROPOSALPAYMENT.PAYEECOUNTRY == T005S.LAND1
  • I_PAYMENTPROPOSALPAYMENT.MANDT == T005S.MANDT
  • I_PAYMENTPROPOSALPAYMENT.PAYEEREGION == T005S.BLAND
Paying Company Code
  • Paying Company Code
  • Client
  • I_PAYMENTPROPOSALPAYMENT.PAYINGCOMPANYCODE == T001.BUKRS
  • I_PAYMENTPROPOSALPAYMENT.MANDT == T001.MANDT
Currency for Automatic Payment
  • Additional Currency 1
  • Currency Key
  • Additional Currency 2
  • Functional Currency
  • Currency for Automatic Payment
  • Client
  • I_PAYMENTPROPOSALPAYMENT.ADDITIONALCURRENCY1 == TCURC.WAERS
  • I_PAYMENTPROPOSALPAYMENT.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PAYMENTPROPOSALPAYMENT.ADDITIONALCURRENCY2 == TCURC.WAERS
  • I_PAYMENTPROPOSALPAYMENT.FUNCTIONALCURRENCY == TCURC.WAERS
  • I_PAYMENTPROPOSALPAYMENT.PAYMENTCURRENCY == TCURC.WAERS
  • I_PAYMENTPROPOSALPAYMENT.MANDT == TCURC.MANDT
Payment Method for This Payment
  • Country/Region Key
  • Country/Region Key
  • Client
  • Payment Method for This Payment
  • I_PAYMENTPROPOSALPAYMENT.COMPANYCODECOUNTRY == T042Z.LAND1
  • I_PAYMENTPROPOSALPAYMENT.COUNTRY == T042Z.LAND1
  • I_PAYMENTPROPOSALPAYMENT.MANDT == T042Z.MANDT
  • I_PAYMENTPROPOSALPAYMENT.PAYMENTMETHOD == T042Z.ZLSCH
Payment Method Supplement
  • Client
  • Payment Method Supplement
  • I_PAYMENTPROPOSALPAYMENT.MANDT == T042F.MANDT
  • I_PAYMENTPROPOSALPAYMENT.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
Payment Reason
  • Client
  • Payment Reason
Sending Company Code
  • Sending Company Code
  • Client
  • I_PAYMENTPROPOSALPAYMENT.SENDINGCOMPANYCODE == T001.BUKRS
  • I_PAYMENTPROPOSALPAYMENT.MANDT == T001.MANDT
Supplier
  • Supplier
  • Client
  • I_PAYMENTPROPOSALPAYMENT.SUPPLIER == LFA1.LIFNR
  • I_PAYMENTPROPOSALPAYMENT.MANDT == LFA1.MANDT