[Home] [Help] [Dependency Information]
Object Name: | ECE_AR_TRX_LINE_TAX# |
---|---|
Object Type: | VIEW |
Owner: | EC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMMUNICATION_METHOD | VARCHAR2 | (30) | ||
TRANSACTION_TYPE | VARCHAR2 | (30) | ||
TRANSACTION_ID | NUMBER | Yes | ||
LINE_NUMBER | NUMBER | |||
LINE_TYPE | VARCHAR2 | (20) | ||
TAX_LINE_NUMBER | NUMBER | |||
TAX_AMOUNT | NUMBER | |||
TAX_RATE | NUMBER | |||
TAX_PRECEDENCE | NUMBER | (15) | ||
VAT_TAX_CODE_INT | VARCHAR2 | (50) | ||
VAT_TAX_CODE_EXT1 | VARCHAR2 | (80) | ||
VAT_TAX_CODE_EXT2 | VARCHAR2 | (80) | ||
VAT_TAX_CODE_EXT3 | VARCHAR2 | (80) | ||
VAT_TAX_CODE_EXT4 | VARCHAR2 | (80) | ||
VAT_TAX_CODE_EXT5 | VARCHAR2 | (80) | ||
TAX_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
TAX_ATTRIBUTE1 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE2 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE3 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE4 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE5 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE6 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE7 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE8 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE9 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE10 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE11 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE12 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE13 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE14 | VARCHAR2 | (150) | ||
TAX_ATTRIBUTE15 | VARCHAR2 | (150) | ||
TAX_EXEMPT_FLAG | VARCHAR2 | (1) | ||
TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | ||
TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | ||
TAX_TYPE | VARCHAR2 | (30) | ||
TAX_TYPE_EXT1 | VARCHAR2 | (80) | ||
TAX_TYPE_EXT2 | VARCHAR2 | (80) | ||
TAX_TYPE_EXT3 | VARCHAR2 | (80) | ||
TAX_TYPE_EXT4 | VARCHAR2 | (80) | ||
TAX_TYPE_EXT5 | VARCHAR2 | (80) | ||
DESCRIPTION | VARCHAR2 | (60) | ||
LOCATION | VARCHAR2 | (60) | ||
TAX_CLASSIFICATION | VARCHAR2 | (30) | ||
TAX_CLASSIFICATION_EXT1 | VARCHAR2 | (80) | ||
TAX_CLASSIFICATION_EXT2 | VARCHAR2 | (80) | ||
TAX_CLASSIFICATION_EXT3 | VARCHAR2 | (80) | ||
TAX_CLASSIFICATION_EXT4 | VARCHAR2 | (80) | ||
TAX_CLASSIFICATION_EXT5 | VARCHAR2 | (80) | ||
VAT_TRANSACTION_TYPE | VARCHAR2 | (30) | ||
VAT_TRANSACTION_TYPE_EXT1 | VARCHAR2 | (80) | ||
VAT_TRANSACTION_TYPE_EXT2 | VARCHAR2 | (80) | ||
VAT_TRANSACTION_TYPE_EXT3 | VARCHAR2 | (80) | ||
VAT_TRANSACTION_TYPE_EXT4 | VARCHAR2 | (80) | ||
VAT_TRANSACTION_TYPE_EXT5 | VARCHAR2 | (80) | ||
VAT_TAX_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
VAT_TAX_ATTRIBUTE1 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE2 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE3 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE4 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE5 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE6 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE7 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE8 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE9 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE10 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE11 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE12 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE13 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE14 | VARCHAR2 | (150) | ||
VAT_TAX_ATTRIBUTE15 | VARCHAR2 | (150) | ||
RUN_ID | NUMBER | (22) | ||
TRANSACTION_RECORD_ID | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT COMMUNICATION_METHOD
, TRANSACTION_TYPE
, TRANSACTION_ID
, LINE_NUMBER
, LINE_TYPE
, TAX_LINE_NUMBER
, TAX_AMOUNT
, TAX_RATE
, TAX_PRECEDENCE
, VAT_TAX_CODE_INT
, VAT_TAX_CODE_EXT1
, VAT_TAX_CODE_EXT2
, VAT_TAX_CODE_EXT3
, VAT_TAX_CODE_EXT4
, VAT_TAX_CODE_EXT5
, TAX_ATTRIBUTE_CATEGORY
, TAX_ATTRIBUTE1
, TAX_ATTRIBUTE2
, TAX_ATTRIBUTE3
, TAX_ATTRIBUTE4
, TAX_ATTRIBUTE5
, TAX_ATTRIBUTE6
, TAX_ATTRIBUTE7
, TAX_ATTRIBUTE8
, TAX_ATTRIBUTE9
, TAX_ATTRIBUTE10
, TAX_ATTRIBUTE11
, TAX_ATTRIBUTE12
, TAX_ATTRIBUTE13
, TAX_ATTRIBUTE14
, TAX_ATTRIBUTE15
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, TAX_TYPE
, TAX_TYPE_EXT1
, TAX_TYPE_EXT2
, TAX_TYPE_EXT3
, TAX_TYPE_EXT4
, TAX_TYPE_EXT5
, DESCRIPTION
, LOCATION
, TAX_CLASSIFICATION
, TAX_CLASSIFICATION_EXT1
, TAX_CLASSIFICATION_EXT2
, TAX_CLASSIFICATION_EXT3
, TAX_CLASSIFICATION_EXT4
, TAX_CLASSIFICATION_EXT5
, VAT_TRANSACTION_TYPE
, VAT_TRANSACTION_TYPE_EXT1
, VAT_TRANSACTION_TYPE_EXT2
, VAT_TRANSACTION_TYPE_EXT3
, VAT_TRANSACTION_TYPE_EXT4
, VAT_TRANSACTION_TYPE_EXT5
, VAT_TAX_ATTRIBUTE_CATEGORY
, VAT_TAX_ATTRIBUTE1
, VAT_TAX_ATTRIBUTE2
, VAT_TAX_ATTRIBUTE3
, VAT_TAX_ATTRIBUTE4
, VAT_TAX_ATTRIBUTE5
, VAT_TAX_ATTRIBUTE6
, VAT_TAX_ATTRIBUTE7
, VAT_TAX_ATTRIBUTE8
, VAT_TAX_ATTRIBUTE9
, VAT_TAX_ATTRIBUTE10
, VAT_TAX_ATTRIBUTE11
, VAT_TAX_ATTRIBUTE12
, VAT_TAX_ATTRIBUTE13
, VAT_TAX_ATTRIBUTE14
, VAT_TAX_ATTRIBUTE15
, RUN_ID
, TRANSACTION_RECORD_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM EC.ECE_AR_TRX_LINE_TAX#;
|
|
|