EXP_RPT 
Default Table Name  EXP_RPT 
Definition 
 Name: Expense Report.     Description: This table contains the overall information about specific expense reports.
 

EXP_RPT Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
EXP_RPT_ID(PK)    VARCHAR(10)  NO 
Name: Expense Report ID. Description: The unique identifier for the expense report.
 
EMPL_ID(FK)    VARCHAR(20)  NO 
Name: Employee ID. Description: The employee whose export it is.
 
EXP_RPT_DESC    VARCHAR(30)  NO 
Name: Expense Report Description. Description: Short description of the expense report.
 
EXP_RPT_DT    DATE  NO 
Name: Expense Report Date. Description: User assigned date for expense report.
 
REVISION_NO    NUMERIC(10, 0)  NO 
Name: Revision Number. Description: The current revision of the expense report.
 
S_EXP_RPT_STATUS_CD    VARCHAR(1)  NO 
Name: Expense Report Status. Description: The valid values are: D - Draft S – Submitted U – Under Review A – Approved R – Rejected P – Processed V – Voided
 
S_RECEIPT_STATUS_CD    VARCHAR(1)  NO 
Name: Receipt Status. Description: P – Pending R – Received N – Not Applicable
 
START_DT    DATE  NO 
Name: Start Date. Description: Starting date of expenses. This mainly for trip type expenses.
 
END_DT    DATE  NO 
Name: End Date. Description: Starting date of expenses. This mainly for trip type expenses. 
 
PURPOSE_TEXT    VARCHAR(4000)  YES 
Name: Purpose. Description: The purpose of the expenses on the report.
 
PER_DIEM_SCHEDULE_CD(FK)    VARCHAR(10)  YES 
Name: Per Diem Schedule. Description: The per diem schedule that applies to the expense report.
 
CURRENCY_SCHEDULE_CD(FK)    VARCHAR(10)  YES 
Name: Currency Schedule. Description: The currency schedule that applies to the expense report.
 
EXP_RPT_TYPE_CD(FK)    VARCHAR(10)  NO 
Name: Expense Report Type. Description: The type of expense report.
 
EXP_CLASS_CD(FK)    VARCHAR(20)  NO 
Name: Expense Class. Description: The expense class of the employee at the time of the expense report.
 
UNAVAILABLE_FL    VARCHAR(1)  NO 
Name: Unavailable Flag. Description: Logical as to whether this expense report is unavailable.
 
BATCH_ID    VARCHAR(10)  YES 
Name: Batch ID. Description: The ID of the process that currently has the expense report unavailable
 
CP_COMPANY_CD(FK)    VARCHAR(10)  NO 
Name: Costpoint Company. Description: Costpoint Company Code of expense report. (Employee)
 
SUBMIT_WARNING_TEXT    VARCHAR(1000)  YES 
Name: Sign Warnings. Description: Warnings received during last expense report submit.
 
PAY_CURRENCY_CD(FK)    VARCHAR(3)  NO 
Name: Pay Currency. Description: The currency code of that the employee will be reimbursed in.
 
BASE_CURRENCY_CD(FK)    VARCHAR(3)  NO 
Name: Base Currency. Description: The base currency code of the system. 
 
MODIFIED_BY    VARCHAR(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMERIC(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.
 
EXP_RPT_UDT_ID    VARCHAR(50)  YES 
Name: Expense Report Header UDT Option. Description: The configured UDT that is displayed in header.
 
S_IMAGE_STATUS_CD    VARCHAR(1)  NO 
Name: Receipt Image Status. Description: The system assigned image status code. The valid values are: P – Pending R – Received N – Not Applicable
 
EXP_AUTH_ID(FK)    VARCHAR(10)  YES 
Name: Expene Authorization ID. Description: The Expense Authorization for this expense report. 
 
RECEIVABLE_UDT01_ID    VARCHAR(50)  YES 
Name: Receivable UDT01 ID. Description: The UDT01 identifier for the employee receivable charge.
 
RECEIVABLE_UDT02_ID    VARCHAR(50)  YES 
Name: Receivable UDT02 ID. Description: The UDT02 identifier for the employee receivable charge.
 
RECEIVABLE_UDT03_ID    VARCHAR(20)  YES 
Name: Receivable UDT03 ID. Description: The UDT03 identifier for the employee receivable charge.
 
RECEIVABLE_UDT04_ID    VARCHAR(20)  YES 
Name: Receivable UDT04 ID. Description: The UDT04 identifier for the employee receivable charge.
 
RECEIVABLE_UDT05_ID    VARCHAR(20)  YES 
Name: Receivable UDT05 ID. Description: The UDT05 identifier for the employee receivable charge.
 
RECEIVABLE_UDT06_ID    VARCHAR(20)  YES 
Name: Receivable UDT06 ID. Description: The UDT06 identifier for the employee receivable charge.
 
RECEIVABLE_UDT07_ID    VARCHAR(20)  YES 
Name: Receivable UDT07 ID. Description: The UDT07 identifier for the employee receivable charge.
 
RECEIVABLE_UDT08_ID    VARCHAR(20)  YES 
Name: Receivable UDT08 ID. Description: The UDT08 identifier for the employee receivable charge.
 
RECEIVABLE_UDT09_ID    VARCHAR(20)  YES 
Name: Receivable UDT09 ID. Description: The UDT09 identifier for the employee receivable charge.
 
RECEIVABLE_UDT10_ID    VARCHAR(20)  YES 
Name: Receivable UDT10 ID. Description: The UDT10 identifier for the employee receivable charge.
 
RECEIVABLE_UDT06_CP_COMPANY_CD    VARCHAR(10)  YES 
Name: Receivable UDT06 Costpoint Company. Description: Costpoint Company Code for employee receivable UDT06_ID field.
 
RECEIVABLE_UDT07_CP_COMPANY_CD    VARCHAR(10)  YES 
Name: Receivable UDT07 Costpoint Company. Description: Costpoint Company Code for employee receivable UDT07_ID field.
 
RECEIVABLE_EXPENSE_REF_CD    VARCHAR(20)  YES 
Name: Receivable Reference Code. Description: User defined reference code for employee receivable charge.
 
PAY_RECEIVABLE_AMT    NUMERIC(15, 5)  NO 
Name: Pay Currency Receivable Amount. Description: The employee receivable amount. This amount is in the employee’s pay currency.
 
BASE_RECEIVABLE_AMT    NUMERIC(15, 5)  NO 
Name: Base Currency Receivable Amount. Description: The employee receivable amount. This amount is in the system’s base currency.
 
S_DUE_COMPANY_PAYMENT_CD    VARCHAR(10)  NO 
Name: Due Company Payment Option. Description: Indicates the method of payment the employee indicated for net due company expense reports. The valid values are as follows: NONE - None CASH – Cash CHECK – Check DEDUCTION – Payroll Deduction OTHER – Other
 
DUE_COMPANY_REFERENCE_S    VARCHAR(20)  YES 
Name: Due Company Payment Reference. Description: Text field where employee can provide details if payment is check or other.
 
PAYMENT_UDT01_ID    VARCHAR(50)  YES 
Name: Payment UDT01 ID. Description: The UDT01 identifier for the payment.
 
PAYMENT_UDT02_ID    VARCHAR(50)  YES 
Name: Payment UDT02 ID. Description: The UDT02 identifier for the payment.
 
PAYMENT_UDT03_ID    VARCHAR(20)  YES 
Name: Payment UDT03 ID. Description: The UDT03 identifier for the payment.
 
PAYMENT_UDT04_ID    VARCHAR(20)  YES 
Name: Payment UDT04 ID. Description: The UDT04 identifier for the payment.
 
PAYMENT_UDT05_ID    VARCHAR(20)  YES 
Name: Payment UDT05 ID. Description: The UDT05 identifier for the payment.
 
PAYMENT_UDT06_ID    VARCHAR(20)  YES 
Name: Payment UDT06 ID. Description: The UDT06 identifier for the payment.
 
PAYMENT_UDT07_ID    VARCHAR(20)  YES 
Name: Payment UDT07 ID. Description: The UDT07 identifier for the payment.
 
PAYMENT_UDT08_ID    VARCHAR(20)  YES 
Name: Payment UDT08 ID. Description: The UDT08 identifier for the payment.
 
PAYMENT_UDT09_ID    VARCHAR(20)  YES 
Name: Payment UDT09 ID. Description: The UDT09 identifier for the payment.
 
PAYMENT_UDT10_ID    VARCHAR(20)  YES 
Name: Payment UDT10 ID. Description: The UDT10 identifier for the payment.
 
PAYMENT_UDT06_CP_COMPANY_CD    VARCHAR(10)  YES 
Name: Payment UDT06 Costpoint Company. Description: Costpoint Company Code for UDT06_ID field for the payment.
 
PAYMENT_UDT07_CP_COMPANY_CD    VARCHAR(10)  YES 
Name: Payment UDT07 Costpoint Company. Description: Costpoint Company Code for UDT07_ID field for the payment.
 
PAYMENT_EXPENSE_REF_CD    VARCHAR(20)  YES 
Name: Payment Reference Code. Description: User defined reference code for the payment.
 
FIRST_DAY_TRIP_FL    VARCHAR(1)  NO 
Name: First Day Trip Flag. Description: Logical as to whether this expense report contains the first day of the trip.
 
LAST_DAY_TRIP_FL    VARCHAR(1)  NO 
Name: Last Day Trip Flag. Description: Logical as to whether this expense report contains the last day of the trip.
 
CODE1_CD    VARCHAR(20)  YES 
Name: User Defined Code 1. Description: The Code1 user defined field. The values are based on the expense report type.
 
CODE2_CD    VARCHAR(20)  YES 
Name: User Defined Code 2. Description: The Code2 user defined field. The values are based on the expense report type.
 
CODE3_CD    VARCHAR(20)  YES 
Name: User Defined Code 3. Description: The Code3 user defined field. The values are based on the expense report type.
 
RECEIVABLE_UDT11_ID    VARCHAR(20)  YES 
Name: Receivable UDT11 ID. Description: The UDT11 identifier for the Receivable line.
 
RECEIVABLE_UDT12_ID    VARCHAR(20)  YES 
Name: Receivable UDT12 ID. Description: The UDT12 identifier for the Receivable line.
 
RECEIVABLE_UDT13_ID    VARCHAR(20)  YES 
Name: Receivable UDT13 ID. Description: The UDT13 identifier for the Receivable line.
 
RECEIVABLE_UDT14_ID    VARCHAR(20)  YES 
Name: Receivable UDT14 ID. Description: The UDT14 identifier for the Receivable line.
 
RECEIVABLE_UDT15_ID    VARCHAR(20)  YES 
Name: Receivable UDT15 ID. Description: The UDT15 identifier for the Receivable line.
 
PAYMENT_UDT11_ID    VARCHAR(20)  YES 
Name: Payment UDT11 ID. Description: The UDT11 identifier for the payment.
 
PAYMENT_UDT12_ID    VARCHAR(20)  YES 
Name: Payment UDT12 ID. Description: The UDT12 identifier for the payment.
 
PAYMENT_UDT13_ID    VARCHAR(20)  YES 
Name: Payment UDT13 ID. Description: The UDT13 identifier for the payment.
 
PAYMENT_UDT14_ID    VARCHAR(20)  YES 
Name: Payment UDT14 ID. Description: The UDT14 identifier for the payment.
 
PAYMENT_UDT15_ID    VARCHAR(20)  YES 
Name: Payment UDT15 ID. Description: The UDT15 identifier for the payment.
 
SHORT_HEADER_TEXT    VARCHAR(4000)  YES 
Name: Expense Report Notes. Description: Administrative notes pertaining to the entire expense report.
 
CORRECTION_NO    NUMERIC(10, 0)  NO 
Name: Correction Number. Description: The current correction number of the expense report.
 

EXP_RPT Keys 
Key Name  Key Type  Keys 
RI_F00346  Inversion Entry  EXP_AUTH_ID 
RI_F00207  Inversion Entry  EMPL_ID 
RI_F00206  Inversion Entry  CURRENCY_SCHEDULE_CD 
RI_F00205  Inversion Entry  BASE_CURRENCY_CD 
RI_F00204  Inversion Entry  PAY_CURRENCY_CD 
RI_F00203  Inversion Entry  CP_COMPANY_CD 
PI_0180  PrimaryKey  EXP_RPT_ID 
RI_F00210  Inversion Entry  PER_DIEM_SCHEDULE_CD 
RI_F00209  Inversion Entry  EXP_RPT_TYPE_CD 
RI_F00208  Inversion Entry  EXP_CLASS_CD 

EXP_RPT Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
CP_COMPANY  Non-Identifying  One To Zero or More        CP_COMPANY_CD  NO 
CURRENCY  Non-Identifying  One To Zero or More        PAY_CURRENCY_CD  NO 
CURRENCY  Non-Identifying  One To Zero or More        BASE_CURRENCY_CD  NO 
CURRENCY_SCHEDULE  Non-Identifying  Zero or One to Zero or More        CURRENCY_SCHEDULE_CD  NO 
EMPL  Non-Identifying  One To Zero or More        EMPL_ID  NO 
EXP_CLASS  Non-Identifying  One To Zero or More        EXP_CLASS_CD  NO 
EXP_RPT_TYPE  Non-Identifying  One To Zero or More        EXP_RPT_TYPE_CD  NO 
PER_DIEM  Non-Identifying  Zero or One to Zero or More        PER_DIEM_SCHEDULE_CD  NO 
EXP_AUTH  Non-Identifying  Zero or One to Zero or More        EXP_AUTH_ID  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
EXP_RPT_CHARGE_ALLOCATIONS  Identifying  One To Zero or More          NO 
EXP_RPT_PAYMENT  Identifying  One To Zero or More          NO 
EXP_RPT_REVISION  Identifying  One To Zero or More          NO 
EXP_RPT_EXPENSE  Identifying  One To Zero or More          NO 
ADVANCE_OUTSTANDING  Non-Identifying  One To Zero or More          NO 
EXP_RPT_LOCATION  Identifying  One To Zero or More          NO 
TASK  Non-Identifying  One To Zero or More          NO 
CORRECT_TASK  Non-Identifying  One To Zero or More          NO 
EXP_RPT_WARNING  Identifying  One To Zero or More          NO 
EXP_RPT_ADVANCE  Identifying  One To Zero or More          NO