/*
Created		3/11/2014
Modified		24/7/2016
Project
Model
Company
Author
Version
Database		Oracle 10g
*/





Drop trigger "tu_TITEM"
/


Drop trigger "tu_TORDER_ITEM"
/





Drop trigger "tu_TUM"
/

Drop trigger "tu_TPROFILE_PERMISSION"
/


Drop trigger "tu_TUSER_PROFILE"
/

Drop trigger "tu_TUSER"
/

Drop trigger "tu_TCOMPONENT"
/














Drop trigger "tu_TEVENT"
/



Drop trigger "tu_TTAX_ENVIRONMENT"
/


Drop trigger "tu_TSUPPLIER"
/

Drop trigger "tu_TINVOICE"
/


Drop trigger "tu_TCREDIT_TERMS"
/


Drop trigger "tu_TMRP"
/


Drop trigger "tu_TEMAIL"
/






Drop trigger "tu_TNCM"
/


Drop trigger "tu_TSNAPSHOT"
/

Drop trigger "tu_TSNAPSHOT_ITEM"
/












Drop trigger "tu_TPURCHASE_ORDER"
/









Drop trigger "tu_TPURCHASE_ORDER_ITEM"
/

Drop trigger "tu_TPO_ITEM_STEP"
/


Drop trigger "tu_TPO_STEP"
/






Drop trigger "tu_TDRAWBACK"
/

Drop trigger "tu_TDRAWBACK_ITEM"
/






































































































Alter table "TORDER_ITEM" drop constraint "FK_ORDERITEM_ITEM"
/
Alter table "TITEM_UM" drop constraint "FK_UM_ITEM"
/
Alter table "TFORECAST_DETAIL" drop constraint "FK_FORECASTDETAIL_ITEM"
/
Alter table "TITEM_PRICE" drop constraint "FK_PRICELIST_ITEM"
/
Alter table "TINVOICE_ITEM" drop constraint "FK_INVOICEITEM_ITEM"
/
Alter table "TITEM_SUPPLIER" drop constraint "FK_ITEMSUPPLIER_ITEM"
/
Alter table "TMRP_DETAIL" drop constraint "FK_MRPDETAIL_ITEM"
/
Alter table "TITEM_STRUCTURE" drop constraint "FK_STRUCTURE_PARENTITEM"
/
Alter table "TITEM_STRUCTURE" drop constraint "FK_ITEM_COMPONENTITEM"
/
Alter table "TITEM_STOCK" drop constraint "PK_ITEMSTOCK_ITEM"
/
Alter table "TPURCHASE_ORDER_ITEM" drop constraint "FK_POITEM_ITEM"
/
Alter table "TITEM_CUSTOMER" drop constraint "FK_ITEMCUSTOMER_ITEM"
/
Alter table "TDRAWBACK_ITEM" drop constraint "FK_DRAWBACKITEM_ITEM"
/
Alter table "TORDER_ITEM" drop constraint "FK_ORDERITEM_ORDER"
/
Alter table "TORDER_STATUS" drop constraint "FK_ORDERSTATUS_ORDER"
/
Alter table "TORDER_APPROVAL" drop constraint "FK_ORDERAPPROVAL_ORDER"
/
Alter table "TORDER_ITEM_COMMENT" drop constraint "FK_ITEMCOMMENT_ORDERITEM"
/
Alter table "TORDER_ITEM_DELIVERY" drop constraint "FK_DELIVERY_ORDERITEM"
/
Alter table "TITEM" drop constraint "FK_ITEM_ITEMSTATUS"
/
Alter table "TORDER_STATUS" drop constraint "FK_ORDERSTATUS_ORDERSTEP"
/
Alter table "TITEM_UM" drop constraint "FK_ITEMUM_UMSOURCE"
/
Alter table "TITEM_UM" drop constraint "FK_ITEMUM_UMTARGET"
/
Alter table "TITEM" drop constraint "FK_ITEM_UM"
/
Alter table "TORDER_ITEM" drop constraint "FK_ORDERITEM_UMITEM"
/
Alter table "TORDER_ITEM" drop constraint "FK_ORDERITEM_UMORDER"
/
Alter table "TITEM_PRICE" drop constraint "FK_ITEMPRICE_UOM"
/
Alter table "TITEM_SUPPLIER" drop constraint "FK_ITEMSUPPLIER_UM"
/
Alter table "TPURCHASE_ORDER_ITEM" drop constraint "FK_POITEM_UM"
/
Alter table "TCOMPONENT_PERMISSION" drop constraint "FK_COMPONENTPERMISSION_PROFILE"
/
Alter table "TUSER" drop constraint "FK_USER_USERPROFILE"
/
Alter table "TPROFILE_PERMISSION" drop constraint "FK_PROFILEPERMISSION_PROFILE"
/
Alter table "TORDER" drop constraint "FK_ORDER_USUARIO"
/
Alter table "TORDER_STATUS" drop constraint "FK_ORDERSATUS_USER"
/
Alter table "TDATALOAD" drop constraint "FK_DATALOAD_USER"
/
Alter table "TFORECAST" drop constraint "FK_FORECAST_USER"
/
Alter table "TORDER_APPROVAL" drop constraint "FK_ORDERAPPROVAL_USER"
/
Alter table "TUSER_LOG" drop constraint "FK_USERLOG_USER"
/
Alter table "TORDER_ITEM_COMMENT" drop constraint "FK_ORDERITEMCOMM_USER"
/
Alter table "TINVOICE" drop constraint "FK_INVOICE_USER"
/
Alter table "TINVOICE_STATUS" drop constraint "FK_INVOICESTATUS_USER"
/
Alter table "TORDER" drop constraint "FK_ORDER_LASTUSER"
/
Alter table "TTICKET" drop constraint "FK_TICKET_USER"
/
Alter table "TPURCHASE_ORDER" drop constraint "FK_PURCHASEORDER_USER"
/
Alter table "TDRAWBACK" drop constraint "FK_DRAWBACK_USER"
/
Alter table "TCOMPONENT_PERMISSION" drop constraint "FK_COMPONENTEPERMISSAO_COMPONE"
/
Alter table "TITEM" drop constraint "FK_ITEM_PRODUCTLINE"
/
Alter table "TITEM" drop constraint "FK_ITEM_ITEMTYPE"
/
Alter table "TFORECAST_DETAIL" drop constraint "FK_FORECASTDETAIL_FORECAST"
/
Alter table "TUSER" drop constraint "FK_USER_CUSTOMER"
/
Alter table "TITEM_CUSTOMER" drop constraint "FK_ITEMCUSTOMER_CUSTOMER"
/
Alter table "TUSER_LOG" drop constraint "FK_USERLOG_EVENT"
/
Alter table "TNCM_TAXES" drop constraint "FK_FISCALENVIRONMENT_TAXES"
/
Alter table "TINVOICE" drop constraint "FK_INVOICE_SUPPLIER"
/
Alter table "TITEM_SUPPLIER" drop constraint "FK_ITEMSUPPLIER_SUPPLIER"
/
Alter table "TPURCHASE_ORDER" drop constraint "PK_PO_SUPPLIER"
/
Alter table "TINVOICE_ITEM" drop constraint "FK_INVOICEITEM_INVOICE"
/
Alter table "TINVOICE_STATUS" drop constraint "FK_INVOICESTATUS_INVOICE"
/
Alter table "TINVOICE" drop constraint "FK_INVOICE_CREDITTERMS"
/
Alter table "TMRP_DETAIL" drop constraint "FK_MRPDETAIL_MRP"
/
Alter table "TEMAIL_ATTACH" drop constraint "FK_ATTACHMENTS_EMAIL"
/
Alter table "TINVOICE_STATUS" drop constraint "FK_INVOICESTATUS_STEP"
/
Alter table "TNCM_TAXES" drop constraint "FK_NCMFISCALENV_NCM"
/
Alter table "TSNAPSHOT_ITEM" drop constraint "FK_SNAPSHOTITEM_SNAPSHOT"
/
Alter table "TSNAPSHOT_STRUCTURE" drop constraint "FK_PARENTITEM_SNAPSHOT"
/
Alter table "TSNAPSHOT_STRUCTURE" drop constraint "FK_COMPONENTITEM_SNAPSHOT"
/
Alter table "TITEM_STOCK_CHECK" drop constraint "FK_ITEMSTOCKCHECK_STOCKCHECK"
/
Alter table "TUSER" drop constraint "FK_USER_QUEUE"
/
Alter table "TPURCHASE_ORDER_ITEM" drop constraint "PK_PURCHASEORDERITEM_PO"
/
Alter table "TPO_STATUS" drop constraint "FK_POSTATUS_PO"
/
Alter table "TPO_ITEM_STATUS" drop constraint "FK_POITEM_POITEMSTATUS"
/
Alter table "TPO_ITEM_STATUS" drop constraint "FK_POITEMSTATUS_POITEMSTEP"
/
Alter table "TPURCHASE_ORDER_ITEM" drop constraint "FK_POITEM_POITEMSTEP"
/
Alter table "TPO_STATUS" drop constraint "FK_POSTATUS_POSTEP"
/
Alter table "TPURCHASE_ORDER" drop constraint "FK_PURCHASEORDER_POSTEP"
/
Alter table "TDRAWBACK_ITEM" drop constraint "FK_DRAWBACKITEM_DRAWBACK"
/
Alter table "TDRAWBACK_ITEM_BREAK" drop constraint "PK_BREAKDOWN_DRAWBACKITEM"
/



Drop table "TDRAWBACK_ITEM_BREAK"
/
Drop table "TDRAWBACK_ITEM"
/
Drop table "TDRAWBACK"
/
Drop table "TEXCHANGE_RATE"
/
Drop table "TMP_EXCHANGERATE"
/
Drop table "TITEM_CUSTOMER"
/
Drop table "TMP_CUSTOMERITEM"
/
Drop table "TPO_STATUS"
/
Drop table "TPO_STEP"
/
Drop table "TPO_ITEM_STATUS"
/
Drop table "TPO_ITEM_STEP"
/
Drop table "TPURCHASE_ORDER_ITEM"
/
Drop table "TMP_TAX_ENVIRONMENT"
/
Drop table "TMP_TAXBASEDATALOAD"
/
Drop table "TMP_TAXESDATALOAD"
/
Drop table "TMP_PRODLINEDATALOAD"
/
Drop table "TMP_STOCKDATALOAD"
/
Drop table "TMP_LOCDATALOAD"
/
Drop table "TMP_UMDATALOAD"
/
Drop table "TMP_ITEMDATALOAD"
/
Drop table "TPURCHASE_ORDER"
/
Drop table "TQUEUE"
/
Drop table "TTICKET"
/
Drop table "TTMP_SalesOrder"
/
Drop table "TQAD_TAXESINV"
/
Drop table "TQAD_NF"
/
Drop table "TLOCATION"
/
Drop table "TITEM_STOCK_CHECK"
/
Drop table "TSTOCK_CHECK"
/
Drop table "TITEM_STOCK"
/
Drop table "TORDER_ITEM_DELIVERY"
/
Drop table "TSNAPSHOT_STRUCTURE"
/
Drop table "TSNAPSHOT_ITEM"
/
Drop table "TSNAPSHOT"
/
Drop table "TNCM_TAXES"
/
Drop table "TNCM"
/
Drop table "TINVOICE_STEP"
/
Drop table "TINVOICE_STATUS"
/
Drop table "TITEM_STRUCTURE"
/
Drop table "TTAX_BASE"
/
Drop table "TEMAIL_ATTACH"
/
Drop table "TEMAIL"
/
Drop table "TVERSION"
/
Drop table "TMRP"
/
Drop table "TMRP_DETAIL"
/
Drop table "TCREDIT_TERMS"
/
Drop table "TITEM_SUPPLIER"
/
Drop table "TINVOICE"
/
Drop table "TSUPPLIER"
/
Drop table "TINVOICE_ITEM"
/
Drop table "TTAX_ENVIRONMENT"
/
Drop table "TTAX_RATE"
/
Drop table "TORDER_ITEM_COMMENT"
/
Drop table "TEVENT"
/
Drop table "TUSER_LOG"
/
Drop table "TORDER_APPROVAL"
/
Drop table "TITEM_PRICE"
/
Drop table "TCUSTOMER"
/
Drop table "TFORECAST_DETAIL"
/
Drop table "TFORECAST"
/
Drop table "TITEM_TYPE"
/
Drop table "TPRODUCT_LINE"
/
Drop table "TDATALOAD"
/
Drop table "TREPORT"
/
Drop table "TCONFIGURATION"
/
Drop table "THELP"
/
Drop table "TSEQUENCE_CONTROL"
/
Drop table "TCOMPONENT"
/
Drop table "TUSER"
/
Drop table "TUSER_PROFILE"
/
Drop table "TCOMPONENT_PERMISSION"
/
Drop table "TPROFILE_PERMISSION"
/
Drop table "TUM"
/
Drop table "TITEM_UM"
/
Drop table "TORDER_STEP"
/
Drop table "TORDER_STATUS"
/
Drop table "TITEM_STATUS"
/
Drop table "TORDER_ITEM"
/
Drop table "TORDER"
/
Drop table "TITEM"
/


-- Create Types section





-- Create Tables section


Create table "TITEM" (
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"CD_ITEMTYPE" Varchar2(20) NOT NULL ,
	"CD_PRODUCTLINE" Varchar2(4) NOT NULL ,
	"CD_UM" Varchar2(2) NOT NULL ,
	"DC_ITEM" Varchar2(50) NOT NULL ,
	"DC_ITEM2" Varchar2(50),
	"CD_ITEMSTATUS" Varchar2(8) NOT NULL ,
	"DT_STATUS" Date NOT NULL ,
	"DT_CREATION" Date NOT NULL ,
	"IN_PURCMANU" Varchar2(1) NOT NULL ,
	"VL_STOCK" Decimal(15,5) NOT NULL ,
	"VL_LEADTIME" Integer Default 0 NOT NULL ,
	"DC_NCM" Char(10),
	"DC_TAXCLASS" Char(3),
	"VL_COST" Decimal(15,5) Default 0 NOT NULL ,
	"DC_DRAWING" Varchar2(50),
	"CD_BUYER" Varchar2(10),
	"CD_VENDOR" Varchar2(10),
	"IN_PHANTOM" Smallint Default 0 NOT NULL ,
 Constraint "PK_ITEM" primary key ("CD_ITEM")
)
/

Create table "TORDER" (
	"NU_ORDER" Integer NOT NULL ,
	"CD_LASTUSER" Integer NOT NULL ,
	"DT_ORDER" Date NOT NULL ,
	"DT_DELIVERY" Date NOT NULL ,
	"CD_USER" Integer NOT NULL ,
	"CD_ORDERTYPE" Char(10) Default 0 NOT NULL ,
	"TX_COMPLEMENTARY" Long,
	"IN_ADJUSTED" Smallint Default 0 NOT NULL ,
	"TX_UPDATES" Long,
	"NU_SEFAZKEY" Varchar2(50),
	"NU_INVOICE" Integer,
	"NU_SERIES" Integer,
	"CD_CURRENCY" Varchar2(3) Default BRL NOT NULL ,
	"VL_EXCHANGERATE" Decimal(15,5) Default 1 NOT NULL ,
 Constraint "pk_TORDER" primary key ("NU_ORDER")
)
/

Create table "TORDER_ITEM" (
	"NU_ORDER" Integer NOT NULL ,
	"NU_SEQUENCE" Integer NOT NULL ,
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"VL_QUANTITY" Decimal(15,5) NOT NULL ,
	"CD_ITEMUM" Varchar2(2) NOT NULL ,
	"CD_ORDERUM" Varchar2(2) NOT NULL ,
	"VL_CONVERSION" Decimal(15,5) NOT NULL ,
	"VL_PRICE" Decimal(15,5) NOT NULL ,
	"DT_DELIVERY" Date NOT NULL ,
	"DT_DELIVERED" Date,
	"DC_TAXCLASS" Varchar2(3),
	"DC_OPERATIONTYPE" Varchar2(10),
	"IN_GIFTCOMPONENT" Smallint Default 0 NOT NULL ,
	"CD_REFERENCE" Varchar2(10),
	"IN_REMOVED" Smallint Default 0 NOT NULL ,
	"DC_REMOVALREASON" Varchar2(50),
 Constraint "pk_TORDER_ITEM" primary key ("NU_ORDER","NU_SEQUENCE")
)
/

Create table "TITEM_STATUS" (
	"CD_ITEMSTATUS" Varchar2(8) NOT NULL ,
	"DC_ITEMSTATUS" Varchar2(50) NOT NULL ,
 Constraint "pk_TITEM_STATUS" primary key ("CD_ITEMSTATUS")
)
/

Create table "TORDER_STATUS" (
	"NU_ORDER" Integer NOT NULL ,
	"NU_SEQUENCE" Integer NOT NULL ,
	"DT_STATUS" Date NOT NULL ,
	"CD_ORDERSTEP" Integer NOT NULL ,
	"CD_USER" Integer NOT NULL ,
 Constraint "pk_TORDER_STATUS" primary key ("NU_ORDER","NU_SEQUENCE")
)
/

Create table "TORDER_STEP" (
	"CD_ORDERSTEP" Integer NOT NULL ,
	"DC_ORDERSTEP" Varchar2(100) NOT NULL ,
	"IN_APPROVAL" Smallint NOT NULL ,
	"IN_EMAILALERT" Smallint NOT NULL ,
 Constraint "PK_ORDERSTEP" primary key ("CD_ORDERSTEP")
)
/

Create table "TITEM_UM" (
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"CD_SOURCEUM" Varchar2(2) NOT NULL ,
	"CD_TARGETUM" Varchar2(2) NOT NULL ,
	"VL_CONVERSION" Decimal(15,5) NOT NULL ,
 Constraint "pk_TITEM_UM" primary key ("CD_ITEM","CD_SOURCEUM","CD_TARGETUM")
)
/

Create table "TUM" (
	"CD_UM" Varchar2(2) NOT NULL ,
	"DC_UM" Varchar2(50) NOT NULL  UNIQUE ,
 Constraint "pk_TUM" primary key ("CD_UM")
)
/

Create table "TPROFILE_PERMISSION" (
	"CD_USERPROFILE" Integer NOT NULL ,
	"NM_FORM" Varchar2(50) NOT NULL ,
	"NM_FORMNAME" Varchar2(50) NOT NULL ,
	"IN_QUERY" Smallint Default 0 NOT NULL ,
	"IN_INSERT" Smallint Default 0 NOT NULL ,
	"IN_DELETE" Smallint Default 0 NOT NULL ,
	"IN_UPDATE" Smallint Default 0 NOT NULL ,
	"IN_TRANSFER" Smallint Default 0 NOT NULL ,
	"IN_PRINT" Smallint Default 0 NOT NULL ,
 Constraint "PK_USERPERMISSION" primary key ("CD_USERPROFILE","NM_FORM")
)
/

Create table "TCOMPONENT_PERMISSION" (
	"NM_FORM" Varchar2(50) NOT NULL ,
	"CD_COMPONENT" Integer NOT NULL ,
	"IN_VISIBILITY" Smallint Default 1,
	"CD_USERPROFILE" Integer NOT NULL ,
 Constraint "PK_COMPONENTEPERMISSAO" primary key ("NM_FORM","CD_COMPONENT","CD_USERPROFILE")
)
/

Create table "TUSER_PROFILE" (
	"CD_USERPROFILE" Integer NOT NULL ,
	"DC_USERPROFILE" Varchar2(20) NOT NULL ,
	"IN_EMAILALERT" Smallint Default 0 NOT NULL ,
	"IN_APPROVER" Smallint Default 0 NOT NULL ,
	"IN_PRICEAWARE" Smallint Default 0 NOT NULL ,
	"IN_STRUCTUREAWARE" Smallint Default 0 NOT NULL ,
	"IN_CUSTOMERAPPROVER" Smallint Default 0 NOT NULL ,
	"IN_QADINTEGRATOR" Smallint Default 0 NOT NULL ,
 Constraint "PK_USERPROFILE" primary key ("CD_USERPROFILE")
)
/

Create table "TUSER" (
	"CD_USER" Integer NOT NULL ,
	"CD_USERPROFILE" Integer NOT NULL ,
	"CD_CUSTOMER" Integer,
	"NM_USER" Varchar2(50) NOT NULL  UNIQUE ,
	"NM_LOGIN" Varchar2(10) NOT NULL  UNIQUE ,
	"DC_PASSWORD" Char(6) NOT NULL  UNIQUE ,
	"DC_EMAIL" Varchar2(100) NOT NULL ,
	"CD_QUEUE" Integer NOT NULL ,
 Constraint "PK_USER" primary key ("CD_USER")
)
/

Create table "TCOMPONENT" (
	"CD_COMPONENT" Integer NOT NULL ,
	"DC_COMPONENT" Varchar2(100) NOT NULL ,
	"TP_COMPONENT" Varchar2(100) NOT NULL ,
	"NM_FORM" Varchar2(50) NOT NULL ,
 Constraint "PK_COMPONENTE" primary key ("CD_COMPONENT")
)
/

Create table "TSEQUENCE_CONTROL" (
	"NM_SEQUENCE" Varchar2(50) NOT NULL ,
	"CD_NEXTSEQUENCE" Integer NOT NULL ,
 Constraint "PK_SEQUENCECONTROL" primary key ("NM_SEQUENCE")
)
/

Create table "THELP" (
	"NM_FORM" Varchar2(50) NOT NULL ,
	"NM_HELP" Varchar2(100) NOT NULL ,
	"NU_SEQUENCE" Integer NOT NULL ,
	"BL_HELP" Long,
	"DC_FILE" Varchar2(100),
 Constraint "PK_HELP" primary key ("NM_FORM","NM_HELP","NU_SEQUENCE")
)
/

Create table "TCONFIGURATION" (
	"CD_CONFIGURATION" Integer NOT NULL ,
	"DC_CATEGORY" Varchar2(50) Default SYSTEM NOT NULL ,
	"DC_CONFIGURATION" Varchar2(100) NOT NULL  UNIQUE ,
	"VL_CONFIGURATION" Varchar2(100) NOT NULL ,
	"TP_CONFIGURATION" Varchar2(20) NOT NULL ,
 Constraint "PK_CONFIGURATION" primary key ("CD_CONFIGURATION")
)
/

Create table "TREPORT" (
	"NM_FORM" Varchar2(50) NOT NULL ,
	"NM_REPORT" Varchar2(100) NOT NULL ,
	"BL_REPORT" Long,
 Constraint "PK_REPORT" primary key ("NM_FORM","NM_REPORT")
)
/

Create table "TDATALOAD" (
	"CD_DATALOAD" Integer NOT NULL ,
	"DC_LOADGROUP" Varchar2(50),
	"CD_USER" Integer NOT NULL ,
	"DT_DATALOAD" Date Default current_timestamp NOT NULL ,
	"BL_ITEM" Long,
	"BL_UM" Long,
	"BL_STOCK" Long,
	"BL_PRICE" Long,
	"BL_COST" Long,
	"BL_PRODUCTLINE" Long,
	"BL_PLANNING" Long,
 Constraint "pk_TDATALOAD" primary key ("CD_DATALOAD")
)
/

Create table "TPRODUCT_LINE" (
	"CD_PRODUCTLINE" Varchar2(4) NOT NULL ,
	"DC_PRODUCTLINE" Varchar2(50) NOT NULL ,
 Constraint "pk_TPRODUCT_LINE" primary key ("CD_PRODUCTLINE")
)
/

Create table "TITEM_TYPE" (
	"CD_ITEMTYPE" Varchar2(20) NOT NULL ,
	"DC_ITEMTYPE" Varchar2(50) NOT NULL ,
 Constraint "pk_TITEM_TYPE" primary key ("CD_ITEMTYPE")
)
/

Create table "TFORECAST" (
	"CD_FORECAST" Integer NOT NULL ,
	"CD_USER" Integer NOT NULL ,
	"DT_CREATION" Date NOT NULL ,
	"DC_STATUS" Varchar2(10) NOT NULL ,
	"NU_YEAR" Integer NOT NULL ,
	"DT_CLOSING" Date,
	"IN_MODIFIED" Smallint Default 0 NOT NULL ,
	"DT_MODIFICATION" Date,
 Constraint "pk_TFORECAST" primary key ("CD_FORECAST")
)
/

Create table "TFORECAST_DETAIL" (
	"CD_FORECAST" Integer NOT NULL ,
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"VL_JANUARY" Decimal(15,5) Default 0 NOT NULL ,
	"VL_FEBRUARY" Decimal(15,5) Default 0 NOT NULL ,
	"VL_MARCH" Decimal(15,5) Default 0 NOT NULL ,
	"VL_APRIL" Decimal(15,5) Default 0 NOT NULL ,
	"VL_MAY" Decimal(15,5) Default 0 NOT NULL ,
	"VL_JUNE" Decimal(15,5) Default 0 NOT NULL ,
	"VL_JULY" Decimal(15,5) Default 0 NOT NULL ,
	"VL_AUGUST" Decimal(15,5) Default 0 NOT NULL ,
	"VL_SEPTEMBER" Decimal(15,5) Default 0 NOT NULL ,
	"VL_OCTOBER" Decimal(15,5) Default 0 NOT NULL ,
	"VL_NOVEMBER" Decimal(15,5) Default 0 NOT NULL ,
	"VL_DECEMBER" Decimal(15,5) Default 0 NOT NULL ,
 Constraint "pk_TFORECAST_DETAIL" primary key ("CD_FORECAST","CD_ITEM")
)
/

Create table "TCUSTOMER" (
	"CD_CUSTOMER" Integer NOT NULL ,
	"NM_CUSTOMER" Varchar2(50) NOT NULL ,
	"CD_CURRENCY" Char(3) NOT NULL ,
	"CD_ORDERCURRENCY" Char(3) Default BRL NOT NULL ,
	"CD_EXTERNALREFERENCE" Varchar2(50),
	"NU_DELIVERYDAYS" Integer Default 0 NOT NULL ,
	"DC_ORDERCYCLE" Varchar2(20) Default 'Weekly' NOT NULL ,
	"DC_ORDERWEEK" Varchar2(10) Default 'Week 1' NOT NULL ,
	"DC_DELIVERYWEEKDAY" Varchar2(10) Default 'Monday' NOT NULL ,
	"DC_PLACINGWEEKDAY" Varchar2(10) Default 'Friday' NOT NULL ,
	"CD_GROUPTYPE" Varchar2(10),
	"DC_SALESOPERATIONTYPE" Varchar2(10),
	"DC_BREAKDOWNOPERATIONTYPE" Varchar2(10),
	"DC_SALESENVIRONMENT" Varchar2(10),
	"DC_PURCHASEOPERATIONTYPE" Varchar2(10),
 Constraint "pk_TCUSTOMER" primary key ("CD_CUSTOMER")
)
/

Create table "TITEM_PRICE" (
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"CD_UM" Varchar2(2) NOT NULL ,
	"CD_PRICELIST" Varchar2(10) NOT NULL ,
	"VL_PRICE" Decimal(15,5) NOT NULL ,
	"CD_CURRENCY" Char(3) NOT NULL ,
	"CD_GROUPTYPE" Varchar2(10) NOT NULL
)
/

Create table "TORDER_APPROVAL" (
	"NU_ORDER" Integer NOT NULL ,
	"CD_USER" Integer NOT NULL ,
	"IN_APPROVED" Integer Default 0 NOT NULL ,
	"DT_APPROVAL" Date,
	"IN_REJECTED" Integer Default 0 NOT NULL ,
	"DT_REJECTION" Date,
	"DC_REJECTIONREASON" Varchar2(100),
 Constraint "PK_ORDERAPPROVAL" primary key ("NU_ORDER","CD_USER")
)
/

Create table "TUSER_LOG" (
	"CD_USER" Integer NOT NULL ,
	"DT_LOG" Date Default current_timestamp NOT NULL ,
	"CD_EVENT" Integer NOT NULL ,
 Constraint "pk_TUSER_LOG" primary key ("CD_USER","DT_LOG","CD_EVENT")
)
/

Create table "TEVENT" (
	"CD_EVENT" Integer NOT NULL ,
	"DC_EVENT" Varchar2(50) NOT NULL ,
 Constraint "pk_TEVENT" primary key ("CD_EVENT")
)
/

Create table "TORDER_ITEM_COMMENT" (
	"NU_ORDER" Integer NOT NULL ,
	"NU_SEQUENCE" Integer NOT NULL ,
	"DT_COMMENT" Date Default CURRENT_TIMESTAMP NOT NULL ,
	"CD_USER" Integer NOT NULL ,
	"DC_COMMENT" Varchar2(500) NOT NULL ,
 Constraint "pk_TORDER_ITEM_COMMENT" primary key ("NU_ORDER","NU_SEQUENCE","DT_COMMENT","CD_USER","DC_COMMENT")
)
/

Create table "TTAX_RATE" (
	"DC_TAXTYPE" Varchar2(15) NOT NULL ,
	"DC_OPERATIONTYPE" Varchar2(10) NOT NULL ,
	"DC_TAXCLASS" Varchar2(3) NOT NULL ,
	"VL_RATE" Decimal(15,5) NOT NULL ,
	"NU_CALCULATION" Integer NOT NULL ,
	"IN_TAXINCLUDED" Smallint Default 0 NOT NULL ,
	"DC_TAXBASE" Varchar2(15),
 Constraint "PK_TAXRATE" primary key ("DC_TAXTYPE","DC_OPERATIONTYPE","DC_TAXCLASS")
)
/

Create table "TTAX_ENVIRONMENT" (
	"DC_ENVIRONMENT" Varchar2(15) NOT NULL ,
	"DC_TAXTYPE" Varchar2(15) NOT NULL ,
 Constraint "PK_ENVIRONMENTTAXES" primary key ("DC_ENVIRONMENT","DC_TAXTYPE")
)
/

Create table "TINVOICE_ITEM" (
	"CD_INVOICE" Integer NOT NULL ,
	"NU_SEQUENCE" Integer NOT NULL ,
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"VL_QUANTITY" Decimal(15,5) Default 0 NOT NULL ,
	"CD_UM" Varchar2(2) NOT NULL ,
	"VL_CIFUNIT" Decimal(15,5) Default 0 NOT NULL ,
	"VL_ORDERUNIT" Decimal(15,5) Default 0 NOT NULL ,
	"VL_TOTALCIF" Decimal(15,5) Default 0 NOT NULL ,
	"DC_NCM" Char(10) NOT NULL ,
	"VL_ICMSRATE" Decimal(15,5) Default 0 NOT NULL ,
	"VL_IMPORTRATE" Decimal(15,5) Default 0 NOT NULL ,
	"VL_IPIRATE" Decimal(15,5) NOT NULL ,
	"VL_PISRATE" Decimal(15,5) Default 0 NOT NULL ,
	"VL_COFINSRATE" Decimal(15,5) Default 0 NOT NULL ,
	"VL_COFCPLRATE" Decimal(15,5) Default 0 NOT NULL ,
	"DC_OPERATIONTYPE" Varchar2(15) NOT NULL ,
	"DC_TAXCLASS" Char(3) NOT NULL ,
	"VL_NETWEIGHT" Decimal(15,5) Default 0 NOT NULL ,
	"VL_GROSSWEIGHT" Decimal(15,5) Default 0 NOT NULL ,
	"NU_ADICAO" Integer,
	"NU_ITEM" Integer,
	"NU_PURCHASEORDER" Varchar2(20),
	"NU_ORDERITEM" Integer,
	"DC_LOCATION" Varchar2(80),
	"DC_LOT" Varchar2(30),
	"DT_EXPIRATION" Date,
 Constraint "PK_INVOICEITEM" primary key ("CD_INVOICE","NU_SEQUENCE")
)
/

Create table "TSUPPLIER" (
	"CD_SUPPLIER" Integer NOT NULL ,
	"NM_SUPPLIER" Varchar2(50) NOT NULL ,
	"CD_CURRENCY" Char(3) NOT NULL ,
	"CD_EXTERNALREFERENCE" Varchar2(10),
	"DC_OPERATIONTYPE" Varchar2(10),
	"CD_CURRENCY" Char(3),
	"CD_STATE" Char(2),
	"CD_FEDERALID" Varchar2(20),
 Constraint "PK_SUPPLIER" primary key ("CD_SUPPLIER")
)
/

Create table "TINVOICE" (
	"CD_INVOICE" Integer NOT NULL ,
	"CD_CREDITTERMS" Varchar2(10) NOT NULL ,
	"CD_USER" Integer NOT NULL ,
	"CD_SUPPLIER" Integer NOT NULL ,
	"CD_INVOICEMODEL" Char(2) Default 55 NOT NULL ,
	"NU_INVOICETYPE" Integer Default 1 NOT NULL ,
	"DT_INVOICE" Date NOT NULL ,
	"VL_SISCOMEX" Decimal(15,5) Default 0 NOT NULL ,
	"VL_AFRMM" Decimal(15,5) Default 0 NOT NULL ,
	"DC_ENVIRONMENT" Varchar2(15) NOT NULL ,
	"CD_ORDERCURRENCY" Char(3) Default 'BRL' NOT NULL ,
	"NU_DI" Varchar2(20),
	"DT_DI" Date,
	"DC_PLACEOFLANDING" Varchar2(20),
	"DT_LANDING" Date,
	"NU_TRANSPORTROUTE" Integer,
	"NU_INVOICE" Integer,
	"NU_SERIES" Integer,
	"VL_EXCHANGERATE" Decimal(15,5) Default 0,
	"DC_STATEOFLANDING" Varchar2(2),
	"CD_CREDITTERMS" Varchar2(10),
	"NU_SEFAZKEY" Varchar2(50),
	"DC_TRANSPORTER" Varchar2(50),
	"DC_PROCESSREFERENCE" Varchar2(50),
	"IN_CLOSED" Smallint Default 0 NOT NULL ,
	"VL_WAREHOUSING" Decimal(15,5),
	"VL_DELIVERYFREIGHT" Decimal(15,5),
	"VL_BROKER" Decimal(15,5),
	"VL_FINE" Decimal(15,5),
	"VL_GRUANVISA" Decimal(15,5),
	"VL_BLAWB" Decimal(15,5),
 Constraint "PK_INVOICE" primary key ("CD_INVOICE")
)
/

Create table "TITEM_SUPPLIER" (
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"CD_UM" Varchar2(2) NOT NULL ,
	"CD_SUPPLIER" Integer NOT NULL ,
	"CD_CURRENCY" Varchar2(3) NOT NULL ,
	"VL_PRICE" Decimal(15,5) Default 0 NOT NULL ,
 Constraint "PK_ITEMSUPPLIER" primary key ("CD_ITEM","CD_UM","CD_SUPPLIER","CD_CURRENCY")
)
/

Create table "TCREDIT_TERMS" (
	"CD_CREDITTERMS" Varchar2(10) NOT NULL ,
	"DC_CREDITTERMS" Varchar2(50) NOT NULL ,
 Constraint "pk_TCREDIT_TERMS" primary key ("CD_CREDITTERMS")
)
/

Create table "TMRP_DETAIL" (
	"CD_MRP" Integer NOT NULL ,
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"NU_YEAR" Integer NOT NULL ,
	"VL_JANUARY" Decimal(15,5) Default 0,
	"VL_JANSUGGESTION" Decimal(15,5),
	"VL_FEBRUARY" Decimal(15,5) Default 0,
	"VL_FEBSUGGESTION" Decimal(15,5),
	"VL_MARCH" Decimal(15,5) Default 0,
	"VL_MARSUGGESTION" Decimal(15,5),
	"VL_APRIL" Decimal(15,5) Default 0,
	"VL_APRSUGGESTION" Decimal(15,5),
	"VL_MAY" Decimal(15,5) Default 0,
	"VL_MAYSUGGESTION" Decimal(15,5),
	"VL_JUNE" Decimal(15,5) Default 0,
	"VL_JUNSUGGESTION" Decimal(15,5),
	"VL_JULY" Decimal(15,5) Default 0,
	"VL_JULSUGGESTION" Decimal(15,5),
	"VL_AUGUST" Decimal(15,5) Default 0,
	"VL_AUGSUGGESTION" Decimal(15,5),
	"VL_SEPTEMBER" Decimal(15,5) Default 0,
	"VL_SEPSUGGESTION" Decimal(15,5),
	"VL_OCTOBER" Decimal(15,5) Default 0,
	"VL_OCTSUGGESTION" Decimal(15,5),
	"VL_NOVEMBER" Decimal(15,5) Default 0,
	"VL_NOVSUGGESTION" Decimal(15,5),
	"VL_DECEMBER" Decimal(15,5) Default 0,
	"VL_DECSUGGESTION" Decimal(15,5),
 Constraint "PK_MRPDETAIL" primary key ("CD_MRP","CD_ITEM","NU_YEAR")
)
/

Create table "TMRP" (
	"CD_MRP" Integer NOT NULL ,
	"DT_MRP" Date NOT NULL ,
 Constraint "PK_MRP" primary key ("CD_MRP")
)
/

Create table "TVERSION" (
	"CD_VERSION" Varchar2(10) NOT NULL ,
	"BL_FILE" Long NOT NULL ,
 Constraint "PK_VERSION" primary key ("CD_VERSION")
)
/

Create table "TEMAIL" (
	"CD_EMAIL" Integer NOT NULL ,
	"DT_EMAIL" Date NOT NULL ,
	"DC_RECIPIENTS" Varchar2(1000) NOT NULL ,
	"DC_SUBJECT" Varchar2(100) NOT NULL ,
	"IN_SENT" Smallint Default 0 NOT NULL ,
	"DT_SENDING" Date,
 Constraint "PK_EMAIL" primary key ("CD_EMAIL")
)
/

Create table "TEMAIL_ATTACH" (
	"CD_EMAIL" Integer NOT NULL ,
	"NU_SEQUENCE" Integer NOT NULL ,
	"DC_CONTENTTYPE" Varchar2(50) NOT NULL ,
	"BL_ATTACHMENT" Long NOT NULL ,
 Constraint "PK_ATTACHMENT" primary key ("CD_EMAIL","NU_SEQUENCE")
)
/

Create table "TTAX_BASE" (
	"DC_TAXBASE" Varchar2(15) NOT NULL ,
	"DC_TAXTYPE" Varchar2(15) NOT NULL ,
	"VL_BASEPERCENTAGE" Decimal(15,5) NOT NULL ,
 Constraint "PK_TAXBASE" primary key ("DC_TAXBASE","DC_TAXTYPE")
)
/

Create table "TITEM_STRUCTURE" (
	"CD_PARENTITEM" Varchar2(10) NOT NULL ,
	"CD_COMPONENTITEM" Varchar2(10) NOT NULL ,
	"CD_TYPESTRUCTURE" Char(1) Default S NOT NULL ,
	"CD_TYPEQUANTITY" Char(1) Default B NOT NULL ,
	"VL_QUANTITY" Decimal(15,5) Default 0 NOT NULL ,
 Constraint "pk_TITEM_STRUCTURE" primary key ("CD_PARENTITEM","CD_COMPONENTITEM")
)
/

Create table "TINVOICE_STATUS" (
	"CD_INVOICE" Integer NOT NULL ,
	"NU_SEQUENCE" Smallint NOT NULL ,
	"CD_USER" Integer NOT NULL ,
	"CD_INVOICESTEP" Integer NOT NULL ,
	"DT_STATUS" Date NOT NULL ,
 Constraint "PK_INVOICESTATUS" primary key ("CD_INVOICE","NU_SEQUENCE","CD_USER")
)
/

Create table "TINVOICE_STEP" (
	"CD_INVOICESTEP" Integer NOT NULL ,
	"DC_INVOICESTEP" Varchar2(50) NOT NULL ,
 Constraint "PK_INVOICESTEP" primary key ("CD_INVOICESTEP")
)
/

Create table "TNCM" (
	"DC_NCM" Varchar2(10) NOT NULL ,
 Constraint "pk_TNCM" primary key ("DC_NCM")
)
/

Create table "TNCM_TAXES" (
	"DC_ENVIRONMENT" Varchar2(15) NOT NULL ,
	"DC_NCM" Varchar2(10) NOT NULL ,
	"DC_TAXTYPE" Varchar2(15) NOT NULL ,
	"VL_RATE" Decimal(15,5) NOT NULL ,
 Constraint "pk_TNCM_TAXES" primary key ("DC_ENVIRONMENT","DC_NCM","DC_TAXTYPE")
)
/

Create table "TSNAPSHOT" (
	"CD_SNAPSHOT" Integer NOT NULL  UNIQUE ,
	"DT_SNAPSHOT" Date NOT NULL ,
	"DC_SNAPSHOT" Varchar2(50) NOT NULL ,
 Constraint "pk_TSNAPSHOT" primary key ("CD_SNAPSHOT")
)
/

Create table "TSNAPSHOT_ITEM" (
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"CD_SNAPSHOT" Integer NOT NULL ,
	"DC_ITEM" Varchar2(50) NOT NULL ,
	"DC_ITEM2" Varchar2(50) NOT NULL ,
	"CD_PRODUCTLINE" Varchar2(3) NOT NULL ,
	"IN_PM" Char(1) NOT NULL ,
	"CD_ITEMTYPE" Varchar2(10) NOT NULL ,
	"CD_UM" Char(2) NOT NULL ,
 Constraint "pk_TSNAPSHOT_ITEM" primary key ("CD_ITEM","CD_SNAPSHOT")
)
/

Create table "TSNAPSHOT_STRUCTURE" (
	"CD_PARENTSNAPSHOT" Integer NOT NULL ,
	"CD_PARENTITEM" Varchar2(10) NOT NULL ,
	"CD_COMPONENTSNAPSHOT" Integer NOT NULL ,
	"CD_COMPONENTITEM" Varchar2(10) NOT NULL ,
	"DC_REFERENCE" Varchar2(20) NOT NULL ,
	"VL_QUANTITY" Decimal(15,5) NOT NULL ,
	"DT_MODIFICATION" Date,
	"DT_ADDING" Date,
	"CD_UM" Char(2),
	"CD_QUANTITYTYPE" Char(1) NOT NULL ,
 Constraint "pk_TSNAPSHOT_STRUCTURE" primary key ("CD_PARENTSNAPSHOT","CD_PARENTITEM","CD_COMPONENTSNAPSHOT","CD_COMPONENTITEM","DC_REFERENCE")
)
/

Create table "TORDER_ITEM_DELIVERY" (
	"NU_ORDER" Integer NOT NULL ,
	"NU_SEQUENCE" Integer NOT NULL ,
	"NU_QADORDER" Varchar2(10) NOT NULL ,
	"VL_QUANTITY" Decimal(15,5) NOT NULL ,
	"DT_DELIVERED" Date,
	"NU_SEFAZKEY" Varchar2(50),
	"NU_INVOICE" Integer,
	"NU_SERIES" Integer,
 Constraint "PK_ORDERITEMDELIVERY" primary key ("NU_ORDER","NU_SEQUENCE","NU_QADORDER")
)
/

Create table "TITEM_STOCK" (
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"DC_LOCATION" Varchar2(80) NOT NULL ,
	"DC_LOT" Varchar2(30) NOT NULL ,
	"DT_EXPIRATION" Date,
	"VL_QUANTITY" Decimal(15,5) NOT NULL ,
	"DT_LASTCOUNT" Date,
	"DT_CREATION" Date NOT NULL ,
 Constraint "pk_TITEM_STOCK" primary key ("CD_ITEM","DC_LOCATION","DC_LOT")
)
/

Create table "TSTOCK_CHECK" (
	"CD_STOCKCHECK" Integer NOT NULL ,
	"DT_STOCK" Date NOT NULL ,
	"IN_PENDING" Smallint NOT NULL ,
 Constraint "pk_TSTOCK_CHECK" primary key ("CD_STOCKCHECK")
)
/

Create table "TITEM_STOCK_CHECK" (
	"CD_STOCKCHECK" Integer NOT NULL ,
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"DC_LOCATION" Varchar2(80) NOT NULL ,
	"DC_LOT" Varchar2(30) NOT NULL ,
	"VL_QUANTITY" Decimal(15,5) NOT NULL ,
	"DT_COUNTING" Date,
	"VL_COUNTED" Decimal(15,5) Default 0 NOT NULL ,
	"IN_COUNTED" Smallint Default 0 NOT NULL ,
	"DT_EXPIRATION" Date,
 Constraint "pk_TITEM_STOCK_CHECK" primary key ("CD_STOCKCHECK","CD_ITEM","DC_LOCATION","DC_LOT")
)
/

Create table "TLOCATION" (
	"CD_LOCATION" Char(50) NOT NULL ,
 Constraint "PK_LOCATION" primary key ("CD_LOCATION")
)
/

Create table "TQAD_NF" (
	"NU_NF" Varchar2(10) NOT NULL ,
	"NU_LINE" Integer NOT NULL ,
	"DT_SHIP" Date NOT NULL ,
	"CD_CUSTOMER" Varchar2(10) NOT NULL ,
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"DC_ITEM1" Varchar2(30) NOT NULL ,
	"VL_PRICE" Decimal(15,5) Default 0 NOT NULL ,
	"VL_QUANTITY" Decimal(15,5) NOT NULL ,
	"CD_UM" Varchar2(2) NOT NULL ,
	"NU_INVOICE" Char(10) NOT NULL ,
	"CD_FISCALCLASS" Varchar2(20),
 Constraint "pk_TQAD_NF" primary key ("NU_NF","NU_LINE")
)
/

Create table "TQAD_TAXESINV" (
	"NU_INVOICE" Varchar2(10) NOT NULL ,
	"NU_LINE" Integer NOT NULL ,
	"DC_TAXTYPE" Varchar2(20) NOT NULL ,
	"IN_TAX" Integer NOT NULL ,
	"VL_AMOUNT" Decimal(15,5) NOT NULL ,
	"DC_TAXUSAGE" Varchar2(20) NOT NULL ,
	"DC_TAXCLASS" Char(3) NOT NULL ,
 Constraint "pk_TQAD_TAXESINV" primary key ("NU_INVOICE","NU_LINE","DC_TAXTYPE")
)
/

Create table "TTMP_SalesOrder" (
	"NU_SALESORDER" Varchar2(10) NOT NULL ,
	"NU_LINE" Char(10) NOT NULL ,
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"VL_QTYSHIPPED" Decimal(15,5),
	"DT_EFFECTIVE" Char(10),
 Constraint "PK_TMPSALESORDER" primary key ("NU_SALESORDER","NU_LINE","CD_ITEM")
)
/

Create table "TTICKET" (
	"CD_TICKET" Integer NOT NULL ,
	"CD_USER" Integer NOT NULL ,
	"DT_TICKET" Date NOT NULL ,
 Constraint "PK_TICKET" primary key ("CD_TICKET")
)
/

Create table "TQUEUE" (
	"CD_QUEUE" Integer NOT NULL ,
	"NM_QUEUE" Varchar2(50) NOT NULL ,
 Constraint "pk_TQUEUE" primary key ("CD_QUEUE")
)
/

Create table "TPURCHASE_ORDER" (
	"NU_ORDER" Integer NOT NULL ,
	"CD_USER" Integer NOT NULL ,
	"CD_SUPPLIER" Integer NOT NULL ,
	"NU_POTYPE" Integer NOT NULL ,
	"DT_ORDER" Date NOT NULL ,
	"DC_EXTERNALREFERENCE" Varchar2(50),
	"DC_PROCESSREFERENCE" Varchar2(50),
	"CD_CURRENCY" Char(3) NOT NULL ,
	"DT_DUE" Date NOT NULL ,
	"TX_ADDITIONAL" Long,
	"CD_STATUS" Integer NOT NULL ,
	"VL_DISCOUNT" Decimal(15,5),
	"VL_INCREASE" Decimal(15,5),
	"IN_CLOSED" Smallint Default 0 NOT NULL ,
 Constraint "PK_PURCHASEORDER" primary key ("NU_ORDER")
)
/

Create table "TMP_ITEMDATALOAD" (
	"PT_PART" Varchar2(30) NOT NULL ,
	"PT_UM" Varchar2(30),
	"PT_STATUS" Varchar2(80),
	"PT_PART_TYPE" Varchar2(80),
	"PT_DESC1" Varchar2(80),
	"PT_DESC2" Varchar2(80),
	"PT_PROD_LINE" Varchar2(30),
	"PT_ADDED" Date,
	"PT_PUR_LEAD" Integer,
	"PT_FISCAL_CLASS" Varchar2(30),
	"PT_TAXC" Varchar2(30),
	"PT_DRAW" Varchar2(30),
	"PT_PM_CODE" Varchar2(30),
	"SPT_COST" Decimal(15,5),
	"LD_QTY_OH" Decimal(15,5),
	"PT_BUYER" Varchar2(80),
	"PT_VENDOR" Varchar2(80),
	"PT_PHANTOM" Smallint,
 Constraint "PK_TMPITEMDATALOAD" primary key ("PT_PART")
)
/

Create table "TMP_UMDATALOAD" (
	"UM_PART" Varchar2(30) NOT NULL ,
	"UM_ALT_UM" Varchar2(30) NOT NULL ,
	"UM_UM" Varchar2(30) NOT NULL ,
	"UM_CONV" Decimal(15,5) NOT NULL ,
 Constraint "PK_TMPUMDATALOAT" primary key ("UM_PART","UM_ALT_UM","UM_UM")
)
/

Create table "TMP_LOCDATALOAD" (
	"LOC_LOC" Char(10) NOT NULL ,
 Constraint "PK_TMPLOCDATALOAD" primary key ("LOC_LOC")
)
/

Create table "TMP_STOCKDATALOAD" (
	"LD_PART" Varchar2(30) NOT NULL ,
	"LD_LOC" Varchar2(80) NOT NULL ,
	"LD_LOT" Varchar2(30) NOT NULL ,
	"LD_DATE" Date,
	"LD_QTY_OH" Decimal(15,5),
	"LD_CNT_DATE" Date,
	"LD_EXPIRE" Date,
 Constraint "PK_TMPSTOCKDATALOAD" primary key ("LD_PART","LD_LOC","LD_LOT")
)
/

Create table "TMP_PRODLINEDATALOAD" (
	"PL_PROD_LINE" Varchar2(30) NOT NULL ,
	"PL_DESC" Varchar2(80),
 Constraint "PK_PRODLINEDATALOAD" primary key ("PL_PROD_LINE")
)
/

Create table "TMP_TAXESDATALOAD" (
	"TX2_TAX_TYPE" Varchar2(30) NOT NULL ,
	"TX2_TAX_USAGE" Varchar2(80) NOT NULL ,
	"TX2_PT_TAXC" Varchar2(30) NOT NULL ,
	"TX2_TAX_PCT" Decimal(15,5),
	"TX2_METHOD" Varchar2(30),
	"TX2_BASE" Varchar2(80),
	"TX2_TAX_IN" Char(10),
 Constraint "PK_TMPDATALOAD" primary key ("TX2_TAX_TYPE","TX2_TAX_USAGE","TX2_PT_TAXC")
)
/

Create table "TMP_TAXBASEDATALOAD" (
	"TXBD_BASE" Varchar2(80) NOT NULL ,
	"TXBR_TAX_TYPE" Varchar2(30) NOT NULL ,
	"TXBD_PERCENT" Varchar2(10),
 Constraint "PK_TAXBASEDATALOAD" primary key ("TXBD_BASE","TXBR_TAX_TYPE")
)
/

Create table "TMP_TAX_ENVIRONMENT" (
	"TXED_TAX_ENV" Varchar2(30) NOT NULL ,
	"TXED_TAX_TYPE" Varchar2(30) NOT NULL ,
 Constraint "pk_TMP_TAX_ENVIRONMENT" primary key ("TXED_TAX_ENV","TXED_TAX_TYPE")
)
/

Create table "TPURCHASE_ORDER_ITEM" (
	"NU_ORDER" Integer NOT NULL ,
	"CD_STATUS" Integer NOT NULL ,
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"CD_ORDERUM" Varchar2(2) NOT NULL ,
	"NU_SEQUENCE" Integer NOT NULL ,
	"VL_QUANTITY" Decimal(15,5) NOT NULL ,
	"VL_QTYSHIPPED" Decimal(15,5) Default 0 NOT NULL ,
	"VL_PRICE" Decimal(15,5) NOT NULL ,
	"DT_DUE" Date NOT NULL ,
	"DT_DELIVERY" Date,
	"VL_SHIPPED" Decimal(15,5),
	"TX_ADDITIONAL" Long,
	"IN_REMOVED" Smallint Default 0 NOT NULL ,
	"DC_REMOVALREASON" Varchar2(50),
 Constraint "PK_PURCHASEORDERITEM" primary key ("NU_ORDER","NU_SEQUENCE")
)
/

Create table "TPO_ITEM_STEP" (
	"CD_POITEMSTEP" Integer NOT NULL ,
	"DC_POITEMSTEP" Varchar2(50) NOT NULL ,
	"IN_USERSELECTABLE" Smallint Default 0 NOT NULL ,
 Constraint "PK_POITEMSTEP" primary key ("CD_POITEMSTEP")
)
/

Create table "TPO_ITEM_STATUS" (
	"NU_ORDER" Integer NOT NULL ,
	"NU_SEQUENCE" Integer NOT NULL ,
	"NU_SEQ" Integer NOT NULL ,
	"DT_STATUS" Date NOT NULL ,
	"CD_POITEMSTEP" Integer NOT NULL ,
 Constraint "PK_POITEMSTATUS" primary key ("NU_ORDER","NU_SEQUENCE","NU_SEQ")
)
/

Create table "TPO_STEP" (
	"CD_POSTEP" Integer NOT NULL ,
	"DC_POSTEP" Varchar2(50) NOT NULL ,
	"IN_USERSELECTABLE" Smallint Default 0 NOT NULL ,
	"IN_TRANSIT" Smallint Default 0 NOT NULL ,
	"IN_CLOSED" Smallint Default 0 NOT NULL ,
 Constraint "PK_POSTEP" primary key ("CD_POSTEP")
)
/

Create table "TPO_STATUS" (
	"NU_ORDER" Integer NOT NULL ,
	"NU_SEQ" Integer NOT NULL ,
	"CD_POSTEP" Integer NOT NULL ,
	"DT_STATUS" Date NOT NULL ,
 Constraint "PK_POSTATUS" primary key ("NU_ORDER","NU_SEQ")
)
/

Create table "TMP_CUSTOMERITEM" (
	"CP_CUST" Varchar2(10) NOT NULL ,
	"CP_PART" Varchar2(10) NOT NULL ,
 Constraint "pk_TMP_CUSTOMERITEM" primary key ("CP_CUST","CP_PART")
)
/

Create table "TITEM_CUSTOMER" (
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"CD_CUSTOMER" Integer NOT NULL ,
 Constraint "pk_TITEM_CUSTOMER" primary key ("CD_ITEM","CD_CUSTOMER")
)
/

Create table "TMP_EXCHANGERATE" (
	"EXR_CURR1" Varchar2(30) NOT NULL ,
	"EXR_CURR2" Varchar2(30) NOT NULL ,
	"EXR_START_DATE" Date NOT NULL ,
	"EXR_END_DATE" Date NOT NULL ,
	"EXR_RATE1" Decimal(15,10),
	"EXR_RATE2" Decimal(15,10),
 Constraint "pk_TMP_EXCHANGERATE" primary key ("EXR_CURR1","EXR_CURR2","EXR_START_DATE","EXR_END_DATE")
)
/

Create table "TEXCHANGE_RATE" (
	"CD_SOURCECURRENCY" Varchar2(30) NOT NULL ,
	"CD_TARGETCURRENCY" Varchar2(30) NOT NULL ,
	"VL_RATE" Decimal(15,5) Default 0 NOT NULL ,
	"DT_START" Date NOT NULL ,
	"DT_END" Date NOT NULL ,
 Constraint "pk_TEXCHANGE_RATE" primary key ("CD_SOURCECURRENCY","CD_TARGETCURRENCY")
)
/

Create table "TDRAWBACK" (
	"CD_DRAWBACK" Integer NOT NULL ,
	"CD_USER" Integer NOT NULL ,
	"DT_DRAWBACK" Char(10) NOT NULL ,
 Constraint "PK_DRAWBACK" primary key ("CD_DRAWBACK")
)
/

Create table "TDRAWBACK_ITEM" (
	"CD_DRAWBACK" Integer NOT NULL ,
	"NU_SEQUENCE" Integer NOT NULL ,
	"CD_ITEM" Varchar2(10) NOT NULL ,
	"CD_UM" Varchar2(2) NOT NULL ,
	"VL_QUANTITY" Decimal(15,5) Default 0 NOT NULL ,
 Constraint "PK_DRAWBACKITEM" primary key ("CD_DRAWBACK","NU_SEQUENCE")
)
/

Create table "TDRAWBACK_ITEM_BREAK" (
	"CD_DRAWBACK" Integer NOT NULL ,
	"NU_SEQUENCE" Integer NOT NULL ,
	"CD_UM" Varchar2(2) NOT NULL ,
	"VL_QUANTITY" Decimal(15,5) Default 0 NOT NULL ,
 Constraint "PK_ITEMBREAKDOWN" primary key ("CD_DRAWBACK","NU_SEQUENCE")
)
/



set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE TRIGGER [dbo].[ORDERITEM_DELETE]
   ON  [dbo].[TORDER_ITEM]
   FOR DELETE
AS
DECLARE @ITEM_NUMBER VARCHAR(10)
DECLARE @DESCRIPTION VARCHAR(10)
DECLARE @QUANTITY NUMERIC(15,5)
DECLARE @ORDER_NUMBER INT
DECLARE @LAST_USER VARCHAR(10)
BEGIN



    SELECT @ITEM_NUMBER = D.CD_ITEM
         , @DESCRIPTION = I.DC_ITEM
		 , @QUANTITY = D.VL_QUANTITY
         , @ORDER_NUMBER = D.NU_ORDER
         , @LAST_USER = U.NM_LOGIN
      FROM DELETED D
         , TITEM I
         , TORDER O
         , TUSER U
    WHERE I.CD_ITEM = D.CD_ITEM
      AND O.NU_ORDER = D.NU_ORDER
      AND U.CD_USER = O.CD_LASTUSER
    ;

	IF @ORDER_NUMBER IS NOT NULL
	BEGIN

		UPDATE TORDER
		   SET TX_UPDATES = case
							   when cast( TX_UPDATES as varchar(max)) is not null then
									cast( TX_UPDATES as varchar(max))
							 else ''
							 end + char(13) +
							 CONVERT(VARCHAR(10),GETDATE(),103) + ': ' +
							 'User ' + @LAST_USER + ' deleted item: ' +
							  @ITEM_NUMBER + ' - ' +
							  @DESCRIPTION + ' - ' +
							  cast( @QUANTITY AS VARCHAR(100) )
			 , IN_ADJUSTED = 1
		WHERE NU_ORDER = @ORDER_NUMBER
	   ;
	END;

	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for trigger here

END



GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE TRIGGER [dbo].[ORDERITEM_INSERT]
   ON  [dbo].[TORDER_ITEM]
   FOR INSERT
AS
DECLARE @ITEM_NUMBER VARCHAR(10)
DECLARE @DESCRIPTION VARCHAR(10)
DECLARE @QUANTITY NUMERIC(15,5)
DECLARE @ORDER_NUMBER INT
DECLARE @DUE_DATE DATETIME
DECLARE @LAST_USER VARCHAR(10)
BEGIN

    SELECT @ITEM_NUMBER = I.CD_ITEM
         , @DESCRIPTION = I.DC_ITEM
		 , @QUANTITY = INS.VL_QUANTITY
         , @ORDER_NUMBER = INS.NU_ORDER
         , @LAST_USER = U.NM_LOGIN
         , @DUE_DATE = INS.DT_DELIVERY
      FROM INSERTED INS
         , TITEM I
         , TORDER O
         , TUSER U
    WHERE I.CD_ITEM = INS.CD_ITEM
      AND O.NU_ORDER = INS.NU_ORDER
      AND U.CD_USER = O.CD_LASTUSER
    ;

    UPDATE TORDER
       SET TX_UPDATES = case
                            when cast( TX_UPDATES as varchar(max)) is not null then
                                 cast( TX_UPDATES as varchar(max))
							else ''
                        end + char(13) +
						CONVERT(VARCHAR(10),GETDATE(),103) + ': ' +
                         'User ' + @LAST_USER + ' inserted item: ' +
						  @ITEM_NUMBER + ' - ' +
                          @DESCRIPTION + ' - ' +
						  cast( @QUANTITY AS VARCHAR(100) ) + ' due to: ' +
						  CONVERT(VARCHAR(10),@DUE_DATE,103)
         , IN_ADJUSTED = 1
    WHERE NU_ORDER = @ORDER_NUMBER
   ;

	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for trigger here

END

GO


-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE TRIGGER [lush].[ORDERITEM_UPDATE]
   ON  [lush].[TORDER_ITEM]
   FOR UPDATE
AS
DECLARE @ITEM_NUMBER VARCHAR(10)
DECLARE @DESCRIPTION VARCHAR(10)
DECLARE @OLD_QUANTITY NUMERIC(15,5)
DECLARE @NEW_QUANTITY NUMERIC(15,5)
DECLARE @OLD_DUEDATE DATETIME
DECLARE @NEW_DUEDATE DATETIME
DECLARE @ORDER_NUMBER INT
DECLARE @LAST_USER VARCHAR(10)
BEGIN

    SELECT @ITEM_NUMBER = D.CD_ITEM
         , @DESCRIPTION = I.DC_ITEM
		 , @OLD_QUANTITY = D.VL_QUANTITY
		 , @OLD_DUEDATE = D.DT_DELIVERY
		 , @NEW_QUANTITY = INS.VL_QUANTITY
         , @NEW_DUEDATE = INS.DT_DELIVERY
         , @ORDER_NUMBER = D.NU_ORDER
         , @LAST_USER = U.NM_LOGIN
      FROM DELETED D
         , TITEM I
         , TORDER O
         , TUSER U
         , INSERTED INS
    WHERE I.CD_ITEM = D.CD_ITEM
      AND O.NU_ORDER = D.NU_ORDER
      AND U.CD_USER = O.CD_LASTUSER
      AND INS.NU_ORDER = D.NU_ORDER
      AND INS.NU_SEQUENCE = D.NU_SEQUENCE
    ;

    IF @OLD_QUANTITY <> @NEW_QUANTITY
    BEGIN
		UPDATE TORDER
		   SET TX_UPDATES = case
                               when cast( TX_UPDATES as varchar(max)) is not null then
                                    cast( TX_UPDATES as varchar(max))
							else ''
                            end + char(13) +
							CONVERT(VARCHAR(10),GETDATE(),103) + ': ' +
							  'User ' + @LAST_USER + ' updated item: ' +
							  @ITEM_NUMBER + ' - ' +
							  @DESCRIPTION + ' - ' + ' from quantity: ' +
							  cast( @OLD_QUANTITY AS VARCHAR(100) ) + ' to ' +
							  cast( @NEW_QUANTITY AS VARCHAR(100) )
		 WHERE NU_ORDER = @ORDER_NUMBER
	   ;

	   UPDATE TORDER
		  SET IN_ADJUSTED = 1
		WHERE NU_ORDER = @ORDER_NUMBER
	   ;
	END


    IF @OLD_DUEDATE <> @NEW_DUEDATE
    BEGIN
		UPDATE TORDER
		   SET TX_UPDATES = case
                               when cast( TX_UPDATES as varchar(max)) is not null then cast( TX_UPDATES as varchar(max))
							   else ''
                            end + char(13) +
							CONVERT(VARCHAR(10),GETDATE(),103) + ': ' +
							 'User ' + @LAST_USER + ' updated item: ' +
							  @ITEM_NUMBER + ' - ' +
							  @DESCRIPTION + ' - ' + ' from due date: ' +
							  CONVERT(VARCHAR(10),@OLD_DUEDATE,103) + ' to ' +
							  CONVERT(VARCHAR(10),@NEW_DUEDATE,103)
		 WHERE NU_ORDER = @ORDER_NUMBER
	   ;
	END


	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for trigger here

END















INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 1,  'Order placed', 0, 1 );
INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 2,  'Order waiting for approval', 1, 1 );
INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 3,  'Order approved', 0, 1 );
INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 4,  'Order sent to QAD', 0, 1 );
INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 5,  'Order integrated to QAD', 0, 1 );
INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 6,  'Order picked', 0, 1 );
INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 7,  'Order sent to delivery', 0, 1 );
INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 8,  'Order delivered', 0, 1 );
INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 9,  'Order closed', 0, 1 );
INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 10, 'Order sent for review', 0, 1 );
INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'CX', 'CAIXA(S)' );
INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'EA', 'EACH' );
INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'GM', 'GRAMA(S)' );
INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'KG', 'QUILO(S)' );
INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'L', 'LITRO(S)' );
INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'MT', 'METRO(S)' );
INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'PC', 'PEÇA(S)' );
INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'UN', 'UNIDADE(S)' );
INSERT INTO TPROFILE_PERMISSION( CD_USERPROFILE, NM_FORM, NM_FORMNAME, IN_QUERY, IN_INSERT, IN_DELETE, IN_UPDATE, IN_TRANSFER, IN_PRINT )
VALUES ( 1, 'form_CadastroPerfilUsuario', 'User Profile', 1, 1, 1, 1, 1, 1 );
INSERT INTO TUSER_PROFILE( CD_USERPROFILE, DC_USERPROFILE, IN_EMAILALERT, IN_APPROVER )
VALUES ( 1, 'ADMINISTRATOR', 1, 1 );

INSERT INTO TUSER_PROFILE( CD_USERPROFILE, DC_USERPROFILE, IN_EMAILALERT, IN_APPROVER )
VALUES ( 2, 'INTERNAL CLIENT', 1, 0 );
INSERT INTO TUSER( CD_USER, NM_USER, NM_LOGIN, DC_PASSWORD, CD_CUSTOMER, CD_USERPROFILE, DC_EMAIL)
VALUES (1,'ADMINISTRATOR', 'ADMIN', 'ADMIN', NULL, 1, 'diego.meire@lush.com.br' );

INSERT INTO TUSER( CD_USER, NM_USER, NM_LOGIN, DC_PASSWORD, CD_CUSTOMER, CD_USERPROFILE, DC_EMAIL)
VALUES (2, 'DIEGO DA FONSECA', 'DMEIRE', 'DMEIRE', null, 1, 'diego.meire@lush.com.br' );

INSERT INTO TUSER( CD_USER, NM_USER, NM_LOGIN, DC_PASSWORD, CD_CUSTOMER, CD_USERPROFILE, DC_EMAIL)
VALUES (3, 'LOJA CONSOLAÇÃO', 'LOJA01', 'LOJA01', 1, 1, 'diego.meire@lush.com.br' );

INSERT INTO TUSER( CD_USER, NM_USER, NM_LOGIN, DC_PASSWORD, CD_CUSTOMER, CD_USERPROFILE, DC_EMAIL)
VALUES (4, 'E-COMMERCE', 'ECOMM', 'ECOMM', 2, 1, 'diego.meire@lush.com.br' );

INSERT INTO TUSER( CD_USER, NM_USER, NM_LOGIN, DC_PASSWORD, CD_CUSTOMER, CD_USERPROFILE, DC_EMAIL)
VALUES (5, 'RELAÇÕES PÚBLICAS', 'RP', 'RP', 3, 1, 'diego.meire@lush.com.br' );

INSERT INTO TSEQUENCE_CONTROL( NM_SEQUENCE, CD_NEXTSEQUENCE ) VALUES ( 'TUSER', 6 );
INSERT INTO TSEQUENCE_CONTROL( NM_SEQUENCE, CD_NEXTSEQUENCE ) VALUES ( 'TUSER_PROFILE', 3 );
INSERT INTO TSEQUENCE_CONTROL( NM_SEQUENCE, CD_NEXTSEQUENCE ) VALUES ( 'TCUSTOMER', 4 );
INSERT INTO TSEQUENCE_CONTROL( NM_SEQUENCE, CD_NEXTSEQUENCE ) VALUES ( 'TORDER_STEP', 9 );

INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
VALUES ( 1, 'SMTP SERVER', 'smtp.gmail.com', 'STRING' );

INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
VALUES ( 2, 'SMTP PORT', '587', 'STRING' );

INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
VALUES ( 3, 'E-MAIL ACCOUNT', 'diego.meire@lushbrazil.com', 'STRING' );

INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
VALUES ( 4, 'E-MAIL PASSWORD', '4569eaAC', 'PASSWORD' );

INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
VALUES ( 5, 'HOST QAD', 'qlsbldb1', 'STRING' );

INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
VALUES ( 6, 'USER QAD', 'lpearcy', 'STRING' );

INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
VALUES ( 7, 'USER PASSWORD', 'Pepper12345', 'PASSWORD' );

INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
VALUES ( 8, 'CIM OUTPUT DIRECTORY', 'CIM', 'STRING' );

INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
VALUES ( 9, 'CIM TEMP DIRECTORY', 'TEMP', 'STRING' );

INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
VALUES ( 10, 'SFTP UTILITY', 'psftp', 'STRING' );

INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
VALUES ( 11, 'CIM SEQUENCE FILE', '0', 'INTEGER' );

INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
VALUES ( 12, 'LAST VERSION', '1.0.0.0', 'STRING' );

INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
VALUES ( 13, 'DOWNLOAD LOCATION', 'GOOGLE DRIVE', 'STRING' );

INSERT INTO TITEM_TYPE( CD_ITEMTYPE, DC_ITEMTYPE ) VALUES ('FINGOOD', 'PRODUTO ACABADO' );
DROP PROCEDURE [sp_ArchiveForecast]
-- =============================================
-- Author:		Diego
-- Create date: 24/11/2014
-- Description:	Stored Procedure to archive ALL
--			    active Forecast and generate new
--				clear ones
-- =============================================

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Diego
-- Create date: 24/11/2014
-- Description:	Stored Procedure to archive ALL
--			    active Forecast and generate new
--				clear ones
-- =============================================
CREATE PROCEDURE [sp_ArchiveForecast]
@CD_FORECAST int
AS
DECLARE @NEW_SEQUENCE INT,
		@DC_STATUS VARCHAR(20)
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	SELECT @DC_STATUS = DC_STATUS
      FROM TFORECAST
     WHERE CD_FORECAST = @CD_FORECAST

	IF @DC_STATUS IN ( 'ACTIVE', 'ARCHIVING' )
	BEGIN
			UPDATE TFORECAST
			   SET DC_STATUS = 'ARCHIVING'
			 WHERE DC_STATUS = 'ACTIVE'
			   AND CD_FORECAST = @CD_FORECAST

			SELECT @NEW_SEQUENCE = CD_NEXTSEQUENCE + 1
			  FROM TSEQUENCE_CONTROL
			 WHERE NM_SEQUENCE = 'TFORECAST'

			IF @NEW_SEQUENCE IS NULL
			BEGIN
			   INSERT INTO TSEQUENCE_CONTROL( NM_SEQUENCE, CD_NEXTSEQUENCE ) VALUES ( 'TFORECAST', 1 )
			   SELECT @NEW_SEQUENCE = 1
			END
			ELSE
			BEGIN
			   UPDATE TSEQUENCE_CONTROL
			   SET CD_NEXTSEQUENCE = @NEW_SEQUENCE
			   WHERE NM_SEQUENCE = 'TFORECAST'
  			END

			DELETE FROM TFORECAST_DETAIL WHERE CD_FORECAST = @NEW_SEQUENCE
			DELETE FROM TFORECAST WHERE CD_FORECAST = @NEW_SEQUENCE

			INSERT INTO TFORECAST (CD_FORECAST, CD_USER, NU_YEAR, DT_CREATION, DC_STATUS )
			SELECT @NEW_SEQUENCE
				   , CD_USER
				   , NU_YEAR
				   , CURRENT_TIMESTAMP
				   , 'ACTIVE'
			  FROM TFORECAST
			 WHERE CD_FORECAST = @CD_FORECAST


			INSERT INTO TFORECAST_DETAIL (CD_FORECAST,
										  CD_ITEM,
										  VL_JANUARY,
										  VL_FEBRUARY,
										  VL_MARCH,
										  VL_APRIL,
										  VL_MAY,
										  VL_JUNE,
										  VL_JULY,
										  VL_AUGUST,
										  VL_SEPTEMBER,
										  VL_OCTOBER,
										  VL_NOVEMBER,
										  VL_DECEMBER )
			SELECT @NEW_SEQUENCE
				   , CD_ITEM
				   , VL_JANUARY
				   , VL_FEBRUARY
				   , VL_MARCH
				   , VL_APRIL
				   , VL_MAY
				   , VL_JUNE
				   , VL_JULY
				   , VL_AUGUST
				   , VL_SEPTEMBER
				   , VL_OCTOBER
				   , VL_NOVEMBER
				   , VL_DECEMBER
			  FROM TFORECAST_DETAIL
			 WHERE CD_FORECAST = @CD_FORECAST
			 UNION
			SELECT @NEW_SEQUENCE
				   , CD_ITEM
				   , 0
				   , 0
				   , 0
				   , 0
				   , 0
				   , 0
				   , 0
				   , 0
				   , 0
				   , 0
				   , 0
				   , 0
			   FROM TITEM I
			  WHERE ( I.CD_ITEMTYPE = 'FINGOOD' )
				and ( LEN( substring( CD_ITEM, 6, 2  ) ) = 0 OR substring( CD_ITEM, 6, 2  ) = 'BR' )
				AND I.CD_ITEM NOT IN ( SELECT CD_ITEM
										 FROM TFORECAST_DETAIL
										WHERE CD_FORECAST = @CD_FORECAST
									  )

			UPDATE TFORECAST
			   SET DC_STATUS = 'CLOSED',
				   DT_CLOSING = CURRENT_TIMESTAMP
			 WHERE DC_STATUS = 'ARCHIVING'
			   AND CD_FORECAST = @CD_FORECAST
	END

END

GO

INSERT INTO TCUSTOMER( CD_CUSTOMER, NM_CUSTOMER, CD_CURRENCY ) VALUES ( 1, 'LOJA 01', 'BRL' );
INSERT INTO TCUSTOMER( CD_CUSTOMER, NM_CUSTOMER, CD_CURRENCY ) VALUES ( 2, 'E-COMMERCE', 'BRL' );
INSERT INTO TCUSTOMER( CD_CUSTOMER, NM_CUSTOMER, CD_CURRENCY ) VALUES ( 3, 'RP', 'BRL' );
INSERT INTO TEVENT( CD_EVENT, DC_EVENT ) VALUES ( 1, 'Logged in' );
INSERT INTO TEVENT( CD_EVENT, DC_EVENT ) VALUES ( 2, 'Logged off' );
INSERT INTO TEVENT( CD_EVENT, DC_EVENT ) VALUES ( 3, 'Closed the application' );
INSERT INTO TINVOICE_STEP( CD_INVOICESTEP, DC_INVOICESTEP ) VALUES ( 1, 'Invoice placed' );
INSERT INTO TINVOICE_STEP( CD_INVOICESTEP, DC_INVOICESTEP ) VALUES ( 2, 'Invoice sent to QAD' );
INSERT INTO TINVOICE_STEP( CD_INVOICESTEP, DC_INVOICESTEP ) VALUES ( 3, 'Invoice successfully integrated to Sefaz' );


-- Create Alternate keys section


-- Create Indexes section



-- Create Foreign keys section

Alter table "TORDER_ITEM" add Constraint "FK_ORDERITEM_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
/

Alter table "TITEM_UM" add Constraint "FK_UM_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
/

Alter table "TFORECAST_DETAIL" add Constraint "FK_FORECASTDETAIL_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
/

Alter table "TITEM_PRICE" add Constraint "FK_PRICELIST_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
/

Alter table "TINVOICE_ITEM" add Constraint "FK_INVOICEITEM_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
/

Alter table "TITEM_SUPPLIER" add Constraint "FK_ITEMSUPPLIER_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
/

Alter table "TMRP_DETAIL" add Constraint "FK_MRPDETAIL_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
/

Alter table "TITEM_STRUCTURE" add Constraint "FK_STRUCTURE_PARENTITEM" foreign key ("CD_PARENTITEM") references "TITEM" ("CD_ITEM")
/

Alter table "TITEM_STRUCTURE" add Constraint "FK_ITEM_COMPONENTITEM" foreign key ("CD_COMPONENTITEM") references "TITEM" ("CD_ITEM")
/

Alter table "TITEM_STOCK" add Constraint "PK_ITEMSTOCK_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")  on delete cascade
/

Alter table "TPURCHASE_ORDER_ITEM" add Constraint "FK_POITEM_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
/

Alter table "TITEM_CUSTOMER" add Constraint "FK_ITEMCUSTOMER_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
/

Alter table "TDRAWBACK_ITEM" add Constraint "FK_DRAWBACKITEM_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
/

Alter table "TORDER_ITEM" add Constraint "FK_ORDERITEM_ORDER" foreign key ("NU_ORDER") references "TORDER" ("NU_ORDER")  on delete cascade
/

Alter table "TORDER_STATUS" add Constraint "FK_ORDERSTATUS_ORDER" foreign key ("NU_ORDER") references "TORDER" ("NU_ORDER")  on delete cascade
/

Alter table "TORDER_APPROVAL" add Constraint "FK_ORDERAPPROVAL_ORDER" foreign key ("NU_ORDER") references "TORDER" ("NU_ORDER")  on delete cascade
/

Alter table "TORDER_ITEM_COMMENT" add Constraint "FK_ITEMCOMMENT_ORDERITEM" foreign key ("NU_ORDER","NU_SEQUENCE") references "TORDER_ITEM" ("NU_ORDER","NU_SEQUENCE")  on delete cascade
/

Alter table "TORDER_ITEM_DELIVERY" add Constraint "FK_DELIVERY_ORDERITEM" foreign key ("NU_ORDER","NU_SEQUENCE") references "TORDER_ITEM" ("NU_ORDER","NU_SEQUENCE")  on delete cascade
/

Alter table "TITEM" add Constraint "FK_ITEM_ITEMSTATUS" foreign key ("CD_ITEMSTATUS") references "TITEM_STATUS" ("CD_ITEMSTATUS")
/

Alter table "TORDER_STATUS" add Constraint "FK_ORDERSTATUS_ORDERSTEP" foreign key ("CD_ORDERSTEP") references "TORDER_STEP" ("CD_ORDERSTEP")
/

Alter table "TITEM_UM" add Constraint "FK_ITEMUM_UMSOURCE" foreign key ("CD_SOURCEUM") references "TUM" ("CD_UM")
/

Alter table "TITEM_UM" add Constraint "FK_ITEMUM_UMTARGET" foreign key ("CD_TARGETUM") references "TUM" ("CD_UM")
/

Alter table "TITEM" add Constraint "FK_ITEM_UM" foreign key ("CD_UM") references "TUM" ("CD_UM")
/

Alter table "TORDER_ITEM" add Constraint "FK_ORDERITEM_UMITEM" foreign key ("CD_ITEMUM") references "TUM" ("CD_UM")
/

Alter table "TORDER_ITEM" add Constraint "FK_ORDERITEM_UMORDER" foreign key ("CD_ORDERUM") references "TUM" ("CD_UM")
/

Alter table "TITEM_PRICE" add Constraint "FK_ITEMPRICE_UOM" foreign key ("CD_UM") references "TUM" ("CD_UM")
/

Alter table "TITEM_SUPPLIER" add Constraint "FK_ITEMSUPPLIER_UM" foreign key ("CD_UM") references "TUM" ("CD_UM")
/

Alter table "TPURCHASE_ORDER_ITEM" add Constraint "FK_POITEM_UM" foreign key ("CD_ORDERUM") references "TUM" ("CD_UM")
/

Alter table "TCOMPONENT_PERMISSION" add Constraint "FK_COMPONENTPERMISSION_PROFILE" foreign key ("CD_USERPROFILE","NM_FORM") references "TPROFILE_PERMISSION" ("CD_USERPROFILE","NM_FORM")  on delete cascade
/

Alter table "TUSER" add Constraint "FK_USER_USERPROFILE" foreign key ("CD_USERPROFILE") references "TUSER_PROFILE" ("CD_USERPROFILE")
/

Alter table "TPROFILE_PERMISSION" add Constraint "FK_PROFILEPERMISSION_PROFILE" foreign key ("CD_USERPROFILE") references "TUSER_PROFILE" ("CD_USERPROFILE")
/

Alter table "TORDER" add Constraint "FK_ORDER_USUARIO" foreign key ("CD_USER") references "TUSER" ("CD_USER")
/

Alter table "TORDER_STATUS" add Constraint "FK_ORDERSATUS_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
/

Alter table "TDATALOAD" add Constraint "FK_DATALOAD_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
/

Alter table "TFORECAST" add Constraint "FK_FORECAST_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
/

Alter table "TORDER_APPROVAL" add Constraint "FK_ORDERAPPROVAL_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
/

Alter table "TUSER_LOG" add Constraint "FK_USERLOG_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")  on delete cascade
/

Alter table "TORDER_ITEM_COMMENT" add Constraint "FK_ORDERITEMCOMM_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")  on delete cascade
/

Alter table "TINVOICE" add Constraint "FK_INVOICE_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
/

Alter table "TINVOICE_STATUS" add Constraint "FK_INVOICESTATUS_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
/

Alter table "TORDER" add Constraint "FK_ORDER_LASTUSER" foreign key ("CD_LASTUSER") references "TUSER" ("CD_USER")  on delete cascade
/

Alter table "TTICKET" add Constraint "FK_TICKET_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
/

Alter table "TPURCHASE_ORDER" add Constraint "FK_PURCHASEORDER_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
/

Alter table "TDRAWBACK" add Constraint "FK_DRAWBACK_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
/

Alter table "TCOMPONENT_PERMISSION" add Constraint "FK_COMPONENTEPERMISSAO_COMPONE" foreign key ("CD_COMPONENT") references "TCOMPONENT" ("CD_COMPONENT")
/

Alter table "TITEM" add Constraint "FK_ITEM_PRODUCTLINE" foreign key ("CD_PRODUCTLINE") references "TPRODUCT_LINE" ("CD_PRODUCTLINE")
/

Alter table "TITEM" add Constraint "FK_ITEM_ITEMTYPE" foreign key ("CD_ITEMTYPE") references "TITEM_TYPE" ("CD_ITEMTYPE")
/

Alter table "TFORECAST_DETAIL" add Constraint "FK_FORECASTDETAIL_FORECAST" foreign key ("CD_FORECAST") references "TFORECAST" ("CD_FORECAST")
/

Alter table "TUSER" add Constraint "FK_USER_CUSTOMER" foreign key ("CD_CUSTOMER") references "TCUSTOMER" ("CD_CUSTOMER")
/

Alter table "TITEM_CUSTOMER" add Constraint "FK_ITEMCUSTOMER_CUSTOMER" foreign key ("CD_CUSTOMER") references "TCUSTOMER" ("CD_CUSTOMER")
/

Alter table "TUSER_LOG" add Constraint "FK_USERLOG_EVENT" foreign key ("CD_EVENT") references "TEVENT" ("CD_EVENT")  on delete cascade
/

Alter table "TNCM_TAXES" add Constraint "FK_FISCALENVIRONMENT_TAXES" foreign key ("DC_ENVIRONMENT","DC_TAXTYPE") references "TTAX_ENVIRONMENT" ("DC_ENVIRONMENT","DC_TAXTYPE")  on delete cascade
/

Alter table "TINVOICE" add Constraint "FK_INVOICE_SUPPLIER" foreign key ("CD_SUPPLIER") references "TSUPPLIER" ("CD_SUPPLIER")
/

Alter table "TITEM_SUPPLIER" add Constraint "FK_ITEMSUPPLIER_SUPPLIER" foreign key ("CD_SUPPLIER") references "TSUPPLIER" ("CD_SUPPLIER")
/

Alter table "TPURCHASE_ORDER" add Constraint "PK_PO_SUPPLIER" foreign key ("CD_SUPPLIER") references "TSUPPLIER" ("CD_SUPPLIER")  on delete cascade
/

Alter table "TINVOICE_ITEM" add Constraint "FK_INVOICEITEM_INVOICE" foreign key ("CD_INVOICE") references "TINVOICE" ("CD_INVOICE")  on delete cascade
/

Alter table "TINVOICE_STATUS" add Constraint "FK_INVOICESTATUS_INVOICE" foreign key ("CD_INVOICE") references "TINVOICE" ("CD_INVOICE")  on delete cascade
/

Alter table "TINVOICE" add Constraint "FK_INVOICE_CREDITTERMS" foreign key ("CD_CREDITTERMS") references "TCREDIT_TERMS" ("CD_CREDITTERMS")
/

Alter table "TMRP_DETAIL" add Constraint "FK_MRPDETAIL_MRP" foreign key ("CD_MRP") references "TMRP" ("CD_MRP")  on delete cascade
/

Alter table "TEMAIL_ATTACH" add Constraint "FK_ATTACHMENTS_EMAIL" foreign key ("CD_EMAIL") references "TEMAIL" ("CD_EMAIL")
/

Alter table "TINVOICE_STATUS" add Constraint "FK_INVOICESTATUS_STEP" foreign key ("CD_INVOICESTEP") references "TINVOICE_STEP" ("CD_INVOICESTEP")
/

Alter table "TNCM_TAXES" add Constraint "FK_NCMFISCALENV_NCM" foreign key ("DC_NCM") references "TNCM" ("DC_NCM")  on delete cascade
/

Alter table "TSNAPSHOT_ITEM" add Constraint "FK_SNAPSHOTITEM_SNAPSHOT" foreign key ("CD_SNAPSHOT") references "TSNAPSHOT" ("CD_SNAPSHOT")  on delete cascade
/

Alter table "TSNAPSHOT_STRUCTURE" add Constraint "FK_PARENTITEM_SNAPSHOT" foreign key ("CD_PARENTITEM","CD_PARENTSNAPSHOT") references "TSNAPSHOT_ITEM" ("CD_ITEM","CD_SNAPSHOT")  on delete cascade
/

Alter table "TSNAPSHOT_STRUCTURE" add Constraint "FK_COMPONENTITEM_SNAPSHOT" foreign key ("CD_COMPONENTITEM","CD_COMPONENTSNAPSHOT") references "TSNAPSHOT_ITEM" ("CD_ITEM","CD_SNAPSHOT")
/

Alter table "TITEM_STOCK_CHECK" add Constraint "FK_ITEMSTOCKCHECK_STOCKCHECK" foreign key ("CD_STOCKCHECK") references "TSTOCK_CHECK" ("CD_STOCKCHECK")  on delete cascade
/

Alter table "TUSER" add Constraint "FK_USER_QUEUE" foreign key ("CD_QUEUE") references "TQUEUE" ("CD_QUEUE")
/

Alter table "TPURCHASE_ORDER_ITEM" add Constraint "PK_PURCHASEORDERITEM_PO" foreign key ("NU_ORDER") references "TPURCHASE_ORDER" ("NU_ORDER")  on delete cascade
/

Alter table "TPO_STATUS" add Constraint "FK_POSTATUS_PO" foreign key ("NU_ORDER") references "TPURCHASE_ORDER" ("NU_ORDER")  on delete cascade
/

Alter table "TPO_ITEM_STATUS" add Constraint "FK_POITEM_POITEMSTATUS" foreign key ("NU_ORDER","NU_SEQUENCE") references "TPURCHASE_ORDER_ITEM" ("NU_ORDER","NU_SEQUENCE")  on delete cascade
/

Alter table "TPO_ITEM_STATUS" add Constraint "FK_POITEMSTATUS_POITEMSTEP" foreign key ("CD_POITEMSTEP") references "TPO_ITEM_STEP" ("CD_POITEMSTEP")  on delete cascade
/

Alter table "TPURCHASE_ORDER_ITEM" add Constraint "FK_POITEM_POITEMSTEP" foreign key ("CD_STATUS") references "TPO_ITEM_STEP" ("CD_POITEMSTEP")
/

Alter table "TPO_STATUS" add Constraint "FK_POSTATUS_POSTEP" foreign key ("CD_POSTEP") references "TPO_STEP" ("CD_POSTEP")  on delete cascade
/

Alter table "TPURCHASE_ORDER" add Constraint "FK_PURCHASEORDER_POSTEP" foreign key ("CD_STATUS") references "TPO_STEP" ("CD_POSTEP")
/

Alter table "TDRAWBACK_ITEM" add Constraint "FK_DRAWBACKITEM_DRAWBACK" foreign key ("CD_DRAWBACK") references "TDRAWBACK" ("CD_DRAWBACK")  on delete cascade
/

Alter table "TDRAWBACK_ITEM_BREAK" add Constraint "PK_BREAKDOWN_DRAWBACKITEM" foreign key ("CD_DRAWBACK","NU_SEQUENCE") references "TDRAWBACK_ITEM" ("CD_DRAWBACK","NU_SEQUENCE")  on delete cascade
/


-- Create Object Tables section



-- Create XMLType Tables section



-- Create Procedures section



-- Create Functions section



-- Create Views section



-- Create Sequences section




-- Create Triggers from referential integrity section

-- Update trigger for "TITEM"
Create Trigger "tu_TITEM"
after update of "CD_ITEM","CD_ITEMTYPE","CD_PRODUCTLINE","CD_UM","CD_ITEMSTATUS" on "TITEM"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TINVOICE_ITEM" update when parent "TITEM" changed
if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM")  then
	begin
	update "TINVOICE_ITEM"
	set 	"CD_ITEM" = :new_upd."CD_ITEM"
	where 	"TINVOICE_ITEM"."CD_ITEM" = :old_upd."CD_ITEM" ;
	end;
end if;
-- Cascade child "TITEM_SUPPLIER" update when parent "TITEM" changed
if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM")  then
	begin
	update "TITEM_SUPPLIER"
	set 	"CD_ITEM" = :new_upd."CD_ITEM"
	where 	"TITEM_SUPPLIER"."CD_ITEM" = :old_upd."CD_ITEM" ;
	end;
end if;
-- Cascade child "TMRP_DETAIL" update when parent "TITEM" changed
if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM")  then
	begin
	update "TMRP_DETAIL"
	set 	"CD_ITEM" = :new_upd."CD_ITEM"
	where 	"TMRP_DETAIL"."CD_ITEM" = :old_upd."CD_ITEM" ;
	end;
end if;
-- Cascade child "TITEM_STRUCTURE" update when parent "TITEM" changed
if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM")  then
	begin
	update "TITEM_STRUCTURE"
	set 	"CD_PARENTITEM" = :new_upd."CD_ITEM"
	where 	"TITEM_STRUCTURE"."CD_PARENTITEM" = :old_upd."CD_ITEM" ;
	end;
end if;
-- Cascade child "TPURCHASE_ORDER_ITEM" update when parent "TITEM" changed
if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM")  then
	begin
	update "TPURCHASE_ORDER_ITEM"
	set 	"CD_ITEM" = :new_upd."CD_ITEM"
	where 	"TPURCHASE_ORDER_ITEM"."CD_ITEM" = :old_upd."CD_ITEM" ;
	end;
end if;
-- Cascade child "TDRAWBACK_ITEM" update when parent "TITEM" changed
if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM")  then
	begin
	update "TDRAWBACK_ITEM"
	set 	"CD_ITEM" = :new_upd."CD_ITEM"
	where 	"TDRAWBACK_ITEM"."CD_ITEM" = :old_upd."CD_ITEM" ;
	end;
end if;


end;
/
-- Update trigger for "TORDER_ITEM"
Create Trigger "tu_TORDER_ITEM"
after update of "NU_ORDER","NU_SEQUENCE","CD_ITEM","CD_ITEMUM","CD_ORDERUM" on "TORDER_ITEM"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TORDER_ITEM_COMMENT" update when parent "TORDER_ITEM" changed
if (:old_upd."NU_ORDER" != :new_upd."NU_ORDER" or
   	:old_upd."NU_SEQUENCE" != :new_upd."NU_SEQUENCE")  then
	begin
	update "TORDER_ITEM_COMMENT"
	set 	"NU_ORDER" = :new_upd."NU_ORDER",
     	"NU_SEQUENCE" = :new_upd."NU_SEQUENCE"
	where 	"TORDER_ITEM_COMMENT"."NU_ORDER" = :old_upd."NU_ORDER" and
       		"TORDER_ITEM_COMMENT"."NU_SEQUENCE" = :old_upd."NU_SEQUENCE" ;
	end;
end if;
-- Cascade child "TORDER_ITEM_DELIVERY" update when parent "TORDER_ITEM" changed
if (:old_upd."NU_ORDER" != :new_upd."NU_ORDER" or
   	:old_upd."NU_SEQUENCE" != :new_upd."NU_SEQUENCE")  then
	begin
	update "TORDER_ITEM_DELIVERY"
	set 	"NU_ORDER" = :new_upd."NU_ORDER",
     	"NU_SEQUENCE" = :new_upd."NU_SEQUENCE"
	where 	"TORDER_ITEM_DELIVERY"."NU_ORDER" = :old_upd."NU_ORDER" and
       		"TORDER_ITEM_DELIVERY"."NU_SEQUENCE" = :old_upd."NU_SEQUENCE" ;
	end;
end if;


end;
/
-- Update trigger for "TUM"
Create Trigger "tu_TUM"
after update of "CD_UM" on "TUM"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TITEM_SUPPLIER" update when parent "TUM" changed
if (:old_upd."CD_UM" != :new_upd."CD_UM")  then
	begin
	update "TITEM_SUPPLIER"
	set 	"CD_UM" = :new_upd."CD_UM"
	where 	"TITEM_SUPPLIER"."CD_UM" = :old_upd."CD_UM" ;
	end;
end if;
-- Cascade child "TPURCHASE_ORDER_ITEM" update when parent "TUM" changed
if (:old_upd."CD_UM" != :new_upd."CD_UM")  then
	begin
	update "TPURCHASE_ORDER_ITEM"
	set 	"CD_ORDERUM" = :new_upd."CD_UM"
	where 	"TPURCHASE_ORDER_ITEM"."CD_ORDERUM" = :old_upd."CD_UM" ;
	end;
end if;


end;
/
-- Update trigger for "TPROFILE_PERMISSION"
Create Trigger "tu_TPROFILE_PERMISSION"
after update of "CD_USERPROFILE","NM_FORM" on "TPROFILE_PERMISSION"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TCOMPONENT_PERMISSION" update when parent "TPROFILE_PERMISSION" changed
if (:old_upd."CD_USERPROFILE" != :new_upd."CD_USERPROFILE" or
   	:old_upd."NM_FORM" != :new_upd."NM_FORM")  then
	begin
	update "TCOMPONENT_PERMISSION"
	set 	"CD_USERPROFILE" = :new_upd."CD_USERPROFILE",
     	"NM_FORM" = :new_upd."NM_FORM"
	where 	"TCOMPONENT_PERMISSION"."CD_USERPROFILE" = :old_upd."CD_USERPROFILE" and
       		"TCOMPONENT_PERMISSION"."NM_FORM" = :old_upd."NM_FORM" ;
	end;
end if;


end;
/
-- Update trigger for "TUSER_PROFILE"
Create Trigger "tu_TUSER_PROFILE"
after update of "CD_USERPROFILE" on "TUSER_PROFILE"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TUSER" update when parent "TUSER_PROFILE" changed
if (:old_upd."CD_USERPROFILE" != :new_upd."CD_USERPROFILE")  then
	begin
	update "TUSER"
	set 	"CD_USERPROFILE" = :new_upd."CD_USERPROFILE"
	where 	"TUSER"."CD_USERPROFILE" = :old_upd."CD_USERPROFILE" ;
	end;
end if;


end;
/
-- Update trigger for "TUSER"
Create Trigger "tu_TUSER"
after update of "CD_USER","CD_USERPROFILE","CD_CUSTOMER","CD_QUEUE" on "TUSER"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TUSER_LOG" update when parent "TUSER" changed
if (:old_upd."CD_USER" != :new_upd."CD_USER")  then
	begin
	update "TUSER_LOG"
	set 	"CD_USER" = :new_upd."CD_USER"
	where 	"TUSER_LOG"."CD_USER" = :old_upd."CD_USER" ;
	end;
end if;
-- Cascade child "TORDER_ITEM_COMMENT" update when parent "TUSER" changed
if (:old_upd."CD_USER" != :new_upd."CD_USER")  then
	begin
	update "TORDER_ITEM_COMMENT"
	set 	"CD_USER" = :new_upd."CD_USER"
	where 	"TORDER_ITEM_COMMENT"."CD_USER" = :old_upd."CD_USER" ;
	end;
end if;
-- Cascade child "TINVOICE" update when parent "TUSER" changed
if (:old_upd."CD_USER" != :new_upd."CD_USER")  then
	begin
	update "TINVOICE"
	set 	"CD_USER" = :new_upd."CD_USER"
	where 	"TINVOICE"."CD_USER" = :old_upd."CD_USER" ;
	end;
end if;
-- Cascade child "TORDER" update when parent "TUSER" changed
if (:old_upd."CD_USER" != :new_upd."CD_USER")  then
	begin
	update "TORDER"
	set 	"CD_LASTUSER" = :new_upd."CD_USER"
	where 	"TORDER"."CD_LASTUSER" = :old_upd."CD_USER" ;
	end;
end if;
-- Cascade child "TPURCHASE_ORDER" update when parent "TUSER" changed
if (:old_upd."CD_USER" != :new_upd."CD_USER")  then
	begin
	update "TPURCHASE_ORDER"
	set 	"CD_USER" = :new_upd."CD_USER"
	where 	"TPURCHASE_ORDER"."CD_USER" = :old_upd."CD_USER" ;
	end;
end if;
-- Cascade child "TDRAWBACK" update when parent "TUSER" changed
if (:old_upd."CD_USER" != :new_upd."CD_USER")  then
	begin
	update "TDRAWBACK"
	set 	"CD_USER" = :new_upd."CD_USER"
	where 	"TDRAWBACK"."CD_USER" = :old_upd."CD_USER" ;
	end;
end if;


end;
/
-- Update trigger for "TCOMPONENT"
Create Trigger "tu_TCOMPONENT"
after update of "CD_COMPONENT" on "TCOMPONENT"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TCOMPONENT_PERMISSION" update when parent "TCOMPONENT" changed
if (:old_upd."CD_COMPONENT" != :new_upd."CD_COMPONENT")  then
	begin
	update "TCOMPONENT_PERMISSION"
	set 	"CD_COMPONENT" = :new_upd."CD_COMPONENT"
	where 	"TCOMPONENT_PERMISSION"."CD_COMPONENT" = :old_upd."CD_COMPONENT" ;
	end;
end if;


end;
/
-- Update trigger for "TEVENT"
Create Trigger "tu_TEVENT"
after update of "CD_EVENT" on "TEVENT"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TUSER_LOG" update when parent "TEVENT" changed
if (:old_upd."CD_EVENT" != :new_upd."CD_EVENT")  then
	begin
	update "TUSER_LOG"
	set 	"CD_EVENT" = :new_upd."CD_EVENT"
	where 	"TUSER_LOG"."CD_EVENT" = :old_upd."CD_EVENT" ;
	end;
end if;


end;
/
-- Update trigger for "TTAX_ENVIRONMENT"
Create Trigger "tu_TTAX_ENVIRONMENT"
after update of "DC_ENVIRONMENT","DC_TAXTYPE" on "TTAX_ENVIRONMENT"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TNCM_TAXES" update when parent "TTAX_ENVIRONMENT" changed
if (:old_upd."DC_ENVIRONMENT" != :new_upd."DC_ENVIRONMENT" or
   	:old_upd."DC_TAXTYPE" != :new_upd."DC_TAXTYPE")  then
	begin
	update "TNCM_TAXES"
	set 	"DC_ENVIRONMENT" = :new_upd."DC_ENVIRONMENT",
     	"DC_TAXTYPE" = :new_upd."DC_TAXTYPE"
	where 	"TNCM_TAXES"."DC_ENVIRONMENT" = :old_upd."DC_ENVIRONMENT" and
       		"TNCM_TAXES"."DC_TAXTYPE" = :old_upd."DC_TAXTYPE" ;
	end;
end if;


end;
/
-- Update trigger for "TSUPPLIER"
Create Trigger "tu_TSUPPLIER"
after update of "CD_SUPPLIER" on "TSUPPLIER"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TINVOICE" update when parent "TSUPPLIER" changed
if (:old_upd."CD_SUPPLIER" != :new_upd."CD_SUPPLIER")  then
	begin
	update "TINVOICE"
	set 	"CD_SUPPLIER" = :new_upd."CD_SUPPLIER"
	where 	"TINVOICE"."CD_SUPPLIER" = :old_upd."CD_SUPPLIER" ;
	end;
end if;
-- Cascade child "TITEM_SUPPLIER" update when parent "TSUPPLIER" changed
if (:old_upd."CD_SUPPLIER" != :new_upd."CD_SUPPLIER")  then
	begin
	update "TITEM_SUPPLIER"
	set 	"CD_SUPPLIER" = :new_upd."CD_SUPPLIER"
	where 	"TITEM_SUPPLIER"."CD_SUPPLIER" = :old_upd."CD_SUPPLIER" ;
	end;
end if;
-- Cascade child "TPURCHASE_ORDER" update when parent "TSUPPLIER" changed
if (:old_upd."CD_SUPPLIER" != :new_upd."CD_SUPPLIER")  then
	begin
	update "TPURCHASE_ORDER"
	set 	"CD_SUPPLIER" = :new_upd."CD_SUPPLIER"
	where 	"TPURCHASE_ORDER"."CD_SUPPLIER" = :old_upd."CD_SUPPLIER" ;
	end;
end if;


end;
/
-- Update trigger for "TINVOICE"
Create Trigger "tu_TINVOICE"
after update of "CD_INVOICE","CD_CREDITTERMS","CD_USER","CD_SUPPLIER" on "TINVOICE"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TINVOICE_ITEM" update when parent "TINVOICE" changed
if (:old_upd."CD_INVOICE" != :new_upd."CD_INVOICE")  then
	begin
	update "TINVOICE_ITEM"
	set 	"CD_INVOICE" = :new_upd."CD_INVOICE"
	where 	"TINVOICE_ITEM"."CD_INVOICE" = :old_upd."CD_INVOICE" ;
	end;
end if;
-- Cascade child "TINVOICE_STATUS" update when parent "TINVOICE" changed
if (:old_upd."CD_INVOICE" != :new_upd."CD_INVOICE")  then
	begin
	update "TINVOICE_STATUS"
	set 	"CD_INVOICE" = :new_upd."CD_INVOICE"
	where 	"TINVOICE_STATUS"."CD_INVOICE" = :old_upd."CD_INVOICE" ;
	end;
end if;


end;
/
-- Update trigger for "TCREDIT_TERMS"
Create Trigger "tu_TCREDIT_TERMS"
after update of "CD_CREDITTERMS" on "TCREDIT_TERMS"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TINVOICE" update when parent "TCREDIT_TERMS" changed
if (:old_upd."CD_CREDITTERMS" != :new_upd."CD_CREDITTERMS")  then
	begin
	update "TINVOICE"
	set 	"CD_CREDITTERMS" = :new_upd."CD_CREDITTERMS"
	where 	"TINVOICE"."CD_CREDITTERMS" = :old_upd."CD_CREDITTERMS" ;
	end;
end if;


end;
/
-- Update trigger for "TMRP"
Create Trigger "tu_TMRP"
after update of "CD_MRP" on "TMRP"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TMRP_DETAIL" update when parent "TMRP" changed
if (:old_upd."CD_MRP" != :new_upd."CD_MRP")  then
	begin
	update "TMRP_DETAIL"
	set 	"CD_MRP" = :new_upd."CD_MRP"
	where 	"TMRP_DETAIL"."CD_MRP" = :old_upd."CD_MRP" ;
	end;
end if;


end;
/
-- Update trigger for "TEMAIL"
Create Trigger "tu_TEMAIL"
after update of "CD_EMAIL" on "TEMAIL"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TEMAIL_ATTACH" update when parent "TEMAIL" changed
if (:old_upd."CD_EMAIL" != :new_upd."CD_EMAIL")  then
	begin
	update "TEMAIL_ATTACH"
	set 	"CD_EMAIL" = :new_upd."CD_EMAIL"
	where 	"TEMAIL_ATTACH"."CD_EMAIL" = :old_upd."CD_EMAIL" ;
	end;
end if;


end;
/
-- Update trigger for "TNCM"
Create Trigger "tu_TNCM"
after update of "DC_NCM" on "TNCM"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TNCM_TAXES" update when parent "TNCM" changed
if (:old_upd."DC_NCM" != :new_upd."DC_NCM")  then
	begin
	update "TNCM_TAXES"
	set 	"DC_NCM" = :new_upd."DC_NCM"
	where 	"TNCM_TAXES"."DC_NCM" = :old_upd."DC_NCM" ;
	end;
end if;


end;
/
-- Update trigger for "TSNAPSHOT"
Create Trigger "tu_TSNAPSHOT"
after update of "CD_SNAPSHOT" on "TSNAPSHOT"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TSNAPSHOT_ITEM" update when parent "TSNAPSHOT" changed
if (:old_upd."CD_SNAPSHOT" != :new_upd."CD_SNAPSHOT")  then
	begin
	update "TSNAPSHOT_ITEM"
	set 	"CD_SNAPSHOT" = :new_upd."CD_SNAPSHOT"
	where 	"TSNAPSHOT_ITEM"."CD_SNAPSHOT" = :old_upd."CD_SNAPSHOT" ;
	end;
end if;


end;
/
-- Update trigger for "TSNAPSHOT_ITEM"
Create Trigger "tu_TSNAPSHOT_ITEM"
after update of "CD_ITEM","CD_SNAPSHOT" on "TSNAPSHOT_ITEM"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TSNAPSHOT_STRUCTURE" update when parent "TSNAPSHOT_ITEM" changed
if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM" or
   	:old_upd."CD_SNAPSHOT" != :new_upd."CD_SNAPSHOT")  then
	begin
	update "TSNAPSHOT_STRUCTURE"
	set 	"CD_PARENTITEM" = :new_upd."CD_ITEM",
     	"CD_PARENTSNAPSHOT" = :new_upd."CD_SNAPSHOT"
	where 	"TSNAPSHOT_STRUCTURE"."CD_PARENTITEM" = :old_upd."CD_ITEM" and
       		"TSNAPSHOT_STRUCTURE"."CD_PARENTSNAPSHOT" = :old_upd."CD_SNAPSHOT" ;
	end;
end if;


end;
/
-- Update trigger for "TPURCHASE_ORDER"
Create Trigger "tu_TPURCHASE_ORDER"
after update of "NU_ORDER","CD_USER","CD_SUPPLIER","CD_STATUS" on "TPURCHASE_ORDER"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TPURCHASE_ORDER_ITEM" update when parent "TPURCHASE_ORDER" changed
if (:old_upd."NU_ORDER" != :new_upd."NU_ORDER")  then
	begin
	update "TPURCHASE_ORDER_ITEM"
	set 	"NU_ORDER" = :new_upd."NU_ORDER"
	where 	"TPURCHASE_ORDER_ITEM"."NU_ORDER" = :old_upd."NU_ORDER" ;
	end;
end if;
-- Cascade child "TPO_STATUS" update when parent "TPURCHASE_ORDER" changed
if (:old_upd."NU_ORDER" != :new_upd."NU_ORDER")  then
	begin
	update "TPO_STATUS"
	set 	"NU_ORDER" = :new_upd."NU_ORDER"
	where 	"TPO_STATUS"."NU_ORDER" = :old_upd."NU_ORDER" ;
	end;
end if;


end;
/
-- Update trigger for "TPURCHASE_ORDER_ITEM"
Create Trigger "tu_TPURCHASE_ORDER_ITEM"
after update of "NU_ORDER","CD_STATUS","CD_ITEM","CD_ORDERUM","NU_SEQUENCE" on "TPURCHASE_ORDER_ITEM"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TPO_ITEM_STATUS" update when parent "TPURCHASE_ORDER_ITEM" changed
if (:old_upd."NU_ORDER" != :new_upd."NU_ORDER" or
   	:old_upd."NU_SEQUENCE" != :new_upd."NU_SEQUENCE")  then
	begin
	update "TPO_ITEM_STATUS"
	set 	"NU_ORDER" = :new_upd."NU_ORDER",
     	"NU_SEQUENCE" = :new_upd."NU_SEQUENCE"
	where 	"TPO_ITEM_STATUS"."NU_ORDER" = :old_upd."NU_ORDER" and
       		"TPO_ITEM_STATUS"."NU_SEQUENCE" = :old_upd."NU_SEQUENCE" ;
	end;
end if;


end;
/
-- Update trigger for "TPO_ITEM_STEP"
Create Trigger "tu_TPO_ITEM_STEP"
after update of "CD_POITEMSTEP" on "TPO_ITEM_STEP"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TPO_ITEM_STATUS" update when parent "TPO_ITEM_STEP" changed
if (:old_upd."CD_POITEMSTEP" != :new_upd."CD_POITEMSTEP")  then
	begin
	update "TPO_ITEM_STATUS"
	set 	"CD_POITEMSTEP" = :new_upd."CD_POITEMSTEP"
	where 	"TPO_ITEM_STATUS"."CD_POITEMSTEP" = :old_upd."CD_POITEMSTEP" ;
	end;
end if;
-- Cascade child "TPURCHASE_ORDER_ITEM" update when parent "TPO_ITEM_STEP" changed
if (:old_upd."CD_POITEMSTEP" != :new_upd."CD_POITEMSTEP")  then
	begin
	update "TPURCHASE_ORDER_ITEM"
	set 	"CD_STATUS" = :new_upd."CD_POITEMSTEP"
	where 	"TPURCHASE_ORDER_ITEM"."CD_STATUS" = :old_upd."CD_POITEMSTEP" ;
	end;
end if;


end;
/
-- Update trigger for "TPO_STEP"
Create Trigger "tu_TPO_STEP"
after update of "CD_POSTEP" on "TPO_STEP"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TPO_STATUS" update when parent "TPO_STEP" changed
if (:old_upd."CD_POSTEP" != :new_upd."CD_POSTEP")  then
	begin
	update "TPO_STATUS"
	set 	"CD_POSTEP" = :new_upd."CD_POSTEP"
	where 	"TPO_STATUS"."CD_POSTEP" = :old_upd."CD_POSTEP" ;
	end;
end if;
-- Cascade child "TPURCHASE_ORDER" update when parent "TPO_STEP" changed
if (:old_upd."CD_POSTEP" != :new_upd."CD_POSTEP")  then
	begin
	update "TPURCHASE_ORDER"
	set 	"CD_STATUS" = :new_upd."CD_POSTEP"
	where 	"TPURCHASE_ORDER"."CD_STATUS" = :old_upd."CD_POSTEP" ;
	end;
end if;


end;
/
-- Update trigger for "TDRAWBACK"
Create Trigger "tu_TDRAWBACK"
after update of "CD_DRAWBACK","CD_USER" on "TDRAWBACK"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TDRAWBACK_ITEM" update when parent "TDRAWBACK" changed
if (:old_upd."CD_DRAWBACK" != :new_upd."CD_DRAWBACK")  then
	begin
	update "TDRAWBACK_ITEM"
	set 	"CD_DRAWBACK" = :new_upd."CD_DRAWBACK"
	where 	"TDRAWBACK_ITEM"."CD_DRAWBACK" = :old_upd."CD_DRAWBACK" ;
	end;
end if;


end;
/
-- Update trigger for "TDRAWBACK_ITEM"
Create Trigger "tu_TDRAWBACK_ITEM"
after update of "CD_DRAWBACK","NU_SEQUENCE","CD_ITEM" on "TDRAWBACK_ITEM"
referencing new as new_upd old as old_upd
for each row
declare numrows integer;
begin
-- Cascade child "TDRAWBACK_ITEM_BREAK" update when parent "TDRAWBACK_ITEM" changed
if (:old_upd."CD_DRAWBACK" != :new_upd."CD_DRAWBACK" or
   	:old_upd."NU_SEQUENCE" != :new_upd."NU_SEQUENCE")  then
	begin
	update "TDRAWBACK_ITEM_BREAK"
	set 	"CD_DRAWBACK" = :new_upd."CD_DRAWBACK",
     	"NU_SEQUENCE" = :new_upd."NU_SEQUENCE"
	where 	"TDRAWBACK_ITEM_BREAK"."CD_DRAWBACK" = :old_upd."CD_DRAWBACK" and
       		"TDRAWBACK_ITEM_BREAK"."NU_SEQUENCE" = :old_upd."NU_SEQUENCE" ;
	end;
end if;


end;
/







































































































































































-- Create user Triggers section



-- Create Packages section





-- Create Synonyms section



-- Create Roles section



-- Users Permissions to roles section



-- Roles Permissions section

/* Roles permissions */




-- User Permissions section

/* Users permissions */




-- Create Table comments section


-- Create Attribute comments section

Comment on column "TCOMPONENT_PERMISSION"."IN_VISIBILITY" is '0 - Invisível
1 - Visível'
/

-- After section