API tools faq
paste
Advertisement
diego_fm

oRACLE

diego_fm
Aug 15th, 2016
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 81.89 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. Created 3/11/2014
  3. Modified 2/8/2016
  4. Project
  5. Model
  6. Company
  7. Author
  8. Version
  9. Database Oracle 10g
  10. */
  11.  
  12.  
  13.  
  14.  
  15.  
  16. Drop trigger "tu_TITEM"
  17. /
  18.  
  19.  
  20. Drop trigger "tu_TORDER_ITEM"
  21. /
  22.  
  23.  
  24.  
  25.  
  26.  
  27. Drop trigger "tu_TUM"
  28. /
  29.  
  30. Drop trigger "tu_TPROFILE_PERMISSION"
  31. /
  32.  
  33.  
  34. Drop trigger "tu_TUSER_PROFILE"
  35. /
  36.  
  37. Drop trigger "tu_TUSER"
  38. /
  39.  
  40. Drop trigger "tu_TCOMPONENT"
  41. /
  42.  
  43.  
  44.  
  45.  
  46.  
  47.  
  48.  
  49.  
  50.  
  51.  
  52.  
  53.  
  54.  
  55.  
  56. Drop trigger "tu_TEVENT"
  57. /
  58.  
  59.  
  60.  
  61. Drop trigger "tu_TTAX_ENVIRONMENT"
  62. /
  63.  
  64.  
  65. Drop trigger "tu_TSUPPLIER"
  66. /
  67.  
  68. Drop trigger "tu_TINVOICE"
  69. /
  70.  
  71.  
  72. Drop trigger "tu_TCREDIT_TERMS"
  73. /
  74.  
  75.  
  76. Drop trigger "tu_TMRP"
  77. /
  78.  
  79.  
  80. Drop trigger "tu_TEMAIL"
  81. /
  82.  
  83.  
  84.  
  85.  
  86.  
  87.  
  88. Drop trigger "tu_TNCM"
  89. /
  90.  
  91.  
  92. Drop trigger "tu_TSNAPSHOT"
  93. /
  94.  
  95. Drop trigger "tu_TSNAPSHOT_ITEM"
  96. /
  97.  
  98.  
  99.  
  100.  
  101.  
  102.  
  103.  
  104.  
  105.  
  106.  
  107.  
  108.  
  109. Drop trigger "tu_TPURCHASE_ORDER"
  110. /
  111.  
  112.  
  113.  
  114.  
  115.  
  116.  
  117.  
  118.  
  119.  
  120. Drop trigger "tu_TPURCHASE_ORDER_ITEM"
  121. /
  122.  
  123. Drop trigger "tu_TPO_ITEM_STEP"
  124. /
  125.  
  126.  
  127. Drop trigger "tu_TPO_STEP"
  128. /
  129.  
  130.  
  131.  
  132.  
  133.  
  134.  
  135. Drop trigger "tu_TDRAWBACK"
  136. /
  137.  
  138. Drop trigger "tu_TDRAWBACK_ITEM"
  139. /
  140.  
  141.  
  142.  
  143.  
  144.  
  145.  
  146.  
  147.  
  148.  
  149.  
  150.  
  151.  
  152.  
  153.  
  154.  
  155.  
  156.  
  157.  
  158.  
  159.  
  160.  
  161.  
  162.  
  163.  
  164.  
  165.  
  166.  
  167.  
  168.  
  169.  
  170.  
  171.  
  172.  
  173.  
  174.  
  175.  
  176.  
  177.  
  178.  
  179.  
  180.  
  181.  
  182.  
  183.  
  184.  
  185.  
  186.  
  187.  
  188.  
  189.  
  190.  
  191.  
  192.  
  193.  
  194.  
  195.  
  196.  
  197.  
  198.  
  199.  
  200.  
  201.  
  202.  
  203.  
  204.  
  205.  
  206.  
  207.  
  208.  
  209.  
  210.  
  211.  
  212.  
  213.  
  214.  
  215.  
  216.  
  217.  
  218.  
  219.  
  220.  
  221.  
  222.  
  223.  
  224.  
  225.  
  226.  
  227.  
  228.  
  229.  
  230.  
  231.  
  232.  
  233.  
  234.  
  235.  
  236.  
  237.  
  238.  
  239.  
  240.  
  241.  
  242.  
  243.  
  244. Alter table "TORDER_ITEM" drop constraint "FK_ORDERITEM_ITEM"
  245. /
  246. Alter table "TITEM_UM" drop constraint "FK_UM_ITEM"
  247. /
  248. Alter table "TFORECAST_DETAIL" drop constraint "FK_FORECASTDETAIL_ITEM"
  249. /
  250. Alter table "TITEM_PRICE" drop constraint "FK_PRICELIST_ITEM"
  251. /
  252. Alter table "TINVOICE_ITEM" drop constraint "FK_INVOICEITEM_ITEM"
  253. /
  254. Alter table "TITEM_SUPPLIER" drop constraint "FK_ITEMSUPPLIER_ITEM"
  255. /
  256. Alter table "TMRP_DETAIL" drop constraint "FK_MRPDETAIL_ITEM"
  257. /
  258. Alter table "TITEM_STRUCTURE" drop constraint "FK_STRUCTURE_PARENTITEM"
  259. /
  260. Alter table "TITEM_STRUCTURE" drop constraint "FK_ITEM_COMPONENTITEM"
  261. /
  262. Alter table "TITEM_STOCK" drop constraint "PK_ITEMSTOCK_ITEM"
  263. /
  264. Alter table "TPURCHASE_ORDER_ITEM" drop constraint "FK_POITEM_ITEM"
  265. /
  266. Alter table "TITEM_CUSTOMER" drop constraint "FK_ITEMCUSTOMER_ITEM"
  267. /
  268. Alter table "TDRAWBACK_ITEM" drop constraint "FK_DRAWBACKITEM_ITEM"
  269. /
  270. Alter table "TORDER_ITEM" drop constraint "FK_ORDERITEM_ORDER"
  271. /
  272. Alter table "TORDER_STATUS" drop constraint "FK_ORDERSTATUS_ORDER"
  273. /
  274. Alter table "TORDER_APPROVAL" drop constraint "FK_ORDERAPPROVAL_ORDER"
  275. /
  276. Alter table "TORDER_ITEM_COMMENT" drop constraint "FK_ITEMCOMMENT_ORDERITEM"
  277. /
  278. Alter table "TORDER_ITEM_DELIVERY" drop constraint "FK_DELIVERY_ORDERITEM"
  279. /
  280. Alter table "TITEM" drop constraint "FK_ITEM_ITEMSTATUS"
  281. /
  282. Alter table "TORDER_STATUS" drop constraint "FK_ORDERSTATUS_ORDERSTEP"
  283. /
  284. Alter table "TITEM_UM" drop constraint "FK_ITEMUM_UMSOURCE"
  285. /
  286. Alter table "TITEM_UM" drop constraint "FK_ITEMUM_UMTARGET"
  287. /
  288. Alter table "TITEM" drop constraint "FK_ITEM_UM"
  289. /
  290. Alter table "TORDER_ITEM" drop constraint "FK_ORDERITEM_UMITEM"
  291. /
  292. Alter table "TORDER_ITEM" drop constraint "FK_ORDERITEM_UMORDER"
  293. /
  294. Alter table "TITEM_PRICE" drop constraint "FK_ITEMPRICE_UOM"
  295. /
  296. Alter table "TITEM_SUPPLIER" drop constraint "FK_ITEMSUPPLIER_UM"
  297. /
  298. Alter table "TPURCHASE_ORDER_ITEM" drop constraint "FK_POITEM_UM"
  299. /
  300. Alter table "TCOMPONENT_PERMISSION" drop constraint "FK_COMPONENTPERMISSION_PROFILE"
  301. /
  302. Alter table "TUSER" drop constraint "FK_USER_USERPROFILE"
  303. /
  304. Alter table "TPROFILE_PERMISSION" drop constraint "FK_PROFILEPERMISSION_PROFILE"
  305. /
  306. Alter table "TORDER" drop constraint "FK_ORDER_USUARIO"
  307. /
  308. Alter table "TORDER_STATUS" drop constraint "FK_ORDERSATUS_USER"
  309. /
  310. Alter table "TDATALOAD" drop constraint "FK_DATALOAD_USER"
  311. /
  312. Alter table "TFORECAST" drop constraint "FK_FORECAST_USER"
  313. /
  314. Alter table "TORDER_APPROVAL" drop constraint "FK_ORDERAPPROVAL_USER"
  315. /
  316. Alter table "TUSER_LOG" drop constraint "FK_USERLOG_USER"
  317. /
  318. Alter table "TORDER_ITEM_COMMENT" drop constraint "FK_ORDERITEMCOMM_USER"
  319. /
  320. Alter table "TINVOICE" drop constraint "FK_INVOICE_USER"
  321. /
  322. Alter table "TINVOICE_STATUS" drop constraint "FK_INVOICESTATUS_USER"
  323. /
  324. Alter table "TORDER" drop constraint "FK_ORDER_LASTUSER"
  325. /
  326. Alter table "TTICKET" drop constraint "FK_TICKET_USER"
  327. /
  328. Alter table "TPURCHASE_ORDER" drop constraint "FK_PURCHASEORDER_USER"
  329. /
  330. Alter table "TDRAWBACK" drop constraint "FK_DRAWBACK_USER"
  331. /
  332. Alter table "TCOMPONENT_PERMISSION" drop constraint "FK_COMPONENTEPERMISSAO_COMPONE"
  333. /
  334. Alter table "TITEM" drop constraint "FK_ITEM_PRODUCTLINE"
  335. /
  336. Alter table "TITEM" drop constraint "FK_ITEM_ITEMTYPE"
  337. /
  338. Alter table "TFORECAST_DETAIL" drop constraint "FK_FORECASTDETAIL_FORECAST"
  339. /
  340. Alter table "TUSER" drop constraint "FK_USER_CUSTOMER"
  341. /
  342. Alter table "TITEM_CUSTOMER" drop constraint "FK_ITEMCUSTOMER_CUSTOMER"
  343. /
  344. Alter table "TUSER_LOG" drop constraint "FK_USERLOG_EVENT"
  345. /
  346. Alter table "TNCM_TAXES" drop constraint "FK_FISCALENVIRONMENT_TAXES"
  347. /
  348. Alter table "TINVOICE" drop constraint "FK_INVOICE_SUPPLIER"
  349. /
  350. Alter table "TITEM_SUPPLIER" drop constraint "FK_ITEMSUPPLIER_SUPPLIER"
  351. /
  352. Alter table "TPURCHASE_ORDER" drop constraint "PK_PO_SUPPLIER"
  353. /
  354. Alter table "TINVOICE_ITEM" drop constraint "FK_INVOICEITEM_INVOICE"
  355. /
  356. Alter table "TINVOICE_STATUS" drop constraint "FK_INVOICESTATUS_INVOICE"
  357. /
  358. Alter table "TINVOICE" drop constraint "FK_INVOICE_CREDITTERMS"
  359. /
  360. Alter table "TMRP_DETAIL" drop constraint "FK_MRPDETAIL_MRP"
  361. /
  362. Alter table "TEMAIL_ATTACH" drop constraint "FK_ATTACHMENTS_EMAIL"
  363. /
  364. Alter table "TINVOICE_STATUS" drop constraint "FK_INVOICESTATUS_STEP"
  365. /
  366. Alter table "TNCM_TAXES" drop constraint "FK_NCMFISCALENV_NCM"
  367. /
  368. Alter table "TSNAPSHOT_ITEM" drop constraint "FK_SNAPSHOTITEM_SNAPSHOT"
  369. /
  370. Alter table "TSNAPSHOT_STRUCTURE" drop constraint "FK_PARENTITEM_SNAPSHOT"
  371. /
  372. Alter table "TSNAPSHOT_STRUCTURE" drop constraint "FK_COMPONENTITEM_SNAPSHOT"
  373. /
  374. Alter table "TITEM_STOCK_CHECK" drop constraint "FK_ITEMSTOCKCHECK_STOCKCHECK"
  375. /
  376. Alter table "TUSER" drop constraint "FK_USER_QUEUE"
  377. /
  378. Alter table "TPURCHASE_ORDER_ITEM" drop constraint "PK_PURCHASEORDERITEM_PO"
  379. /
  380. Alter table "TPO_STATUS" drop constraint "FK_POSTATUS_PO"
  381. /
  382. Alter table "TPO_ITEM_STATUS" drop constraint "FK_POITEM_POITEMSTATUS"
  383. /
  384. Alter table "TPO_ITEM_STATUS" drop constraint "FK_POITEMSTATUS_POITEMSTEP"
  385. /
  386. Alter table "TPURCHASE_ORDER_ITEM" drop constraint "FK_POITEM_POITEMSTEP"
  387. /
  388. Alter table "TPO_STATUS" drop constraint "FK_POSTATUS_POSTEP"
  389. /
  390. Alter table "TPURCHASE_ORDER" drop constraint "FK_PURCHASEORDER_POSTEP"
  391. /
  392. Alter table "TDRAWBACK_ITEM" drop constraint "FK_DRAWBACKITEM_DRAWBACK"
  393. /
  394. Alter table "TDRAWBACK_ITEM_BREAK" drop constraint "PK_BREAKDOWN_DRAWBACKITEM"
  395. /
  396.  
  397.  
  398.  
  399. Drop table "TMP_POITEMDATALOAD"
  400. /
  401. Drop table "TDRAWBACK_ITEM_BREAK"
  402. /
  403. Drop table "TDRAWBACK_ITEM"
  404. /
  405. Drop table "TDRAWBACK"
  406. /
  407. Drop table "TEXCHANGE_RATE"
  408. /
  409. Drop table "TMP_EXCHANGERATE"
  410. /
  411. Drop table "TITEM_CUSTOMER"
  412. /
  413. Drop table "TMP_CUSTOMERITEM"
  414. /
  415. Drop table "TPO_STATUS"
  416. /
  417. Drop table "TPO_STEP"
  418. /
  419. Drop table "TPO_ITEM_STATUS"
  420. /
  421. Drop table "TPO_ITEM_STEP"
  422. /
  423. Drop table "TPURCHASE_ORDER_ITEM"
  424. /
  425. Drop table "TMP_TAX_ENVIRONMENT"
  426. /
  427. Drop table "TMP_TAXBASEDATALOAD"
  428. /
  429. Drop table "TMP_TAXESDATALOAD"
  430. /
  431. Drop table "TMP_PRODLINEDATALOAD"
  432. /
  433. Drop table "TMP_STOCKDATALOAD"
  434. /
  435. Drop table "TMP_LOCDATALOAD"
  436. /
  437. Drop table "TMP_UMDATALOAD"
  438. /
  439. Drop table "TMP_ITEMDATALOAD"
  440. /
  441. Drop table "TPURCHASE_ORDER"
  442. /
  443. Drop table "TQUEUE"
  444. /
  445. Drop table "TTICKET"
  446. /
  447. Drop table "TTMP_SalesOrder"
  448. /
  449. Drop table "TQAD_TAXESINV"
  450. /
  451. Drop table "TQAD_NF"
  452. /
  453. Drop table "TLOCATION"
  454. /
  455. Drop table "TITEM_STOCK_CHECK"
  456. /
  457. Drop table "TSTOCK_CHECK"
  458. /
  459. Drop table "TITEM_STOCK"
  460. /
  461. Drop table "TORDER_ITEM_DELIVERY"
  462. /
  463. Drop table "TSNAPSHOT_STRUCTURE"
  464. /
  465. Drop table "TSNAPSHOT_ITEM"
  466. /
  467. Drop table "TSNAPSHOT"
  468. /
  469. Drop table "TNCM_TAXES"
  470. /
  471. Drop table "TNCM"
  472. /
  473. Drop table "TINVOICE_STEP"
  474. /
  475. Drop table "TINVOICE_STATUS"
  476. /
  477. Drop table "TITEM_STRUCTURE"
  478. /
  479. Drop table "TTAX_BASE"
  480. /
  481. Drop table "TEMAIL_ATTACH"
  482. /
  483. Drop table "TEMAIL"
  484. /
  485. Drop table "TVERSION"
  486. /
  487. Drop table "TMRP"
  488. /
  489. Drop table "TMRP_DETAIL"
  490. /
  491. Drop table "TCREDIT_TERMS"
  492. /
  493. Drop table "TITEM_SUPPLIER"
  494. /
  495. Drop table "TINVOICE"
  496. /
  497. Drop table "TSUPPLIER"
  498. /
  499. Drop table "TINVOICE_ITEM"
  500. /
  501. Drop table "TTAX_ENVIRONMENT"
  502. /
  503. Drop table "TTAX_RATE"
  504. /
  505. Drop table "TORDER_ITEM_COMMENT"
  506. /
  507. Drop table "TEVENT"
  508. /
  509. Drop table "TUSER_LOG"
  510. /
  511. Drop table "TORDER_APPROVAL"
  512. /
  513. Drop table "TITEM_PRICE"
  514. /
  515. Drop table "TCUSTOMER"
  516. /
  517. Drop table "TFORECAST_DETAIL"
  518. /
  519. Drop table "TFORECAST"
  520. /
  521. Drop table "TITEM_TYPE"
  522. /
  523. Drop table "TPRODUCT_LINE"
  524. /
  525. Drop table "TDATALOAD"
  526. /
  527. Drop table "TREPORT"
  528. /
  529. Drop table "TCONFIGURATION"
  530. /
  531. Drop table "THELP"
  532. /
  533. Drop table "TSEQUENCE_CONTROL"
  534. /
  535. Drop table "TCOMPONENT"
  536. /
  537. Drop table "TUSER"
  538. /
  539. Drop table "TUSER_PROFILE"
  540. /
  541. Drop table "TCOMPONENT_PERMISSION"
  542. /
  543. Drop table "TPROFILE_PERMISSION"
  544. /
  545. Drop table "TUM"
  546. /
  547. Drop table "TITEM_UM"
  548. /
  549. Drop table "TORDER_STEP"
  550. /
  551. Drop table "TORDER_STATUS"
  552. /
  553. Drop table "TITEM_STATUS"
  554. /
  555. Drop table "TORDER_ITEM"
  556. /
  557. Drop table "TORDER"
  558. /
  559. Drop table "TITEM"
  560. /
  561.  
  562.  
  563. -- Create Types section
  564.  
  565.  
  566.  
  567.  
  568.  
  569. -- Create Tables section
  570.  
  571.  
  572. Create table "TITEM" (
  573. "CD_ITEM" Varchar2(10) NOT NULL ,
  574. "CD_ITEMTYPE" Varchar2(20) NOT NULL ,
  575. "CD_PRODUCTLINE" Varchar2(4) NOT NULL ,
  576. "CD_UM" Varchar2(2) NOT NULL ,
  577. "DC_ITEM" Varchar2(50) NOT NULL ,
  578. "DC_ITEM2" Varchar2(50),
  579. "CD_ITEMSTATUS" Varchar2(8) NOT NULL ,
  580. "DT_STATUS" Date NOT NULL ,
  581. "DT_CREATION" Date NOT NULL ,
  582. "IN_PURCMANU" Varchar2(1) NOT NULL ,
  583. "VL_STOCK" Decimal(15,5) NOT NULL ,
  584. "VL_LEADTIME" Integer Default 0 NOT NULL ,
  585. "DC_NCM" Char(10),
  586. "DC_TAXCLASS" Char(3),
  587. "VL_COST" Decimal(15,5) Default 0 NOT NULL ,
  588. "DC_DRAWING" Varchar2(50),
  589. "CD_BUYER" Varchar2(10),
  590. "CD_VENDOR" Varchar2(10),
  591. "IN_PHANTOM" Smallint Default 0 NOT NULL ,
  592. Constraint "PK_ITEM" primary key ("CD_ITEM")
  593. )
  594. /
  595.  
  596. Create table "TORDER" (
  597. "NU_ORDER" Integer NOT NULL ,
  598. "CD_LASTUSER" Integer NOT NULL ,
  599. "DT_ORDER" Date NOT NULL ,
  600. "DT_DELIVERY" Date NOT NULL ,
  601. "CD_USER" Integer NOT NULL ,
  602. "CD_ORDERTYPE" Char(10) Default 0 NOT NULL ,
  603. "TX_COMPLEMENTARY" Long,
  604. "IN_ADJUSTED" Smallint Default 0 NOT NULL ,
  605. "TX_UPDATES" Long,
  606. "NU_SEFAZKEY" Varchar2(50),
  607. "NU_INVOICE" Integer,
  608. "NU_SERIES" Integer,
  609. "CD_CURRENCY" Varchar2(3) Default BRL NOT NULL ,
  610. "VL_EXCHANGERATE" Decimal(15,5) Default 1 NOT NULL ,
  611. Constraint "pk_TORDER" primary key ("NU_ORDER")
  612. )
  613. /
  614.  
  615. Create table "TORDER_ITEM" (
  616. "NU_ORDER" Integer NOT NULL ,
  617. "NU_SEQUENCE" Integer NOT NULL ,
  618. "CD_ITEM" Varchar2(10) NOT NULL ,
  619. "VL_QUANTITY" Decimal(15,5) NOT NULL ,
  620. "CD_ITEMUM" Varchar2(2) NOT NULL ,
  621. "CD_ORDERUM" Varchar2(2) NOT NULL ,
  622. "VL_CONVERSION" Decimal(15,5) NOT NULL ,
  623. "VL_PRICE" Decimal(15,5) NOT NULL ,
  624. "DT_DELIVERY" Date NOT NULL ,
  625. "DT_DELIVERED" Date,
  626. "DC_TAXCLASS" Varchar2(3),
  627. "DC_OPERATIONTYPE" Varchar2(10),
  628. "IN_GIFTCOMPONENT" Smallint Default 0 NOT NULL ,
  629. "CD_REFERENCE" Varchar2(10),
  630. "IN_REMOVED" Smallint Default 0 NOT NULL ,
  631. "DC_REMOVALREASON" Varchar2(50),
  632. Constraint "pk_TORDER_ITEM" primary key ("NU_ORDER","NU_SEQUENCE")
  633. )
  634. /
  635.  
  636. Create table "TITEM_STATUS" (
  637. "CD_ITEMSTATUS" Varchar2(8) NOT NULL ,
  638. "DC_ITEMSTATUS" Varchar2(50) NOT NULL ,
  639. Constraint "pk_TITEM_STATUS" primary key ("CD_ITEMSTATUS")
  640. )
  641. /
  642.  
  643. Create table "TORDER_STATUS" (
  644. "NU_ORDER" Integer NOT NULL ,
  645. "NU_SEQUENCE" Integer NOT NULL ,
  646. "DT_STATUS" Date NOT NULL ,
  647. "CD_ORDERSTEP" Integer NOT NULL ,
  648. "CD_USER" Integer NOT NULL ,
  649. Constraint "pk_TORDER_STATUS" primary key ("NU_ORDER","NU_SEQUENCE")
  650. )
  651. /
  652.  
  653. Create table "TORDER_STEP" (
  654. "CD_ORDERSTEP" Integer NOT NULL ,
  655. "DC_ORDERSTEP" Varchar2(100) NOT NULL ,
  656. "IN_APPROVAL" Smallint NOT NULL ,
  657. "IN_EMAILALERT" Smallint NOT NULL ,
  658. Constraint "PK_ORDERSTEP" primary key ("CD_ORDERSTEP")
  659. )
  660. /
  661.  
  662. Create table "TITEM_UM" (
  663. "CD_ITEM" Varchar2(10) NOT NULL ,
  664. "CD_SOURCEUM" Varchar2(2) NOT NULL ,
  665. "CD_TARGETUM" Varchar2(2) NOT NULL ,
  666. "VL_CONVERSION" Decimal(15,5) NOT NULL ,
  667. Constraint "pk_TITEM_UM" primary key ("CD_ITEM","CD_SOURCEUM","CD_TARGETUM")
  668. )
  669. /
  670.  
  671. Create table "TUM" (
  672. "CD_UM" Varchar2(2) NOT NULL ,
  673. "DC_UM" Varchar2(50) NOT NULL UNIQUE ,
  674. Constraint "pk_TUM" primary key ("CD_UM")
  675. )
  676. /
  677.  
  678. Create table "TPROFILE_PERMISSION" (
  679. "CD_USERPROFILE" Integer NOT NULL ,
  680. "NM_FORM" Varchar2(50) NOT NULL ,
  681. "NM_FORMNAME" Varchar2(50) NOT NULL ,
  682. "IN_QUERY" Smallint Default 0 NOT NULL ,
  683. "IN_INSERT" Smallint Default 0 NOT NULL ,
  684. "IN_DELETE" Smallint Default 0 NOT NULL ,
  685. "IN_UPDATE" Smallint Default 0 NOT NULL ,
  686. "IN_TRANSFER" Smallint Default 0 NOT NULL ,
  687. "IN_PRINT" Smallint Default 0 NOT NULL ,
  688. Constraint "PK_USERPERMISSION" primary key ("CD_USERPROFILE","NM_FORM")
  689. )
  690. /
  691.  
  692. Create table "TCOMPONENT_PERMISSION" (
  693. "NM_FORM" Varchar2(50) NOT NULL ,
  694. "CD_COMPONENT" Integer NOT NULL ,
  695. "IN_VISIBILITY" Smallint Default 1,
  696. "CD_USERPROFILE" Integer NOT NULL ,
  697. Constraint "PK_COMPONENTEPERMISSAO" primary key ("NM_FORM","CD_COMPONENT","CD_USERPROFILE")
  698. )
  699. /
  700.  
  701. Create table "TUSER_PROFILE" (
  702. "CD_USERPROFILE" Integer NOT NULL ,
  703. "DC_USERPROFILE" Varchar2(20) NOT NULL ,
  704. "IN_EMAILALERT" Smallint Default 0 NOT NULL ,
  705. "IN_APPROVER" Smallint Default 0 NOT NULL ,
  706. "IN_PRICEAWARE" Smallint Default 0 NOT NULL ,
  707. "IN_STRUCTUREAWARE" Smallint Default 0 NOT NULL ,
  708. "IN_CUSTOMERAPPROVER" Smallint Default 0 NOT NULL ,
  709. "IN_QADINTEGRATOR" Smallint Default 0 NOT NULL ,
  710. Constraint "PK_USERPROFILE" primary key ("CD_USERPROFILE")
  711. )
  712. /
  713.  
  714. Create table "TUSER" (
  715. "CD_USER" Integer NOT NULL ,
  716. "CD_USERPROFILE" Integer NOT NULL ,
  717. "CD_CUSTOMER" Integer,
  718. "NM_USER" Varchar2(50) NOT NULL UNIQUE ,
  719. "NM_LOGIN" Varchar2(10) NOT NULL UNIQUE ,
  720. "DC_PASSWORD" Char(6) NOT NULL UNIQUE ,
  721. "DC_EMAIL" Varchar2(100) NOT NULL ,
  722. "CD_QUEUE" Integer NOT NULL ,
  723. Constraint "PK_USER" primary key ("CD_USER")
  724. )
  725. /
  726.  
  727. Create table "TCOMPONENT" (
  728. "CD_COMPONENT" Integer NOT NULL ,
  729. "DC_COMPONENT" Varchar2(100) NOT NULL ,
  730. "TP_COMPONENT" Varchar2(100) NOT NULL ,
  731. "NM_FORM" Varchar2(50) NOT NULL ,
  732. Constraint "PK_COMPONENTE" primary key ("CD_COMPONENT")
  733. )
  734. /
  735.  
  736. Create table "TSEQUENCE_CONTROL" (
  737. "NM_SEQUENCE" Varchar2(50) NOT NULL ,
  738. "CD_NEXTSEQUENCE" Integer NOT NULL ,
  739. Constraint "PK_SEQUENCECONTROL" primary key ("NM_SEQUENCE")
  740. )
  741. /
  742.  
  743. Create table "THELP" (
  744. "NM_FORM" Varchar2(50) NOT NULL ,
  745. "NM_HELP" Varchar2(100) NOT NULL ,
  746. "NU_SEQUENCE" Integer NOT NULL ,
  747. "BL_HELP" Long,
  748. "DC_FILE" Varchar2(100),
  749. Constraint "PK_HELP" primary key ("NM_FORM","NM_HELP","NU_SEQUENCE")
  750. )
  751. /
  752.  
  753. Create table "TCONFIGURATION" (
  754. "CD_CONFIGURATION" Integer NOT NULL ,
  755. "DC_CATEGORY" Varchar2(50) Default SYSTEM NOT NULL ,
  756. "DC_CONFIGURATION" Varchar2(100) NOT NULL UNIQUE ,
  757. "VL_CONFIGURATION" Varchar2(100) NOT NULL ,
  758. "TP_CONFIGURATION" Varchar2(20) NOT NULL ,
  759. Constraint "PK_CONFIGURATION" primary key ("CD_CONFIGURATION")
  760. )
  761. /
  762.  
  763. Create table "TREPORT" (
  764. "NM_FORM" Varchar2(50) NOT NULL ,
  765. "NM_REPORT" Varchar2(100) NOT NULL ,
  766. "BL_REPORT" Long,
  767. Constraint "PK_REPORT" primary key ("NM_FORM","NM_REPORT")
  768. )
  769. /
  770.  
  771. Create table "TDATALOAD" (
  772. "CD_DATALOAD" Integer NOT NULL ,
  773. "DC_LOADGROUP" Varchar2(50),
  774. "CD_USER" Integer NOT NULL ,
  775. "DT_DATALOAD" Date Default current_timestamp NOT NULL ,
  776. "BL_ITEM" Long,
  777. "BL_UM" Long,
  778. "BL_STOCK" Long,
  779. "BL_PRICE" Long,
  780. "BL_COST" Long,
  781. "BL_PRODUCTLINE" Long,
  782. "BL_PLANNING" Long,
  783. Constraint "pk_TDATALOAD" primary key ("CD_DATALOAD")
  784. )
  785. /
  786.  
  787. Create table "TPRODUCT_LINE" (
  788. "CD_PRODUCTLINE" Varchar2(4) NOT NULL ,
  789. "DC_PRODUCTLINE" Varchar2(50) NOT NULL ,
  790. Constraint "pk_TPRODUCT_LINE" primary key ("CD_PRODUCTLINE")
  791. )
  792. /
  793.  
  794. Create table "TITEM_TYPE" (
  795. "CD_ITEMTYPE" Varchar2(20) NOT NULL ,
  796. "DC_ITEMTYPE" Varchar2(50) NOT NULL ,
  797. Constraint "pk_TITEM_TYPE" primary key ("CD_ITEMTYPE")
  798. )
  799. /
  800.  
  801. Create table "TFORECAST" (
  802. "CD_FORECAST" Integer NOT NULL ,
  803. "CD_USER" Integer NOT NULL ,
  804. "DT_CREATION" Date NOT NULL ,
  805. "DC_STATUS" Varchar2(10) NOT NULL ,
  806. "NU_YEAR" Integer NOT NULL ,
  807. "DT_CLOSING" Date,
  808. "IN_MODIFIED" Smallint Default 0 NOT NULL ,
  809. "DT_MODIFICATION" Date,
  810. Constraint "pk_TFORECAST" primary key ("CD_FORECAST")
  811. )
  812. /
  813.  
  814. Create table "TFORECAST_DETAIL" (
  815. "CD_FORECAST" Integer NOT NULL ,
  816. "CD_ITEM" Varchar2(10) NOT NULL ,
  817. "VL_JANUARY" Decimal(15,5) Default 0 NOT NULL ,
  818. "VL_FEBRUARY" Decimal(15,5) Default 0 NOT NULL ,
  819. "VL_MARCH" Decimal(15,5) Default 0 NOT NULL ,
  820. "VL_APRIL" Decimal(15,5) Default 0 NOT NULL ,
  821. "VL_MAY" Decimal(15,5) Default 0 NOT NULL ,
  822. "VL_JUNE" Decimal(15,5) Default 0 NOT NULL ,
  823. "VL_JULY" Decimal(15,5) Default 0 NOT NULL ,
  824. "VL_AUGUST" Decimal(15,5) Default 0 NOT NULL ,
  825. "VL_SEPTEMBER" Decimal(15,5) Default 0 NOT NULL ,
  826. "VL_OCTOBER" Decimal(15,5) Default 0 NOT NULL ,
  827. "VL_NOVEMBER" Decimal(15,5) Default 0 NOT NULL ,
  828. "VL_DECEMBER" Decimal(15,5) Default 0 NOT NULL ,
  829. Constraint "pk_TFORECAST_DETAIL" primary key ("CD_FORECAST","CD_ITEM")
  830. )
  831. /
  832.  
  833. Create table "TCUSTOMER" (
  834. "CD_CUSTOMER" Integer NOT NULL ,
  835. "NM_CUSTOMER" Varchar2(50) NOT NULL ,
  836. "CD_CURRENCY" Char(3) NOT NULL ,
  837. "CD_ORDERCURRENCY" Char(3) Default BRL NOT NULL ,
  838. "CD_EXTERNALREFERENCE" Varchar2(50),
  839. "NU_DELIVERYDAYS" Integer Default 0 NOT NULL ,
  840. "DC_ORDERCYCLE" Varchar2(20) Default 'Weekly' NOT NULL ,
  841. "DC_ORDERWEEK" Varchar2(10) Default 'Week 1' NOT NULL ,
  842. "DC_DELIVERYWEEKDAY" Varchar2(10) Default 'Monday' NOT NULL ,
  843. "DC_PLACINGWEEKDAY" Varchar2(10) Default 'Friday' NOT NULL ,
  844. "CD_GROUPTYPE" Varchar2(10),
  845. "DC_SALESOPERATIONTYPE" Varchar2(10),
  846. "DC_BREAKDOWNOPERATIONTYPE" Varchar2(10),
  847. "DC_SALESENVIRONMENT" Varchar2(10),
  848. "DC_PURCHASEOPERATIONTYPE" Varchar2(10),
  849. Constraint "pk_TCUSTOMER" primary key ("CD_CUSTOMER")
  850. )
  851. /
  852.  
  853. Create table "TITEM_PRICE" (
  854. "CD_ITEM" Varchar2(10) NOT NULL ,
  855. "CD_UM" Varchar2(2) NOT NULL ,
  856. "CD_PRICELIST" Varchar2(10) NOT NULL ,
  857. "VL_PRICE" Decimal(15,5) NOT NULL ,
  858. "CD_CURRENCY" Char(3) NOT NULL ,
  859. "CD_GROUPTYPE" Varchar2(10) NOT NULL
  860. )
  861. /
  862.  
  863. Create table "TORDER_APPROVAL" (
  864. "NU_ORDER" Integer NOT NULL ,
  865. "CD_USER" Integer NOT NULL ,
  866. "IN_APPROVED" Integer Default 0 NOT NULL ,
  867. "DT_APPROVAL" Date,
  868. "IN_REJECTED" Integer Default 0 NOT NULL ,
  869. "DT_REJECTION" Date,
  870. "DC_REJECTIONREASON" Varchar2(100),
  871. Constraint "PK_ORDERAPPROVAL" primary key ("NU_ORDER","CD_USER")
  872. )
  873. /
  874.  
  875. Create table "TUSER_LOG" (
  876. "CD_USER" Integer NOT NULL ,
  877. "DT_LOG" Date Default current_timestamp NOT NULL ,
  878. "CD_EVENT" Integer NOT NULL ,
  879. Constraint "pk_TUSER_LOG" primary key ("CD_USER","DT_LOG","CD_EVENT")
  880. )
  881. /
  882.  
  883. Create table "TEVENT" (
  884. "CD_EVENT" Integer NOT NULL ,
  885. "DC_EVENT" Varchar2(50) NOT NULL ,
  886. Constraint "pk_TEVENT" primary key ("CD_EVENT")
  887. )
  888. /
  889.  
  890. Create table "TORDER_ITEM_COMMENT" (
  891. "NU_ORDER" Integer NOT NULL ,
  892. "NU_SEQUENCE" Integer NOT NULL ,
  893. "DT_COMMENT" Date Default CURRENT_TIMESTAMP NOT NULL ,
  894. "CD_USER" Integer NOT NULL ,
  895. "DC_COMMENT" Varchar2(500) NOT NULL ,
  896. Constraint "pk_TORDER_ITEM_COMMENT" primary key ("NU_ORDER","NU_SEQUENCE","DT_COMMENT","CD_USER","DC_COMMENT")
  897. )
  898. /
  899.  
  900. Create table "TTAX_RATE" (
  901. "DC_TAXTYPE" Varchar2(15) NOT NULL ,
  902. "DC_OPERATIONTYPE" Varchar2(10) NOT NULL ,
  903. "DC_TAXCLASS" Varchar2(3) NOT NULL ,
  904. "VL_RATE" Decimal(15,5) NOT NULL ,
  905. "NU_CALCULATION" Integer NOT NULL ,
  906. "IN_TAXINCLUDED" Smallint Default 0 NOT NULL ,
  907. "DC_TAXBASE" Varchar2(15),
  908. Constraint "PK_TAXRATE" primary key ("DC_TAXTYPE","DC_OPERATIONTYPE","DC_TAXCLASS")
  909. )
  910. /
  911.  
  912. Create table "TTAX_ENVIRONMENT" (
  913. "DC_ENVIRONMENT" Varchar2(15) NOT NULL ,
  914. "DC_TAXTYPE" Varchar2(15) NOT NULL ,
  915. Constraint "PK_ENVIRONMENTTAXES" primary key ("DC_ENVIRONMENT","DC_TAXTYPE")
  916. )
  917. /
  918.  
  919. Create table "TINVOICE_ITEM" (
  920. "CD_INVOICE" Integer NOT NULL ,
  921. "NU_SEQUENCE" Integer NOT NULL ,
  922. "CD_ITEM" Varchar2(10) NOT NULL ,
  923. "VL_QUANTITY" Decimal(15,5) Default 0 NOT NULL ,
  924. "CD_UM" Varchar2(2) NOT NULL ,
  925. "VL_CIFUNIT" Decimal(15,5) Default 0 NOT NULL ,
  926. "VL_ORDERUNIT" Decimal(15,5) Default 0 NOT NULL ,
  927. "VL_TOTALCIF" Decimal(15,5) Default 0 NOT NULL ,
  928. "DC_NCM" Char(10) NOT NULL ,
  929. "VL_ICMSRATE" Decimal(15,5) Default 0 NOT NULL ,
  930. "VL_IMPORTRATE" Decimal(15,5) Default 0 NOT NULL ,
  931. "VL_IPIRATE" Decimal(15,5) NOT NULL ,
  932. "VL_PISRATE" Decimal(15,5) Default 0 NOT NULL ,
  933. "VL_COFINSRATE" Decimal(15,5) Default 0 NOT NULL ,
  934. "VL_COFCPLRATE" Decimal(15,5) Default 0 NOT NULL ,
  935. "DC_OPERATIONTYPE" Varchar2(15) NOT NULL ,
  936. "DC_TAXCLASS" Char(3) NOT NULL ,
  937. "VL_NETWEIGHT" Decimal(15,5) Default 0 NOT NULL ,
  938. "VL_GROSSWEIGHT" Decimal(15,5) Default 0 NOT NULL ,
  939. "NU_ADICAO" Integer,
  940. "NU_ITEM" Integer,
  941. "NU_PURCHASEORDER" Varchar2(20),
  942. "NU_ORDERITEM" Integer,
  943. "DC_LOCATION" Varchar2(80),
  944. "DC_LOT" Varchar2(30),
  945. "DT_EXPIRATION" Date,
  946. Constraint "PK_INVOICEITEM" primary key ("CD_INVOICE","NU_SEQUENCE")
  947. )
  948. /
  949.  
  950. Create table "TSUPPLIER" (
  951. "CD_SUPPLIER" Integer NOT NULL ,
  952. "NM_SUPPLIER" Varchar2(50) NOT NULL ,
  953. "CD_CURRENCY" Char(3) NOT NULL ,
  954. "CD_EXTERNALREFERENCE" Varchar2(10),
  955. "DC_OPERATIONTYPE" Varchar2(10),
  956. "CD_CURRENCY" Char(3),
  957. "CD_STATE" Char(2),
  958. "CD_FEDERALID" Varchar2(20),
  959. Constraint "PK_SUPPLIER" primary key ("CD_SUPPLIER")
  960. )
  961. /
  962.  
  963. Create table "TINVOICE" (
  964. "CD_INVOICE" Integer NOT NULL ,
  965. "CD_CREDITTERMS" Varchar2(10) NOT NULL ,
  966. "CD_USER" Integer NOT NULL ,
  967. "CD_SUPPLIER" Integer NOT NULL ,
  968. "CD_INVOICEMODEL" Char(2) Default 55 NOT NULL ,
  969. "NU_INVOICETYPE" Integer Default 1 NOT NULL ,
  970. "DT_INVOICE" Date NOT NULL ,
  971. "VL_SISCOMEX" Decimal(15,5) Default 0 NOT NULL ,
  972. "VL_AFRMM" Decimal(15,5) Default 0 NOT NULL ,
  973. "DC_ENVIRONMENT" Varchar2(15) NOT NULL ,
  974. "CD_ORDERCURRENCY" Char(3) Default 'BRL' NOT NULL ,
  975. "NU_DI" Varchar2(20),
  976. "DT_DI" Date,
  977. "DC_PLACEOFLANDING" Varchar2(20),
  978. "DT_LANDING" Date,
  979. "NU_TRANSPORTROUTE" Integer,
  980. "NU_INVOICE" Integer,
  981. "NU_SERIES" Integer,
  982. "VL_EXCHANGERATE" Decimal(15,5) Default 0,
  983. "DC_STATEOFLANDING" Varchar2(2),
  984. "CD_CREDITTERMS" Varchar2(10),
  985. "NU_SEFAZKEY" Varchar2(50),
  986. "DC_TRANSPORTER" Varchar2(50),
  987. "DC_PROCESSREFERENCE" Varchar2(50),
  988. "IN_CLOSED" Smallint Default 0 NOT NULL ,
  989. "VL_WAREHOUSING" Decimal(15,5),
  990. "VL_DELIVERYFREIGHT" Decimal(15,5),
  991. "VL_BROKER" Decimal(15,5),
  992. "VL_FINE" Decimal(15,5),
  993. "VL_GRUANVISA" Decimal(15,5),
  994. "VL_BLAWB" Decimal(15,5),
  995. Constraint "PK_INVOICE" primary key ("CD_INVOICE")
  996. )
  997. /
  998.  
  999. Create table "TITEM_SUPPLIER" (
  1000. "CD_ITEM" Varchar2(10) NOT NULL ,
  1001. "CD_UM" Varchar2(2) NOT NULL ,
  1002. "CD_SUPPLIER" Integer NOT NULL ,
  1003. "CD_CURRENCY" Varchar2(3) NOT NULL ,
  1004. "VL_PRICE" Decimal(15,5) Default 0 NOT NULL ,
  1005. Constraint "PK_ITEMSUPPLIER" primary key ("CD_ITEM","CD_UM","CD_SUPPLIER","CD_CURRENCY")
  1006. )
  1007. /
  1008.  
  1009. Create table "TCREDIT_TERMS" (
  1010. "CD_CREDITTERMS" Varchar2(10) NOT NULL ,
  1011. "DC_CREDITTERMS" Varchar2(50) NOT NULL ,
  1012. Constraint "pk_TCREDIT_TERMS" primary key ("CD_CREDITTERMS")
  1013. )
  1014. /
  1015.  
  1016. Create table "TMRP_DETAIL" (
  1017. "CD_MRP" Integer NOT NULL ,
  1018. "CD_ITEM" Varchar2(10) NOT NULL ,
  1019. "NU_YEAR" Integer NOT NULL ,
  1020. "VL_JANUARY" Decimal(15,5) Default 0,
  1021. "VL_JANSUGGESTION" Decimal(15,5),
  1022. "VL_FEBRUARY" Decimal(15,5) Default 0,
  1023. "VL_FEBSUGGESTION" Decimal(15,5),
  1024. "VL_MARCH" Decimal(15,5) Default 0,
  1025. "VL_MARSUGGESTION" Decimal(15,5),
  1026. "VL_APRIL" Decimal(15,5) Default 0,
  1027. "VL_APRSUGGESTION" Decimal(15,5),
  1028. "VL_MAY" Decimal(15,5) Default 0,
  1029. "VL_MAYSUGGESTION" Decimal(15,5),
  1030. "VL_JUNE" Decimal(15,5) Default 0,
  1031. "VL_JUNSUGGESTION" Decimal(15,5),
  1032. "VL_JULY" Decimal(15,5) Default 0,
  1033. "VL_JULSUGGESTION" Decimal(15,5),
  1034. "VL_AUGUST" Decimal(15,5) Default 0,
  1035. "VL_AUGSUGGESTION" Decimal(15,5),
  1036. "VL_SEPTEMBER" Decimal(15,5) Default 0,
  1037. "VL_SEPSUGGESTION" Decimal(15,5),
  1038. "VL_OCTOBER" Decimal(15,5) Default 0,
  1039. "VL_OCTSUGGESTION" Decimal(15,5),
  1040. "VL_NOVEMBER" Decimal(15,5) Default 0,
  1041. "VL_NOVSUGGESTION" Decimal(15,5),
  1042. "VL_DECEMBER" Decimal(15,5) Default 0,
  1043. "VL_DECSUGGESTION" Decimal(15,5),
  1044. Constraint "PK_MRPDETAIL" primary key ("CD_MRP","CD_ITEM","NU_YEAR")
  1045. )
  1046. /
  1047.  
  1048. Create table "TMRP" (
  1049. "CD_MRP" Integer NOT NULL ,
  1050. "DT_MRP" Date NOT NULL ,
  1051. Constraint "PK_MRP" primary key ("CD_MRP")
  1052. )
  1053. /
  1054.  
  1055. Create table "TVERSION" (
  1056. "CD_VERSION" Varchar2(10) NOT NULL ,
  1057. "BL_FILE" Long NOT NULL ,
  1058. Constraint "PK_VERSION" primary key ("CD_VERSION")
  1059. )
  1060. /
  1061.  
  1062. Create table "TEMAIL" (
  1063. "CD_EMAIL" Integer NOT NULL ,
  1064. "DT_EMAIL" Date NOT NULL ,
  1065. "DC_RECIPIENTS" Varchar2(1000) NOT NULL ,
  1066. "DC_SUBJECT" Varchar2(100) NOT NULL ,
  1067. "IN_SENT" Smallint Default 0 NOT NULL ,
  1068. "DT_SENDING" Date,
  1069. Constraint "PK_EMAIL" primary key ("CD_EMAIL")
  1070. )
  1071. /
  1072.  
  1073. Create table "TEMAIL_ATTACH" (
  1074. "CD_EMAIL" Integer NOT NULL ,
  1075. "NU_SEQUENCE" Integer NOT NULL ,
  1076. "DC_CONTENTTYPE" Varchar2(50) NOT NULL ,
  1077. "BL_ATTACHMENT" Long NOT NULL ,
  1078. Constraint "PK_ATTACHMENT" primary key ("CD_EMAIL","NU_SEQUENCE")
  1079. )
  1080. /
  1081.  
  1082. Create table "TTAX_BASE" (
  1083. "DC_TAXBASE" Varchar2(15) NOT NULL ,
  1084. "DC_TAXTYPE" Varchar2(15) NOT NULL ,
  1085. "VL_BASEPERCENTAGE" Decimal(15,5) NOT NULL ,
  1086. Constraint "PK_TAXBASE" primary key ("DC_TAXBASE","DC_TAXTYPE")
  1087. )
  1088. /
  1089.  
  1090. Create table "TITEM_STRUCTURE" (
  1091. "CD_PARENTITEM" Varchar2(10) NOT NULL ,
  1092. "CD_COMPONENTITEM" Varchar2(10) NOT NULL ,
  1093. "CD_TYPESTRUCTURE" Char(1) Default S NOT NULL ,
  1094. "CD_TYPEQUANTITY" Char(1) Default B NOT NULL ,
  1095. "VL_QUANTITY" Decimal(15,5) Default 0 NOT NULL ,
  1096. Constraint "pk_TITEM_STRUCTURE" primary key ("CD_PARENTITEM","CD_COMPONENTITEM")
  1097. )
  1098. /
  1099.  
  1100. Create table "TINVOICE_STATUS" (
  1101. "CD_INVOICE" Integer NOT NULL ,
  1102. "NU_SEQUENCE" Smallint NOT NULL ,
  1103. "CD_USER" Integer NOT NULL ,
  1104. "CD_INVOICESTEP" Integer NOT NULL ,
  1105. "DT_STATUS" Date NOT NULL ,
  1106. Constraint "PK_INVOICESTATUS" primary key ("CD_INVOICE","NU_SEQUENCE","CD_USER")
  1107. )
  1108. /
  1109.  
  1110. Create table "TINVOICE_STEP" (
  1111. "CD_INVOICESTEP" Integer NOT NULL ,
  1112. "DC_INVOICESTEP" Varchar2(50) NOT NULL ,
  1113. Constraint "PK_INVOICESTEP" primary key ("CD_INVOICESTEP")
  1114. )
  1115. /
  1116.  
  1117. Create table "TNCM" (
  1118. "DC_NCM" Varchar2(10) NOT NULL ,
  1119. Constraint "pk_TNCM" primary key ("DC_NCM")
  1120. )
  1121. /
  1122.  
  1123. Create table "TNCM_TAXES" (
  1124. "DC_ENVIRONMENT" Varchar2(15) NOT NULL ,
  1125. "DC_NCM" Varchar2(10) NOT NULL ,
  1126. "DC_TAXTYPE" Varchar2(15) NOT NULL ,
  1127. "VL_RATE" Decimal(15,5) NOT NULL ,
  1128. Constraint "pk_TNCM_TAXES" primary key ("DC_ENVIRONMENT","DC_NCM","DC_TAXTYPE")
  1129. )
  1130. /
  1131.  
  1132. Create table "TSNAPSHOT" (
  1133. "CD_SNAPSHOT" Integer NOT NULL UNIQUE ,
  1134. "DT_SNAPSHOT" Date NOT NULL ,
  1135. "DC_SNAPSHOT" Varchar2(50) NOT NULL ,
  1136. Constraint "pk_TSNAPSHOT" primary key ("CD_SNAPSHOT")
  1137. )
  1138. /
  1139.  
  1140. Create table "TSNAPSHOT_ITEM" (
  1141. "CD_ITEM" Varchar2(10) NOT NULL ,
  1142. "CD_SNAPSHOT" Integer NOT NULL ,
  1143. "DC_ITEM" Varchar2(50) NOT NULL ,
  1144. "DC_ITEM2" Varchar2(50) NOT NULL ,
  1145. "CD_PRODUCTLINE" Varchar2(3) NOT NULL ,
  1146. "IN_PM" Char(1) NOT NULL ,
  1147. "CD_ITEMTYPE" Varchar2(10) NOT NULL ,
  1148. "CD_UM" Char(2) NOT NULL ,
  1149. Constraint "pk_TSNAPSHOT_ITEM" primary key ("CD_ITEM","CD_SNAPSHOT")
  1150. )
  1151. /
  1152.  
  1153. Create table "TSNAPSHOT_STRUCTURE" (
  1154. "CD_PARENTSNAPSHOT" Integer NOT NULL ,
  1155. "CD_PARENTITEM" Varchar2(10) NOT NULL ,
  1156. "CD_COMPONENTSNAPSHOT" Integer NOT NULL ,
  1157. "CD_COMPONENTITEM" Varchar2(10) NOT NULL ,
  1158. "DC_REFERENCE" Varchar2(20) NOT NULL ,
  1159. "VL_QUANTITY" Decimal(15,5) NOT NULL ,
  1160. "DT_MODIFICATION" Date,
  1161. "DT_ADDING" Date,
  1162. "CD_UM" Char(2),
  1163. "CD_QUANTITYTYPE" Char(1) NOT NULL ,
  1164. Constraint "pk_TSNAPSHOT_STRUCTURE" primary key ("CD_PARENTSNAPSHOT","CD_PARENTITEM","CD_COMPONENTSNAPSHOT","CD_COMPONENTITEM","DC_REFERENCE")
  1165. )
  1166. /
  1167.  
  1168. Create table "TORDER_ITEM_DELIVERY" (
  1169. "NU_ORDER" Integer NOT NULL ,
  1170. "NU_SEQUENCE" Integer NOT NULL ,
  1171. "NU_QADORDER" Varchar2(10) NOT NULL ,
  1172. "VL_QUANTITY" Decimal(15,5) NOT NULL ,
  1173. "DT_DELIVERED" Date,
  1174. "NU_SEFAZKEY" Varchar2(50),
  1175. "NU_INVOICE" Integer,
  1176. "NU_SERIES" Integer,
  1177. Constraint "PK_ORDERITEMDELIVERY" primary key ("NU_ORDER","NU_SEQUENCE","NU_QADORDER")
  1178. )
  1179. /
  1180.  
  1181. Create table "TITEM_STOCK" (
  1182. "CD_ITEM" Varchar2(10) NOT NULL ,
  1183. "DC_LOCATION" Varchar2(80) NOT NULL ,
  1184. "DC_LOT" Varchar2(30) NOT NULL ,
  1185. "DT_EXPIRATION" Date,
  1186. "VL_QUANTITY" Decimal(15,5) NOT NULL ,
  1187. "DT_LASTCOUNT" Date,
  1188. "DT_CREATION" Date NOT NULL ,
  1189. Constraint "pk_TITEM_STOCK" primary key ("CD_ITEM","DC_LOCATION","DC_LOT")
  1190. )
  1191. /
  1192.  
  1193. Create table "TSTOCK_CHECK" (
  1194. "CD_STOCKCHECK" Integer NOT NULL ,
  1195. "DT_STOCK" Date NOT NULL ,
  1196. "IN_PENDING" Smallint NOT NULL ,
  1197. Constraint "pk_TSTOCK_CHECK" primary key ("CD_STOCKCHECK")
  1198. )
  1199. /
  1200.  
  1201. Create table "TITEM_STOCK_CHECK" (
  1202. "CD_STOCKCHECK" Integer NOT NULL ,
  1203. "CD_ITEM" Varchar2(10) NOT NULL ,
  1204. "DC_LOCATION" Varchar2(80) NOT NULL ,
  1205. "DC_LOT" Varchar2(30) NOT NULL ,
  1206. "VL_QUANTITY" Decimal(15,5) NOT NULL ,
  1207. "DT_COUNTING" Date,
  1208. "VL_COUNTED" Decimal(15,5) Default 0 NOT NULL ,
  1209. "IN_COUNTED" Smallint Default 0 NOT NULL ,
  1210. "DT_EXPIRATION" Date,
  1211. Constraint "pk_TITEM_STOCK_CHECK" primary key ("CD_STOCKCHECK","CD_ITEM","DC_LOCATION","DC_LOT")
  1212. )
  1213. /
  1214.  
  1215. Create table "TLOCATION" (
  1216. "CD_LOCATION" Char(50) NOT NULL ,
  1217. Constraint "PK_LOCATION" primary key ("CD_LOCATION")
  1218. )
  1219. /
  1220.  
  1221. Create table "TQAD_NF" (
  1222. "NU_NF" Varchar2(10) NOT NULL ,
  1223. "NU_LINE" Integer NOT NULL ,
  1224. "DT_SHIP" Date NOT NULL ,
  1225. "CD_CUSTOMER" Varchar2(10) NOT NULL ,
  1226. "CD_ITEM" Varchar2(10) NOT NULL ,
  1227. "DC_ITEM1" Varchar2(30) NOT NULL ,
  1228. "VL_PRICE" Decimal(15,5) Default 0 NOT NULL ,
  1229. "VL_QUANTITY" Decimal(15,5) NOT NULL ,
  1230. "CD_UM" Varchar2(2) NOT NULL ,
  1231. "NU_INVOICE" Char(10) NOT NULL ,
  1232. "CD_FISCALCLASS" Varchar2(20),
  1233. Constraint "pk_TQAD_NF" primary key ("NU_NF","NU_LINE")
  1234. )
  1235. /
  1236.  
  1237. Create table "TQAD_TAXESINV" (
  1238. "NU_INVOICE" Varchar2(10) NOT NULL ,
  1239. "NU_LINE" Integer NOT NULL ,
  1240. "DC_TAXTYPE" Varchar2(20) NOT NULL ,
  1241. "IN_TAX" Integer NOT NULL ,
  1242. "VL_AMOUNT" Decimal(15,5) NOT NULL ,
  1243. "DC_TAXUSAGE" Varchar2(20) NOT NULL ,
  1244. "DC_TAXCLASS" Char(3) NOT NULL ,
  1245. Constraint "pk_TQAD_TAXESINV" primary key ("NU_INVOICE","NU_LINE","DC_TAXTYPE")
  1246. )
  1247. /
  1248.  
  1249. Create table "TTMP_SalesOrder" (
  1250. "NU_SALESORDER" Varchar2(10) NOT NULL ,
  1251. "NU_LINE" Char(10) NOT NULL ,
  1252. "CD_ITEM" Varchar2(10) NOT NULL ,
  1253. "VL_QTYSHIPPED" Decimal(15,5),
  1254. "DT_EFFECTIVE" Char(10),
  1255. Constraint "PK_TMPSALESORDER" primary key ("NU_SALESORDER","NU_LINE","CD_ITEM")
  1256. )
  1257. /
  1258.  
  1259. Create table "TTICKET" (
  1260. "CD_TICKET" Integer NOT NULL ,
  1261. "CD_USER" Integer NOT NULL ,
  1262. "DT_TICKET" Date NOT NULL ,
  1263. Constraint "PK_TICKET" primary key ("CD_TICKET")
  1264. )
  1265. /
  1266.  
  1267. Create table "TQUEUE" (
  1268. "CD_QUEUE" Integer NOT NULL ,
  1269. "NM_QUEUE" Varchar2(50) NOT NULL ,
  1270. Constraint "pk_TQUEUE" primary key ("CD_QUEUE")
  1271. )
  1272. /
  1273.  
  1274. Create table "TPURCHASE_ORDER" (
  1275. "NU_ORDER" Integer NOT NULL ,
  1276. "CD_USER" Integer NOT NULL ,
  1277. "CD_SUPPLIER" Integer NOT NULL ,
  1278. "NU_POTYPE" Integer NOT NULL ,
  1279. "DT_ORDER" Date NOT NULL ,
  1280. "DC_EXTERNALREFERENCE" Varchar2(50),
  1281. "DC_PROCESSREFERENCE" Varchar2(50),
  1282. "CD_CURRENCY" Char(3) NOT NULL ,
  1283. "DT_DUE" Date NOT NULL ,
  1284. "TX_ADDITIONAL" Long,
  1285. "CD_STATUS" Integer NOT NULL ,
  1286. "VL_DISCOUNT" Decimal(15,5),
  1287. "VL_INCREASE" Decimal(15,5),
  1288. "IN_CLOSED" Smallint Default 0 NOT NULL ,
  1289. Constraint "PK_PURCHASEORDER" primary key ("NU_ORDER")
  1290. )
  1291. /
  1292.  
  1293. Create table "TMP_ITEMDATALOAD" (
  1294. "PT_PART" Varchar2(30) NOT NULL ,
  1295. "PT_UM" Varchar2(30),
  1296. "PT_STATUS" Varchar2(80),
  1297. "PT_PART_TYPE" Varchar2(80),
  1298. "PT_DESC1" Varchar2(80),
  1299. "PT_DESC2" Varchar2(80),
  1300. "PT_PROD_LINE" Varchar2(30),
  1301. "PT_ADDED" Date,
  1302. "PT_PUR_LEAD" Integer,
  1303. "PT_FISCAL_CLASS" Varchar2(30),
  1304. "PT_TAXC" Varchar2(30),
  1305. "PT_DRAW" Varchar2(30),
  1306. "PT_PM_CODE" Varchar2(30),
  1307. "SPT_COST" Decimal(15,5),
  1308. "LD_QTY_OH" Decimal(15,5),
  1309. "PT_BUYER" Varchar2(80),
  1310. "PT_VENDOR" Varchar2(80),
  1311. "PT_PHANTOM" Smallint,
  1312. Constraint "PK_TMPITEMDATALOAD" primary key ("PT_PART")
  1313. )
  1314. /
  1315.  
  1316. Create table "TMP_UMDATALOAD" (
  1317. "UM_PART" Varchar2(30) NOT NULL ,
  1318. "UM_ALT_UM" Varchar2(30) NOT NULL ,
  1319. "UM_UM" Varchar2(30) NOT NULL ,
  1320. "UM_CONV" Decimal(15,5) NOT NULL ,
  1321. Constraint "PK_TMPUMDATALOAT" primary key ("UM_PART","UM_ALT_UM","UM_UM")
  1322. )
  1323. /
  1324.  
  1325. Create table "TMP_LOCDATALOAD" (
  1326. "LOC_LOC" Char(10) NOT NULL ,
  1327. Constraint "PK_TMPLOCDATALOAD" primary key ("LOC_LOC")
  1328. )
  1329. /
  1330.  
  1331. Create table "TMP_STOCKDATALOAD" (
  1332. "LD_PART" Varchar2(30) NOT NULL ,
  1333. "LD_LOC" Varchar2(80) NOT NULL ,
  1334. "LD_LOT" Varchar2(30) NOT NULL ,
  1335. "LD_DATE" Date,
  1336. "LD_QTY_OH" Decimal(15,5),
  1337. "LD_CNT_DATE" Date,
  1338. "LD_EXPIRE" Date,
  1339. Constraint "PK_TMPSTOCKDATALOAD" primary key ("LD_PART","LD_LOC","LD_LOT")
  1340. )
  1341. /
  1342.  
  1343. Create table "TMP_PRODLINEDATALOAD" (
  1344. "PL_PROD_LINE" Varchar2(30) NOT NULL ,
  1345. "PL_DESC" Varchar2(80),
  1346. Constraint "PK_PRODLINEDATALOAD" primary key ("PL_PROD_LINE")
  1347. )
  1348. /
  1349.  
  1350. Create table "TMP_TAXESDATALOAD" (
  1351. "TX2_TAX_TYPE" Varchar2(30) NOT NULL ,
  1352. "TX2_TAX_USAGE" Varchar2(80) NOT NULL ,
  1353. "TX2_PT_TAXC" Varchar2(30) NOT NULL ,
  1354. "TX2_TAX_PCT" Decimal(15,5),
  1355. "TX2_METHOD" Varchar2(30),
  1356. "TX2_BASE" Varchar2(80),
  1357. "TX2_TAX_IN" Char(10),
  1358. Constraint "PK_TMPDATALOAD" primary key ("TX2_TAX_TYPE","TX2_TAX_USAGE","TX2_PT_TAXC")
  1359. )
  1360. /
  1361.  
  1362. Create table "TMP_TAXBASEDATALOAD" (
  1363. "TXBD_BASE" Varchar2(80) NOT NULL ,
  1364. "TXBR_TAX_TYPE" Varchar2(30) NOT NULL ,
  1365. "TXBD_PERCENT" Varchar2(10),
  1366. Constraint "PK_TAXBASEDATALOAD" primary key ("TXBD_BASE","TXBR_TAX_TYPE")
  1367. )
  1368. /
  1369.  
  1370. Create table "TMP_TAX_ENVIRONMENT" (
  1371. "TXED_TAX_ENV" Varchar2(30) NOT NULL ,
  1372. "TXED_TAX_TYPE" Varchar2(30) NOT NULL ,
  1373. Constraint "pk_TMP_TAX_ENVIRONMENT" primary key ("TXED_TAX_ENV","TXED_TAX_TYPE")
  1374. )
  1375. /
  1376.  
  1377. Create table "TPURCHASE_ORDER_ITEM" (
  1378. "NU_ORDER" Integer NOT NULL ,
  1379. "CD_STATUS" Integer NOT NULL ,
  1380. "CD_ITEM" Varchar2(10) NOT NULL ,
  1381. "CD_ORDERUM" Varchar2(2) NOT NULL ,
  1382. "NU_SEQUENCE" Integer NOT NULL ,
  1383. "VL_QUANTITY" Decimal(15,5) NOT NULL ,
  1384. "VL_QTYSHIPPED" Decimal(15,5) Default 0 NOT NULL ,
  1385. "VL_PRICE" Decimal(15,5) NOT NULL ,
  1386. "DT_DUE" Date NOT NULL ,
  1387. "DT_DELIVERY" Date,
  1388. "VL_SHIPPED" Decimal(15,5),
  1389. "TX_ADDITIONAL" Long,
  1390. "IN_REMOVED" Smallint Default 0 NOT NULL ,
  1391. "DC_REMOVALREASON" Varchar2(50),
  1392. Constraint "PK_PURCHASEORDERITEM" primary key ("NU_ORDER","NU_SEQUENCE")
  1393. )
  1394. /
  1395.  
  1396. Create table "TPO_ITEM_STEP" (
  1397. "CD_POITEMSTEP" Integer NOT NULL ,
  1398. "DC_POITEMSTEP" Varchar2(50) NOT NULL ,
  1399. "IN_USERSELECTABLE" Smallint Default 0 NOT NULL ,
  1400. Constraint "PK_POITEMSTEP" primary key ("CD_POITEMSTEP")
  1401. )
  1402. /
  1403.  
  1404. Create table "TPO_ITEM_STATUS" (
  1405. "NU_ORDER" Integer NOT NULL ,
  1406. "NU_SEQUENCE" Integer NOT NULL ,
  1407. "NU_SEQ" Integer NOT NULL ,
  1408. "DT_STATUS" Date NOT NULL ,
  1409. "CD_POITEMSTEP" Integer NOT NULL ,
  1410. Constraint "PK_POITEMSTATUS" primary key ("NU_ORDER","NU_SEQUENCE","NU_SEQ")
  1411. )
  1412. /
  1413.  
  1414. Create table "TPO_STEP" (
  1415. "CD_POSTEP" Integer NOT NULL ,
  1416. "DC_POSTEP" Varchar2(50) NOT NULL ,
  1417. "IN_USERSELECTABLE" Smallint Default 0 NOT NULL ,
  1418. "IN_TRANSIT" Smallint Default 0 NOT NULL ,
  1419. "IN_CLOSED" Smallint Default 0 NOT NULL ,
  1420. "IN_DELIVERED" Smallint Default 0 NOT NULL ,
  1421. Constraint "PK_POSTEP" primary key ("CD_POSTEP")
  1422. )
  1423. /
  1424.  
  1425. Create table "TPO_STATUS" (
  1426. "NU_ORDER" Integer NOT NULL ,
  1427. "NU_SEQ" Integer NOT NULL ,
  1428. "CD_POSTEP" Integer NOT NULL ,
  1429. "DT_STATUS" Date NOT NULL ,
  1430. Constraint "PK_POSTATUS" primary key ("NU_ORDER","NU_SEQ")
  1431. )
  1432. /
  1433.  
  1434. Create table "TMP_CUSTOMERITEM" (
  1435. "CP_CUST" Varchar2(10) NOT NULL ,
  1436. "CP_PART" Varchar2(10) NOT NULL ,
  1437. Constraint "pk_TMP_CUSTOMERITEM" primary key ("CP_CUST","CP_PART")
  1438. )
  1439. /
  1440.  
  1441. Create table "TITEM_CUSTOMER" (
  1442. "CD_ITEM" Varchar2(10) NOT NULL ,
  1443. "CD_CUSTOMER" Integer NOT NULL ,
  1444. Constraint "pk_TITEM_CUSTOMER" primary key ("CD_ITEM","CD_CUSTOMER")
  1445. )
  1446. /
  1447.  
  1448. Create table "TMP_EXCHANGERATE" (
  1449. "EXR_CURR1" Varchar2(30) NOT NULL ,
  1450. "EXR_CURR2" Varchar2(30) NOT NULL ,
  1451. "EXR_START_DATE" Date NOT NULL ,
  1452. "EXR_END_DATE" Date NOT NULL ,
  1453. "EXR_RATE1" Decimal(15,10),
  1454. "EXR_RATE2" Decimal(15,10),
  1455. Constraint "pk_TMP_EXCHANGERATE" primary key ("EXR_CURR1","EXR_CURR2","EXR_START_DATE","EXR_END_DATE")
  1456. )
  1457. /
  1458.  
  1459. Create table "TEXCHANGE_RATE" (
  1460. "CD_SOURCECURRENCY" Varchar2(30) NOT NULL ,
  1461. "CD_TARGETCURRENCY" Varchar2(30) NOT NULL ,
  1462. "VL_RATE" Decimal(15,5) Default 0 NOT NULL ,
  1463. "DT_START" Date NOT NULL ,
  1464. "DT_END" Date NOT NULL ,
  1465. Constraint "pk_TEXCHANGE_RATE" primary key ("CD_SOURCECURRENCY","CD_TARGETCURRENCY")
  1466. )
  1467. /
  1468.  
  1469. Create table "TDRAWBACK" (
  1470. "CD_DRAWBACK" Integer NOT NULL ,
  1471. "CD_USER" Integer NOT NULL ,
  1472. "DT_DRAWBACK" Char(10) NOT NULL ,
  1473. Constraint "PK_DRAWBACK" primary key ("CD_DRAWBACK")
  1474. )
  1475. /
  1476.  
  1477. Create table "TDRAWBACK_ITEM" (
  1478. "CD_DRAWBACK" Integer NOT NULL ,
  1479. "NU_SEQUENCE" Integer NOT NULL ,
  1480. "CD_ITEM" Varchar2(10) NOT NULL ,
  1481. "CD_UM" Varchar2(2) NOT NULL ,
  1482. "VL_QUANTITY" Decimal(15,5) Default 0 NOT NULL ,
  1483. Constraint "PK_DRAWBACKITEM" primary key ("CD_DRAWBACK","NU_SEQUENCE")
  1484. )
  1485. /
  1486.  
  1487. Create table "TDRAWBACK_ITEM_BREAK" (
  1488. "CD_DRAWBACK" Integer NOT NULL ,
  1489. "NU_SEQUENCE" Integer NOT NULL ,
  1490. "CD_UM" Varchar2(2) NOT NULL ,
  1491. "VL_QUANTITY" Decimal(15,5) Default 0 NOT NULL ,
  1492. Constraint "PK_ITEMBREAKDOWN" primary key ("CD_DRAWBACK","NU_SEQUENCE")
  1493. )
  1494. /
  1495.  
  1496. Create table "TMP_POITEMDATALOAD" (
  1497. "POD_NBR" Varchar2(80) NOT NULL ,
  1498. "POD_LINE" Integer NOT NULL ,
  1499. "POD_PART" Varchar2(30),
  1500. "POD_QTY_ORD" Decimal(15,5),
  1501. "POD_STATUS" Varchar2(30),
  1502. Constraint "PK_POITEMDATALOAD" primary key ("POD_NBR","POD_LINE")
  1503. )
  1504. /
  1505.  
  1506.  
  1507.  
  1508. set ANSI_NULLS ON
  1509. set QUOTED_IDENTIFIER ON
  1510. GO
  1511. -- =============================================
  1512. -- Author: <Author,,Name>
  1513. -- Create date: <Create Date,,>
  1514. -- Description: <Description,,>
  1515. -- =============================================
  1516. CREATE TRIGGER [dbo].[ORDERITEM_DELETE]
  1517. ON [dbo].[TORDER_ITEM]
  1518. FOR DELETE
  1519. AS
  1520. DECLARE @ITEM_NUMBER VARCHAR(10)
  1521. DECLARE @DESCRIPTION VARCHAR(10)
  1522. DECLARE @QUANTITY NUMERIC(15,5)
  1523. DECLARE @ORDER_NUMBER INT
  1524. DECLARE @LAST_USER VARCHAR(10)
  1525. BEGIN
  1526.  
  1527.  
  1528.  
  1529. SELECT @ITEM_NUMBER = D.CD_ITEM
  1530. , @DESCRIPTION = I.DC_ITEM
  1531. , @QUANTITY = D.VL_QUANTITY
  1532. , @ORDER_NUMBER = D.NU_ORDER
  1533. , @LAST_USER = U.NM_LOGIN
  1534. FROM DELETED D
  1535. , TITEM I
  1536. , TORDER O
  1537. , TUSER U
  1538. WHERE I.CD_ITEM = D.CD_ITEM
  1539. AND O.NU_ORDER = D.NU_ORDER
  1540. AND U.CD_USER = O.CD_LASTUSER
  1541. ;
  1542.  
  1543. IF @ORDER_NUMBER IS NOT NULL
  1544. BEGIN
  1545.  
  1546. UPDATE TORDER
  1547. SET TX_UPDATES = case
  1548. when cast( TX_UPDATES as varchar(max)) is not null then
  1549. cast( TX_UPDATES as varchar(max))
  1550. else ''
  1551. end + char(13) +
  1552. CONVERT(VARCHAR(10),GETDATE(),103) + ': ' +
  1553. 'User ' + @LAST_USER + ' deleted item: ' +
  1554. @ITEM_NUMBER + ' - ' +
  1555. @DESCRIPTION + ' - ' +
  1556. cast( @QUANTITY AS VARCHAR(100) )
  1557. , IN_ADJUSTED = 1
  1558. WHERE NU_ORDER = @ORDER_NUMBER
  1559. ;
  1560. END;
  1561.  
  1562. -- SET NOCOUNT ON added to prevent extra result sets from
  1563. -- interfering with SELECT statements.
  1564. SET NOCOUNT ON;
  1565.  
  1566. -- Insert statements for trigger here
  1567.  
  1568. END
  1569.  
  1570.  
  1571.  
  1572. GO
  1573.  
  1574. -- =============================================
  1575. -- Author: <Author,,Name>
  1576. -- Create date: <Create Date,,>
  1577. -- Description: <Description,,>
  1578. -- =============================================
  1579. CREATE TRIGGER [dbo].[ORDERITEM_INSERT]
  1580. ON [dbo].[TORDER_ITEM]
  1581. FOR INSERT
  1582. AS
  1583. DECLARE @ITEM_NUMBER VARCHAR(10)
  1584. DECLARE @DESCRIPTION VARCHAR(10)
  1585. DECLARE @QUANTITY NUMERIC(15,5)
  1586. DECLARE @ORDER_NUMBER INT
  1587. DECLARE @DUE_DATE DATETIME
  1588. DECLARE @LAST_USER VARCHAR(10)
  1589. BEGIN
  1590.  
  1591. SELECT @ITEM_NUMBER = I.CD_ITEM
  1592. , @DESCRIPTION = I.DC_ITEM
  1593. , @QUANTITY = INS.VL_QUANTITY
  1594. , @ORDER_NUMBER = INS.NU_ORDER
  1595. , @LAST_USER = U.NM_LOGIN
  1596. , @DUE_DATE = INS.DT_DELIVERY
  1597. FROM INSERTED INS
  1598. , TITEM I
  1599. , TORDER O
  1600. , TUSER U
  1601. WHERE I.CD_ITEM = INS.CD_ITEM
  1602. AND O.NU_ORDER = INS.NU_ORDER
  1603. AND U.CD_USER = O.CD_LASTUSER
  1604. ;
  1605.  
  1606. UPDATE TORDER
  1607. SET TX_UPDATES = case
  1608. when cast( TX_UPDATES as varchar(max)) is not null then
  1609. cast( TX_UPDATES as varchar(max))
  1610. else ''
  1611. end + char(13) +
  1612. CONVERT(VARCHAR(10),GETDATE(),103) + ': ' +
  1613. 'User ' + @LAST_USER + ' inserted item: ' +
  1614. @ITEM_NUMBER + ' - ' +
  1615. @DESCRIPTION + ' - ' +
  1616. cast( @QUANTITY AS VARCHAR(100) ) + ' due to: ' +
  1617. CONVERT(VARCHAR(10),@DUE_DATE,103)
  1618. , IN_ADJUSTED = 1
  1619. WHERE NU_ORDER = @ORDER_NUMBER
  1620. ;
  1621.  
  1622. -- SET NOCOUNT ON added to prevent extra result sets from
  1623. -- interfering with SELECT statements.
  1624. SET NOCOUNT ON;
  1625.  
  1626. -- Insert statements for trigger here
  1627.  
  1628. END
  1629.  
  1630. GO
  1631.  
  1632.  
  1633. -- =============================================
  1634. -- Author: <Author,,Name>
  1635. -- Create date: <Create Date,,>
  1636. -- Description: <Description,,>
  1637. -- =============================================
  1638. CREATE TRIGGER [lush].[ORDERITEM_UPDATE]
  1639. ON [lush].[TORDER_ITEM]
  1640. FOR UPDATE
  1641. AS
  1642. DECLARE @ITEM_NUMBER VARCHAR(10)
  1643. DECLARE @DESCRIPTION VARCHAR(10)
  1644. DECLARE @OLD_QUANTITY NUMERIC(15,5)
  1645. DECLARE @NEW_QUANTITY NUMERIC(15,5)
  1646. DECLARE @OLD_DUEDATE DATETIME
  1647. DECLARE @NEW_DUEDATE DATETIME
  1648. DECLARE @ORDER_NUMBER INT
  1649. DECLARE @LAST_USER VARCHAR(10)
  1650. BEGIN
  1651.  
  1652. SELECT @ITEM_NUMBER = D.CD_ITEM
  1653. , @DESCRIPTION = I.DC_ITEM
  1654. , @OLD_QUANTITY = D.VL_QUANTITY
  1655. , @OLD_DUEDATE = D.DT_DELIVERY
  1656. , @NEW_QUANTITY = INS.VL_QUANTITY
  1657. , @NEW_DUEDATE = INS.DT_DELIVERY
  1658. , @ORDER_NUMBER = D.NU_ORDER
  1659. , @LAST_USER = U.NM_LOGIN
  1660. FROM DELETED D
  1661. , TITEM I
  1662. , TORDER O
  1663. , TUSER U
  1664. , INSERTED INS
  1665. WHERE I.CD_ITEM = D.CD_ITEM
  1666. AND O.NU_ORDER = D.NU_ORDER
  1667. AND U.CD_USER = O.CD_LASTUSER
  1668. AND INS.NU_ORDER = D.NU_ORDER
  1669. AND INS.NU_SEQUENCE = D.NU_SEQUENCE
  1670. ;
  1671.  
  1672. IF @OLD_QUANTITY <> @NEW_QUANTITY
  1673. BEGIN
  1674. UPDATE TORDER
  1675. SET TX_UPDATES = case
  1676. when cast( TX_UPDATES as varchar(max)) is not null then
  1677. cast( TX_UPDATES as varchar(max))
  1678. else ''
  1679. end + char(13) +
  1680. CONVERT(VARCHAR(10),GETDATE(),103) + ': ' +
  1681. 'User ' + @LAST_USER + ' updated item: ' +
  1682. @ITEM_NUMBER + ' - ' +
  1683. @DESCRIPTION + ' - ' + ' from quantity: ' +
  1684. cast( @OLD_QUANTITY AS VARCHAR(100) ) + ' to ' +
  1685. cast( @NEW_QUANTITY AS VARCHAR(100) )
  1686. WHERE NU_ORDER = @ORDER_NUMBER
  1687. ;
  1688.  
  1689. UPDATE TORDER
  1690. SET IN_ADJUSTED = 1
  1691. WHERE NU_ORDER = @ORDER_NUMBER
  1692. ;
  1693. END
  1694.  
  1695.  
  1696. IF @OLD_DUEDATE <> @NEW_DUEDATE
  1697. BEGIN
  1698. UPDATE TORDER
  1699. SET TX_UPDATES = case
  1700. when cast( TX_UPDATES as varchar(max)) is not null then cast( TX_UPDATES as varchar(max))
  1701. else ''
  1702. end + char(13) +
  1703. CONVERT(VARCHAR(10),GETDATE(),103) + ': ' +
  1704. 'User ' + @LAST_USER + ' updated item: ' +
  1705. @ITEM_NUMBER + ' - ' +
  1706. @DESCRIPTION + ' - ' + ' from due date: ' +
  1707. CONVERT(VARCHAR(10),@OLD_DUEDATE,103) + ' to ' +
  1708. CONVERT(VARCHAR(10),@NEW_DUEDATE,103)
  1709. WHERE NU_ORDER = @ORDER_NUMBER
  1710. ;
  1711. END
  1712.  
  1713.  
  1714. -- SET NOCOUNT ON added to prevent extra result sets from
  1715. -- interfering with SELECT statements.
  1716. SET NOCOUNT ON;
  1717.  
  1718. -- Insert statements for trigger here
  1719.  
  1720. END
  1721.  
  1722.  
  1723.  
  1724.  
  1725.  
  1726.  
  1727.  
  1728.  
  1729.  
  1730.  
  1731.  
  1732.  
  1733.  
  1734.  
  1735.  
  1736. INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 1, 'Order placed', 0, 1 );
  1737. INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 2, 'Order waiting for approval', 1, 1 );
  1738. INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 3, 'Order approved', 0, 1 );
  1739. INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 4, 'Order sent to QAD', 0, 1 );
  1740. INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 5, 'Order integrated to QAD', 0, 1 );
  1741. INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 6, 'Order picked', 0, 1 );
  1742. INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 7, 'Order sent to delivery', 0, 1 );
  1743. INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 8, 'Order delivered', 0, 1 );
  1744. INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 9, 'Order closed', 0, 1 );
  1745. INSERT INTO TORDER_STEP( CD_ORDERSTEP, DC_ORDERSTEP, IN_APPROVAL, IN_EMAILALERT ) VALUES ( 10, 'Order sent for review', 0, 1 );
  1746. INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'CX', 'CAIXA(S)' );
  1747. INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'EA', 'EACH' );
  1748. INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'GM', 'GRAMA(S)' );
  1749. INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'KG', 'QUILO(S)' );
  1750. INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'L', 'LITRO(S)' );
  1751. INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'MT', 'METRO(S)' );
  1752. INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'PC', 'PEÇA(S)' );
  1753. INSERT INTO TUM ( CD_UM, DC_UM ) VALUES ( 'UN', 'UNIDADE(S)' );
  1754. INSERT INTO TPROFILE_PERMISSION( CD_USERPROFILE, NM_FORM, NM_FORMNAME, IN_QUERY, IN_INSERT, IN_DELETE, IN_UPDATE, IN_TRANSFER, IN_PRINT )
  1755. VALUES ( 1, 'form_CadastroPerfilUsuario', 'User Profile', 1, 1, 1, 1, 1, 1 );
  1756. INSERT INTO TUSER_PROFILE( CD_USERPROFILE, DC_USERPROFILE, IN_EMAILALERT, IN_APPROVER )
  1757. VALUES ( 1, 'ADMINISTRATOR', 1, 1 );
  1758.  
  1759. INSERT INTO TUSER_PROFILE( CD_USERPROFILE, DC_USERPROFILE, IN_EMAILALERT, IN_APPROVER )
  1760. VALUES ( 2, 'INTERNAL CLIENT', 1, 0 );
  1761. INSERT INTO TUSER( CD_USER, NM_USER, NM_LOGIN, DC_PASSWORD, CD_CUSTOMER, CD_USERPROFILE, DC_EMAIL)
  1762. VALUES (1,'ADMINISTRATOR', 'ADMIN', 'ADMIN', NULL, 1, 'diego.meire@lush.com.br' );
  1763.  
  1764. INSERT INTO TUSER( CD_USER, NM_USER, NM_LOGIN, DC_PASSWORD, CD_CUSTOMER, CD_USERPROFILE, DC_EMAIL)
  1765. VALUES (2, 'DIEGO DA FONSECA', 'DMEIRE', 'DMEIRE', null, 1, 'diego.meire@lush.com.br' );
  1766.  
  1767. INSERT INTO TUSER( CD_USER, NM_USER, NM_LOGIN, DC_PASSWORD, CD_CUSTOMER, CD_USERPROFILE, DC_EMAIL)
  1768. VALUES (3, 'LOJA CONSOLAÇÃO', 'LOJA01', 'LOJA01', 1, 1, 'diego.meire@lush.com.br' );
  1769.  
  1770. INSERT INTO TUSER( CD_USER, NM_USER, NM_LOGIN, DC_PASSWORD, CD_CUSTOMER, CD_USERPROFILE, DC_EMAIL)
  1771. VALUES (4, 'E-COMMERCE', 'ECOMM', 'ECOMM', 2, 1, 'diego.meire@lush.com.br' );
  1772.  
  1773. INSERT INTO TUSER( CD_USER, NM_USER, NM_LOGIN, DC_PASSWORD, CD_CUSTOMER, CD_USERPROFILE, DC_EMAIL)
  1774. VALUES (5, 'RELAÇÕES PÚBLICAS', 'RP', 'RP', 3, 1, 'diego.meire@lush.com.br' );
  1775.  
  1776. INSERT INTO TSEQUENCE_CONTROL( NM_SEQUENCE, CD_NEXTSEQUENCE ) VALUES ( 'TUSER', 6 );
  1777. INSERT INTO TSEQUENCE_CONTROL( NM_SEQUENCE, CD_NEXTSEQUENCE ) VALUES ( 'TUSER_PROFILE', 3 );
  1778. INSERT INTO TSEQUENCE_CONTROL( NM_SEQUENCE, CD_NEXTSEQUENCE ) VALUES ( 'TCUSTOMER', 4 );
  1779. INSERT INTO TSEQUENCE_CONTROL( NM_SEQUENCE, CD_NEXTSEQUENCE ) VALUES ( 'TORDER_STEP', 9 );
  1780.  
  1781. INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
  1782. VALUES ( 1, 'SMTP SERVER', 'smtp.gmail.com', 'STRING' );
  1783.  
  1784. INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
  1785. VALUES ( 2, 'SMTP PORT', '587', 'STRING' );
  1786.  
  1787. INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
  1788. VALUES ( 3, 'E-MAIL ACCOUNT', 'diego.meire@lushbrazil.com', 'STRING' );
  1789.  
  1790. INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
  1791. VALUES ( 4, 'E-MAIL PASSWORD', '4569eaAC', 'PASSWORD' );
  1792.  
  1793. INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
  1794. VALUES ( 5, 'HOST QAD', 'qlsbldb1', 'STRING' );
  1795.  
  1796. INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
  1797. VALUES ( 6, 'USER QAD', 'lpearcy', 'STRING' );
  1798.  
  1799. INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
  1800. VALUES ( 7, 'USER PASSWORD', 'Pepper12345', 'PASSWORD' );
  1801.  
  1802. INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
  1803. VALUES ( 8, 'CIM OUTPUT DIRECTORY', 'CIM', 'STRING' );
  1804.  
  1805. INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
  1806. VALUES ( 9, 'CIM TEMP DIRECTORY', 'TEMP', 'STRING' );
  1807.  
  1808. INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
  1809. VALUES ( 10, 'SFTP UTILITY', 'psftp', 'STRING' );
  1810.  
  1811. INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
  1812. VALUES ( 11, 'CIM SEQUENCE FILE', '0', 'INTEGER' );
  1813.  
  1814. INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
  1815. VALUES ( 12, 'LAST VERSION', '1.0.0.0', 'STRING' );
  1816.  
  1817. INSERT INTO TCONFIGURATION( CD_CONFIGURATION, DC_CONFIGURATION, VL_CONFIGURATION, TP_CONFIGURATION )
  1818. VALUES ( 13, 'DOWNLOAD LOCATION', 'GOOGLE DRIVE', 'STRING' );
  1819.  
  1820. INSERT INTO TITEM_TYPE( CD_ITEMTYPE, DC_ITEMTYPE ) VALUES ('FINGOOD', 'PRODUTO ACABADO' );
  1821. DROP PROCEDURE [sp_ArchiveForecast]
  1822. -- =============================================
  1823. -- Author: Diego
  1824. -- Create date: 24/11/2014
  1825. -- Description: Stored Procedure to archive ALL
  1826. -- active Forecast and generate new
  1827. -- clear ones
  1828. -- =============================================
  1829. 
  1830. set ANSI_NULLS ON
  1831. set QUOTED_IDENTIFIER ON
  1832. GO
  1833. -- =============================================
  1834. -- Author: Diego
  1835. -- Create date: 24/11/2014
  1836. -- Description: Stored Procedure to archive ALL
  1837. -- active Forecast and generate new
  1838. -- clear ones
  1839. -- =============================================
  1840. CREATE PROCEDURE [sp_ArchiveForecast]
  1841. @CD_FORECAST int
  1842. AS
  1843. DECLARE @NEW_SEQUENCE INT,
  1844. @DC_STATUS VARCHAR(20)
  1845. BEGIN
  1846. -- SET NOCOUNT ON added to prevent extra result sets from
  1847. -- interfering with SELECT statements.
  1848. SET NOCOUNT ON;
  1849.  
  1850. SELECT @DC_STATUS = DC_STATUS
  1851. FROM TFORECAST
  1852. WHERE CD_FORECAST = @CD_FORECAST
  1853.  
  1854. IF @DC_STATUS IN ( 'ACTIVE', 'ARCHIVING' )
  1855. BEGIN
  1856. UPDATE TFORECAST
  1857. SET DC_STATUS = 'ARCHIVING'
  1858. WHERE DC_STATUS = 'ACTIVE'
  1859. AND CD_FORECAST = @CD_FORECAST
  1860.  
  1861. SELECT @NEW_SEQUENCE = CD_NEXTSEQUENCE + 1
  1862. FROM TSEQUENCE_CONTROL
  1863. WHERE NM_SEQUENCE = 'TFORECAST'
  1864.  
  1865. IF @NEW_SEQUENCE IS NULL
  1866. BEGIN
  1867. INSERT INTO TSEQUENCE_CONTROL( NM_SEQUENCE, CD_NEXTSEQUENCE ) VALUES ( 'TFORECAST', 1 )
  1868. SELECT @NEW_SEQUENCE = 1
  1869. END
  1870. ELSE
  1871. BEGIN
  1872. UPDATE TSEQUENCE_CONTROL
  1873. SET CD_NEXTSEQUENCE = @NEW_SEQUENCE
  1874. WHERE NM_SEQUENCE = 'TFORECAST'
  1875. END
  1876.  
  1877. DELETE FROM TFORECAST_DETAIL WHERE CD_FORECAST = @NEW_SEQUENCE
  1878. DELETE FROM TFORECAST WHERE CD_FORECAST = @NEW_SEQUENCE
  1879.  
  1880. INSERT INTO TFORECAST (CD_FORECAST, CD_USER, NU_YEAR, DT_CREATION, DC_STATUS )
  1881. SELECT @NEW_SEQUENCE
  1882. , CD_USER
  1883. , NU_YEAR
  1884. , CURRENT_TIMESTAMP
  1885. , 'ACTIVE'
  1886. FROM TFORECAST
  1887. WHERE CD_FORECAST = @CD_FORECAST
  1888.  
  1889.  
  1890. INSERT INTO TFORECAST_DETAIL (CD_FORECAST,
  1891. CD_ITEM,
  1892. VL_JANUARY,
  1893. VL_FEBRUARY,
  1894. VL_MARCH,
  1895. VL_APRIL,
  1896. VL_MAY,
  1897. VL_JUNE,
  1898. VL_JULY,
  1899. VL_AUGUST,
  1900. VL_SEPTEMBER,
  1901. VL_OCTOBER,
  1902. VL_NOVEMBER,
  1903. VL_DECEMBER )
  1904. SELECT @NEW_SEQUENCE
  1905. , CD_ITEM
  1906. , VL_JANUARY
  1907. , VL_FEBRUARY
  1908. , VL_MARCH
  1909. , VL_APRIL
  1910. , VL_MAY
  1911. , VL_JUNE
  1912. , VL_JULY
  1913. , VL_AUGUST
  1914. , VL_SEPTEMBER
  1915. , VL_OCTOBER
  1916. , VL_NOVEMBER
  1917. , VL_DECEMBER
  1918. FROM TFORECAST_DETAIL
  1919. WHERE CD_FORECAST = @CD_FORECAST
  1920. UNION
  1921. SELECT @NEW_SEQUENCE
  1922. , CD_ITEM
  1923. , 0
  1924. , 0
  1925. , 0
  1926. , 0
  1927. , 0
  1928. , 0
  1929. , 0
  1930. , 0
  1931. , 0
  1932. , 0
  1933. , 0
  1934. , 0
  1935. FROM TITEM I
  1936. WHERE ( I.CD_ITEMTYPE = 'FINGOOD' )
  1937. and ( LEN( substring( CD_ITEM, 6, 2 ) ) = 0 OR substring( CD_ITEM, 6, 2 ) = 'BR' )
  1938. AND I.CD_ITEM NOT IN ( SELECT CD_ITEM
  1939. FROM TFORECAST_DETAIL
  1940. WHERE CD_FORECAST = @CD_FORECAST
  1941. )
  1942.  
  1943. UPDATE TFORECAST
  1944. SET DC_STATUS = 'CLOSED',
  1945. DT_CLOSING = CURRENT_TIMESTAMP
  1946. WHERE DC_STATUS = 'ARCHIVING'
  1947. AND CD_FORECAST = @CD_FORECAST
  1948. END
  1949.  
  1950. END
  1951. 
  1952. GO
  1953.  
  1954. INSERT INTO TCUSTOMER( CD_CUSTOMER, NM_CUSTOMER, CD_CURRENCY ) VALUES ( 1, 'LOJA 01', 'BRL' );
  1955. INSERT INTO TCUSTOMER( CD_CUSTOMER, NM_CUSTOMER, CD_CURRENCY ) VALUES ( 2, 'E-COMMERCE', 'BRL' );
  1956. INSERT INTO TCUSTOMER( CD_CUSTOMER, NM_CUSTOMER, CD_CURRENCY ) VALUES ( 3, 'RP', 'BRL' );
  1957. INSERT INTO TEVENT( CD_EVENT, DC_EVENT ) VALUES ( 1, 'Logged in' );
  1958. INSERT INTO TEVENT( CD_EVENT, DC_EVENT ) VALUES ( 2, 'Logged off' );
  1959. INSERT INTO TEVENT( CD_EVENT, DC_EVENT ) VALUES ( 3, 'Closed the application' );
  1960. INSERT INTO TINVOICE_STEP( CD_INVOICESTEP, DC_INVOICESTEP ) VALUES ( 1, 'Invoice placed' );
  1961. INSERT INTO TINVOICE_STEP( CD_INVOICESTEP, DC_INVOICESTEP ) VALUES ( 2, 'Invoice sent to QAD' );
  1962. INSERT INTO TINVOICE_STEP( CD_INVOICESTEP, DC_INVOICESTEP ) VALUES ( 3, 'Invoice successfully integrated to Sefaz' );
  1963.  
  1964.  
  1965. -- Create Alternate keys section
  1966.  
  1967.  
  1968. -- Create Indexes section
  1969.  
  1970.  
  1971.  
  1972. -- Create Foreign keys section
  1973.  
  1974. Alter table "TORDER_ITEM" add Constraint "FK_ORDERITEM_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
  1975. /
  1976.  
  1977. Alter table "TITEM_UM" add Constraint "FK_UM_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
  1978. /
  1979.  
  1980. Alter table "TFORECAST_DETAIL" add Constraint "FK_FORECASTDETAIL_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
  1981. /
  1982.  
  1983. Alter table "TITEM_PRICE" add Constraint "FK_PRICELIST_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
  1984. /
  1985.  
  1986. Alter table "TINVOICE_ITEM" add Constraint "FK_INVOICEITEM_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
  1987. /
  1988.  
  1989. Alter table "TITEM_SUPPLIER" add Constraint "FK_ITEMSUPPLIER_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
  1990. /
  1991.  
  1992. Alter table "TMRP_DETAIL" add Constraint "FK_MRPDETAIL_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
  1993. /
  1994.  
  1995. Alter table "TITEM_STRUCTURE" add Constraint "FK_STRUCTURE_PARENTITEM" foreign key ("CD_PARENTITEM") references "TITEM" ("CD_ITEM")
  1996. /
  1997.  
  1998. Alter table "TITEM_STRUCTURE" add Constraint "FK_ITEM_COMPONENTITEM" foreign key ("CD_COMPONENTITEM") references "TITEM" ("CD_ITEM")
  1999. /
  2000.  
  2001. Alter table "TITEM_STOCK" add Constraint "PK_ITEMSTOCK_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM") on delete cascade
  2002. /
  2003.  
  2004. Alter table "TPURCHASE_ORDER_ITEM" add Constraint "FK_POITEM_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
  2005. /
  2006.  
  2007. Alter table "TITEM_CUSTOMER" add Constraint "FK_ITEMCUSTOMER_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
  2008. /
  2009.  
  2010. Alter table "TDRAWBACK_ITEM" add Constraint "FK_DRAWBACKITEM_ITEM" foreign key ("CD_ITEM") references "TITEM" ("CD_ITEM")
  2011. /
  2012.  
  2013. Alter table "TORDER_ITEM" add Constraint "FK_ORDERITEM_ORDER" foreign key ("NU_ORDER") references "TORDER" ("NU_ORDER") on delete cascade
  2014. /
  2015.  
  2016. Alter table "TORDER_STATUS" add Constraint "FK_ORDERSTATUS_ORDER" foreign key ("NU_ORDER") references "TORDER" ("NU_ORDER") on delete cascade
  2017. /
  2018.  
  2019. Alter table "TORDER_APPROVAL" add Constraint "FK_ORDERAPPROVAL_ORDER" foreign key ("NU_ORDER") references "TORDER" ("NU_ORDER") on delete cascade
  2020. /
  2021.  
  2022. 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
  2023. /
  2024.  
  2025. 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
  2026. /
  2027.  
  2028. Alter table "TITEM" add Constraint "FK_ITEM_ITEMSTATUS" foreign key ("CD_ITEMSTATUS") references "TITEM_STATUS" ("CD_ITEMSTATUS")
  2029. /
  2030.  
  2031. Alter table "TORDER_STATUS" add Constraint "FK_ORDERSTATUS_ORDERSTEP" foreign key ("CD_ORDERSTEP") references "TORDER_STEP" ("CD_ORDERSTEP")
  2032. /
  2033.  
  2034. Alter table "TITEM_UM" add Constraint "FK_ITEMUM_UMSOURCE" foreign key ("CD_SOURCEUM") references "TUM" ("CD_UM")
  2035. /
  2036.  
  2037. Alter table "TITEM_UM" add Constraint "FK_ITEMUM_UMTARGET" foreign key ("CD_TARGETUM") references "TUM" ("CD_UM")
  2038. /
  2039.  
  2040. Alter table "TITEM" add Constraint "FK_ITEM_UM" foreign key ("CD_UM") references "TUM" ("CD_UM")
  2041. /
  2042.  
  2043. Alter table "TORDER_ITEM" add Constraint "FK_ORDERITEM_UMITEM" foreign key ("CD_ITEMUM") references "TUM" ("CD_UM")
  2044. /
  2045.  
  2046. Alter table "TORDER_ITEM" add Constraint "FK_ORDERITEM_UMORDER" foreign key ("CD_ORDERUM") references "TUM" ("CD_UM")
  2047. /
  2048.  
  2049. Alter table "TITEM_PRICE" add Constraint "FK_ITEMPRICE_UOM" foreign key ("CD_UM") references "TUM" ("CD_UM")
  2050. /
  2051.  
  2052. Alter table "TITEM_SUPPLIER" add Constraint "FK_ITEMSUPPLIER_UM" foreign key ("CD_UM") references "TUM" ("CD_UM")
  2053. /
  2054.  
  2055. Alter table "TPURCHASE_ORDER_ITEM" add Constraint "FK_POITEM_UM" foreign key ("CD_ORDERUM") references "TUM" ("CD_UM")
  2056. /
  2057.  
  2058. 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
  2059. /
  2060.  
  2061. Alter table "TUSER" add Constraint "FK_USER_USERPROFILE" foreign key ("CD_USERPROFILE") references "TUSER_PROFILE" ("CD_USERPROFILE")
  2062. /
  2063.  
  2064. Alter table "TPROFILE_PERMISSION" add Constraint "FK_PROFILEPERMISSION_PROFILE" foreign key ("CD_USERPROFILE") references "TUSER_PROFILE" ("CD_USERPROFILE")
  2065. /
  2066.  
  2067. Alter table "TORDER" add Constraint "FK_ORDER_USUARIO" foreign key ("CD_USER") references "TUSER" ("CD_USER")
  2068. /
  2069.  
  2070. Alter table "TORDER_STATUS" add Constraint "FK_ORDERSATUS_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
  2071. /
  2072.  
  2073. Alter table "TDATALOAD" add Constraint "FK_DATALOAD_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
  2074. /
  2075.  
  2076. Alter table "TFORECAST" add Constraint "FK_FORECAST_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
  2077. /
  2078.  
  2079. Alter table "TORDER_APPROVAL" add Constraint "FK_ORDERAPPROVAL_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
  2080. /
  2081.  
  2082. Alter table "TUSER_LOG" add Constraint "FK_USERLOG_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER") on delete cascade
  2083. /
  2084.  
  2085. Alter table "TORDER_ITEM_COMMENT" add Constraint "FK_ORDERITEMCOMM_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER") on delete cascade
  2086. /
  2087.  
  2088. Alter table "TINVOICE" add Constraint "FK_INVOICE_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
  2089. /
  2090.  
  2091. Alter table "TINVOICE_STATUS" add Constraint "FK_INVOICESTATUS_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
  2092. /
  2093.  
  2094. Alter table "TORDER" add Constraint "FK_ORDER_LASTUSER" foreign key ("CD_LASTUSER") references "TUSER" ("CD_USER") on delete cascade
  2095. /
  2096.  
  2097. Alter table "TTICKET" add Constraint "FK_TICKET_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
  2098. /
  2099.  
  2100. Alter table "TPURCHASE_ORDER" add Constraint "FK_PURCHASEORDER_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
  2101. /
  2102.  
  2103. Alter table "TDRAWBACK" add Constraint "FK_DRAWBACK_USER" foreign key ("CD_USER") references "TUSER" ("CD_USER")
  2104. /
  2105.  
  2106. Alter table "TCOMPONENT_PERMISSION" add Constraint "FK_COMPONENTEPERMISSAO_COMPONE" foreign key ("CD_COMPONENT") references "TCOMPONENT" ("CD_COMPONENT")
  2107. /
  2108.  
  2109. Alter table "TITEM" add Constraint "FK_ITEM_PRODUCTLINE" foreign key ("CD_PRODUCTLINE") references "TPRODUCT_LINE" ("CD_PRODUCTLINE")
  2110. /
  2111.  
  2112. Alter table "TITEM" add Constraint "FK_ITEM_ITEMTYPE" foreign key ("CD_ITEMTYPE") references "TITEM_TYPE" ("CD_ITEMTYPE")
  2113. /
  2114.  
  2115. Alter table "TFORECAST_DETAIL" add Constraint "FK_FORECASTDETAIL_FORECAST" foreign key ("CD_FORECAST") references "TFORECAST" ("CD_FORECAST")
  2116. /
  2117.  
  2118. Alter table "TUSER" add Constraint "FK_USER_CUSTOMER" foreign key ("CD_CUSTOMER") references "TCUSTOMER" ("CD_CUSTOMER")
  2119. /
  2120.  
  2121. Alter table "TITEM_CUSTOMER" add Constraint "FK_ITEMCUSTOMER_CUSTOMER" foreign key ("CD_CUSTOMER") references "TCUSTOMER" ("CD_CUSTOMER")
  2122. /
  2123.  
  2124. Alter table "TUSER_LOG" add Constraint "FK_USERLOG_EVENT" foreign key ("CD_EVENT") references "TEVENT" ("CD_EVENT") on delete cascade
  2125. /
  2126.  
  2127. 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
  2128. /
  2129.  
  2130. Alter table "TINVOICE" add Constraint "FK_INVOICE_SUPPLIER" foreign key ("CD_SUPPLIER") references "TSUPPLIER" ("CD_SUPPLIER")
  2131. /
  2132.  
  2133. Alter table "TITEM_SUPPLIER" add Constraint "FK_ITEMSUPPLIER_SUPPLIER" foreign key ("CD_SUPPLIER") references "TSUPPLIER" ("CD_SUPPLIER")
  2134. /
  2135.  
  2136. Alter table "TPURCHASE_ORDER" add Constraint "PK_PO_SUPPLIER" foreign key ("CD_SUPPLIER") references "TSUPPLIER" ("CD_SUPPLIER") on delete cascade
  2137. /
  2138.  
  2139. Alter table "TINVOICE_ITEM" add Constraint "FK_INVOICEITEM_INVOICE" foreign key ("CD_INVOICE") references "TINVOICE" ("CD_INVOICE") on delete cascade
  2140. /
  2141.  
  2142. Alter table "TINVOICE_STATUS" add Constraint "FK_INVOICESTATUS_INVOICE" foreign key ("CD_INVOICE") references "TINVOICE" ("CD_INVOICE") on delete cascade
  2143. /
  2144.  
  2145. Alter table "TINVOICE" add Constraint "FK_INVOICE_CREDITTERMS" foreign key ("CD_CREDITTERMS") references "TCREDIT_TERMS" ("CD_CREDITTERMS")
  2146. /
  2147.  
  2148. Alter table "TMRP_DETAIL" add Constraint "FK_MRPDETAIL_MRP" foreign key ("CD_MRP") references "TMRP" ("CD_MRP") on delete cascade
  2149. /
  2150.  
  2151. Alter table "TEMAIL_ATTACH" add Constraint "FK_ATTACHMENTS_EMAIL" foreign key ("CD_EMAIL") references "TEMAIL" ("CD_EMAIL")
  2152. /
  2153.  
  2154. Alter table "TINVOICE_STATUS" add Constraint "FK_INVOICESTATUS_STEP" foreign key ("CD_INVOICESTEP") references "TINVOICE_STEP" ("CD_INVOICESTEP")
  2155. /
  2156.  
  2157. Alter table "TNCM_TAXES" add Constraint "FK_NCMFISCALENV_NCM" foreign key ("DC_NCM") references "TNCM" ("DC_NCM") on delete cascade
  2158. /
  2159.  
  2160. Alter table "TSNAPSHOT_ITEM" add Constraint "FK_SNAPSHOTITEM_SNAPSHOT" foreign key ("CD_SNAPSHOT") references "TSNAPSHOT" ("CD_SNAPSHOT") on delete cascade
  2161. /
  2162.  
  2163. 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
  2164. /
  2165.  
  2166. Alter table "TSNAPSHOT_STRUCTURE" add Constraint "FK_COMPONENTITEM_SNAPSHOT" foreign key ("CD_COMPONENTITEM","CD_COMPONENTSNAPSHOT") references "TSNAPSHOT_ITEM" ("CD_ITEM","CD_SNAPSHOT")
  2167. /
  2168.  
  2169. Alter table "TITEM_STOCK_CHECK" add Constraint "FK_ITEMSTOCKCHECK_STOCKCHECK" foreign key ("CD_STOCKCHECK") references "TSTOCK_CHECK" ("CD_STOCKCHECK") on delete cascade
  2170. /
  2171.  
  2172. Alter table "TUSER" add Constraint "FK_USER_QUEUE" foreign key ("CD_QUEUE") references "TQUEUE" ("CD_QUEUE")
  2173. /
  2174.  
  2175. Alter table "TPURCHASE_ORDER_ITEM" add Constraint "PK_PURCHASEORDERITEM_PO" foreign key ("NU_ORDER") references "TPURCHASE_ORDER" ("NU_ORDER") on delete cascade
  2176. /
  2177.  
  2178. Alter table "TPO_STATUS" add Constraint "FK_POSTATUS_PO" foreign key ("NU_ORDER") references "TPURCHASE_ORDER" ("NU_ORDER") on delete cascade
  2179. /
  2180.  
  2181. 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
  2182. /
  2183.  
  2184. Alter table "TPO_ITEM_STATUS" add Constraint "FK_POITEMSTATUS_POITEMSTEP" foreign key ("CD_POITEMSTEP") references "TPO_ITEM_STEP" ("CD_POITEMSTEP") on delete cascade
  2185. /
  2186.  
  2187. Alter table "TPURCHASE_ORDER_ITEM" add Constraint "FK_POITEM_POITEMSTEP" foreign key ("CD_STATUS") references "TPO_ITEM_STEP" ("CD_POITEMSTEP")
  2188. /
  2189.  
  2190. Alter table "TPO_STATUS" add Constraint "FK_POSTATUS_POSTEP" foreign key ("CD_POSTEP") references "TPO_STEP" ("CD_POSTEP") on delete cascade
  2191. /
  2192.  
  2193. Alter table "TPURCHASE_ORDER" add Constraint "FK_PURCHASEORDER_POSTEP" foreign key ("CD_STATUS") references "TPO_STEP" ("CD_POSTEP")
  2194. /
  2195.  
  2196. Alter table "TDRAWBACK_ITEM" add Constraint "FK_DRAWBACKITEM_DRAWBACK" foreign key ("CD_DRAWBACK") references "TDRAWBACK" ("CD_DRAWBACK") on delete cascade
  2197. /
  2198.  
  2199. 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
  2200. /
  2201.  
  2202.  
  2203. -- Create Object Tables section
  2204.  
  2205.  
  2206.  
  2207. -- Create XMLType Tables section
  2208.  
  2209.  
  2210.  
  2211. -- Create Procedures section
  2212.  
  2213.  
  2214.  
  2215. -- Create Functions section
  2216.  
  2217.  
  2218.  
  2219. -- Create Views section
  2220.  
  2221.  
  2222.  
  2223. -- Create Sequences section
  2224.  
  2225.  
  2226.  
  2227.  
  2228. -- Create Triggers from referential integrity section
  2229.  
  2230. -- Update trigger for "TITEM"
  2231. Create Trigger "tu_TITEM"
  2232. after update of "CD_ITEM","CD_ITEMTYPE","CD_PRODUCTLINE","CD_UM","CD_ITEMSTATUS" on "TITEM"
  2233. referencing new as new_upd old as old_upd
  2234. for each row
  2235. declare numrows integer;
  2236. begin
  2237. -- Cascade child "TINVOICE_ITEM" update when parent "TITEM" changed
  2238. if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM") then
  2239. begin
  2240. update "TINVOICE_ITEM"
  2241. set "CD_ITEM" = :new_upd."CD_ITEM"
  2242. where "TINVOICE_ITEM"."CD_ITEM" = :old_upd."CD_ITEM" ;
  2243. end;
  2244. end if;
  2245. -- Cascade child "TITEM_SUPPLIER" update when parent "TITEM" changed
  2246. if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM") then
  2247. begin
  2248. update "TITEM_SUPPLIER"
  2249. set "CD_ITEM" = :new_upd."CD_ITEM"
  2250. where "TITEM_SUPPLIER"."CD_ITEM" = :old_upd."CD_ITEM" ;
  2251. end;
  2252. end if;
  2253. -- Cascade child "TMRP_DETAIL" update when parent "TITEM" changed
  2254. if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM") then
  2255. begin
  2256. update "TMRP_DETAIL"
  2257. set "CD_ITEM" = :new_upd."CD_ITEM"
  2258. where "TMRP_DETAIL"."CD_ITEM" = :old_upd."CD_ITEM" ;
  2259. end;
  2260. end if;
  2261. -- Cascade child "TITEM_STRUCTURE" update when parent "TITEM" changed
  2262. if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM") then
  2263. begin
  2264. update "TITEM_STRUCTURE"
  2265. set "CD_PARENTITEM" = :new_upd."CD_ITEM"
  2266. where "TITEM_STRUCTURE"."CD_PARENTITEM" = :old_upd."CD_ITEM" ;
  2267. end;
  2268. end if;
  2269. -- Cascade child "TPURCHASE_ORDER_ITEM" update when parent "TITEM" changed
  2270. if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM") then
  2271. begin
  2272. update "TPURCHASE_ORDER_ITEM"
  2273. set "CD_ITEM" = :new_upd."CD_ITEM"
  2274. where "TPURCHASE_ORDER_ITEM"."CD_ITEM" = :old_upd."CD_ITEM" ;
  2275. end;
  2276. end if;
  2277. -- Cascade child "TDRAWBACK_ITEM" update when parent "TITEM" changed
  2278. if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM") then
  2279. begin
  2280. update "TDRAWBACK_ITEM"
  2281. set "CD_ITEM" = :new_upd."CD_ITEM"
  2282. where "TDRAWBACK_ITEM"."CD_ITEM" = :old_upd."CD_ITEM" ;
  2283. end;
  2284. end if;
  2285.  
  2286.  
  2287. end;
  2288. /
  2289. -- Update trigger for "TORDER_ITEM"
  2290. Create Trigger "tu_TORDER_ITEM"
  2291. after update of "NU_ORDER","NU_SEQUENCE","CD_ITEM","CD_ITEMUM","CD_ORDERUM" on "TORDER_ITEM"
  2292. referencing new as new_upd old as old_upd
  2293. for each row
  2294. declare numrows integer;
  2295. begin
  2296. -- Cascade child "TORDER_ITEM_COMMENT" update when parent "TORDER_ITEM" changed
  2297. if (:old_upd."NU_ORDER" != :new_upd."NU_ORDER" or
  2298. :old_upd."NU_SEQUENCE" != :new_upd."NU_SEQUENCE") then
  2299. begin
  2300. update "TORDER_ITEM_COMMENT"
  2301. set "NU_ORDER" = :new_upd."NU_ORDER",
  2302. "NU_SEQUENCE" = :new_upd."NU_SEQUENCE"
  2303. where "TORDER_ITEM_COMMENT"."NU_ORDER" = :old_upd."NU_ORDER" and
  2304. "TORDER_ITEM_COMMENT"."NU_SEQUENCE" = :old_upd."NU_SEQUENCE" ;
  2305. end;
  2306. end if;
  2307. -- Cascade child "TORDER_ITEM_DELIVERY" update when parent "TORDER_ITEM" changed
  2308. if (:old_upd."NU_ORDER" != :new_upd."NU_ORDER" or
  2309. :old_upd."NU_SEQUENCE" != :new_upd."NU_SEQUENCE") then
  2310. begin
  2311. update "TORDER_ITEM_DELIVERY"
  2312. set "NU_ORDER" = :new_upd."NU_ORDER",
  2313. "NU_SEQUENCE" = :new_upd."NU_SEQUENCE"
  2314. where "TORDER_ITEM_DELIVERY"."NU_ORDER" = :old_upd."NU_ORDER" and
  2315. "TORDER_ITEM_DELIVERY"."NU_SEQUENCE" = :old_upd."NU_SEQUENCE" ;
  2316. end;
  2317. end if;
  2318.  
  2319.  
  2320. end;
  2321. /
  2322. -- Update trigger for "TUM"
  2323. Create Trigger "tu_TUM"
  2324. after update of "CD_UM" on "TUM"
  2325. referencing new as new_upd old as old_upd
  2326. for each row
  2327. declare numrows integer;
  2328. begin
  2329. -- Cascade child "TITEM_SUPPLIER" update when parent "TUM" changed
  2330. if (:old_upd."CD_UM" != :new_upd."CD_UM") then
  2331. begin
  2332. update "TITEM_SUPPLIER"
  2333. set "CD_UM" = :new_upd."CD_UM"
  2334. where "TITEM_SUPPLIER"."CD_UM" = :old_upd."CD_UM" ;
  2335. end;
  2336. end if;
  2337. -- Cascade child "TPURCHASE_ORDER_ITEM" update when parent "TUM" changed
  2338. if (:old_upd."CD_UM" != :new_upd."CD_UM") then
  2339. begin
  2340. update "TPURCHASE_ORDER_ITEM"
  2341. set "CD_ORDERUM" = :new_upd."CD_UM"
  2342. where "TPURCHASE_ORDER_ITEM"."CD_ORDERUM" = :old_upd."CD_UM" ;
  2343. end;
  2344. end if;
  2345.  
  2346.  
  2347. end;
  2348. /
  2349. -- Update trigger for "TPROFILE_PERMISSION"
  2350. Create Trigger "tu_TPROFILE_PERMISSION"
  2351. after update of "CD_USERPROFILE","NM_FORM" on "TPROFILE_PERMISSION"
  2352. referencing new as new_upd old as old_upd
  2353. for each row
  2354. declare numrows integer;
  2355. begin
  2356. -- Cascade child "TCOMPONENT_PERMISSION" update when parent "TPROFILE_PERMISSION" changed
  2357. if (:old_upd."CD_USERPROFILE" != :new_upd."CD_USERPROFILE" or
  2358. :old_upd."NM_FORM" != :new_upd."NM_FORM") then
  2359. begin
  2360. update "TCOMPONENT_PERMISSION"
  2361. set "CD_USERPROFILE" = :new_upd."CD_USERPROFILE",
  2362. "NM_FORM" = :new_upd."NM_FORM"
  2363. where "TCOMPONENT_PERMISSION"."CD_USERPROFILE" = :old_upd."CD_USERPROFILE" and
  2364. "TCOMPONENT_PERMISSION"."NM_FORM" = :old_upd."NM_FORM" ;
  2365. end;
  2366. end if;
  2367.  
  2368.  
  2369. end;
  2370. /
  2371. -- Update trigger for "TUSER_PROFILE"
  2372. Create Trigger "tu_TUSER_PROFILE"
  2373. after update of "CD_USERPROFILE" on "TUSER_PROFILE"
  2374. referencing new as new_upd old as old_upd
  2375. for each row
  2376. declare numrows integer;
  2377. begin
  2378. -- Cascade child "TUSER" update when parent "TUSER_PROFILE" changed
  2379. if (:old_upd."CD_USERPROFILE" != :new_upd."CD_USERPROFILE") then
  2380. begin
  2381. update "TUSER"
  2382. set "CD_USERPROFILE" = :new_upd."CD_USERPROFILE"
  2383. where "TUSER"."CD_USERPROFILE" = :old_upd."CD_USERPROFILE" ;
  2384. end;
  2385. end if;
  2386.  
  2387.  
  2388. end;
  2389. /
  2390. -- Update trigger for "TUSER"
  2391. Create Trigger "tu_TUSER"
  2392. after update of "CD_USER","CD_USERPROFILE","CD_CUSTOMER","CD_QUEUE" on "TUSER"
  2393. referencing new as new_upd old as old_upd
  2394. for each row
  2395. declare numrows integer;
  2396. begin
  2397. -- Cascade child "TUSER_LOG" update when parent "TUSER" changed
  2398. if (:old_upd."CD_USER" != :new_upd."CD_USER") then
  2399. begin
  2400. update "TUSER_LOG"
  2401. set "CD_USER" = :new_upd."CD_USER"
  2402. where "TUSER_LOG"."CD_USER" = :old_upd."CD_USER" ;
  2403. end;
  2404. end if;
  2405. -- Cascade child "TORDER_ITEM_COMMENT" update when parent "TUSER" changed
  2406. if (:old_upd."CD_USER" != :new_upd."CD_USER") then
  2407. begin
  2408. update "TORDER_ITEM_COMMENT"
  2409. set "CD_USER" = :new_upd."CD_USER"
  2410. where "TORDER_ITEM_COMMENT"."CD_USER" = :old_upd."CD_USER" ;
  2411. end;
  2412. end if;
  2413. -- Cascade child "TINVOICE" update when parent "TUSER" changed
  2414. if (:old_upd."CD_USER" != :new_upd."CD_USER") then
  2415. begin
  2416. update "TINVOICE"
  2417. set "CD_USER" = :new_upd."CD_USER"
  2418. where "TINVOICE"."CD_USER" = :old_upd."CD_USER" ;
  2419. end;
  2420. end if;
  2421. -- Cascade child "TORDER" update when parent "TUSER" changed
  2422. if (:old_upd."CD_USER" != :new_upd."CD_USER") then
  2423. begin
  2424. update "TORDER"
  2425. set "CD_LASTUSER" = :new_upd."CD_USER"
  2426. where "TORDER"."CD_LASTUSER" = :old_upd."CD_USER" ;
  2427. end;
  2428. end if;
  2429. -- Cascade child "TPURCHASE_ORDER" update when parent "TUSER" changed
  2430. if (:old_upd."CD_USER" != :new_upd."CD_USER") then
  2431. begin
  2432. update "TPURCHASE_ORDER"
  2433. set "CD_USER" = :new_upd."CD_USER"
  2434. where "TPURCHASE_ORDER"."CD_USER" = :old_upd."CD_USER" ;
  2435. end;
  2436. end if;
  2437. -- Cascade child "TDRAWBACK" update when parent "TUSER" changed
  2438. if (:old_upd."CD_USER" != :new_upd."CD_USER") then
  2439. begin
  2440. update "TDRAWBACK"
  2441. set "CD_USER" = :new_upd."CD_USER"
  2442. where "TDRAWBACK"."CD_USER" = :old_upd."CD_USER" ;
  2443. end;
  2444. end if;
  2445.  
  2446.  
  2447. end;
  2448. /
  2449. -- Update trigger for "TCOMPONENT"
  2450. Create Trigger "tu_TCOMPONENT"
  2451. after update of "CD_COMPONENT" on "TCOMPONENT"
  2452. referencing new as new_upd old as old_upd
  2453. for each row
  2454. declare numrows integer;
  2455. begin
  2456. -- Cascade child "TCOMPONENT_PERMISSION" update when parent "TCOMPONENT" changed
  2457. if (:old_upd."CD_COMPONENT" != :new_upd."CD_COMPONENT") then
  2458. begin
  2459. update "TCOMPONENT_PERMISSION"
  2460. set "CD_COMPONENT" = :new_upd."CD_COMPONENT"
  2461. where "TCOMPONENT_PERMISSION"."CD_COMPONENT" = :old_upd."CD_COMPONENT" ;
  2462. end;
  2463. end if;
  2464.  
  2465.  
  2466. end;
  2467. /
  2468. -- Update trigger for "TEVENT"
  2469. Create Trigger "tu_TEVENT"
  2470. after update of "CD_EVENT" on "TEVENT"
  2471. referencing new as new_upd old as old_upd
  2472. for each row
  2473. declare numrows integer;
  2474. begin
  2475. -- Cascade child "TUSER_LOG" update when parent "TEVENT" changed
  2476. if (:old_upd."CD_EVENT" != :new_upd."CD_EVENT") then
  2477. begin
  2478. update "TUSER_LOG"
  2479. set "CD_EVENT" = :new_upd."CD_EVENT"
  2480. where "TUSER_LOG"."CD_EVENT" = :old_upd."CD_EVENT" ;
  2481. end;
  2482. end if;
  2483.  
  2484.  
  2485. end;
  2486. /
  2487. -- Update trigger for "TTAX_ENVIRONMENT"
  2488. Create Trigger "tu_TTAX_ENVIRONMENT"
  2489. after update of "DC_ENVIRONMENT","DC_TAXTYPE" on "TTAX_ENVIRONMENT"
  2490. referencing new as new_upd old as old_upd
  2491. for each row
  2492. declare numrows integer;
  2493. begin
  2494. -- Cascade child "TNCM_TAXES" update when parent "TTAX_ENVIRONMENT" changed
  2495. if (:old_upd."DC_ENVIRONMENT" != :new_upd."DC_ENVIRONMENT" or
  2496. :old_upd."DC_TAXTYPE" != :new_upd."DC_TAXTYPE") then
  2497. begin
  2498. update "TNCM_TAXES"
  2499. set "DC_ENVIRONMENT" = :new_upd."DC_ENVIRONMENT",
  2500. "DC_TAXTYPE" = :new_upd."DC_TAXTYPE"
  2501. where "TNCM_TAXES"."DC_ENVIRONMENT" = :old_upd."DC_ENVIRONMENT" and
  2502. "TNCM_TAXES"."DC_TAXTYPE" = :old_upd."DC_TAXTYPE" ;
  2503. end;
  2504. end if;
  2505.  
  2506.  
  2507. end;
  2508. /
  2509. -- Update trigger for "TSUPPLIER"
  2510. Create Trigger "tu_TSUPPLIER"
  2511. after update of "CD_SUPPLIER" on "TSUPPLIER"
  2512. referencing new as new_upd old as old_upd
  2513. for each row
  2514. declare numrows integer;
  2515. begin
  2516. -- Cascade child "TINVOICE" update when parent "TSUPPLIER" changed
  2517. if (:old_upd."CD_SUPPLIER" != :new_upd."CD_SUPPLIER") then
  2518. begin
  2519. update "TINVOICE"
  2520. set "CD_SUPPLIER" = :new_upd."CD_SUPPLIER"
  2521. where "TINVOICE"."CD_SUPPLIER" = :old_upd."CD_SUPPLIER" ;
  2522. end;
  2523. end if;
  2524. -- Cascade child "TITEM_SUPPLIER" update when parent "TSUPPLIER" changed
  2525. if (:old_upd."CD_SUPPLIER" != :new_upd."CD_SUPPLIER") then
  2526. begin
  2527. update "TITEM_SUPPLIER"
  2528. set "CD_SUPPLIER" = :new_upd."CD_SUPPLIER"
  2529. where "TITEM_SUPPLIER"."CD_SUPPLIER" = :old_upd."CD_SUPPLIER" ;
  2530. end;
  2531. end if;
  2532. -- Cascade child "TPURCHASE_ORDER" update when parent "TSUPPLIER" changed
  2533. if (:old_upd."CD_SUPPLIER" != :new_upd."CD_SUPPLIER") then
  2534. begin
  2535. update "TPURCHASE_ORDER"
  2536. set "CD_SUPPLIER" = :new_upd."CD_SUPPLIER"
  2537. where "TPURCHASE_ORDER"."CD_SUPPLIER" = :old_upd."CD_SUPPLIER" ;
  2538. end;
  2539. end if;
  2540.  
  2541.  
  2542. end;
  2543. /
  2544. -- Update trigger for "TINVOICE"
  2545. Create Trigger "tu_TINVOICE"
  2546. after update of "CD_INVOICE","CD_CREDITTERMS","CD_USER","CD_SUPPLIER" on "TINVOICE"
  2547. referencing new as new_upd old as old_upd
  2548. for each row
  2549. declare numrows integer;
  2550. begin
  2551. -- Cascade child "TINVOICE_ITEM" update when parent "TINVOICE" changed
  2552. if (:old_upd."CD_INVOICE" != :new_upd."CD_INVOICE") then
  2553. begin
  2554. update "TINVOICE_ITEM"
  2555. set "CD_INVOICE" = :new_upd."CD_INVOICE"
  2556. where "TINVOICE_ITEM"."CD_INVOICE" = :old_upd."CD_INVOICE" ;
  2557. end;
  2558. end if;
  2559. -- Cascade child "TINVOICE_STATUS" update when parent "TINVOICE" changed
  2560. if (:old_upd."CD_INVOICE" != :new_upd."CD_INVOICE") then
  2561. begin
  2562. update "TINVOICE_STATUS"
  2563. set "CD_INVOICE" = :new_upd."CD_INVOICE"
  2564. where "TINVOICE_STATUS"."CD_INVOICE" = :old_upd."CD_INVOICE" ;
  2565. end;
  2566. end if;
  2567.  
  2568.  
  2569. end;
  2570. /
  2571. -- Update trigger for "TCREDIT_TERMS"
  2572. Create Trigger "tu_TCREDIT_TERMS"
  2573. after update of "CD_CREDITTERMS" on "TCREDIT_TERMS"
  2574. referencing new as new_upd old as old_upd
  2575. for each row
  2576. declare numrows integer;
  2577. begin
  2578. -- Cascade child "TINVOICE" update when parent "TCREDIT_TERMS" changed
  2579. if (:old_upd."CD_CREDITTERMS" != :new_upd."CD_CREDITTERMS") then
  2580. begin
  2581. update "TINVOICE"
  2582. set "CD_CREDITTERMS" = :new_upd."CD_CREDITTERMS"
  2583. where "TINVOICE"."CD_CREDITTERMS" = :old_upd."CD_CREDITTERMS" ;
  2584. end;
  2585. end if;
  2586.  
  2587.  
  2588. end;
  2589. /
  2590. -- Update trigger for "TMRP"
  2591. Create Trigger "tu_TMRP"
  2592. after update of "CD_MRP" on "TMRP"
  2593. referencing new as new_upd old as old_upd
  2594. for each row
  2595. declare numrows integer;
  2596. begin
  2597. -- Cascade child "TMRP_DETAIL" update when parent "TMRP" changed
  2598. if (:old_upd."CD_MRP" != :new_upd."CD_MRP") then
  2599. begin
  2600. update "TMRP_DETAIL"
  2601. set "CD_MRP" = :new_upd."CD_MRP"
  2602. where "TMRP_DETAIL"."CD_MRP" = :old_upd."CD_MRP" ;
  2603. end;
  2604. end if;
  2605.  
  2606.  
  2607. end;
  2608. /
  2609. -- Update trigger for "TEMAIL"
  2610. Create Trigger "tu_TEMAIL"
  2611. after update of "CD_EMAIL" on "TEMAIL"
  2612. referencing new as new_upd old as old_upd
  2613. for each row
  2614. declare numrows integer;
  2615. begin
  2616. -- Cascade child "TEMAIL_ATTACH" update when parent "TEMAIL" changed
  2617. if (:old_upd."CD_EMAIL" != :new_upd."CD_EMAIL") then
  2618. begin
  2619. update "TEMAIL_ATTACH"
  2620. set "CD_EMAIL" = :new_upd."CD_EMAIL"
  2621. where "TEMAIL_ATTACH"."CD_EMAIL" = :old_upd."CD_EMAIL" ;
  2622. end;
  2623. end if;
  2624.  
  2625.  
  2626. end;
  2627. /
  2628. -- Update trigger for "TNCM"
  2629. Create Trigger "tu_TNCM"
  2630. after update of "DC_NCM" on "TNCM"
  2631. referencing new as new_upd old as old_upd
  2632. for each row
  2633. declare numrows integer;
  2634. begin
  2635. -- Cascade child "TNCM_TAXES" update when parent "TNCM" changed
  2636. if (:old_upd."DC_NCM" != :new_upd."DC_NCM") then
  2637. begin
  2638. update "TNCM_TAXES"
  2639. set "DC_NCM" = :new_upd."DC_NCM"
  2640. where "TNCM_TAXES"."DC_NCM" = :old_upd."DC_NCM" ;
  2641. end;
  2642. end if;
  2643.  
  2644.  
  2645. end;
  2646. /
  2647. -- Update trigger for "TSNAPSHOT"
  2648. Create Trigger "tu_TSNAPSHOT"
  2649. after update of "CD_SNAPSHOT" on "TSNAPSHOT"
  2650. referencing new as new_upd old as old_upd
  2651. for each row
  2652. declare numrows integer;
  2653. begin
  2654. -- Cascade child "TSNAPSHOT_ITEM" update when parent "TSNAPSHOT" changed
  2655. if (:old_upd."CD_SNAPSHOT" != :new_upd."CD_SNAPSHOT") then
  2656. begin
  2657. update "TSNAPSHOT_ITEM"
  2658. set "CD_SNAPSHOT" = :new_upd."CD_SNAPSHOT"
  2659. where "TSNAPSHOT_ITEM"."CD_SNAPSHOT" = :old_upd."CD_SNAPSHOT" ;
  2660. end;
  2661. end if;
  2662.  
  2663.  
  2664. end;
  2665. /
  2666. -- Update trigger for "TSNAPSHOT_ITEM"
  2667. Create Trigger "tu_TSNAPSHOT_ITEM"
  2668. after update of "CD_ITEM","CD_SNAPSHOT" on "TSNAPSHOT_ITEM"
  2669. referencing new as new_upd old as old_upd
  2670. for each row
  2671. declare numrows integer;
  2672. begin
  2673. -- Cascade child "TSNAPSHOT_STRUCTURE" update when parent "TSNAPSHOT_ITEM" changed
  2674. if (:old_upd."CD_ITEM" != :new_upd."CD_ITEM" or
  2675. :old_upd."CD_SNAPSHOT" != :new_upd."CD_SNAPSHOT") then
  2676. begin
  2677. update "TSNAPSHOT_STRUCTURE"
  2678. set "CD_PARENTITEM" = :new_upd."CD_ITEM",
  2679. "CD_PARENTSNAPSHOT" = :new_upd."CD_SNAPSHOT"
  2680. where "TSNAPSHOT_STRUCTURE"."CD_PARENTITEM" = :old_upd."CD_ITEM" and
  2681. "TSNAPSHOT_STRUCTURE"."CD_PARENTSNAPSHOT" = :old_upd."CD_SNAPSHOT" ;
  2682. end;
  2683. end if;
  2684.  
  2685.  
  2686. end;
  2687. /
  2688. -- Update trigger for "TPURCHASE_ORDER"
  2689. Create Trigger "tu_TPURCHASE_ORDER"
  2690. after update of "NU_ORDER","CD_USER","CD_SUPPLIER","CD_STATUS" on "TPURCHASE_ORDER"
  2691. referencing new as new_upd old as old_upd
  2692. for each row
  2693. declare numrows integer;
  2694. begin
  2695. -- Cascade child "TPURCHASE_ORDER_ITEM" update when parent "TPURCHASE_ORDER" changed
  2696. if (:old_upd."NU_ORDER" != :new_upd."NU_ORDER") then
  2697. begin
  2698. update "TPURCHASE_ORDER_ITEM"
  2699. set "NU_ORDER" = :new_upd."NU_ORDER"
  2700. where "TPURCHASE_ORDER_ITEM"."NU_ORDER" = :old_upd."NU_ORDER" ;
  2701. end;
  2702. end if;
  2703. -- Cascade child "TPO_STATUS" update when parent "TPURCHASE_ORDER" changed
  2704. if (:old_upd."NU_ORDER" != :new_upd."NU_ORDER") then
  2705. begin
  2706. update "TPO_STATUS"
  2707. set "NU_ORDER" = :new_upd."NU_ORDER"
  2708. where "TPO_STATUS"."NU_ORDER" = :old_upd."NU_ORDER" ;
  2709. end;
  2710. end if;
  2711.  
  2712.  
  2713. end;
  2714. /
  2715. -- Update trigger for "TPURCHASE_ORDER_ITEM"
  2716. Create Trigger "tu_TPURCHASE_ORDER_ITEM"
  2717. after update of "NU_ORDER","CD_STATUS","CD_ITEM","CD_ORDERUM","NU_SEQUENCE" on "TPURCHASE_ORDER_ITEM"
  2718. referencing new as new_upd old as old_upd
  2719. for each row
  2720. declare numrows integer;
  2721. begin
  2722. -- Cascade child "TPO_ITEM_STATUS" update when parent "TPURCHASE_ORDER_ITEM" changed
  2723. if (:old_upd."NU_ORDER" != :new_upd."NU_ORDER" or
  2724. :old_upd."NU_SEQUENCE" != :new_upd."NU_SEQUENCE") then
  2725. begin
  2726. update "TPO_ITEM_STATUS"
  2727. set "NU_ORDER" = :new_upd."NU_ORDER",
  2728. "NU_SEQUENCE" = :new_upd."NU_SEQUENCE"
  2729. where "TPO_ITEM_STATUS"."NU_ORDER" = :old_upd."NU_ORDER" and
  2730. "TPO_ITEM_STATUS"."NU_SEQUENCE" = :old_upd."NU_SEQUENCE" ;
  2731. end;
  2732. end if;
  2733.  
  2734.  
  2735. end;
  2736. /
  2737. -- Update trigger for "TPO_ITEM_STEP"
  2738. Create Trigger "tu_TPO_ITEM_STEP"
  2739. after update of "CD_POITEMSTEP" on "TPO_ITEM_STEP"
  2740. referencing new as new_upd old as old_upd
  2741. for each row
  2742. declare numrows integer;
  2743. begin
  2744. -- Cascade child "TPO_ITEM_STATUS" update when parent "TPO_ITEM_STEP" changed
  2745. if (:old_upd."CD_POITEMSTEP" != :new_upd."CD_POITEMSTEP") then
  2746. begin
  2747. update "TPO_ITEM_STATUS"
  2748. set "CD_POITEMSTEP" = :new_upd."CD_POITEMSTEP"
  2749. where "TPO_ITEM_STATUS"."CD_POITEMSTEP" = :old_upd."CD_POITEMSTEP" ;
  2750. end;
  2751. end if;
  2752. -- Cascade child "TPURCHASE_ORDER_ITEM" update when parent "TPO_ITEM_STEP" changed
  2753. if (:old_upd."CD_POITEMSTEP" != :new_upd."CD_POITEMSTEP") then
  2754. begin
  2755. update "TPURCHASE_ORDER_ITEM"
  2756. set "CD_STATUS" = :new_upd."CD_POITEMSTEP"
  2757. where "TPURCHASE_ORDER_ITEM"."CD_STATUS" = :old_upd."CD_POITEMSTEP" ;
  2758. end;
  2759. end if;
  2760.  
  2761.  
  2762. end;
  2763. /
  2764. -- Update trigger for "TPO_STEP"
  2765. Create Trigger "tu_TPO_STEP"
  2766. after update of "CD_POSTEP" on "TPO_STEP"
  2767. referencing new as new_upd old as old_upd
  2768. for each row
  2769. declare numrows integer;
  2770. begin
  2771. -- Cascade child "TPO_STATUS" update when parent "TPO_STEP" changed
  2772. if (:old_upd."CD_POSTEP" != :new_upd."CD_POSTEP") then
  2773. begin
  2774. update "TPO_STATUS"
  2775. set "CD_POSTEP" = :new_upd."CD_POSTEP"
  2776. where "TPO_STATUS"."CD_POSTEP" = :old_upd."CD_POSTEP" ;
  2777. end;
  2778. end if;
  2779. -- Cascade child "TPURCHASE_ORDER" update when parent "TPO_STEP" changed
  2780. if (:old_upd."CD_POSTEP" != :new_upd."CD_POSTEP") then
  2781. begin
  2782. update "TPURCHASE_ORDER"
  2783. set "CD_STATUS" = :new_upd."CD_POSTEP"
  2784. where "TPURCHASE_ORDER"."CD_STATUS" = :old_upd."CD_POSTEP" ;
  2785. end;
  2786. end if;
  2787.  
  2788.  
  2789. end;
  2790. /
  2791. -- Update trigger for "TDRAWBACK"
  2792. Create Trigger "tu_TDRAWBACK"
  2793. after update of "CD_DRAWBACK","CD_USER" on "TDRAWBACK"
  2794. referencing new as new_upd old as old_upd
  2795. for each row
  2796. declare numrows integer;
  2797. begin
  2798. -- Cascade child "TDRAWBACK_ITEM" update when parent "TDRAWBACK" changed
  2799. if (:old_upd."CD_DRAWBACK" != :new_upd."CD_DRAWBACK") then
  2800. begin
  2801. update "TDRAWBACK_ITEM"
  2802. set "CD_DRAWBACK" = :new_upd."CD_DRAWBACK"
  2803. where "TDRAWBACK_ITEM"."CD_DRAWBACK" = :old_upd."CD_DRAWBACK" ;
  2804. end;
  2805. end if;
  2806.  
  2807.  
  2808. end;
  2809. /
  2810. -- Update trigger for "TDRAWBACK_ITEM"
  2811. Create Trigger "tu_TDRAWBACK_ITEM"
  2812. after update of "CD_DRAWBACK","NU_SEQUENCE","CD_ITEM" on "TDRAWBACK_ITEM"
  2813. referencing new as new_upd old as old_upd
  2814. for each row
  2815. declare numrows integer;
  2816. begin
  2817. -- Cascade child "TDRAWBACK_ITEM_BREAK" update when parent "TDRAWBACK_ITEM" changed
  2818. if (:old_upd."CD_DRAWBACK" != :new_upd."CD_DRAWBACK" or
  2819. :old_upd."NU_SEQUENCE" != :new_upd."NU_SEQUENCE") then
  2820. begin
  2821. update "TDRAWBACK_ITEM_BREAK"
  2822. set "CD_DRAWBACK" = :new_upd."CD_DRAWBACK",
  2823. "NU_SEQUENCE" = :new_upd."NU_SEQUENCE"
  2824. where "TDRAWBACK_ITEM_BREAK"."CD_DRAWBACK" = :old_upd."CD_DRAWBACK" and
  2825. "TDRAWBACK_ITEM_BREAK"."NU_SEQUENCE" = :old_upd."NU_SEQUENCE" ;
  2826. end;
  2827. end if;
  2828.  
  2829.  
  2830. end;
  2831. /
  2832.  
  2833.  
  2834.  
  2835.  
  2836.  
  2837.  
  2838.  
  2839.  
  2840.  
  2841.  
  2842.  
  2843.  
  2844.  
  2845.  
  2846.  
  2847.  
  2848.  
  2849.  
  2850.  
  2851.  
  2852.  
  2853.  
  2854.  
  2855.  
  2856.  
  2857.  
  2858.  
  2859.  
  2860.  
  2861.  
  2862.  
  2863.  
  2864.  
  2865.  
  2866.  
  2867.  
  2868.  
  2869.  
  2870.  
  2871.  
  2872.  
  2873.  
  2874.  
  2875.  
  2876.  
  2877.  
  2878.  
  2879.  
  2880.  
  2881.  
  2882.  
  2883.  
  2884.  
  2885.  
  2886.  
  2887.  
  2888.  
  2889.  
  2890.  
  2891.  
  2892.  
  2893.  
  2894.  
  2895.  
  2896.  
  2897.  
  2898.  
  2899.  
  2900.  
  2901.  
  2902.  
  2903.  
  2904.  
  2905.  
  2906.  
  2907.  
  2908.  
  2909.  
  2910.  
  2911.  
  2912.  
  2913.  
  2914.  
  2915.  
  2916.  
  2917.  
  2918.  
  2919.  
  2920.  
  2921.  
  2922.  
  2923.  
  2924.  
  2925.  
  2926.  
  2927.  
  2928.  
  2929.  
  2930.  
  2931.  
  2932.  
  2933.  
  2934.  
  2935.  
  2936.  
  2937.  
  2938.  
  2939.  
  2940.  
  2941.  
  2942.  
  2943.  
  2944.  
  2945.  
  2946.  
  2947.  
  2948.  
  2949.  
  2950.  
  2951.  
  2952.  
  2953.  
  2954.  
  2955.  
  2956.  
  2957.  
  2958.  
  2959.  
  2960.  
  2961.  
  2962.  
  2963.  
  2964.  
  2965.  
  2966.  
  2967.  
  2968.  
  2969.  
  2970.  
  2971.  
  2972.  
  2973.  
  2974.  
  2975.  
  2976.  
  2977.  
  2978.  
  2979.  
  2980.  
  2981.  
  2982.  
  2983.  
  2984.  
  2985.  
  2986.  
  2987.  
  2988.  
  2989.  
  2990.  
  2991.  
  2992.  
  2993.  
  2994.  
  2995.  
  2996.  
  2997.  
  2998.  
  2999.  
  3000.  
  3001. -- Create user Triggers section
  3002.  
  3003.  
  3004.  
  3005. -- Create Packages section
  3006.  
  3007.  
  3008.  
  3009.  
  3010.  
  3011. -- Create Synonyms section
  3012.  
  3013.  
  3014.  
  3015. -- Create Roles section
  3016.  
  3017.  
  3018.  
  3019. -- Users Permissions to roles section
  3020.  
  3021.  
  3022.  
  3023. -- Roles Permissions section
  3024.  
  3025. /* Roles permissions */
  3026.  
  3027.  
  3028.  
  3029.  
  3030. -- User Permissions section
  3031.  
  3032. /* Users permissions */
  3033.  
  3034.  
  3035.  
  3036.  
  3037. -- Create Table comments section
  3038.  
  3039.  
  3040. -- Create Attribute comments section
  3041.  
  3042. Comment on column "TCOMPONENT_PERMISSION"."IN_VISIBILITY" is '0 - Invisível
  3043. 1 - Visível'
  3044. /
  3045.  
  3046. -- After section
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!