eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AP.AP_EXPENSE_REPORT_LINES_ALL

Object Details

Object Name:	AP_EXPENSE_REPORT_LINES_ALL
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_EXPENSE_REPORT_LINES_ALL
Subobject Name:
Status:	VALID

AP_EXPENSE_REPORT_LINES_ALL stores detailed information about expense items for individual expense reports you enter. Your Oracle Payables application uses this information to create invoice distributions when you import expense reports using the Expense Report Import program.

This table corresponds to the tabbed regions of the Expense Reports window.
This table has no primary key.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_EXPENSE_REPORT_LINES_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	REPORT_LINE_ID
AP_EXPENSE_REPORT_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REPORT_HEADER_ID
AP_EXPENSE_REPORT_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REFERENCE_1 REFERENCE_2
AP_EXPENSE_REPORT_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TASK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REPORT_HEADER_ID	NUMBER		Yes	Expense report header identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this 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 this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)		Standard who column - user who created this 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.
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
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
AMOUNT_INCLUDES_TAX_FLAG	VARCHAR2	(1)		Amount includes tax flag
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
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
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
CREDIT_CARD_TRX_ID	NUMBER	(15)		Identifies the credit card transaction from which the expense line is derived
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 expesne report
TASK_NAME	VARCHAR2	(30)		Temporary storage for task number when user enteres it manually and wants to save the expesne 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 Id.
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.
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)		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)		Image Receipt Required Flag
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 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
,      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
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      AMOUNT_INCLUDES_TAX_FLAG
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      ADJUSTMENT_REASON
,      POLICY_SHORTPAY_FLAG
,      AWARD_ID
,      MERCHANT_DOCUMENT_NUMBER
,      MERCHANT_REFERENCE
,      MERCHANT_TAX_REG_NUMBER
,      MERCHANT_TAXPAYER_ID
,      COUNTRY_OF_SUPPLY
,      TAX_CODE_OVERRIDE_FLAG
,      TAX_CODE_ID
,      CREDIT_CARD_TRX_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_ALL;

Dependencies

[top of page]

AP.AP_EXPENSE_REPORT_LINES_ALL does not reference any database object

AP.AP_EXPENSE_REPORT_LINES_ALL is referenced by following:

AP: AP_EXPENSE_REPORT_LINES_ALL#