ManPageW ImportPayment es

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

Volver al Indice

¡Disfrútalo y ayuda a completarlo! Pero por favor, siempre respetando los derechos de autor.

Por favor, escriba sus contribuciones bajo la Sección Contribuciones


Window: Import Payment

Description : Import Payments

Help :



Tab: Payment

Description : Import Payments

Help :

Table Name  : I_Payment

ManPageW ImportPayment Payment.png

Fields

Name Description Help Technical Data
Import Payment Import Payment I_Payment_ID

NUMBER(10)

ID

Imported Has this import been processed The Imported check box indicates if this import has been processed. I_IsImported

CHAR(1)

YesNo

Payment Payment identifier The Payment is a unique identifier of this payment. C_Payment_ID

NUMBER(10)

Search

Import Error Message Messages generated from import process The Import Error Message displays any error messages generated during the import process. I_ErrorMsg

NVARCHAR2(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. AD_Client_ID

NUMBER(10)

TableDir

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. AD_Org_ID

NUMBER(10)

TableDir

Bank Account No Bank Account Number BankAccountNo

NVARCHAR2(20)

String

Bank Account Account at the Bank The Bank Account identifies an account at this Bank. C_BankAccount_ID

NUMBER(10)

TableDir

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).

DocumentNo

NVARCHAR2(30)

String

Receipt This is a sales transaction (receipt) IsReceipt

CHAR(1)

YesNo

Document Type Name Name of the Document Type DocTypeName

NVARCHAR2(60)

String

Document Type Document type or rules The Document Type determines document sequence and processing rules C_DocType_ID

NUMBER(10)

TableDir

Transaction Date Transaction Date The Transaction Date indicates the date of the transaction. DateTrx

DATE

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. DateAcct

DATE

DateTime

Business Partner Key Key of the Business Partner BPartnerValue

NVARCHAR2(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 C_BPartner_ID

NUMBER(10)

Search

Invoice Document No Document Number of the Invoice InvoiceDocumentNo

NVARCHAR2(30)

String

Invoice Invoice Identifier The Invoice Document. C_Invoice_ID

NUMBER(10)

Search

ISO Currency Code Three letter ISO 4217 Code of the Currency For details - http://www.unece.org/trade/rec/rec09en.htm ISO_Code

CHAR(3)

String

Currency The Currency for this record Indicates the Currency to be used when processing or reporting on this record C_Currency_ID

NUMBER(10)

TableDir

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. PayAmt

NUMBER

Amount

Discount Amount Calculated amount of discount The Discount Amount indicates the discount amount for a document or line. DiscountAmt

NUMBER

Amount

Write-off Amount Amount to write-off The Write Off Amount indicates the amount to be written off as uncollectible. WriteOffAmt

NUMBER

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.

IsOverUnderPayment

CHAR(1)

YesNo

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.

OverUnderAmt

NUMBER

Amount

Tender type Method of Payment The Tender Type indicates the method of payment (ACH or Direct Deposit, Credit Card, Check, Direct Debit) TenderType

CHAR(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. CreditCardType

CHAR(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. TrxType

CHAR(1)

List

Number Credit Card Number The Credit Card number indicates the number on the credit card, without blanks or spaces. CreditCardNumber

NVARCHAR2(20)

String

Exp. Month Expiry Month The Expiry Month indicates the expiry month for this credit card. CreditCardExpMM

NUMBER(10)

Integer

Exp. Year Expiry Year The Expiry Year indicates the expiry year for this credit card. CreditCardExpYY

NUMBER(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. RoutingNo

NVARCHAR2(20)

String

Account No Account Number The Account Number indicates the Number assigned to this bank account. AccountNo

NVARCHAR2(20)

String

Check No Check Number The Check Number indicates the number on the check. CheckNo

NVARCHAR2(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 Micr

NVARCHAR2(20)

String

Account Name Name on Credit Card or Account holder The Name of the Credit Card or Account holder. A_Name

NVARCHAR2(60)

String

Account Street Street address of the Credit Card or Account holder The Street Address of the Credit Card or Account holder. A_Street

NVARCHAR2(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 A_City

NVARCHAR2(60)

String

Account Zip/Postal Zip Code of the Credit Card or Account Holder The Zip Code of the Credit Card or Account Holder. A_Zip

NVARCHAR2(20)

String

Account State State of the Credit Card or Account holder The State of the Credit Card or Account holder A_State

NVARCHAR2(40)

String

Account Country Country Account Country Name A_Country

NVARCHAR2(40)

String

Driver License Payment Identification - Driver License The Driver's License being used as identification. A_Ident_DL

NVARCHAR2(20)

String

Social Security No Payment Identification - Social Security No The Social Security number being used as identification. A_Ident_SSN

NVARCHAR2(20)

String

Account EMail Email Address The EMail Address indicates the EMail address off the Credit Card or Account holder. A_EMail

NVARCHAR2(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. VoiceAuthCode

NVARCHAR2(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. Orig_TrxID

NVARCHAR2(20)

String

Approved Indicates if this document requires approval The Approved checkbox indicates if this document requires approval before it can be processed. IsApproved

CHAR(1)

YesNo

Result Result of transmission The Response Result indicates the result of the transmission to the Credit Card Company. R_Result

NVARCHAR2(20)

String

Response Message Response message The Response Message indicates the message returned from the Credit Card Company as the result of a transmission R_RespMsg

NVARCHAR2(60)

String

Reference Payment reference The Payment Reference indicates the reference returned from the Credit Card Company for a payment R_PnRef

NVARCHAR2(20)

String

Authorization Code Authorization Code returned The Authorization Code indicates the code returned from the electronic transmission. R_AuthCode

NVARCHAR2(20)

String

Import Payments Import Payments The Parameters are default values for null import record values, they do not overwrite any data. Processing

CHAR(1)

Button

Contribuciones