Scribd
Upload
22 views4 pages

Fieldname Type Size Fieldname Type Size Fieldname Type

The document describes the structure of an inventory database that contains information about items (Barang), customers (Pelanggan), suppliers (Supplier), purchases (Beli), sales (Jual), and users (Pemakai). The database includes fields for item codes, names, expiration dates, prices and quantities as well as customer and supplier contact information. It also tracks purchase and sales orders along with the users who have permission to access different areas of the system.

Uploaded by

yusuf hadi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
22 views4 pages

Fieldname Type Size Fieldname Type Size Fieldname Type

The document describes the structure of an inventory database that contains information about items (Barang), customers (Pelanggan), suppliers (Supplier), purchases (Beli), sales (Jual), and users (Pemakai). The database includes fields for item codes, names, expiration dates, prices and quantities as well as customer and supplier contact information. It also tracks purchase and sales orders along with the users who have permission to access different areas of the system.

Uploaded by

yusuf hadi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

INVENTORY DATABASE

BARANG PELANGGAN SUPPLIER


FieldName Type Size FieldName Type Size FieldName Type
KodeBarang Text 10 KodePelanggan Text 10 KodeSupplier Text
Barcode Text 20 Nama Text 40 Nama Text
NamaBarang Text 40 Alamat Text 50 Alamat Text
TglEXP DateTime - Kota Text 25 Kota Text
Satuan Text 20 NoTelp Text 25 NoTelp Text
HargaJual Number Single
HargaBeli Number Single BELI
Stok Number LongInteger FieldName Type
StokMIN Number LongInteger NoFaktur Text
StokMAX Number LongInteger TglBeli DateTime
KodeSupplier Text

DETAILBELI
FieldName Type
NoFaktur Text
Barcode Text
JmlBeli Number
HargaBeli Number
JUAL PEMAKAI
Size FieldName Type Size FieldName Type Size
10 NoNota Text 10 UserName Text 10
40 TglJual DateTime - Password Text 15
50 KodePelanggan Text 10 NamaPemakai Text 50
25 Jabatan Text 30
25 DETAILJUAL MnPemakai Yes/No -
FieldName Type Size MnUbahPass Yes/No -
NoNota Text 10 MnBarang Yes/No -
Size Barcode Text 20 MnPelanggan Yes/No -
10 JmlJual Number - MnSupplier Yes/No -
- HargaJual Number Single MnBeli Yes/No -
10 MnJual Yes/No -
MnLapBarang Yes/No -
MnLapSupplier Yes/No -
Size MnLapBarang Yes/No -
10 MnLapBeli Yes/No -
20 MnLapJual Yes/No -
- MnBarcode Yes/No -
Single

You might also like