View source | Discuss this page | Page history | Printable version   

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.calendar/C PeriodControl Log

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.calendar


Contents

C_PeriodControl_Log

This table contains the following columns:

Name Nullable Data Type Description


Isactive No CHAR (1) 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 reporting. There are two reasons for de-activating and not deleting records:

(1) The system requires the record for auditing purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.

C_Calendar_ID No VARCHAR (32) 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.
IsRecursive No CHAR (1) If it is selected, the process will also open or close the documents of all of the organizations that depend on the selected organization.
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
Createdby No VARCHAR (32) The Created By field indicates the user who created this record.
Created No TIMESTAMP (7) The Created field indicates the date that this record was created.
Description Yes VARCHAR (255) A description is limited to 255 characters.
Docbasetype Yes VARCHAR (60) The Document Base Type identifies the base or starting point for a document. Multiple document types may share a single document base type.
AD_Org_ID No VARCHAR (32) An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.
C_Period_ID Yes VARCHAR (32) The Period indicates an exclusive range of dates for a calendar.
Periodaction No VARCHAR (60) The Period Action indicates the action to be taken for this period. For example 'Close Period' or 'Open Period'.
C_Periodcontrol_Log_ID No VARCHAR (32) Log of the Open/Close Period Control process
Periodno No VARCHAR (32) 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.
Processing No CHAR (1) When this field is set as 'Y' a process is being performed on this record.
Processed No CHAR (1) The Processed checkbox indicates that a document has been processed.
Updated No TIMESTAMP (7) The Updated field indicates the date that this record was updated.
Updatedby No VARCHAR (32) The Updated By field indicates the user who updated this record.
C_Year_ID No VARCHAR (32) The Year uniquely identifies an accounting year for a calendar.

Columns

Active



top


Calendar


Foreign key column to C_Calendar table, (column: C_Calendar_ID)

top


Cascade



top


Client


Foreign key column to AD_Client table, (column: AD_Client_ID) It has a validation "AD_Client Security validation", with the following code

AD_Client.AD_Client_ID in (@#User_Client@)

top


Created By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Creation Date



top


Description



top


Document Category



List values: C_DocType DocBaseType

The allowed values for this list are:

top


Organization


Foreign key column to AD_Org table, (column: AD_Org_ID) It has a validation "AD_Org IsPeriodControlAllowed", with the following code

ISPERIODCONTROLALLOWED='Y' AND IsReady='Y'

Callout: SE_PeriodNo

This column has a callout associated.

It is implemented by [1] Java Class.

top


Period


Foreign key column to C_Period table, (column: C_Period_ID)

top


Period Action


It has a validation "Allowed PeriodActions", with the following code

Value<>'N'

List values: C_PeriodControl Action

The allowed values for this list are:

top


Period Control record



top


Period No.

Foreign key column to C_Period table, (column: C_Period_ID)

top


Process Now



top


Processed



top


Updated



top


Updated By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Year

Foreign key column to C_Year table, (column: C_Year_ID) It has a validation "C_Calendar and C_Year of an organization", with the following code

C_YEAR.C_CALENDAR_ID IN (SELECT AD_InheritedCalendar_ID FROM AD_ORG WHERE AD_Client_ID= @AD_Client_ID@ AND AD_ORG_ID= @AD_Org_ID@)

Callout: SE_PeriodNo

This column has a callout associated.

It is implemented by [2] Java Class.

top


Other Info

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.financialmgmt.calendar

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.financialmgmt.calendar/C_PeriodControl_Log"

This page has been accessed 3,521 times. This page was last modified on 4 September 2023, at 01:58. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.