ZX_REP_CONTEXT_T
Used for Business Unit address information, if the report is run at the Ledger or Business Unit level. If the report is run at the Legal Entity level it contains Legal Entity information.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZX_REP_CONTEXT_T_PK |
REP_CONTEXT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REP_CONTEXT_ID | NUMBER | 18 | Yes | Unique identifier | |
| REP_ENTITY_ID | NUMBER | 18 | Operating unit identifier or legal entity identifier based on whether this reporting context is for operating unit based reports or legal entity based reports | ||
| ORG_INFORMATION2 | VARCHAR2 | 150 | Tax registration number | ||
| REP_CONTEXT_ENTITY_LOCATION_ID | NUMBER | 18 | Location identifier for this reporting context | ||
| REP_CONTEXT_ENTITY_NAME | VARCHAR2 | 240 | Legal entity name or Operating unit name for this report context | ||
| REP_CONTEXT_ENTITY_CITY | VARCHAR2 | 120 | City field for the address of this report context | ||
| REP_CONTEXT_ENTITY_COUNTY | VARCHAR2 | 120 | County field for the address of this report context | ||
| REP_CONTEXT_ENTITY_STATE | VARCHAR2 | 120 | State field for the address of this report context | ||
| REP_CONTEXT_ENTITY_PROVINCE | VARCHAR2 | 120 | Province field for the address of this report context | ||
| REP_CONTEXT_ENTITY_ADDRESS1 | VARCHAR2 | 240 | Address line 1 of this report context | ||
| REP_CONTEXT_ENTITY_ADDRESS2 | VARCHAR2 | 240 | Address line 2 of this report context | ||
| REP_CONTEXT_ENTITY_ADDRESS3 | VARCHAR2 | 240 | Address line 3 of this report context | ||
| REP_CONTEXT_ENTITY_COUNTRY | VARCHAR2 | 60 | Country code of the address for this report context | ||
| REP_CONTEXT_ENTITY_POSTAL_CODE | VARCHAR2 | 30 | Postal code field of the address for this report context | ||
| REP_CONTEXT_ENTITY_TEL_NUMBER | VARCHAR2 | 60 | Telephone number field of the address for this report context | ||
| REP_CONTEXT_LVL_MNG | VARCHAR2 | 80 | Reporting context level description | ||
| REP_CONTEXT_LVL_CODE | VARCHAR2 | 30 | Lookup code to indicate whether this reporting context is at the level of ledger or legal entity or a single operating unit or multiple operating units. | ||
| EXTRACT_SUMMARY_CODE | VARCHAR2 | 30 | Lookup code to indicate the summary level at which the data is extracted for this report context | ||
| MATRIX_REPORT_FLAG | VARCHAR2 | 1 | Y or N indicates whether this report context is for matrix reports | ||
| LEGAL_CONTACT_PRE_NAME_ADJUNCT | VARCHAR2 | 30 | Title of the legal contact | ||
| LEGAL_CONTACT_PARTY_NAME | VARCHAR2 | 360 | Legal contact name | ||
| TAXPAYER_ID | VARCHAR2 | 30 | Tax payer identifier | ||
| LEGAL_CONTACT_TITLE | VARCHAR2 | 100 | Job title of the legal contact | ||
| ACTIVITY_CODE | VARCHAR2 | 150 | Activity code | ||
| SUB_ACTIVITY_CODE | VARCHAR2 | 150 | Sub activity code | ||
| INCEPTION_DATE | DATE | Inception date | |||
| LEGAL_CONTACT_PARTY_NUM | VARCHAR2 | 30 | Legal contact party number | ||
| LEGAL_AUTH_ADDRESS_LINE2 | VARCHAR2 | 240 | Legal authority address line 2 | ||
| LEGAL_AUTH_ADDRESS_LINE3 | VARCHAR2 | 240 | Legal authority address line 3 | ||
| LEGAL_AUTH_CITY | VARCHAR2 | 60 | Legal authority city | ||
| 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. | ||
| REQUEST_ID | NUMBER | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Application identifier of last concurrent program to update this record | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Program identifier of last concurrent program to update this record | ||
| PROGRAM_LOGIN_ID | NUMBER | Login user identifier of last concurrent program to update this record | |||
| 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. | ||
| LEGAL_AUTHORITY_NAME | VARCHAR2 | 360 | Legal authority name |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_REP_CONTEXT_T_U1 | Unique | Default | REP_CONTEXT_ID |