no, I know. I didnt mention that I echoed the code. Sorry if I sounded attacking or anything, I just underlined it and capitalized it because that's how the words came out in my head. Empesizing the word can. didnt mean to yell. Once again, I apologize and appreciate your help. How do I post my table structure? Is this good enough?
CREATE TABLE hotlines (
unique_identifier int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
receiving_record_number CHAR(6) NOT NULL,
supplier_name VARCHAR(50),
supplier_code CHAR(7),
tolas_number VARCHAR(20),
purchase_order_number VARCHAR(20),
part_number VARCHAR(30) NOT NULL,
quantity CHAR(10) NOT NULL,
pdc CHAR(4) NOT NULL,
manual_packing_list CHAR(3),
pdc_hotline_page_comments TEXT,
scheduler_follow_up_date VARCHAR(20),
scheduler_follow_up_contacts VARCHAR(30),
scheduler_follow_up_problem TEXT,
vendor CHAR(3),
edi_radioset VARCHAR(10),
no_manual_packing_list CHAR(3),
no_po_on_packing_list CHAR(3),
no_packing_list CHAR(3),
no_part_number CHAR(3),
invalid_intl_part_number CHAR(3),
supplier_part_number_only CHAR(3),
not_in_tolas CHAR(3),
not_in_wms CHAR(3),
cancelled CHAR(3),
cancelled_Date VARCHAR(20),
shipped CHAR(3),
shipped_date VARCHAR(20),
bad_po CHAR(3),
invalid_order CHAR(3),
pending_req CHAR(3),
issued_new_drp_po CHAR(3),
new_po VARCHAR(20),
utilized_existing_drp_po CHAR(3),
existing_po VARCHAR(20),
modified_stc CHAR(3),
stc1 CHAR(4),
stc2 CHAR(4),
last_revision_Date_via_system_or_user CHAR(3),
last_revision_date VARCHAR(20),
chargeback CHAR(3),
change_due_date CHAR(3),
change_due_Date_from VARCHAR(20),
change_due_date_to VARCHAR(20),
request_pdc_to_interface CHAR(3),
called_supplier CHAR(3),
wms_receipt_received_but_not_showing_in_drp CHAR(3),
team_radioset VARCHAR(40),
unit_code CHAR(2),
scheduler VARCHAR(50),
remarks_annotated CHAR(3),
po_history TEXT,
packing_list TEXT,
user_ip_addy TEXT,
date_opened TEXT,
time_stamp_pdc DATETIME,
time_stamp_hotline_finish DATETIME,
PRIMARY KEY(unique_identifier) )
