This set of views expose the Order Header related data. The set consists of the views described in the following table.
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 |
|
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 |
|
YNA_ORDHDR_CHARGE_ TRANSN_VW |
This view exposes the data in the YFS_CHARGE_TRANSACTION table. | None |
|
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 |
|
YNA_ORDHDR_TAX_VW | This view exposes data in the YFS_TAX_BREAKUP table filtered for an Order Header. | None |
|
YNA_ORDER_HOLD_TYPE_VW | This view exposes the data in the YFS_ORDER_HOLD_TYPE table. | None |
|
YNA_ORDER_HOLD_TYPE_LOG_VW | This view exposes the data in the YFS_ORDER_HOLD_TYPE_LOG table. | None |
|
YNA_CHARGE_TRAN_DIST_VW | This view exposes the data in the YFS_CHARGE_TRAN_DIST table. | None |
|