eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.AR_SALES_TAX_REP_ITF

Object Details

Object Name:	AR_SALES_TAX_REP_ITF
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_SALES_TAX_REP_ITF
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_SALES_TAX_REP_ITF_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER		Yes	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
LAST_UPDATED_BY	NUMBER			Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
SOB_NAME	VARCHAR2	(30)		Set of Books name
BASE_CURRENCY	VARCHAR2	(15)		Base currency code
INVOICE_NUMBER	VARCHAR2	(20)		Invoice number
INVOICE_CURRENCY_CODE	VARCHAR2	(15)		Invoice currency code
TRANSACTION_TYPE	VARCHAR2	(20)		Transaction type
CLASS	VARCHAR2	(80)		Invoice class
SIC_CODE	VARCHAR2	(30)		SIC code
FOB_POINT	VARCHAR2	(30)		Freight on Board
SHIP_DATE_ACTUAL	DATE			Actual ship date
WAYBILL_NUMBER	VARCHAR2	(50)		Waybill number
POSTING_STATUS	VARCHAR2	(10)		Posting status
SHIP_TO_STATE	VARCHAR2	(60)		Ship-to state
SHIP_TO_COUNTY	VARCHAR2	(60)		Ship-to county
SHIP_TO_CITY	VARCHAR2	(60)		Ship-to city
SHIP_TO_POSTAL_CODE	VARCHAR2	(60)		Ship-to postal code
SHIP_TO_CUSTOMER_NAME	VARCHAR2	(50)		Ship-to customer name
SHIP_TO_CUSTOMER_NUMBER	VARCHAR2	(30)		Ship-to customer number
SHIP_TO_CUSTOMER_TYPE	VARCHAR2	(80)		Ship-to customer type
SHIP_TO_ADDRESS1	VARCHAR2	(240)		Ship-to address line
SHIP_TO_ADDRESS2	VARCHAR2	(240)		Ship-to address line 2
SHIP_TO_ADDRESS3	VARCHAR2	(240)		Ship-to address line 3
SHIP_TO_ADDRESS4	VARCHAR2	(240)		Ship-to address line 4
SHIP_TO_PROVINCE	VARCHAR2	(60)		Ship-to province
BILL_TO_STATE	VARCHAR2	(60)		Bill-to state
BILL_TO_COUNTY	VARCHAR2	(60)		Bill-to county
BILL_TO_CITY	VARCHAR2	(60)		Bill-to city
BILL_TO_POSTAL_CODE	VARCHAR2	(60)		Bill-to postal code
BILL_TO_CUSTOMER_NAME	VARCHAR2	(50)		Bill-to customer name
BILL_TO_CUSTOMER_NUMBER	VARCHAR2	(30)		Bill-to customer number
BILL_TO_CUSTOMER_TYPE	VARCHAR2	(80)		Bill-to customer type
BILL_TO_ADDRESS1	VARCHAR2	(240)		Bill-to address line 1
BILL_TO_ADDRESS2	VARCHAR2	(240)		Bill-to address line 2
BILL_TO_ADDRESS3	VARCHAR2	(240)		Bill-to address line 3
BILL_TO_ADDRESS4	VARCHAR2	(240)		Bill-to address line 4
BILL_TO_PROVINCE	VARCHAR2	(60)		Bill-to province
SOLD_TO_STATE	VARCHAR2	(60)		Sold-to state
SOLD_TO_COUNTY	VARCHAR2	(60)		Sold-to county
SOLD_TO_CITY	VARCHAR2	(60)		Sold-to city
SOLD_TO_POSTAL_CODE	VARCHAR2	(60)		Sold-to postal code
SOLD_TO_CUSTOMER_NAME	VARCHAR2	(50)		Sold-to customer name
SOLD_TO_CUSTOMER_NUMBER	VARCHAR2	(30)		Sold-to customer number
SOLD_TO_CUSTOMER_TYPE	VARCHAR2	(80)		Sold-to customer type
SOLD_TO_ADDRESS1	VARCHAR2	(240)		Sold-to address line 1
SOLD_TO_ADDRESS2	VARCHAR2	(240)		Sold-to address line 2
SOLD_TO_ADDRESS3	VARCHAR2	(240)		Sold-to address line 3
SOLD_TO_ADDRESS4	VARCHAR2	(240)		Sold-to address line 4
SOLD_TO_PROVINCE	VARCHAR2	(60)		Sold-to province
PURCHASE_ORDER	VARCHAR2	(50)		Purchase order number
PURCHASE_ORDER_REVISION	VARCHAR2	(50)		Purchase order revision
SALES_ORDER	VARCHAR2	(50)		Sales order number
SALES_ORDER_SOURCE	VARCHAR2	(50)		Sales order source
SALES_ORDER_REVISION	NUMBER			Sales order revision
SALES_ORDER_DATE	DATE			Sales order date
HEADER_CATEGORY	VARCHAR2	(150)		Header Level Descriptive Flexfield structure defining column
HEADER_ATTRIBUTE1	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE2	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE3	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE4	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE5	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE6	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE7	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE8	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE9	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE10	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE11	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE12	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE13	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE14	VARCHAR2	(150)		Header Descriptive Flexfield segment column
HEADER_ATTRIBUTE15	VARCHAR2	(150)		Header Descriptive Flexfield segment column
LINE_NUMBER	NUMBER			Invoice line number
ADJUSTMENT_NUMBER	VARCHAR2	(20)		Adjustment number or credit memo number
INV_OR_ADJ_DATE	DATE			Transaction date
INVENTORY_ITEM	VARCHAR2	(800)		Inventory item
DESCRIPTION	VARCHAR2	(240)		Line item description
ITEM_DESCRIPTION	VARCHAR2	(240)		Inventory item description, can be overridden by line item description
LINE_AMOUNT	NUMBER			Invoice line amount
EXEMPT_AMOUNT	NUMBER			Exempt amount
TAXABLE_AMOUNT	NUMBER			Taxable amount
TAX_REFERENCE	VARCHAR2	(50)		Tax reference
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type
EXCHANGE_DATE	DATE			Exchange rate date
EXCHANGE_RATE	NUMBER			Exchange rate
SHIP_VIA	VARCHAR2	(30)		Ship VIA
UOM	VARCHAR2	(3)		Unit of measurement
QUANTITY_INVOICED	NUMBER			Quantity invoiced
UNIT_SELLING_PRICE	NUMBER			Unit selling price
SALES_ORDER_LINE	VARCHAR2	(30)		Sales order line number
LINE_CATEGORY	VARCHAR2	(150)		Line Level Descriptive Flexfield structure defining column of type Line
LINE_ATTRIBUTE1	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE2	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE3	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE4	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE5	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE6	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE7	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE8	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE9	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE10	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE11	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE12	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE13	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE14	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
LINE_ATTRIBUTE15	VARCHAR2	(150)		Line Descriptive Flexfield segment column of type Line
TAX_LINE_NUMBER	NUMBER			Tax line number
TAX_RATE	NUMBER			Tax rate
TAX_CODE	VARCHAR2	(50)		Tax code
TAX_PRECEDENCE	NUMBER	(15)		Tax precedence
TAX_AMOUNT	NUMBER			Tax amount
EXEMPT_NUMBER	VARCHAR2	(80)		Exemption number
EXEMPT_REASON	VARCHAR2	(80)		Exemption reason
TOTAL_LINES_AMOUNT	NUMBER			Total line amount
TOTAL_TAX_AMOUNT	NUMBER			Total tax amount
FOOTNOTE	VARCHAR2	(80)		Footnote

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

AR.AR_SALES_TAX_REP_ITF does not reference any database object

AR.AR_SALES_TAX_REP_ITF is referenced by following:

AR: AR_SALES_TAX_REP_ITF#