Notes

create table COLES_ORDER
(user_reserved_code varchar(150),
user_reserved_number int,
user_reserved_date timestamp,
user_reserved_amount decimal,
user_reserved_reference varchar(150),
sender_EDI_ID varchar(150),
receiver_EDI_ID varchar(150),
rate_exchange decimal,
order_taken_by varchar(150),
time_scheduled_pick int,
customer_PO varchar(150),
date_cancel timestamp,
ordered_by varchar(150),
date_ordered timestamp,
company varchar(150),
processing_version varchar(150),
action_type varchar(150),
business_unit varchar(150),
document_number int,
document_company varchar(150),
document_type_code varchar(150),
time_requested int,
deliver_to_long_id varchar(150),
deliver_to_tax_id varchar(150),
deliver_to_id varchar(150),
forwarder_to_long_id varchar(150),
forwarder_to_tax_id varchar(150),
forwarder_to_id varchar(150),
bill_payment_inst_code varchar(150),
bill_cc_type_code varchar(150),
bill_tax_rate_area_code varchar(150),
bill_print_message_code varchar(150),
bill_date_expiration timestamp,
bill_freight_handling_code varchar(150),
bill_percent_disc_crade decimal,
bill_payment_terms_code varchar(150),
bill_adjust_schedule_code varchar(150),
bill_check_number varchar(150),
bill_deliv_instruction2 varchar(150),
bill_cc_account_name varchar(150),
bill_tax_exp_code varchar(150),
bill_cc_account_number varchar(150),
bill_carrier_long_id varchar(150),
bill_carrier_tax_id varchar(150),
bill_carrier_id varchar(150),
bill_deliv_instruction1 varchar(150),
bill_cstmr_price_grp_code varchar(150),
date_schedule_pick timestamp,
paid_by_long_id varchar(150),
paid_by_tax_id varchar(150),
paid_by_id varchar(150),
attachment_text varchar(150),
hold_order_code varchar(150),
currency_code_to varchar(150),
invoiced_to_long_id varchar(150),
invoiced_to_tax_id varchar(150),
invoiced_to_id varchar(150),
ship_to_postal_code varchar(150),
ship_to_address_line3 varchar(150),
ship_to_mailing_name varchar(150),
ship_to_cust_long_id varchar(150),
ship_to_cust_tax_id varchar(150),
ship_to_cust_id varchar(150),
ship_to_county_code varchar(150),
ship_to_address_line4 varchar(150),
ship_to_country_code varchar(150),
ship_to_address_line2 varchar(150),
ship_to_state_code varchar(150),
ship_to_city varchar(150),
ship_to_address_line1 varchar(150),
date_requested timestamp,
sold_to_postal_code varchar(150),
sold_to_address_line3 varchar(150),
sold_to_mailing_name varchar(150),
sold_to_cust_long_id varchar(150),
sold_to_cust_tax_id varchar(150),
sold_to_cust_id varchar(150),
sold_to_county_code varchar(150),
sold_to_address_line4 varchar(150),
sold_to_country_code varchar(150),
sold_to_address_line2 varchar(150),
sold_to_state_code varchar(150),
sold_to_city varchar(150),
sold_to_address_line1 varchar(150)
);

CREATE TABLE COLES_ORDER_DETAIL
(quantity_ordered decimal,
prod_item_free_form varchar(150),
prod_item_customer varchar(150),
prod_item_product varchar(150),
prod_item_id int,
prod_item_catalog varchar(150),
prod_item_weight decimal,
prod_lot_number varchar(150),
prod_desc_1 varchar(150),
prod_uom_code_weight varchar(150),
prod_item_volume decimal,
prod_uom_code_volume varchar(150),
prod_location varchar(150),
prod_desc_2 varchar(150),
user_reserved_code varchar(150),
user_reserved_number int,
user_teserved_date timestamp,
user_reserved_amount decimal,
user_reserved_reference varchar(150),
doc_line_numb_orig decimal,
doc_numb_orig varchar(150),
doc_comp_orig varchar(150),
doc_type_code_orig varchar(150),
time_scheduled_pick int,
agreement_supplement int,
unit_of_measure_code_tx varchar(150),
category_code_purch_005 varchar(150),
category_code_purch_004 varchar(150),
category_code_purch_003 varchar(150),
category_code_purch_002 varchar(150),
category_code_purch_001 varchar(150),
customer_PO varchar(150),
quantity_canceled decimal,
time_promised_original int,
category_code_sales_005 varchar(150),
category_code_sales_004 varchar(150),
category_code_sales_003 varchar(150),
category_code_sales_002 varchar(150),
category_code_sales_001 varchar(150),
date_cancel timestamp,
line_of_business_code varchar(150),
time_promised_ship int,
status_code_last varchar(150),
end_use_code varchar(150),
use_config_rule int,
action_type varchar(150),
business_unit varchar (150),
date_promised_ship timestamp,
date_promised_orig timestamp,
time_requested int,
qty_shippable decimal,
buss_unit_destination varchar(150),
duty_status_code varchar(150),
bill_uom_code_pricing varchar(150),
bill_adj_schdl_code varchar(150),
bill_price_code2 varchar(150),
bill_price_unit_domestic decimal,
bill_price_ext_domestic decimal,
bill_price_unit_foreign decimal,
bill_price_ext_foreign decimal,
bill_price_code1 varchar(150),
bill_price_code3 varchar(150),
bill_date_price_effective timestamp,
bill_is_zero_prince_override int,
bill_subledger varchar(150),
bill_payment_inst_code varchar(150),
bill_taxable_code varchar(150),
bill_tax_expl_code varchar(150),
bill_tax_rate_area_code varchar(150),
bill_carrier_long_id varchar(150),
bill_carrier_tax_id varchar(150),
bill_carrier_id varchar(150),
bill_print_mssg_code varchar(150),
bill_subledger_type_code varchar(150),
bill_freight_handling_code varchar(150),
bill_payment_terms_code varchar(150),
bill_mode_of_trnsprt_code varchar(150),
bill_route_code varchar(150),
date_schedule_pick timestamp,
status_code_next varchar(150),
doc_line_number decimal,
time_promised_delivery int,
date_promised_delivery timestamp,
supplier_long_id varchar(150),
supplier_tax_id varchar(150),
supplier_id varchar(150),
doc_line_numb_related decimal,
doc_numb_related varchar(150),
doc_comp_related varchar(150),
doc_type_code_related varchar(150),
agreement_id varchar(150),
ship_to_long_id varchar(150),
ship_to_tax_id varchar(150),
ship_to_id varchar(150),
line_type_code varchar(150),
qty_back_ordered decimal,
priority_code varchar(150),
date_requested timestamp,
reference varchar(150),
poa_complete_flag varchar(1),
asn_complete_flag varchar(1),
einvoice_complete_flag varchar(1)
);

create table COLES_CONFIGURATION
(customer_PO varchar(150),
detail_prod_item_product varchar(150),
detail_prod_item_id int,
qty_component decimal,
config_item_free_form varchar(150),
config_item_customer varchar(150),
config_item_product varchar(150),
config_item_id int,
config_item_catalog varchar(150),
business_unit varchar(150),
parent_item_free_form varchar(150),
parent_item_customer varchar(150),
parent_item_product varchar(150),
parent_item_id int,
parent_item_catalog varchar(150),
desc_1 varchar(150),
uom_code_component varchar(150),
line_type_code varchar(150)
);

create table COLES_SEGMENT
(customer_PO varchar(150),
detail_prod_item_product varchar(150),
detail_prod_item_id int,
config_item_product varchar(150),
config_item_id int,
segment_number int,
segment_value varchar(150)
);