导入帐户 (窗口 ID-248)
窗口: 导入帐户
描述: 导入普通的帐户值
幫助: The Import Natural Account Window is an interim table which is used when importing external data into the system. Selecting the 'Process' button will either add or modify the appropriate records.
TAB: 导入帐户
描述: null
幫助 null
File:导入帐户 - 导入帐户 - 窗口 (iDempiere 1.0.0).png
名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
---|---|---|---|---|
Active | 有效 | 本记录有效 | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive character(1) Yes-No |
Import Account | 导入帐户 | 导入帐户值 | null | I_ElementValue_ID numeric(10) NOT NULL ID |
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 |
Account Element | 会计科目 | 会计科目 | Account Elements can be natural accounts or user defined values. | C_ElementValue_ID numeric(10) Table Direct |
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 | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) Table Direct |
Organization | 机构 | 客户内的机构实体。 | 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 |
Element Name | 元素名 | 元素名 | null | ElementName character varying(60) String |
Element | 会计科目 | 会计科目 | The Account Element uniquely identifies an Account Type. These are commonly known as a Chart of Accounts. | C_Element_ID numeric(10) Table Direct |
Search Key | 检索关键字 | 记录的检索关键字在格式上是必须的 -并且必须唯一 | A search key allows you a fast method of finding a particular record.
If you leave the search key empty, the system automatically creates a numeric number. 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). |
Value character varying(40) String |
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 character varying(60) String |
Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
Account Type | 帐户类型 | 指示帐户的类型 | Valid account types are A - Asset, E - Expense, L - Liability, O- Owner's Equity, R -Revenue and M- Memo. The account type is used to determine what taxes, if any are applicable, validating payables and receivables for business partners. Note: Memo account amounts are ignored when checking for balancing | AccountType character(1) List |
Account Sign | 财务符号 | Indicates the Natural Sign of the Account as a Debit or Credit | Indicates if the expected balance for this account should be a Debit or a Credit. | AccountSign character(1) List |
Summary Level | 汇总级别 | 这是父类实体 | A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values. | IsSummary character(1) Yes-No |
Parent Key | 父类关键字 | 是否父类关键字 | null | ParentValue character varying(40) String |
Parent Account | 父类帐户 | 父类帐户 | null | ParentElementValue_ID numeric(10) Table |
Post Actual | 过帐实际值 | 可过帐实际值 | The Post Actual indicates if actual values can be posted to this element value. | PostActual character(1) Yes-No |
Post Budget | 过帐预算 | 预算值可被过帐 | The Post Budget indicates if budget values can be posted to this element value. | PostBudget character(1) Yes-No |
Post Statistical | 过帐统计数量 | Post statistical quantities to this account? | null | PostStatistical character(1) Yes-No |
Post Encumbrance | 过帐债权 | Post commitments to this account | null | PostEncumbrance character(1) Yes-No |
Document Controlled | 文档受控 | Control account - If an account is controlled by a document, you cannot post manually to it | null | IsDocControlled character(1) Yes-No |
Default Account | 缺省帐户 | Name of the Default Account Column | null | Default_Account character varying(30) String |
Column | 列 | 在表中的列 | 链接到数据库表中的列。 | AD_Column_ID numeric(10) Table |
Import Accounts | 导入帐户 | 导入普通的帐户 | Import accounts and their hierarchies and optional update the default accounts.
Updating the Default Accounts changes the natural account segment of the used account, e.g. account 01-240 becomes 01-300). If you create a new combination, the old account (e.g. 01-240) will remain, otherwise replaced. If you select this, make sure that you not multiple default accounts using one natural account and HAVE A BACKUP !! The Parameters are default values for null import record values, they do not overwrite any data. |
Processing character(1) Button |
Processed | 已处理 | The document has been processed | The Processed checkbox indicates that a document has been processed. | Processed character(1) Yes-No |