[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OIE_PDM_DAILY_BREAKUPS_ARC |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.OIE_PDM_DAILY_BREAKUPS_ARC
|
| Subobject Name: | |
| Status: | VALID |
OIE Archive Table for PerDiem Daily Breakups
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ARC_REQ_ID | NUMBER | Yes | Archive Request Identifier | |
| ARCHIVE_DATE | DATE | Archive Date - Date when this row got created | ||
| PDM_DAILY_BREAKUP_ID | NUMBER | (15) | Yes | Sequence generated unique identifier |
| REPORT_LINE_ID | NUMBER | (15) | Report Line Identifier | |
| START_DATE | DATE | Yes | Start date for expense detail line | |
| END_DATE | DATE | Yes | End date for expense detail line | |
| AMOUNT | NUMBER | Reimbursable amount | ||
| NUMBER_OF_MEALS | NUMBER | Number of meals | ||
| MEALS_AMOUNT | NUMBER | Amount incurred due to meals | ||
| BREAKFAST_FLAG | VARCHAR2 | (1) | Indicates if breakfast is free | |
| LUNCH_FLAG | VARCHAR2 | (1) | Indicates if lunch is free | |
| DINNER_FLAG | VARCHAR2 | (1) | Indicates if dinner is free | |
| ACCOMMODATION_AMOUNT | NUMBER | Amount incurred due to accommodation | ||
| ACCOMMODATION_FLAG | VARCHAR2 | (1) | Indicates if user received dinner during the rate period | |
| HOTEL_NAME | VARCHAR2 | (80) | Stores hotel name | |
| NIGHT_RATE_TYPE | VARCHAR2 | (80) | Stores night rate type | |
| NIGHT_RATE_AMOUNT | NUMBER | Night rate amount | ||
| PDM_RATE | NUMBER | Daily per diem amount based on per diem detail dates | ||
| PDM_DESTINATION_ID | NUMBER | (15) | Points to the location choosen for per diem calculation | |
| RATE_TYPE_CODE | VARCHAR2 | (80) | Column indicates if rate is standard, first day rate, last day rate | |
| LAST_UPDATE_DATE | DATE | Standard WHO column | ||
| LAST_UPDATED_BY | NUMBER | Standard WHO column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard WHO column | ||
| CREATED_BY | NUMBER | Standard WHO column | ||
| CREATION_DATE | DATE | Standard WHO column | ||
| SCHEDULE_TYPE_CODE | VARCHAR2 | (30) | Denotes the type of schedule type | |
| CUST_MEALS_AMOUNT | NUMBER | Custom amount incurred due to meals | ||
| CUST_ACCOMMODATION_AMOUNT | NUMBER | Custom amount incurred due to accommodation | ||
| CUST_NIGHT_RATE_AMOUNT | NUMBER | Custom night rate amount. | ||
| CUST_PDM_RATE | NUMBER | Custom daily per diem amount based on per diem detail dates |
Cut, paste (and edit) the following text to query this object:
SELECT ARC_REQ_ID
, ARCHIVE_DATE
, PDM_DAILY_BREAKUP_ID
, REPORT_LINE_ID
, START_DATE
, END_DATE
, AMOUNT
, NUMBER_OF_MEALS
, MEALS_AMOUNT
, BREAKFAST_FLAG
, LUNCH_FLAG
, DINNER_FLAG
, ACCOMMODATION_AMOUNT
, ACCOMMODATION_FLAG
, HOTEL_NAME
, NIGHT_RATE_TYPE
, NIGHT_RATE_AMOUNT
, PDM_RATE
, PDM_DESTINATION_ID
, RATE_TYPE_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, SCHEDULE_TYPE_CODE
, CUST_MEALS_AMOUNT
, CUST_ACCOMMODATION_AMOUNT
, CUST_NIGHT_RATE_AMOUNT
, CUST_PDM_RATE
FROM AP.OIE_PDM_DAILY_BREAKUPS_ARC;
AP.OIE_PDM_DAILY_BREAKUPS_ARC does not reference any database object
AP.OIE_PDM_DAILY_BREAKUPS_ARC is referenced by following:
AP
OIE_PDM_DAILY_BREAKUPS_ARC#
|
|
|
|