[Home] [Help]
View: APBV_EXPENSE_REPORT_LINES
View Text
SELECT REPORT_HEADER_ID
, AERLA.LAST_UPDATE_DATE
, AERLA.LAST_UPDATED_BY
, AERLA.ITEM_DESCRIPTION
, AERLA.SET_OF_BOOKS_ID
, AERLA.AMOUNT
, '_DF:SQLAP:AP_EXPENSE_REPORT_LINES:AERLA'
, AERLA.CURRENCY_CODE
, AERLA.EXCHANGE_RATE_TYPE
, AERLA.EXCHANGE_RATE
, AERLA.EXCHANGE_DATE
, AERLA.VAT_CODE
, AERLA.LINE_TYPE_LOOKUP_CODE
, AERLA.CREATION_DATE
, AERLA.CREATED_BY
, AERLA.STAT_AMOUNT
, AERLA.USSGL_TRANSACTION_CODE
, AERLA.USSGL_TRX_CODE_CONTEXT
, AERLA.EXPENDITURE_TYPE
, AERLA.EXPENDITURE_ITEM_DATE
, AERLA.PA_QUANTITY
, AERLA.DISTRIBUTION_LINE_NUMBER
, AERLA.REFERENCE_1
, AERLA.REFERENCE_2
, AERLA.AWT_GROUP_ID
, AERLA.ORG_ID
, AERLA.RECEIPT_VERIFIED_FLAG
, AERLA.JUSTIFICATION_REQUIRED_FLAG
, AERLA.RECEIPT_REQUIRED_FLAG
, AERLA.RECEIPT_MISSING_FLAG
, AERLA.JUSTIFICATION
, AERLA.EXPENSE_GROUP
, AERLA.START_EXPENSE_DATE
, AERLA.END_EXPENSE_DATE
, AERLA.RECEIPT_CURRENCY_CODE
, AERLA.RECEIPT_CONVERSION_RATE
, AERLA.DAILY_AMOUNT
, AERLA.RECEIPT_CURRENCY_AMOUNT
, AERLA.WEB_PARAMETER_ID
, AERLA.AMOUNT_INCLUDES_TAX_FLAG
, AERLA.ADJUSTMENT_REASON
, AERLA.POLICY_SHORTPAY_FLAG
, AERLA.CREDIT_CARD_TRX_ID
, AERLA.MERCHANT_DOCUMENT_NUMBER
, AERLA.MERCHANT_NAME
, AERLA.MERCHANT_REFERENCE
, AERLA.MERCHANT_TAX_REG_NUMBER
, AERLA.MERCHANT_TAXPAYER_ID
, AERLA.COUNTRY_OF_SUPPLY
, AERLA.TAX_CODE_OVERRIDE_FLAG
, AERLA.TAX_CODE_ID
, AERLA.ITEMIZE_ID
, AERLA.COMPANY_PREPAID_INVOICE_ID
, AERLA.VEHICLE_CATEGORY_CODE
, AERLA.VEHICLE_TYPE
, AERLA.FUEL_TYPE
, AERLA.NUMBER_PEOPLE
, AERLA.DAILY_DISTANCE
, AERLA.DISTANCE_UNIT_CODE
, AERLA.AVG_MILEAGE_RATE
, AERLA.DESTINATION_FROM
, AERLA.DESTINATION_TO
, AERLA.TRIP_DISTANCE
, AERLA.LICENSE_PLATE_NUMBER
, AERLA.MILEAGE_RATE_ADJUSTED_FLAG
, AERLA.LOCATION_ID
, AERLA.NUM_PDM_DAYS1
, AERLA.NUM_PDM_DAYS2
, AERLA.NUM_PDM_DAYS3
, AERLA.PER_DIEM_RATE1
, AERLA.PER_DIEM_RATE2
, AERLA.PER_DIEM_RATE3
, AERLA.DEDUCTION_ADDITION_AMT1
, AERLA.DEDUCTION_ADDITION_AMT2
, AERLA.DEDUCTION_ADDITION_AMT3
, AERLA.NUM_FREE_BREAKFASTS1
, AERLA.NUM_FREE_LUNCHES1
, AERLA.NUM_FREE_DINNERS1
, AERLA.NUM_FREE_ACCOMMODATIONS1
, AERLA.NUM_FREE_BREAKFASTS2
, AERLA.NUM_FREE_LUNCHES2
, AERLA.NUM_FREE_DINNERS2
, AERLA.NUM_FREE_ACCOMMODATIONS2
, AERLA.NUM_FREE_BREAKFASTS3
, AERLA.NUM_FREE_LUNCHES3
, AERLA.NUM_FREE_DINNERS3
, AERLA.NUM_FREE_ACCOMMODATIONS3
, AERLA.ATTENDEES
, AERLA.NUMBER_ATTENDEES
, AERLA.TRAVEL_TYPE
, AERLA.TICKET_CLASS_CODE
, AERLA.TICKET_NUMBER
, AERLA.FLIGHT_NUMBER
, AERLA.LOCATION_TO_ID
, AERLA.ITEMIZATION_PARENT_ID
, AERLA.FUNC_CURRENCY_AMT
, AERLA.LOCATION
, AERLA.CATEGORY_CODE
, AERLA.ADJUSTMENT_REASON_CODE
, AERLA.AP_VALIDATION_ERROR
, AERLA.SUBMITTED_AMOUNT
, AERLA.REPORT_LINE_ID
, AERLA.ALLOCATION_REASON
FROM AP_EXPENSE_REPORT_LINES_ALL AERLA
WHERE '_SEC:AERLA.ORG_ID' IS NOT NULL WITH READ ONLY
Columns
| REPORT_HEADER_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| ITEM_DESCRIPTION |
| SET_OF_BOOKS_ID |
| AMOUNT |
| _DF |
| CURRENCY_CODE |
| EXCHANGE_RATE_TYPE |
| EXCHANGE_RATE |
| EXCHANGE_DATE |
| VAT_CODE |
| LINE_TYPE_LOOKUP_CODE |
| CREATION_DATE |
| CREATED_BY |
| STAT_AMOUNT |
| USSGL_TRANSACTION_CODE |
| USSGL_TRX_CODE_CONTEXT |
| 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 |
| AMOUNT_INCLUDES_TAX_FLAG |
| ADJUSTMENT_REASON |
| POLICY_SHORTPAY_FLAG |
| CREDIT_CARD_TRX_ID |
| MERCHANT_DOCUMENT_NUMBER |
| MERCHANT_NAME |
| MERCHANT_REFERENCE |
| MERCHANT_TAX_REG_NUMBER |
| MERCHANT_TAXPAYER_ID |
| COUNTRY_OF_SUPPLY |
| TAX_CODE_OVERRIDE_FLAG |
| TAX_CODE_ID |
| ITEMIZE_ID |
| COMPANY_PREPAID_INVOICE_ID |
| 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 |
| FUNC_CURRENCY_AMT |
| LOCATION |
| CATEGORY_CODE |
| ADJUSTMENT_REASON_CODE |
| AP_VALIDATION_ERROR |
| SUBMITTED_AMOUNT |
| REPORT_LINE_ID |
| ALLOCATION_REASON |
| Name |
APPS.APBV_EXPENSE_REPORT_LINES