JE_ZZ_VAT_REP_TRX_T
Oracle internal use only. This temporary table contains reporting information related to tax, that must be sent to the tax authority.
Details
-
Schema: FUSION
-
Object owner: JE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
JE_ZZ_VAT_REP_TRX_T_PK |
REP_TRX_DETAIL_LINE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REP_TRX_DETAIL_LINE_ID | NUMBER | 18 | Yes | Identifier of the detail tax line id. | |
| TRANSACTION_SOURCE | VARCHAR2 | 30 | Source application module that created this record. Examples include Receivables, Payables, and external tax transactions. | ||
| REPORTING_BATCH_ID | NUMBER | 18 | Identifies the selection process batch. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| JE_INFO_V1 | VARCHAR2 | 240 | Oracle internal use only | ||
| JE_INFO_V2 | VARCHAR2 | 240 | Oracle internal use only | ||
| JE_INFO_V3 | VARCHAR2 | 240 | Oracle internal use only | ||
| JE_INFO_V4 | VARCHAR2 | 240 | Oracle internal use only | ||
| JE_INFO_V5 | VARCHAR2 | 240 | Oracle internal use only | ||
| JE_INFO_V6 | VARCHAR2 | 240 | Oracle internal use only | ||
| JE_INFO_V7 | VARCHAR2 | 240 | Oracle internal use only | ||
| JE_INFO_V8 | VARCHAR2 | 240 | Oracle internal use only | ||
| JE_INFO_V9 | VARCHAR2 | 240 | Oracle internal use only | ||
| JE_INFO_V10 | VARCHAR2 | 240 | Oracle internal use only | ||
| JE_INFO_V11 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V12 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V13 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V14 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V15 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V16 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V17 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V18 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V19 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V20 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V21 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V22 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V23 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V24 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V25 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V26 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V27 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V28 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V29 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V30 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V31 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V32 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V33 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V34 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V35 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V36 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V37 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V38 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V39 | VARCHAR2 | 500 | Oracle internal use only | ||
| JE_INFO_V40 | VARCHAR2 | 1000 | Oracle internal use only | ||
| JE_INFO_V41 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V42 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V43 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V44 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V45 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V46 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V47 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V48 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V49 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_V50 | VARCHAR2 | 150 | Oracle internal use only | ||
| JE_INFO_N1 | NUMBER | Oracle internal use only | |||
| JE_INFO_N2 | NUMBER | Oracle internal use only | |||
| JE_INFO_N3 | NUMBER | Oracle internal use only | |||
| JE_INFO_N4 | NUMBER | Oracle internal use only | |||
| JE_INFO_N5 | NUMBER | Oracle internal use only | |||
| JE_INFO_N6 | NUMBER | Oracle internal use only | |||
| JE_INFO_N7 | NUMBER | Oracle internal use only | |||
| JE_INFO_N8 | NUMBER | Oracle internal use only | |||
| JE_INFO_N9 | NUMBER | Oracle internal use only | |||
| JE_INFO_N10 | NUMBER | Oracle internal use only | |||
| JE_INFO_N11 | NUMBER | Oracle internal use only | |||
| JE_INFO_N12 | NUMBER | Oracle internal use only | |||
| JE_INFO_N13 | NUMBER | Oracle internal use only | |||
| JE_INFO_N14 | NUMBER | Oracle internal use only | |||
| JE_INFO_N15 | NUMBER | Oracle internal use only | |||
| JE_INFO_N16 | NUMBER | Oracle internal use only | |||
| JE_INFO_N17 | NUMBER | Oracle internal use only | |||
| JE_INFO_N18 | NUMBER | Oracle internal use only | |||
| JE_INFO_N19 | NUMBER | Oracle internal use only | |||
| JE_INFO_N20 | NUMBER | Oracle internal use only | |||
| JE_INFO_N21 | NUMBER | Oracle internal use only | |||
| JE_INFO_N22 | NUMBER | Oracle internal use only | |||
| JE_INFO_N23 | NUMBER | Oracle internal use only | |||
| JE_INFO_N24 | NUMBER | Oracle internal use only | |||
| JE_INFO_N25 | NUMBER | Oracle internal use only | |||
| JE_INFO_N26 | NUMBER | Oracle internal use only | |||
| JE_INFO_N27 | NUMBER | Oracle internal use only | |||
| JE_INFO_N28 | NUMBER | Oracle internal use only | |||
| JE_INFO_N29 | NUMBER | Oracle internal use only | |||
| JE_INFO_N30 | NUMBER | Oracle internal use only | |||
| JE_INFO_D1 | DATE | Oracle internal use only | |||
| JE_INFO_D2 | DATE | Oracle internal use only | |||
| JE_INFO_D3 | DATE | Oracle internal use only | |||
| JE_INFO_D4 | DATE | Oracle internal use only | |||
| JE_INFO_D5 | DATE | Oracle internal use only | |||
| JE_INFO_D6 | DATE | Oracle internal use only | |||
| JE_INFO_D7 | DATE | Oracle internal use only | |||
| JE_INFO_D8 | DATE | Oracle internal use only | |||
| JE_INFO_D9 | DATE | Oracle internal use only | |||
| JE_INFO_D10 | DATE | Oracle internal use only | |||
| JE_INFO_D11 | DATE | Oracle internal use only | |||
| JE_INFO_D12 | DATE | Oracle internal use only | |||
| JE_INFO_D13 | DATE | Oracle internal use only | |||
| JE_INFO_D14 | DATE | Oracle internal use only | |||
| JE_INFO_D15 | DATE | Oracle internal use only | |||
| JE_INFO_DT1 | TIMESTAMP | Oracle internal use only | |||
| JE_INFO_DT2 | TIMESTAMP | Oracle internal use only |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JE_ZZ_VAT_REP_TRX_T_N1 | Non Unique | Default | REPORTING_BATCH_ID |
| JE_ZZ_VAT_REP_TRX_T_N2 | Non Unique | Default | REQUEST_ID |
| JE_ZZ_VAT_REP_TRX_T_U1 | Unique | Default | REP_TRX_DETAIL_LINE_ID |