Order Header Views

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

Table 1. Order Header Views
View Description Interpreted Columns SQL Filename
YNA_ORDER_HEADER_VW This view exposes the data in the YFS_ORDER_HEADER table. None TRANSACTION/order_header_vw.sql

YNA_ORDER_HEADER_ADD

_VW

This view exposes limited columns from YFS_ORDER_HEADER None
TRANSACTION/Order_
Header.sql

YNA_ORDER_HEADER_

CHARGES_VW

This view exposes the data in the YFS_order_header_charges table for charges filtered for an order header. None
TRANSACTION/
Order_Header_
Charges.sql

YNA_ORDHDR_CHARGE_

TRANSN_VW

This view exposes the data in the YFS_CHARGE_TRANSACTION table. None
TRANSACTION/
Order_Header_
Charge_Xn.sql
YNA_ORDHDR_INSTRUCTION_VW This view exposes the data in the YFS_INSTRUCTION_DETAIL table. It exposes instruction details filtered for an Order Header. None
TRANSACTION/
Order_Header_
Instruction.sql
YNA_ORDHDR_TAX_VW This view exposes data in the YFS_TAX_BREAKUP table filtered for an Order Header. None
TRANSACTION/
Order_Header_
Tax.sql
YNA_ORDER_HOLD_TYPE_VW This view exposes the data in the YFS_ORDER_HOLD_TYPE table. None
TRANSACTION/
YNA_ORDER_HOLD_
TYPE_VW.sql
YNA_ORDER_HOLD_TYPE_LOG_VW This view exposes the data in the YFS_ORDER_HOLD_TYPE_LOG table. None
TRANSACTION/
YNA_ORDER_HOLD_
TYPE_LOG_VW.sql
YNA_CHARGE_TRAN_DIST_VW This view exposes the data in the YFS_CHARGE_TRAN_DIST table. None
TRANSACTION/
YNA_CHARGE_TRAN_
DIST_VW.sql