This set of views expose the data related to any organization. The set consists of the views described in the following table.
View | Description | Interpreted Columns | SQL Filename |
---|---|---|---|
YNA_ORGANIZATION _VW |
This view exposes data from the YFS_ ORGANIZATION table |
None |
|
YNA_ENTERPRISE_VW | This view exposes data from the YFS_ ENTERPRISE table |
None | YNA_ENTERPRISE_VW |
YNA_ENTERPRISE_PARTICIPANTS_VW | This view exposes limited columns from YFS_ORG _ENTERPRISE |
None |
|
YNA_ORG_ENTERPRISE_VW | This view exposes data from the YFS_ORG_ ENTERPRISE table |
None |
|
YNA_ORGANIZATION_SHIP_NODES _VW |
This view exposes the data in the YFS_SHIP_NODE.YFS_ PERSON_INFO table. It is based on the YFS_SHIP_NODE table and provides information about Ship Nodes in the IBM® Sterling Selling and Fulfillment Foundation system with the Contact Address and Ship Node Address information denormalized into the view. This view is used in multiple places in the Catalog. It is replicated into Organization Ship Nodes and Organization Receiving Nodes in the Business Layer (the base entity being Organization Distribution Nodes). These entities are further multiplied in the Package Layer. |
None |
|
YNA_ORGANIZATION_ USERS_NL_VW |
This view exposes the data in the YFS_USER.YFS_ PERSON_INFO table. It provides information about Users in the IBM Sterling Selling and Fulfillment Foundation system with the Contact Address and Billing Address information denormalized into the view. This view is not joined to the YFS_ Organization table. |
None |
|
YNA_ORGANIZATION_ NL_VW |
This view exposes the data in the YFS_ORGANIZATION. YFS_PERSON_INFO table. It provides information about any Organization in the IBM Sterling Selling and Fulfillment Foundation system with the Corporate Address, Contact Address and Billing Address information denormalized into the view. |
None |
|
YNA_ORGANIZATION_BUYER_ NL_VW |
This view exposes the data in the YFS_ORGANIZATION. YFS_ORG_ROLE.YFS_ROLE. YFS_PERSON_INFO table. It primarily contains columns from the YFS_ORGANZIATION table for Organizations that play the role of a Buyer in the IBM Sterling Selling and Fulfillment Foundation. The Corporate Address, Contact Address and the Billing Address information has been denormalized into the view. |
None |
|
YNA_ORGANIZATION_CARRIER_ NL_VW |
This view exposes the data in the YFS_ORGANIZATION.YFS_ ORG_ROLE.YFS_ROLE. YFS_PERSON_INFO table. It primarily contains columns from the YFS_ORGANZIATION table for an Organization that plays the role of a Carrier in the IBM Sterling Selling and Fulfillment Foundation. The Corporate Address, Contact Address and the Billing Address information has been denormalized into the view. |
None |
|
YNA_ORG_ENTERPRISE _NL_VW |
This view exposes the data in the YFS_ORGANIZATION .YFS_ORG_ROLE.YFS_ROLE. YFS_PERSON_INFO table. It primarily contains columns from the YFS_ORGANZIATION table for an Organization that plays the role of a Carrier in the IBM Sterling Selling and Fulfillment Foundation. The Corporate Address, Contact Address and the Billing Address information has been denormalized into the view. |
None |
|
YNA_ORG_SELLER_ NL_VW |
This view exposes the data in the YFS_ORGANIZATION. YFS_ORG_ROLE.YFS_ROLE. YFS_PERSON_INFO table. It primarily contains columns from the YFS_ORGANZIATION table for an Organization that plays the role of a Seller in the IBM Sterling Selling and Fulfillment Foundation. The Corporate Address, Contact Address and the Billing Address information has been denormalized into the view. |
None |
|
YNA_ORG_ROLE _VW |
This view returns all organizational along with their roles from the YFS_ORGANIZATION table. |
None |
|
YNA_VENDOR_VW | This view exposes data from the YFS_VENDOR table. |
None |
|
YNA_SHIP_NODE_ VW |
This view exposes data from the YFS_SHIP_NODE table |
None |
|