GL_TRANSACTION_CALENDAR
GL_TRANSACTION_CALENDAR contains the transaction calendars you define using the Transaction Calendar form. Each row includes the name and description of one particular transaction calendar as well as flags indicating whether each day of the week should default to a business or a non-business day. There is a one-to-many relationship between a row in this table and rows in the GL_TRANSACTION_DATES table.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_TRANSACTION_CALENDAR_PK |
TRANSACTION_CALENDAR_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| TRANSACTION_CALENDAR_ID | NUMBER | 18 | Yes | Transaction calendar identifier. | ||
| NAME | VARCHAR2 | 25 | Yes | Name of the transaction calendar. | ||
| MON_BUSINESS_DAY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether Monday defaults to a business day. | ||
| TUE_BUSINESS_DAY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether Tuesday defaults to a business day. | ||
| WED_BUSINESS_DAY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether Wednesday defaults to a business day. | ||
| THU_BUSINESS_DAY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether Thursday defaults to a business day. | ||
| FRI_BUSINESS_DAY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether Friday defaults to a business day. | ||
| SAT_BUSINESS_DAY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether Saturday defaults to a business day. | ||
| SUN_BUSINESS_DAY_FLAG | VARCHAR2 | 1 | Yes | Indicates whether Sunday defaults to a business day. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| DESCRIPTION | VARCHAR2 | 240 | Transaction calendar description. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Transaction Calendars (GL_TRANSACTION_CALENDAR) | ||
| SECURITY_FLAG | VARCHAR2 | 1 | Yes | Enable definition access set security flag. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| gl_ledgers | gl_transaction_calendar | TRANSACTION_CALENDAR_ID |
| gl_transaction_dates | gl_transaction_calendar | TRANSACTION_CALENDAR_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_TRANSACTION_CALENDAR_U1 | Unique | Default | TRANSACTION_CALENDAR_ID |
| GL_TRANSACTION_CALENDAR_U2 | Unique | Default | NAME |