EXP_RPT_EXPENSE_DAY 
Default Table Name  EXP_RPT_EXPENSE_DAY 
Definition 
 Name: Expense Report Expense Daily Details.     Description: This table contains the details of an expense at the daily level.
 

EXP_RPT_EXPENSE_DAY Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EXP_RPT_ID(PK)(FK)    VARCHAR2(10)  NO 
Name: Expense Report ID. Description: The unique identifier for the expense report.
 
EXPENSE_ID(PK)(FK)    NUMBER(10, 0)  NO 
Name: Expense ID. Description: The unique identifier for the expense.
 
EXP_DT(PK)    DATE  NO 
Name: Expense Date. Description: The date of the expense
 
BREAKFAST_FL    VARCHAR2(1)  NO 
Name: Breakfast Flag. Description: Logical as to whether this expense is breakfast.
 
LUNCH_FL    VARCHAR2(1)  NO 
Name: Lunch Flag. Description: Logical as to whether this expense is lunch.
 
DINNER_FL    VARCHAR2(1)  NO 
Name: Dinner Flag. Description: Logical as to whether this expense is dinner.
 
TRANS_CEILING_AMT    NUMBER(15, 5)  NO 
Name: Transaction Currency Ceiling Amount. Description: The ceiling amount in transaction currency.
 
TRANS_EXPENSE_AMT    NUMBER(15, 5)  NO 
Name: Transaction Currency Expense Amount. Description: The net expense in the transaction currency. (INCURRED – OTHER)
 
PAY_CEILING_AMT    NUMBER(15, 5)  NO 
Name: Pay Currency Ceiling Amount. Description: The ceiling amount in pay currency.
 
PAY_EXPENSE_AMT    NUMBER(15, 5)  NO 
Name: Pay Currency Expense Amount. Description: The net expense in the pay currency.  (INCURRED – OTHER)
 
BASE_CEILING_AMT    NUMBER(15, 5)  NO 
Name: Base Currency Ceiling Amount. Description: The ceiling amount in system base currency.
 
BASE_EXPENSE_AMT    NUMBER(15, 5)  NO 
Name: Base Currency Expense Amount. Description: The net expense in the system base currency.  (INCURRED – OTHER)
 
MODIFIED_BY    VARCHAR2(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMBER(10, 0)  NO 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
INCIDENTAL_FL    VARCHAR2(1)  NO 
Name: Incidental Flag. Description: Logical as to whether expense included incidentals.
 
TRANS_BREAKFAST_AMT    NUMBER(15, 5)  NO 
Name: Transaction Breakfast Amount. Description: The breakfast amount incurred in the transaction currency.
 
TRANS_LUNCH_AMT    NUMBER(15, 5)  NO 
Name: Transaction Lunch Amount. Description: The lunch amount incurred in the transaction currency.
 
TRANS_DINNER_AMT    NUMBER(15, 5)  NO 
Name: Transaction Dinner Amount. Description: The dinner amount incurred in the transaction currency.
 
TRANS_INCIDENTAL_AMT    NUMBER(15, 5)  NO 
Name: Transaction Incidental Amount. Description: The incidental amount incurred in the transaction currency.
 
BASE_BREAKFAST_AMT    NUMBER(15, 5)  NO 
Name: Base Breakfast Amount. Description: The breakfast amount incurred in the system’s base currency.
 
BASE_LUNCH_AMT    NUMBER(15, 5)  NO 
Name: Base Lunch Amount. Description: The lunch amount incurred in the system’s base currency.
 
BASE_DINNER_AMT    NUMBER(15, 5)  NO 
Name: Base Dinner Amount. Description: The dinner amount incurred in the system’s base currency.
 
BASE_INCIDENTAL_AMT    NUMBER(15, 5)  NO 
Name: Base Incidental Amount. Description: The incidental amount incurred in the system’s base currency.
 
PAY_BREAKFAST_AMT    NUMBER(15, 5)  NO 
Name: Pay Breakfast Amount. Description: The breakfast amount incurred in the pay currency.
 
PAY_LUNCH_AMT    NUMBER(15, 5)  NO 
Name: Pay Lunch Amount. Description: The lunch amount incurred in the pay currency.
 
PAY_DINNER_AMT    NUMBER(15, 5)  NO 
Name: Pay Dinner Amount. Description: The dinner amount incurred in the pay currency.
 
PAY_INCIDENTAL_AMT    NUMBER(15, 5)  NO 
Name: Pay Incidental Amount. Description: The incidental amount incurred in the pay currency.
 
TRANS_DAILY_ROOM_RATE    NUMBER(15, 5)  NO 
Name: Daily Transaction Currency Daily Room Rate  Description: The daily room rate in transaction currency.
 
TRANS_DAILY_TAX_RATE    NUMBER(15, 5)  NO 
Name: Daily Transaction Currency Daily Tax Rate  Description: The daily room tax rate in transaction currency.
 
TRANS_ADJUST_OVER_CEILING_AMT    NUMBER(15, 5)  NO 
Name: Daily Transaction Currency Over Ceiling Adjustment Amount  Description: The over ceiling adjustment amount in transaction currency.
 
TRANS_ADJUST_UNDER_CEILING_AMT    NUMBER(15, 5)  NO 
Name: Daily Transaction Currency Under Ceiling Adjustment Amount Description: The under ceiling adjustment amount in transaction currency.
 
TRANS_OVER_CEILING_AMT    NUMBER(15, 5)  NO 
Name: Daily Transaction Currency Over Ceiling Amount Description: The over ceiling amount in transaction currency.
 
TRANS_UNALLOWABLE_AMT    NUMBER(15, 5)  NO 
Name: Daily Transaction Currency Unallowable Amount  Description: The unallowable amount in transaction currency.
 
TRANS_NON_REIMBURSE_AMT    NUMBER(15, 5)  NO 
Name: Transaction Currency Non-Reimbursable Amount  Description: The non-reimbursable amount in transaction currency.
 
ADJUSTMENT_REASON_TEXT    VARCHAR2(254)  YES 
 
BASE_DAILY_ROOM_RATE    NUMBER(15, 5)  NO 
Name: Daily Base Currency Daily Room Rate  Description: The daily room rate in system base currency.
 
BASE_DAILY_TAX_RATE    NUMBER(15, 5)  NO 
Name: Daily Base Currency Daily Tax Rate  Description: The daily room tax rate in system base currency.
 
BASE_ADJUST_OVER_CEILING_AMT    NUMBER(15, 5)  NO 
Name: Daily Base Currency Over Ceiling Adjustment Amount  Description: The over ceiling adjustment amount in system base currency.
 
BASE_ADJUST_UNDER_CEILING_AMT    NUMBER(15, 5)  NO 
Name: Daily Base Currency Under Ceiling Adjustment Amount  Description: The under ceiling adjustment amount in system base currency.
 
BASE_OVER_CEILING_AMT    NUMBER(15, 5)  NO 
Name: Daily Base Currency Over Ceiling Amount  Description: The over ceiling amount in system base currency.
 
BASE_UNALLOWABLE_AMT    NUMBER(15, 5)  NO 
Name: Daily Base Currency Unallowable Amount  Description: The unallowable amount in system base currency.
 
BASE_NON_REIMBURSE_AMT    NUMBER(15, 5)  NO 
Name: Daily Base Currency Non-Reimbursable Amount  Description: The non-reimbursable amount in system base currency.
 
PAY_DAILY_ROOM_RATE    NUMBER(15, 5)  NO 
Name: Daily Pay Currency Daily Room Rate  Description: The daily room rate in pay currency.
 
PAY_DAILY_TAX_RATE    NUMBER(15, 5)  NO 
Name: Daily Pay Currency Daily Tax Rate  Description: The daily room tax rate in pay currency.
 
PAY_ADJUST_OVER_CEILING_AMT    NUMBER(15, 5)  NO 
Name: Daily Pay Currency Over Ceiling Adjustment Amount  Description: The over ceiling adjustment amount in pay currency.
 
PAY_ADJUST_UNDER_CEILING_AMT    NUMBER(15, 5)  NO 
Name: Daily Pay Currency Under Ceiling Adjustment Amount  Description: The under ceiling adjustment amount in pay currency.
 
PAY_OVER_CEILING_AMT    NUMBER(15, 5)  NO 
Name: Daily Pay Currency Over Ceiling Amount  Description: The over ceiling amount in pay currency.
 
PAY_UNALLOWABLE_AMT    NUMBER(15, 5)  NO 
Name: Daily Pay Currency Unallowable Amount  Description: The unallowable amount in pay currency.
 
PAY_NON_REIMBURSE_AMT    NUMBER(15, 5)  NO 
Name: Daily Pay Currency Non-Reimbursable Amount  Description: The non-reimbursable amount in pay currency.
 
PERSONAL_FL    VARCHAR2(1)  NO 
Name: Personal Flag  Description: Logical as to whether this transaction is a personal expense.
 
TRANS_PERSONAL_AMT    NUMBER(15, 5)  NO 
Name: Daily Transaction Currency Personal Amount  Description: The personal amount in transaction currency.
 
BASE_PERSONAL_AMT    NUMBER(15, 5)  NO 
Name: Daily Pay Currency Personal Amount  Description: The personal amount in pay currency.
 
PAY_PERSONAL_AMT    NUMBER(15, 5)  NO 
Name: Daily Base Currency Personal Amount  Description: The personal amount in system base currency.
 

EXP_RPT_EXPENSE_DAY Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0189  PrimaryKey  EXP_RPT_ID, EXPENSE_ID, EXP_DT 

EXP_RPT_EXPENSE_DAY Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
EXP_RPT_EXPENSE  Identifying  One To Zero or More  F00237      EXP_RPT_ID, EXPENSE_ID  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable