Import Payment (Window ID-280)

From iDempiere en

Table of Contents

Window: Import Payment

Description: Import Payments

Help:

Tab: Payment

Description: Import Payments

Help:

Import Payment - Payment - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
Import Payment Import Payment I_Payment.I_Payment_ID
numeric(10)
ID
Imported Has this import been processed The Imported check box indicates if this import has been processed. I_Payment.I_IsImported
character(1)
Yes-No
Payment Payment identifier The Payment is a unique identifier of this payment. I_Payment.C_Payment_ID
numeric(10)
Search
Import Error Message Messages generated from import process The Import Error Message displays any error messages generated during the import process. I_Payment.I_ErrorMsg
character varying(2000)
String
Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. I_Payment.AD_Client_ID
numeric(10)
Table Direct
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. I_Payment.AD_Org_ID
numeric(10)
Table Direct
Bank Account No Bank Account Number I_Payment.BankAccountNo
character varying(20)
String
Bank Account Account at the Bank The Bank Account identifies an account at this Bank. I_Payment.C_BankAccount_ID
numeric(10)
Table Direct
Document No Document sequence number of the document The document number is usually automatically generated by the system and determined by the document type of the document. If the document is not saved, the preliminary number is displayed in "<>".

If the document type of your document has no automatic document sequence defined, the field is empty if you create a new document. This is for documents which usually have an external number (like vendor invoice). If you leave the field empty, the system will generate a document number for you. The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).

I_Payment.DocumentNo
character varying(30)
String
Receipt This is a sales transaction (receipt) I_Payment.IsReceipt
character(1)
Yes-No
Document Type Name Name of the Document Type I_Payment.DocTypeName
character varying(60)
String
Document Type Document type or rules The Document Type determines document sequence and processing rules I_Payment.C_DocType_ID
numeric(10)
Table Direct
Transaction Date Transaction Date The Transaction Date indicates the date of the transaction. I_Payment.DateTrx
timestamp without time zone
Date
Account Date Accounting Date The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document. It is also used for any currency conversion. I_Payment.DateAcct
timestamp without time zone
Date+Time
Business Partner Key Key of the Business Partner I_Payment.BPartnerValue
character varying(40)
String
Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson I_Payment.C_BPartner_ID
numeric(10)
Search
Invoice Document No Document Number of the Invoice I_Payment.InvoiceDocumentNo
character varying(30)
String
Invoice Invoice Identifier The Invoice Document. I_Payment.C_Invoice_ID
numeric(10)
Search
ISO Currency Code Three letter ISO 4217 Code of the Currency For details - http://www.unece.org/trade/rec/rec09en.htm I_Payment.ISO_Code
character(3)
String
Currency The Currency for this record Indicates the Currency to be used when processing or reporting on this record I_Payment.C_Currency_ID
numeric(10)
Table Direct
Payment amount Amount being paid Indicates the amount this payment is for. The payment amount can be for single or multiple invoices or a partial payment for an invoice. I_Payment.PayAmt
numeric
Amount
Discount Amount Calculated amount of discount The Discount Amount indicates the discount amount for a document or line. I_Payment.DiscountAmt
numeric
Amount
Write-off Amount Amount to write-off The Write Off Amount indicates the amount to be written off as uncollectible. I_Payment.WriteOffAmt
numeric
Amount
Over/Under Payment Over-Payment (unallocated) or Under-Payment (partial payment) Overpayments (negative) are unallocated amounts and allow you to receive money for more than the particular invoice.

Underpayments (positive) is a partial payment for the invoice. You do not write off the unpaid amount.

I_Payment.IsOverUnderPayment
character(1)
Yes-No
Over/Under Payment Over-Payment (unallocated) or Under-Payment (partial payment) Amount Overpayments (negative) are unallocated amounts and allow you to receive money for more than the particular invoice.

Underpayments (positive) is a partial payment for the invoice. You do not write off the unpaid amount.

I_Payment.OverUnderAmt
numeric
Amount
Tender type Method of Payment The Tender Type indicates the method of payment (ACH or Direct Deposit, Credit Card, Check, Direct Debit) I_Payment.TenderType
character(1)
List
Credit Card Credit Card (Visa, MC, AmEx) The Credit Card drop down list box is used for selecting the type of Credit Card presented for payment. I_Payment.CreditCardType
character(1)
List
Transaction Type Type of credit card transaction The Transaction Type indicates the type of transaction to be submitted to the Credit Card Company. I_Payment.TrxType
character(1)
List
Number Credit Card Number The Credit Card number indicates the number on the credit card, without blanks or spaces. I_Payment.CreditCardNumber
character varying(20)
String
Exp. Month Expiry Month The Expiry Month indicates the expiry month for this credit card. I_Payment.CreditCardExpMM
numeric(10)
Integer
Exp. Year Expiry Year The Expiry Year indicates the expiry year for this credit card. I_Payment.CreditCardExpYY
numeric(10)
Integer
Routing No Bank Routing Number The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions. I_Payment.RoutingNo
character varying(20)
String
Account No Account Number The Account Number indicates the Number assigned to this bank account. I_Payment.AccountNo
character varying(20)
String
IBAN International Bank Account Number If your bank provides an International Bank Account Number, enter it here

Details ISO 13616 and http://www.ecbs.org. The account number has the maximum length of 22 characters (without spaces). The IBAN is often printed with a apace after 4 characters. Do not enter the spaces in iDempiere.

I_Payment.IBAN
character varying(40)
String
Swift code Swift Code or BIC The Swift Code (Society of Worldwide Interbank Financial Telecommunications) or BIC (Bank Identifier Code) is an identifier of a Bank. The first 4 characters are the bank code, followed by the 2 character country code, the two character location code and optional 3 character branch code. For details see http://www.swift.com/biconline/index.cfm I_Payment.SwiftCode
character varying(20)
String
Check No Check Number The Check Number indicates the number on the check. I_Payment.CheckNo
character varying(20)
String
Micr Combination of routing no, account and check no The Micr number is the combination of the bank routing number, account number and check number I_Payment.Micr
character varying(20)
String
Account Name Name on Credit Card or Account holder The Name of the Credit Card or Account holder. I_Payment.A_Name
character varying(60)
String
Account Street Street address of the Credit Card or Account holder The Street Address of the Credit Card or Account holder. I_Payment.A_Street
character varying(60)
String
Account City City or the Credit Card or Account Holder The Account City indicates the City of the Credit Card or Account holder I_Payment.A_City
character varying(60)
String
Account Zip/Postal Zip Code of the Credit Card or Account Holder The Zip Code of the Credit Card or Account Holder. I_Payment.A_Zip
character varying(20)
String
Account State State of the Credit Card or Account holder The State of the Credit Card or Account holder I_Payment.A_State
character varying(40)
String
Account Country Country Account Country Name I_Payment.A_Country
character varying(40)
String
Driver License Payment Identification - Driver License The Driver's License being used as identification. I_Payment.A_Ident_DL
character varying(20)
String
Social Security No Payment Identification - Social Security No The Social Security number being used as identification. I_Payment.A_Ident_SSN
character varying(20)
String
Account EMail Email Address The EMail Address indicates the EMail address off the Credit Card or Account holder. I_Payment.A_EMail
character varying(60)
String
Voice authorization code Voice Authorization Code from credit card company The Voice Authorization Code indicates the code received from the Credit Card Company. I_Payment.VoiceAuthCode
character varying(20)
String
Original Transaction ID Original Transaction ID The Original Transaction ID is used for reversing transactions and indicates the transaction that has been reversed. I_Payment.Orig_TrxID
character varying(20)
String
Approved Indicates if this document requires approval The Approved checkbox indicates if this document requires approval before it can be processed. I_Payment.IsApproved
character(1)
Yes-No
Result Result of transmission The Response Result indicates the result of the transmission to the Credit Card Company. I_Payment.R_Result
character varying(20)
String
Response Message Response message The Response Message indicates the message returned from the Credit Card Company as the result of a transmission I_Payment.R_RespMsg
character varying(60)
String
Reference Payment reference The Payment Reference indicates the reference returned from the Credit Card Company for a payment I_Payment.R_PnRef
character varying(20)
String
Authorization Code Authorization Code returned The Authorization Code indicates the code returned from the electronic transmission. I_Payment.R_AuthCode
character varying(20)
String
Import Payments Import Payments The Parameters are default values for null import record values, they do not overwrite any data. I_Payment.Processing
character(1)
Button


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.