|
Table Owner |
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|---|---|
|
dbo |
peg6_price_list_param_tmp |
|
plptmp_guid |
sql_variant |
|
No |
No |
|
|
|
|
plptmp_ref_doc |
|
|
|
|
|
|
|
|
plptmp_ref_ou |
int |
|
|
|
|
|
|
|
plptmp_customer |
sql_variant |
|
|
|
|
|
|
|
plptmp_transaction_date |
datetime |
|
|
|
|
|
|
|
plptmp_currency |
sql_variant |
|
|
|
|
|
|
|
plptmp_part_no |
|
|
|
|
|
|
|
|
plptmp_serial_no |
|
|
|
|
|
|
|
|
plptmp_part_group |
|
|
|
|
|
|
|
|
plptmp_part_type |
|
|
|
|
|
|
|
|
plptmp_quantity |
bigint |
|
|
|
|
|
|
|
plptmp_UOM |
sql_variant |
|
|
|
|
|
|
|
plptmp_condition |
|
|
|
|
|
|
peg6_price_list_tmp |
|
pltmp_guid |
|
|
|
|
|
|
|
|
pltmp_Seq_No |
int |
|
|
|
|
|
|
|
pltmp_price_list |
sql_variant |
|
|
|
|
|
|
|
pltmp_exists_flag |
|
|
|
|
|
|
|
|
pltmp_price |
bigint |
|
|
|
|
|
peg6_rult_tc_rule_tmp |
|
rult_guid |
sql_variant |
|
|
|
|
|
|
|
rult_parameter |
|
|
|
|
|
|
|
|
rult_rule_no |
|
|
|
|
|
|
|
|
rult_priority |
int |
|
|
|
|
|
|
|
rult_weightage |
bigint |
|
|
|
|
|
PEG6_Spl_Cu_Wout_work_unit |
|
Guid |
sql_variant |
|
|
|
|
|
|
|
SpCu_Component |
|
|
|
|
|
|
|
|
SpCu_SNo |
int |
|
|
|
|
|
|
|
SpCu_order_no |
sql_variant |
|
|
|
|
|
|
|
SpCu_wout_order_ou |
int |
|
|
|
|
|
|
|
SpCu_wout_amend_no |
sql_variant |
|
|
|
|
|
|
|
SpCu_serial_no |
int |
|
|
|
|
|
|
|
SpCu_ref_serial_no |
|
|
|
|
|
|
|
|
SpCu_unit_type |
sql_variant |
|
|
|
|
|
|
|
SpCu_unit_code |
|
|
|
|
|
|
|
|
SpCu_unit_ou |
int |
|
|
|
|
|
|
|
SpCu_rp_code |
sql_variant |
|
|
|
|
|
|
|
SpCu_res_price_flat |
bigint |
|
|
|
|
|
|
|
SpCu_est_res_price |
|
|
|
|
|
|
|
|
SpCu_tot_res_price |
|
|
|
|
|
|
|
|
SpCu_mtr_price_flat |
|
|
|
|
|
|
|
|
SpCu_est_mtr_price |
|
|
|
|
|
|
|
|
SpCu_tot_mtr_price |
|
|
|
|
|
|
|
|
SpCu_embodiment_fee |
|
|
|
|
|
|
|
|
SpCu_misc_cost |
|
|
|
|
|
|
|
|
SpCu_Estimated_Tot |
|
|
|
|
|
|
PEG6_Spl_Cu_Wu_Part |
|
SpCu_Pt_Guid |
sql_variant |
|
|
|
|
|
|
|
SpCu_Pt_SNo |
int |
|
|
|
|
|
|
|
SpCu_Pt_Order_No |
sql_variant |
|
|
|
|
|
|
|
SpCu_Pt_Order_Ou |
int |
|
|
|
|
|
|
|
SpCu_Pt_Amend_No |
sql_variant |
|
|
|
|
|
|
|
SpCu_Pt_Serial_No |
int |
|
|
|
|
|
|
|
SpCu_Pt_CoMgt_Serial_No |
|
|
|
|
|
|
|
|
SpCu_Pt_WorkUnit_No |
sql_variant |
|
|
|
|
|
|
|
SpCu_Pt_WorkUnit_Ou |
int |
|
|
|
|
|
|
|
SpCu_Pt_WorkUnit_Type |
sql_variant |
|
|
|
|
|
|
|
SpCu_Pt_Part_No |
|
|
|
|
|
|
|
|
SpCu_Pt_Part_Ou |
int |
|
|
|
|
|
|
|
SpCu_Pt_Part_UOM |
sql_variant |
|
|
|
|
|
|
|
SpCu_Pt_Part_Qty |
bigint |
|
|
|
|
|
|
|
SpCu_Pt_Part_Type |
sql_variant |
|
|
|
|
|
|
|
SpCu_Pt_Cust_Mro_Flag |
|
|
|
|
|
|
|
|
SpCu_Pt_Upd_Flag |
|
|
|
|
|
|
|
|
SpCu_Pt_mtr_price_flat |
bigint |
|
|
|
|
|
|
|
SpCu_Pt_est_mtr_rate |
|
|
|
|
|
|
|
|
SpCu_Pt_est_mtr_price |
|
|
|
|
|
|
|
|
SpCu_embodiment_fee |
|
|
|
|
|
|
|
|
SpCu_Pt_tot_mtr_price |
|
|
|
|
|
|
PEG6_Spl_Cu_Wu_Resource |
|
SpCu_Res_Guid |
sql_variant |
|
|
|
|
|
|
|
SpCu_Res_SNo |
int |
|
|
|
|
|
|
|
SpCu_Res_Order_No |
sql_variant |
|
|
|
|
|
|
|
SpCu_Res_Order_Ou |
int |
|
|
|
|
|
|
|
SpCu_Res_Amend_No |
sql_variant |
|
|
|
|
|
|
|
SpCu_Res_Serial_No |
int |
|
|
|
|
|
|
|
SpCu_Res_CoMgt_Serial_No |
|
|
|
|
|
|
|
|
SpCu_Res_WorkUnit_No |
sql_variant |
|
|
|
|
|
|
|
SpCu_Res_WorkUnit_Ou |
int |
|
|
|
|
|
|
|
SpCu_Res_WorkUnit_Type |
sql_variant |
|
|
|
|
|
|
|
SpCu_Res_Resource_No |
|
|
|
|
|
|
|
|
SpCu_Res_Resource_Ou |
int |
|
|
|
|
|
|
|
SpCu_Res_Resource_Type |
sql_variant |
|
|
|
|
|
|
|
SpCu_Res_bill_hrs |
bigint |
|
|
|
|
|
|
|
SpCu_Res_Upd_Flag |
sql_variant |
|
|
|
|
|
|
|
SpCu_Res_price_flat |
bigint |
|
|
|
|
|
|
|
SpCu_Res_est_price |
|
|
|
|
|
|
|
|
SpCu_Res_est_rate |
|
|
|
|
|
|
|
|
SpCu_Res_Tot_price |
|
|
|
|
|
|
|
|
spCU_ap_res_flag |
sql_variant |
|
|
|
|
|
peg6_sysparam_tmp |
|
attributename |
|
|
|
|
|
|
|
|
attributevalue |
|
|
|
|
|
|
|
|
guid |
|
|
|
|
|
|
PEG6_TC_RULE_HDR_TMP |
|
ptchdr_guid |
|
|
|
|
|
|
|
|
ptchdr_ouinstance |
int |
|
|
|
|
|
|
|
ptchdr_doctype |
sql_variant |
|
|
|
|
|
|
|
ptchdr_cust_grp |
|
|
|
|
|
|
|
|
ptchdr_cust_code |
|
|
|
|
|
|
|
|
ptchdr_currency |
|
|
|
|
|
|
|
|
ptchdr_part_group |
|
|
|
|
|
|
|
|
ptchdr_part_no |
|
|
|
|
|
|
|
|
ptchdr_shipping_pt |
int |
|
|
|
|
|
|
|
ptchdr_shipping_wh |
sql_variant |
|
|
|
|
|
|
|
ptchdr_site_id |
|
|
|
|
|
|
|
|
ptchdr_receiving_ou |
int |
|
|
|
|
|
|
|
ptchdr_optional_param1 |
sql_variant |
|
|
|
|
|
|
|
ptchdr_optional_param2 |
|
|
|
|
|
|
|
|
ptchdr_optional_param3 |
|
|
|
|
|
|
|
|
ptchdr_optional_param4 |
|
|
|
|
|
|
|
|
ptchdr_transaction_date |
datetime |
|
|
|
|
|
|
|
ptchdr_delivery_area |
sql_variant |
|
|
|
|
|
|
|
ptchdr_applicableon |
|
|
|
|
|
|
|
|
ptchdr_quantity |
bigint |
|
|
|
|
|
|
|
ptchdr_uom |
sql_variant |
|
|
|
|
|
peg6_tcd_detail_tmp |
|
tcdt_rule_no |
|
|
|
|
|
|
|
|
tcdt_tc_type |
|
|
|
|
|
|
|
|
tcdt_tc_code |
|
|
|
|
|
|
|
|
tcdt_tc_variant |
|
|
|
|
|
|
|
|
tcdt_guid |
|
|
|
|
|
|
pl_disc_rule_temp |
|
dc_rule_no |
|
|
|
|
|
|
|
|
dc_dcline_no |
int |
|
|
|
|
|
|
|
dc_customer_code |
sql_variant |
|
|
|
|
|
|
|
dc_customer_group |
|
|
|
|
|
|
|
|
dc_shipping_point |
int |
|
|
|
|
|
|
|
dc_shipping_wh |
sql_variant |
|
|
|
|
|
|
|
dc_delivery_area |
|
|
|
|
|
|
|
|
dc_currency |
|
|
|
|
|
|
|
|
dc_sales_channel |
|
|
|
|
|
|
|
|
dc_item_type |
|
|
|
|
|
|
|
|
dc_item_grp |
|
|
|
|
|
|
|
|
dc_item_code |
|
|
|
|
|
|
|
|
dc_item_variant |
|
|
|
|
|
|
|
|
dc_op_param1 |
|
|
|
|
|
|
|
|
dc_op_param2 |
|
|
|
|
|
|
|
|
dc_op_param3 |
|
|
|
|
|
|
|
|
dc_op_param4 |
|
|
|
|
|
|
|
|
dc_rule_ouinstance |
int |
|
|
|
|
|
|
|
dc_type |
sql_variant |
|
|
|
|
|
|
|
dc_code |
|
|
|
|
|
|
|
|
dc_variant |
|
|
|
|
|
|
|
|
dc_basis |
|
|
|
|
|
|
|
|
dc_variantvalue |
bigint |
|
|
|
|
|
|
|
dc_versionno |
int |
|
|
|
|
|
|
|
dc_line_no |
|
|
|
|
|
|
|
|
dc_priority |
sql_variant |
|
|
|
|
|
|
|
dc_weightage |
int |
|
|
|
|
|
|
|
dc_process_flag |
sql_variant |
|
|
|
|
|
|
|
dc_created_date |
|
|
|
|
|
|
|
|
dc_expiry_date |
|
|
|
|
|
|
|
|
guid |
|
|
|
|
|
|
pl_prom_deal_temp |
|
prom_promotion_id |
|
|
|
|
|
|
|
|
prom_customer_code |
|
|
|
|
|
|
|
|
prom_cust_group |
|
|
|
|
|
|
|
|
prom_shipping_point |
int |
|
|
|
|
|
|
|
prom_shipping_wh |
sql_variant |
|
|
|
|
|
|
|
prom_delivery_area |
|
|
|
|
|
|
|
|
prom_currency |
|
|
|
|
|
|
|
|
prom_item_grp |
|
|
|
|
|
|
|
|
prom_item_code |
|
|
|
|
|
|
|
|
prom_variant |
|
|
|
|
|
|
|
|
prom_optional_param1 |
|
|
|
|
|
|
|
|
prom_optional_param2 |
|
|
|
|
|
|
|
|
prom_optional_param3 |
|
|
|
|
|
|
|
|
prom_optional_param4 |
|
|
|
|
|
|
|
|
prom_line_no |
int |
|
|
|
|
|
|
|
prom_deal_id |
sql_variant |
|
|
|
|
|
|
|
prom_deal_type |
|
|
|
|
|
|
|
|
prom_deal_usage |
|
|
|
|
|
|
|
|
prom_uom |
|
|
|
|
|
|
|
|
prom_qty |
bigint |
|
|
|
|
|
|
|
prom_unit_rate |
|
|
|
|
|
|
|
|
prom_process_flag |
sql_variant |
|
|
|
|
|
|
|
prom_priority |
|
|
|
|
|
|
|
|
prom_weightage |
int |
|
|
|
|
|
|
|
prom_guid |
sql_variant |
|
|
|
|
|
pl_prom_rule_temp |
|
prom_promotion_id |
|
|
|
|
|
|
|
|
prom_promotion_line_no |
int |
|
|
|
|
|
|
|
prom_customer_code |
sql_variant |
|
|
|
|
|
|
|
prom_cust_group |
|
|
|
|
|
|
|
|
prom_shipping_point |
int |
|
|
|
|
|
|
|
prom_shipping_wh |
sql_variant |
|
|
|
|
|
|
|
prom_delivery_area |
|
|
|
|
|
|
|
|
prom_currency |
|
|
|
|
|
|
|
|
prom_item_grp |
|
|
|
|
|
|
|
|
prom_item_code |
|
|
|
|
|
|
|
|
prom_variant |
|
|
|
|
|
|
|
|
prom_optional_param1 |
|
|
|
|
|
|
|
|
prom_optional_param2 |
|
|
|
|
|
|
|
|
prom_optional_param3 |
|
|
|
|
|
|
|
|
prom_optional_param4 |
|
|
|
|
|
|
|
|
prom_line_no |
int |
|
|
|
|
|
|
|
prom_deal_id |
sql_variant |
|
|
|
|
|
|
|
prom_deal_type |
|
|
|
|
|
|
|
|
prom_deal_usage |
|
|
|
|
|
|
|
|
prom_uom |
|
|
|
|
|
|
|
|
prom_qty |
bigint |
|
|
|
|
|
|
|
prom_unit_rate |
|
|
|
|
|
|
|
|
prom_process_flag |
sql_variant |
|
|
|
|
|
|
|
prom_priority |
|
|
|
|
|
|
|
|
prom_weightage |
int |
|
|
|
|
|
|
|
prom_created_date |
sql_variant |
|
|
|
|
|
|
|
prom_expiry_date |
|
|
|
|
|
|
|
|
prom_guid |
|
|
|
|
|
|
pl_tc_rule_temp |
|
tc_rule_no |
|
|
|
|
|
|
|
|
tc_tcline_no |
int |
|
|
|
|
|
|
|
tc_customer_code |
sql_variant |
|
|
|
|
|
|
|
tc_customer_group |
|
|
|
|
|
|
|
|
tc_shipping_point |
int |
|
|
|
|
|
|
|
tc_shipping_wh |
sql_variant |
|
|
|
|
|
|
|
tc_delivery_area |
|
|
|
|
|
|
|
|
tc_currency |
|
|
|
|
|
|
|
|
tc_recv_ou |
int |
|
|
|
|
|
|
|
tc_site_id |
sql_variant |
|
|
|
|
|
|
|
tc_item_type |
|
|
|
|
|
|
|
|
tc_item_grp |
|
|
|
|
|
|
|
|
tc_item_code |
|
|
|
|
|
|
|
|
tc_item_variant |
|
|
|
|
|
|
|
|
tc_op_param1 |
|
|
|
|
|
|
|
|
tc_op_param2 |
|
|
|
|
|
|
|
|
tc_op_param3 |
|
|
|
|
|
|
|
|
tc_op_param4 |
|
|
|
|
|
|
|
|
tc_rule_ouinstance |
int |
|
|
|
|
|
|
|
tc_tcdtype |
sql_variant |
|
|
|
|
|
|
|
tc_tcdcode |
|
|
|
|
|
|
|
|
tc_tcdvariant |
|
|
|
|
|
|
|
|
tc_tcdbasis |
|
|
|
|
|
|
|
|
tc_tcddt_variantvalue |
bigint |
|
|
|
|
|
|
|
tc_line_no |
int |
|
|
|
|
|
|
|
tc_priority |
sql_variant |
|
|
|
|
|
|
|
tc_weightage |
int |
|
|
|
|
|
|
|
tc_process_flag |
sql_variant |
|
|
|
|
|
|
|
tc_created_date |
|
|
|
|
|
|
|
|
tc_expiry_date |
|
|
|
|
|
|
|
|
guid |
|
|
|
|
|
|
pr_op_column_metadata |
|
op_param_code |
|
|
|
|
|
|
|
|
op_param_name |
|
|
|
|
|
|
pr_out_op_param_tmp |
|
pr_guid |
|
|
|
|
|
|
|
|
pr_doc_lineno |
int |
|
|
|
|
|
|
|
pr_option_param1 |
sql_variant |
|
|
|
|
|
|
|
pr_option_param2 |
|
|
|
|
|
|
|
|
pr_option_param3 |
|
|
|
|
|
|
|
|
pr_option_param4 |
|
|
|
|
|
|
price_attr_grp_code_tmp |
|
pr_attr_guid |
|
|
|
|
|
|
|
|
pr_attr_grp_code |
|
|
|
|
|
|
|
|
pr_attr_grp_count |
int |
|
|
|
|
|
price_debug_msg_tmp |
|
debug_guid |
sql_variant |
|
|
|
|
|
|
|
debug_message |
|
|
|
|
|
|
|
|
debug_info1 |
|
|
|
|
|
|
|
|
debug_value1 |
|
|
|
|
|
|
|
|
debug_info2 |
|
|
|
|
|
|
|
|
debug_value2 |
|
|
|
|
|
|
|
|
debug_info3 |
|
|
|
|
|
|
|
|
debug_value3 |
|
|
|
|
|
|
price_disc_deal_out_tmp |
|
disc_guid |
|
|
|
|
|
|
|
|
disc_ou |
int |
|
|
|
|
|
|
|
disc_info_level |
sql_variant |
|
|
|
|
|
|
|
disc_doc_line_no |
int |
|
|
|
|
|
|
|
disc_line_no |
|
|
|
|
|
|
|
|
disc_type |
sql_variant |
|
|
|
|
|
|
|
disc_code |
|
|
|
|
|
|
|
|
disc_variant |
|
|
|
|
|
|
|
|
disc_basis |
|
|
|
|
|
|
|
|
disc_value |
bigint |
|
|
|
|
|
|
|
disc_promotion_ou |
int |
|
|
|
|
|
|
|
disc_promotion_id |
sql_variant |
|
|
|
|
|
|
|
disc_deal_type |
|
|
|
|
|
|
|
|
disc_deal_id |
|
|
|
|
|
|
|
|
disc_max_version |
int |
|
|
|
|
|
price_disc_in_tmp |
|
disc_guid |
sql_variant |
|
|
|
|
|
|
|
disc_login_ou |
int |
|
|
|
|
|
|
|
disc_info_level |
sql_variant |
|
|
|
|
|
|
|
disc_doc_line_no |
int |
|
|
|
|
|
|
|
disc_item_ou |
|
|
|
|
|
|
|
|
disc_item_type |
sql_variant |
|
|
|
|
|
|
|
disc_item_code |
|
|
|
|
|
|
|
|
disc_item_group |
|
|
|
|
|
|
|
|
disc_item_variant |
|
|
|
|
|
|
|
|
disc_uom |
|
|
|
|
|
|
|
|
disc_qty |
bigint |
|
|
|
|
|
|
|
disc_rate |
|
|
|
|
|
|
|
|
disc_pricing_date |
sql_variant |
|
|
|
|
|
|
|
disc_ordcustomer_ou |
int |
|
|
|
|
|
|
|
disc_billcustomer_ou |
|
|
|
|
|
|
|
|
disc_shipcustomer_ou |
|
|
|
|
|
|
|
|
disc_ordcustomer_code |
sql_variant |
|
|
|
|
|
|
|
disc_billcustomer_code |
|
|
|
|
|
|
|
|
disc_shipcustomer_code |
|
|
|
|
|
|
|
|
disc_shipping_point |
int |
|
|
|
|
|
|
|
disc_shipping_wh |
sql_variant |
|
|
|
|
|
|
|
disc_delivery_area |
|
|
|
|
|
|
|
|
disc_sales_channel |
|
|
|
|
|
|
|
|
disc_currency |
|
|
|
|
|
|
|
|
disc_doc_amount |
bigint |
|
|
|
|
|
|
|
disc_op_param1 |
sql_variant |
|
|
|
|
|
|
|
disc_op_param2 |
|
|
|
|
|
|
|
|
disc_op_param3 |
|
|
|
|
|
|
|
|
disc_op_param4 |
datetime |
|
|
|
|
|
price_disc_out_tmp |
|
disc_guid |
sql_variant |
|
|
|
|
|
|
|
disc_ou |
int |
|
|
|
|
|
|
|
disc_info_level |
sql_variant |
|
|
|
|
|
|
|
disc_doc_line_no |
int |
|
|
|
|
|
|
|
disc_line_no |
|
|
|
|
|
|
|
|
disc_rule_ou |
|
|
|
|
|
|
|
|
disc_rulenum |
sql_variant |
|
|
|
|
|
|
|
disc_type |
|
|
|
|
|
|
|
|
disc_code |
|
|
|
|
|
|
|
|
disc_variant |
|
|
|
|
|
|
|
|
disc_basis |
|
|
|
|
|
|
|
|
disc_value |
bigint |
|
|
|
|
|
|
|
disc_max_version |
int |
|
|
|
|
|
price_eng_sysparam_dtl |
|
pricesys_ou |
|
|
Yes |
|
|
|
|
|
pricesys_param_code |
sql_variant |
|
|
|
|
|
|
|
pricesys_param_value |
|
|
No |
|
|
|
|
|
pricesys_created_by |
|
|
|
|
|
|
|
|
pricesys_created_date |
|
|
|
|
|
|
|
|
pricesys_modified_by |
|
|
|
|
|
|
|
|
pricesys_modified_date |
|
|
|
|
|
|
|
|
pricesys_timestamp |
int |
|
|
|
|
|
price_engine_in_tmp |
|
price_guid |
sql_variant |
|
|
|
|
|
|
|
price_login_ou |
int |
|
|
|
|
|
|
|
price_info_level |
sql_variant |
|
|
|
|
|
|
|
price_doc_line_no |
int |
|
|
|
|
|
|
|
price_item_ou |
|
|
|
|
|
|
|
|
price_item_type |
sql_variant |
|
|
|
|
|
|
|
price_item_code |
|
|
|
|
|
|
|
|
price_item_group |
|
|
|
|
|
|
|
|
price_item_variant |
|
|
|
|
|
|
|
|
price_uom |
|
|
|
|
|
|
|
|
price_qty |
bigint |
|
|
|
|
|
|
|
price_unit_rate |
|
|
|
|
|
|
|
|
price_default_price |
sql_variant |
|
|
|
|
|
|
|
price_default_promotion |
|
|
|
|
|
|
|
|
price_pricing_date |
|
|
|
|
|
|
|
|
price_ordcustomer_ou |
int |
|
|
|
|
|
|
|
price_billcustomer_ou |
|
|
|
|
|
|
|
|
price_shipcustomer_ou |
|
|
|
|
|
|
|
|
price_ordcustomer_code |
sql_variant |
|
|
|
|
|
|
|
price_billcustomer_code |
|
|
|
|
|
|
|
|
price_shipcustomer_code |
|
|
|
|
|
|
|
|
price_shipping_point |
int |
|
|
|
|
|
|
|
price_shipping_wh |
sql_variant |
|
|
|
|
|
|
|
price_delivery_area |
|
|
|
|
|
|
|
|
price_sales_channel |
|
|
|
|
|
|
|
|
price_currency |
|
|
|
|
|
|
|
|
price_pricelist_code |
|
|
|
|
|
|
|
|
price_ref_doc_type |
|
|
|
|
|
|
|
|
price_ref_doc_no |
|
|
|
|
|
|
|
|
price_ref_doc_ou |
int |
|
|
|
|
|
|
|
price_ref_doc_lineno |
|
|
|
|
|
|
|
|
price_op_param1 |
sql_variant |
|
|
|
|
|
|
|
price_op_param2 |
|
|
|
|
|
|
|
|
price_op_param3 |
|
|
|
|
|
|
|
|
price_op_param4 |
|
|
|
|
|
|
price_engine_out_tmp |
|
price_guid |
|
|
|
|
|
|
|
|
price_login_ou |
int |
|
|
|
|
|
|
|
price_doc_line_no |
|
|
|
|
|
|
|
|
price_customer_ou |
|
|
|
|
|
|
|
|
price_customer_code |
sql_variant |
|
|
|
|
|
|
|
price_currency |
|
|
|
|
|
|
|
|
price_tran_date |
|
|
|
|
|
|
|
|
price_item_ou |
int |
|
|
|
|
|
|
|
price_item_type |
sql_variant |
|
|
|
|
|
|
|
price_item_code |
|
|
|
|
|
|
|
|
price_item_variant |
|
|
|
|
|
|
|
|
price_item_group |
|
|
|
|
|
|
|
|
price_uom |
|
|
|
|
|
|
|
|
price_qty |
bigint |
|
|
|
|
|
|
|
price_unit_rate |
|
|
|
|
|
|
|
|
price_threshold_min_qty |
|
|
|
|
|
|
|
|
price_threshold_rate |
|
|
|
|
|
|
|
|
price_pricelist_ou |
int |
|
|
|
|
|
|
|
price_pricelist_code |
sql_variant |
|
|
|
|
|
|
|
price_pricelist_amnd_no |
int |
|
|
|
|
|
|
|
price_rule_ou |
|
|
|
|
|
|
|
|
price_rule_num |
sql_variant |
|
|
|
|
|
|
|
price_promotion_ou |
int |
|
|
|
|
|
|
|
price_promotion_id |
sql_variant |
|
|
|
|
|
|
|
price_deal_type |
|
|
|
|
|
|
|
|
price_deal_id |
|
|
|
|
|
|
|
|
price_upd_flag |
|
|
|
|
|
|
price_fetch_attrib_tmp |
|
price_guid |
|
|
|
|
|
|
|
|
price_login_ou |
int |
|
|
|
|
|
|
|
price_doc_line_no |
|
|
|
|
|
|
|
|
price_attrib_line_no |
|
|
|
|
|
|
|
|
price_attribute_code |
sql_variant |
|
|
|
|
|
|
|
price_qualitative_value |
|
|
|
|
|
|
|
|
price_min_value |
int |
|
|
|
|
|
|
|
price_max_value |
|
|
|
|
|
|
price_fetch_in_tmp |
|
price_guid |
sql_variant |
|
|
|
|
|
|
|
price_login_ou |
int |
|
|
|
|
|
|
|
price_doc_line_no |
|
|
|
|
|
|
|
|
price_ordcustomer_ou |
|
|
|
|
|
|
|
|
price_billcustomer_ou |
|
|
|
|
|
|
|
|
price_shipcustomer_ou |
|
|
|
|
|
|
|
|
price_ordcustomer_code |
sql_variant |
|
|
|
|
|
|
|
price_billcustomer_code |
|
|
|
|
|
|
|
|
price_shipcustomer_code |
|
|
|
|
|
|
|
|
price_pricelist_code |
|
|
|
|
|
|
|
|
price_currency |
|
|
|
|
|
|
|
|
price_tran_date |
|
|
|
|
|
|
|
|
price_item_ou |
int |
|
|
|
|
|
|
|
price_item_type |
sql_variant |
|
|
|
|
|
|
|
price_item_code |
|
|
|
|
|
|
|
|
price_item_group |
|
|
|
|
|
|
|
|
price_item_variant |
|
|
|
|
|
|
|
|
price_uom |
|
|
|
|
|
|
|
|
price_qty |
bigint |
|
|
|
|
|
price_free_deal_out_tmp |
|
price_guid |
sql_variant |
|
|
|
|
|
|
|
price_ou |
int |
|
|
|
|
|
|
|
price_info_level |
sql_variant |
|
|
|
|
|
|
|
price_doc_line_no |
int |
|
|
|
|
|
|
|
price_line_no |
|
|
|
|
|
|
|
|
price_item_type |
sql_variant |
|
|
|
|
|
|
|
price_item_code |
|
|
|
|
|
|
|
|
price_item_variant |
|
|
|
|
|
|
|
|
price_min_qty |
bigint |
|
|
|
|
|
|
|
price_max_qty |
|
|
|
|
|
|
|
|
price_item_uom |
sql_variant |
|
|
|
|
|
|
|
price_promotion_ou |
int |
|
|
|
|
|
|
|
price_promotion_id |
sql_variant |
|
|
|
|
|
|
|
price_deal_type |
|
|
|
|
|
|
|
|
price_deal_id |
|
|
|
|
|
|
price_is_metadata |
|
calling_component |
|
|
|
|
|
|
|
|
view_type |
|
|
|
|
|
|
|
|
input_view_name |
|
|
|
|
|
|
|
|
document_type |
|
|
|
|
|
|
price_item_validation_tmp |
|
guid |
|
|
|
|
|
|
|
|
item_ou |
int |
|
|
|
|
|
|
|
status |
sql_variant |
|
|
|
|
|
price_opt_param_tmp |
|
pr_op_guid |
|
|
|
|
|
|
|
|
pr_op_ou |
int |
|
|
|
|
|
|
|
pr_op_infolevel |
sql_variant |
|
|
|
|
|
|
|
pr_op_lineno |
int |
|
|
|
|
|
|
|
pr_op_prefered_carrier |
sql_variant |
|
|
|
|
|
|
|
pr_op_folder |
|
|
|
|
|
|
|
|
pr_op_freight_billable |
|
|
|
|
|
|
|
|
pr_op_freight_term |
|
|
|
|
|
|
|
|
pr_op_inco_term |
|
|
|
|
|
|
|
|
pr_op_order_priority |
int |
|
|
|
|
|
|
|
pr_op_proc_action |
sql_variant |
|
|
|
|
|
|
|
pr_op_pay_term_code |
|
|
|
|
|
|
|
|
pr_op_receipt_method |
|
|
|
|
|
|
|
|
pr_op_sales_person |
|
|
|
|
|
|
|
|
pr_op_ship_partial |
|
|
|
|
|
|
|
|
pr_op_stock_status |
|
|
|
|
|
|
|
|
pr_op_sale_purpose |
|
|
|
|
|
|
|
|
pr_op_trans_mode |
|
|
|
|
|
|
|
|
pr_op_uom |
|
|
|
|
|
|
|
|
pr_op_order_date |
|
|
|
|
|
|
|
|
pr_op_pricing_date |
|
|
|
|
|
|
|
|
pr_op_req_date |
|
|
|
|
|
|
|
|
pr_op_to_ship_date |
|
|
|
|
|
|
|
|
pr_op_order_type |
|
|
|
|
|
|
|
|
pr_op_order_point |
int |
|
|
|
|
|
|
|
pr_op_sale_type |
sql_variant |
|
|
|
|
|
price_optional_param |
|
poptl_lo |
|
|
|
|
|
|
|
|
poptl_ou |
int |
|
|
|
|
|
|
|
poptl_param1 |
sql_variant |
|
|
|
|
|
|
|
poptl_param2 |
|
|
|
|
|
|
|
|
poptl_param3 |
|
|
|
|
|
|
|
|
poptl_param4 |
|
|
|
|
|
|
|
|
poptl_role_priority |
|
|
|
|
|
|
|
|
poptl_base_pricelist_No |
|
|
|
|
|
|
|
|
poptl_SvrPLst_No |
|
|
|
|
|
|
|
|
poptl_SvrPLst_OU |
int |
|
|
|
|
|
|
|
poptl_timestamp |
|
|
|
|
|
|
|
|
poptl_created_by |
sql_variant |
|
|
|
|
|
|
|
poptl_created_date |
datetime |
|
|
|
|
|
|
|
poptl_modified_by |
sql_variant |
|
|
|
|
|
|
|
poptl_modified_date |
datetime |
|
|
|
|
|
price_range_metadata |
|
pricerng_ouinstance |
int |
|
|
|
|
|
|
|
pricerng_part_type |
sql_variant |
|
|
|
|
|
|
|
pricerng_range_from |
bigint |
|
|
|
|
|
|
|
pricerng_range_to |
|
|
|
|
|
|
|
|
pricerng_price_tag |
|
|
|
|
|
|
price_rule_temp |
|
plrhdr_guid |
sql_variant |
|
|
|
|
|
|
|
plrhdr_lineno |
int |
|
|
|
|
|
|
|
plrhdr_pl_rule_no |
sql_variant |
|
|
|
|
|
|
|
plrhdr_ou |
int |
|
|
|
|
|
|
|
plrhdr_cust_group |
sql_variant |
|
|
|
|
|
|
|
plrhdr_cust_code |
|
|
|
|
|
|
|
|
plrhdr_item_group |
|
|
|
|
|
|
|
|
plrhdr_item_code |
|
|
|
|
|
|
|
|
plrhdr_item_variant |
|
|
|
|
|
|
|
|
plrhdr_shipping_pt |
int |
|
|
|
|
|
|
|
plrhdr_shipping_wh |
sql_variant |
|
|
|
|
|
|
|
plrhdr_sales_channel |
|
|
|
|
|
|
|
|
plrhdr_delivery_area |
|
|
|
|
|
|
|
|
plrhdr_optional_param1 |
|
|
|
|
|
|
|
|
plrhdr_optional_param2 |
|
|
|
|
|
|
|
|
plrhdr_optional_param3 |
|
|
|
|
|
|
|
|
plrhdr_optional_param4 |
|
|
|
|
|
|
|
|
plrhdr_priority |
|
|
|
|
|
|
|
|
plrhdr_weightage |
int |
|
|
|
|
|
|
|
plrhdr_created_date |
sql_variant |
|
|
|
|
|
|
|
plrhdr_expiry_date |
|
|
|
|
|
|
price_tc_in_tmp |
|
tc_guid |
|
|
|
|
|
|
|
|
tc_login_ou |
int |
|
|
|
|
|
|
|
tc_info_level |
sql_variant |
|
|
|
|
|
|
|
tc_doc_line_no |
int |
|
|
|
|
|
|
|
tc_ref_doc_type |
sql_variant |
|
|
|
|
|
|
|
tc_item_ou |
int |
|
|
|
|
|
|
|
tc_item_type |
sql_variant |
|
|
|
|
|
|
|
tc_item_code |
|
|
|
|
|
|
|
|
tc_item_group |
|
|
|
|
|
|
|
|
tc_item_variant |
|
|
|
|
|
|
|
|
tc_uom |
|
|
|
|
|
|
|
|
tc_qty |
bigint |
|
|
|
|
|
|
|
tc_default_tax_flag |
sql_variant |
|
|
|
|
|
|
|
tc_default_chrg_flag |
|
|
|
|
|
|
|
|
tc_tran_date |
|
|
|
|
|
|
|
|
tc_ordcustomer_ou |
int |
|
|
|
|
|
|
|
tc_billcustomer_ou |
|
|
|
|
|
|
|
|
tc_shipcustomer_ou |
|
|
|
|
|
|
|
|
tc_ordcustomer_code |
sql_variant |
|
|
|
|
|
|
|
tc_billcustomer_code |
|
|
|
|
|
|
|
|
tc_shipcustomer_code |
|
|
|
|
|
|
|
|
tc_shipping_point |
int |
|
|
|
|
|
|
|
tc_shipping_wh |
sql_variant |
|
|
|
|
|
|
|
tc_delivery_area |
|
|
|
|
|
|
|
|
tc_sales_channel |
|
|
|
|
|
|
|
|
tc_site_id |
|
|
|
|
|
|
|
|
tc_recv_ou |
int |
|
|
|
|
|
|
|
tc_currency |
sql_variant |
|
|
|
|
|
|
|
tc_doc_amount |
bigint |
|
|
|
|
|
|
|
tc_op_param1 |
sql_variant |
|
|
|
|
|
|
|
tc_op_param2 |
|
|
|
|
|
|
|
|
tc_op_param3 |
|
|
|
|
|
|
|
|
tc_op_param4 |
|
|
|
|
|
|
price_tc_out_tmp |
|
tc_guid |
|
|
|
|
|
|
|
|
tc_ou |
int |
|
|
|
|
|
|
|
tc_info_level |
sql_variant |
|
|
|
|
|
|
|
tc_doc_line_no |
int |
|
|
|
|
|
|
|
tc_line_no |
|
|
|
|
|
|
|
|
tc_rule_ou |
|
|
|
|
|
|
|
|
tc_rulenum |
sql_variant |
|
|
|
|
|
|
|
tc_type |
|
|
|
|
|
|
|
|
tc_code |
|
|
|
|
|
|
|
|
tc_variant |
|
|
|
|
|
|
|
|
tc_basis |
|
|
|
|
|
|
|
|
tc_value |
bigint |
|
|
|
|
|
|
|
tc_max_version |
int |
|
|
|
|
|
price_tran_prty_weight |
|
ptran_transtype |
sql_variant |
|
|
|
|
|
|
|
ptran_lo |
|
|
|
|
|
|
|
|
ptran_parameter |
|
|
|
|
|
|
|
|
ptran_ou |
int |
|
|
|
|
|
|
|
ptran_timestamp |
|
|
|
|
|
|
|
|
ptran_priority |
|
|
|
|
|
|
|
|
ptran_weightage |
|
|
|
|
|
|
|
|
ptran_created_by |
sql_variant |
|
|
|
|
|
|
|
ptran_created_date |
datetime |
|
|
|
|
|
|
|
ptran_modified_by |
sql_variant |
|
|
|
|
|
|
|
ptran_modified_date |
datetime |
|
|
|