AR_TRX_COGS_GT
This is a temporary table which is used internally by Oracle.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Columns
| Name | Datatype | Precision | Not-null | Comments |
|---|---|---|---|---|
| CUSTOMER_TRX_ID | NUMBER | 18 | Oracle internal use only | |
| CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Oracle internal use only | |
| PREVIOUS_CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Oracle internal use only | |
| SO_LINE_ID | NUMBER | 18 | Oracle internal use only | |
| PERIOD_NUMBER | NUMBER | 18 | Oracle internal use only | |
| REVENUE_DIST_AMOUNT | NUMBER | Oracle internal use only | ||
| REVENUE_LINE_AMOUNT | NUMBER | Oracle internal use only | ||
| LATEST_GL_DATE | DATE | Oracle internal use only | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. |
| SET_OF_BOOKS_ID | NUMBER | 18 | Oracle internal use only |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AR_TRX_COGS_N1 | Non Unique | SO_LINE_ID |