[Home] [Help] [Dependency Information]
Object Name: | ECE_CDMO_LINE_TAX_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EC.ECE_CDMO_LINE_TAX_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view extracts line tax information
for the outbound Credit/Debit Memo (812/CREADV/DEBADV) transaction.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | (15) | Yes | Transaction ID |
LINE_NUMBER | NUMBER | Yes | Line Number | |
CUSTOMER_TRX_LINE_ID | NUMBER | (15) | Yes | Customer Transaction Line Id |
TAX_LINE_NUMBER | NUMBER | Yes | Tax Line Number | |
LINE_TYPE | VARCHAR2 | (20) | Yes | Line Type |
TAX_AMOUNT | NUMBER | Yes | Tax Amount | |
TAX_RATE | NUMBER | Tax Rate | ||
TAX_PRECEDENCE | NUMBER | Tax Precedence | ||
TAX_CODE | VARCHAR2 | (50) | Tax Code (Internal) | |
LINK_TO_CUST_TRX_LINE_ID | NUMBER | (15) | Tax Link To Customer Transaction Id | |
TAX_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Tax Flexfield Context | |
TAX_ATTRIBUTE1 | VARCHAR2 | (150) | Tax Flexfield 1 | |
TAX_ATTRIBUTE2 | VARCHAR2 | (150) | Tax Flexfield 2 | |
TAX_ATTRIBUTE3 | VARCHAR2 | (150) | Tax Flexfield 3 | |
TAX_ATTRIBUTE4 | VARCHAR2 | (150) | Tax Flexfield 4 | |
TAX_ATTRIBUTE5 | VARCHAR2 | (150) | Tax Flexfield 5 | |
TAX_ATTRIBUTE6 | VARCHAR2 | (150) | Tax Flexfield 6 | |
TAX_ATTRIBUTE7 | VARCHAR2 | (150) | Tax Flexfield 7 | |
TAX_ATTRIBUTE8 | VARCHAR2 | (150) | Tax Flexfield 8 | |
TAX_ATTRIBUTE9 | VARCHAR2 | (150) | Tax Flexfield 9 | |
TAX_ATTRIBUTE10 | VARCHAR2 | (150) | Tax Flexfield 10 | |
TAX_ATTRIBUTE11 | VARCHAR2 | (150) | Tax Flexfield 11 | |
TAX_ATTRIBUTE12 | VARCHAR2 | (150) | Tax Flexfield 12 | |
TAX_ATTRIBUTE13 | VARCHAR2 | (150) | Tax Flexfield 13 | |
TAX_ATTRIBUTE14 | VARCHAR2 | (150) | Tax Flexfield 14 | |
TAX_ATTRIBUTE15 | VARCHAR2 | (150) | Tax Flexfield 15 | |
TAX_EXEMPT_FLAG | VARCHAR2 | (1) | Tax Exempt Flag | |
TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | Tax Exempt Number | |
TAX_EXEMPT_REASON_CODE | VARCHAR2 | (30) | Tax Exempt Reason Code | |
TAX_TYPE | VARCHAR2 | (30) | Tax Type | |
DESCRIPTION | VARCHAR2 | (60) | Description | |
LOCATION | VARCHAR2 | (0) | Location | |
TAX_CLASSIFICATION | VARCHAR2 | (0) | Tax Classification | |
VAT_TRANSACTION_TYPE | VARCHAR2 | (30) | Vat Transaction Type | |
VAT_TAX_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Vat Tax Flexfield Context | |
VAT_TAX_ATTRIBUTE1 | VARCHAR2 | (150) | Vat Tax Flexfield 1 | |
VAT_TAX_ATTRIBUTE2 | VARCHAR2 | (150) | Vat Tax Flexfield 2 | |
VAT_TAX_ATTRIBUTE3 | VARCHAR2 | (150) | Vat Tax Flexfield 3 | |
VAT_TAX_ATTRIBUTE4 | VARCHAR2 | (150) | Vat Tax Flexfield 4 | |
VAT_TAX_ATTRIBUTE5 | VARCHAR2 | (150) | Vat Tax Flexfield 5 | |
VAT_TAX_ATTRIBUTE6 | VARCHAR2 | (150) | Vat Tax Flexfield 6 | |
VAT_TAX_ATTRIBUTE7 | VARCHAR2 | (150) | Vat Tax Flexfield 7 | |
VAT_TAX_ATTRIBUTE8 | VARCHAR2 | (150) | Vat Tax Flexfield 8 | |
VAT_TAX_ATTRIBUTE9 | VARCHAR2 | (150) | Vat Tax Flexfield 9 | |
VAT_TAX_ATTRIBUTE10 | VARCHAR2 | (150) | Vat Tax Flexfield 10 | |
VAT_TAX_ATTRIBUTE11 | VARCHAR2 | (150) | Vat Tax Flexfield 11 | |
VAT_TAX_ATTRIBUTE12 | VARCHAR2 | (150) | Vat Tax Flexfield 12 | |
VAT_TAX_ATTRIBUTE13 | VARCHAR2 | (150) | Vat Tax Flexfield 13 | |
VAT_TAX_ATTRIBUTE14 | VARCHAR2 | (150) | Vat Tax Flexfield 14 | |
VAT_TAX_ATTRIBUTE15 | VARCHAR2 | (150) | Vat Tax Flexfield 15 |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, LINE_NUMBER
, CUSTOMER_TRX_LINE_ID
, TAX_LINE_NUMBER
, LINE_TYPE
, TAX_AMOUNT
, TAX_RATE
, TAX_PRECEDENCE
, TAX_CODE
, LINK_TO_CUST_TRX_LINE_ID
, 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
, DESCRIPTION
, LOCATION
, TAX_CLASSIFICATION
, VAT_TRANSACTION_TYPE
, 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
FROM APPS.ECE_CDMO_LINE_TAX_V;
APPS.ECE_CDMO_LINE_TAX_V is not referenced by any database object
|
|
|