Organization Views

This set of views expose the data related to any organization. The set consists of the views described in the following table.

Table 1. Organization Views
View Description Interpreted Columns SQL Filename

YNA_ORGANIZATION

_VW

This view exposes data from the YFS_

ORGANIZATION table

None
CONFIGURATION/
organization_vw.sql
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
CONFIGURATION/Organization_
Enterprise_Participants.sql
YNA_ORG_ENTERPRISE_VW

This view exposes data from the YFS_ORG_

ENTERPRISE table

None
CONFIGURATION/
org_enterprise_vw.sql

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
CONFIGURATION/Organization_
Ship_Nodes.sql

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
MASTER/
Organization_UsersNL.sql

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
CONFIGURATION/
OrganizationNL.sql

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
CONFIGURATION/
Organization_BuyerNL.sql

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
CONFIGURATION/
Organization_CarrierNL.sql

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
CONFIGURATION/
Organization_EnterpriseNL.sql

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
CONFIGURATION/
Organization_SellerNL.sql

YNA_ORG_ROLE

_VW

This view returns all organizational along with their roles from the YFS_ORGANIZATION table.

None
CONFIGURATION/
Organization_Role.sql
YNA_VENDOR_VW

This view exposes data from the YFS_VENDOR table.

None
MASTER/
Vendor.sql

YNA_SHIP_NODE_

VW

This view exposes data from the YFS_SHIP_NODE table

None
CONFIGURATION/
ship_node_vw.sql