VIEW: AP.AP_INVOICE_LINES_INTERFACE#

Source

View Text - Preformatted

select INVOICE_ID INVOICE_ID, INVOICE_LINE_ID INVOICE_LINE_ID, LINE_NUMBER LINE_NUMBER, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE, LINE_GROUP_NUMBER LINE_GROUP_NUMBER, AMOUNT AMOUNT, ACCOUNTING_DATE ACCOUNTING_DATE, DESCRIPTION DESCRIPTION, AMOUNT_INCLUDES_TAX_FLAG AMOUNT_INCLUDES_TAX_FLAG, PRORATE_ACROSS_FLAG PRORATE_ACROSS_FLAG, TAX_CODE TAX_CODE, FINAL_MATCH_FLAG FINAL_MATCH_FLAG, PO_HEADER_ID PO_HEADER_ID, PO_NUMBER PO_NUMBER, PO_LINE_ID PO_LINE_ID, PO_LINE_NUMBER PO_LINE_NUMBER, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, PO_SHIPMENT_NUM PO_SHIPMENT_NUM, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, PO_DISTRIBUTION_NUM PO_DISTRIBUTION_NUM, PO_UNIT_OF_MEASURE PO_UNIT_OF_MEASURE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_DESCRIPTION ITEM_DESCRIPTION, QUANTITY_INVOICED QUANTITY_INVOICED, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE, UNIT_PRICE UNIT_PRICE, DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID, DISTRIBUTION_SET_NAME DISTRIBUTION_SET_NAME, DIST_CODE_CONCATENATED DIST_CODE_CONCATENATED, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID, AWT_GROUP_ID AWT_GROUP_ID, AWT_GROUP_NAME AWT_GROUP_NAME, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, 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, 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, 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, PO_RELEASE_ID PO_RELEASE_ID, RELEASE_NUM RELEASE_NUM, ACCOUNT_SEGMENT ACCOUNT_SEGMENT, BALANCING_SEGMENT BALANCING_SEGMENT, COST_CENTER_SEGMENT COST_CENTER_SEGMENT, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT, PA_ADDITION_FLAG PA_ADDITION_FLAG, PA_QUANTITY PA_QUANTITY, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, STAT_AMOUNT STAT_AMOUNT, TYPE_1099 TYPE_1099, INCOME_TAX_REGION INCOME_TAX_REGION, ASSETS_TRACKING_FLAG ASSETS_TRACKING_FLAG, PRICE_CORRECTION_FLAG PRICE_CORRECTION_FLAG, ORG_ID ORG_ID, RECEIPT_NUMBER RECEIPT_NUMBER, RECEIPT_LINE_NUMBER RECEIPT_LINE_NUMBER, MATCH_OPTION MATCH_OPTION, PACKING_SLIP PACKING_SLIP, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, PA_CC_AR_INVOICE_ID PA_CC_AR_INVOICE_ID, PA_CC_AR_INVOICE_LINE_NUM PA_CC_AR_INVOICE_LINE_NUM, REFERENCE_1 REFERENCE_1, REFERENCE_2 REFERENCE_2, PA_CC_PROCESSED_CODE PA_CC_PROCESSED_CODE, TAX_RECOVERY_RATE TAX_RECOVERY_RATE, TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG, TAX_RECOVERABLE_FLAG TAX_RECOVERABLE_FLAG, TAX_CODE_OVERRIDE_FLAG TAX_CODE_OVERRIDE_FLAG, TAX_CODE_ID TAX_CODE_ID, CREDIT_CARD_TRX_ID CREDIT_CARD_TRX_ID, AWARD_ID AWARD_ID, VENDOR_ITEM_NUM VENDOR_ITEM_NUM, TAXABLE_FLAG TAXABLE_FLAG, PRICE_CORRECT_INV_NUM PRICE_CORRECT_INV_NUM, EXTERNAL_DOC_LINE_REF EXTERNAL_DOC_LINE_REF, SERIAL_NUMBER SERIAL_NUMBER, MANUFACTURER MANUFACTURER, MODEL_NUMBER MODEL_NUMBER, WARRANTY_NUMBER WARRANTY_NUMBER, DEFERRED_ACCTG_FLAG DEFERRED_ACCTG_FLAG, DEF_ACCTG_START_DATE DEF_ACCTG_START_DATE, DEF_ACCTG_END_DATE DEF_ACCTG_END_DATE, DEF_ACCTG_NUMBER_OF_PERIODS DEF_ACCTG_NUMBER_OF_PERIODS, DEF_ACCTG_PERIOD_TYPE DEF_ACCTG_PERIOD_TYPE, UNIT_OF_MEAS_LOOKUP_CODE UNIT_OF_MEAS_LOOKUP_CODE, PRICE_CORRECT_INV_LINE_NUM PRICE_CORRECT_INV_LINE_NUM, ASSET_BOOK_TYPE_CODE ASSET_BOOK_TYPE_CODE, ASSET_CATEGORY_ID ASSET_CATEGORY_ID, REQUESTER_ID REQUESTER_ID, REQUESTER_FIRST_NAME REQUESTER_FIRST_NAME, REQUESTER_LAST_NAME REQUESTER_LAST_NAME, REQUESTER_EMPLOYEE_NUM REQUESTER_EMPLOYEE_NUM, APPLICATION_ID APPLICATION_ID, PRODUCT_TABLE PRODUCT_TABLE, REFERENCE_KEY1 REFERENCE_KEY1, REFERENCE_KEY2 REFERENCE_KEY2, REFERENCE_KEY3 REFERENCE_KEY3, REFERENCE_KEY4 REFERENCE_KEY4, REFERENCE_KEY5 REFERENCE_KEY5, PURCHASING_CATEGORY PURCHASING_CATEGORY, PURCHASING_CATEGORY_ID PURCHASING_CATEGORY_ID, COST_FACTOR_ID COST_FACTOR_ID, COST_FACTOR_NAME COST_FACTOR_NAME, CONTROL_AMOUNT CONTROL_AMOUNT, ASSESSABLE_VALUE ASSESSABLE_VALUE, DEFAULT_DIST_CCID DEFAULT_DIST_CCID, PRIMARY_INTENDED_USE PRIMARY_INTENDED_USE, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, PRODUCT_TYPE PRODUCT_TYPE, PRODUCT_CATEGORY PRODUCT_CATEGORY, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY, TAX_REGIME_CODE TAX_REGIME_CODE, TAX TAX, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE, TAX_STATUS_CODE TAX_STATUS_CODE, TAX_RATE_ID TAX_RATE_ID, TAX_RATE_CODE TAX_RATE_CODE, TAX_RATE TAX_RATE, INCL_IN_TAXABLE_LINE_FLAG INCL_IN_TAXABLE_LINE_FLAG, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID, SOURCE_ENTITY_CODE SOURCE_ENTITY_CODE, SOURCE_EVENT_CLASS_CODE SOURCE_EVENT_CLASS_CODE, SOURCE_TRX_ID SOURCE_TRX_ID, SOURCE_LINE_ID SOURCE_LINE_ID, SOURCE_TRX_LEVEL_TYPE SOURCE_TRX_LEVEL_TYPE, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE, CC_REVERSAL_FLAG CC_REVERSAL_FLAG, COMPANY_PREPAID_INVOICE_ID COMPANY_PREPAID_INVOICE_ID, EXPENSE_GROUP EXPENSE_GROUP, JUSTIFICATION JUSTIFICATION, 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, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE, RECEIPT_CONVERSION_RATE RECEIPT_CONVERSION_RATE, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT, COUNTRY_OF_SUPPLY COUNTRY_OF_SUPPLY, PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID, PAY_AWT_GROUP_NAME PAY_AWT_GROUP_NAME, EXPENSE_START_DATE EXPENSE_START_DATE, EXPENSE_END_DATE EXPENSE_END_DATE from "AP"."AP_INVOICE_LINES_INTERFACE"

View Text - HTML Formatted

SELECT INVOICE_ID INVOICE_ID
, INVOICE_LINE_ID INVOICE_LINE_ID
, LINE_NUMBER LINE_NUMBER
, LINE_TYPE_LOOKUP_CODE LINE_TYPE_LOOKUP_CODE
, LINE_GROUP_NUMBER LINE_GROUP_NUMBER
, AMOUNT AMOUNT
, ACCOUNTING_DATE ACCOUNTING_DATE
, DESCRIPTION DESCRIPTION
, AMOUNT_INCLUDES_TAX_FLAG AMOUNT_INCLUDES_TAX_FLAG
, PRORATE_ACROSS_FLAG PRORATE_ACROSS_FLAG
, TAX_CODE TAX_CODE
, FINAL_MATCH_FLAG FINAL_MATCH_FLAG
, PO_HEADER_ID PO_HEADER_ID
, PO_NUMBER PO_NUMBER
, PO_LINE_ID PO_LINE_ID
, PO_LINE_NUMBER PO_LINE_NUMBER
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, PO_SHIPMENT_NUM PO_SHIPMENT_NUM
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, PO_DISTRIBUTION_NUM PO_DISTRIBUTION_NUM
, PO_UNIT_OF_MEASURE PO_UNIT_OF_MEASURE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, QUANTITY_INVOICED QUANTITY_INVOICED
, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE
, UNIT_PRICE UNIT_PRICE
, DISTRIBUTION_SET_ID DISTRIBUTION_SET_ID
, DISTRIBUTION_SET_NAME DISTRIBUTION_SET_NAME
, DIST_CODE_CONCATENATED DIST_CODE_CONCATENATED
, DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID
, AWT_GROUP_ID AWT_GROUP_ID
, AWT_GROUP_NAME AWT_GROUP_NAME
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, 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
, 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
, 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
, PO_RELEASE_ID PO_RELEASE_ID
, RELEASE_NUM RELEASE_NUM
, ACCOUNT_SEGMENT ACCOUNT_SEGMENT
, BALANCING_SEGMENT BALANCING_SEGMENT
, COST_CENTER_SEGMENT COST_CENTER_SEGMENT
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT
, PA_ADDITION_FLAG PA_ADDITION_FLAG
, PA_QUANTITY PA_QUANTITY
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, STAT_AMOUNT STAT_AMOUNT
, TYPE_1099 TYPE_1099
, INCOME_TAX_REGION INCOME_TAX_REGION
, ASSETS_TRACKING_FLAG ASSETS_TRACKING_FLAG
, PRICE_CORRECTION_FLAG PRICE_CORRECTION_FLAG
, ORG_ID ORG_ID
, RECEIPT_NUMBER RECEIPT_NUMBER
, RECEIPT_LINE_NUMBER RECEIPT_LINE_NUMBER
, MATCH_OPTION MATCH_OPTION
, PACKING_SLIP PACKING_SLIP
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, PA_CC_AR_INVOICE_ID PA_CC_AR_INVOICE_ID
, PA_CC_AR_INVOICE_LINE_NUM PA_CC_AR_INVOICE_LINE_NUM
, REFERENCE_1 REFERENCE_1
, REFERENCE_2 REFERENCE_2
, PA_CC_PROCESSED_CODE PA_CC_PROCESSED_CODE
, TAX_RECOVERY_RATE TAX_RECOVERY_RATE
, TAX_RECOVERY_OVERRIDE_FLAG TAX_RECOVERY_OVERRIDE_FLAG
, TAX_RECOVERABLE_FLAG TAX_RECOVERABLE_FLAG
, TAX_CODE_OVERRIDE_FLAG TAX_CODE_OVERRIDE_FLAG
, TAX_CODE_ID TAX_CODE_ID
, CREDIT_CARD_TRX_ID CREDIT_CARD_TRX_ID
, AWARD_ID AWARD_ID
, VENDOR_ITEM_NUM VENDOR_ITEM_NUM
, TAXABLE_FLAG TAXABLE_FLAG
, PRICE_CORRECT_INV_NUM PRICE_CORRECT_INV_NUM
, EXTERNAL_DOC_LINE_REF EXTERNAL_DOC_LINE_REF
, SERIAL_NUMBER SERIAL_NUMBER
, MANUFACTURER MANUFACTURER
, MODEL_NUMBER MODEL_NUMBER
, WARRANTY_NUMBER WARRANTY_NUMBER
, DEFERRED_ACCTG_FLAG DEFERRED_ACCTG_FLAG
, DEF_ACCTG_START_DATE DEF_ACCTG_START_DATE
, DEF_ACCTG_END_DATE DEF_ACCTG_END_DATE
, DEF_ACCTG_NUMBER_OF_PERIODS DEF_ACCTG_NUMBER_OF_PERIODS
, DEF_ACCTG_PERIOD_TYPE DEF_ACCTG_PERIOD_TYPE
, UNIT_OF_MEAS_LOOKUP_CODE UNIT_OF_MEAS_LOOKUP_CODE
, PRICE_CORRECT_INV_LINE_NUM PRICE_CORRECT_INV_LINE_NUM
, ASSET_BOOK_TYPE_CODE ASSET_BOOK_TYPE_CODE
, ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, REQUESTER_ID REQUESTER_ID
, REQUESTER_FIRST_NAME REQUESTER_FIRST_NAME
, REQUESTER_LAST_NAME REQUESTER_LAST_NAME
, REQUESTER_EMPLOYEE_NUM REQUESTER_EMPLOYEE_NUM
, APPLICATION_ID APPLICATION_ID
, PRODUCT_TABLE PRODUCT_TABLE
, REFERENCE_KEY1 REFERENCE_KEY1
, REFERENCE_KEY2 REFERENCE_KEY2
, REFERENCE_KEY3 REFERENCE_KEY3
, REFERENCE_KEY4 REFERENCE_KEY4
, REFERENCE_KEY5 REFERENCE_KEY5
, PURCHASING_CATEGORY PURCHASING_CATEGORY
, PURCHASING_CATEGORY_ID PURCHASING_CATEGORY_ID
, COST_FACTOR_ID COST_FACTOR_ID
, COST_FACTOR_NAME COST_FACTOR_NAME
, CONTROL_AMOUNT CONTROL_AMOUNT
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, DEFAULT_DIST_CCID DEFAULT_DIST_CCID
, PRIMARY_INTENDED_USE PRIMARY_INTENDED_USE
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, PRODUCT_TYPE PRODUCT_TYPE
, PRODUCT_CATEGORY PRODUCT_CATEGORY
, PRODUCT_FISC_CLASSIFICATION PRODUCT_FISC_CLASSIFICATION
, USER_DEFINED_FISC_CLASS USER_DEFINED_FISC_CLASS
, TRX_BUSINESS_CATEGORY TRX_BUSINESS_CATEGORY
, TAX_REGIME_CODE TAX_REGIME_CODE
, TAX TAX
, TAX_JURISDICTION_CODE TAX_JURISDICTION_CODE
, TAX_STATUS_CODE TAX_STATUS_CODE
, TAX_RATE_ID TAX_RATE_ID
, TAX_RATE_CODE TAX_RATE_CODE
, TAX_RATE TAX_RATE
, INCL_IN_TAXABLE_LINE_FLAG INCL_IN_TAXABLE_LINE_FLAG
, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, SOURCE_ENTITY_CODE SOURCE_ENTITY_CODE
, SOURCE_EVENT_CLASS_CODE SOURCE_EVENT_CLASS_CODE
, SOURCE_TRX_ID SOURCE_TRX_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, SOURCE_TRX_LEVEL_TYPE SOURCE_TRX_LEVEL_TYPE
, TAX_CLASSIFICATION_CODE TAX_CLASSIFICATION_CODE
, CC_REVERSAL_FLAG CC_REVERSAL_FLAG
, COMPANY_PREPAID_INVOICE_ID COMPANY_PREPAID_INVOICE_ID
, EXPENSE_GROUP EXPENSE_GROUP
, JUSTIFICATION JUSTIFICATION
, 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
, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE
, RECEIPT_CONVERSION_RATE RECEIPT_CONVERSION_RATE
, RECEIPT_CURRENCY_AMOUNT RECEIPT_CURRENCY_AMOUNT
, COUNTRY_OF_SUPPLY COUNTRY_OF_SUPPLY
, PAY_AWT_GROUP_ID PAY_AWT_GROUP_ID
, PAY_AWT_GROUP_NAME PAY_AWT_GROUP_NAME
, EXPENSE_START_DATE EXPENSE_START_DATE
, EXPENSE_END_DATE EXPENSE_END_DATE
FROM "AP"."AP_INVOICE_LINES_INTERFACE"