Skip to content

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

VIEW: AR.AR_SALES_TAX_REP_ITF#

Object Details
Object Name: AR_SALES_TAX_REP_ITF#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes
LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

LAST_UPDATE_DATE DATE

SOB_NAME VARCHAR2 (30)
BASE_CURRENCY VARCHAR2 (15)
INVOICE_NUMBER VARCHAR2 (20)
INVOICE_CURRENCY_CODE VARCHAR2 (15)
TRANSACTION_TYPE VARCHAR2 (20)
CLASS VARCHAR2 (80)
SIC_CODE VARCHAR2 (30)
FOB_POINT VARCHAR2 (30)
SHIP_DATE_ACTUAL DATE

WAYBILL_NUMBER VARCHAR2 (50)
POSTING_STATUS VARCHAR2 (10)
SHIP_TO_STATE VARCHAR2 (60)
SHIP_TO_COUNTY VARCHAR2 (60)
SHIP_TO_CITY VARCHAR2 (60)
SHIP_TO_POSTAL_CODE VARCHAR2 (60)
SHIP_TO_CUSTOMER_NAME VARCHAR2 (50)
SHIP_TO_CUSTOMER_NUMBER VARCHAR2 (30)
SHIP_TO_CUSTOMER_TYPE VARCHAR2 (80)
SHIP_TO_ADDRESS1 VARCHAR2 (240)
SHIP_TO_ADDRESS2 VARCHAR2 (240)
SHIP_TO_ADDRESS3 VARCHAR2 (240)
SHIP_TO_ADDRESS4 VARCHAR2 (240)
SHIP_TO_PROVINCE VARCHAR2 (60)
BILL_TO_STATE VARCHAR2 (60)
BILL_TO_COUNTY VARCHAR2 (60)
BILL_TO_CITY VARCHAR2 (60)
BILL_TO_POSTAL_CODE VARCHAR2 (60)
BILL_TO_CUSTOMER_NAME VARCHAR2 (50)
BILL_TO_CUSTOMER_NUMBER VARCHAR2 (30)
BILL_TO_CUSTOMER_TYPE VARCHAR2 (80)
BILL_TO_ADDRESS1 VARCHAR2 (240)
BILL_TO_ADDRESS2 VARCHAR2 (240)
BILL_TO_ADDRESS3 VARCHAR2 (240)
BILL_TO_ADDRESS4 VARCHAR2 (240)
BILL_TO_PROVINCE VARCHAR2 (60)
SOLD_TO_STATE VARCHAR2 (60)
SOLD_TO_COUNTY VARCHAR2 (60)
SOLD_TO_CITY VARCHAR2 (60)
SOLD_TO_POSTAL_CODE VARCHAR2 (60)
SOLD_TO_CUSTOMER_NAME VARCHAR2 (50)
SOLD_TO_CUSTOMER_NUMBER VARCHAR2 (30)
SOLD_TO_CUSTOMER_TYPE VARCHAR2 (80)
SOLD_TO_ADDRESS1 VARCHAR2 (240)
SOLD_TO_ADDRESS2 VARCHAR2 (240)
SOLD_TO_ADDRESS3 VARCHAR2 (240)
SOLD_TO_ADDRESS4 VARCHAR2 (240)
SOLD_TO_PROVINCE VARCHAR2 (60)
PURCHASE_ORDER VARCHAR2 (50)
PURCHASE_ORDER_REVISION VARCHAR2 (50)
SALES_ORDER VARCHAR2 (50)
SALES_ORDER_SOURCE VARCHAR2 (50)
SALES_ORDER_REVISION NUMBER

SALES_ORDER_DATE DATE

HEADER_CATEGORY VARCHAR2 (150)
HEADER_ATTRIBUTE1 VARCHAR2 (150)
HEADER_ATTRIBUTE2 VARCHAR2 (150)
HEADER_ATTRIBUTE3 VARCHAR2 (150)
HEADER_ATTRIBUTE4 VARCHAR2 (150)
HEADER_ATTRIBUTE5 VARCHAR2 (150)
HEADER_ATTRIBUTE6 VARCHAR2 (150)
HEADER_ATTRIBUTE7 VARCHAR2 (150)
HEADER_ATTRIBUTE8 VARCHAR2 (150)
HEADER_ATTRIBUTE9 VARCHAR2 (150)
HEADER_ATTRIBUTE10 VARCHAR2 (150)
HEADER_ATTRIBUTE11 VARCHAR2 (150)
HEADER_ATTRIBUTE12 VARCHAR2 (150)
HEADER_ATTRIBUTE13 VARCHAR2 (150)
HEADER_ATTRIBUTE14 VARCHAR2 (150)
HEADER_ATTRIBUTE15 VARCHAR2 (150)
LINE_NUMBER NUMBER

ADJUSTMENT_NUMBER VARCHAR2 (20)
INV_OR_ADJ_DATE DATE

INVENTORY_ITEM VARCHAR2 (800)
DESCRIPTION VARCHAR2 (240)
ITEM_DESCRIPTION VARCHAR2 (240)
LINE_AMOUNT NUMBER

EXEMPT_AMOUNT NUMBER

TAXABLE_AMOUNT NUMBER

TAX_REFERENCE VARCHAR2 (50)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
EXCHANGE_DATE DATE

EXCHANGE_RATE NUMBER

SHIP_VIA VARCHAR2 (30)
UOM VARCHAR2 (3)
QUANTITY_INVOICED NUMBER

UNIT_SELLING_PRICE NUMBER

SALES_ORDER_LINE VARCHAR2 (30)
LINE_CATEGORY VARCHAR2 (150)
LINE_ATTRIBUTE1 VARCHAR2 (150)
LINE_ATTRIBUTE2 VARCHAR2 (150)
LINE_ATTRIBUTE3 VARCHAR2 (150)
LINE_ATTRIBUTE4 VARCHAR2 (150)
LINE_ATTRIBUTE5 VARCHAR2 (150)
LINE_ATTRIBUTE6 VARCHAR2 (150)
LINE_ATTRIBUTE7 VARCHAR2 (150)
LINE_ATTRIBUTE8 VARCHAR2 (150)
LINE_ATTRIBUTE9 VARCHAR2 (150)
LINE_ATTRIBUTE10 VARCHAR2 (150)
LINE_ATTRIBUTE11 VARCHAR2 (150)
LINE_ATTRIBUTE12 VARCHAR2 (150)
LINE_ATTRIBUTE13 VARCHAR2 (150)
LINE_ATTRIBUTE14 VARCHAR2 (150)
LINE_ATTRIBUTE15 VARCHAR2 (150)
TAX_LINE_NUMBER NUMBER

TAX_RATE NUMBER

TAX_CODE VARCHAR2 (50)
TAX_PRECEDENCE NUMBER (15)
TAX_AMOUNT NUMBER

EXEMPT_NUMBER VARCHAR2 (80)
EXEMPT_REASON VARCHAR2 (80)
TOTAL_LINES_AMOUNT NUMBER

TOTAL_TAX_AMOUNT NUMBER

FOOTNOTE VARCHAR2 (80)
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# references the following:

SchemaAR
TableAR_SALES_TAX_REP_ITF
AR.AR_SALES_TAX_REP_ITF# is referenced by following:

SchemaAPPS
SynonymAR_SALES_TAX_REP_ITF