Adempiere3.1.2/en/ManPageW CalendarYearandPeriod olh
Contents
Window: Calendar Year and Period
Description : Maintain Calendars Years Periods
Help : The Calendar Year and Periods defines the calendars that will be used for period control and reporting. You can also define non-standard calendars (e.g. business year from July to June).
Tab: Calendar
Description : Define your calendar
Help : The Calendar Tab defines each calendar that will be used by an Organization.
Table Name : C_Calendar
Name | Description | Help | Technical Data |
---|---|---|---|
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 |
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 |
Active | 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
CHAR(1) YesNo |
Tab: Year
Description : Define Calendar Year
Help : The Year Window is used to define each year for the specified calendar.
Table Name : C_Year
Name | Description | Help | Technical Data |
---|---|---|---|
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 |
Calendar | Accounting Calendar Name | The Calendar uniquely identifies an accounting calendar. Multiple calendars can be used. For example you may need a standard calendar that runs from Jan 1 to Dec 31 and a fiscal calendar that runs from July 1 to June 30. | C_Calendar_ID
NUMBER(10) TableDir |
Year | The Fiscal Year | The Year identifies the accounting year for a calendar. | FiscalYear
VARCHAR2 String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Active | 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
CHAR(1) YesNo |
Create Periods | Create 12 standard calendar periods (Jan-Dec) | Processing
CHAR(1) Button |
Tab: Period
Description : Define Calendar Periods
Help : The Period Tab defines a Period No, Name and Start Date for each Calendar Year. Each period begins on the defined Start Date and ends one day prior to the next period's Start Date.
Table Name : C_Period
Name | Description | Help | Technical Data |
---|---|---|---|
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 |
Year | Calendar Year | The Year uniquely identifies an accounting year for a calendar. | C_Year_ID
NUMBER(10) TableDir |
Period No | Unique Period Number | The Period No identifies a specific period for this year. Each period is defined by a start and end date. Date ranges for a calendar and year cannot overlap. | PeriodNo
NUMBER(10) Integer |
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 |
Active | 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
CHAR(1) YesNo |
Start Date | First effective day (inclusive) | The Start Date indicates the first or starting date | StartDate
DATE Date |
End Date | Last effective date (inclusive) | The End Date indicates the last date in this range. | EndDate
DATE Date |
Period Type | Period Type | The Period Type indicates the type (Standard or Adjustment) of period. | PeriodType
CHAR(1) List |
Open/Close All | Change Period Status for all Period Controls of this Period | Processing
CHAR(1) Button |
Tab: Period Control
Description : Define Period Control
Help : The Period Control Tab displays the status of a Period (Never Opened, Opened, Closed).
Table Name : C_PeriodControl
Name | Description | Help | Technical Data |
---|---|---|---|
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 |
Period | Period of the Calendar | The Period indicates an exclusive range of dates for a calendar. | C_Period_ID
NUMBER(10) TableDir |
Document BaseType | Logical type of document | The Document Base Type identifies the base or starting point for a document. Multiple document types may share a single document base type. | DocBaseType
CHAR(3) List |
Active | 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
CHAR(1) YesNo |
Period Status | Current state of this period | The Period Status indicates the current status for this period. For example 'Closed', 'Open', 'Never Opened'. | PeriodStatus
CHAR(1) List |
Period Action | Action taken for this period | The Period Action indicates the action to be taken for this period. For example 'Close Period' or 'Open Period'. | PeriodAction
CHAR(1) List |
Open/Close | Change Period Status | Processing
CHAR(1) Button |
Tab: Non Business Day
Description : Define Non Business Days
Help : The Non Business Days Tab defines those days to exclude when calculating the due date for given payment terms. For example, if an invoice terms was Net 10 days and the Invoice Date was 2/17/2000 the due date would be 2/27/2000. If 2/27/2000 was defined as a non business day then the due date on the Invoice would be 2/28/2000.
Table Name : C_NonBusinessDay
Name | Description | Help | Technical Data |
---|---|---|---|
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 |
Calendar | Accounting Calendar Name | The Calendar uniquely identifies an accounting calendar. Multiple calendars can be used. For example you may need a standard calendar that runs from Jan 1 to Dec 31 and a fiscal calendar that runs from July 1 to June 30. | C_Calendar_ID
NUMBER(10) TableDir |
Active | 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
CHAR(1) YesNo |
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 |
Date | Date when business is not conducted | The Date field identifies a calendar date on which business will not be conducted. | Date1
DATE Date |