| Table Name: | req_to_extern |
| Table Number: | 5758 |
| Group: | Billing Manager |
| Description: | Holds requests that need to be send to external systems |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| ack_counter | LONG | int | 0 | DIRECT | Counter to keep track of received acknowledgements from various systems. 0=Mean no response; More than 0 means external system has responded, default=0 | |||
| addnl_info | CHAR | text | ALLOW_NULL | XML string that captures additional information needed for the request to be sent | Search (1) | |||
| creation_time | CLK_TIME | datetime | Creation date and time | Search (1) | ||||
| description | CHAR | varchar | 255 | Description of activity that created the request | Search (1) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| is_ready | LONG | tinyint | 0 | DIRECT | 1=Ready to be send, 0=Not read, Default=0 | Search (1) | ||
| last_update | CLK_TIME | datetime | CHANGE_DATE | Date time of last update | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (1) | ||
| req_type | CHAR | varchar | 50 | Type of request | Search (1) | |||
| status | LONG | smallint | 1 | DIRECT | Status of request, 0=Hold, 1=Ready for send, 2=Waiting for approval,3=Sent, 4=Done, 5=Failed, 6=Rejected; Default - 1 | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| req_to_extern2blg_argmnt | MTO | blg_argmnt | blg_argmnt2req_to_extern | Billing arrangement's external request | Search (1) | ||
| req_to_extern2bus_org | MTO | bus_org | bus_org2req_to_extern | Customer (bus_org)'s external request | Search (1) | ||
| req_to_extern2fin_accnt | MTO | fin_accnt | fin_accnt2req_to_extern | Financial account's external request | Search (1) | ||
| req_to_extern2pay_means | MTO | pay_means | pay_means2req_to_extern | Pay Means's external request | Search (1) | ||
| req_to_extern2pp_bucket | MTO | pp_bucket | pp_bucket2req_to_extern | Pre-paid bucket's external request | Search (1) | ||
| req_to_extern2rechrg_instrn | MTO | rechrg_instrn | rechrg_instrn2req_to_extern | Recharge instruction's external request | Search (1) | ||
| req_to_extern2site_part | MTO | site_part | site_part2req_to_extern | Subscriber's external request |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| objindex | objid | clustered, unique located on PRIMARY |
| rte2ba5758 | req_to_extern2blg_argmnt | nonclustered located on PRIMARY |
| rte2bo5758 | req_to_extern2bus_org | nonclustered located on PRIMARY |
| rte2fa5758 | req_to_extern2fin_accnt | nonclustered located on PRIMARY |
| rte2pb5758 | req_to_extern2pp_bucket | nonclustered located on PRIMARY |
| rte2pm5758 | req_to_extern2pay_means | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5838 | req_to_extern_view | blg_argmnt, bus_org, fin_accnt, pay_means, pp_bucket, rechrg_instrn, req_to_extern |
| req_to_extern | |||