Difference between revisions of "Adempiere3.2.0/en/ManPageW ImportBankStatement olh"
(No difference)
|
Latest revision as of 22:14, 17 May 2007
Window: Import Bank Statement
Description : Import Bank Statements
Help :
Tab: Bank Statement
Description : Import Bank Statement
Help :
Table Name : I_BankStatement
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Import Bank Statement | Import of the Bank Statement | I_BankStatement_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 |
Bank Statement | Bank Statement of account | The Bank Statement identifies a unique Bank Statement for a defined time period. The statement defines all transactions that occurred | C_BankStatement_ID
NUMBER(10) Search |
Bank statement line | Line on a statement from this Bank | The Bank Statement Line identifies a unique transaction (Payment, Withdrawal, Charge) for the defined time period at this Bank. | C_BankStatementLine_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 |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
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 |
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 |
Statement date | Date of the statement | The Statement Date field defines the date of the statement. | StatementDate
DATE Date |
Line No | Unique line for this document | Indicates the unique line for a document. It will also control the display order of the lines within a document. | Line
NUMBER(10) Integer |
Reference No | Your customer or vendor number at the Business Partner's site | The reference number can be printed on orders and invoices to allow your business partner to faster identify your records. | ReferenceNo
NVARCHAR2(40) String |
Line Description | Description of the Line | LineDescription
NVARCHAR2(255) String | |
Statement Line Date | Date of the Statement Line | StatementLineDate
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 Date |
Effective date | Date when money is available | The Effective Date indicates the date that money is available from the bank. | ValutaDate
DATE Date |
Reversal | This is a reversing transaction | The Reversal check box indicates if this is a reversal of a prior transaction. | IsReversal
CHAR(1) YesNo |
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 |
Transaction Amount | Amount of a transaction | The Transaction Amount indicates the amount for a single transaction. | TrxAmt
NUMBER Amount |
Statement amount | Statement Amount | The Statement Amount indicates the amount of a single statement line. | StmtAmt
NUMBER Amount |
Charge Name | Name of the Charge | ChargeName
NVARCHAR2(60) String | |
Charge | Additional document charges | The Charge indicates a type of Charge (Handling, Shipping, Restocking) | C_Charge_ID
NUMBER(10) TableDir |
Interest Amount | Interest Amount | The Interest Amount indicates any interest charged or received on a Bank Statement. | InterestAmt
NUMBER Amount |
Charge amount | Charge Amount | The Charge Amount indicates the amount for an additional charge. | ChargeAmt
NUMBER Amount |
Memo | Memo Text | Memo
NVARCHAR2(255) String | |
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 |
Payment Document No | Document number of the Payment | PaymentDocumentNo
NVARCHAR2(30) String | |
Payment | Payment identifier | The Payment is a unique identifier of this payment. | C_Payment_ID
NUMBER(10) Search |
Transaction Type | Type of credit card transaction | The Transaction Type indicates the type of transaction to be submitted to the Credit Card Company. | TrxType
VARCHAR2 List |
Match Bank Statement | Match Bank Statement Info to Business Partners, Invoices and Payments | MatchStatement
CHAR(1) Button | |
Import Bank Statement | Import Bank Statement | The Parameters are default values for null import record values, they do not overwrite any data. | Processing
CHAR(1) Button |
Create Payment | Create Payment from Bank Statement Info | CreatePayment
CHAR(1) Button | |
Processed | The document has been processed | The Processed checkbox indicates that a document has been processed. | Processed
CHAR(1) YesNo |
EFT Statement Reference | Electronic Funds Transfer Statement Reference | Information from EFT media | EftStatementReference
NVARCHAR2(60) String |
EFT Statement Date | Electronic Funds Transfer Statement Date | Information from EFT media | EftStatementDate
DATE Date |
EFT Trx ID | Electronic Funds Transfer Transaction ID | Information from EFT media | EftTrxID
NVARCHAR2(40) String |
EFT Trx Type | Electronic Funds Transfer Transaction Type | Information from EFT media | EftTrxType
NVARCHAR2(20) String |
EFT Check No | Electronic Funds Transfer Check No | Information from EFT media | EftCheckNo
NVARCHAR2(20) String |
EFT Reference | Electronic Funds Transfer Reference | Information from EFT media | EftReference
NVARCHAR2(60) String |
EFT Memo | Electronic Funds Transfer Memo | Information from EFT media | EftMemo
NVARCHAR2(2000) String |
EFT Payee | Electronic Funds Transfer Payee information | Information from EFT media | EftPayee
NVARCHAR2(255) String |
EFT Payee Account | Electronic Funds Transfer Payyee Account Information | Information from EFT media | EftPayeeAccount
NVARCHAR2(40) String |
EFT Statement Line Date | Electronic Funds Transfer Statement Line Date | Information from EFT media | EftStatementLineDate
DATE Date |
EFT Effective Date | Electronic Funds Transfer Valuta (effective) Date | Information from EFT media | EftValutaDate
DATE Date |
EFT Currency | Electronic Funds Transfer Currency | Information from EFT media | EftCurrency
NVARCHAR2(20) String |
EFT Amount | Electronic Funds Transfer Amount | EftAmt
NUMBER Amount |