VIEW: AP.AP_EXPENSE_FEED_LINES_ALL#

Source

View Text - Preformatted

select EMPLOYEE_ID EMPLOYEE_ID, CARD_ID CARD_ID, CARD_PROGRAM_ID CARD_PROGRAM_ID, CARD_NUMBER CARD_NUMBER, FEED_LINE_ID FEED_LINE_ID, REFERENCE_NUMBER REFERENCE_NUMBER, ALT_REFERENCE_NUMBER ALT_REFERENCE_NUMBER, CUSTOMER_CODE CUSTOMER_CODE, AMOUNT AMOUNT, ORIGINAL_CURRENCY_AMOUNT ORIGINAL_CURRENCY_AMOUNT, ORIGINAL_CURRENCY_CODE ORIGINAL_CURRENCY_CODE, POSTED_CURRENCY_CODE POSTED_CURRENCY_CODE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, TRANSACTION_DATE TRANSACTION_DATE, POSTED_DATE POSTED_DATE, RECORD_TYPE RECORD_TYPE, CREATE_DISTRIBUTION_FLAG CREATE_DISTRIBUTION_FLAG, MERCHANT_NAME MERCHANT_NAME, MERCHANT_NUMBER MERCHANT_NUMBER, CARD_CODE_VALUE CARD_CODE_VALUE, CODE_ID CODE_ID, INDUSTRY_CODE1 INDUSTRY_CODE1, INDUSTRY_CODE2 INDUSTRY_CODE2, ALT_MERCHANT_NUMBER ALT_MERCHANT_NUMBER, MERCHANT_ADDRESS1 MERCHANT_ADDRESS1, MERCHANT_ADDRESS2 MERCHANT_ADDRESS2, MERCHANT_ADDRESS3 MERCHANT_ADDRESS3, MERCHANT_ADDRESS4 MERCHANT_ADDRESS4, MERCHANT_CITY MERCHANT_CITY, MERCHANT_PROVINCE_STATE MERCHANT_PROVINCE_STATE, MERCHANT_POSTAL_CODE MERCHANT_POSTAL_CODE, MERCHANT_COUNTRY MERCHANT_COUNTRY, MERCHANT_PHONE MERCHANT_PHONE, SHIP_FROM_POSTAL_CODE SHIP_FROM_POSTAL_CODE, SHIP_FROM_COUNTRY SHIP_FROM_COUNTRY, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE, SHIP_TO_COUNTRY SHIP_TO_COUNTRY, MERCHANT_TAX_ID MERCHANT_TAX_ID, TAX_PAID_FLAG TAX_PAID_FLAG, TAX_AMOUNT TAX_AMOUNT, TAX_RATE TAX_RATE, TAX_TYPE TAX_TYPE, ALT_MERCHANT_TAX_ID ALT_MERCHANT_TAX_ID, ALT_TAX_PAID_FLAG ALT_TAX_PAID_FLAG, ALT_TAX_AMOUNT ALT_TAX_AMOUNT, ALT_TAX_RATE ALT_TAX_RATE, ALT_TAX_TYPE ALT_TAX_TYPE, FREIGHT_AMOUNT FREIGHT_AMOUNT, DUTY_AMOUNT DUTY_AMOUNT, MERCHANT_BUSINESS_TYPE MERCHANT_BUSINESS_TYPE, MERCHANT_OWNER_TYPE MERCHANT_OWNER_TYPE, PRODUCT_CODE PRODUCT_CODE, ITEM_DESCRIPTION ITEM_DESCRIPTION, ITEM_QUANTITY ITEM_QUANTITY, ITEM_UOM ITEM_UOM, EXTENDED_ITEM_AMOUNT EXTENDED_ITEM_AMOUNT, DISCOUNT_INDICATOR DISCOUNT_INDICATOR, DISCOUNT_AMOUNT DISCOUNT_AMOUNT, EMPLOYEE_VERIFICATION_ID EMPLOYEE_VERIFICATION_ID, DESCRIPTION DESCRIPTION, REJECT_CODE REJECT_CODE, ORG_ID ORG_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, 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, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30 from "AP"."AP_EXPENSE_FEED_LINES_ALL"

View Text - HTML Formatted

SELECT EMPLOYEE_ID EMPLOYEE_ID
, CARD_ID CARD_ID
, CARD_PROGRAM_ID CARD_PROGRAM_ID
, CARD_NUMBER CARD_NUMBER
, FEED_LINE_ID FEED_LINE_ID
, REFERENCE_NUMBER REFERENCE_NUMBER
, ALT_REFERENCE_NUMBER ALT_REFERENCE_NUMBER
, CUSTOMER_CODE CUSTOMER_CODE
, AMOUNT AMOUNT
, ORIGINAL_CURRENCY_AMOUNT ORIGINAL_CURRENCY_AMOUNT
, ORIGINAL_CURRENCY_CODE ORIGINAL_CURRENCY_CODE
, POSTED_CURRENCY_CODE POSTED_CURRENCY_CODE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, TRANSACTION_DATE TRANSACTION_DATE
, POSTED_DATE POSTED_DATE
, RECORD_TYPE RECORD_TYPE
, CREATE_DISTRIBUTION_FLAG CREATE_DISTRIBUTION_FLAG
, MERCHANT_NAME MERCHANT_NAME
, MERCHANT_NUMBER MERCHANT_NUMBER
, CARD_CODE_VALUE CARD_CODE_VALUE
, CODE_ID CODE_ID
, INDUSTRY_CODE1 INDUSTRY_CODE1
, INDUSTRY_CODE2 INDUSTRY_CODE2
, ALT_MERCHANT_NUMBER ALT_MERCHANT_NUMBER
, MERCHANT_ADDRESS1 MERCHANT_ADDRESS1
, MERCHANT_ADDRESS2 MERCHANT_ADDRESS2
, MERCHANT_ADDRESS3 MERCHANT_ADDRESS3
, MERCHANT_ADDRESS4 MERCHANT_ADDRESS4
, MERCHANT_CITY MERCHANT_CITY
, MERCHANT_PROVINCE_STATE MERCHANT_PROVINCE_STATE
, MERCHANT_POSTAL_CODE MERCHANT_POSTAL_CODE
, MERCHANT_COUNTRY MERCHANT_COUNTRY
, MERCHANT_PHONE MERCHANT_PHONE
, SHIP_FROM_POSTAL_CODE SHIP_FROM_POSTAL_CODE
, SHIP_FROM_COUNTRY SHIP_FROM_COUNTRY
, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE
, SHIP_TO_COUNTRY SHIP_TO_COUNTRY
, MERCHANT_TAX_ID MERCHANT_TAX_ID
, TAX_PAID_FLAG TAX_PAID_FLAG
, TAX_AMOUNT TAX_AMOUNT
, TAX_RATE TAX_RATE
, TAX_TYPE TAX_TYPE
, ALT_MERCHANT_TAX_ID ALT_MERCHANT_TAX_ID
, ALT_TAX_PAID_FLAG ALT_TAX_PAID_FLAG
, ALT_TAX_AMOUNT ALT_TAX_AMOUNT
, ALT_TAX_RATE ALT_TAX_RATE
, ALT_TAX_TYPE ALT_TAX_TYPE
, FREIGHT_AMOUNT FREIGHT_AMOUNT
, DUTY_AMOUNT DUTY_AMOUNT
, MERCHANT_BUSINESS_TYPE MERCHANT_BUSINESS_TYPE
, MERCHANT_OWNER_TYPE MERCHANT_OWNER_TYPE
, PRODUCT_CODE PRODUCT_CODE
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, ITEM_QUANTITY ITEM_QUANTITY
, ITEM_UOM ITEM_UOM
, EXTENDED_ITEM_AMOUNT EXTENDED_ITEM_AMOUNT
, DISCOUNT_INDICATOR DISCOUNT_INDICATOR
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, EMPLOYEE_VERIFICATION_ID EMPLOYEE_VERIFICATION_ID
, DESCRIPTION DESCRIPTION
, REJECT_CODE REJECT_CODE
, ORG_ID ORG_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, 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
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
FROM "AP"."AP_EXPENSE_FEED_LINES_ALL"