[Home] [Help] [Dependency Information]
Object Name: | PO_RETRIEVED_TIMECARDS |
---|---|
Object Type: | TABLE |
Owner: | PO |
FND Design Data: | PO.PO_RETRIEVED_TIMECARDS |
Subobject Name: | |
Status: | VALID |
Table that stores the timecard entry retrieved from OTL tables.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PO_RETRIEVED_TIMECARDS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
VENDOR_ID
VENDOR_SITE_ID |
PO_RETRIEVED_TIMECARDS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PO_NUMBER |
PO_RETRIEVED_TIMECARDS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PO_CREATION_DATE |
PO_RETRIEVED_TIMECARDS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TC_ID |
PO_RETRIEVED_TIMECARDS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TC_DETAIL_ID |
PO_RETRIEVED_TIMECARDS_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACTION_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VENDOR_ID | NUMBER | Yes | Vendor for whom the timecard entry is made. | |
VENDOR_SITE_ID | NUMBER | Vendor Site Id for whom the timecard entry is made. | ||
VENDOR_CONTACT_ID | NUMBER | Vendor Contact ID for the time entry made | ||
PO_HEADER_ID | NUMBER | Yes | HEADER_ID of the PO against which the timeentry is made. | |
PO_NUMBER | VARCHAR2 | (20) | Yes | PO Number for wich the time entry is made. |
PO_LINE_ID | NUMBER | Yes | LINE_ID of the PO for which the time entry is made. | |
PO_LINE_NUMBER | NUMBER | Yes | Line Number for which the time entry is made. | |
ORG_ID | NUMBER | Yes | Organization identifier | |
PO_CREATION_DATE | DATE | Yes | Date on which the PO is approved. | |
PO_CONTRACTOR_FULL_NAME | VARCHAR2 | (240) | Yes | The full name of the contract for whom the time entry is made. |
PROJECT_ID | NUMBER | Project_ID that may be associated with this PO. | ||
PROJECT_NAME | VARCHAR2 | (240) | Name of the project that the PO may be associated with. | |
TASK_ID | NUMBER | The task that may be associated with the project | ||
TASK_NAME | VARCHAR2 | (240) | The name of the task that may be associated with the PO. | |
TC_ID | NUMBER | Yes | Time card ID which references the timeentry made | |
TC_DAY_ID | NUMBER | Yes | The Day ID in the timecard in which the timeentry is made. | |
TC_DETAIL_ID | NUMBER | Yes | The id in which the timeentry is associated with under the TC_DAY_ID. | |
TC_UOM | VARCHAR2 | (30) | Yes | UOM for the time entry |
TC_START_DATE | DATE | Yes | The date on which the time entry is made. | |
TC_END_DATE | DATE | End date of the time entry | ||
TC_ENTRY_DATE | DATE | Yes | Entry date of the time entry | |
TC_TIME_RECEIVED | NUMBER | Amount of time received | ||
TC_SUBMISSION_DATE | DATE | Date on which the timecard is submitted | ||
TC_APPROVAL_STATUS | VARCHAR2 | (30) | Approval status of the timecard | |
TC_APPROVED_DATE | DATE | Yes | Date on which the Timecard is approved. | |
TC_SCOPE | VARCHAR2 | (30) | Scope of this time entry | |
CONTINGENT_WORKER_ID | NUMBER | Yes | ID of the worker who made the time entry | |
TC_COMMENT_TEXT | VARCHAR2 | (2000) | Comment stored along with the time entry | |
LINE_RATE_TYPE | VARCHAR2 | (30) | Yes | Type of the time entry made |
LINE_RATE | NUMBER | Yes | The agreed rate for the line rate type | |
LINE_RATE_CURRENCY | VARCHAR2 | (3) | Yes | Currency in which the line rate is calculated. |
PO_CONTRACTOR_LAST_NAME | VARCHAR2 | (240) | Last name of the worker who entered the time. | |
PO_CONTRACTOR_FIRST_NAME | VARCHAR2 | (240) | First name of the worker who entered the time. | |
INTERFACE_TRANSACTION_ID | NUMBER | Yes | Corresponding Recieving transaction id that actually made this entry. | |
ACTION_FLAG | VARCHAR2 | (2) | Yes | Can have I, U or D to indicate the row is a result of insertion or update or a delete. This will be null if the transaction is completed. |
TC_ENTRY_SEQUENCE | NUMBER | Yes | Uses the timecard sequence order |
Cut, paste (and edit) the following text to query this object:
SELECT VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CONTACT_ID
, PO_HEADER_ID
, PO_NUMBER
, PO_LINE_ID
, PO_LINE_NUMBER
, ORG_ID
, PO_CREATION_DATE
, PO_CONTRACTOR_FULL_NAME
, PROJECT_ID
, PROJECT_NAME
, TASK_ID
, TASK_NAME
, TC_ID
, TC_DAY_ID
, TC_DETAIL_ID
, TC_UOM
, TC_START_DATE
, TC_END_DATE
, TC_ENTRY_DATE
, TC_TIME_RECEIVED
, TC_SUBMISSION_DATE
, TC_APPROVAL_STATUS
, TC_APPROVED_DATE
, TC_SCOPE
, CONTINGENT_WORKER_ID
, TC_COMMENT_TEXT
, LINE_RATE_TYPE
, LINE_RATE
, LINE_RATE_CURRENCY
, PO_CONTRACTOR_LAST_NAME
, PO_CONTRACTOR_FIRST_NAME
, INTERFACE_TRANSACTION_ID
, ACTION_FLAG
, TC_ENTRY_SEQUENCE
FROM PO.PO_RETRIEVED_TIMECARDS;
PO.PO_RETRIEVED_TIMECARDS does not reference any database object
PO.PO_RETRIEVED_TIMECARDS is referenced by following:
|
|
|