[Home] [Help] [Dependency Information]
Object Name: | AR_TAX_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | (15) | Yes | |
INTERFACE_LINE_ID | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
SEGMENT_QUALIFIER | VARCHAR2 | (30) | Yes | |
RATE_TYPE | VARCHAR2 | (30) | Yes | |
LOCATION_ID | VARCHAR2 | (15) | Yes | |
LOCATION_VALUE | VARCHAR2 | (60) | Yes | |
LOCATION_DESCRIPTION | VARCHAR2 | (60) | ||
PARENT_LOCATION_ID | VARCHAR2 | (15) | ||
FROM_POSTAL_CODE | VARCHAR2 | (60) | ||
TO_POSTAL_CODE | VARCHAR2 | (60) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
TAX_RATE | NUMBER | |||
CHANGE_FLAG | VARCHAR2 | (1) | Yes | |
STATUS | VARCHAR2 | (60) | ||
ERROR_MESSAGE | VARCHAR2 | (240) | ||
OVERRIDE_CONTROL | NUMBER | (15) | ||
LOCATION_SEGMENT_ID | NUMBER | (15) | ||
LOCATION_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
LOCATION_ATTRIBUTE1 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE2 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE3 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE4 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE5 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE6 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE7 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE8 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE9 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE10 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE11 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE12 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE13 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE14 | VARCHAR2 | (150) | ||
LOCATION_ATTRIBUTE15 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
RATE_ATTRIBUTE1 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE2 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE3 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE4 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE5 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE6 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE7 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE8 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE9 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE10 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE11 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE12 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE13 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE14 | VARCHAR2 | (150) | ||
RATE_ATTRIBUTE15 | VARCHAR2 | (150) | ||
OVERRIDE_STRUCTURE_ID | NUMBER | |||
OVERRIDE_RATE1 | NUMBER | |||
OVERRIDE_RATE2 | NUMBER | |||
OVERRIDE_RATE3 | NUMBER | |||
OVERRIDE_RATE4 | NUMBER | |||
OVERRIDE_RATE5 | NUMBER | |||
OVERRIDE_RATE6 | NUMBER | |||
OVERRIDE_RATE7 | NUMBER | |||
OVERRIDE_RATE8 | NUMBER | |||
OVERRIDE_RATE9 | NUMBER | |||
OVERRIDE_RATE10 | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, INTERFACE_LINE_ID
, CREATED_BY
, CREATION_DATE
, SEGMENT_QUALIFIER
, RATE_TYPE
, LOCATION_ID
, LOCATION_VALUE
, LOCATION_DESCRIPTION
, PARENT_LOCATION_ID
, FROM_POSTAL_CODE
, TO_POSTAL_CODE
, START_DATE
, END_DATE
, TAX_RATE
, CHANGE_FLAG
, STATUS
, ERROR_MESSAGE
, OVERRIDE_CONTROL
, LOCATION_SEGMENT_ID
, LOCATION_ATTRIBUTE_CATEGORY
, LOCATION_ATTRIBUTE1
, LOCATION_ATTRIBUTE2
, LOCATION_ATTRIBUTE3
, LOCATION_ATTRIBUTE4
, LOCATION_ATTRIBUTE5
, LOCATION_ATTRIBUTE6
, LOCATION_ATTRIBUTE7
, LOCATION_ATTRIBUTE8
, LOCATION_ATTRIBUTE9
, LOCATION_ATTRIBUTE10
, LOCATION_ATTRIBUTE11
, LOCATION_ATTRIBUTE12
, LOCATION_ATTRIBUTE13
, LOCATION_ATTRIBUTE14
, LOCATION_ATTRIBUTE15
, RATE_ATTRIBUTE_CATEGORY
, RATE_ATTRIBUTE1
, RATE_ATTRIBUTE2
, RATE_ATTRIBUTE3
, RATE_ATTRIBUTE4
, RATE_ATTRIBUTE5
, RATE_ATTRIBUTE6
, RATE_ATTRIBUTE7
, RATE_ATTRIBUTE8
, RATE_ATTRIBUTE9
, RATE_ATTRIBUTE10
, RATE_ATTRIBUTE11
, RATE_ATTRIBUTE12
, RATE_ATTRIBUTE13
, RATE_ATTRIBUTE14
, RATE_ATTRIBUTE15
, OVERRIDE_STRUCTURE_ID
, OVERRIDE_RATE1
, OVERRIDE_RATE2
, OVERRIDE_RATE3
, OVERRIDE_RATE4
, OVERRIDE_RATE5
, OVERRIDE_RATE6
, OVERRIDE_RATE7
, OVERRIDE_RATE8
, OVERRIDE_RATE9
, OVERRIDE_RATE10
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
FROM AR.AR_TAX_INTERFACE#;
|
|
|