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

TABLE: JA.JAI_AP_TDS_THGRP_AUDITS

Object Details
Object Name: JAI_AP_TDS_THGRP_AUDITS
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_AP_TDS_THGRP_AUDITS
Subobject Name:
Status: VALID


This table tracks the changes that happens to the table JAI_AP_TDS_THHOLD_GRPS. This table is very important for Threshold calculation and hence is tracked for all changes.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_AP_TDS_THGRP_AUDITS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTHRESHOLD_GRP_AUDIT_ID
JAI_AP_TDS_THGRP_AUDITS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTHRESHOLD_GRP_ID
Columns
Name Datatype Length Mandatory Comments
THRESHOLD_GRP_AUDIT_ID NUMBER (15) Yes Unique identifier
THRESHOLD_GRP_ID NUMBER (15) Yes threshold group identifier
OLD_INVOICE_AMOUNT NUMBER

Old TOTAL_INVOICE_AMOUNT
OLD_INVOICE_CANCEL_AMOUNT NUMBER

Old TOTAL_INVOICE_CANCEL_AMOUNT
OLD_INVOICE_APPLY_AMOUNT NUMBER

Old TOTAL_INVOICE_APPLY_AMOUNT
OLD_INVOICE_UNAPPLY_AMOUNT NUMBER

Old TOTAL_INVOICE_UNAPPLY_AMOUNT
OLD_TAX_PAID NUMBER

Old TOTAL_TAX_PAID
OLD_THHOLD_CHANGE_TAX_PAID NUMBER

Old TOTAL_THHOLD_CHANGE_TAX_PAID
OLD_THRESHOLD_SLAB_ID NUMBER (15)
old CURRENT_THRESHOLD_SLAB_ID
TRX_INVOICE_AMOUNT NUMBER

Transaction TOTAL_INVOICE_AMOUNT
TRX_INVOICE_CANCEL_AMOUNT NUMBER

Transaction TOTAL_INVOICE_CANCEL_AMOUNT
TRX_INVOICE_APPLY_AMOUNT NUMBER

Transaction TOTAL_INVOICE_APPLY_AMOUNT
TRX_INVOICE_UNAPPLY_AMOUNT NUMBER

Transaction TOTAL_INVOICE_UNAPPLY_AMOUNT
TRX_TAX_PAID NUMBER

Transaction TOTAL_TAX_PAID
TRX_THHOLD_CHANGE_TAX_PAID NUMBER

Transaction TOTAL_THHOLD_CHANGE_TAX_PAID
TRX_THRESHOLD_SLAB_ID NUMBER (15)
Transaction CURRENT_THRESHOLD_SLAB_ID
NEW_INVOICE_AMOUNT NUMBER

New TOTAL_INVOICE_AMOUNT
NEW_INVOICE_CANCEL_AMOUNT NUMBER

New TOTAL_INVOICE_CANCEL_AMOUNT
NEW_INVOICE_APPLY_AMOUNT NUMBER

New TOTAL_INVOICE_APPLY_AMOUNT
NEW_INVOICE_UNAPPLY_AMOUNT NUMBER

New TOTAL_INVOICE_UNAPPLY_AMOUNT
NEW_TAX_PAID NUMBER

New TOTAL_TAX_PAID
NEW_THHOLD_CHANGE_TAX_PAID NUMBER

New TOTAL_THHOLD_CHANGE_TAX_PAID
NEW_THRESHOLD_SLAB_ID NUMBER (15)
New CURRENT_THRESHOLD_SLAB_ID
TDS_EVENT VARCHAR2 (100)
TDS event, Possible values are INVOICE VALIDATE, INVOICE CANCEL, PREPAYMENT APPLICATION, PREPAYMENT UNAPPLICATION, MANUAL UPDATE and MIGRATION
INVOICE_ID NUMBER (15)
Invoice identifier
INVOICE_DISTRIBUTION_ID NUMBER (15)
Invoice Distribution identifier.
REMARKS VARCHAR2 (255)
Remarks
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number.
INVOICE_LINE_NUMBER NUMBER (15)
Invoice Line Number
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT THRESHOLD_GRP_AUDIT_ID
,      THRESHOLD_GRP_ID
,      OLD_INVOICE_AMOUNT
,      OLD_INVOICE_CANCEL_AMOUNT
,      OLD_INVOICE_APPLY_AMOUNT
,      OLD_INVOICE_UNAPPLY_AMOUNT
,      OLD_TAX_PAID
,      OLD_THHOLD_CHANGE_TAX_PAID
,      OLD_THRESHOLD_SLAB_ID
,      TRX_INVOICE_AMOUNT
,      TRX_INVOICE_CANCEL_AMOUNT
,      TRX_INVOICE_APPLY_AMOUNT
,      TRX_INVOICE_UNAPPLY_AMOUNT
,      TRX_TAX_PAID
,      TRX_THHOLD_CHANGE_TAX_PAID
,      TRX_THRESHOLD_SLAB_ID
,      NEW_INVOICE_AMOUNT
,      NEW_INVOICE_CANCEL_AMOUNT
,      NEW_INVOICE_APPLY_AMOUNT
,      NEW_INVOICE_UNAPPLY_AMOUNT
,      NEW_TAX_PAID
,      NEW_THHOLD_CHANGE_TAX_PAID
,      NEW_THRESHOLD_SLAB_ID
,      TDS_EVENT
,      INVOICE_ID
,      INVOICE_DISTRIBUTION_ID
,      REMARKS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      INVOICE_LINE_NUMBER
FROM JA.JAI_AP_TDS_THGRP_AUDITS;

Dependencies

[top of page]

JA.JAI_AP_TDS_THGRP_AUDITS does not reference any database object

JA.JAI_AP_TDS_THGRP_AUDITS is referenced by following:

SchemaAPPS
SynonymJAI_AP_TDS_THGRP_AUDITS