Hospitality Category

This ERD (see the following figure) illustrates how Siebel Hospitality supports the categorization for revenue. There can be N levels of the revenue category in the hierarchy. One parent category can include one or more categories, and one category can include one or more subcategories. The subcategory is defined for the charge code and product, and a report is generated by category for each function and quote. Function and quote revenue by category hierarchy supports the hierarchical category. A macro estimate for the opportunity and quote is generated at the category level.

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
Hospitality Category	S_CTLG_CAT
Parent Category	S_CTLG_CAT
Category	S_CTLG_CAT
Subcategory	S_CTLG_CAT
Category Revenue	S_AVG_VAL_TNT, S_FN_CATRV_TNT, S_QUO_CATRV_TNT
Function Average Level	S_AVG_VAL_TNT
Function Revenue by Category	S_FN_CATRV_TNT
Quote Revenue by Category	S_QUO_CATRV_TNT
Quote Macro Revenue Estimate	S_QUO_MEST_TNT
Opportunity Macro Revenue Estimate	S_OPTY_MEST_TNT
Charge Code	S_EVT_CHRG_LST
Function Business Type by Date	S_BIZ_TP_DT_TNT
Function	S_FUNC_TNT
Function Report Section	S_FUNC_RPT_SECT
Property Report Section	S_PROP_RPT_SECT
Report Section	S_RPT_SECT_TNT
Property/Asset	S_ORG_EXT
Quote	S_DOC_QUOTE
Opportunity	S_OPTY
Product or Service	S_PROD_INT
Tax/Service List	S_PRI_LST