[Home] [Help] [Dependency Information]
Object Name: | CS_TM_LABOR_SCHEDULES |
---|---|
Object Type: | TABLE |
Owner: | CS |
FND Design Data: | CS.CS_TM_LABOR_SCHEDULES |
Subobject Name: | |
Status: | VALID |
T&M Labor Schedules for Service Labor Billing
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CS_TM_LABOR_SCHEDULES_U1 | NORMAL | UNIQUE | APPS_TS_SEED | TM_LABOR_SCHEDULE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TM_LABOR_SCHEDULE_ID | NUMBER | (15) | Yes | T&M Labor Schedule Identifier |
BUSINESS_PROCESS_ID | NUMBER | (15) | Yes | Business Process Identifier |
START_TIME | DATE | Obsoleted | ||
END_TIME | DATE | Obsoleted | ||
MONDAY_FLAG | VARCHAR2 | (1) | Cover Mondays Y/N | |
TUESDAY_FLAG | VARCHAR2 | (1) | Cover Tuesdays Y/N | |
WEDNESDAY_FLAG | VARCHAR2 | (1) | Cover Wednesdays Y/N | |
THURSDAY_FLAG | VARCHAR2 | (1) | Cover Thursdays Y/N | |
FRIDAY_FLAG | VARCHAR2 | (1) | Cover Fridays Y/N | |
SATURDAY_FLAG | VARCHAR2 | (1) | Cover Saturdays Y/N | |
SUNDAY_FLAG | VARCHAR2 | (1) | Cover Sundays Y/N | |
HOLIDAY_FLAG | VARCHAR2 | (1) | Cover Holidays Y/N | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Identifier - Labor | |
LABOR_CODE | VARCHAR2 | (30) | Labor Lookup Code - for contract labor coverage conversion purpose | |
CREATED_BY | NUMBER | Yes | Created by | |
CREATION_DATE | DATE | Yes | Creation Date | |
LAST_UPDATED_BY | NUMBER | Yes | Last Updated by | |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Last Update Login | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Attribute Category | |
ATTRIBUTE1 | VARCHAR2 | (150) | Attribute 1 | |
ATTRIBUTE2 | VARCHAR2 | (150) | Attribute 2 | |
ATTRIBUTE3 | VARCHAR2 | (150) | Attribute 3 | |
ATTRIBUTE4 | VARCHAR2 | (150) | Attribute 4 | |
ATTRIBUTE5 | VARCHAR2 | (150) | Attribute 5 | |
ATTRIBUTE6 | VARCHAR2 | (150) | Attribute 6 | |
ATTRIBUTE7 | VARCHAR2 | (150) | Attribute 7 | |
ATTRIBUTE8 | VARCHAR2 | (150) | Attribute 8 | |
ATTRIBUTE9 | VARCHAR2 | (150) | Attribute 9 | |
ATTRIBUTE10 | VARCHAR2 | (150) | Attribute 10 | |
ATTRIBUTE11 | VARCHAR2 | (150) | Attribute 11 | |
ATTRIBUTE12 | VARCHAR2 | (150) | Attribute 12 | |
ATTRIBUTE13 | VARCHAR2 | (150) | Attribute 13 | |
ATTRIBUTE14 | VARCHAR2 | (150) | Attribute 14 | |
ATTRIBUTE15 | VARCHAR2 | (150) | Attribute 15 | |
SECURITY_GROUP_ID | NUMBER | Security Group Identifier | ||
START_HOUR | NUMBER | Labor time start hour | ||
START_MINUTE | NUMBER | Labor time start minute | ||
END_HOUR | NUMBER | Labor time end hour | ||
END_MINUTE | NUMBER | Labor time end minute |
Cut, paste (and edit) the following text to query this object:
SELECT TM_LABOR_SCHEDULE_ID
, BUSINESS_PROCESS_ID
, START_TIME
, END_TIME
, MONDAY_FLAG
, TUESDAY_FLAG
, WEDNESDAY_FLAG
, THURSDAY_FLAG
, FRIDAY_FLAG
, SATURDAY_FLAG
, SUNDAY_FLAG
, HOLIDAY_FLAG
, INVENTORY_ITEM_ID
, LABOR_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, START_HOUR
, START_MINUTE
, END_HOUR
, END_MINUTE
FROM CS.CS_TM_LABOR_SCHEDULES;
CS.CS_TM_LABOR_SCHEDULES does not reference any database object
CS.CS_TM_LABOR_SCHEDULES is referenced by following:
|
|
|