Report Line Set (Window ID-218)

From iDempiere en

Table of Contents

Window: Report Line Set

Description: Maintain Financial Report Line Sets

Help: The Line Set determines, which lines are printed in a Financial Report

Tab: Report Line Set

Description: Maintain Financial Report Line Set

Help:

Report Line Set - Report Line Set - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
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. PA_ReportLineSet.AD_Client_ID
numeric(10)
Table Direct
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. PA_ReportLineSet.AD_Org_ID
numeric(10)
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. PA_ReportLineSet.Name
character varying(60)
String
Description Optional short description of the record A description is limited to 255 characters. PA_ReportLineSet.Description
character varying(255)
String
Active The record is active in the system 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.

PA_ReportLineSet.IsActive
character(1)
Yes-No
Copy Lines Copy Report Lines from other Line Set Copy lines at the end of this Line Set. Please note that you need to re-set the calculation operands. PA_ReportLineSet.Processing
character(1)
Button

Tab: Report Line

Description: Maintain Financial Report Line

Help:

Report Line Set - Report Line - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
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. PA_ReportLine.AD_Client_ID
numeric(10)
Table Direct
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. PA_ReportLine.AD_Org_ID
numeric(10)
Table Direct
Report Line Set PA_ReportLine.PA_ReportLineSet_ID
numeric(10)
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. PA_ReportLine.Name
character varying(60)
String
Description Optional short description of the record A description is limited to 255 characters. PA_ReportLine.Description
character varying(255)
String
Active The record is active in the system 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.

PA_ReportLine.IsActive
character(1)
Yes-No
Printed Indicates if this document / line is printed The Printed checkbox indicates if this document or line will included when printing. PA_ReportLine.IsPrinted
character(1)
Yes-No
Sequence Method of ordering records; lowest number comes first The Sequence indicates the order of records PA_ReportLine.SeqNo
numeric(10)
Integer
Line Type PA_ReportLine.LineType
character(1)
List
Calculation PA_ReportLine.CalculationType
character(1)
List
Operand 1 First operand for calculation PA_ReportLine.Oper_1_ID
numeric(10)
Table
Operand 2 Second operand for calculation PA_ReportLine.Oper_2_ID
numeric(10)
Table
Inverse Operation for Debit/Credit Only Column Apply inverse operation to debit or credit only column PA_ReportLine.IsInverseDebitCreditOnly
character(1)
Yes-No
PostingType The type of posted amount for the transaction The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. PA_ReportLine.PostingType
character(1)
List
Budget General Ledger Budget The General Ledger Budget identifies a user defined budget. These can be used in reporting as a comparison against your actual amounts. PA_ReportLine.GL_Budget_ID
numeric(10)
Table Direct
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. PA_ReportLine.PAAmountType
character(1)
List
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. PA_ReportLine.PAPeriodType
character(1)
List
Show Opposite Sign Display values with the opposite sign Displays values for a Report Line with the opposite sign to the calculated value. The "Allow Opposite Sign" flag on Report Column must also be set for this to take effect. Note that all report calculations are performed before the sign is reversed. PA_ReportLine.IsShowOppositeSign
character(1)
Yes-No
Overline Stroke Type PA_ReportLine.OverlineStrokeType
character varying(3)
List
Underline Stroke Type PA_ReportLine.UnderlineStrokeType
character varying(3)
List

Tab: Translation

Description:

Help:

File:Report Line Set - Translation - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
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. PA_ReportLine_Trl.AD_Client_ID
numeric(10)
Table Direct
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. PA_ReportLine_Trl.AD_Org_ID
numeric(10)
Table Direct
Report Line PA_ReportLine_Trl.PA_ReportLine_ID
numeric(10)
Table Direct
Language Language for this entity The Language identifies the language to use for display and formatting PA_ReportLine_Trl.AD_Language
character varying(6)
Table
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. PA_ReportLine_Trl.Name
character varying(255)
String
Description Optional short description of the record A description is limited to 255 characters. PA_ReportLine_Trl.Description
character varying(255)
String
Active The record is active in the system 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.

PA_ReportLine_Trl.IsActive
character(1)
Yes-No
Translated This column is translated The Translated checkbox indicates if this column is translated. PA_ReportLine_Trl.IsTranslated
character(1)
Yes-No

Tab: Report Source

Description: Maintain Segment Values of Report Line Source

Help:

Report Line Set - Report Source - Window (iDempiere 1.0.0).png

Fields
Name Description Help Technical Data
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. PA_ReportSource.AD_Client_ID
numeric(10)
Table Direct
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. PA_ReportSource.AD_Org_ID
numeric(10)
Table Direct
Report Line PA_ReportSource.PA_ReportLine_ID
numeric(10)
Table Direct
Description Optional short description of the record A description is limited to 255 characters. PA_ReportSource.Description
character varying(255)
String
Active The record is active in the system 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.

PA_ReportSource.IsActive
character(1)
Yes-No
Type Element Type (account or user defined) The Element Type indicates if this element is the Account element or is a User Defined element. PA_ReportSource.ElementType
character(2)
List
Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. PA_ReportSource.Org_ID
numeric(10)
Table
Include Nulls in Org Include nulls in the selection of the organization PA_ReportSource.IsIncludeNullsOrg
character(1)
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. PA_ReportSource.AD_OrgTrx_ID
numeric(10)
Table
Include Nulls in Org Trx Include nulls in the selection of the organization transaction PA_ReportSource.IsIncludeNullsOrgTrx
character(1)
Yes-No
Account Element Account Element Account Elements can be natural accounts or user defined values. PA_ReportSource.C_ElementValue_ID
numeric(10)
Search
Include Nulls in Account Include nulls in the selection of the account PA_ReportSource.IsIncludeNullsElementValue
character(1)
Yes-No
Business Partner Identifies a Business Partner A Business Partner is anyone with whom you transact. This can include Vendor, Customer, Employee or Salesperson PA_ReportSource.C_BPartner_ID
numeric(10)
Search
Include Nulls in BPartner Include nulls in the selection of the business partner PA_ReportSource.IsIncludeNullsBPartner
character(1)
Yes-No
Product Product, Service, Item Identifies an item which is either purchased or sold in this organization. PA_ReportSource.M_Product_ID
numeric(10)
Search
Include Nulls in Product Include nulls in the selection of the product PA_ReportSource.IsIncludeNullsProduct
character(1)
Yes-No
Address Location or Address The Location / Address field defines the location of an entity. PA_ReportSource.C_Location_ID
numeric(10)
Location (Address)
Include Nulls in Location Include nulls in the selection of the location PA_ReportSource.IsIncludeNullsLocation
character(1)
Yes-No
Project Financial Project A Project allows you to track and control internal or external activities. PA_ReportSource.C_Project_ID
numeric(10)
Table Direct
Include Nulls in Project Include nulls in the selection of the project PA_ReportSource.IsIncludeNullsProject
character(1)
Yes-No
Sales Region Sales coverage region The Sales Region indicates a specific area of sales coverage. PA_ReportSource.C_SalesRegion_ID
numeric(10)
Table Direct
Include Nulls in Sales Region Include nulls in the selection of the sales region PA_ReportSource.IsIncludeNullsSalesRegion
character(1)
Yes-No
Activity Business Activity Activities indicate tasks that are performed and used to utilize Activity based Costing PA_ReportSource.C_Activity_ID
numeric(10)
Table Direct
Include Nulls in Activity Include nulls in the selection of the activity PA_ReportSource.IsIncludeNullsActivity
character(1)
Yes-No
Campaign Marketing 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. PA_ReportSource.C_Campaign_ID
numeric(10)
Table Direct
Include Nulls in Campaign Include nulls in the selection of the campaign PA_ReportSource.IsIncludeNullsCampaign
character(1)
Yes-No
User Column 1 User defined accounting Element A user defined accounting element referres to a iDempiere 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) PA_ReportSource.UserElement1_ID
numeric(10)
ID
Include Nulls in User Element 1 Include nulls in the selection of the user element 1 PA_ReportSource.IsIncludeNullsUserElement1
character(1)
Yes-No
User Column 2 User defined accounting Element A user defined accounting element referres to a iDempiere 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) PA_ReportSource.UserElement2_ID
numeric(10)
ID
Include Nulls in User Element 2 Include nulls in the selection of the user element 2 PA_ReportSource.IsIncludeNullsUserElement2
character(1)
Yes-No


Contributions / Posts

Cookies help us deliver our services. By using our services, you agree to our use of cookies.