TblJenis
Kolom
|
Tipe
Data
|
Panjang
|
KodeJenis*
|
Text
|
4
|
Jenis
|
Text
|
60
|
TblBarang
Kolom
|
Tipe
Data
|
Panjang
|
KodeBarang*
|
Text
|
4
|
NamaBarang
|
Text
|
100
|
KodeJenis**
|
Text
|
4
|
HargaNet
|
Currency
|
|
HargaJual
|
Currency
|
|
Stok
|
Number
|
TblSupplier
Kolom
|
Tipe
Data
|
Panjang
|
IdSupplier*
|
Text
|
6
|
NamaSupplier
|
Text
|
80
|
Alamat
|
Text
|
100
|
KotaAsal
|
Text
|
80
|
Email
|
Text
|
80
|
Telpon
|
Text
|
15
|
TblBarangMasuk
Kolom
|
Tipe
Data
|
Panjang
|
NoNota*
|
Text
|
10
|
TglMasuk
|
Date
|
|
IdDistributor**
|
Text
|
6
|
IdUser**
|
Number
|
|
Total
|
Currency
|
TblDetailBarangMasuk
Kolom
|
Tipe
Data
|
Panjang
|
NoNota**
|
Text
|
10
|
KodeBarang**
|
Text
|
4
|
Jumlah
|
Number
|
|
SubTotal
|
Currency
|
TblPenjualan
Kolom
|
Tipe
Data
|
Panjang
|
NoFaktur*
|
Text
|
10
|
TglPenjualan
|
Date
|
|
IdUser
|
Number
|
|
Bayar
|
Currency
|
|
Sisa
|
Currency
|
|
Total
|
Currency
|
TblDetailPenjualan
Kolom
|
Tipe
Data
|
Panjang
|
NoFaktur**
|
Text
|
10
|
KodeBarang**
|
Text
|
4
|
Jumlah
|
Number
|
|
SubTotal
|
Currency
|
Keterangan :
