View Name: | vw_addr_blg_argmnt |
View Number: | 5719 |
Group: | Billing Manager |
Description: | Used by form 706, 11650,11651,11652,11653,11654,11656,11657,11658,11659,11660,11661,11662,11663,11664,11665,11666,11667,11668,11669,11670,11671,16030,16100,16110,16150 |
Flags: | VIEW_OPTIMIZED |
Baseline/Custom: | Baseline |
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
---|---|---|---|---|
role_objid | addr_ba_role | objid | Addr_ba_role internal record number | 3 (UNIQUE) |
add_objid | address | objid | Address internal record number | |
ba_objid | blg_argmnt | objid | Billing arrangement internal record number | |
address | address | address | Contact's first name | |
address_2 | address | address_2 | Contact's last name | |
role_name | addr_ba_role | role_name | Name of the role | |
ba_name | blg_argmnt | name | Name of billing arrangement | |
country_name | country | name | Name of the specific country | |
state_prov_name | state_prov | name | State or province name | |
city | address | city | The city for the specified address | |
state_full_name | state_prov | full_name | State or province full name | |
zipcode | address | zipcode | The zip or other postal code for the specified address | |
ba_ext_src | blg_argmnt_extern | ext_src | The name of the system that manages the Billing arrangement (e.g., Ensemble, Kenan) | |
ba_ext_ref | blg_argmnt_extern | ext_ref | The identifier of the billing arrangement from the external system | |
ba_ext_objid | blg_argmnt_extern | objid | blg_argmnt_extern internal record number |
Join From | Join To |
---|---|
(addr_ba_role).blg_argmnt_role2blg_argmnt | (blg_argmnt).blg_argmnt2addr_ba_role |
(addr_ba_role).address_role2address | (address).address2addr_ba_role |
(address).address2country | (country).country2address |
(address).address2state_prov | (state_prov).state_prov2address |
(blg_argmnt_extern).blg_argmnt_extern2blg_argmnt | (blg_argmnt).blg_argmnt2blg_argmnt_extern |
vw_addr_blg_argmnt | |||