Invoicing Views

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

Table 1. Invoicing Views
View Description Interpreted Columns SQL Filename
YNA_INVOICE_COLLECTION_VW

This view exposes the data in the YFS_INVOICE

_COLLECTION table.

None
TRANSACTION/
Invoicing_Collection.sql

YNA_INVOICE_HEADER_CHARGES

_VW

This view exposes the data in the YFS_HEADER_CHARGES table. It also exposes the YFS_HEADER_CHARGES table filtered for Header Charges related to Invoicing.

None
TRANSACTION/
Invoicing_Header_
Charges.sql
YNA_INVOICE_LINE_CHARGES_VW

This view exposes the YFS_LINE_CHARGES table for the Line Charges related to Invoicing.

None
TRANSACTION/
Invoicing_Line_
Charges.sql
YNA_INVOICE_LINE_TAX_VW

This view exposes the YFS_TAX_BREAKUP table filtered for Taxes related to Invoicing.It is used for Line Taxes.

None
TRANSACTION/
Invoicing_Line_
Tax.sql
YNA_INVOICE_ORDER_DETAIL_VW

This view exposes the data in the YFS_ORDER_

INVOICE_DETAIL table.

None
TRANSACTION/
Invoicing_Order_
Detail.sql
YNA_INVOICE_TAX_CHARGES_VW

This view exposes the YFS_TAX_BREAKUP table filtered for Taxes related to Invoicing. It is used for Header Taxes.

None
TRANSACTION/
Invoicing_Tax_
Breakup.sql
YNA_INVOICE_ORDER_VW

This view exposes the data in the YFS_ORDER_INVOICE table.

None
TRANSACTION/
Invoicing_
Order.sql