VIEW: AP.AP_EXPENSE_REPORT_LINES_ALL#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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