Import Report Line Set (Venster ID-249)

Uit iDempiere nl
Ga naar:navigatie, zoeken



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


Contributions / Posts

Cookies helpen ons onze services aan te bieden. Door onze services te gebruiken stemt u in met het gebruik van onze cookies.