Import Payment (Venster ID-280)

Venster: Import Payment

Beschrijving: Import Payments

Help: null

TAB: Payment

Beschrijving: Import Payments

Help null

Bestand:Import Payment - Payment - Venster (iDempiere 1.0.0).png

Naam	Naam	Beschrijving	Help	Specificaties
Import Payment	Import Payment	Import Payment	null	I_Payment_ID numeric(10) NOT NULL ID
Imported	Imported	Has this import been processed	The Imported check box indicates if this import has been processed.	I_IsImported character(1) NOT NULL Yes-No
Payment	Payment	Payment identifier	The Payment is a unique identifier of this payment.	C_Payment_ID numeric(10) Search
Import Error Message	Import Error Message	Messages generated from import process	The Import Error Message displays any error messages generated during the import process.	I_ErrorMsg character varying(2000) String
Client	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 numeric(10) Table Direct
Organization	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 numeric(10) Table Direct
Bank Account No	Bank Account No	Bank Account Number	null	BankAccountNo character varying(20) String
Bank Account	Bank Rekening (Bank Account)	Account at the Bank	The Bank Account identifies an account at this Bank.	C_BankAccount_ID numeric(10) Table Direct
Document No	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 character varying(30) String
Receipt	Receipt	This is a sales transaction (receipt)	null	IsReceipt character(1) Yes-No
Document Type Name	Document Type Name	Name of the Document Type	null	DocTypeName character varying(60) String
Document Type	Document Type	Document type or rules	The Document Type determines document sequence and processing rules	C_DocType_ID numeric(10) Table Direct
Transaction Date	Transaction Date	Transaction Date	The Transaction Date indicates the date of the transaction.	DateTrx timestamp without time zone Date
Account 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 timestamp without time zone Date+Time
Business Partner Key	Business Partner Key	Key of the Business Partner	null	BPartnerValue character varying(40) String
Business Partner	Relatie	Identifies a Business Partner	A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson	C_BPartner_ID numeric(10) Search
Invoice Document No	Invoice Document No	Document Number of the Invoice	null	InvoiceDocumentNo character varying(30) String
Invoice	Invoice	Invoice Identifier	The Invoice Document.	C_Invoice_ID numeric(10) Search
ISO Currency Code	ISO Currency Code	Three letter ISO 4217 Code of the Currency	For details - http://www.unece.org/trade/rec/rec09en.htm	ISO_Code character(3) String
Currency	Munteenheid	The Currency for this record	Indicates the Currency to be used when processing or reporting on this record	C_Currency_ID numeric(10) Table Direct
Payment amount	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 numeric Amount
Discount Amount	Discount Amount	Calculated amount of discount	The Discount Amount indicates the discount amount for a document or line.	DiscountAmt numeric Amount
Write-off Amount	Write-off Amount	Amount to write-off	The Write Off Amount indicates the amount to be written off as uncollectible.	WriteOffAmt numeric Amount
Over/Under Payment	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 character(1) Yes-No
Over/Under Payment	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 numeric Amount
Tender type	Tender type	Method of Payment	The Tender Type indicates the method of payment (ACH or Direct Deposit, Credit Card, Check, Direct Debit)	TenderType character(1) List
Credit Card	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 character(1) List
Transaction Type	Transaction Type	Type of credit card transaction	The Transaction Type indicates the type of transaction to be submitted to the Credit Card Company.	TrxType character(1) List
Number	Nummer	Credit Card Number	The Credit Card number indicates the number on the credit card, without blanks or spaces.	CreditCardNumber character varying(20) String
Exp. Month	Verval Maand	Expiry Month	The Expiry Month indicates the expiry month for this credit card.	CreditCardExpMM numeric(10) Integer
Exp. Year	Verval Jaar	Expiry Year	The Expiry Year indicates the expiry year for this credit card.	CreditCardExpYY numeric(10) Integer
Routing No	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 character varying(20) String
Account No	Account No	Account Number	The Account Number indicates the Number assigned to this bank account.	AccountNo character varying(20) String
Check No	Check No	Check Number	The Check Number indicates the number on the check.	CheckNo character varying(20) String
Micr	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 character varying(20) String
Account Name	Account Naam	Name on Credit Card or Account holder	The Name of the Credit Card or Account holder.	A_Name character varying(60) String
Account Street	Account Street	Street address of the Credit Card or Account holder	The Street Address of the Credit Card or Account holder.	A_Street character varying(60) String
Account City	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 character varying(60) String
Account Zip/Postal	Account Zip/Postal	Zip Code of the Credit Card or Account Holder	The Zip Code of the Credit Card or Account Holder.	A_Zip character varying(20) String
Account State	Account State	State of the Credit Card or Account holder	The State of the Credit Card or Account holder	A_State character varying(40) String
Account Country	Account Country	Land	Account Country Name	A_Country character varying(40) String
Driver License	Driver License	Payment Identification - Driver License	The Driver's License being used as identification.	A_Ident_DL character varying(20) String
Social Security No	Social Security No	Payment Identification - Social Security No	The Social Security number being used as identification.	A_Ident_SSN character varying(20) String
Account EMail	Account EMail	Email Address	The EMail Address indicates the EMail address off the Credit Card or Account holder.	A_EMail character varying(60) String
Voice authorization code	Voice authorization code	Voice Authorization Code from credit card company	The Voice Authorization Code indicates the code received from the Credit Card Company.	VoiceAuthCode character varying(20) String
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.	Orig_TrxID character varying(20) String
Approved	Approved	Indicates if this document requires approval	The Approved checkbox indicates if this document requires approval before it can be processed.	IsApproved character(1) Yes-No
Result	Resultaat	Result of transmission	The Response Result indicates the result of the transmission to the Credit Card Company.	R_Result character varying(20) String
Response Message	Response Message	Response message	The Response Message indicates the message returned from the Credit Card Company as the result of a transmission	R_RespMsg character varying(60) String
Reference	Referentie	Payment reference	The Payment Reference indicates the reference returned from the Credit Card Company for a payment	R_PnRef character varying(20) String
Authorization Code	Authorization Code	Authorization Code returned	The Authorization Code indicates the code returned from the electronic transmission.	R_AuthCode character varying(20) String
Import Payments	Import Payments	Import Payments	The Parameters are default values for null import record values, they do not overwrite any data.	Processing character(1) Button