| Table Name: | extern_id |
| Table Number: | 5670 |
| Group: | System |
| Description: | This table stores the mapping between clarify objects and external objects |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| clarify_objid | LONG | int | DIRECT, ALLOW_NULL | Internal record number of the object to be externalized | ||||
| clarify_type | LONG | smallint | DIRECT, ALLOW_NULL | Type ID of the object to be externalized | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| ext_type | CHAR | varchar | 50 | The type of the entity in the external system | ||||
| extern_id | CHAR | varchar | 64 | A case sensitive string identifying external id within the scope of partner id | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | |||
| partner_id | CHAR | varchar | 64 | Identifies the partner company uniquely |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views | Set Name | Type ID Stored in | Objid Stored In |
|---|---|---|---|---|---|---|---|---|---|---|
| Exclusive Set Relations | ||||||||||
| extern_id2blg_argmnt | MTO | blg_argmnt | blg_argmnt2extern_id | One billing arrangement can be mapped to several different entities in the external systems | extern_for | clarify_type | clarify_objid | |||
| extern_id2fin_accnt | MTO | fin_accnt | fin_accnt2extern_id | One financial account can be mapped to several different entities in the external systems | extern_for | clarify_type | clarify_objid | |||
| extern_id2pp_bucket | MTO | pp_bucket | pp_bucket2extern_id | One pre-paid bucket can be mapped to several different entities in the external Systems | extern_for | clarify_type | clarify_objid | |||
| extern_id2rechrg_instrn | MTO | rechrg_instrn | rechrg_instrn2extern_id | The recurring pre paid instructions as presented in the external systems | extern_for | clarify_type | clarify_objid | |||
| extern_id2site_part | MTO | site_part | site_part2extern_id | One installed part can be mapped to several different entities in the external systems | extern_for | clarify_type | clarify_objid | |||
| Index Name | Fields | Flags |
|---|---|---|
| I5670_2 | partner_id:extern_id:ext_type | UNIQUE |
| I5670_3 | clarify_type:clarify_objid:partner_id |
| Index Name | Fields | Additional Information |
|---|---|---|
| co5670 | clarify_objid, clarify_type | nonclustered located on PRIMARY |
| I5670_2 | partner_id, extern_id, ext_type | nonclustered, unique located on PRIMARY |
| I5670_3 | clarify_type, clarify_objid, partner_id | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|
| extern_id | |||