Отчет за поредица в колона (прозорец ID-217)
От iDempiere bg
прозорец: Отчет за поредица в колона
описание: Поддържане на финансови отчети за поредица в колона
помощ: The Report Column Set defines what data is printed in the columns of a report.
TAB: Отчет за поредица в колона
описание: Поддържане на финансови отчети за поредица в колона
помощ Column Sets are the combination of Columns to be included in a Financial Report
Файл:Отчет за поредица в колона - Отчет за поредица в колона - прозорец (iDempiere 1.0.0).png
| име | име | описание | помощ | спецификации |
|---|---|---|---|---|
| Report Column Set | Отчет за поредица в колона | Група от колони в отчет | The Report Column Set identifies the columns used in a Report. | PA_ReportColumnSet_ID numeric(10) NOT NULL ID |
| Client | Фирма | Фирма | Фирма | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | Организация | Подразделение на клиента | 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) NOT NULL Table Direct |
| Name | Наименование | Не повече от 60 знака | 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) NOT NULL String |
| Description | Описание | Описание (не повече 255 символа) | A description is limited to 255 characters. | Description character varying(255) String |
| Active | Активен | Записа е активен | Всеки запис може да бъде напълно изтрит или направен неактивен (при неактивност записа няма да бъде достъпен) | IsActive character(1) NOT NULL Yes-No |
| Copy Columns | Копирай колони | Копирай колони за справки от други колони | Копирай колони от края на множеството от колони | Processing character(1) NOT NULL Button |
TAB: Отчет колона
описание: Maintain Financial Report Column
помощ A column represents a column in a Financial Report
Файл:Отчет за поредица в колона - Отчет колона - прозорец (iDempiere 1.0.0).png
| име | име | описание | помощ | спецификации |
|---|---|---|---|---|
| Client | Фирма | Фирма | Фирма | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | Организация | Подразделение на клиента | 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) NOT NULL Table Direct |
| Report Column Set | Отчет за поредица в колона | Група от колони в отчет | The Report Column Set identifies the columns used in a Report. | PA_ReportColumnSet_ID numeric(10) NOT NULL Table Direct |
| Name | Наименование | Не повече от 60 знака | 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) NOT NULL String |
| Description | Описание | Описание (не повече 255 символа) | A description is limited to 255 characters. | Description character varying(255) String |
| Active | Активен | Записа е активен | Всеки запис може да бъде напълно изтрит или направен неактивен (при неактивност записа няма да бъде достъпен) | IsActive character(1) NOT NULL Yes-No |
| Printed | Отпечатано | Показва дали този документ / ред се печата | The Printed checkbox indicates if this document or line will included when printing. | IsPrinted character(1) NOT NULL Yes-No |
| Sequence | Последователност | Последователност на въвеждане на редовете | The Sequence indicates the order of records | SeqNo numeric(10) NOT NULL Integer |
| 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) NOT NULL List |
| Budget | Бюджет | Бюджет | The General Ledger Budget identifies a user defined budget. These can be used in reporting as a comparison against your actual amounts. | GL_Budget_ID numeric(10) Table Direct |
| 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 |
| Currency Type | Currency Type | null | null | CurrencyType character(1) List |
| Currency | Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID numeric(10) Table Direct |
| Adhoc Conversion | Adhoc Conversion | Perform conversion for all amounts to currency | If a currency is selected, only this currency will be reported. If adhoc conversion is selected, all currencies are converted to the defined currency | IsAdhocConversion character(1) Yes-No |
| Column Type | Колона/Тип | null | null | ColumnType character(1) NOT NULL List |
| Relative Period | Относит. период | 0 - текущ | null | RelativePeriod numeric(10) Number |
| Calculation | Изчисление | null | null | CalculationType character(1) List |
| Operand 1 | Операнд 1 | First operand for calculation | null | Oper_1_ID numeric(10) Table |
| Operand 2 | Операнд 2 | Second operand for calculation | null | Oper_2_ID numeric(10) Table |
| Type | Тип | Element Type (account or user defined) | The Element Type indicates if this element is the Account element or is a User Defined element. | ElementType character(2) List |
| Organization | Организация | Подразделение на клиента | An organization is a unit of your client or legal entity - examples are store, department. | Org_ID numeric(10) Table |
| Include Nulls in Org | Include Nulls in Org | Include nulls in the selection of the organization | null | IsIncludeNullsOrg character(1) NOT NULL 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. | AD_OrgTrx_ID numeric(10) Table |
| Include Nulls in Org Trx | Include Nulls in Org Trx | Include nulls in the selection of the organization transaction | null | IsIncludeNullsOrgTrx character(1) NOT NULL Yes-No |
| Account Element | Сметкови елемент | Сметкови елемент | Account Elements can be natural accounts or user defined values. | C_ElementValue_ID numeric(10) Table Direct |
| Include Nulls in Account | Include Nulls in Account | Include nulls in the selection of the account | null | IsIncludeNullsElementValue character(1) NOT NULL Yes-No |
| Product | Продукт | Продукт | Identifies an item which is either purchased or sold in this organization. | M_Product_ID numeric(10) Table Direct |
| Include Nulls in Product | Include Nulls in Product | Include nulls in the selection of the product | null | IsIncludeNullsProduct character(1) NOT NULL Yes-No |
| 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. | C_Campaign_ID numeric(10) Table Direct |
| Include Nulls in Campaign | Include Nulls in Campaign | Include nulls in the selection of the campaign | null | IsIncludeNullsCampaign character(1) NOT NULL Yes-No |
| Business Partner | Партньор | Партньор | Партньорът е всеки, с когото работите. Това може да означава Доставчик, Клиент, Служител или Търговски представител. | C_BPartner_ID numeric(10) Table Direct |
| Include Nulls in BPartner | Include Nulls in BPartner | Include nulls in the selection of the business partner | null | IsIncludeNullsBPartner character(1) NOT NULL Yes-No |
| Project | Проект | Финансов проект | A Project allows you to track and control internal or external activities. | C_Project_ID numeric(10) Table Direct |
| Include Nulls in Project | Include Nulls in Project | Include nulls in the selection of the project | null | IsIncludeNullsProject character(1) NOT NULL Yes-No |
| Address | Адрес | Местоположение или адрес | The Location / Address field defines the location of an entity. | C_Location_ID numeric(10) Location (Address) |
| Include Nulls in Location | Include Nulls in Location | Include nulls in the selection of the location | null | IsIncludeNullsLocation character(1) NOT NULL Yes-No |
| Sales Region | Регион за продажби | Регион покриван при продажби | The Sales Region indicates a specific area of sales coverage. | C_SalesRegion_ID numeric(10) Table Direct |
| Include Nulls in Sales Region | Include Nulls in Sales Region | Include nulls in the selection of the sales region | null | IsIncludeNullsSalesRegion character(1) NOT NULL Yes-No |
| Activity | Дейност | Бизнес дейност | Activities indicate tasks that are performed and used to utilize Activity based Costing | C_Activity_ID numeric(10) Table Direct |
| Include Nulls in Activity | Include Nulls in Activity | Include nulls in the selection of the activity | null | IsIncludeNullsActivity character(1) NOT NULL Yes-No |
| User Element 1 | User Element 1 | User defined accounting Element | A user defined accounting element referres to a Compiere 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) | UserElement1_ID numeric(10) ID |
| Include Nulls in User Element 1 | Include Nulls in User Element 1 | Include nulls in the selection of the user element 1 | null | IsIncludeNullsUserElement1 character(1) NOT NULL Yes-No |
| User Element 2 | User Element 2 | User defined accounting Element | A user defined accounting element referres to a Compiere 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) | UserElement2_ID numeric(10) ID |
| Include Nulls in User Element 2 | Include Nulls in User Element 2 | Include nulls in the selection of the user element 2 | null | IsIncludeNullsUserElement2 character(1) NOT NULL Yes-No |
| Format Pattern | Format Pattern | The pattern used to format a number or date. | A string complying with either Java SimpleDateFormat or DecimalFormat pattern syntax used to override the default presentation format of a date or number type field. | FormatPattern character varying(22) String |
| Factor | Factor | Scaling factor. | Numbers are divided by the scaling factor for presentation. E.g. 123,000 with a scaling factor of 1,000 will display as 123. | Factor character(1) List |
.png){kind=link}
.png){kind=link}