| Table Name: | blg_argmnt_extern |
| Table Number: | 5709 |
| Group: | Billing Manager |
| Description: | This table stores foreign key mapping between billing arrangement and external system |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| ext_ref | CHAR | varchar | 64 | ALLOW_NULL | The identifier of the billing arrangement in the external system | Search (6) | ||
| ext_src | CHAR | varchar | 30 | The name of the system that manages the Billing arrangement (e.g., Ensemble, Kenan) | Search (6) | |||
| last_update | CLK_TIME | datetime | CHANGE_DATE | Date time of last update | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (6) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| blg_argmnt_extern2blg_argmnt | MTO | blg_argmnt | blg_argmnt2blg_argmnt_extern | blg_argmnt related to the external system | Search (6) |
| Index Name | Fields | Flags |
|---|---|---|
| I5709 | ext_ref:ext_src | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| bae2ba5709 | blg_argmnt_extern2blg_argmnt | nonclustered located on PRIMARY |
| I5709 | ext_ref, ext_src | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| blg_argmnt_extern | |||