JG_FSCL_TAX_LINE_DTLS_GT

This is a temporary table which is used internally by Oracle.

Details

• Schema: FUSION

• Object owner: JG

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
JG_FSCL_TAX_LINE_DTLS_GT_PK	DETAIL_TAX_LINE_ID

Columns

Name	Datatype	Precision	Not-null	Comments
DETAIL_TAX_LINE_ID	NUMBER	18	Yes	Detail tax line identifier of the transaction.
TAX_LINE_ID	NUMBER	18	Yes	Tax line identifier of the transaction.
TRX_LINE_DETAIL_ID	NUMBER	18	Yes	Transaction line detail identifier of the transaction.
TRX_LINE_ID	NUMBER	18	Yes	Transaction line identifier of the transaction.
DTL_TAX_LINE_TAXABLE_AMT	NUMBER			Taxable amount in entered currency.
DTL_TAX_LINE_TAX_AMT	NUMBER			Tax amount in entered currency.
LINE_TAXABLE_AMOUNT	NUMBER			Taxable amount of a fiscal document tax line in entered currency.
LINE_TAX_AMT	NUMBER			Tax amount of a fiscal document tax line in entered currency.

Indexes

Index	Uniqueness	Tablespace	Columns
JG_FSCL_TAX_LINE_DTLS_GT_U1	Unique	Default	DETAIL_TAX_LINE_ID
JG_FSCL_TAX_LINE_DTLS_GT_U2	Unique	Default	TAX_LINE_ID, TRX_LINE_DETAIL_ID