View source for Template:Import Payment (Window ID-280 V1.0.0)

= Window: Import Payment =

'''Description:''' Import Payments

'''Help:''' 

== Tab: Payment ==
'''Description:''' Import Payments

'''Help:''' 

[[Image:Import_Payment_-_Payment_-_Window_(iDempiere_1.0.0).png|border]]

{| border="1" cellpadding="5" cellspacing="0" align="center"
|+'''Fields'''
!style="background:#efefef;" width="100"|Name
!style="background:#efefef;" width="150"|Description
!style="background:#efefef;" width="300"|Help
!style="background:#efefef;" width="100"|<small>Technical Data</small>
|-valign="top"
|Import Payment
|Import Payment
|
|<small>I_Payment.I_Payment_ID<br>numeric(10)<br>ID</small>
|-valign="top"
|Imported
|Has this import been processed
|The Imported check box indicates if this import has been processed.
|<small>I_Payment.I_IsImported<br>character(1)<br>Yes-No</small>
|-valign="top"
|Payment
|Payment identifier
|The Payment is a unique identifier of this payment.
|<small>I_Payment.C_Payment_ID<br>numeric(10)<br>Search</small>
|-valign="top"
|Import Error Message
|Messages generated from import process
|The Import Error Message displays any error messages generated during the import process.
|<small>I_Payment.I_ErrorMsg<br>character varying(2000)<br>String</small>
|-valign="top"
|Tenant
|Tenant for this installation.
|A Tenant is a company or a legal entity. You cannot share data between Tenants.
|<small>I_Payment.AD_Client_ID<br>numeric(10)<br>Table Direct</small>
|-valign="top"
|Organization
|Organizational entity within tenant
|An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.
|<small>I_Payment.AD_Org_ID<br>numeric(10)<br>Table Direct</small>
|-valign="top"
|Bank Account No
|Bank Account Number
|
|<small>I_Payment.BankAccountNo<br>character varying(20)<br>String</small>
|-valign="top"
|Bank Account
|Account at the Bank
|The Bank Account identifies an account at this Bank.
|<small>I_Payment.C_BankAccount_ID<br>numeric(10)<br>Table Direct</small>
|-valign="top"
|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).
|<small>I_Payment.DocumentNo<br>character varying(30)<br>String</small>
|-valign="top"
|Receipt
|This is a sales transaction (receipt)
|
|<small>I_Payment.IsReceipt<br>character(1)<br>Yes-No</small>
|-valign="top"
|Document Type Name
|Name of the Document Type
|
|<small>I_Payment.DocTypeName<br>character varying(60)<br>String</small>
|-valign="top"
|Document Type
|Document type or rules
|The Document Type determines document sequence and processing rules
|<small>I_Payment.C_DocType_ID<br>numeric(10)<br>Table Direct</small>
|-valign="top"
|Transaction Date
|Transaction Date
|The Transaction Date indicates the date of the transaction.
|<small>I_Payment.DateTrx<br>timestamp without time zone<br>Date</small>
|-valign="top"
|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.
|<small>I_Payment.DateAcct<br>timestamp without time zone<br>Date+Time</small>
|-valign="top"
|Business Partner Key
|Key of the Business Partner
|
|<small>I_Payment.BPartnerValue<br>character varying(40)<br>String</small>
|-valign="top"
|Business Partner
|Identifies a Business Partner
|A Business Partner is anyone with whom you transact.  This can include Vendor, Customer, Employee or Salesperson
|<small>I_Payment.C_BPartner_ID<br>numeric(10)<br>Search</small>
|-valign="top"
|Invoice Document No
|Document Number of the Invoice
|
|<small>I_Payment.InvoiceDocumentNo<br>character varying(30)<br>String</small>
|-valign="top"
|Invoice
|Invoice Identifier
|The Invoice Document.
|<small>I_Payment.C_Invoice_ID<br>numeric(10)<br>Search</small>
|-valign="top"
|ISO Currency Code
|Three letter ISO 4217 Code of the Currency
|For details - http://www.unece.org/trade/rec/rec09en.htm
|<small>I_Payment.ISO_Code<br>character(3)<br>String</small>
|-valign="top"
|Currency
|The Currency for this record
|Indicates the Currency to be used when processing or reporting on this record
|<small>I_Payment.C_Currency_ID<br>numeric(10)<br>Table Direct</small>
|-valign="top"
|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.
|<small>I_Payment.PayAmt<br>numeric<br>Amount</small>
|-valign="top"
|Discount Amount
|Calculated amount of discount
|The Discount Amount indicates the discount amount for a document or line.
|<small>I_Payment.DiscountAmt<br>numeric<br>Amount</small>
|-valign="top"
|Write-off Amount
|Amount to write-off
|The Write Off Amount indicates the amount to be written off as uncollectible.
|<small>I_Payment.WriteOffAmt<br>numeric<br>Amount</small>
|-valign="top"
|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.
|<small>I_Payment.IsOverUnderPayment<br>character(1)<br>Yes-No</small>
|-valign="top"
|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.
|<small>I_Payment.OverUnderAmt<br>numeric<br>Amount</small>
|-valign="top"
|Tender type
|Method of Payment
|The Tender Type indicates the method of payment (ACH or Direct Deposit, Credit Card, Check, Direct Debit)
|<small>I_Payment.TenderType<br>character(1)<br>List</small>
|-valign="top"
|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.
|<small>I_Payment.CreditCardType<br>character(1)<br>List</small>
|-valign="top"
|Transaction Type
|Type of credit card transaction
|The Transaction Type indicates the type of transaction to be submitted to the Credit Card Company.
|<small>I_Payment.TrxType<br>character(1)<br>List</small>
|-valign="top"
|Number
|Credit Card Number 
|The Credit Card number indicates the number on the credit card, without blanks or spaces.
|<small>I_Payment.CreditCardNumber<br>character varying(20)<br>String</small>
|-valign="top"
|Exp. Month
|Expiry Month
|The Expiry Month indicates the expiry month for this credit card.
|<small>I_Payment.CreditCardExpMM<br>numeric(10)<br>Integer</small>
|-valign="top"
|Exp. Year
|Expiry Year
|The Expiry Year indicates the expiry year for this credit card.
|<small>I_Payment.CreditCardExpYY<br>numeric(10)<br>Integer</small>
|-valign="top"
|Routing No
|Bank Routing Number
|The Bank Routing Number (ABA Number) identifies a legal Bank.  It is used in routing checks and electronic transactions.
|<small>I_Payment.RoutingNo<br>character varying(20)<br>String</small>
|-valign="top"
|Account No
|Account Number
|The Account Number indicates the Number assigned to this bank account. 
|<small>I_Payment.AccountNo<br>character varying(20)<br>String</small>
|-valign="top"
|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.
|<small>I_Payment.IBAN<br>character varying(40)<br>String</small>
|-valign="top"
|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
|<small>I_Payment.SwiftCode<br>character varying(20)<br>String</small>
|-valign="top"
|Check No
|Check Number
|The Check Number indicates the number on the check.
|<small>I_Payment.CheckNo<br>character varying(20)<br>String</small>
|-valign="top"
|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
|<small>I_Payment.Micr<br>character varying(20)<br>String</small>
|-valign="top"
|Account Name
|Name on Credit Card or Account holder
|The Name of the Credit Card or Account holder.
|<small>I_Payment.A_Name<br>character varying(60)<br>String</small>
|-valign="top"
|Account Street
|Street address of the Credit Card or Account holder
|The Street Address of the Credit Card or Account holder.
|<small>I_Payment.A_Street<br>character varying(60)<br>String</small>
|-valign="top"
|Account City
|City or the Credit Card or Account Holder
|The Account City indicates the City of the Credit Card or Account holder
|<small>I_Payment.A_City<br>character varying(60)<br>String</small>
|-valign="top"
|Account Zip/Postal
|Zip Code of the Credit Card or Account Holder
|The Zip Code of the Credit Card or Account Holder.
|<small>I_Payment.A_Zip<br>character varying(20)<br>String</small>
|-valign="top"
|Account State
|State of the Credit Card or Account holder
|The State of the Credit Card or Account holder
|<small>I_Payment.A_State<br>character varying(40)<br>String</small>
|-valign="top"
|Account Country
|Country
|Account Country Name
|<small>I_Payment.A_Country<br>character varying(40)<br>String</small>
|-valign="top"
|Driver License
|Payment Identification - Driver License
|The Driver's License being used as identification.
|<small>I_Payment.A_Ident_DL<br>character varying(20)<br>String</small>
|-valign="top"
|Social Security No
|Payment Identification - Social Security No
|The Social Security number being used as identification.
|<small>I_Payment.A_Ident_SSN<br>character varying(20)<br>String</small>
|-valign="top"
|Account EMail
|Email Address
|The EMail Address indicates the EMail address off the Credit Card or Account holder.
|<small>I_Payment.A_EMail<br>character varying(60)<br>String</small>
|-valign="top"
|Voice authorization code
|Voice Authorization Code from credit card company
|The Voice Authorization Code indicates the code received from the Credit Card Company.
|<small>I_Payment.VoiceAuthCode<br>character varying(20)<br>String</small>
|-valign="top"
|Original Transaction ID
|Original Transaction ID
|The Original Transaction ID is used for reversing transactions and indicates the transaction that has been reversed.
|<small>I_Payment.Orig_TrxID<br>character varying(20)<br>String</small>
|-valign="top"
|Approved
|Indicates if this document requires approval
|The Approved checkbox indicates if this document requires approval before it can be processed.
|<small>I_Payment.IsApproved<br>character(1)<br>Yes-No</small>
|-valign="top"
|Result
|Result of transmission
|The Response Result indicates the result of the transmission to the Credit Card Company.
|<small>I_Payment.R_Result<br>character varying(20)<br>String</small>
|-valign="top"
|Response Message
|Response message
|The Response Message indicates the message returned from the Credit Card Company as the result of a transmission
|<small>I_Payment.R_RespMsg<br>character varying(60)<br>String</small>
|-valign="top"
|Reference
|Payment reference
|The Payment Reference indicates the reference returned from the Credit Card Company for a payment
|<small>I_Payment.R_PnRef<br>character varying(20)<br>String</small>
|-valign="top"
|Authorization Code
|Authorization Code returned
|The Authorization Code indicates the code returned from the electronic transmission.
|<small>I_Payment.R_AuthCode<br>character varying(20)<br>String</small>
|-valign="top"
|Import Payments
|Import Payments
|The Parameters are default values for null import record values, they do not overwrite any data.
|<small>I_Payment.Processing<br>character(1)<br>Button</small>
|}