Window: Payment Transaction
[Created: 22/10/2012 - Updated: 22/10/2012 ]
Description: Payment Transactions
Help:
Tab: Payment Transaction
[Created: 22/10/2012 - Updated: 01/11/2012 ]
Description:
Help:
Tab Level: 0
Table 10: Payment Transaction - Fields
Table: Report Parameters
| Name | Description | Help | Technical Info |
|---|---|---|---|
| Tenant | Tenant for this installation. | A Tenant is a company or a legal entity. You cannot share data between Tenants. | c_paymenttransaction.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. | c_paymenttransaction.AD_Org_ID numeric(10) Table Direct |
| Payment Transaction | c_paymenttransaction.C_PaymentTransaction_ID numeric(10) ID | ||
| Bank Account | Account at the Bank | The Bank Account identifies an account at this Bank. | c_paymenttransaction.C_BankAccount_ID numeric(10) Table Direct |
| Receipt | This is a sales transaction (receipt) | c_paymenttransaction.IsReceipt character(1) Yes-No | |
| Business Partner | Identifies a Business Partner | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | c_paymenttransaction.C_BPartner_ID numeric(10) Search |
| Transaction Date | Transaction Date | The Transaction Date indicates the date of the transaction. | c_paymenttransaction.DateTrx timestamp without time zone Date |
| Description | Optional short description of the record | A description is limited to 255 characters. | c_paymenttransaction.Description character varying(255) String |
| Invoice | Invoice Identifier | The Invoice Document. | c_paymenttransaction.C_Invoice_ID numeric(10) Search |
| Order | Order | The Order is a control document. The Order is complete when the quantity ordered is the same as the quantity shipped and invoiced. When you close an order, unshipped (backordered) quantities are cancelled. | c_paymenttransaction.C_Order_ID numeric(10) Search |
| Project | Financial Project | A Project allows you to track and control internal or external activities. | c_paymenttransaction.C_Project_ID numeric(10) Table Direct |
| Charge | Additional document charges | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | c_paymenttransaction.C_Charge_ID numeric(10) Table Direct |
| Activity | Business Activity | Activities indicate tasks that are performed and used to utilize Activity based Costing | c_paymenttransaction.C_Activity_ID numeric(10) Table Direct |
| Campaign | Marketing Campaign | The Campaign defines a unique marketing program. Projects can be associated with a pre defined Marketing Campaign. You can then report based on a specific Campaign. | c_paymenttransaction.C_Campaign_ID numeric(10) Table Direct |
| Trx Organization | Performing or initiating organization | The organization which performs or initiates this transaction (for another organization). The owning Organization may not be the transaction organization in a service bureau environment, with centralized services, and inter-organization transactions. | c_paymenttransaction.AD_OrgTrx_ID numeric(10) Table |
| User Element List 1 | User defined list element #1 | The user defined element displays the optional elements that have been defined for this account combination. | c_paymenttransaction.User1_ID numeric(10) Search |
| User Element List 2 | User defined list element #2 | The user defined element displays the optional elements that have been defined for this account combination. | c_paymenttransaction.User2_ID numeric(10) Search |
| 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. | c_paymenttransaction.PayAmt numeric Amount |
| Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | c_paymenttransaction.C_Currency_ID numeric(10) Table Direct |
| Currency Type | Currency Conversion Rate Type | The Currency Conversion Rate Type lets you define different type of rates, e.g. Spot, Corporate and/or Sell/Buy rates. | c_paymenttransaction.C_ConversionType_ID numeric(10) Table Direct |
| Tender type | Method of Payment | The Tender Type indicates the method of payment (ACH or Direct Deposit, Credit Card, Check, Direct Debit) | c_paymenttransaction.TenderType character(1) List |
| POS Tender Type | c_paymenttransaction.C_POSTenderType_ID numeric(10) Table Direct | ||
| Online Access | Can be accessed online | The Online Access check box indicates if the application can be accessed via the web. | c_paymenttransaction.IsOnline character(1) Yes-No |
| Partner Bank Account | Bank Account of the Business Partner | The Partner Bank Account identifies the bank account to be used for this Business Partner | c_paymenttransaction.C_BP_BankAccount_ID numeric(10) Table Direct |
| Routing No | Bank Routing Number | The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions. | c_paymenttransaction.RoutingNo character varying(20) String |
| Account No | Account Number | The Account Number indicates the Number assigned to this bank account. | c_paymenttransaction.AccountNo character varying(20) String |
| IBAN | International Bank Account Number | If your bank provides an International Bank Account Number, enter it hereDetails 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. | c_paymenttransaction.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 | c_paymenttransaction.SwiftCode character varying(20) String |
| Check No | Check Number | The Check Number indicates the number on the check. | c_paymenttransaction.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 | c_paymenttransaction.Micr character varying(20) String |
| 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. | c_paymenttransaction.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. | c_paymenttransaction.TrxType character(1) List |
| Number | Credit Card Number | The Credit Card number indicates the number on the credit card, without blanks or spaces. | c_paymenttransaction.CreditCardNumber character varying(20) String |
| Verification Code | Credit Card Verification code on credit card | The Credit Card Verification indicates the verification code on the credit card (AMEX 4 digits on front; MC,Visa 3 digits back) | c_paymenttransaction.CreditCardVV character varying(4) String |
| Exp. Month | Expiry Month | The Expiry Month indicates the expiry month for this credit card. | c_paymenttransaction.CreditCardExpMM numeric(10) Integer |
| Exp. Year | Expiry Year | The Expiry Year indicates the expiry year for this credit card. | c_paymenttransaction.CreditCardExpYY numeric(10) Integer |
| Account Name | Name on Credit Card or Account holder | The Name of the Credit Card or Account holder. | c_paymenttransaction.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. | c_paymenttransaction.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 | c_paymenttransaction.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. | c_paymenttransaction.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 | c_paymenttransaction.A_State character varying(40) String |
| Account Country | Country | Account Country Name | c_paymenttransaction.A_Country character varying(40) String |
| Driver License | Payment Identification - Driver License | The Driver's License being used as identification. | c_paymenttransaction.A_Ident_DL character varying(20) String |
| Social Security No | Payment Identification - Social Security No | The Social Security number being used as identification. | c_paymenttransaction.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. | c_paymenttransaction.A_EMail character varying(60) String |
| Tax Amount | Tax Amount for a document | The Tax Amount displays the total tax amount for a document. | c_paymenttransaction.TaxAmt numeric Amount |
| PO Number | Purchase Order Number | The PO Number indicates the number assigned to a purchase order | c_paymenttransaction.PONum 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. | c_paymenttransaction.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. | c_paymenttransaction.Orig_TrxID character varying(20) String |
| Void It | c_paymenttransaction.VoidIt character(1) Button | ||
| Approved | Indicates if this document requires approval | The Approved checkbox indicates if this document requires approval before it can be processed. | c_paymenttransaction.IsApproved character(1) Yes-No |
| Delayed Capture | Charge after Shipment | Delayed Capture is required, if you ship products. The first credit card transaction is the Authorization, the second is the actual transaction after the shipment of the product. | c_paymenttransaction.IsDelayedCapture character(1) Yes-No |
| Result | Result of transmission | The Response Result indicates the result of the transmission to the Credit Card Company. | c_paymenttransaction.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 | c_paymenttransaction.R_RespMsg character varying(60) String |
| Info | Response info | The Info indicates any response information returned from the Credit Card Company. | c_paymenttransaction.R_Info character varying(2000) String |
| Voided | c_paymenttransaction.IsVoided character(1) Yes-No | ||
| Void Message | c_paymenttransaction.R_VoidMsg character varying(255) Text | ||
| Reference | Payment reference | The Payment Reference indicates the reference returned from the Credit Card Company for a payment | c_paymenttransaction.R_PnRef character varying(20) String |
| Authorization Code | Authorization Code returned | The Authorization Code indicates the code returned from the electronic transmission. | c_paymenttransaction.R_AuthCode character varying(20) String |
| Zip verified | The Zip Code has been verified | The Zip Verified indicates if the zip code has been verified by the Credit Card Company. | c_paymenttransaction.R_AvsZip character(1) List |
| Address verified | This address has been verified | The Address Verified indicates if the address has been verified by the Credit Card Company. | c_paymenttransaction.R_AvsAddr character(1) List |
| CVV Match | Credit Card Verification Code Match | The Credit Card Verification Code was matched | c_paymenttransaction.R_CVV2Match character(1) Yes-No |
| Payment Processor | Payment processor for electronic payments | The Payment Processor indicates the processor to be used for electronic payments | c_paymenttransaction.C_PaymentProcessor_ID numeric(10) Table Direct |
| Customer Payment Profile ID | c_paymenttransaction.CustomerPaymentProfileID character varying(60) String | ||
| Customer Profile ID | c_paymenttransaction.CustomerProfileID character varying(60) String | ||
| Customer Address ID | c_paymenttransaction.CustomerAddressID character varying(60) String | ||
| Payment | Payment identifier | The Payment is a unique identifier of this payment. | c_paymenttransaction.C_Payment_ID numeric(10) Search |
| Cash Book | Cash Book for recording petty cash transactions | The Cash Book identifies a unique cash book. The cash book is used to record cash transactions. | c_paymenttransaction.C_CashBook_ID numeric(10) Table Direct |
| Payment Batch | Payment batch for EFT | Electronic Fund Transfer Payment Batch. | c_paymenttransaction.C_PaymentBatch_ID numeric(10) Search |
| Referenced Payment Transaction | c_paymenttransaction.Ref_PaymentTransaction_ID numeric(10) Search | ||
| Self-Service | This is a Self-Service entry or this entry can be changed via Self-Service | Self-Service allows users to enter data or update their data. The flag indicates, that this record was entered or created via Self-Service or that the user can change it via the Self-Service functionality. | c_paymenttransaction.IsSelfService character(1) Yes-No |
| Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | c_paymenttransaction.Processed character(1) Yes-No |