Page 4 - Dokumentasi Program Sipad

DOKUMENTASI PROGRAM

Page 4 of 25

4 NO_DO VARCHAR (50) NOT NULL
5 NO_SO VARCHAR (50) NOT NULL
6 NO_POCUST VARCHAR (50) NOT NULL
7 KODE_BRG NVARCHAR (15) NOT NULL KODE BARANG SIPAD
8 KODE_BRG_ACC VARCHAR (15) NOT NULL KODE BARANG ACCURATE
9 SUBKATEGORI_BRG NVARCHAR (50) NOT NULL
10 KODEBAGIAN NVARCHAR (50) NULL
11 QTY_SO INT NOT NULL QTY DI SO
12 QTY_DO INT NOT NULL QTY DO DALAM DUS
13 QTY_DO_PCS INT NOT NULL QTY DO DALAM PCS
14 KETERANGAN NVARCHAR (150) NULL
15 SATUAN VARCHAR (5) NULL
Primary Key: COMP_NAME, NO_DO, NO_SO, KODE_BRG

2.5. TDO_mst
No Field Name Data Type Description
1 COMP_NAME VARCHAR (6) NOT NULL COMPANY NAME, default: IPP
2 TGL_INPUT DATETIME NOT NULL
3 INPUTBY VARCHAR (50) NOT NULL
4 TGL_CANCEL DATETIME NULL
5 CANCELBY VARCHAR (50) NULL
6 TGL_REPRINT DATETIME NULL
7 REPRINTBY VARCHAR (50) NULL
8 NO_DO VARCHAR (50) NOT NULL
9 KODE_CUST NVARCHAR (50) NOT NULL
10 TGL_TRANS DATETIME NOT NULL
11 LOKASI VARCHAR (20) NOT NULL
12 STATUS VARCHAR (20) NOT NULL
13 KALIPRINT INT NULL JUMLAH BERAPA KALI DO SUDAH
DIREPRINT
14 NAMA_SUPIR NVARCHAR (50) NOT NULL
15 NO_MOBIL NVARCHAR (50) NOT NULL
16 NO_HP_SUPIR VARCHAR (15) NOT NULL
17 NOTES_DO VARCHAR (200) NULL
18 ALASAN_CANCEL VARCHAR (100) NULL
19 FLAG VARCHAR (10) NULL Diisi NULL atau RECEIVE, Jika NULL berarti
belum di RECEIVE DO dan RECEIVE berarti
sudah di RECEIVE DO

Dibuat oleh: Gs Tgl dibuat: 04 November 2016