[Home] [Help] [Dependency Information]
Object Name: | JAI_AP_TDS_INV_TAXES# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TDS_INV_TAX_ID | NUMBER | (15) | Yes | |
INVOICE_ID | NUMBER | (15) | ||
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | ||
DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | ||
AMOUNT | NUMBER | |||
SECTION_TYPE | VARCHAR2 | (30) | Yes | |
DEFAULT_TYPE | VARCHAR2 | (30) | ||
DEFAULT_SECTION_CODE | VARCHAR2 | (30) | ||
DEFAULT_TAX_ID | NUMBER | (15) | ||
ACTUAL_SECTION_CODE | VARCHAR2 | (30) | ||
ACTUAL_TAX_ID | NUMBER | (15) | ||
USER_DELETED_TAX_FLAG | VARCHAR2 | (1) | ||
DEFAULT_THRESHOLD_GRP_ID | NUMBER | |||
DEFAULT_CUM_THRESHOLD_SLAB_ID | NUMBER | |||
DEFAULT_CUM_THRESHOLD_STAGE | VARCHAR2 | (30) | ||
DEFAULT_SIN_THRESHOLD_SLAB_ID | NUMBER | |||
DEFAULT_FROM | VARCHAR2 | (30) | ||
CONSIDER_FOR_REDEFAULT | VARCHAR2 | (2) | ||
TAX_AMOUNT | NUMBER | |||
THRESHOLD_TRX_ID | NUMBER | (15) | ||
THRESHOLD_GRP_ID | NUMBER | (15) | ||
THRESHOLD_HDR_ID | NUMBER | (15) | ||
THRESHOLD_SLAB_ID | NUMBER | (15) | ||
THRESHOLD_SLAB_ID_SINGLE | NUMBER | (15) | ||
PROCESS_STATUS | VARCHAR2 | (2) | ||
PROCESS_MESSAGE | VARCHAR2 | (255) | ||
CODEPATH | VARCHAR2 | (1996) | ||
MATCH_STATUS_FLAG | VARCHAR2 | (1) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
INVOICE_LINE_NUMBER | NUMBER | (15) | ||
CALC_TAX_AMOUNT | NUMBER | |||
CONSIDER_AMT_FOR_TDS | VARCHAR2 | (1) | ||
VENDOR_ID | NUMBER | (15) | ||
VENDOR_SITE_ID | NUMBER | (15) | ||
DIST_CODE_COMBINATION_ID | NUMBER | (15) | ||
TAX_LINE_NO | NUMBER | (15) | ||
TAX_TYPE | VARCHAR2 | (30) | ||
TAX_CATEGORY_ID | NUMBER | (15) | ||
PRECEDENCE_1 | NUMBER | (15) | ||
PRECEDENCE_2 | NUMBER | (15) | ||
PRECEDENCE_3 | NUMBER | (15) | ||
PRECEDENCE_4 | NUMBER | (15) | ||
PRECEDENCE_5 | NUMBER | (15) | ||
PRECEDENCE_6 | NUMBER | (15) | ||
PRECEDENCE_7 | NUMBER | (15) | ||
PRECEDENCE_8 | NUMBER | (15) | ||
PRECEDENCE_9 | NUMBER | (15) | ||
PRECEDENCE_10 | NUMBER | (15) | ||
FUNC_TAX_AMOUNT | NUMBER | (15) | ||
BASE_TAX_AMOUNT | NUMBER | (15) | ||
ROUNDED_AMOUNT | NUMBER | (15) | ||
THRESHOLD_TRANSITION | VARCHAR2 | (1) | ||
JAI_DISTRIBUTION_ID | NUMBER | (15) | ||
TAX_CATEGORY_OVERRIDEN | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT TDS_INV_TAX_ID
, INVOICE_ID
, INVOICE_DISTRIBUTION_ID
, DISTRIBUTION_LINE_NUMBER
, AMOUNT
, SECTION_TYPE
, DEFAULT_TYPE
, DEFAULT_SECTION_CODE
, DEFAULT_TAX_ID
, ACTUAL_SECTION_CODE
, ACTUAL_TAX_ID
, USER_DELETED_TAX_FLAG
, DEFAULT_THRESHOLD_GRP_ID
, DEFAULT_CUM_THRESHOLD_SLAB_ID
, DEFAULT_CUM_THRESHOLD_STAGE
, DEFAULT_SIN_THRESHOLD_SLAB_ID
, DEFAULT_FROM
, CONSIDER_FOR_REDEFAULT
, TAX_AMOUNT
, THRESHOLD_TRX_ID
, THRESHOLD_GRP_ID
, THRESHOLD_HDR_ID
, THRESHOLD_SLAB_ID
, THRESHOLD_SLAB_ID_SINGLE
, PROCESS_STATUS
, PROCESS_MESSAGE
, CODEPATH
, MATCH_STATUS_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, INVOICE_LINE_NUMBER
, CALC_TAX_AMOUNT
, CONSIDER_AMT_FOR_TDS
, VENDOR_ID
, VENDOR_SITE_ID
, DIST_CODE_COMBINATION_ID
, TAX_LINE_NO
, TAX_TYPE
, TAX_CATEGORY_ID
, PRECEDENCE_1
, PRECEDENCE_2
, PRECEDENCE_3
, PRECEDENCE_4
, PRECEDENCE_5
, PRECEDENCE_6
, PRECEDENCE_7
, PRECEDENCE_8
, PRECEDENCE_9
, PRECEDENCE_10
, FUNC_TAX_AMOUNT
, BASE_TAX_AMOUNT
, ROUNDED_AMOUNT
, THRESHOLD_TRANSITION
, JAI_DISTRIBUTION_ID
, TAX_CATEGORY_OVERRIDEN
FROM JA.JAI_AP_TDS_INV_TAXES#;
|
|
|