DW_EMPLOYEE_EXPENSE_UNINVOICED_CF

Employee Expense Fact

Details

Module: Expenses

Key Columns

EXPENSE_DIST_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
EXPENSE_DIST_ID NUMBER 38 0 True Unique identifier of the expense distribution of a specific expense item.
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Source record identifier. Value is derived from expense distribution id
EXPENSE_AMOUNT NUMBER Amount to be reimbursed to the individual against this expense distribution.
LEDGER_EXPENSE_AMOUNT NUMBER Ledger amount calculated at distribution grain
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code.
GLOBAL_CURRENCY_EXCH_RATE NUMBER Global currency conversion from ledger currency
GLOBAL_EXPENSE_AMOUNT NUMBER Ledger amount in global currency.
RECEIPT_AMOUNT NUMBER Receipt amount calculated at distribution grain
ORIG_REIMBURSABLE_AMOUNT NUMBER Original reimburable amount calculated at distribution grain
COST_CENTER VARCHAR2 128 Cost center that the expense needs to be charged to
PJC_PROJECT_ID NUMBER 38 0 Identifier of the project used to build the transaction
PJC_TASK_ID NUMBER 38 0 Identifier of the task used to build the transaction
PJC_EXPENDITURE_TYPE_ID NUMBER 38 0 Expenditure type used to build the transaction
PJC_ORGANIZATION_ID NUMBER 38 0 Expenditure type used to build the transaction
PJC_EXPENDITURE_ITEM_DATE DATE Date on which a project-related expense is incurred.
CODE_COMBINATION_ID NUMBER 38 0 Identifier of the accounting code combination that expense is charged to.
COST_CENTER_SEGMENT VARCHAR2 32 Cost center segment. DW_COST_CENTER_D COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE VARCHAR2 64 Cost center value set code. DW_COST_CENTER_D COST_CENTER_VALUESET_CODE
GL_BALANCING_SEGMENT VARCHAR2 32 Balancing segment. DW_BALANCING_SEGMENT_D GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE VARCHAR2 64 Balancing segment value set code. DW_BALANCING_SEGMENT_D GL_BLNC_SGMNT_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT VARCHAR2 32 Natural account segment. DW_NATURAL_ACCOUNT_D NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE VARCHAR2 64 Natural account value set code. DW_NATURAL_ACCOUNT_D NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 VARCHAR2 32 Accounting segment 1. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE VARCHAR2 64 Accounting segment 1 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 VARCHAR2 32 Accounting segment 2. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE VARCHAR2 64 Accounting segment 2 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 VARCHAR2 32 Accounting segment 3. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE VARCHAR2 64 Accounting segment 3 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 VARCHAR2 32 Accounting segment 4. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE VARCHAR2 64 Accounting segment 4 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 VARCHAR2 32 Accounting segment 5. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE VARCHAR2 64 Accounting segment 5 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 VARCHAR2 32 Accounting segment 6. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE VARCHAR2 64 Accounting segment 6 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 VARCHAR2 32 Accounting segment 7. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE VARCHAR2 64 Accounting segment 7 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 VARCHAR2 32 Accounting segment 8. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE VARCHAR2 64 Accounting segment 8 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 VARCHAR2 32 Accounting segment 9. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE VARCHAR2 64 Accounting segment 9 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 VARCHAR2 32 Accounting segment 10. DW_GL_SEGMENT_D GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE VARCHAR2 64 Accounting segment 10 value set code. DW_GL_SEGMENT_D GL_SEGMENT_VALUESET_CODE
EXPENSE_ID NUMBER 38 0 Unique identifier of a specific expense item.
EXPENSE_TEMPLATE_ID NUMBER 38 0 Unique identifier of a specific expense template. DW_EXM_EXPENSE_TEMPLATES_D EXPENSE_TEMPLATE_ID
EXPENSE_TYPE_ID NUMBER 38 0 Unique identifier for a specific expense type. DW_EXM_EXPENSE_TYPES_D EXPENSE_TYPE_ID
EXPENSE_TYPE_CATEGORY_CODE VARCHAR2 128 This grouping allows expense types to include information such as class of fare, merchant, ticket number
EXPENSE_CATEGORY_CODE VARCHAR2 128 Classification of an expense item such as business or personal.
EXPENSE_SOURCE VARCHAR2 128 Source of an expense item, such as cash or corporate card.
EXPENSE_ITEM_DESCRIPTION VARCHAR2 256 Description of an expense item.
LINE_EXPENSE_AMOUNT NUMBER Amount to be reimbursed to the individual in reimbursable currency for this expense.
LINE_ORIG_REIMBURSABLE_AMOUNT NUMBER Original amount to be reimbursed to the individual for this expense.
EXCHANGE_RATE NUMBER Rate that represents the amount one currency can be exchanged for another at a specific point in time.
ORIG_EXCHANGE_RATE NUMBER Exchange rate of the expense before it was changed.
RECEIPT_CURRENCY_CODE VARCHAR2 64 Receipt currency of an expense item.
LINE_RECEIPT_AMOUNT NUMBER Amount of the receipt in the receipt currency.
LINE_PERSONAL_RECEIPT_AMOUNT NUMBER Amount of the expense that is marked as personal.
RECEIPT_REQUIRED_FLAG VARCHAR2 16 Indicator of whether this expense requires a receipt.
RECEIPT_MISSING_FLAG VARCHAR2 16 Indicator of whether the receipts are missing for this expense.
TRAVEL_TYPE VARCHAR2 128 Type of flight, whether domestic or international.
AUDIT_ADJUSTMENT_REASON_CODE VARCHAR2 128 Reason code for reimbursable amount to the individual during audit.
AUDIT_ADJUSTMENT_REASON VARCHAR2 256 Reason for adjusting the reimbursable amount to the individual during audit.
POLICY_VIOLATED_FLAG VARCHAR2 16 Indicator of whether the expense violated company policies.
POLICY_SHORTPAY_FLAG VARCHAR2 16 Indicator of whether the expense is short paid due to policy noncompliance.
JUSTIFICATION VARCHAR2 256 Reason an expense was incurred.
JUSTIFICATION_REQUIRED_FLAG VARCHAR2 16 Indicator of whether the expense requires justification.
TRANSACTION_DATE DATE Date when the expense occurred or the first day of an expense that spans multiple days.
LOCATION VARCHAR2 512 Location where the expense was incurred.
MERCHANT_NAME VARCHAR2 512 Name of the merchant where the expense was incurred.
IMG_RECEIPT_REQUIRED_FLAG VARCHAR2 16 Indicator of whether this expense requires an imaged receipt.
EXPENSE_CREATION_METHOD_CODE VARCHAR2 32 Method of expense item creation, such as mobile iOS device or mobile Android device.
LEGAL_EMPLOYER_ID NUMBER 38 0 Legal entity identifier. DW_LEGAL_EMPLOYER_D LEGAL_EMPLOYER_ID
EXPENSE_REPORT_ID NUMBER 38 0 Identifier of the expense report.
EXPENSE_REPORT_NAME VARCHAR2 256 Report Name
PERSON_ID NUMBER 38 0 Identifier of the person whose expenses are included in this expense report. DW_PERSON_D PERSON_ID
PREPARER_ID NUMBER 38 0 Identifier of the person who created the expense report. DW_PERSON_D PERSON_ID
ORG_ID NUMBER 38 0 Indicates the identifier of the business unit associated to the row. DW_INTERNAL_ORG_D ORGANIZATION_ID
LEDGER_ID NUMBER 38 0 Ledger identifier. DW_LEDGER_D LEDGER_ID
LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
LEDGER_LINE_EXPENSE_AMOUNT NUMBER Functional currency amount at expense line
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Accounting calendar name. DW_FISCAL_DAY_D FISCAL_PERIOD_SET_NAME
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type. DW_FISCAL_DAY_D FISCAL_PERIOD_TYPE
FISCAL_PERIOD_NAME VARCHAR2 64 Accounting period name. DW_FISCAL_DAY_D FISCAL_PERIOD_NAME
ASSIGNMENT_ID NUMBER 38 0 Identifier of the assignment of the person on the expense report. DW_WRKFRC_ASG_F ASSIGNMENT_ID
PURPOSE VARCHAR2 256 Business activities that justify the expense report.
REPORT_CREATION_METHOD_CODE VARCHAR2 32 Method of expense report creation, such as mobile iOS device or mobile Android device.
EXPENSE_STATUS_CODE VARCHAR2 128 Expense report approval status, such as Approved, Pending Manager Approval, or Paid.
RECEIPTS_STATUS_CODE VARCHAR2 128 Receipt status of an expense report, such as Missing, Required, and Received.
SHORTPAY_TYPE_CODE VARCHAR2 128 Indicator of why the expense report is short paid.
BOTHPAY_FLAG VARCHAR2 16 Indicator whether report contains corporate card transactions with Both Pay payment liability.
EXPENSE_REPORT_DATE DATE Month, day, and year in which an expense report is saved or submitted.
REPORT_SUBMIT_DATE DATE Month, day, and year in which an expense report is submitted.
RECEIPTS_RECEIVED_DATE DATE Date when receipts for the expense report are received.
EXPENSE_STATUS_DATE DATE Date when expense report acquired the current status.
REPORT_EXPENSE_AMOUNT NUMBER Total amount of the expense report in reimbursement currency.
REIMBURSEMENT_CURRENCY_CODE VARCHAR2 64 Currency of the amount to be reimbursed to the individual for the expenses incurred.
AUDIT_CODE VARCHAR2 128 Audit type for the expense report based on receipt requirements.
FINAL_APPROVAL_DATE DATE Date when final approval is obtained for the report
PAYMENT_METHOD_CODE VARCHAR2 128 Method of payment for this expense report such as check, cash, or credit.
CASH_EXPENSE_PAID_DATE DATE Date when cash expense was reimbursed to the individual.
JOB_ID NUMBER 38 0 Job Identifier DW_JOB_D JOB_ID
LOCATION_ID NUMBER 38 0 Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
DEPARTMENT_ID NUMBER 38 0 Department Identifier#5 DW_DEPARTMENT_D DEPARTMENT_ID
LEGISLATION_CODE VARCHAR2 256 Legislation of Assignment DW_LEGISLATION_D_TL LEGISLATION_CODE
CREATION_DATE DATE Date of the creation of the row. This is a date converted column.
IMAGED_RECEIPTS_RECEIVED_DATE DATE Date when an imaged receipt is received for an expense report.
EXM_EXPENSE_DISTS_CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
L_CHECKOUT_DATE DATE Date when a person departs a place associated with an accommodation expense category.
START_DATE DATE Date when the expense occurred or the first day of an expense that spans multiple days.
END_DATE DATE Last day of an expense that spans multiple days.
L_START_DATE DATE Date when the expense occurred or the first day of an expense that spans multiple days.
L_END_DATE DATE Last day of an expense that spans multiple days.
L_DESTINATION_FROM VARCHAR2 4000 Starting or departure location of the trip.
L_DESTINATION_TO VARCHAR2 4000 Ending or arrival location of the trip.
RECEIPT_VERIFIED_FLAG VARCHAR2 16 Indicator of whether the auditor verified the receipt for this expense.
L_MERCHANT_NAME VARCHAR2 512 Name of the merchant where the expense was incurred.
MERCHANT_DOCUMENT_NUMBER VARCHAR2 512 Receipt number on the receipt issued by the merchant.
MERCHANT_REFERENCE VARCHAR2 1024 Purchase identification of a transaction provided by the merchant at the point of sale.
MERCHANT_TAX_REG_NUMBER VARCHAR2 512 Unique sequence of letters and/or numbers assigned to a party or party site, by a tax authority, when it is registered and by which the party or party site registration will be identified.
L_EXPENSE_TYPE_CATEGORY_CODE VARCHAR2 128 This grouping allows expense types to include information such as class of fare, merchant, ticket number
TAX_CLASSIFICATION_CODE VARCHAR2 128 Tax code applicable to the expense item.
ATTRIBUTE_CATEGORY VARCHAR2 1024 Descriptive Flexfield: structure definition of the user descriptive flexfield.
L_ATTRIBUTE_CATEGORY VARCHAR2 1024 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ITEMIZATION_PARENT_EXPENSE_ID NUMBER 38 0 Unique identifier of the parent expense of an itemized expense item. Possible values are NULL indicating that the expense is not itemized, -1 indicating that the expense is a parent line with itemization, and greater than 0 indicating that the expense is an itemized child line and the value is the parent line's identifier.
TICKET_CLASS_CODE VARCHAR2 128 Cabin class of a flight or ship, for example business or economy.
L_TICKET_CLASS_CODE VARCHAR2 128 Cabin class of a flight or ship, for example business or economy.
L_TRAVEL_TYPE VARCHAR2 128 Type of flight, whether domestic or international.
CURRENT_APPROVER_ID NUMBER 38 0 Identifier of the current approver of the expense report.
LAST_AUDIT_BY NUMBER 38 0 Person identifier of the expense auditor who previously audited the expense report.
EXPENSE_AMOUNT_TRX_CURR NUMBER Expense amount in transactional Currency
MANAGER_ASSIGNMENT_ID NUMBER 38 0 Identifier of the manager for the current assignment.
ASSIGNMENT_ANCHOR_DATE DATE This column will store Report Submit Date, if this is NULL it will store Report Date