| Table Name: | lit_req |
| Table Number: | 5309 |
| Group: | Sales Mgr |
| Description: | Header template for the shipment (see lit_ship_req) of a literature request |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| comments | CHAR | varchar | 255 | Comments about the literature request | Search (1) | |||
| create_date | CLK_TIME | datetime | Date the template was created | Search (1) | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| fulfilled_date | CLK_TIME | datetime | Date that shipment to the addressees was completed | Search (1) | ||||
| lit_req_id | CHAR | varchar | 4 | 40 | Unique ID number of the template; assigned according to auto-numbering definition | Search (2) | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (2) | ||
| required_date | CLK_TIME | datetime | Date that shipment to the addressees is required (lit_ship_req) | Search (1) | ||||
| ship_via | CHAR | varchar | 40 | Requested means of shipment. This is from a Clarify-defined popup list with default name SHIP_VIA | Search (1) | |||
| title | CHAR | varchar | 2 | 80 | Title of the literature request | Search (2) |
| 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 | ||||||||||
| lit_req2doc_inst | OTM | doc_inst | doc_inst2lit_req | Soft copy items to be shipped | ||||||
| lit_send2gbst_elm | MTO | gbst_elm | send_type2lit_req | The sending method for the template | Search (1) | |||||
| lit_status2gbst_elm | MTO | gbst_elm | status2lit_req | The status of the template | Search (1) | |||||
| lit_req2lit_req_itm | OTM | lit_req_itm | lit_req_itm2lit_req | Part items to be shipped | ||||||
| lit_req2lit_ship_req | OTM | lit_ship_req | lit_ship_req2lit_req | Related shipments | ||||||
| lit_req2task | OTM | task | task2lit_req | Related action items | ||||||
| lit_req2topic | OTM | topic | topic2lit_req | Literature Request related to this topic | interaction_for | focus_type | focus_lowid | |||
| lit_owner2user | MTO | user | lit_owner2lit_req | User owning the template | Search (1) | |||||
| lit_orig2user | MTO | user | lit_orig2lit_req | User originating the template | ||||||
| Index Name | Fields | Flags |
|---|---|---|
| lit_req_ind | lit_req_id | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_lit_orig2user | lit_orig2user | nonclustered located on PRIMARY |
| ind_lit_owner2user | lit_owner2user | nonclustered located on PRIMARY |
| lit_req_ind | lit_req_id | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 5229 | lit_req_view | gbst_elm, lit_req, user |
| 5359 | sfa_tsk_mto_v | bus_org, contact, lead, lit_req, opportunity, task |
| lit_req | |||