Order Line Views

This set of views expose the Order Line-related data. The set consists of the views described in the following table.

Table 1. Order Line Views
View Description Interpreted Columns SQL Filename

YNA_ORDER_KIT_LINE_VW

This view exposes the data in the YFS_ORDER_KIT_LINE table.

None
TRANSACTION/
Order_Kit_Line.sql
YNA_ORDER_LINE_VW

This view exposes the data in the YFS_ORDER_LINE table.

None
TRANSACTION/
order_line_vw.sql
YNA_ORDER_LINE_ADD_VW

This view exposes limited columns from YFS_ORDER_LINE

None
TRANSACTION/
Order_Line.sql

YNA_ORDER_LINE_

CHARGES_VW

This view exposes the data in the YFS_ORDER_LINE_CHARGES

table filtered for an Order.

None
TRANSACTION/
Order_Line_Charges.sql
YNA_ORDER_LINE_DS_VW

This view exposes the data in the YFS_ORDER_

LINE.YFS_ORDER_HEADER.

YFS_PERSON_INFO table.

None
TRANSACTION/
Order_Line_Delivery_Srvc.sql

YNA_ORDER_LINE_

OPTION_VW

This view exposes the data in the YFS_ORDER_

LINE_OPTION table.

None
TRANSACTION/
Order_Line_Option.sql

YNA_ORDER_LINE_

PROD_VW

This view exposes the data in the YFS_ORDERLINE.YFS_ORDER_

HEADER.YFS_PERSON_INFO table.

None
TRANSACTION/
Order_Line_Prod.sql
YNA_ORDER_LINE_PS_VW

This view exposes the data in the YFS_ORDER_PROD_SER_ASSOC,

YFS_ORDER_LINE table.

None
TRANSACTION/
Order_Line_Provided_Srvc.sql

YNA_ORDER_LINE_

REQ_TAG_VW

This view exposes the data in the YFS_ORDER_

LINE_REQ_TAG table.

None
TRANSACTION/
Order_Line_Req_Tag.sql

YNA_ORDER_LINE_

SCHEDULE_VW

This view exposes the data in the YFS_ORDER_

LINE_SCHEDULE table.

None
TRANSACTION/
order_line_schedule_vw.sql

YNA_ORDER_PROD_

SER_ASSOC_VW

This view exposes the data in the YFS_ORDER_

PROD_SER_ASSOC table.

None
TRANSACTION/
\Order_Prod_Srvc_Assoc.sql
YNA_ORDLINE_INSTR_VW

This view exposes the instruction details data in the YFS_

INSTRUCTION_DETAIL_H table for an Order Line.

None
TRANSACTION/
Order_Line_Instruction.sql
YNA_ORDLINE_TAX_VW

This view exposes the data in the YFS_TAX_

BREAKUP table filtered for an Order Line.

None
TRANSACTION/
Order_Line_Tax.sql