Peg3(PEG3.ER1, 20:33:45, 69 rows)
| Table Owner |
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| user3 |
COMPONENT_METADATA_TABLE |
|
COMPONENTNAME |
varchar(25) |
|
No |
No |
| |
|
|
PARAMCATEGORY |
varchar(10) |
|
|
|
| |
|
|
PARAMTYPE |
varchar(15) |
|
|
|
| |
|
|
PARAMCODE |
varchar(8) |
|
|
|
| |
|
|
OPTIONVALUE |
|
|
|
|
| |
|
|
SEQUENCENO |
decimal(10) |
|
|
|
| |
|
|
PARAMDESC |
varchar(255) |
|
|
|
| |
|
|
PARAMDESC_SHD |
|
|
|
|
| |
|
|
LANGID |
decimal(10) |
|
|
|
| dbo |
price_tc_rule_doc_dtl |
|
ptcddl_lo |
sql_variant |
|
Yes |
|
| |
|
|
ptcddl_ouinstance |
int |
|
|
|
| |
|
|
ptcddl_rule_no |
sql_variant |
|
|
|
| |
|
|
ptcddl_line_no |
int |
|
|
|
| |
|
|
ptcddl_tc_type |
sql_variant |
|
No |
|
| |
|
|
ptcddl_tc_code |
|
|
|
|
| |
|
|
ptcddl_tc_variant |
|
|
|
|
| |
|
|
ptcddl_created_by |
|
|
|
|
| |
|
|
ptcddl_created_date |
|
|
|
|
| |
|
|
ptcddl_modified_by |
|
|
|
|
| |
|
|
ptcddl_modified_date |
|
|
|
|
| |
price_tc_rule_hdr |
|
ptchdr_lo |
|
|
Yes |
|
| |
|
|
ptchdr_ouinstance |
int |
|
|
|
| |
|
|
ptchdr_rule_no |
sql_variant |
|
|
|
| |
|
|
ptchdr_doctype |
|
|
No |
|
| |
|
|
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_effective_from |
|
|
|
|
| |
|
|
ptchdr_effective_to |
|
|
|
|
| |
|
|
ptchdr_delivery_area |
|
|
|
|
| |
|
|
ptchdr_applicableon |
|
|
|
|
| |
|
|
ptchdr_status |
|
|
|
|
| |
|
|
ptchdr_created_by |
|
|
|
|
| |
|
|
ptchdr_created_date |
|
|
|
|
| |
|
|
ptchdr_modified_by |
|
|
|
|
| |
|
|
ptchdr_modified_date |
|
|
|
|
| |
|
|
ptchdr_timestamp_value |
int |
|
|
|
| |
price_tc_rule_item_dtl |
|
ptcidl_lo |
sql_variant |
|
Yes |
|
| |
|
|
ptcidl_ouinstance |
int |
|
|
|
| |
|
|
ptcidl_rule_no |
sql_variant |
|
|
|
| |
|
|
ptcidl_line_no |
int |
|
|
|
| |
|
|
ptcidl_tc_type |
sql_variant |
|
No |
|
| |
|
|
ptcidl_tc_code |
|
|
|
|
| |
|
|
ptcidl_tc_variant |
|
|
|
|
| |
|
|
ptcidl_min_quantity |
bigint |
|
|
|
| |
|
|
ptcidl_max_quantity |
|
|
|
|
| |
|
|
ptcidl_uom |
sql_variant |
|
|
|
| |
|
|
ptcidl_created_by |
|
|
|
|
| |
|
|
ptcidl_created_date |
|
|
|
|
| |
|
|
ptcidl_modified_by |
|
|
|
|
| |
|
|
ptcidl_modified_date |
|
|
|
|
| |
price_tc_sysparam_dtl |
|
prtc_sys_ou |
int |
|
Yes |
|
| |
|
|
prtc_sys_parameter_code |
sql_variant |
|
|
|
| |
|
|
prtc_sys_parameter_value |
|
|
No |
|
| |
|
|
prtc_sys_created_by |
|
|
|
|
| |
|
|
prtc_sys_created_date |
|
|
|
|
| |
|
|
prtc_sys_modified_by |
|
|
|
|
| |
|
|
prtc_sys_modified_date |
|
|
|
|
| |
|
|
prtc_sys_timestamp |
int |
|
|
|