| View Name: | tr_filter_view |
| View Number: | 71 |
| Group: | Invoice Interface |
| Description: | Selects billing data for a Case |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | trans_record | objid | Trans_record internal record number | 3 (UNIQUE) |
| extract_date | trans_record | extract_date | Datetime of the extract | |
| case_id | case | id_number | Unique case number assigned based on auto-numbering definition | |
| site_id | c_site(site) | site_id | Unique site number assigned according to auto-numbering definition | |
| approved | trans_record | approved | Indicates the approved status of a detail record; i.e., 0=not approved, 1=approved | |
| district | c_site(site) | district | District to which the site belongs | |
| region | c_site(site) | region | District to which the site belongs | |
| bill_state | bill_addr(address) | state | State in site's billing address | |
| prim_state | prim_addr(address) | state | State in site's primary address | |
| ship_state | ship_addr(address) | state | State in site's shipping address | |
| bill_country | bill_country(country) | name | Country in site's billing address | |
| prim_country | prim_country(country) | name | Country in site's primary address | |
| ship_country | ship_country(country) | name | Country in site's shipping address | |
| site_name | c_site(site) | name | Name of the site |
| Join From | Join To |
|---|---|
| bill_addr(address).address2country | bill_country(country).country2address |
| prim_addr(address).address2country | prim_country(country).country2address |
| ship_addr(address).address2country | ship_country(country).country2address |
| c_site(site).cust_primaddr2address | prim_addr(address).primary_addr2site |
| c_site(site).cust_billaddr2address | bill_addr(address).bill_addr2site |
| c_site(site).cust_shipaddr2address | ship_addr(address).ship_addr2site |
| (trans_record).trans_record2site | c_site(site).site2trans_record |
| (trans_record).trans_record2case | (case).case2trans_record |
| tr_filter_view | |||