create table company
(COCODE CHAR(2),
NAME VARCHAR2(50),
AC1 CHAR(2),
AC2 CHAR(2),
AC3 CHAR(2),
ST15 CHAR(6),
ST3 CHAR(6));
create table customer
(cocode char(2),
cuscode char(4),
cusname varchar2(50),
addr varchar2(150),
stregno varchar2(15),
telephone varchar2(15),
fax varchar2(15),
email varchar2(60));
create table machine
(cocode char(2),
mcode char(2),
name varchar2(50),
dia varchar2(10),
guage varchar2(10),
capacity number(8));
create table product
(cocode char(2),
pcode char(10),
name varchar2(50),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10));
create table recyarn
(cocode char(2),
docno char(10),
cuscode char(4),
PCODE CHAR(10),
recdate date,
qty number(10),
progref varchar2(15),
dcno char(10),
ref varchar2(15),
FABRIC VARCHAR2(30),
vehicalno varchar2(20),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
transferfrom char(15),
qtytrf number(10,2),
qtybal number(10,2),
qtyout number(10,2));
CREATE TABLE RETYARN
(DOCNO CHAR(10),
RECDATE DATE,
QTY NUMBER(10),
PROGREF VARCHAR2(15),
DCNO CHAR(10),
vehicalno VARCHAR2(20),
CUSCODE CHAR(4),
FABRIC VARCHAR2(30),
PCODE CHAR(10),
REF VARCHAR2(15),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
COCODE CHAR(2),
TRANSFERFROM CHAR(15),
QTYTRF NUMBER(10),
QTYBAL NUMBER(10),
QTYOUT NUMBER(10));
CREATE TABLE PRODINFHEAD
(DOCNO CHAR(10),
DOCDATE DATE,
WEIGHT NUMBER(7,2),
MCODE CHAR(2),
PROGREF VARCHAR2(15),
CUSCODE CHAR(4),
SHIFT CHAR(1),
FABRIC VARCHAR2(30),
WORKER VARCHAR2(30),
GUAGE VARCHAR2(10),
DIA VARCHAR2(10),
WASTAGE NUMBER(5,2),
GSM VARCHAR2(10),
REMARKS VARCHAR2(150),
TOTALWGHT NUMBER(10,2),
COCODE CHAR(2),
CHECKBOX CHAR(1),
HOURS VARCHAR2(10),
PCODE VARCHAR2(10),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
SNO NUMBER(2),
WGHT NUMBER(10,2));
CREATE TABLE PRODINFDET
(DOCNO CHAR(10),
DOCDATE DATE,
WEIGHT NUMBER(7,2),
MCODE CHAR(2),
PROGREF VARCHAR2(15),
CUSCODE CHAR(4),
SHIFT CHAR(1),
FABRIC VARCHAR2(30),
WORKER VARCHAR2(30),
GUAGE VARCHAR2(10),
DIA VARCHAR2(10),
WASTAGE NUMBER(5,2),
GSM VARCHAR2(10),
REMARKS VARCHAR2(150),
TOTALWGHT NUMBER(10,2),
COCODE CHAR(2),
CHECKBOX CHAR(1),
HOURS VARCHAR2(10),
PCODE VARCHAR2(10),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
SNO NUMBER(2),
WGHT NUMBER(10,2));
create table dchead
(DOCNO CHAR(10),
DOCDATE DATE,
WEIGHT NUMBER(10,2),
MCODE CHAR(2),
PROGREF VARCHAR2(15),
CUSCODE CHAR(4),
PCODE CHAR(10),
SHIFT CHAR(1),
FABRIC VARCHAR2(30),
WORKER VARCHAR2(30),
GUAGE VARCHAR2(10),
DIA VARCHAR2(10),
WASTAGE NUMBER(5,2),
GSM VARCHAR2(10),
REMARKS VARCHAR2(150),
REFNO VARCHAR2(10),
TOTALWGHT NUMBER(7,2),
GEN CHAR(1),
INVNO VARCHAR2(15),
INVDATE DATE,
COCODE CHAR(2),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2));
CREATE TABLE DCDET
(DOCNO CHAR(10),
DOCDATE DATE,
WEIGHT NUMBER(10,2),
MCODE CHAR(2),
PROGREF VARCHAR2(15),
CUSCODE CHAR(4),
PCODE CHAR(10),
SHIFT CHAR(1),
FABRIC VARCHAR2(30),
WORKER VARCHAR2(30),
GUAGE VARCHAR2(10),
DIA VARCHAR2(10),
WASTAGE NUMBER(5,2),
GSM VARCHAR2(10),
REMARKS VARCHAR2(150),
REFNO VARCHAR2(10),
TOTALWGHT NUMBER(7,2),
GEN CHAR(1),
INVNO VARCHAR2(15),
INVDATE DATE,
COCODE CHAR(2),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
SNO NUMBER(2),
WGHT NUMBER(10,2));
CREATE TABLE FABRETHEAD
(cocode char(2),
docno char(10),
cuscode char(4),
PCODE CHAR(10),
recdate date,
qty number(10),
progref varchar2(15),
dcno char(10),
ref varchar2(15),
FABRIC VARCHAR2(30),
vehicalno varchar2(20),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
transferfrom char(15),
qtytrf number(10,2),
qtybal number(10,2),
qtyout number(10,2));
(COCODE CHAR(2),
NAME VARCHAR2(50),
AC1 CHAR(2),
AC2 CHAR(2),
AC3 CHAR(2),
ST15 CHAR(6),
ST3 CHAR(6));
create table customer
(cocode char(2),
cuscode char(4),
cusname varchar2(50),
addr varchar2(150),
stregno varchar2(15),
telephone varchar2(15),
fax varchar2(15),
email varchar2(60));
create table machine
(cocode char(2),
mcode char(2),
name varchar2(50),
dia varchar2(10),
guage varchar2(10),
capacity number(8));
create table product
(cocode char(2),
pcode char(10),
name varchar2(50),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10));
create table recyarn
(cocode char(2),
docno char(10),
cuscode char(4),
PCODE CHAR(10),
recdate date,
qty number(10),
progref varchar2(15),
dcno char(10),
ref varchar2(15),
FABRIC VARCHAR2(30),
vehicalno varchar2(20),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
transferfrom char(15),
qtytrf number(10,2),
qtybal number(10,2),
qtyout number(10,2));
CREATE TABLE RETYARN
(DOCNO CHAR(10),
RECDATE DATE,
QTY NUMBER(10),
PROGREF VARCHAR2(15),
DCNO CHAR(10),
vehicalno VARCHAR2(20),
CUSCODE CHAR(4),
FABRIC VARCHAR2(30),
PCODE CHAR(10),
REF VARCHAR2(15),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
COCODE CHAR(2),
TRANSFERFROM CHAR(15),
QTYTRF NUMBER(10),
QTYBAL NUMBER(10),
QTYOUT NUMBER(10));
CREATE TABLE PRODINFHEAD
(DOCNO CHAR(10),
DOCDATE DATE,
WEIGHT NUMBER(7,2),
MCODE CHAR(2),
PROGREF VARCHAR2(15),
CUSCODE CHAR(4),
SHIFT CHAR(1),
FABRIC VARCHAR2(30),
WORKER VARCHAR2(30),
GUAGE VARCHAR2(10),
DIA VARCHAR2(10),
WASTAGE NUMBER(5,2),
GSM VARCHAR2(10),
REMARKS VARCHAR2(150),
TOTALWGHT NUMBER(10,2),
COCODE CHAR(2),
CHECKBOX CHAR(1),
HOURS VARCHAR2(10),
PCODE VARCHAR2(10),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
SNO NUMBER(2),
WGHT NUMBER(10,2));
CREATE TABLE PRODINFDET
(DOCNO CHAR(10),
DOCDATE DATE,
WEIGHT NUMBER(7,2),
MCODE CHAR(2),
PROGREF VARCHAR2(15),
CUSCODE CHAR(4),
SHIFT CHAR(1),
FABRIC VARCHAR2(30),
WORKER VARCHAR2(30),
GUAGE VARCHAR2(10),
DIA VARCHAR2(10),
WASTAGE NUMBER(5,2),
GSM VARCHAR2(10),
REMARKS VARCHAR2(150),
TOTALWGHT NUMBER(10,2),
COCODE CHAR(2),
CHECKBOX CHAR(1),
HOURS VARCHAR2(10),
PCODE VARCHAR2(10),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
SNO NUMBER(2),
WGHT NUMBER(10,2));
create table dchead
(DOCNO CHAR(10),
DOCDATE DATE,
WEIGHT NUMBER(10,2),
MCODE CHAR(2),
PROGREF VARCHAR2(15),
CUSCODE CHAR(4),
PCODE CHAR(10),
SHIFT CHAR(1),
FABRIC VARCHAR2(30),
WORKER VARCHAR2(30),
GUAGE VARCHAR2(10),
DIA VARCHAR2(10),
WASTAGE NUMBER(5,2),
GSM VARCHAR2(10),
REMARKS VARCHAR2(150),
REFNO VARCHAR2(10),
TOTALWGHT NUMBER(7,2),
GEN CHAR(1),
INVNO VARCHAR2(15),
INVDATE DATE,
COCODE CHAR(2),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2));
CREATE TABLE DCDET
(DOCNO CHAR(10),
DOCDATE DATE,
WEIGHT NUMBER(10,2),
MCODE CHAR(2),
PROGREF VARCHAR2(15),
CUSCODE CHAR(4),
PCODE CHAR(10),
SHIFT CHAR(1),
FABRIC VARCHAR2(30),
WORKER VARCHAR2(30),
GUAGE VARCHAR2(10),
DIA VARCHAR2(10),
WASTAGE NUMBER(5,2),
GSM VARCHAR2(10),
REMARKS VARCHAR2(150),
REFNO VARCHAR2(10),
TOTALWGHT NUMBER(7,2),
GEN CHAR(1),
INVNO VARCHAR2(15),
INVDATE DATE,
COCODE CHAR(2),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
SNO NUMBER(2),
WGHT NUMBER(10,2));
CREATE TABLE FABRETHEAD
(cocode char(2),
docno char(10),
cuscode char(4),
PCODE CHAR(10),
recdate date,
qty number(10),
progref varchar2(15),
dcno char(10),
ref varchar2(15),
FABRIC VARCHAR2(30),
vehicalno varchar2(20),
count1 varchar2(10),
count2 varchar2(10),
count3 varchar2(10),
lycra varchar2(10),
c1bname varchar2(10),
c2bname varchar2(10),
c3bname varchar2(10),
lbname varchar2(10),
c1qty number(10,2),
c2qty number(10,2),
c3qty number(10,2),
lqty number(10,2),
c1per number(10,2),
c2per number(10,2),
c3per number(10,2),
lper number(10,2),
transferfrom char(15),
qtytrf number(10,2),
qtybal number(10,2),
qtyout number(10,2));
No comments:
Post a Comment