<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE import SYSTEM "../xml/wcs.dtd">
<import>
<cleanconf objectname="tickler" type="obselete" statement="delete from tickler where (days(current timestamp) - days(lastupdate)) >= ? and status = 1" namearg="no" daysarg="yes" sequence="1" />
<cleanconf objectname="catentry" type="made_to_order" statement="UPDATE catentry SET state = 'D' WHERE catentry_id IN ( SELECT distinct catentry_id FROM rfqrspprod, rfqrsp WHERE rfqrspprod.rfqrsp_id = rfqrsp.rfqrsp_id AND rfqrsp.state IN (3, 9) AND catentry_id is NOT null ) AND catentry_id NOT IN ( SELECT distinct catentry_id FROM rfqrspprod , rfqrsp WHERE rfqrspprod.rfqrsp_id = rfqrsp.rfqrsp_id AND rfqrsp.state NOT IN (3,9) AND catentry_id IS NOT NULL ) AND catentry_id IN ( SELECT catentry_id FROM CATGPENREL , catgroup WHERE catgroup.catgroup_id = catgpenrel.catgroup_id AND catgroup.identifier = ? ) AND catentry_id NOT IN ( SELECT distinct catentry_id FROM rfqprod WHERE catentry_id IS NOT NULL ) AND catentry_id NOT IN ( SELECT distinct catentry_id FROM auction ) AND catentry_id NOT IN ( SELECT distinct catentry_id FROM orderitems WHERE catentry_id is NOT null ) AND catentry_id NOT IN ( SELECT distinct catentry_id FROM oicomplist WHERE catentry_id is NOT null ) AND catentry_id NOT IN ( SELECT distinct catentry_id FROM iitem ) AND catentry_id NOT IN ( SELECT distinct catentry_id FROM rmaitem WHERE catentry_id is NOT null ) AND catentry_id NOT IN ( SELECT distinct catentry_id FROM offer WHERE offer_id IN (select distinct offer_id FROM orderitems WHERE offer_id is NOT null) )" namearg="yes" sequence="1" daysarg="no" />
<cleanconf objectname="catentry" type="made_to_order" statement="update catentry set state='D' where catentry_id in (select catentry_id_parent from catentrel, catentry where catentry_id_child=catentry_id and state='D') and catentry_id not in (select catentry_id_parent from catentrel, catentry where catentry_id_child=catentry_id and state!='D')" namearg="no" sequence="2" daysarg="no" />
<cleanconf objectname="catentry" type="made_to_order" statement="update rfqrspprod set catentry_id = null where catentry_id in (select catentry_id from catentry where state = 'D')" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="catentry" type="made_to_order" statement="delete from catentry where state='D'" namearg="no" sequence="4" daysarg="no" />
<cleanconf objectname="cacheivl" type="obsolete" statement="delete from cacheivl where (days(CURRENT TIMESTAMP) - days(inserttime)) >= ?" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="fileupload" type="obsolete" statement="delete from fileupload where days(current timestamp) - days(uploadtime) >=?" sequence="1" namearg="no" daysarg="yes" />
<cleanconf objectname="store" type="markedfordelete" statement="select directory from store where store_id in (select storeent_id from storeent where markfordelete=1)" sequence="1" namearg="no" daysarg="no" statementtype="relative directory" />
<cleanconf objectname="store" type="markedfordelete" statement="select substr(filepath,1,length(rtrim(filepath))-length(rtrim(filename))-1) from fileupload where store_id in (select storeent_id from storeent where markfordelete=1)" sequence="2" namearg="no" daysarg="no" statementtype="absolute file" />
<cleanconf objectname="store" type="markedfordelete" statement="delete from storeent where markfordelete=1" sequence="3" namearg="no" daysarg="no" />
<cleanconf objectname="user" type="registered" statement="select attachmenturl from attachment where cast(attachment_id as char(60)) != cast(attachmenturl as char(254)) and member_id in (select users_id from users where registertype= 'R' and (days(CURRENT TIMESTAMP) - days(lastsession)) >= ? and (users_id not in (select member_id from orders where status != 'Q')) and (users_id > 0) and (users_id not in (select member_id from address where address_id in (select address_id from orderitems where address_id is not null and status != 'Q') or address_id in (select allocaddress_id from orderitems where allocaddress_id is not null and status != 'Q') or address_id in (select address_id from orders where address_id is not null and status !='Q'))))" namearg="no" sequence="1" daysarg="yes" statementtype="URL" />
<cleanconf objectname="user" type="registered" statement="delete from member where member_id in (select users_id from users where registertype= 'R' and (days(CURRENT TIMESTAMP) - days(lastsession)) >= ? and (users_id not in (select member_id from orders where status != 'Q')) and (users_id > 0) and (users_id not in (select member_id from address where address_id in (select address_id from orderitems where address_id is not null and status != 'Q') or address_id in (select allocaddress_id from orderitems where allocaddress_id is not null and status != 'Q') or address_id in (select address_id from orders where address_id is not null and status !='Q'))))" namearg="no" sequence="2" daysarg="yes" />
<cleanconf objectname="user" type="registered" statement="delete from aprvstatus where flowtype_id in (select flowtype_id from flowtype where identifier = 'UserRegistrationAdd') and entity_id not in (select member_id from member)" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="user" type="registered" statement="delete from flinstance where flowtype_id in (select flowtype_id from flowtype where identifier = 'UserRegistrationAdd') and entity_id not in (select member_id from member)" namearg="no" sequence="4" daysarg="no" />
<cleanconf objectname="organization" type="specified" statement="select attachmenturl from attachment where cast(attachment_id as char(60)) != cast(attachmenturl as char(254)) and member_id in (select orgentity_id from orgentity where orgentity_id = ?)" sequence="1" namearg="yes" daysarg="no" statementtype="URL" />
<cleanconf objectname="organization" type="specified" statement="delete from member where member_id in (select orgentity_id from orgentity where orgentity_id = ?)" sequence="2" namearg="yes" daysarg="no" />
<cleanconf objectname="user" type="guest" statement="select attachmenturl from attachment where cast(attachment_id as char(60)) != cast(attachmenturl as char(254)) and member_id in (select users_id from users where registertype='G' and (days(CURRENT TIMESTAMP) - days(prevlastsession)) >= ? and (users_id not in (select member_id from orders where status != 'Q')) and (users_id > 0) and (users_id not in (select member_id from address where address_id in (select address_id from orderitems where address_id is not null and status != 'Q') or address_id in (select allocaddress_id from orderitems where allocaddress_id is not null and status != 'Q') or address_id in (select address_id from orders where address_id is not null and status !='Q'))))" namearg="no" sequence="1" daysarg="yes" statementtype="URL" />
<cleanconf objectname="user" type="guest" statement="delete from member where member_id in (select users_id from users T1 where registertype='G' and (days(CURRENT TIMESTAMP) - days(prevlastsession)) >= ? And not Exists (select 1 from orders where orders.member_id=T1.users_id and status != 'Q') and (users_id > 0))" namearg="no" sequence="2" daysarg="yes" />
<cleanconf objectname="user" type="guest" statement="delete from aprvstatus where flowtype_id in (select flowtype_id from flowtype where identifier = 'UserRegistrationAdd') and entity_id not in (select member_id from member)" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="user" type="guest" statement="delete from flinstance where flowtype_id in (select flowtype_id from flowtype where identifier = 'UserRegistrationAdd') and entity_id not in (select member_id from member)" namearg="no" sequence="4" daysarg="no" />
<cleanconf objectname="calculation_code" type="markedfordelete" statement="delete from calcodedsc where calcode_id in (select calcode_id from calcode where published = 2)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="calculation_code" type="markedfordelete" statement="delete from calcodemgp where calcode_id in (select calcode_id from calcode where published = 2)" namearg="no" sequence="2" daysarg="no" />
<cleanconf objectname="calculation_code" type="markedfordelete" statement="delete from catencalcd where calcode_id in (select calcode_id from calcode where published = 2)" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="calculation_code" type="markedfordelete" statement="delete from shpmodclcd where calcode_id in (select calcode_id from calcode where published = 2)" namearg="no" sequence="4" daysarg="no" />
<cleanconf objectname="calculation_code" type="markedfordelete" statement="delete from rldiscount where calcode_id in (select calcode_id from calcode where published = 2)" namearg="no" sequence="5" daysarg="no" />
<cleanconf objectname="address" type="obsolete" statement="delete from address where status = 'T' and (days(CURRENT TIMESTAMP) - days(lastcreate)) >= ? and (address_id not in (select distinct address_id from orderitems where address_id is not null)) and (address_id not in (select distinct address_id from orders where address_id is not null)) and (address_id not in (select distinct allocaddress_id from orderitems where allocaddress_id is not null))" sequence="1" namearg="no" daysarg="yes" />
<cleanconf objectname="order" type="completed" statement="delete from orders where status = 'C' and (days(CURRENT TIMESTAMP) - days(lastupdate)) >= ? and orders_id not in (select orders_id from orderitems where orderitems_id in (select orderitems_id from rmaitem where orderitems_id is not null)) and orders_id not in (select orders_id from orderitems where orderitems.status != 'C')" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="order" type="completed" statement="delete from aprvstatus where flowtype_id in (select flowtype_id from flowtype where identifier = 'OrderProcess') and entity_id not in (select orders_id from orders)" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="order" type="completed" statement="delete from flinstance where flowtype_id in (select flowtype_id from flowtype where identifier = 'OrderProcess') and entity_id not in (select orders_id from orders)" namearg="no" sequence="4" daysarg="no" />
<cleanconf objectname="order" type="canceled" statement="delete from orders where status ='X' and (days(CURRENT TIMESTAMP) - days(lastupdate)) >= ? and orders_id not in (select orders_id from orderitems where orderitems_id in (select orderitems_id from rmaitem where orderitems_id is not null))" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="order" type="canceled" statement="delete from aprvstatus where flowtype_id in (select flowtype_id from flowtype where identifier = 'OrderProcess') and entity_id not in (select orders_id from orders)" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="order" type="canceled" statement="delete from flinstance where flowtype_id in (select flowtype_id from flowtype where identifier = 'OrderProcess') and entity_id not in (select orders_id from orders)" namearg="no" sequence="4" daysarg="no" />
<cleanconf objectname="order" type="shipped" statement="delete from orders where status ='S' and (days(CURRENT TIMESTAMP) - days(lastupdate)) >= ? and orders_id not in (select orders_id from orderitems where orderitems_id in (select orderitems_id from rmaitem where orderitems_id is not null))" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="order" type="shipped" statement="delete from aprvstatus where flowtype_id in (select flowtype_id from flowtype where identifier = 'OrderProcess') and entity_id not in (select orders_id from orders)" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="order" type="shipped" statement="delete from flinstance where flowtype_id in (select flowtype_id from flowtype where identifier = 'OrderProcess') and entity_id not in (select orders_id from orders)" namearg="no" sequence="4" daysarg="no" />
<cleanconf objectname="order" type="deposited" statement="delete from orders where status ='D' and (days(CURRENT TIMESTAMP) - days(lastupdate)) >= ? and orders_id not in (select orders_id from orderitems where orderitems_id in (select orderitems_id from rmaitem where orderitems_id is not null))" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="order" type="deposited" statement="delete from aprvstatus where flowtype_id in (select flowtype_id from flowtype where identifier = 'OrderProcess') and entity_id not in (select orders_id from orders)" namearg="no" sequence="2" daysarg="no" />
<cleanconf objectname="order" type="deposited" statement="delete from flinstance where flowtype_id in (select flowtype_id from flowtype where identifier = 'OrderProcess') and entity_id not in (select orders_id from orders)" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="order" type="stale_guest" statement="delete from orders where (status ='P' or status = 'I' or status = 'W' or status = 'N') and (days(CURRENT TIMESTAMP) - days(lastupdate)) >= ? and orders.member_id in (select distinct users_id from users where registertype = 'G') and (orders_id not in (select distinct orders_id from orderitems where inventorystatus != 'NALC' and inventorystatus is not null)) and orders_id not in (select orders_id from orderitems where orderitems_id in (select orderitems_id from rmaitem where orderitems_id is not null))" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="order" type="stale_guest" statement="delete from aprvstatus where flowtype_id in (select flowtype_id from flowtype where identifier = 'OrderProcess') and entity_id not in (select orders_id from orders)" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="order" type="stale_guest" statement="delete from flinstance where flowtype_id in (select flowtype_id from flowtype where identifier = 'OrderProcess') and entity_id not in (select orders_id from orders)" namearg="no" sequence="4" daysarg="no" />
<cleanconf objectname="order" type="stale_non_guest" statement="delete from orders where (status ='P' or status = 'I' or status = 'W' or status = 'N') and (days(CURRENT TIMESTAMP) - days(lastupdate)) >= ? and orders.member_id in (select distinct users_id from users where registertype != 'G') and (orders_id not in (select distinct orders_id from orderitems where inventorystatus != 'NALC' and inventorystatus is not null)) and orders_id not in (select orders_id from orderitems where orderitems_id in (select orderitems_id from rmaitem where orderitems_id is not null))" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="order" type="stale_non_guest" statement="delete from aprvstatus where flowtype_id in (select flowtype_id from flowtype where identifier = 'OrderProcess') and entity_id not in (select orders_id from orders)" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="order" type="stale_non_guest" statement="delete from flinstance where flowtype_id in (select flowtype_id from flowtype where identifier = 'OrderProcess') and entity_id not in (select orders_id from orders)" namearg="no" sequence="4" daysarg="no" />
<cleanconf objectname="order" type="quotation" statement="delete from orders where orders_id in (select child_id from ordquotrel where reltype='markedForDelete')" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="order" type="quotation" statement="delete from ordquotrel where child_id is null and reltype='markedForDelete'" namearg="no" sequence="2" daysarg="no" />
<cleanconf objectname="order" type="markfordelete" statement="delete from orderitems where orders_id in (select orders_id from orders where type = 'BIN' and status = 'J')" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="order" type="markfordelete" statement="delete from orders where type = 'TRH' and status = 'X'" namearg="no" sequence="2" daysarg="no" />
<cleanconf objectname="catentry" type="without_orderitems" statement="delete from catentry where markfordelete = 1 and ((days(CURRENT TIMESTAMP) - days(lastupdate)) >= ? or lastupdate is null) and catentry_id not in (select distinct catentry_id from auction) and catentry_id not in (select distinct catentry_id from orderitems where catentry_id is not null) and catentry_id not in (select distinct catentry_id from oicomplist where catentry_id is not null) and catentry_id not in (select distinct catentry_id from rmaitem where catentry_id is not null) and catentry_id not in (select distinct catentry_id from offer where offer_id in (select distinct offer_id from orderitems where offer_id is not null ) )" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="catentry" type="without_orderitems_iitems" statement="delete from catentry where markfordelete = 1 and ((days(CURRENT TIMESTAMP) - days(lastupdate)) >= ? or lastupdate is null) and catentry_id not in (select distinct catentry_id from auction) and catentry_id not in (select distinct catentry_id from orderitems where catentry_id is not null) and catentry_id not in (select distinct catentry_id from oicomplist where catentry_id is not null)and catentry_id not in (select distinct catentry_id from iitem) and catentry_id not in (select distinct catentry_id from rmaitem where catentry_id is not null) and catentry_id not in (select distinct catentry_id from offer where offer_id in (select distinct offer_id from orderitems where offer_id is not null))" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="calculation_code" type="obsolete" statement="delete from calcode where published = 2 and calcode_id not in (select distinct calcode_id from ordadjust where calcode_id is not null) and calcode_id not in (select distinct calcode_id from stencalusg where calcode_id is not null) and calcode_id not in (select distinct calcode_id from ordcalcd where calcode_id is not null) and calcode_id not in (select distinct calcode_id from ordicalcd where calcode_id is not null)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="fulfillment_center" type="obsolete" statement="delete from ffmcenter where markfordelete = 1 and ffmcenter_id not in (select distinct ffmcenter_id from radetail where ffmcenter_id is not null) and ffmcenter_id not in (select distinct ffmcenter_id from inventory where ffmcenter_id is not null) and ffmcenter_id not in (select distinct ffmcenter_id from rma where ffmcenter_id is not null ) and ffmcenter_id not in (select distinct ffmcenter_id from orderitems where ffmcenter_id is not null) and ffmcenter_id not in (select distinct allocffmc_id from orderitems where allocffmc_id is not null) and ffmcenter_id not in (select distinct ffmcenter_id from store where ffmcenter_id is not null) and ffmcenter_id not in (select distinct rtnffmctr_id from store where rtnffmctr_id is not null) and ffmcenter_id not in (select distinct ffmcenter_id from receipt where ffmcenter_id is not null) and ffmcenter_id not in (select distinct ffmcenter_id from auction where ffmcenter_id is not null) and ffmcenter_id not in (select distinct ffmcenter_id from auctionlog where ffmcenter_id is not null)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="store" type="specified" statement="delete from storeent where storeent_id = ? and type='S'" namearg="yes" sequence="1" daysarg="no" />
<cleanconf objectname="itemspecification" type="obsolete" statement="delete from itemspc where markfordelete = 1 and itemspc_id not in (select distinct itemspc_id from orderitems where itemspc_id is not null) and itemspc_id not in (select distinct itemspc_id from oicomplist where itemspc_id is not null) and itemspc_id not in (select distinct itemspc_id from versionspc where versionspc_id in (select distinct versionspc_id from receipt)) and itemspc_id not in (select distinct itemspc_id from radetail) and itemspc_id not in (select distinct itemspc_id from bkordalloc) and itemspc_id not in (select distinct itemspc_id from invreserve where itemspc_id is not null) and itemspc_id not in (select distinct itemspc_id from rmaitem) and itemspc_id not in (select distinct itemspc_id from rmaitemcmp) and itemspc_id not in (select distinct itemspc_id from catentry where itemspc_id is not null)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="baseitem" type="obsolete" statement="delete from baseitem where markfordelete = 1 and baseitem_id not in (select baseitem_id from catentry where baseitem_id is not null) and baseitem_id not in (select distinct baseitem_id from itemspc where markfordelete = 0 and itemspc_id in (select distinct itemspc_id from orderitems where itemspc_id is not null) or itemspc_id in (select distinct itemspc_id from oicomplist where itemspc_id is not null) or itemspc_id in (select distinct itemspc_id from versionspc where versionspc_id in (select distinct versionspc_id from receipt)) or itemspc_id in (select distinct itemspc_id from radetail) or itemspc_id in (select distinct itemspc_id from bkordalloc) or itemspc_id in (select distinct itemspc_id from invreserve where itemspc_id is not null) or itemspc_id in (select distinct itemspc_id from rmaitem) or itemspc_id in (select distinct itemspc_id from rmaitemcmp) or itemspc_id in (select distinct itemspc_id from catentry where itemspc_id is not null))" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="account" type="obsolete" statement="delete from trading where markfordelete = 1 and trdtype_id = 0 and trading_id not in (select account_id from trading where account_id is not null) and trading_id not in (select distinct account_id from ordpaymthd where account_id is not null)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="contract" type="obsolete" statement="delete from trading where markfordelete = 1 and trdtype_id = 1 and trading_id not in (select distinct trading_id from orderitems where trading_id is not null) and trading_id not in (select distinct trading_id from rma where trading_id is not null) and trading_id not in (select distinct trading_id from ordpaymthd where trading_id is not null) and trading_id not in (select distinct account_id from ordpaymthd where account_id is not null)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="contract" type="obsolete" statement="delete from productset where markfordelete = 1 and productset_id not in (select distinct productset_id from tradeposcn where productset_id is not null and tradeposcn_id in (select distinct tradeposcn_id from offer where offer_id in (select distinct offer_id from orderitems where offer_id is not null) ))" namearg="no" sequence="2" daysarg="no" />
<cleanconf objectname="contract" type="obsolete" statement="delete from tradeposcn where markfordelete = 1 and tradeposcn_id not in (select distinct tradeposcn_id from offer where offer_id in (select distinct offer_id from orderitems where offer_id is not null))" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="contract" type="obsolete" statement="delete from aprvstatus where flowtype_id in (select flowtype_id from flowtype where identifier = 'ContractSubmit') and entity_id not in (select trading_id from trading)" namearg="no" sequence="4" daysarg="no" />
<cleanconf objectname="contract" type="obsolete" statement="delete from flinstance where flowtype_id in (select flowtype_id from flowtype where identifier = 'ContractSubmit') and entity_id not in (select trading_id from trading)" namearg="no" sequence="5" daysarg="no" />
<cleanconf objectname="policy" type="obsolete" statement="delete from policy where days(current timestamp) - days(endtime) > ? and policy_id not in (select distinct policy_id from ordpaymthd where policy_id is not null) and policy_id not in (select distinct policy_id from rma where policy_id is not null)" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="rfq" type="obsolete" statement="delete from trading where markfordelete = 1 and trdtype_id in (2, 3, 4) and trading_id not in (select distinct trading_id from orderitems where trading_id is not null) and trading_id not in (select distinct trading_id from rma where trading_id is not null) and trading_id not in (select distinct trading_id from ordpaymthd where trading_id is not null) and trading_id not in (select distinct account_id from ordpaymthd where account_id is not null)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="rfq" type="obsolete" statement="delete from aprvstatus where flowtype_id in (select flowtype_id from flowtype where identifier = 'RFQResponse') and entity_id not in (select trading_id from trading)" namearg="no" sequence="2" daysarg="no" />
<cleanconf objectname="rfq" type="obsolete" statement="delete from flinstance where flowtype_id in (select flowtype_id from flowtype where identifier = 'RFQResponse') and entity_id not in (select trading_id from trading)" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="atp_inventory" type="obsolete" statement="delete from receipt where qtyonhand = 0 and qtyinkits = 0 and receipt_id not in (select distinct receipt_id from ordpickhst where receipt_id is not null) and receipt_id not in (select distinct receipt_id from ordshiphst where receipt_id is not null)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="inventory_adjustment_codes" type="obsolete" statement="delete from invadjcode where markfordelete = 1 and invadjcode_id not in (select distinct invadjcode_id from invadjust where invadjcode_id is not null)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="inventory_adjustments" type="obsolete" statement="delete from invadjust where days(CURRENT TIMESTAMP) - days(adjustmentdate) >= ?" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="rtnreasons" type="obsolete" statement="delete from rtnreason where markfordelete = 1 and rtnreason_id not in (select distinct rtnreason_id from rtnrcptdsp where rtnreason_id is not null) and rtnreason_id not in (select distinct rtnreason_id from rmaitem where rtnreason_id is not null)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="rma" type="abandoned" statement="delete from rma where status in ('PRC', 'EDT') and (days(CURRENT TIMESTAMP) - days(lastupdate)) >= ? and rma_id not in (select rma_id from rmaitem where rmaitem.status in ('APP', 'MAN')) and rma_id not in (select rma_id from rtnreceipt)" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="rma" type="canceled" statement="delete from rma where status = 'CAN' and (days(CURRENT TIMESTAMP) - days(lastupdate)) >= ?" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="rma" type="not_approved" statement="delete from rma where status = 'PND' and (days(CURRENT TIMESTAMP) - days(lastupdate)) >= ? and rma_id not in (select rma_id from rmaitem where rmaitem.status in ('APP', 'MAN') ) and rma_id not in (select rma_id from rtnreceipt)" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="rma" type="approved_or_partly_approved" statement="delete from rma where status = 'PND' and (days(CURRENT TIMESTAMP) - days(lastupdate)) >= ? and rma_id in (select rma_id from rmaitem where rmaitem.status in ('APP', 'MAN') ) and rma_id not in (select rma_id from rtnreceipt)" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="rma" type="completed" statement="delete from rma where status = 'CLO' and (days(CURRENT TIMESTAMP) - days(lastupdate)) >= ? and rma_id not in (select rma_id from rtnreceipt)" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="auction" type="settlement_closed" statement="delete from auction where austatus = 'SC' and (days(CURRENT TIMESTAMP) - days(updatetime)) >= ?" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="auction" type="retracted" statement="delete from auction where austatus = 'R' and (days(CURRENT TIMESTAMP) - days(updatetime)) >= ?" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="staglog" type="obsolete" statement="delete from staglog where stgprocessed = 1 and (days(CURRENT TIMESTAMP) - days(stgstmp)) >= ?" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="msgmemrel" type="obsolete" statement="delete from msgmemrel where message_id in (select m.message_id from message ms, msgmemrel m where ms.message_id = m.message_id and (status = 'D' or ((status = 'O' or sendstat = 'S') and (days(CURRENT TIMESTAMP) - days(posttime)) >= ?)))" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="message" type="obsolete" statement="delete from message where message_id not in (select message_id from msgmemrel) or (days(CURRENT TIMESTAMP) - days(posttime)) >= ?" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="usrtraffic" type="obsolete" statement="delete from cpgnlog where usrtraffic_id in (select usrtraffic_id from usrtraffic where (days(CURRENT TIMESTAMP) - days(stmp)) >= ?)" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="usrtraffic" type="obsolete" statement="delete from usrtraffic where (days(CURRENT TIMESTAMP) - days(stmp)) >= ?" namearg="no" sequence="2" daysarg="yes" />
<cleanconf objectname="cpgnlog" type="all" statement="delete from cpgnlog" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="cpgnstats" type="all" statement="delete from cpgnstats" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="pastats" type="all" statement="delete from pastats" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="pestats" type="all" statement="delete from pestats" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="pcstats" type="all" statement="delete from pcstats" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="sastats" type="all" statement="delete from sastats" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="auctionlog" type="obsolete" statement="delete from auctionlog where (days(CURRENT TIMESTAMP) - days(actiontime)) >= ?" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="bidlog" type="obsolete" statement="delete from bidlog where (days(CURRENT TIMESTAMP) - days(actiontime)) >= ?" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="autobidlog" type="obsolete" statement="delete from autobidlog where (days(CURRENT TIMESTAMP) - days(actiontime)) >= ?" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="forummsg" type="obsolete" statement="delete from forummsg where msgstatus = 'D' or (days(CURRENT TIMESTAMP) - days(posttime)) >= ?" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="expected_inventory_records" type="obsolete" statement="delete from ra where markfordelete = 1 and ra_id not in (select distinct ra_id from receipt, radetail where receipt.radetail_id = radetail.radetail_id)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="expected_inventory_record_details" type="obsolete" statement="delete from radetail where markfordelete = 1 and radetail_id not in (select distinct radetail_id from receipt where radetail_id is not null)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="vendor" type="obsolete" statement="delete from vendor where markfordelete = 1 and vendor_id not in (select distinct vendor_id from ra) and vendor_id not in (select distinct vendor_id from receipt where vendor_id is not null)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="attachment" type="obsolete" statement="delete from attachment where days(current timestamp) - days(timeupdated) >=? and (attachusg_id= 'Contract' or attachusg_id= 'RFQ' or attachusg_id= 'PattributeAttachment') and attachment_id not in (select distinct attachment_id from trdattach) and attachment_id not in (select distinct attachment_id from pattrvalue where attachment_id is not null)" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="attachment" type="markedfordelete" statement="select attachmenturl from attachment where cast(attachment_id as char(60)) != cast(attachmenturl as char(254)) and markfordelete =1 " sequence="1" namearg="no" daysarg="no" statementtype="URL" />
<cleanconf objectname="attachment" type="markedfordelete" statement="delete from attachment where markfordelete =1 " sequence="2" namearg="no" daysarg="no" />
<cleanconf objectname="coupon_promotion" type="expired" statement="delete from cppmn where days(current timestamp) - days(enddate) >=?" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="catalog_group" type="obsolete" statement="delete from catgroup where markfordelete = 1" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="productset" type="obsolete" statement="delete from productset where markfordelete = 1 and productset_id not in (select productset_id from tradeposcn where productset_id is not null)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="productset" type="obsolete_tradposcn" statement="delete from productset where productset_id in (select productset_id from tradeposcn where productset_id is not NULL and markfordelete = 1 and type = 'C')" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="tradeposcn" type="obsolete" statement="delete from tradeposcn where markfordelete = 1 and type = 'S'" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="experiment" type="obsolete" statement="delete from expresult where experiment_id in (select experiment_id from experiment where status = 'D')" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="experiment" type="obsolete" statement="delete from expstats where experiment_id in (select experiment_id from experiment where status = 'D')" namearg="no" sequence="2" daysarg="no" />
<cleanconf objectname="experiment" type="obsolete" statement="delete from experiment where status = 'D'" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="explog" type="obsolete" statement="delete from explog where (days(CURRENT TIMESTAMP) - days(created)) >= ?" namearg="no" sequence="1" daysarg="yes" />
<cleanconf objectname="PaymentRule" type="obsolete" statement="delete from edporder where order_id not in (select orders_id from orders)" namearg="no" sequence="1" daysarg="no" />
<cleanconf objectname="PaymentRule" type="obsolete" statement="delete from edprma where rma_id not in (select rma_id from rma)" namearg="no" sequence="2" daysarg="no" />
<cleanconf objectname="PaymentRule" type="obsolete" statement="delete from ppcpayinst where order_id not in (select orders_id from orders) or rma_id not in (select rma_id from rma)" namearg="no" sequence="3" daysarg="no" />
<cleanconf objectname="PaymentRule" type="sensitive_delete" statement="delete from ppcextdata where ppcpayinst_id in (select ppcpayinst_id from ppcpayinst where order_id in (select orders_id from orders where status='D' and (days(CURRENT TIMESTAMP) - days(lastupdate))>= ? ) or rma_id in (select rma_id from rma where status='CLO' and (days(CURRENT TIMESTAMP) - days(lastupdate))>= ?) )" namearg="no" sequence="3" daysarg="yes" />
<stgmertab tabnbr="10" tabname="member" />
<stgmertab tabnbr="20" tabname="orgentity" />
<stgmertab tabnbr="25" tabname="addrbook" />
<stgmertab tabnbr="26" tabname="address" />
<stgmertab tabnbr="30" tabname="mbrgrp" />
<stgmertab tabnbr="31" tabname="mbrgrpdesc" />
<stgmertab tabnbr="32" tabname="mbrgrpcond" />
<stgmertab tabnbr="35" tabname="trading" />
<stgmertab tabnbr="36" tabname="trddesc" />
<stgmertab tabnbr="40" tabname="mbrgrpusg" />
<stgmertab tabnbr="41" tabname="baseitem" />
<stgmertab tabnbr="42" tabname="baseitmdsc" />
<stgmertab tabnbr="43" tabname="itemspc" />
<stgmertab tabnbr="44" tabname="productset" />
<stgmertab tabnbr="45" tabname="prodsetdsc" />
<stgmertab tabnbr="46" tabname="storeent" />
<stgmertab tabnbr="50" tabname="catgroup" />
<stgmertab tabnbr="60" tabname="catgrpattr" />
<stgmertab tabnbr="70" tabname="catgrpdesc" />
<stgmertab tabnbr="80" tabname="catalog" />
<stgmertab tabnbr="85" tabname="catalogdsc" />
<stgmertab tabnbr="90" tabname="cattogrp" />
<stgmertab tabnbr="100" tabname="catgrprel" />
<stgmertab tabnbr="110" tabname="catentry" />
<stgmertab tabnbr="120" tabname="catentdesc" />
<stgmertab tabnbr="130" tabname="catentrel" />
<stgmertab tabnbr="140" tabname="catentship" />
<stgmertab tabnbr="145" tabname="listprice" />
<stgmertab tabnbr="170" tabname="attribute" />
<stgmertab tabnbr="180" tabname="attrvalue" />
<stgmertab tabnbr="230" tabname="ffmcenter" />
<stgmertab tabnbr="241" tabname="staddress" />
<stgmertab tabnbr="243" tabname="ffmcentds" />
<stgmertab tabnbr="250" tabname="storeentds" />
<stgmertab tabnbr="260" tabname="storelang" />
<stgmertab tabnbr="265" tabname="storlangds" />
<stgmertab tabnbr="270" tabname="storegrp" />
<stgmertab tabnbr="295" tabname="shipmode" />
<stgmertab tabnbr="296" tabname="shpmodedsc" />
<stgmertab tabnbr="298" tabname="contract" />
<stgmertab tabnbr="300" tabname="store" />
<stgmertab tabnbr="305" tabname="massoccece" />
<stgmertab tabnbr="307" tabname="massocgpgp" />
<stgmertab tabnbr="310" tabname="streltyp" />
<stgmertab tabnbr="315" tabname="storerel" />
<stgmertab tabnbr="320" tabname="storedef" />
<stgmertab tabnbr="330" tabname="storembrgp" />
<stgmertab tabnbr="350" tabname="storecat" />
<stgmertab tabnbr="360" tabname="storecent" />
<stgmertab tabnbr="370" tabname="storecgrp" />
<stgmertab tabnbr="380" tabname="dispentrel" />
<stgmertab tabnbr="390" tabname="dispcgprel" />
<stgmertab tabnbr="400" tabname="jurstgroup" />
<stgmertab tabnbr="410" tabname="jurst" />
<stgmertab tabnbr="420" tabname="jurstgprel" />
<stgmertab tabnbr="460" tabname="shparrange" />
<stgmertab tabnbr="470" tabname="inventory" />
<stgmertab tabnbr="490" tabname="calmethod" />
<stgmertab tabnbr="500" tabname="txcdclass" />
<stgmertab tabnbr="510" tabname="taxcgry" />
<stgmertab tabnbr="515" tabname="taxcgryds" />
<stgmertab tabnbr="520" tabname="calcode" />
<stgmertab tabnbr="525" tabname="calcodedsc" />
<stgmertab tabnbr="530" tabname="calrule" />
<stgmertab tabnbr="540" tabname="calscale" />
<stgmertab tabnbr="550" tabname="calrange" />
<stgmertab tabnbr="560" tabname="crulescale" />
<stgmertab tabnbr="570" tabname="calrulemgp" />
<stgmertab tabnbr="580" tabname="calrlookup" />
<stgmertab tabnbr="590" tabname="calcodtxex" />
<stgmertab tabnbr="600" tabname="shpjcrule" />
<stgmertab tabnbr="610" tabname="calscaleds" />
<stgmertab tabnbr="620" tabname="taxjcrule" />
<stgmertab tabnbr="630" tabname="tradeposcn" />
<stgmertab tabnbr="635" tabname="trdpscnxml" />
<stgmertab tabnbr="640" tabname="tdpscncntr" />
<stgmertab tabnbr="650" tabname="mgptrdpscn" />
<stgmertab tabnbr="680" tabname="offer" />
<stgmertab tabnbr="685" tabname="offerdesc" />
<stgmertab tabnbr="690" tabname="offerprice" />
<stgmertab tabnbr="700" tabname="catcntr" />
<stgmertab tabnbr="710" tabname="qtyformat" />
<stgmertab tabnbr="720" tabname="qtyfmtdesc" />
<stgmertab tabnbr="730" tabname="curformat" />
<stgmertab tabnbr="740" tabname="curcvlist" />
<stgmertab tabnbr="750" tabname="curlist" />
<stgmertab tabnbr="760" tabname="curfmtdesc" />
<stgmertab tabnbr="770" tabname="curconvert" />
<stgmertab tabnbr="790" tabname="cmdreg" />
<stgmertab tabnbr="820" tabname="catencalcd" />
<stgmertab tabnbr="830" tabname="catgpcalcd" />
<stgmertab tabnbr="840" tabname="langpair" />
<stgmertab tabnbr="850" tabname="catentattr" />
<stgmertab tabnbr="860" tabname="catgpenrel" />
<stgmertab tabnbr="870" tabname="acccmdgrp" />
<stgmertab tabnbr="880" tabname="acccustexc" />
<stgmertab tabnbr="890" tabname="pkgattr" />
<stgmertab tabnbr="900" tabname="pkgattrval" />
<stgmertab tabnbr="910" tabname="pkgitemrel" />
<stgmertab tabnbr="930" tabname="stencalusg" />
<stgmertab tabnbr="940" tabname="itemversn" />
<stgmertab tabnbr="950" tabname="versionspc" />
<stgmertab tabnbr="960" tabname="storeitem" />
<stgmertab tabnbr="970" tabname="shparjurgp" />
<stgmertab tabnbr="980" tabname="distarrang" />
<stgmertab tabnbr="990" tabname="invadjcode" />
<stgmertab tabnbr="1000" tabname="invadjdesc" />
<stgmertab tabnbr="1010" tabname="rtnreason" />
<stgmertab tabnbr="1020" tabname="rtnrsndesc" />
<stgmertab tabnbr="1030" tabname="storitmffc" />
<stgmertab tabnbr="1040" tabname="vendor" />
<stgmertab tabnbr="1050" tabname="vendordesc" />
<stgmertab tabnbr="1060" tabname="rtndspcode" />
<stgmertab tabnbr="1070" tabname="rtndspdesc" />
<stgmertab tabnbr="1080" tabname="attachment" />
<stgmertab tabnbr="1100" tabname="trdattach" />
<stgmertab tabnbr="1110" tabname="termcond" />
<stgmertab tabnbr="1120" tabname="tcdesc" />
<stgmertab tabnbr="1130" tabname="storecntr" />
<stgmertab tabnbr="1140" tabname="policy" />
<stgmertab tabnbr="1150" tabname="policytc" />
<stgmertab tabnbr="1155" tabname="policydesc" />
<stgmertab tabnbr="1160" tabname="cntrname" />
<stgmertab tabnbr="1170" tabname="cntrdisply" />
<stgmertab tabnbr="1180" tabname="policycmd" />
<stgmertab tabnbr="1190" tabname="account" />
<stgmertab tabnbr="1200" tabname="participnt" />
<stgmertab tabnbr="1210" tabname="flowadmin" />
<stgmertab tabnbr="1220" tabname="prsetcerel" />
<stgmertab tabnbr="1230" tabname="catconfinf" />
<stgmertab tabnbr="1240" tabname="catgrptpc" />
<stgmertab tabnbr="1250" tabname="catgrpps" />
<stgmertab tabnbr="1260" tabname="calcodemgp" />
<stgmertab tabnbr="1270" tabname="acpolicy" />
<stgmertab tabnbr="1280" tabname="acpoldesc" />
<stgmertab tabnbr="1290" tabname="acorgpol" />
<stgmertab tabnbr="1300" tabname="chargetype" />
<stgmertab tabnbr="1310" tabname="chrgtypdsc" />
<stgmertab tabnbr="1320" tabname="mbrattrval" />
<stgmertab tabnbr="1330" tabname="mbrrole" />
<stgmertab tabnbr="1340" tabname="mbrrel" />
<stgmertab tabnbr="1350" tabname="rtndnyrsn" />
<stgmertab tabnbr="1360" tabname="rtndnydesc" />
<stgmertab tabnbr="1370" tabname="creditline" />
<stgmertab tabnbr="1380" tabname="buyerpo" />
<stgmertab tabnbr="1390" tabname="pattribute" />
<stgmertab tabnbr="1400" tabname="pattrdesc" />
<stgmertab tabnbr="1410" tabname="pattrprod" />
<stgmertab tabnbr="1420" tabname="lmeventmap" />
<stgmertab tabnbr="1430" tabname="paymthd" />
<stgmertab tabnbr="1440" tabname="paymthddsc" />
<stgmertab tabnbr="1450" tabname="paymthdsup" />
<stgmertab tabnbr="1460" tabname="plcyacclck" />
<stgmertab tabnbr="1470" tabname="plcylckdsc" />
<stgmertab tabnbr="1480" tabname="plcypasswd" />
<stgmertab tabnbr="1490" tabname="plcypwddsc" />
<stgmertab tabnbr="1500" tabname="plcyacct" />
<stgmertab tabnbr="1510" tabname="plcyaccdsc" />
<stgmertab tabnbr="1520" tabname="plcytycmif" />
<stgmertab tabnbr="1540" tabname="profile" />
<stgmertab tabnbr="1550" tabname="profnvstrg" />
<stgmertab tabnbr="1560" tabname="schconfig" />
<stgmertab tabnbr="1570" tabname="schactive" />
<stgmertab tabnbr="1580" tabname="storetrans" />
<stgmertab tabnbr="1590" tabname="icmetareg" />
<stgmertab tabnbr="1600" tabname="icmregdesc" />
<stgmertab tabnbr="1610" tabname="ecetmpt" />
<stgmertab tabnbr="1670" tabname="ectptitm" />
<stgmertab tabnbr="1680" tabname="iniruleval" />
<stgmertab tabnbr="1690" tabname="icdewidreg" />
<stgmertab tabnbr="1700" tabname="iseditatt" />
<stgmertab tabnbr="1710" tabname="colltype" />
<stgmertab tabnbr="1720" tabname="acpolgrp" />
<stgmertab tabnbr="1730" tabname="acplgpdesc" />
<stgmertab tabnbr="1740" tabname="acplgpsubs" />
<stgmertab tabnbr="1750" tabname="acpolgppol" />
<stgmertab tabnbr="1760" tabname="tcattr" />
<stgmertab tabnbr="1770" tabname="psetadjmnt" />
<stgmertab tabnbr="1780" tabname="cntrstore" />
<stgmertab tabnbr="1790" tabname="dkoffer" />
<stgmertab tabnbr="1800" tabname="dkadjmnt" />
<stgmertab tabnbr="2001" tabname="collateral" />
<stgmertab tabnbr="2002" tabname="colldesc" />
<stgmertab tabnbr="2003" tabname="campaign" />
<stgmertab tabnbr="2004" tabname="initiative" />
<stgmertab tabnbr="2005" tabname="emspot" />
<stgmertab tabnbr="2006" tabname="esmapobj" />
<stgmertab tabnbr="2007" tabname="intvsched" />
<stgmertab tabnbr="2020" tabname="exptype" />
<stgmertab tabnbr="2021" tabname="experiment" />
<stgmertab tabnbr="2030" tabname="ordchgrsn" />
<stgmertab tabnbr="2031" tabname="ordchgrsnds" />
<stgmertab tabnbr="3001" tabname="px_group" />
<stgmertab tabnbr="3002" tabname="px_policy" />
<stgmertab tabnbr="3003" tabname="px_promotion" />
<stgmertab tabnbr="3004" tabname="px_dynattr" />
<stgmertab tabnbr="3005" tabname="px_grppolicy" />
<stgmertab tabnbr="3006" tabname="clcdpromo" />
<stgmertab tabnbr="3010" tabname="atchtgt" />
<stgmertab tabnbr="3011" tabname="atchtgtdsc" />
<stgmertab tabnbr="3012" tabname="atchast" />
<stgmertab tabnbr="3013" tabname="atchastlg" />
<stgmertab tabnbr="3014" tabname="atchrlus" />
<stgmertab tabnbr="3015" tabname="atchrlusds" />
<stgmertab tabnbr="3016" tabname="atchrel" />
<stgmertab tabnbr="3017" tabname="atchreldsc" />
<stgmrsttab tabnbr="10" tabname="member" colname="member_id" />
<stgmrsttab tabnbr="20" tabname="orgentity" colname="orgentity_id" />
<stgmrsttab tabnbr="30" tabname="mbrgrp" colname="mbrgrp_id" />
<stgmrsttab tabnbr="31" tabname="mbrgrpdesc" colname="mbrgrp_id" />
<stgmrsttab tabnbr="32" tabname="mbrgrpcond" colname="mbrgrp_id" />
<stgmrsttab tabnbr="35" tabname="staddress" colname="staddress_id" />
<stgmrsttab tabnbr="40" tabname="storeent" colname="storeent_id" />
<stgmrsttab tabnbr="80" tabname="cmdreg" colname="storeent_id" />
<stgmrsttab tabnbr="100" tabname="storeentds" colname="storeent_id" />
<stgmrsttab tabnbr="110" tabname="storegrp" colname="storegrp_id" />
<stgmrsttab tabnbr="120" tabname="ffmcenter" colname="ffmcenter_id" />
<stgmrsttab tabnbr="130" tabname="shipmode" colname="shipmode_id" />
<stgmrsttab tabnbr="135" tabname="ffmcentds" colname="ffmcenter_id" />
<stgmrsttab tabnbr="140" tabname="store" colname="store_id" />
<stgmrsttab tabnbr="150" tabname="storblkrsn" colname="storeent_id" />
<stgmrsttab tabnbr="155" tabname="stqotcfg" colname="storeent_id" />
<stgsitetab tabnbr="25" tabname="devicefmt" />
<stgsitetab tabnbr="30" tabname="language" />
<stgsitetab tabnbr="35" tabname="languageds" />
<stgsitetab tabnbr="40" tabname="catreltype" />
<stgsitetab tabnbr="50" tabname="catenttype" />
<stgsitetab tabnbr="60" tabname="massoctype" />
<stgsitetab tabnbr="70" tabname="massoc" />
<stgsitetab tabnbr="80" tabname="attrtype" />
<stgsitetab tabnbr="90" tabname="mbrgrptype" />
<stgsitetab tabnbr="110" tabname="statecode" />
<stgsitetab tabnbr="120" tabname="countcode" />
<stgsitetab tabnbr="130" tabname="txcdscheme" />
<stgsitetab tabnbr="140" tabname="calusage" />
<stgsitetab tabnbr="160" tabname="taxtype" />
<stgsitetab tabnbr="170" tabname="setcurr" />
<stgsitetab tabnbr="175" tabname="setcurrdsc" />
<stgsitetab tabnbr="180" tabname="qtyunit" />
<stgsitetab tabnbr="190" tabname="qtyunitdsc" />
<stgsitetab tabnbr="200" tabname="qtyconvert" />
<stgsitetab tabnbr="210" tabname="storecgry" />
<stgsitetab tabnbr="215" tabname="acccmdtype" />
<stgsitetab tabnbr="220" tabname="country" />
<stgsitetab tabnbr="230" tabname="stateprov" />
<stgsitetab tabnbr="240" tabname="member" />
<stgsitetab tabnbr="250" tabname="orgentity" />
<stgsitetab tabnbr="260" tabname="mbrgrp" />
<stgsitetab tabnbr="261" tabname="mbrgrpdesc" />
<stgsitetab tabnbr="265" tabname="mbrgrpcond" />
<stgsitetab tabnbr="270" tabname="staddress" />
<stgsitetab tabnbr="280" tabname="storeent" />
<stgsitetab tabnbr="300" tabname="cmdreg" />
<stgsitetab tabnbr="320" tabname="storeentds" />
<stgsitetab tabnbr="330" tabname="storegrp" />
<stgsitetab tabnbr="340" tabname="ffmcenter" />
<stgsitetab tabnbr="350" tabname="shipmode" />
<stgsitetab tabnbr="360" tabname="ffmcentds" />
<stgsitetab tabnbr="370" tabname="store" />
<stgsitetab tabnbr="380" tabname="outputq" />
<stgsitetab tabnbr="390" tabname="outputqdsc" />
<stgsitetab tabnbr="400" tabname="ordchnltyp" />
<stgsitetab tabnbr="410" tabname="invrsrvtyp" />
<stgsitetab tabnbr="420" tabname="invrsrvdsc" />
<stgsitetab tabnbr="430" tabname="tctype" />
<stgsitetab tabnbr="440" tabname="tcsubtype" />
<stgsitetab tabnbr="450" tabname="tcsubtypds" />
<stgsitetab tabnbr="460" tabname="policytype" />
<stgsitetab tabnbr="470" tabname="plcytypdsc" />
<stgsitetab tabnbr="480" tabname="trdtype" />
<stgsitetab tabnbr="490" tabname="trdtypedsc" />
<stgsitetab tabnbr="500" tabname="attachusg" />
<stgsitetab tabnbr="510" tabname="partrole" />
<stgsitetab tabnbr="520" tabname="partroleds" />
<stgsitetab tabnbr="530" tabname="flowdomain" />
<stgsitetab tabnbr="540" tabname="fldomndesc" />
<stgsitetab tabnbr="550" tabname="flowtype" />
<stgsitetab tabnbr="560" tabname="fltypedesc" />
<stgsitetab tabnbr="570" tabname="flow" />
<stgsitetab tabnbr="580" tabname="flowdesc" />
<stgsitetab tabnbr="590" tabname="flcompose" />
<stgsitetab tabnbr="600" tabname="flstategp" />
<stgsitetab tabnbr="610" tabname="flstgpdsc" />
<stgsitetab tabnbr="620" tabname="flstatedct" />
<stgsitetab tabnbr="630" tabname="flstdctdsc" />
<stgsitetab tabnbr="640" tabname="flstaterel" />
<stgsitetab tabnbr="650" tabname="fltransitn" />
<stgsitetab tabnbr="660" tabname="fltransdsc" />
<stgsitetab tabnbr="670" tabname="operator" />
<stgsitetab tabnbr="680" tabname="operatrdsc" />
<stgsitetab tabnbr="710" tabname="icdatareg" />
<stgsitetab tabnbr="720" tabname="itemtype" />
<stgsitetab tabnbr="730" tabname="chkcmd" />
<stgsitetab tabnbr="740" tabname="schcmd" />
<stgsitetab tabnbr="750" tabname="chkarrang" />
<stgsitetab tabnbr="760" tabname="acattr" />
<stgsitetab tabnbr="770" tabname="acattrdesc" />
<stgsitetab tabnbr="780" tabname="acactgrp" />
<stgsitetab tabnbr="790" tabname="acacgpdesc" />
<stgsitetab tabnbr="800" tabname="acresgrp" />
<stgsitetab tabnbr="810" tabname="acresgpdes" />
<stgsitetab tabnbr="820" tabname="acaction" />
<stgsitetab tabnbr="830" tabname="acactdesc" />
<stgsitetab tabnbr="840" tabname="acrescgry" />
<stgsitetab tabnbr="845" tabname="acrscgdes" />
<stgsitetab tabnbr="850" tabname="acrelation" />
<stgsitetab tabnbr="860" tabname="acreldesc" />
<stgsitetab tabnbr="870" tabname="acresgpres" />
<stgsitetab tabnbr="880" tabname="acresrel" />
<stgsitetab tabnbr="890" tabname="acresact" />
<stgsitetab tabnbr="1000" tabname="acresprim" />
<stgsitetab tabnbr="1010" tabname="acactactgp" />
<stgsitetab tabnbr="1015" tabname="acresatrel" />
<stgsitetab tabnbr="1020" tabname="mbrattr" />
<stgsitetab tabnbr="1030" tabname="role" />
<stgsitetab tabnbr="1040" tabname="tfdomain" />
<stgsitetab tabnbr="1050" tabname="tfsbdomain" />
<stgsitetab tabnbr="1060" tabname="tfsbdomdsc" />
<stgsitetab tabnbr="1070" tabname="tfdomdsc" />
<stgsitetab tabnbr="1080" tabname="tfalgotype" />
<stgsitetab tabnbr="1090" tabname="tfalgtypds" />
<stgsitetab tabnbr="1100" tabname="tfalgopol" />
<stgsitetab tabnbr="1110" tabname="tfalgpolds" />
<stgsitetab tabnbr="1120" tabname="buyerpotyp" />
<stgsitetab tabnbr="1130" tabname="numbrusg" />
<stgsitetab tabnbr="1140" tabname="numbrusgds" />
<stgsitetab tabnbr="1150" tabname="msgtypes" />
<stgsitetab tabnbr="1160" tabname="transport" />
<stgsitetab tabnbr="1170" tabname="acrelgrp" />
<stgsitetab tabnbr="1180" tabname="acrlgpdesc" />
<stgsitetab tabnbr="1190" tabname="opsystem" />
<stgsitetab tabnbr="1200" tabname="blkrsncode" />
<stgsitetab tabnbr="1210" tabname="blkrsndesc" />
<stgsitetab tabnbr="1220" tabname="merchant" />
<stgsitetab tabnbr="1230" tabname="merchconf" />
<stgsitetab tabnbr="1240" tabname="merchconfinfo" />
<stgsitetab tabnbr="1250" tabname="storemerch" />
<stguindtab tabname="trading" />
<stguindtab tabname="account" />
<stguindtab tabname="buyerpo" />
<stguindtab tabname="creditline" />
<stguindtab tabname="catencalcd" />
<stguindtab tabname="catgpcalcd" />
<stguindtab tabname="contract" />
<stguindtab tabname="catcntr" />
<stguindtab tabname="cntrdisply" />
<stguindtab tabname="storecntr" />
<stguindtab tabname="storedef" />
<stguindtab tabname="tdpscncntr" />
<stguindtab tabname="participnt" />
<stguindtab tabname="termcond" />
<stguindtab tabname="policytc" />
<stguindtab tabname="tcdesc" />
<stguindtab tabname="trdattach" />
<stguindtab tabname="trddesc" />
<stguindtab tabname="attachment" />
<stguindtab tabname="mbrattrval" />
<stguindtab tabname="tradeposcn" />
<stguindtab tabname="catgrptpc" />
<stguindtab tabname="mgptrdpscn" />
<stguindtab tabname="offer" />
<stguindtab tabname="offerdesc" />
<stguindtab tabname="offerprice" />
</import>