ZX_REP_AUDIT_DISTS
This table contains the audit references for transaction tax reporting, including the references for transactions reported in prior tax reporting periods.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZX_REP_AUDIT_DISTS_PK |
REP_TRX_TAX_DIST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REP_TRX_TAX_DIST_ID | NUMBER | 18 | Yes | Line identifier for each inserted row. | |
| AUDIT_REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: Indicates the request ID of the job that created or last updated the row. | |
| INTERNAL_ORGANIZATION_ID | NUMBER | 18 | Yes | Internal organization identifier of transaction. | |
| APPLICATION_ID | NUMBER | 18 | Yes | Application identifier of transaction. | |
| LEDGER_ID | NUMBER | 18 | Yes | Ledger identifier of transaction. | |
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Legal entity identifier of transaction. | |
| EVENT_CLASS_MAPPING_ID | NUMBER | 18 | Yes | Event class mapping identifier of distribution. | |
| TRX_ID | NUMBER | 18 | Yes | Transaction identifier from subledger. | |
| TRX_LINE_ID | NUMBER | 18 | Yes | Transaction line identifier from subledger. | |
| ENTITY_CODE | VARCHAR2 | 30 | Yes | Entity code for the transaction. | |
| EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Event class code of transaction. | |
| TRX_LEVEL_TYPE | VARCHAR2 | 30 | Yes | Level at which transaction line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. | |
| TAX_LINE_ID | NUMBER | 18 | Yes | Tax line identifier of transaction. | |
| TAX_DIST_ID | NUMBER | 18 | Yes | Recoverable or nonrecoverable tax distribution identifier for procure to pay transactions, or transaction tax distribution identifier for manual order to cash transactions. | |
| TRX_DATE | DATE | Yes | Transaction date entered in subledger. | ||
| TAX_POINT_BASIS | VARCHAR2 | 30 | Yes | Tax point basis information for transaction tax line. | |
| REPORTABLE_FLAG | VARCHAR2 | 1 | Yes | Indicates whether tax line is reportable. | |
| LINES_DET_FACTOR_ID | NUMBER | 18 | Yes | Line identification for tax determining factor. | |
| TAX_EVENT_CLASS_CODE | VARCHAR2 | 30 | Yes | Event class code for transaction tax line. | |
| TAX_REGIME_CODE | VARCHAR2 | 30 | Yes | Tax regime code of distribution. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| HQ_ESTB_REG_NUMBER | VARCHAR2 | 30 | First party HQ establishment tax registration number. | ||
| TRX_LINE_DIST_ID | NUMBER | 18 | Transaction line distribution identifier, such as item distribution identifier, for tax distribution. | ||
| CONTENT_OWNER_ID | NUMBER | 18 | Party tax profile identifier for configuration owner of tax. | ||
| TRX_TAX_DIST_ID | NUMBER | 18 | Distribution identifier in transaction table for tax line or tax distribution. | ||
| ACTG_EVENT_ID | NUMBER | 18 | Categorization of accounting events that is unique within an application and event class. | ||
| ACCOUNTING_DATE | DATE | Date from Oracle Fusion General Ledger that is used to determine accounting period for transactions. | |||
| TAX_POINT_DATE | DATE | Date on which taxpayer becomes liable for paying tax to tax authority, such as delivery date, pickup date, or invoice date. | |||
| REPORTING_BATCH_ID | NUMBER | 18 | Selection process batch identifier. | ||
| LEGAL_REPORTING_STATUS | VARCHAR2 | 15 | Legal reporting status for tax distribution. | ||
| AR_RECEIPT_METHOD_ID | NUMBER | 18 | Receipt method identifier of transaction. | ||
| IBY_PAYMENT_PROFILE_ID | NUMBER | 18 | Payment profile identifier of transaction. | ||
| RECEIPT_CLASS_ID | NUMBER | 18 | Receipt class identifier of transaction. | ||
| PAYMENT_TRX_ID | NUMBER | 18 | Payment identifier when payment is made at transaction level. | ||
| PAYMENT_TRX_LINE_ID | NUMBER | 18 | Payment identifier when payment is made at transaction line level. | ||
| PAYMENT_TRX_DIST_ID | NUMBER | 18 | Payment identifier when payment is made at transaction distribution level. | ||
| PAYMENT_TRX_TAX_DIST_ID | NUMBER | 18 | Payment identifier when payment is made at tax distribution level. | ||
| LINE_CLASS_CODE | VARCHAR2 | 30 | Line class code identifier of transaction. | ||
| AUDIT_JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| AUDIT_JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_REP_AUDIT_DISTS_N1 | Non Unique | Default | LEDGER_ID, LEGAL_ENTITY_ID, APPLICATION_ID, ACCOUNTING_DATE |
| ZX_REP_AUDIT_DISTS_N2 | Non Unique | Default | LEGAL_REPORTING_STATUS, LEDGER_ID, LEGAL_ENTITY_ID, APPLICATION_ID, TAX_POINT_BASIS, TAX_POINT_DATE |
| ZX_REP_AUDIT_DISTS_N3 | Non Unique | Default | LEDGER_ID, LEGAL_ENTITY_ID, APPLICATION_ID, TRX_DATE |
| ZX_REP_AUDIT_DISTS_N4 | Non Unique | Default | REPORTING_BATCH_ID |
| ZX_REP_AUDIT_DISTS_U1 | Unique | Default | REP_TRX_TAX_DIST_ID |
| ZX_REP_AUDIT_DISTS_U2 | Unique | Default | TAX_LINE_ID, TAX_DIST_ID, PAYMENT_TRX_TAX_DIST_ID |