[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:
|
|
|