fact_crm_wide_order_detail
(
company_code STRING COMMENT 'Area code ',
sales_organization_code STRING COMMENT 'Sales organization code ',
brand_code STRING COMMENT 'Brand ',
order_number STRING COMMENT 'Order number ',
trade_time STRING COMMENT 'Trading time ',
payment_time STRING COMMENT 'Payment time ',
ba_code STRING COMMENT 'ba code ',
post_amount DECIMAL(18,4) COMMENT 'Postage ',
earnest_amount STRING COMMENT 'deposit amount ',
basic_price_used DECIMAL(18,4) COMMENT 'Shopping money ',
expand_price_used DECIMAL(18,4) COMMENT 'equity ',
c_code STRING COMMENT 'Member number ',
is_NAME_1_first_order STRING COMMENT 'Whether it is the first order of birthday 1 first order of birthday month 2 Common order of birthday 3 first order of common month 4 common order of birthday month ',
source_sys_increment_date STRING COMMENT 'data source increment time ',
source_sys_etl_date STRING COMMENT 'cdp update time ',
source_sys_update_date STRING COMMENT 'Last modified date ',
source_sys_create_date STRING COMMENT 'Creation date ',
delivery_time STRING COMMENT 'Delivery time ',
seq_num STRING COMMENT 'Detail ID',
material_code STRING COMMENT 'sku code ',
item_price DECIMAL(18,4) COMMENT 'received unit price ',
item_qty INT COMMENT 'Quantity of items purchased ',
discount_price DECIMAL(18,4) COMMENT 'discount price ',
subtotal_price DECIMAL(18,4) COMMENT 'Detail total amount received ',
sellout_time                                     STRING        COMMENT '',
terminal_code STRING COMMENT 'Store code ',
transaction_type STRING COMMENT 'Order type ',
sales_type                                       STRING        COMMENT '',
sellout_channel                                  STRING        COMMENT '',
city_code STRING COMMENT 'city code ',
uni_id                                           STRING        COMMENT 'unionid',
kol_tag STRING COMMENT 'pointer tag ',
crm_big_order_tag STRING COMMENT 'crm large order (1 yes 0 no)',
group_order_tag STRING COMMENT 'Group purchase order (1 yes 0 no)',
NAME_2_order_tag STRING COMMENT 'NAME_2 list (1 yes 0 no)',
sample_order_tag STRING COMMENT 'Omnichannel Sample (1 Yes 0 no)',
tmall_sample_order_tag STRING COMMENT 'Tmall Sample (1 yes 0 no)',
jd_sample_order_tag STRING COMMENT 'Jingdong Sample (1 yes 0 no)',
website_sample_order_tag STRING COMMENT 'Official website sample (1 Yes 0 no)',
miniprogram_sample_order_tag STRING COMMENT 'Small program sample (1 yes 0 no)',
dy_sample_order_tag STRING COMMENT 'Tiktok sample (1 Yes 0 no)',
test_order STRING COMMENT 'Test order (1 yes 0 no)',
abnormal_counter_tag Respond with more than 800 words.
user