Wednesday, July 20, 2005

Still bingung yeuh jeung Sop Order




Gara-gara nich table dibawah gue masih bingung mau bikin aplikasi buat update SOP order dari Visual Foxpro rencana mau gue ganti pake ASP or VB yach namanya juga project thank you..

1.dbf
Name Type width Index
Type Character 20
Model Char 10
Group Char 20
partno Char 25 PartNo
p1 char 75
p2 char 75
p3 char 75
... ... 75
... ... 75
... ... 75
p35 char 75
Remark Char 200

ddata.dbf
model_no char 25
model_1 Char 25
model_2 Char 25
desc char 35
desc1 Char 35
desc2 Char 35
ebom_no11 Char 25
ebom_no12 Char 25
ebom_no13 Char 25
draw_no Char 25
draw_no1 Char 25
draw_no2 Char 25
lot_num Char 10
lotsize Numeric 5
ebom_no21 Char 25
ebom_no22 Char 25
ebom_no23 Char 25
pcn_no Char 40
part char 1
date date 8
dnote memo 4

Drawing.dbf
model_no Character 25
draw Character 25

ebom.dbf
model_no Character 25
ebom_no Character 25

Kit.dbf
model_no Character 25
kit_no Character 10
qty Numeric 4
kit Numeric 2

mlist.dbf
model_no Character 25
desc Character 35
others Logical 1
model_1 Character 25
model-2 Character 25

pcn.dbf
model_no Character 25
date Date 8
no Character 40

No comments: