报表行组合 (窗口 ID-218)
来自iDempiere zh
窗口: 报表行组合
描述: Maintain Financial Report Line Sets
幫助: The Line Set determines, which lines are printed in a Financial Report
TAB: 报表行组合
描述: Maintain Financial Report Line Set
幫助 null
File:报表行组合 - 报表行组合 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Report Line Set | 报表行组合 | null | null | PA_ReportLineSet_ID numeric(10) NOT NULL ID |
| Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL 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) NOT NULL Table Direct |
| 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) NOT NULL String |
| Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
| 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) NOT NULL Yes-No |
| Copy Lines | 复制明细 | 从其他的线组合复印报表行 | 复制在结束的时候这条线组合 | Processing character(1) NOT NULL Button |
TAB: 报表行
描述: Maintain Financial Report Line
幫助 null
File:报表行组合 - 报表行 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Report Line | 报表行 | null | null | PA_ReportLine_ID numeric(10) NOT NULL ID |
| Parent | 父类 | 实体的父类 | The Parent indicates the value used to represent a summary level or report to level for a record | Parent_ID numeric(10) Table |
| 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) NOT NULL Yes-No |
| Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL 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) NOT NULL Table Direct |
| Report Line Set | 报表行组合 | null | null | PA_ReportLineSet_ID numeric(10) NOT NULL Table Direct |
| 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) NOT NULL String |
| Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
| 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) NOT NULL Yes-No |
| Printed | 已打印 | Indicates if this document is printed | The Printed checkbox indicates if this document will be printed. | IsPrinted character(1) NOT NULL Yes-No |
| Sequence | 序列 | Method of ordering records; lowest number comes first | The Sequence indicates the order of records | SeqNo numeric(10) NOT NULL Integer |
| Line Type | 行类型 | null | null | LineType character(1) NOT NULL List |
| Calculation | 计算 | null | null | CalculationType character(1) List |
| Operand 1 | 运算元 1 | 首先运算元为计算 | null | Oper_1_ID numeric(10) Table |
| Operand 2 | 运算元 2 | Second operand for calculation | null | Oper_2_ID numeric(10) Table |
| 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 |
| Amount Type | Amount Type | Type of amount to report | You can choose between the total and period amounts as well as the balance or just the debit/credit amounts. | AmountType character(2) List |
| Amount Type | Amount Type | PA Amount Type for reporting | The amount type to report on: Quantity, Credit Only, Debit Only, Balance (expected sign) or Balance (accounted sign). "Expected sign" adjusts the sign of the result based on the Account Type and Expected Sign of each Account Element, whereas "accounted sign" always returns DR-CR. | PAAmountType character(1) List |
| Period Type | Period Type | PA Period Type | The Period Type to report on: Period, Year, Total or Natural. Natural = Year for P & L accounts, Total for Balance Sheet accounts. | PAPeriodType character(1) List |
TAB: 报表来源
描述: Maintain Segment Values of Report Line Source
幫助 null
File:报表行组合 - 报表来源 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL 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) NOT NULL Table Direct |
| Report Line | 报表行 | null | null | PA_ReportLine_ID numeric(10) NOT NULL Table Direct |
| Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
| 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) NOT NULL Yes-No |
| Type | 类型 | Element Type (account or user defined) | 元素类型标明此元素是财务元素还是自定义元素。 | ElementType character(2) NOT NULL List |
| Organization | 机构 | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. | Org_ID numeric(10) Table |
| Include Nulls in Org | Include Nulls in Org | Include nulls in the selection of the organization | null | IsIncludeNullsOrg character(1) NOT NULL Yes-No |
| 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 |
| Include Nulls in Org Trx | Include Nulls in Org Trx | Include nulls in the selection of the organization transaction | null | IsIncludeNullsOrgTrx character(1) NOT NULL Yes-No |
| Account Element | 会计科目 | 会计科目 | Account Elements can be natural accounts or user defined values. | C_ElementValue_ID numeric(10) Table |
| Include Nulls in Account | Include Nulls in Account | Include nulls in the selection of the account | null | IsIncludeNullsElementValue character(1) NOT NULL Yes-No |
| Business Partner | 业务伙伴 | 标识业务伙伴 | A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson | C_BPartner_ID numeric(10) Table Direct |
| Include Nulls in BPartner | Include Nulls in BPartner | Include nulls in the selection of the business partner | null | IsIncludeNullsBPartner character(1) NOT NULL Yes-No |
| Product | 产品 | Product, Service, Item | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) Table Direct |
| Include Nulls in Product | Include Nulls in Product | Include nulls in the selection of the product | null | IsIncludeNullsProduct character(1) NOT NULL Yes-No |
| Address | 地址 | 位置或地址 | The Location Address field defines the location of an entity. | C_Location_ID numeric(10) Location (Address) |
| Include Nulls in Location | Include Nulls in Location | Include nulls in the selection of the location | null | IsIncludeNullsLocation character(1) NOT NULL Yes-No |
| Project | 项目 | 财务项目 | Project ID is a user defined identifier for a Project | C_Project_ID numeric(10) Table Direct |
| Include Nulls in Project | Include Nulls in Project | Include nulls in the selection of the project | null | IsIncludeNullsProject character(1) NOT NULL Yes-No |
| Sales Region | 销售区域 | 销售报导区域 | The Sales Region indicates a specific area of sales coverage. | C_SalesRegion_ID numeric(10) Table Direct |
| Include Nulls in Sales Region | Include Nulls in Sales Region | Include nulls in the selection of the sales region | null | IsIncludeNullsSalesRegion character(1) NOT NULL Yes-No |
| Activity | 活动 | 业务活动 | Activities indicate tasks that are performed and used to utilize Activity based Costing | C_Activity_ID numeric(10) Table Direct |
| Include Nulls in Activity | Include Nulls in Activity | Include nulls in the selection of the activity | null | IsIncludeNullsActivity character(1) NOT NULL Yes-No |
| 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 |
| Include Nulls in Campaign | Include Nulls in Campaign | Include nulls in the selection of the campaign | null | IsIncludeNullsCampaign character(1) NOT NULL Yes-No |
| User Element 1 | User Element 1 | User defined accounting Element | A user defined accounting element refers to a Adempiere table. This allows to use any table content as an accounting dimension (e.g. Project Task). Note that User Elements are optional and are populated from the context of the document (i.e. not requested) | UserElement1_ID numeric(10) ID |
| Include Nulls in User Element 1 | Include Nulls in User Element 1 | Include nulls in the selection of the user element 1 | null | IsIncludeNullsUserElement1 character(1) NOT NULL Yes-No |
| User Element 2 | User Element 2 | User defined accounting Element | A user defined accounting element refers to a Adempiere table. This allows to use any table content as an accounting dimension (e.g. Project Task). Note that User Elements are optional and are populated from the context of the document (i.e. not requested) | UserElement2_ID numeric(10) ID |
| Include Nulls in User Element 2 | Include Nulls in User Element 2 | Include nulls in the selection of the user element 2 | null | IsIncludeNullsUserElement2 character(1) NOT NULL Yes-No |
.png){kind=link}
.png){kind=link}
.png){kind=link}