ZCX_REF_ENTITIES
Extensibility Reference Entities
Details
-
Schema: FUSION
-
Object owner: ZCX
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
ZCX_REF_ENTITIES_PK |
EFF_LINE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
EFF_LINE_ID | NUMBER | 18 | Yes | EFF_LINE_ID | |
REF_PAR_ID | NUMBER | 18 | Yes | REF_PAR_ID | |
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Yes | Descriptive Flexfield: structure definition of the user descriptive flexfield. | |
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
CONFLICT_ID | NUMBER | 18 | Yes | Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). | |
CPDRF_VER_SOR | NUMBER | 9 | CPDRF_VER_SOR | ||
CPDRF_VER_PILLAR | NUMBER | 9 | CPDRF_VER_PILLAR | ||
CPDRF_LAST_UPD | VARCHAR2 | 15 | CPDRF_LAST_UPD | ||
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. | ||
USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). | |||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID 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. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
CURRENCY_CODE | VARCHAR2 | 15 | Entered Amount Currency Code | ||
CORP_CURRENCY_CODE | VARCHAR2 | 15 | CRM Profile Corporate Currency Code | ||
CURCY_CONV_RATE_TYPE | VARCHAR2 | 30 | CRM Profile Currency Conversion Rate Type | ||
EXTN_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR1 | ||
EXTN_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR2 | ||
EXTN_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR3 | ||
EXTN_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR4 | ||
EXTN_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR5 | ||
EXTN_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR6 | ||
EXTN_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR7 | ||
EXTN_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR8 | ||
EXTN_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR9 | ||
EXTN_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR10 | ||
EXTN_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR11 | ||
EXTN_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR12 | ||
EXTN_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR13 | ||
EXTN_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR14 | ||
EXTN_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR15 | ||
EXTN_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR16 | ||
EXTN_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR17 | ||
EXTN_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR18 | ||
EXTN_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR19 | ||
EXTN_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR20 | ||
EXTN_ATTRIBUTE_CHAR21 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR21 | ||
EXTN_ATTRIBUTE_CHAR22 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR22 | ||
EXTN_ATTRIBUTE_CHAR23 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR23 | ||
EXTN_ATTRIBUTE_CHAR24 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR24 | ||
EXTN_ATTRIBUTE_CHAR25 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR25 | ||
EXTN_ATTRIBUTE_CHAR26 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR26 | ||
EXTN_ATTRIBUTE_CHAR27 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR27 | ||
EXTN_ATTRIBUTE_CHAR28 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR28 | ||
EXTN_ATTRIBUTE_CHAR29 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR29 | ||
EXTN_ATTRIBUTE_CHAR30 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR30 | ||
EXTN_ATTRIBUTE_CHAR31 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR31 | ||
EXTN_ATTRIBUTE_CHAR32 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR32 | ||
EXTN_ATTRIBUTE_CHAR33 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR33 | ||
EXTN_ATTRIBUTE_CHAR34 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR34 | ||
EXTN_ATTRIBUTE_CHAR35 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR35 | ||
EXTN_ATTRIBUTE_CHAR36 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR36 | ||
EXTN_ATTRIBUTE_CHAR37 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR37 | ||
EXTN_ATTRIBUTE_CHAR38 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR38 | ||
EXTN_ATTRIBUTE_CHAR39 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR39 | ||
EXTN_ATTRIBUTE_CHAR40 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR40 | ||
EXTN_ATTRIBUTE_CHAR41 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR41 | ||
EXTN_ATTRIBUTE_CHAR42 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR42 | ||
EXTN_ATTRIBUTE_CHAR43 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR43 | ||
EXTN_ATTRIBUTE_CHAR44 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR44 | ||
EXTN_ATTRIBUTE_CHAR45 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR45 | ||
EXTN_ATTRIBUTE_CHAR46 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR46 | ||
EXTN_ATTRIBUTE_CHAR47 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR47 | ||
EXTN_ATTRIBUTE_CHAR48 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR48 | ||
EXTN_ATTRIBUTE_CHAR49 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR49 | ||
EXTN_ATTRIBUTE_CHAR50 | VARCHAR2 | 150 | EXTN_ATTRIBUTE_CHAR50 | ||
EXTN_ATTRIBUTE_NUMBER1 | NUMBER | EXTN_ATTRIBUTE_NUMBER1 | |||
EXTN_ATTRIBUTE_NUMBER2 | NUMBER | EXTN_ATTRIBUTE_NUMBER2 | |||
EXTN_ATTRIBUTE_NUMBER3 | NUMBER | EXTN_ATTRIBUTE_NUMBER3 | |||
EXTN_ATTRIBUTE_NUMBER4 | NUMBER | EXTN_ATTRIBUTE_NUMBER4 | |||
EXTN_ATTRIBUTE_NUMBER5 | NUMBER | EXTN_ATTRIBUTE_NUMBER5 | |||
EXTN_ATTRIBUTE_NUMBER6 | NUMBER | EXTN_ATTRIBUTE_NUMBER6 | |||
EXTN_ATTRIBUTE_NUMBER7 | NUMBER | EXTN_ATTRIBUTE_NUMBER7 | |||
EXTN_ATTRIBUTE_NUMBER8 | NUMBER | EXTN_ATTRIBUTE_NUMBER8 | |||
EXTN_ATTRIBUTE_NUMBER9 | NUMBER | EXTN_ATTRIBUTE_NUMBER9 | |||
EXTN_ATTRIBUTE_NUMBER10 | NUMBER | EXTN_ATTRIBUTE_NUMBER10 | |||
EXTN_ATTRIBUTE_NUMBER11 | NUMBER | EXTN_ATTRIBUTE_NUMBER11 | |||
EXTN_ATTRIBUTE_NUMBER12 | NUMBER | EXTN_ATTRIBUTE_NUMBER12 | |||
EXTN_ATTRIBUTE_NUMBER13 | NUMBER | EXTN_ATTRIBUTE_NUMBER13 | |||
EXTN_ATTRIBUTE_NUMBER14 | NUMBER | EXTN_ATTRIBUTE_NUMBER14 | |||
EXTN_ATTRIBUTE_NUMBER15 | NUMBER | EXTN_ATTRIBUTE_NUMBER15 | |||
EXTN_ATTRIBUTE_NUMBER16 | NUMBER | EXTN_ATTRIBUTE_NUMBER16 | |||
EXTN_ATTRIBUTE_NUMBER17 | NUMBER | EXTN_ATTRIBUTE_NUMBER17 | |||
EXTN_ATTRIBUTE_NUMBER18 | NUMBER | EXTN_ATTRIBUTE_NUMBER18 | |||
EXTN_ATTRIBUTE_NUMBER19 | NUMBER | EXTN_ATTRIBUTE_NUMBER19 | |||
EXTN_ATTRIBUTE_NUMBER20 | NUMBER | EXTN_ATTRIBUTE_NUMBER20 | |||
EXTN_ATTRIBUTE_NUMBER21 | NUMBER | EXTN_ATTRIBUTE_NUMBER21 | |||
EXTN_ATTRIBUTE_NUMBER22 | NUMBER | EXTN_ATTRIBUTE_NUMBER22 | |||
EXTN_ATTRIBUTE_NUMBER23 | NUMBER | EXTN_ATTRIBUTE_NUMBER23 | |||
EXTN_ATTRIBUTE_NUMBER24 | NUMBER | EXTN_ATTRIBUTE_NUMBER24 | |||
EXTN_ATTRIBUTE_NUMBER25 | NUMBER | EXTN_ATTRIBUTE_NUMBER25 | |||
EXTN_ATTRIBUTE_NUMBER26 | NUMBER | EXTN_ATTRIBUTE_NUMBER26 | |||
EXTN_ATTRIBUTE_NUMBER27 | NUMBER | EXTN_ATTRIBUTE_NUMBER27 | |||
EXTN_ATTRIBUTE_NUMBER28 | NUMBER | EXTN_ATTRIBUTE_NUMBER28 | |||
EXTN_ATTRIBUTE_NUMBER29 | NUMBER | EXTN_ATTRIBUTE_NUMBER29 | |||
EXTN_ATTRIBUTE_NUMBER30 | NUMBER | EXTN_ATTRIBUTE_NUMBER30 | |||
EXTN_ATTRIBUTE_NUMBER31 | NUMBER | EXTN_ATTRIBUTE_NUMBER31 | |||
EXTN_ATTRIBUTE_NUMBER32 | NUMBER | EXTN_ATTRIBUTE_NUMBER32 | |||
EXTN_ATTRIBUTE_NUMBER33 | NUMBER | EXTN_ATTRIBUTE_NUMBER33 | |||
EXTN_ATTRIBUTE_NUMBER34 | NUMBER | EXTN_ATTRIBUTE_NUMBER34 | |||
EXTN_ATTRIBUTE_NUMBER35 | NUMBER | EXTN_ATTRIBUTE_NUMBER35 | |||
EXTN_ATTRIBUTE_NUMBER36 | NUMBER | EXTN_ATTRIBUTE_NUMBER36 | |||
EXTN_ATTRIBUTE_NUMBER37 | NUMBER | EXTN_ATTRIBUTE_NUMBER37 | |||
EXTN_ATTRIBUTE_NUMBER38 | NUMBER | EXTN_ATTRIBUTE_NUMBER38 | |||
EXTN_ATTRIBUTE_NUMBER39 | NUMBER | EXTN_ATTRIBUTE_NUMBER39 | |||
EXTN_ATTRIBUTE_NUMBER40 | NUMBER | EXTN_ATTRIBUTE_NUMBER40 | |||
EXTN_ATTRIBUTE_NUMBER41 | NUMBER | EXTN_ATTRIBUTE_NUMBER41 | |||
EXTN_ATTRIBUTE_NUMBER42 | NUMBER | EXTN_ATTRIBUTE_NUMBER42 | |||
EXTN_ATTRIBUTE_NUMBER43 | NUMBER | EXTN_ATTRIBUTE_NUMBER43 | |||
EXTN_ATTRIBUTE_NUMBER44 | NUMBER | EXTN_ATTRIBUTE_NUMBER44 | |||
EXTN_ATTRIBUTE_NUMBER45 | NUMBER | EXTN_ATTRIBUTE_NUMBER45 | |||
EXTN_ATTRIBUTE_NUMBER46 | NUMBER | EXTN_ATTRIBUTE_NUMBER46 | |||
EXTN_ATTRIBUTE_NUMBER47 | NUMBER | EXTN_ATTRIBUTE_NUMBER47 | |||
EXTN_ATTRIBUTE_NUMBER48 | NUMBER | EXTN_ATTRIBUTE_NUMBER48 | |||
EXTN_ATTRIBUTE_NUMBER49 | NUMBER | EXTN_ATTRIBUTE_NUMBER49 | |||
EXTN_ATTRIBUTE_NUMBER50 | NUMBER | EXTN_ATTRIBUTE_NUMBER50 | |||
EXTN_ATTRIBUTE_FKNUM1 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM1 | ||
EXTN_ATTRIBUTE_FKNUM2 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM2 | ||
EXTN_ATTRIBUTE_FKNUM3 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM3 | ||
EXTN_ATTRIBUTE_FKNUM4 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM4 | ||
EXTN_ATTRIBUTE_FKNUM5 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM5 | ||
EXTN_ATTRIBUTE_FKNUM6 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM6 | ||
EXTN_ATTRIBUTE_FKNUM7 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM7 | ||
EXTN_ATTRIBUTE_FKNUM8 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM8 | ||
EXTN_ATTRIBUTE_FKNUM9 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM9 | ||
EXTN_ATTRIBUTE_FKNUM10 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM10 | ||
EXTN_ATTRIBUTE_FKNUM11 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM11 | ||
EXTN_ATTRIBUTE_FKNUM12 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM12 | ||
EXTN_ATTRIBUTE_FKNUM13 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM13 | ||
EXTN_ATTRIBUTE_FKNUM14 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM14 | ||
EXTN_ATTRIBUTE_FKNUM15 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM15 | ||
EXTN_ATTRIBUTE_FKNUM16 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM16 | ||
EXTN_ATTRIBUTE_FKNUM17 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM17 | ||
EXTN_ATTRIBUTE_FKNUM18 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM18 | ||
EXTN_ATTRIBUTE_FKNUM19 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM19 | ||
EXTN_ATTRIBUTE_FKNUM20 | NUMBER | 18 | EXTN_ATTRIBUTE_FKNUM20 | ||
EXTN_ATTRIBUTE_DATE1 | DATE | EXTN_ATTRIBUTE_DATE1 | |||
EXTN_ATTRIBUTE_DATE2 | DATE | EXTN_ATTRIBUTE_DATE2 | |||
EXTN_ATTRIBUTE_DATE3 | DATE | EXTN_ATTRIBUTE_DATE3 | |||
EXTN_ATTRIBUTE_DATE4 | DATE | EXTN_ATTRIBUTE_DATE4 | |||
EXTN_ATTRIBUTE_DATE5 | DATE | EXTN_ATTRIBUTE_DATE5 | |||
EXTN_ATTRIBUTE_DATE6 | DATE | EXTN_ATTRIBUTE_DATE6 | |||
EXTN_ATTRIBUTE_DATE7 | DATE | EXTN_ATTRIBUTE_DATE7 | |||
EXTN_ATTRIBUTE_DATE8 | DATE | EXTN_ATTRIBUTE_DATE8 | |||
EXTN_ATTRIBUTE_DATE9 | DATE | EXTN_ATTRIBUTE_DATE9 | |||
EXTN_ATTRIBUTE_DATE10 | DATE | EXTN_ATTRIBUTE_DATE10 | |||
EXTN_ATTRIBUTE_DATE11 | DATE | EXTN_ATTRIBUTE_DATE11 | |||
EXTN_ATTRIBUTE_DATE12 | DATE | EXTN_ATTRIBUTE_DATE12 | |||
EXTN_ATTRIBUTE_DATE13 | DATE | EXTN_ATTRIBUTE_DATE13 | |||
EXTN_ATTRIBUTE_DATE14 | DATE | EXTN_ATTRIBUTE_DATE14 | |||
EXTN_ATTRIBUTE_DATE15 | DATE | EXTN_ATTRIBUTE_DATE15 | |||
EXTN_ATTRIBUTE_DATE16 | DATE | EXTN_ATTRIBUTE_DATE16 | |||
EXTN_ATTRIBUTE_DATE17 | DATE | EXTN_ATTRIBUTE_DATE17 | |||
EXTN_ATTRIBUTE_DATE18 | DATE | EXTN_ATTRIBUTE_DATE18 | |||
EXTN_ATTRIBUTE_DATE19 | DATE | EXTN_ATTRIBUTE_DATE19 | |||
EXTN_ATTRIBUTE_DATE20 | DATE | EXTN_ATTRIBUTE_DATE20 | |||
EXTN_ATTRIBUTE_BOOL1 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL2 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL3 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL4 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL5 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL6 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL7 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL8 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL9 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL10 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL11 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL12 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL13 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL14 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_BOOL15 | VARCHAR2 | 1 | Extensibility Boolean Flex Column | ||
EXTN_ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP11 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP12 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP13 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP14 | TIMESTAMP | Extensibility Timestamp Flex Column | |||
EXTN_ATTRIBUTE_TIMESTAMP15 | TIMESTAMP | Extensibility Timestamp Flex Column |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
ZCX_REF_ENTITIES | zcx_ref_entities_parent | REF_PAR_ID |
zcx_ref_entities_xm | zcx_ref_entities | REF_PAR_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
ZCX_REF_ENTITIES_N1 | Non Unique | Default | ATTRIBUTE_CATEGORY |
ZCX_REF_ENTITIES_N10 | Non Unique | Default | EXTN_ATTRIBUTE_FKNUM1 |
ZCX_REF_ENTITIES_N11 | Non Unique | Default | EXTN_ATTRIBUTE_FKNUM2 |
ZCX_REF_ENTITIES_N12 | Non Unique | Default | EXTN_ATTRIBUTE_FKNUM3 |
ZCX_REF_ENTITIES_N13 | Non Unique | Default | EXTN_ATTRIBUTE_FKNUM4 |
ZCX_REF_ENTITIES_N14 | Non Unique | Default | EXTN_ATTRIBUTE_FKNUM5 |
ZCX_REF_ENTITIES_N15 | Non Unique | Default | EXTN_ATTRIBUTE_FKNUM6 |
ZCX_REF_ENTITIES_N16 | Non Unique | Default | EXTN_ATTRIBUTE_FKNUM7 |
ZCX_REF_ENTITIES_N17 | Non Unique | Default | EXTN_ATTRIBUTE_FKNUM8 |
ZCX_REF_ENTITIES_N18 | Non Unique | Default | EXTN_ATTRIBUTE_FKNUM9 |
ZCX_REF_ENTITIES_N19 | Non Unique | Default | EXTN_ATTRIBUTE_FKNUM10 |
ZCX_REF_ENTITIES_N2 | Non Unique | Default | EXTN_ATTRIBUTE_CHAR1 |
ZCX_REF_ENTITIES_N20 | Non Unique | Default | EXTN_ATTRIBUTE_DATE1 |
ZCX_REF_ENTITIES_N21 | Non Unique | Default | EXTN_ATTRIBUTE_DATE2 |
ZCX_REF_ENTITIES_N22 | Non Unique | Default | EXTN_ATTRIBUTE_DATE3 |
ZCX_REF_ENTITIES_N23 | Non Unique | Default | CONFLICT_ID, ATTRIBUTE_CATEGORY |
ZCX_REF_ENTITIES_N3 | Non Unique | Default | EXTN_ATTRIBUTE_CHAR2 |
ZCX_REF_ENTITIES_N4 | Non Unique | Default | EXTN_ATTRIBUTE_CHAR3 |
ZCX_REF_ENTITIES_N5 | Non Unique | Default | EXTN_ATTRIBUTE_CHAR4 |
ZCX_REF_ENTITIES_N6 | Non Unique | Default | EXTN_ATTRIBUTE_CHAR5 |
ZCX_REF_ENTITIES_N7 | Non Unique | Default | EXTN_ATTRIBUTE_NUMBER1 |
ZCX_REF_ENTITIES_N8 | Non Unique | Default | EXTN_ATTRIBUTE_NUMBER2 |
ZCX_REF_ENTITIES_N9 | Non Unique | Default | EXTN_ATTRIBUTE_NUMBER3 |
ZCX_REF_ENTITIES_PK | Unique | Default | EFF_LINE_ID |