DBA Data[Home] [Help] [Dependency Information]

TABLE: AP.AP_EXPENSE_REPORT_LINES_ARC

Object Details
Object Name: AP_EXPENSE_REPORT_LINES_ARC
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_EXPENSE_REPORT_LINES_ARC
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ARC_REQ_ID NUMBER
Yes Archive Request Identifier
ARCHIVE_DATE DATE

Archive Date - date when this row was created.
REPORT_HEADER_ID NUMBER
Yes Expense report header identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated expense line row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated expense line row (foreign key to FND_USER.USER_ID).
CODE_COMBINATION_ID NUMBER

Code combination identifier
ITEM_DESCRIPTION VARCHAR2 (240) Yes Description of expense report item
SET_OF_BOOKS_ID NUMBER (15) Yes Set of books identifier
AMOUNT NUMBER

Amount
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
CURRENCY_CODE VARCHAR2 (15) Yes Currency code
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange rate type for an item on a foreign currency expense report
EXCHANGE_RATE NUMBER

Exchange rate for a foreign currency
EXCHANGE_DATE DATE

Date exchange rate is effective, usually accounting date of a transaction
VAT_CODE VARCHAR2 (30)
Tax code
LINE_TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Name of line type
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated expense line row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE

Standard who column - date when the expense line row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created the expense line row (foreign key to FND_USER.USER_ID)
STAT_AMOUNT NUMBER

Statistical amount associated with an item
USSGL_TRANSACTION_CODE VARCHAR2 (30)
Transaction code for creating US Standard General Ledger journal entries
USSGL_TRX_CODE_CONTEXT VARCHAR2 (30)
USSGL Transaction Code Descriptive Flexfield context column
PROJECT_ACCOUNTING_CONTEXT VARCHAR2 (30)
Descriptive Flexfield structure defining column for Oracle Projects expense report line
PROJECT_ID NUMBER (15)
Project identifier for Oracle Projects expense report line
TASK_ID NUMBER (15)
Task identifier for Oracle Projects expense report line
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
Orgaization identifier for Oracle Projects expense report line
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure type for Oracle Projects expense report line
EXPENDITURE_ITEM_DATE DATE

Item date for Oracle Projects expense report line
PA_QUANTITY NUMBER

Quantity for Oracle Projects expense report line
DISTRIBUTION_LINE_NUMBER NUMBER (15)
Line number for invoice distribution line created from expense report line
REFERENCE_1 VARCHAR2 (30)
Reference 1
REFERENCE_2 VARCHAR2 (30)
Reference 2
AWT_GROUP_ID NUMBER (15)
Withholding Tax group identifier
ORG_ID NUMBER (15)
Organization identifier
RECEIPT_VERIFIED_FLAG VARCHAR2 (1)
Indicates whether your payables department received for the expense line
JUSTIFICATION_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether a justification is required for the expense line
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether you payables department requires that a receipt be sent to them for the expense line
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
RECEIPT_MISSING_FLAG VARCHAR2 (1)
Indicates whether the employee does not possess a receipt for an expense line.
JUSTIFICATION VARCHAR2 (240)
Reason the employee gave to justify incurring the expense.
EXPENSE_GROUP VARCHAR2 (80)
User-defined label used to identify a group of expense lines contained on a single receipt, for example, a hotel bill.
START_EXPENSE_DATE DATE

Start date for expense
END_EXPENSE_DATE DATE

End date for expense
RECEIPT_CURRENCY_CODE VARCHAR2 (15)
Indicates the code for the currency in which the expense line was incurred.
RECEIPT_CONVERSION_RATE NUMBER

The user-defined conversion rate between the receipt currency and the currency in which the expense report will be paid.
DAILY_AMOUNT NUMBER

Indicates the amount charged daily for a multi-day receipt, for example, the daily rate of a rental car or hotel room.
RECEIPT_CURRENCY_AMOUNT NUMBER

The amount that appears on the receipt
WEB_PARAMETER_ID NUMBER

Expense report item type identifier
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (1)
Flag to indicate whether the amount includes tax
ADJUSTMENT_REASON VARCHAR2 (240)
Reason your payables department adjusted (reduced) the expense line amount, or reason your payables department short paid an expense line.
POLICY_SHORTPAY_FLAG VARCHAR2 (1)
Flag to indicate policy violation shortpay
AWARD_ID NUMBER (15)
If Oracle Grants Accounting is installed, the award ID is used with data in project columns to track grant information
CREDIT_CARD_TRX_ID NUMBER (15)
Identifies the credit card transaction from which the expense line is derived
MERCHANT_DOCUMENT_NUMBER VARCHAR2 (80)
Third party document number
MERCHANT_REFERENCE VARCHAR2 (240)
Third party reference number
MERCHANT_TAX_REG_NUMBER VARCHAR2 (80)
Third party tax registration number
MERCHANT_TAXPAYER_ID VARCHAR2 (80)
Third party taxpayer identifier
COUNTRY_OF_SUPPLY VARCHAR2 (5)
Country where services or goods were received
TAX_CODE_OVERRIDE_FLAG VARCHAR2 (1)
Indicates whether the user has overwritten the tax code for the invoice distribution. The possible values for this flag are: Y and N
TAX_CODE_ID NUMBER (15)
Tax code identifier
ITEMIZE_ID NUMBER (15)
No longer used
PROJECT_NAME VARCHAR2 (30)
Temporary storage for project number when user enteres it manually and wants to save the expense report
TASK_NAME VARCHAR2 (30)
Temporary storage for task number when user enteres it manually and wants to save the expense report
COMPANY_PREPAID_INVOICE_ID NUMBER (15)
Invoice ID when this line is an prepaid credit card transaction
PA_INTERFACED_FLAG VARCHAR2 (1)
This flag is set to Y if this is a project-related Oracle Internet Expense expense report line that has been transferred to Oracle Projects
PROJECT_NUMBER VARCHAR2 (30)
Project number for project-related expense report line
TASK_NUMBER VARCHAR2 (30)
Task number for project-related expense report line
AWARD_NUMBER VARCHAR2 (15)
Award Number
VEHICLE_CATEGORY_CODE VARCHAR2 (30)
Vehicle category
VEHICLE_TYPE VARCHAR2 (30)
Vehicle type
FUEL_TYPE VARCHAR2 (30)
Fuel type
NUMBER_PEOPLE NUMBER

Number of passengers
DAILY_DISTANCE NUMBER

Daily distance
DISTANCE_UNIT_CODE VARCHAR2 (30)
Distance unit
AVG_MILEAGE_RATE NUMBER

Mileage rate
DESTINATION_FROM VARCHAR2 (80)
Location from
DESTINATION_TO VARCHAR2 (80)
Location to
TRIP_DISTANCE NUMBER

Trip distance
LICENSE_PLATE_NUMBER VARCHAR2 (30)
License plate number.
MILEAGE_RATE_ADJUSTED_FLAG VARCHAR2 (1)
Mileage rate adjusted status indicator
LOCATION_ID NUMBER (15)
Location Identifier
NUM_PDM_DAYS1 NUMBER

First day
NUM_PDM_DAYS2 NUMBER

Number of interim days
NUM_PDM_DAYS3 NUMBER

Last day
PER_DIEM_RATE1 NUMBER

Rate for first day
PER_DIEM_RATE2 NUMBER

Rate for interim days
PER_DIEM_RATE3 NUMBER

Rate for last day
DEDUCTION_ADDITION_AMT1 NUMBER

Total deduction/addition for first day
DEDUCTION_ADDITION_AMT2 NUMBER

Total deduction/addition for interim days
DEDUCTION_ADDITION_AMT3 NUMBER

Total deduction/aaddition for last day
NUM_FREE_BREAKFASTS1 NUMBER

Number of free breakfasts for the first day
NUM_FREE_LUNCHES1 NUMBER

Number of free lunches for the first day
NUM_FREE_DINNERS1 NUMBER

Number of free dinners for the first day
NUM_FREE_ACCOMMODATIONS1 NUMBER

Number of free accommodations for the first day
NUM_FREE_BREAKFASTS2 NUMBER

Number of free breakfasts for interim.
NUM_FREE_LUNCHES2 NUMBER

Number of free lunches for the interim.
NUM_FREE_DINNERS2 NUMBER

Number of free dinners for the interim.
NUM_FREE_ACCOMMODATIONS2 NUMBER

Number of free accommodations for interim
NUM_FREE_BREAKFASTS3 NUMBER

Number of free breakfasts for the last day
NUM_FREE_LUNCHES3 NUMBER

Number of free lunches for the last day
NUM_FREE_DINNERS3 NUMBER

Number of free dinners for the last day.
NUM_FREE_ACCOMMODATIONS3 NUMBER

Number of free accommodations for last day
ATTENDEES VARCHAR2 (240)
Attendees
NUMBER_ATTENDEES NUMBER

Number of attendees
TRAVEL_TYPE VARCHAR2 (30)
Travel type
TICKET_CLASS_CODE VARCHAR2 (30)
Ticket class code.
TICKET_NUMBER VARCHAR2 (80)
Ticket number
FLIGHT_NUMBER VARCHAR2 (80)
Flight number.
LOCATION_TO_ID NUMBER (15)
ID for Location To
ITEMIZATION_PARENT_ID NUMBER

Indicates a line's involvement in an itemization: if NULL, line is not involved in an itemization; if -1, line is a parent line for an itemization; if >0, line is an itemized child line and this value is the parent line's REPORT_LINE_ID
FLEX_CONCATENATED VARCHAR2 (240)
Cost center for the expense line
FUNC_CURRENCY_AMT NUMBER

Reimbursement amount in functional currency
LOCATION VARCHAR2 (80)
Location Name
CATEGORY_CODE VARCHAR2 (30)
Category Code
ADJUSTMENT_REASON_CODE VARCHAR2 (30)
Identifies the reason why the expense line was adjusted
AP_VALIDATION_ERROR VARCHAR2 (240)
Contains errors encountered during validation
SUBMITTED_AMOUNT NUMBER

The original reimbursement amount. This column is populated if the auditor adjusts the reimbursement amount
REPORT_LINE_ID NUMBER (15) Yes Report Line Identifier
ALLOCATION_REASON VARCHAR2 (240)
Reason for updating allocations for this report line.
ALLOCATION_SPLIT_CODE VARCHAR2 (30)
Indicates how this expense line is split. A null value indicates that the line is not split
RATE_PER_PASSENGER NUMBER

Passenger rate used
PASSENGER_RATE_TYPE VARCHAR2 (30)
Passenger rate type
PASSENGER_AMOUNT NUMBER

Passenger amount
RANGE_LOW NUMBER

Distance threshold low range
RANGE_HIGH NUMBER

Distance threshold high range
UOM_DAYS NUMBER

Unit of measure in days for per diem expense type
IMAGE_RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
Flag to indicate the image receipt requirment
RECEIPTS_ISSUE VARCHAR2 (240)
Receipts Issue
ADJUSTMENT_REASON_COPY VARCHAR2 (30)
Holds the value of adjustment reason for manager approval notification
MERCHANT_NAME#1 VARCHAR2 (240)
Third party name
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ARC_REQ_ID
,      ARCHIVE_DATE
,      REPORT_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CODE_COMBINATION_ID
,      ITEM_DESCRIPTION
,      SET_OF_BOOKS_ID
,      AMOUNT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      VAT_CODE
,      LINE_TYPE_LOOKUP_CODE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      STAT_AMOUNT
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      PROJECT_ACCOUNTING_CONTEXT
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ITEM_DATE
,      PA_QUANTITY
,      DISTRIBUTION_LINE_NUMBER
,      REFERENCE_1
,      REFERENCE_2
,      AWT_GROUP_ID
,      ORG_ID
,      RECEIPT_VERIFIED_FLAG
,      JUSTIFICATION_REQUIRED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      RECEIPT_MISSING_FLAG
,      JUSTIFICATION
,      EXPENSE_GROUP
,      START_EXPENSE_DATE
,      END_EXPENSE_DATE
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_CONVERSION_RATE
,      DAILY_AMOUNT
,      RECEIPT_CURRENCY_AMOUNT
,      WEB_PARAMETER_ID
,      AMOUNT_INCLUDES_TAX_FLAG
,      ADJUSTMENT_REASON
,      POLICY_SHORTPAY_FLAG
,      AWARD_ID
,      CREDIT_CARD_TRX_ID
,      MERCHANT_DOCUMENT_NUMBER
,      MERCHANT_REFERENCE
,      MERCHANT_TAX_REG_NUMBER
,      MERCHANT_TAXPAYER_ID
,      COUNTRY_OF_SUPPLY
,      TAX_CODE_OVERRIDE_FLAG
,      TAX_CODE_ID
,      ITEMIZE_ID
,      PROJECT_NAME
,      TASK_NAME
,      COMPANY_PREPAID_INVOICE_ID
,      PA_INTERFACED_FLAG
,      PROJECT_NUMBER
,      TASK_NUMBER
,      AWARD_NUMBER
,      VEHICLE_CATEGORY_CODE
,      VEHICLE_TYPE
,      FUEL_TYPE
,      NUMBER_PEOPLE
,      DAILY_DISTANCE
,      DISTANCE_UNIT_CODE
,      AVG_MILEAGE_RATE
,      DESTINATION_FROM
,      DESTINATION_TO
,      TRIP_DISTANCE
,      LICENSE_PLATE_NUMBER
,      MILEAGE_RATE_ADJUSTED_FLAG
,      LOCATION_ID
,      NUM_PDM_DAYS1
,      NUM_PDM_DAYS2
,      NUM_PDM_DAYS3
,      PER_DIEM_RATE1
,      PER_DIEM_RATE2
,      PER_DIEM_RATE3
,      DEDUCTION_ADDITION_AMT1
,      DEDUCTION_ADDITION_AMT2
,      DEDUCTION_ADDITION_AMT3
,      NUM_FREE_BREAKFASTS1
,      NUM_FREE_LUNCHES1
,      NUM_FREE_DINNERS1
,      NUM_FREE_ACCOMMODATIONS1
,      NUM_FREE_BREAKFASTS2
,      NUM_FREE_LUNCHES2
,      NUM_FREE_DINNERS2
,      NUM_FREE_ACCOMMODATIONS2
,      NUM_FREE_BREAKFASTS3
,      NUM_FREE_LUNCHES3
,      NUM_FREE_DINNERS3
,      NUM_FREE_ACCOMMODATIONS3
,      ATTENDEES
,      NUMBER_ATTENDEES
,      TRAVEL_TYPE
,      TICKET_CLASS_CODE
,      TICKET_NUMBER
,      FLIGHT_NUMBER
,      LOCATION_TO_ID
,      ITEMIZATION_PARENT_ID
,      FLEX_CONCATENATED
,      FUNC_CURRENCY_AMT
,      LOCATION
,      CATEGORY_CODE
,      ADJUSTMENT_REASON_CODE
,      AP_VALIDATION_ERROR
,      SUBMITTED_AMOUNT
,      REPORT_LINE_ID
,      ALLOCATION_REASON
,      ALLOCATION_SPLIT_CODE
,      RATE_PER_PASSENGER
,      PASSENGER_RATE_TYPE
,      PASSENGER_AMOUNT
,      RANGE_LOW
,      RANGE_HIGH
,      UOM_DAYS
,      IMAGE_RECEIPT_REQUIRED_FLAG
,      RECEIPTS_ISSUE
,      ADJUSTMENT_REASON_COPY
,      MERCHANT_NAME#1
FROM AP.AP_EXPENSE_REPORT_LINES_ARC;

Dependencies

[top of page]

AP.AP_EXPENSE_REPORT_LINES_ARC does not reference any database object

AP.AP_EXPENSE_REPORT_LINES_ARC is referenced by following:

SchemaAP
ViewAP_EXPENSE_REPORT_LINES_ARC#