VIEW: FA.FA_ADDITION_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, SOURCE SOURCE, COMPANY COMPANY, COST_CENTER COST_CENTER, EXPENSE_ACCT EXPENSE_ACCT, ASSET_TYPE ASSET_TYPE, ASSET_NUMBER ASSET_NUMBER, DESCRIPTION DESCRIPTION, VENDOR_NUMBER VENDOR_NUMBER, INVOICE_NUMBER INVOICE_NUMBER, SERIAL_NUMBER SERIAL_NUMBER, TAG_NUMBER TAG_NUMBER, ASSET_KEY ASSET_KEY, PERIOD_NAME PERIOD_NAME, LINE_NUMBER LINE_NUMBER, INVOICE_DESCR INVOICE_DESCR, INVOICE_ORIG_COST INVOICE_ORIG_COST, INVOICE_COST INVOICE_COST, COST_TO_CLEAR COST_TO_CLEAR, INVOICE_FLAG INVOICE_FLAG, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, METHOD METHOD, LIFE_YEAR_MONTH LIFE_YEAR_MONTH, PROD_CAPACITY PROD_CAPACITY, ADJUSTED_RATE ADJUSTED_RATE, RESERVE_ACCT RESERVE_ACCT, COST_ACCT COST_ACCT, CATEGORY CATEGORY, LOCATION LOCATION, EMPLOYEE_NAME EMPLOYEE_NAME, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, RESERVE RESERVE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, INVENTORIAL INVENTORIAL, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE, ORGANIZATION_NAME ORGANIZATION_NAME, BOOK_TYPE_CODE BOOK_TYPE_CODE, PERIOD_NAME_TO PERIOD_NAME_TO, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION, COST_CENTER_DESCRIPTION COST_CENTER_DESCRIPTION, YTD_DEPRECIATION YTD_DEPRECIATION, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, MAJOR_CATEGORY MAJOR_CATEGORY, MAJOR_CATEGORY_DESC MAJOR_CATEGORY_DESC, MINOR_CATEGORY MINOR_CATEGORY, MINOR_CATEGORY_DESC MINOR_CATEGORY_DESC, SPECIFIED_CATEGORY_SEG SPECIFIED_CATEGORY_SEG, SPECIFIED_CAT_SEG_DESC SPECIFIED_CAT_SEG_DESC, GROUP_ASSET_NUMBER GROUP_ASSET_NUMBER, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER from "FA"."FA_ADDITION_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, SOURCE SOURCE
, COMPANY COMPANY
, COST_CENTER COST_CENTER
, EXPENSE_ACCT EXPENSE_ACCT
, ASSET_TYPE ASSET_TYPE
, ASSET_NUMBER ASSET_NUMBER
, DESCRIPTION DESCRIPTION
, VENDOR_NUMBER VENDOR_NUMBER
, INVOICE_NUMBER INVOICE_NUMBER
, SERIAL_NUMBER SERIAL_NUMBER
, TAG_NUMBER TAG_NUMBER
, ASSET_KEY ASSET_KEY
, PERIOD_NAME PERIOD_NAME
, LINE_NUMBER LINE_NUMBER
, INVOICE_DESCR INVOICE_DESCR
, INVOICE_ORIG_COST INVOICE_ORIG_COST
, INVOICE_COST INVOICE_COST
, COST_TO_CLEAR COST_TO_CLEAR
, INVOICE_FLAG INVOICE_FLAG
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, METHOD METHOD
, LIFE_YEAR_MONTH LIFE_YEAR_MONTH
, PROD_CAPACITY PROD_CAPACITY
, ADJUSTED_RATE ADJUSTED_RATE
, RESERVE_ACCT RESERVE_ACCT
, COST_ACCT COST_ACCT
, CATEGORY CATEGORY
, LOCATION LOCATION
, EMPLOYEE_NAME EMPLOYEE_NAME
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, RESERVE RESERVE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, INVENTORIAL INVENTORIAL
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, FUNCTIONAL_CURRENCY_CODE FUNCTIONAL_CURRENCY_CODE
, ORGANIZATION_NAME ORGANIZATION_NAME
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, PERIOD_NAME_TO PERIOD_NAME_TO
, ACCOUNT_DESCRIPTION ACCOUNT_DESCRIPTION
, COST_CENTER_DESCRIPTION COST_CENTER_DESCRIPTION
, YTD_DEPRECIATION YTD_DEPRECIATION
, TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, MAJOR_CATEGORY MAJOR_CATEGORY
, MAJOR_CATEGORY_DESC MAJOR_CATEGORY_DESC
, MINOR_CATEGORY MINOR_CATEGORY
, MINOR_CATEGORY_DESC MINOR_CATEGORY_DESC
, SPECIFIED_CATEGORY_SEG SPECIFIED_CATEGORY_SEG
, SPECIFIED_CAT_SEG_DESC SPECIFIED_CAT_SEG_DESC
, GROUP_ASSET_NUMBER GROUP_ASSET_NUMBER
, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
FROM "FA"."FA_ADDITION_REP_ITF"