Import Report Line Set (Venster ID-249)

Venster: Import Report Line Set

Beschrijving: 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: Importeer Report Regel Set

Beschrijving: null

Help null

Bestand:Import Report Line Set - Importeer Report Regel Set - Venster (iDempiere 1.0.0).png

Naam	Naam	Beschrijving	Help	Specificaties
Active	Actief	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.	IsActive character(1) Yes-No
Import Report Line Set	Importeer Report Regel Set	Import Report Line Set values	null	I_ReportLine_ID numeric(10) NOT NULL ID
Imported	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	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
Client	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 numeric(10) Table Direct
Organization	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 numeric(10) Table Direct
Report Line Set Name	Report Line Set Name	Name of the Report Line Set	null	ReportLineSetName character varying(60) String
Report Line Set	Report Line Set	null	null	PA_ReportLineSet_ID numeric(10) Table Direct
Report Line	Report Line	null	null	PA_ReportLine_ID numeric(10) Table Direct
Name	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) String
Description	Beschrijving	Optional short description of the record	A description is limited to 255 characters.	Description character varying(255) String
Sequence	Sequence	Method of ordering records; lowest number comes first	The Sequence indicates the order of records	SeqNo numeric(10) Integer
Summary Level	Samenvatting Niveau	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 character(1) Yes-No
Printed	Geprint	Indicates if this document / line is printed	The Printed checkbox indicates if this document or line will included when printing.	IsPrinted character(1) Yes-No
PostingType	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 character(1) 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
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
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
Line Type	Line Type	null	null	LineType character(1) List
Calculation	Calculation	null	null	CalculationType character(1) List
Report Source	Report Source	Restriction of what will be shown in Report Line	null	PA_ReportSource_ID numeric(10) Table Direct
Element Key	Element Key	Key of the element	null	ElementValue character varying(40) String
Account Element	Account Element	Account Element	Account Elements can be natural accounts or user defined values.	C_ElementValue_ID numeric(10) Table Direct
Import Report Line Set	Importeer Report Regel Set	Import Report Line Set information	The Parameters are default values for null import record values, they do not overwrite any data.	Processing character(1) Button
Processed	Processed	The document has been processed	The Processed checkbox indicates that a document has been processed.	Processed character(1) Yes-No