VIEW: AR.AR_SALES_TAX_REP_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, SOB_NAME SOB_NAME, BASE_CURRENCY BASE_CURRENCY, INVOICE_NUMBER INVOICE_NUMBER, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE, TRANSACTION_TYPE TRANSACTION_TYPE, CLASS CLASS, SIC_CODE SIC_CODE, FOB_POINT FOB_POINT, SHIP_DATE_ACTUAL SHIP_DATE_ACTUAL, WAYBILL_NUMBER WAYBILL_NUMBER, POSTING_STATUS POSTING_STATUS, SHIP_TO_STATE SHIP_TO_STATE, SHIP_TO_COUNTY SHIP_TO_COUNTY, SHIP_TO_CITY SHIP_TO_CITY, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME, SHIP_TO_CUSTOMER_NUMBER SHIP_TO_CUSTOMER_NUMBER, SHIP_TO_CUSTOMER_TYPE SHIP_TO_CUSTOMER_TYPE, SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS1, SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS2, SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS3, SHIP_TO_ADDRESS4 SHIP_TO_ADDRESS4, SHIP_TO_PROVINCE SHIP_TO_PROVINCE, BILL_TO_STATE BILL_TO_STATE, BILL_TO_COUNTY BILL_TO_COUNTY, BILL_TO_CITY BILL_TO_CITY, BILL_TO_POSTAL_CODE BILL_TO_POSTAL_CODE, BILL_TO_CUSTOMER_NAME BILL_TO_CUSTOMER_NAME, BILL_TO_CUSTOMER_NUMBER BILL_TO_CUSTOMER_NUMBER, BILL_TO_CUSTOMER_TYPE BILL_TO_CUSTOMER_TYPE, BILL_TO_ADDRESS1 BILL_TO_ADDRESS1, BILL_TO_ADDRESS2 BILL_TO_ADDRESS2, BILL_TO_ADDRESS3 BILL_TO_ADDRESS3, BILL_TO_ADDRESS4 BILL_TO_ADDRESS4, BILL_TO_PROVINCE BILL_TO_PROVINCE, SOLD_TO_STATE SOLD_TO_STATE, SOLD_TO_COUNTY SOLD_TO_COUNTY, SOLD_TO_CITY SOLD_TO_CITY, SOLD_TO_POSTAL_CODE SOLD_TO_POSTAL_CODE, SOLD_TO_CUSTOMER_NAME SOLD_TO_CUSTOMER_NAME, SOLD_TO_CUSTOMER_NUMBER SOLD_TO_CUSTOMER_NUMBER, SOLD_TO_CUSTOMER_TYPE SOLD_TO_CUSTOMER_TYPE, SOLD_TO_ADDRESS1 SOLD_TO_ADDRESS1, SOLD_TO_ADDRESS2 SOLD_TO_ADDRESS2, SOLD_TO_ADDRESS3 SOLD_TO_ADDRESS3, SOLD_TO_ADDRESS4 SOLD_TO_ADDRESS4, SOLD_TO_PROVINCE SOLD_TO_PROVINCE, PURCHASE_ORDER PURCHASE_ORDER, PURCHASE_ORDER_REVISION PURCHASE_ORDER_REVISION, SALES_ORDER SALES_ORDER, SALES_ORDER_SOURCE SALES_ORDER_SOURCE, SALES_ORDER_REVISION SALES_ORDER_REVISION, SALES_ORDER_DATE SALES_ORDER_DATE, HEADER_CATEGORY HEADER_CATEGORY, HEADER_ATTRIBUTE1 HEADER_ATTRIBUTE1, HEADER_ATTRIBUTE2 HEADER_ATTRIBUTE2, HEADER_ATTRIBUTE3 HEADER_ATTRIBUTE3, HEADER_ATTRIBUTE4 HEADER_ATTRIBUTE4, HEADER_ATTRIBUTE5 HEADER_ATTRIBUTE5, HEADER_ATTRIBUTE6 HEADER_ATTRIBUTE6, HEADER_ATTRIBUTE7 HEADER_ATTRIBUTE7, HEADER_ATTRIBUTE8 HEADER_ATTRIBUTE8, HEADER_ATTRIBUTE9 HEADER_ATTRIBUTE9, HEADER_ATTRIBUTE10 HEADER_ATTRIBUTE10, HEADER_ATTRIBUTE11 HEADER_ATTRIBUTE11, HEADER_ATTRIBUTE12 HEADER_ATTRIBUTE12, HEADER_ATTRIBUTE13 HEADER_ATTRIBUTE13, HEADER_ATTRIBUTE14 HEADER_ATTRIBUTE14, HEADER_ATTRIBUTE15 HEADER_ATTRIBUTE15, LINE_NUMBER LINE_NUMBER, ADJUSTMENT_NUMBER ADJUSTMENT_NUMBER, INV_OR_ADJ_DATE INV_OR_ADJ_DATE, INVENTORY_ITEM INVENTORY_ITEM, DESCRIPTION DESCRIPTION, ITEM_DESCRIPTION ITEM_DESCRIPTION, LINE_AMOUNT LINE_AMOUNT, EXEMPT_AMOUNT EXEMPT_AMOUNT, TAXABLE_AMOUNT TAXABLE_AMOUNT, TAX_REFERENCE TAX_REFERENCE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, SHIP_VIA SHIP_VIA, UOM UOM, QUANTITY_INVOICED QUANTITY_INVOICED, UNIT_SELLING_PRICE UNIT_SELLING_PRICE, SALES_ORDER_LINE SALES_ORDER_LINE, LINE_CATEGORY LINE_CATEGORY, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15, TAX_LINE_NUMBER TAX_LINE_NUMBER, TAX_RATE TAX_RATE, TAX_CODE TAX_CODE, TAX_PRECEDENCE TAX_PRECEDENCE, TAX_AMOUNT TAX_AMOUNT, EXEMPT_NUMBER EXEMPT_NUMBER, EXEMPT_REASON EXEMPT_REASON, TOTAL_LINES_AMOUNT TOTAL_LINES_AMOUNT, TOTAL_TAX_AMOUNT TOTAL_TAX_AMOUNT, FOOTNOTE FOOTNOTE from "AR"."AR_SALES_TAX_REP_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, SOB_NAME SOB_NAME
, BASE_CURRENCY BASE_CURRENCY
, INVOICE_NUMBER INVOICE_NUMBER
, INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, TRANSACTION_TYPE TRANSACTION_TYPE
, CLASS CLASS
, SIC_CODE SIC_CODE
, FOB_POINT FOB_POINT
, SHIP_DATE_ACTUAL SHIP_DATE_ACTUAL
, WAYBILL_NUMBER WAYBILL_NUMBER
, POSTING_STATUS POSTING_STATUS
, SHIP_TO_STATE SHIP_TO_STATE
, SHIP_TO_COUNTY SHIP_TO_COUNTY
, SHIP_TO_CITY SHIP_TO_CITY
, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE
, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME
, SHIP_TO_CUSTOMER_NUMBER SHIP_TO_CUSTOMER_NUMBER
, SHIP_TO_CUSTOMER_TYPE SHIP_TO_CUSTOMER_TYPE
, SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4 SHIP_TO_ADDRESS4
, SHIP_TO_PROVINCE SHIP_TO_PROVINCE
, BILL_TO_STATE BILL_TO_STATE
, BILL_TO_COUNTY BILL_TO_COUNTY
, BILL_TO_CITY BILL_TO_CITY
, BILL_TO_POSTAL_CODE BILL_TO_POSTAL_CODE
, BILL_TO_CUSTOMER_NAME BILL_TO_CUSTOMER_NAME
, BILL_TO_CUSTOMER_NUMBER BILL_TO_CUSTOMER_NUMBER
, BILL_TO_CUSTOMER_TYPE BILL_TO_CUSTOMER_TYPE
, BILL_TO_ADDRESS1 BILL_TO_ADDRESS1
, BILL_TO_ADDRESS2 BILL_TO_ADDRESS2
, BILL_TO_ADDRESS3 BILL_TO_ADDRESS3
, BILL_TO_ADDRESS4 BILL_TO_ADDRESS4
, BILL_TO_PROVINCE BILL_TO_PROVINCE
, SOLD_TO_STATE SOLD_TO_STATE
, SOLD_TO_COUNTY SOLD_TO_COUNTY
, SOLD_TO_CITY SOLD_TO_CITY
, SOLD_TO_POSTAL_CODE SOLD_TO_POSTAL_CODE
, SOLD_TO_CUSTOMER_NAME SOLD_TO_CUSTOMER_NAME
, SOLD_TO_CUSTOMER_NUMBER SOLD_TO_CUSTOMER_NUMBER
, SOLD_TO_CUSTOMER_TYPE SOLD_TO_CUSTOMER_TYPE
, SOLD_TO_ADDRESS1 SOLD_TO_ADDRESS1
, SOLD_TO_ADDRESS2 SOLD_TO_ADDRESS2
, SOLD_TO_ADDRESS3 SOLD_TO_ADDRESS3
, SOLD_TO_ADDRESS4 SOLD_TO_ADDRESS4
, SOLD_TO_PROVINCE SOLD_TO_PROVINCE
, PURCHASE_ORDER PURCHASE_ORDER
, PURCHASE_ORDER_REVISION PURCHASE_ORDER_REVISION
, SALES_ORDER SALES_ORDER
, SALES_ORDER_SOURCE SALES_ORDER_SOURCE
, SALES_ORDER_REVISION SALES_ORDER_REVISION
, SALES_ORDER_DATE SALES_ORDER_DATE
, HEADER_CATEGORY HEADER_CATEGORY
, HEADER_ATTRIBUTE1 HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE2 HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3 HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4 HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5 HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6 HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7 HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8 HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9 HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE10 HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11 HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12 HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13 HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14 HEADER_ATTRIBUTE14
, HEADER_ATTRIBUTE15 HEADER_ATTRIBUTE15
, LINE_NUMBER LINE_NUMBER
, ADJUSTMENT_NUMBER ADJUSTMENT_NUMBER
, INV_OR_ADJ_DATE INV_OR_ADJ_DATE
, INVENTORY_ITEM INVENTORY_ITEM
, DESCRIPTION DESCRIPTION
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, LINE_AMOUNT LINE_AMOUNT
, EXEMPT_AMOUNT EXEMPT_AMOUNT
, TAXABLE_AMOUNT TAXABLE_AMOUNT
, TAX_REFERENCE TAX_REFERENCE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, SHIP_VIA SHIP_VIA
, UOM UOM
, QUANTITY_INVOICED QUANTITY_INVOICED
, UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, SALES_ORDER_LINE SALES_ORDER_LINE
, LINE_CATEGORY LINE_CATEGORY
, LINE_ATTRIBUTE1 LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2 LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3 LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4 LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5 LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6 LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7 LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8 LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9 LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10 LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11 LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12 LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13 LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14 LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15 LINE_ATTRIBUTE15
, TAX_LINE_NUMBER TAX_LINE_NUMBER
, TAX_RATE TAX_RATE
, TAX_CODE TAX_CODE
, TAX_PRECEDENCE TAX_PRECEDENCE
, TAX_AMOUNT TAX_AMOUNT
, EXEMPT_NUMBER EXEMPT_NUMBER
, EXEMPT_REASON EXEMPT_REASON
, TOTAL_LINES_AMOUNT TOTAL_LINES_AMOUNT
, TOTAL_TAX_AMOUNT TOTAL_TAX_AMOUNT
, FOOTNOTE FOOTNOTE
FROM "AR"."AR_SALES_TAX_REP_ITF"