Import Report Line Set (Window ID-249)

⇐ Table of Contents

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:

Fields

Name	Description	Help	Technical Data
Import Report Line Set	Import Report Line Set values		I_ReportLine.I_ReportLine_ID numeric(10) ID
Imported	Has this import been processed	The Imported check box indicates if this import has been processed.	I_ReportLine.I_IsImported character(1) Yes-No
Import Error Message	Messages generated from import process	The Import Error Message displays any error messages generated during the import process.	I_ReportLine.I_ErrorMsg character varying(2000) String
Tenant	Tenant for this installation.	A Tenant is a company or a legal entity. You cannot share data between Tenants.	I_ReportLine.AD_Client_ID numeric(10) Table Direct
Organization	Organizational entity within tenant	An organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.	I_ReportLine.AD_Org_ID numeric(10) Table Direct
Report Line Set Name	Name of the Report Line Set		I_ReportLine.ReportLineSetName character varying(60) String
Report Line Set			I_ReportLine.PA_ReportLineSet_ID numeric(10) Table Direct
Report Line			I_ReportLine.PA_ReportLine_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.	I_ReportLine.Name character varying(60) String
Description	Optional short description of the record	A description is limited to 255 characters.	I_ReportLine.Description character varying(255) String
Sequence	Method of ordering records; lowest number comes first	The Sequence indicates the order of records	I_ReportLine.SeqNo numeric(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.	I_ReportLine.IsSummary 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.	I_ReportLine.IsPrinted character(1) Yes-No
Posting Type	The type of posted amount for the transaction	The Posting Type indicates the type of amount (Actual, Budget, Reservation, Commitment, Statistical) the transaction.	I_ReportLine.PostingType character(1) List
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.	I_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.	I_ReportLine.PAPeriodType character(1) List
Line Type			I_ReportLine.LineType character(1) List
Calculation			I_ReportLine.CalculationType character(1) List
Report Source	Restriction of what will be shown in Report Line		I_ReportLine.PA_ReportSource_ID numeric(10) Table Direct
Element Key	Key of the element		I_ReportLine.ElementValue character varying(40) String
Account Element	Account Element	Account Elements can be natural accounts or user defined values.	I_ReportLine.C_ElementValue_ID numeric(10) Search
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.	I_ReportLine.Processing character(1) Button
Processed	The document has been processed	The Processed checkbox indicates that a document has been processed.	I_ReportLine.Processed character(1) Yes-No