导入总帐分类帐 (窗口 ID-278)

来自iDempiere zh
跳转至:导航搜索



窗口: 导入总帐分类帐

描述: Import General Ledger Journals

幫助: null



TAB: 通用分类帐

描述: 导入指挥分类帐


幫助 null


File:导入总帐分类帐 - 通用分类帐 - 窗口 (iDempiere 1.0.0).png




名稱 名稱 描述 幫助 產品規格
Import GL Journal 导入总帐分类帐 Import General Ledger Journal null I_GLJournal_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
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
Journal Batch 分类帐批次 通用分类帐分类帐批次 The General Ledger Journal Batch identifies a group of journals to be processed as a group. GL_JournalBatch_ID
numeric(10)
Search
Client Key 实体关键字 客户的关键字 null ClientValue
character varying(40)
String
Client 客户 安装此软件的客户 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 AD_Client_ID
numeric(10)
Table Direct
Document Org Document Org Document Organization (independent from account organization) null AD_OrgDoc_ID
numeric(10)
Table
Batch Document No 批文件号 文档批的数字 null BatchDocumentNo
character varying(30)
String
Create New Batch Create New Batch If selected a new batch is created Note that the balance check does not check that individual batches are balanced. IsCreateNewBatch
character(1)
Yes-No
Batch Description 批描述 批的描述 null BatchDescription
character varying(255)
String
Journal 分类帐 通用分类帐分类帐 The General Ledger Journal identifies a group of journal lines which represent a logical business transaction GL_Journal_ID
numeric(10)
Search
Journal Document No Journal Document No Document number of the Journal null JournalDocumentNo
character varying(30)
String
Create New Journal Create New Journal If selected a new journal within the batch is created Note that the balance check does not check that individual journals are balanced. IsCreateNewJournal
character(1)
Yes-No
Account Schema Name 帐户模式名 会计模式的名称 null AcctSchemaName
character varying(60)
String
Accounting Schema 会计模式 帐户的规则 An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar C_AcctSchema_ID
numeric(10)
Table Direct
PostingType 过帐类型 The type of amount that this journal updated The Posting Type indicates the type of amount (Actual, Encumbrance, Budget) this journal updated. PostingType
character(1)
List
Budget 预算 通用分类帐预算 The General Ledger Budget identifies a user defined budget. These can be used in reporting as a comparison against your actual amounts. GL_Budget_ID
numeric(10)
Table Direct
Document Type Name 文件类型名 文件类型名 null DocTypeName
character varying(60)
String
Document Type 文件类型 文件类型或规则 The Document Type determines document sequence and processing rules C_DocType_ID
numeric(10)
Table Direct
Category Name 分类名 分类名 null CategoryName
character varying(60)
String
GL Category 总帐分类 总帐分类 The General Ledger Category is an optional, user defined method of grouping journal lines. GL_Category_ID
numeric(10)
Table Direct
Account Date 记账日期 记账日期 The Accounting Date indicates the date to be used on the General Ledger account entries generated from this document DateAcct
timestamp without time zone
Date
Period 分期 日历的分期 The Period indicates an exclusive range of dates for a calendar. C_Period_ID
numeric(10)
Table Direct
Journal Line 分类帐明细 通用分类帐分类帐明细 The General Ledger Journal Line identifies a single transaction in a journal. GL_JournalLine_ID
numeric(10)
Search
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
numeric(10)
Integer
Description 描述 该记录的可选描述 描述最多为 255 个字符。 Description
character varying(255)
String
Source Debit 借方来源 借方来源金额 The Source Debit Amount indicates the credit amount for this line in the source currency. AmtSourceDr
numeric
Amount
Source Credit 贷方来源 贷方来源金额 The Source Credit Amount indicates the credit amount for this line in the source currency. AmtSourceCr
numeric
Amount
ISO Currency Code ISO货币编码 币种的 ISO 4217 编码 For details - http: www.unece.org trade rec rec09en.htm ISO_Code
character(3)
String
Currency 货币 币种为该笔记录 Indicates the Currency to be used when processing or reporting on this record C_Currency_ID
numeric(10)
Table Direct
Currency Type Key Currency Type Key Key value for the Currency Conversion Rate Type The date type key for the conversion of foreign currency transactions ConversionTypeValue
character varying(40)
String
Currency Type 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_ConversionType_ID
numeric(10)
Table Direct
Rate 汇率 币种汇率 The Currency Conversion Rate indicates the rate to use when converting the source currency to the accounting currency CurrencyRate
numeric
Number
Accounted Debit 帐户借方 帐户借方金额 The Account Debit Amount indicates the transaction amount converted to this organization's accounting currency AmtAcctDr
numeric
Amount
Accounted Credit 帐户贷方 帐户贷方金额 The Account Credit Amount indicates the transaction amount converted to this organization's accounting currency AmtAcctCr
numeric
Amount
UOM 度量单位 度量单位 The UOM defines a unique non monetary Unit of Measure C_UOM_ID
numeric(10)
Table Direct
Quantity 数量 数量 The Quantity indicates the number of a specific product or item for this document. Qty
numeric
Quantity
Combination 组合 有效的帐户组合 The Combination identifies a valid combination of element which represent a GL account. C_ValidCombination_ID
numeric(10)
Search
Org Key 机构 关键字 机构的关键字 null OrgValue
character varying(40)
String
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
Account Key 帐户关键字 会计科目的关键字 null AccountValue
character varying(40)
String
Account 帐户 已使用帐户 帐户用 Account_ID
numeric(10)
Table
Business Partner Key 业务伙伴关键字 业务伙伴的关键字 null BPartnerValue
character varying(40)
String
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
Product Key 产品关键字 产品的关键字 null ProductValue
character varying(40)
String
UPC/EAN UPC/EAN条码 条形码 Use this field to enter the bar code for the product in any of the bar code symbologies (Codabar, Code 25, Code 39, Code 93, Code 128, UPC (A), UPC (E), EAN-13, EAN-8, ITF, ITF-14, ISBN, ISSN, JAN-13, JAN-8, POSTNET and FIM, MSI Plessey, and Pharmacode) UPC
character varying(30)
String
SKU SKU 存货保管单位 The SKU indicates a user defined stock keeping unit. It may be used for an additional bar code symbols or your own schema. SKU
character varying(30)
String
Product 产品 Product, Service, Item Identifies an item which is either purchased or sold in this organization. M_Product_ID
numeric(10)
Search
Project Key 项目关键字 项目的关键字 null ProjectValue
character varying(40)
String
Project 项目 财务项目 Project ID is a user defined identifier for a Project C_Project_ID
numeric(10)
Search
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_Campaign_ID
numeric(10)
Table Direct
Activity 活动 业务活动 Activities indicate tasks that are performed and used to utilize Activity based Costing C_Activity_ID
numeric(10)
Table Direct
Sales Region 销售区域 销售报导区域 The Sales Region indicates a specific area of sales coverage. C_SalesRegion_ID
numeric(10)
Table Direct
Trx Org Key 交易机构关键字 Key of the Transaction Organization null OrgTrxValue
character varying(40)
String
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. AD_OrgTrx_ID
numeric(10)
Table
Location From 来源位置 Location that inventory was moved from The Location From indicates the location that a product was moved from. C_LocFrom_ID
numeric(10)
Table
Location To 目标位置 Location that inventory was moved to The Location To indicates the location that a product was moved to. C_LocTo_ID
numeric(10)
Table
User List 1 User1 用户定义元素 #1 The user defined element displays the optional elements that have been defined for this account combination. User1_ID
numeric(10)
Table
User List 2 User2 用户定义元素 #2 The user defined element displays the optional elements that have been defined for this account combination. User2_ID
numeric(10)
Table
Import Journal Import Journal Import General Ledger Batch/Journal/Line 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


Contributions / Posts

Cookie帮助我们提供我们的服务。通过使用我们的服务,您同意我们使用cookie。