# View: cdsus_billing_history

**View Name:** cdsus_billing_history
**Table Source:** `sony_internal.prod.CDSUS_BILLING_HISTORY`
**File Path:** `cdsus_billing_history.view.lkml`

## Overview

- **File Size:** 17781 bytes
- **Lines of Code:** 907
- **Dimensions:** 127
- **Measures:** 12
- **Dimension Groups:** 8
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `primary_key` | string |
| `company_cd` | string |
| `catlg_core_id` | string |
| `selling_company_cd` | string |
| `catlg_pfix_id` | string |
| `reporting_week_no` | number |
| `inventory_category_cd` | string |
| `suffix_id` | string |
| `origin_location_cd` | string |
| `origin_system_cd` | string |
| `order_no` | string |
| `customer_po_no` | string |
| `xref_no` | string |
| `ship_to_no` | number |
| `ship_location_cd` | string |
| `reason_cd` | string |
| `inventory_relief_cd` | string |
| `market_program_cd` | string |
| `article_price_group_cd` | string |
| `unit_pr` | number |
| `terms_cd` | string |
| `campaign_cd` | string |
| `minimum_qty_cd` | string |
| `surcharge_in` | string |
| `sales_rep_cd` | string |
| `sales_rep2_cd` | string |
| `tier_percent_rt` | number |
| `reporting_pfix_id` | string |
| `label_cd` | string |
| `repertoire_cd` | string |
| `sub_repertoire_cd` | string |
| `financial_size_cd` | string |
| `product_line_cd` | string |
| `seasonal_cd` | string |
| `cd_rebate_rt` | number |
| `digest_loose_pr` | number |
| `inventory_cost_group_cd` | string |
| `ship_charge_waiver_in` | string |
| `distribution_article_no` | string |
| `product_royalty_cd` | string |
| `return_penalty_rt` | number |
| `set_item_qt` | number |
| `sub_product_line_cd` | string |
| `ipc_rt` | number |
| `incent_disincent_rt` | number |
| `override_return_penalty_cd` | string |
| `override_incentive_disc_cd` | string |
| `reporting_parent_no` | number |
| `region_cd` | string |
| `franchise_tax_cd` | string |
| `customer_profile_cd` | string |
| `customer_sub_type_cd` | string |
| `total_discount_rt` | number |
| `special_tax_cd` | string |
| `customer_royalty_cd` | string |
| `int_ext_invoice_cd` | string |
| `invoice_cycle_cd` | string |
| `invoice_control_no` | number |
| `invoice_line_no` | number |
| `effective_pr` | number |
| `bill_to_no` | number |
| `transaction_cd` | string |
| `ship_from_no` | number |
| `price_source_cd` | string |
| `ar_dating_cd` | string |
| `customer_price_cd` | string |
| `mfg_size_cd` | string |
| `return_penalty_in` | string |
| `auto_market_program_in` | string |
| `branch_cd` | string |
| `invoice_credit_no` | string |
| `original_document_no` | string |
| `hold_in` | string |
| `returns_allowed_in` | string |
| `article_status_cd` | string |
| `album_component_in` | string |
| `tier_percent_rt_cd` | string |
| `solomon_order_no` | string |
| `discount_type_cd` | string |
| `original_product_line_cd` | string |
| `gds_selling_company_cd` | string |
| `gds_cd_rebate_rt` | number |
| `gds_article_price_group_cd` | string |
| `gds_cd_rebate_in` | string |
| `gds_original_order_no` | number |
| `gds_carton_qt` | number |
| `gds_label_group_cd` | string |
| `gds_branch_cd` | string |
| `gds_sub_product_line_cd` | string |
| `sap_profit_center` | string |
| `gds_incent_mischg_cd` | string |
| `gds_incent_rt` | number |
| `gds_rtnpen_mischg_cd` | string |
| `gds_rtnpen_rt` | number |
| `gds_rtnpen_am` | number |
| `fin_label_cd` | string |
| `fin_label_profit_cd` | string |
| `fin_label_parent_cd` | string |
| `strategic_pnl_cd` | string |
| `gds_strategic_pnl_cd` | string |
| `distrib_method_cd` | string |
| `orig_company_cd` | string |
| `customer_sap_company_cd` | string |
| `billing_parent_no` | string |
| `raas_no` | string |
| `customer_roy_override_cd` | string |
| `royalty_in_cd` | string |
| `roy_adj_cd` | string |
| `roy_adj_cancel_cd` | string |
| `marketing_free_qt` | number |
| `pricing_free_qt` | number |
| `invoice_source_cd` | string |
| `invoice_no` | string |
| `fin_label_corp_rollup_cd` | string |
| `price_category_cd` | string |
| `po_price` | number |
| `gds_shipfrom_dc` | string |
| `exp_copyrt_rt` | number |
| `exp_copyrt_mischg_cd` | string |
| `exp_copyrt_am` | number |
| `prepack_no` | string |
| `sap_material_no` | string |
| `audit_key` | number |
| `threadshop_cust_type` | string |
| `threadshop_cust_type_desc` | string |
| `article_no` | string |
| `potential_dollars` | number |

## Measures

| Name | Type |
|------|------|
| `transaction_qt` | sum |
| `transaction_am` | sum |
| `series_cd` | sum |
| `free_goods_qt` | sum |
| `original_order_qt` | sum |
| `cd_rebate_qt` | sum |
| `cd_rebate_am` | sum |
| `incent_disincent_am` | sum |
| `gds_incent_am` | sum |
| `stnd_free_percent_am` | sum |
| `addtl_disc_am` | sum |
| `gds_incent_disincent_am` | sum |

## Dimension Groups

| Name | Type |
|------|------|
| `reporting_dt` | time |
| `origin_dt` | time |
| `entry_dt` | time |
| `ship_dt` | time |
| `release_dt` | time |
| `transaction_dt` | time |
| `invoice_dt` | time |
| `payment_due_dt` | time |