[Home] [Help] [Dependency Information]
Object Name: | JAI_AP_TDS_THGRP_AUDITS# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
THRESHOLD_GRP_AUDIT_ID | NUMBER | (15) | Yes | |
THRESHOLD_GRP_ID | NUMBER | (15) | Yes | |
OLD_INVOICE_AMOUNT | NUMBER | |||
OLD_INVOICE_CANCEL_AMOUNT | NUMBER | |||
OLD_INVOICE_APPLY_AMOUNT | NUMBER | |||
OLD_INVOICE_UNAPPLY_AMOUNT | NUMBER | |||
OLD_TAX_PAID | NUMBER | |||
OLD_THHOLD_CHANGE_TAX_PAID | NUMBER | |||
OLD_THRESHOLD_SLAB_ID | NUMBER | (15) | ||
TRX_INVOICE_AMOUNT | NUMBER | |||
TRX_INVOICE_CANCEL_AMOUNT | NUMBER | |||
TRX_INVOICE_APPLY_AMOUNT | NUMBER | |||
TRX_INVOICE_UNAPPLY_AMOUNT | NUMBER | |||
TRX_TAX_PAID | NUMBER | |||
TRX_THHOLD_CHANGE_TAX_PAID | NUMBER | |||
TRX_THRESHOLD_SLAB_ID | NUMBER | (15) | ||
NEW_INVOICE_AMOUNT | NUMBER | |||
NEW_INVOICE_CANCEL_AMOUNT | NUMBER | |||
NEW_INVOICE_APPLY_AMOUNT | NUMBER | |||
NEW_INVOICE_UNAPPLY_AMOUNT | NUMBER | |||
NEW_TAX_PAID | NUMBER | |||
NEW_THHOLD_CHANGE_TAX_PAID | NUMBER | |||
NEW_THRESHOLD_SLAB_ID | NUMBER | (15) | ||
TDS_EVENT | VARCHAR2 | (100) | ||
INVOICE_ID | NUMBER | (15) | ||
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | ||
REMARKS | VARCHAR2 | (255) | ||
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_OLD_TAX_PAID | NUMBER | |||
CALC_TRX_TAX_PAID | NUMBER | |||
CALC_NEW_TAX_PAID | NUMBER |
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
, CALC_OLD_TAX_PAID
, CALC_TRX_TAX_PAID
, CALC_NEW_TAX_PAID
FROM JA.JAI_AP_TDS_THGRP_AUDITS#;
|
|
|