Skip to content

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

VIEW: JA.JAI_AP_TDS_INV_TAXES#

Object Details
Object Name: JAI_AP_TDS_INV_TAXES#
Object Type: VIEW
Owner: JA
Subobject Name:
Status: VALID

[View Source]

Columns
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)
Query Text

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#;

Dependencies

[top of page]

JA.JAI_AP_TDS_INV_TAXES# references the following:

SchemaJA
TableJAI_AP_TDS_INV_TAXES
JA.JAI_AP_TDS_INV_TAXES# is referenced by following:

SchemaAPPS
SynonymJAI_AP_TDS_INV_TAXES