ManPageW ImportReportLineSet

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

Return to Index

Enjoy it, and help to fill it! But please, always respecting copyright.

Please write your contributions under the Contributions Section



Window: Import Report Line Set

Description : Import Report Line Sets

Help : The Import Report Line Set 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: Import Report Line Set

Description :

Help :

Table Name  : I_ReportLine

ManPageW ImportReportLineSet ImportReportLineSet.png

Fields

Name Description Help Technical Data
Import Report Line Set Import Report Line Set values I_ReportLine_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

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

Report Line Set Name Name of the Report Line Set ReportLineSetName

NVARCHAR2(60)

String

Report Line Set PA_ReportLineSet_ID

NUMBER(10)

TableDir

Report Line PA_ReportLine_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

Sequence Method of ordering records; lowest number comes first The Sequence indicates the order of records SeqNo

NUMBER(10)

Integer

Summary Level This is a summary entity 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

CHAR(1)

YesNo

Printed Indicates if this document / line is printed The Printed checkbox indicates if this document or line will included when printing. IsPrinted

CHAR(1)

YesNo

PostingType The type of posted amount for the transaction The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction. PostingType

CHAR(1)

List

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

CHAR(2)

List

Line Type LineType

CHAR(1)

List

Calculation CalculationType

CHAR(1)

List

Report Source Restriction of what will be shown in Report Line PA_ReportSource_ID

NUMBER(10)

TableDir

Element Key Key of the element ElementValue

NVARCHAR2(40)

String

Account Element Account Element Account Elements can be natural accounts or user defined values. C_ElementValue_ID

NUMBER(10)

TableDir

Import Report Line Set Import Report Line Set information The Parameters are default values for null import record values, they do not overwrite any data. Processing

CHAR(1)

Button

Processed The document has been processed The Processed checkbox indicates that a document has been processed. Processed

CHAR(1)

YesNo

Contributions