Difference between revisions of "Template:Import Payment (Window ID-280 V1.0.0)"
From iDempiere en
m (Created page with "en:Import Payment (Window ID-280) ar:Import Payment (نافذة ID-280) bg:Import Payment (прозорец ID-280) da:Import Payment (Vindue ID-280) [[de:Impo...") |
CarlosRuiz (talk | contribs) (Template generated from iDempiere10.20230331) |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | = Window: Import Payment = | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | '''Description:''' Import Payments | ||
| − | + | '''Help:''' | |
| + | == Tab: Payment == | ||
'''Description:''' Import Payments | '''Description:''' Import Payments | ||
| − | '''Help:''' | + | '''Help:''' |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | [[Image:Import_Payment_-_Payment_-_Window_(iDempiere_1.0.0).png|border]] | ||
| − | |-valign="top" | + | {| 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 | ||
|Import Payment | |Import Payment | ||
| − | | | + | | |
| − | + | |<small>I_Payment.I_Payment_ID<br>numeric(10)<br>ID</small> | |
| − | |I_Payment_ID<br>numeric(10) | + | |-valign="top" |
| − | |-valign="top" | ||
| − | |||
| − | |||
| − | |||
| − | |||
|Imported | |Imported | ||
| − | |Has this import been processed | + | |Has this import been processed |
|The Imported check box indicates if this import has been processed. | |The Imported check box indicates if this import has been processed. | ||
| − | |I_IsImported<br>character(1) | + | |<small>I_Payment.I_IsImported<br>character(1)<br>Yes-No</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Payment | |Payment | ||
| − | + | |Payment identifier | |
| − | |Payment identifier | ||
|The Payment is a unique identifier of this payment. | |The Payment is a unique identifier of this payment. | ||
| − | |C_Payment_ID<br>numeric(10)<br>Search | + | |<small>I_Payment.C_Payment_ID<br>numeric(10)<br>Search</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Import Error Message | |Import Error Message | ||
| − | + | |Messages generated from import process | |
| − | |Messages generated from import process | ||
|The Import Error Message displays any error messages generated during the import process. | |The Import Error Message displays any error messages generated during the import process. | ||
| − | |I_ErrorMsg<br>character varying(2000)<br>String | + | |<small>I_Payment.I_ErrorMsg<br>character varying(2000)<br>String</small> |
| − | |-valign="top" | + | |-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" | |
| − | | | ||
| − | |A | ||
| − | |AD_Client_ID<br>numeric(10)<br>Table Direct | ||
| − | |-valign="top" | ||
| − | |||
| − | |||
| − | |||
| − | |||
|Organization | |Organization | ||
| − | |Organizational entity within | + | |Organizational entity within tenant |
| − | |An organization is a unit of your | + | |An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations. |
| − | |AD_Org_ID<br>numeric(10)<br>Table Direct | + | |<small>I_Payment.AD_Org_ID<br>numeric(10)<br>Table Direct</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Bank Account No | |Bank Account No | ||
| − | + | |Bank Account Number | |
| − | |Bank Account Number | + | | |
| − | | | + | |<small>I_Payment.BankAccountNo<br>character varying(20)<br>String</small> |
| − | |BankAccountNo<br>character varying(20)<br>String | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |-valign="top" | ||
|Bank Account | |Bank Account | ||
| − | + | |Account at the Bank | |
| − | |Account at the Bank | ||
|The Bank Account identifies an account at this Bank. | |The Bank Account identifies an account at this Bank. | ||
| − | |C_BankAccount_ID<br>numeric(10)<br>Table Direct | + | |<small>I_Payment.C_BankAccount_ID<br>numeric(10)<br>Table Direct</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Document No | |Document No | ||
| − | |Document sequence number of the document | + | |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 "<>". | |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). | 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). | ||
| − | |DocumentNo<br>character varying(30)<br>String | + | |<small>I_Payment.DocumentNo<br>character varying(30)<br>String</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Receipt | |Receipt | ||
| − | |This is a sales transaction (receipt) | + | |This is a sales transaction (receipt) |
| − | | | + | | |
| − | |IsReceipt<br>character(1)<br>Yes-No | + | |<small>I_Payment.IsReceipt<br>character(1)<br>Yes-No</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Document Type Name | |Document Type Name | ||
| − | + | |Name of the Document Type | |
| − | |Name of the Document Type | + | | |
| − | | | + | |<small>I_Payment.DocTypeName<br>character varying(60)<br>String</small> |
| − | |DocTypeName<br>character varying(60)<br>String | + | |-valign="top" |
| − | |-valign="top" | ||
| − | |||
| − | |||
| − | |||
| − | |||
|Document Type | |Document Type | ||
| − | |Document type or rules | + | |Document type or rules |
|The Document Type determines document sequence and processing rules | |The Document Type determines document sequence and processing rules | ||
| − | |C_DocType_ID<br>numeric(10)<br>Table Direct | + | |<small>I_Payment.C_DocType_ID<br>numeric(10)<br>Table Direct</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Transaction Date | |Transaction Date | ||
|Transaction Date | |Transaction Date | ||
| − | |||
|The Transaction Date indicates the date of the transaction. | |The Transaction Date indicates the date of the transaction. | ||
| − | |DateTrx<br>timestamp without time zone<br>Date | + | |<small>I_Payment.DateTrx<br>timestamp without time zone<br>Date</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Account Date | |Account Date | ||
| − | |Accounting 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. | |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. | ||
| − | |DateAcct<br>timestamp without time zone<br>Date+Time | + | |<small>I_Payment.DateAcct<br>timestamp without time zone<br>Date+Time</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Business Partner Key | |Business Partner Key | ||
| − | + | |Key of the Business Partner | |
| − | |Key of the Business Partner | + | | |
| − | | | + | |<small>I_Payment.BPartnerValue<br>character varying(40)<br>String</small> |
| − | |BPartnerValue<br>character varying(40)<br>String | + | |-valign="top" |
| − | |-valign="top" | + | |Business Partner |
| − | + | |Identifies a Business Partner | |
| − | |||
| − | |||
| − | |||
| − | |Business Partner | ||
| − | |Identifies a Business Partner | ||
|A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | |A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | ||
| − | |C_BPartner_ID<br>numeric(10)<br>Search | + | |<small>I_Payment.C_BPartner_ID<br>numeric(10)<br>Search</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Invoice Document No | |Invoice Document No | ||
| − | |Document Number of the Invoice | + | |Document Number of the Invoice |
| − | | | + | | |
| − | |InvoiceDocumentNo<br>character varying(30)<br>String | + | |<small>I_Payment.InvoiceDocumentNo<br>character varying(30)<br>String</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Invoice | |Invoice | ||
| − | |Invoice Identifier | + | |Invoice Identifier |
|The Invoice Document. | |The Invoice Document. | ||
| − | |C_Invoice_ID<br>numeric(10)<br>Search | + | |<small>I_Payment.C_Invoice_ID<br>numeric(10)<br>Search</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|ISO Currency Code | |ISO Currency Code | ||
| − | + | |Three letter ISO 4217 Code of the Currency | |
| − | |Three letter ISO 4217 Code of the Currency | ||
|For details - http://www.unece.org/trade/rec/rec09en.htm | |For details - http://www.unece.org/trade/rec/rec09en.htm | ||
| − | |ISO_Code<br>character(3)<br>String | + | |<small>I_Payment.ISO_Code<br>character(3)<br>String</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Currency | |Currency | ||
| − | |The Currency for this record | + | |The Currency for this record |
|Indicates the Currency to be used when processing or reporting on this record | |Indicates the Currency to be used when processing or reporting on this record | ||
| − | |C_Currency_ID<br>numeric(10)<br>Table Direct | + | |<small>I_Payment.C_Currency_ID<br>numeric(10)<br>Table Direct</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Payment amount | |Payment amount | ||
| − | |Amount being paid | + | |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. | |Indicates the amount this payment is for. The payment amount can be for single or multiple invoices or a partial payment for an invoice. | ||
| − | |PayAmt<br>numeric<br>Amount | + | |<small>I_Payment.PayAmt<br>numeric<br>Amount</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Discount Amount | |Discount Amount | ||
| − | + | |Calculated amount of discount | |
| − | |Calculated amount of discount | ||
|The Discount Amount indicates the discount amount for a document or line. | |The Discount Amount indicates the discount amount for a document or line. | ||
| − | |DiscountAmt<br>numeric<br>Amount | + | |<small>I_Payment.DiscountAmt<br>numeric<br>Amount</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Write-off Amount | |Write-off Amount | ||
| − | + | |Amount to write-off | |
| − | |Amount to write-off | ||
|The Write Off Amount indicates the amount to be written off as uncollectible. | |The Write Off Amount indicates the amount to be written off as uncollectible. | ||
| − | |WriteOffAmt<br>numeric<br>Amount | + | |<small>I_Payment.WriteOffAmt<br>numeric<br>Amount</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Over/Under Payment | |Over/Under Payment | ||
| − | + | |Over-Payment (unallocated) or Under-Payment (partial 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. | |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. | Underpayments (positive) is a partial payment for the invoice. You do not write off the unpaid amount. | ||
| − | |IsOverUnderPayment<br>character(1)<br>Yes-No | + | |<small>I_Payment.IsOverUnderPayment<br>character(1)<br>Yes-No</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Over/Under Payment | |Over/Under Payment | ||
| − | |Over-Payment (unallocated) or Under-Payment (partial payment) Amount | + | |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. | |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. | Underpayments (positive) is a partial payment for the invoice. You do not write off the unpaid amount. | ||
| − | |OverUnderAmt<br>numeric<br>Amount | + | |<small>I_Payment.OverUnderAmt<br>numeric<br>Amount</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Tender type | |Tender type | ||
| − | + | |Method of Payment | |
| − | |Method of Payment | ||
|The Tender Type indicates the method of payment (ACH or Direct Deposit, Credit Card, Check, Direct Debit) | |The Tender Type indicates the method of payment (ACH or Direct Deposit, Credit Card, Check, Direct Debit) | ||
| − | |TenderType<br>character(1)<br>List | + | |<small>I_Payment.TenderType<br>character(1)<br>List</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Credit Card | |Credit Card | ||
| − | |Credit Card (Visa, MC, AmEx) | + | |Credit Card (Visa, MC, AmEx) |
|The Credit Card drop down list box is used for selecting the type of Credit Card presented for payment. | |The Credit Card drop down list box is used for selecting the type of Credit Card presented for payment. | ||
| − | |CreditCardType<br>character(1)<br>List | + | |<small>I_Payment.CreditCardType<br>character(1)<br>List</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Transaction Type | |Transaction Type | ||
| − | |Type of credit card transaction | + | |Type of credit card transaction |
|The Transaction Type indicates the type of transaction to be submitted to the Credit Card Company. | |The Transaction Type indicates the type of transaction to be submitted to the Credit Card Company. | ||
| − | |TrxType<br>character(1)<br>List | + | |<small>I_Payment.TrxType<br>character(1)<br>List</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Number | |Number | ||
| − | + | |Credit Card Number | |
| − | |Credit Card Number | ||
|The Credit Card number indicates the number on the credit card, without blanks or spaces. | |The Credit Card number indicates the number on the credit card, without blanks or spaces. | ||
| − | |CreditCardNumber<br>character varying(20)<br>String | + | |<small>I_Payment.CreditCardNumber<br>character varying(20)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Exp. Month | |Exp. Month | ||
| − | + | |Expiry Month | |
| − | |Expiry Month | ||
|The Expiry Month indicates the expiry month for this credit card. | |The Expiry Month indicates the expiry month for this credit card. | ||
| − | |CreditCardExpMM<br>numeric(10)<br>Integer | + | |<small>I_Payment.CreditCardExpMM<br>numeric(10)<br>Integer</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Exp. Year | |Exp. Year | ||
| − | |Expiry Year | + | |Expiry Year |
|The Expiry Year indicates the expiry year for this credit card. | |The Expiry Year indicates the expiry year for this credit card. | ||
| − | |CreditCardExpYY<br>numeric(10)<br>Integer | + | |<small>I_Payment.CreditCardExpYY<br>numeric(10)<br>Integer</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Routing No | |Routing No | ||
| − | |Bank Routing Number | + | |Bank Routing Number |
|The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions. | |The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions. | ||
| − | |RoutingNo<br>character varying(20)<br>String | + | |<small>I_Payment.RoutingNo<br>character varying(20)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Account No | |Account No | ||
| − | + | |Account Number | |
| − | |Account Number | ||
|The Account Number indicates the Number assigned to this bank account. | |The Account Number indicates the Number assigned to this bank account. | ||
| − | |AccountNo<br>character varying(20)<br>String | + | |<small>I_Payment.AccountNo<br>character varying(20)<br>String</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | | | + | |IBAN |
| − | + | |International Bank Account Number | |
| − | |-valign="top" | + | |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 No | ||
| − | |Check Number | + | |Check Number |
|The Check Number indicates the number on the check. | |The Check Number indicates the number on the check. | ||
| − | |CheckNo<br>character varying(20)<br>String | + | |<small>I_Payment.CheckNo<br>character varying(20)<br>String</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Micr | |Micr | ||
| − | |Combination of routing no, account and check no | + | |Combination of routing no, account and check no |
|The Micr number is the combination of the bank routing number, account number and check number | |The Micr number is the combination of the bank routing number, account number and check number | ||
| − | |Micr<br>character varying(20)<br>String | + | |<small>I_Payment.Micr<br>character varying(20)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Account Name | |Account Name | ||
| − | + | |Name on Credit Card or Account holder | |
| − | |Name on Credit Card or Account holder | ||
|The Name of the Credit Card or Account holder. | |The Name of the Credit Card or Account holder. | ||
| − | |A_Name<br>character varying(60)<br>String | + | |<small>I_Payment.A_Name<br>character varying(60)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Account Street | |Account Street | ||
| − | + | |Street address of the Credit Card or Account holder | |
| − | |Street address of the Credit Card or Account holder | ||
|The Street Address of the Credit Card or Account holder. | |The Street Address of the Credit Card or Account holder. | ||
| − | |A_Street<br>character varying(60)<br>String | + | |<small>I_Payment.A_Street<br>character varying(60)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Account City | |Account City | ||
| − | + | |City or the Credit Card or Account Holder | |
| − | |City or the Credit Card or Account Holder | ||
|The Account City indicates the City of the Credit Card or Account holder | |The Account City indicates the City of the Credit Card or Account holder | ||
| − | |A_City<br>character varying(60)<br>String | + | |<small>I_Payment.A_City<br>character varying(60)<br>String</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Account Zip/Postal | |Account Zip/Postal | ||
| − | |Zip Code of the Credit Card or Account Holder | + | |Zip Code of the Credit Card or Account Holder |
|The Zip Code of the Credit Card or Account Holder. | |The Zip Code of the Credit Card or Account Holder. | ||
| − | |A_Zip<br>character varying(20)<br>String | + | |<small>I_Payment.A_Zip<br>character varying(20)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Account State | |Account State | ||
| − | + | |State of the Credit Card or Account holder | |
| − | |State of the Credit Card or Account holder | ||
|The State of the Credit Card or Account holder | |The State of the Credit Card or Account holder | ||
| − | |A_State<br>character varying(40)<br>String | + | |<small>I_Payment.A_State<br>character varying(40)<br>String</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Account Country | |Account Country | ||
| − | |Country | + | |Country |
|Account Country Name | |Account Country Name | ||
| − | |A_Country<br>character varying(40)<br>String | + | |<small>I_Payment.A_Country<br>character varying(40)<br>String</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Driver License | |Driver License | ||
| − | |Payment Identification - Driver License | + | |Payment Identification - Driver License |
|The Driver's License being used as identification. | |The Driver's License being used as identification. | ||
| − | |A_Ident_DL<br>character varying(20)<br>String | + | |<small>I_Payment.A_Ident_DL<br>character varying(20)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Social Security No | |Social Security No | ||
| − | + | |Payment Identification - Social Security No | |
| − | |Payment Identification - Social Security No | ||
|The Social Security number being used as identification. | |The Social Security number being used as identification. | ||
| − | |A_Ident_SSN<br>character varying(20)<br>String | + | |<small>I_Payment.A_Ident_SSN<br>character varying(20)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Account EMail | |Account EMail | ||
| − | + | |Email Address | |
| − | |Email Address | ||
|The EMail Address indicates the EMail address off the Credit Card or Account holder. | |The EMail Address indicates the EMail address off the Credit Card or Account holder. | ||
| − | |A_EMail<br>character varying(60)<br>String | + | |<small>I_Payment.A_EMail<br>character varying(60)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Voice authorization code | |Voice authorization code | ||
| − | + | |Voice Authorization Code from credit card company | |
| − | |Voice Authorization Code from credit card company | ||
|The Voice Authorization Code indicates the code received from the Credit Card Company. | |The Voice Authorization Code indicates the code received from the Credit Card Company. | ||
| − | |VoiceAuthCode<br>character varying(20)<br>String | + | |<small>I_Payment.VoiceAuthCode<br>character varying(20)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Original Transaction ID | |Original Transaction ID | ||
|Original Transaction ID | |Original Transaction ID | ||
| − | |||
|The Original Transaction ID is used for reversing transactions and indicates the transaction that has been reversed. | |The Original Transaction ID is used for reversing transactions and indicates the transaction that has been reversed. | ||
| − | |Orig_TrxID<br>character varying(20)<br>String | + | |<small>I_Payment.Orig_TrxID<br>character varying(20)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Approved | |Approved | ||
| − | + | |Indicates if this document requires approval | |
| − | |Indicates if this document requires approval | ||
|The Approved checkbox indicates if this document requires approval before it can be processed. | |The Approved checkbox indicates if this document requires approval before it can be processed. | ||
| − | |IsApproved<br>character(1)<br>Yes-No | + | |<small>I_Payment.IsApproved<br>character(1)<br>Yes-No</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Result | |Result | ||
| − | + | |Result of transmission | |
| − | |Result of transmission | ||
|The Response Result indicates the result of the transmission to the Credit Card Company. | |The Response Result indicates the result of the transmission to the Credit Card Company. | ||
| − | |R_Result<br>character varying(20)<br>String | + | |<small>I_Payment.R_Result<br>character varying(20)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Response Message | |Response Message | ||
| − | + | |Response message | |
| − | |Response message | ||
|The Response Message indicates the message returned from the Credit Card Company as the result of a transmission | |The Response Message indicates the message returned from the Credit Card Company as the result of a transmission | ||
| − | |R_RespMsg<br>character varying(60)<br>String | + | |<small>I_Payment.R_RespMsg<br>character varying(60)<br>String</small> |
| − | |-valign="top" | + | |-valign="top" |
| − | |||
| − | |||
| − | |||
| − | |||
|Reference | |Reference | ||
| − | |Payment reference | + | |Payment reference |
|The Payment Reference indicates the reference returned from the Credit Card Company for a payment | |The Payment Reference indicates the reference returned from the Credit Card Company for a payment | ||
| − | |R_PnRef<br>character varying(20)<br>String | + | |<small>I_Payment.R_PnRef<br>character varying(20)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Authorization Code | |Authorization Code | ||
| − | + | |Authorization Code returned | |
| − | |Authorization Code returned | ||
|The Authorization Code indicates the code returned from the electronic transmission. | |The Authorization Code indicates the code returned from the electronic transmission. | ||
| − | |R_AuthCode<br>character varying(20)<br>String | + | |<small>I_Payment.R_AuthCode<br>character varying(20)<br>String</small> |
| − | + | |-valign="top" | |
| − | |||
| − | |||
| − | |-valign="top" | ||
|Import Payments | |Import Payments | ||
|Import Payments | |Import Payments | ||
| − | |||
|The Parameters are default values for null import record values, they do not overwrite any data. | |The Parameters are default values for null import record values, they do not overwrite any data. | ||
| − | |Processing<br>character(1)<br>Button | + | |<small>I_Payment.Processing<br>character(1)<br>Button</small> |
| − | |||
| − | |||
|} | |} | ||
Latest revision as of 23:17, 4 April 2023
Window: Import Payment
Description: Import Payments
Help:
Tab: Payment
Description: Import Payments
Help:
.png)
| 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 |
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | I_Payment.AD_Client_ID numeric(10) Table Direct |
| 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. | 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 |
