Page 3 - Dokumentasi Program Sipad
P. 3
DOKUMENTASI PROGRAM
Page 3 of 25
6 KODEBARANG_ACC VARCHAR (15) NOT NULL KODE BARANG ACCURATE
7 SUBKATEGORI_BRG NVARCHAR (50) NOT NULL
8 JUMLAH NUMERIC (18, 4) NULL
9 KETERANGAN NVARCHAR (150) NULL
10 STAT NVARCHAR (50) NULL
11 NOPO VARCHAR (50) NOT NULL
12 PCS_IKAT NUMERIC (18, 0) NULL
13 KODEBAGIAN NVARCHAR (50) NULL
14 QTY_IKAT NUMERIC (18, 0) NULL
15 TGL_INPUT DATETIME NOT NULL
16 INPUTBY VARCHAR (50) NOT NULL
17 LOKASI VARCHAR (20) NOT NULL
18 FLAG VARCHAR (3) NULL Diisi IN atau OUT, Jika IN berarti bernilai +
(positif) dan OUT berarti bernilai – (negatif)
19 NO_SO VARCHAR (50) NOT NULL
20 SATUAN VARCHAR (5) NULL
Primary Key: COMP_NAME, NOFAKTUR, KODEBARANG, NOPO
2.3. TDO_dtl1
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 NO_DO VARCHAR (50) NOT NULL
5 NO_SO VARCHAR (50) NOT NULL
6 NO_POCUST VARCHAR (50) NOT NULL
7 TGL_KIRIM DATETIME NULL
8 SALES_ID NVARCHAR (50) NULL
9 NOTES_SO VARCHAR (255) NULL CATATAN 1 SO
10 NOTES2_SO VARCHAR (255) NULL CATATAN 2 SO
11 NAMA_PROMOSI VARCHAR (50) NULL
Primary Key: COMP_NAME, NO_DO, NO_SO
2.4. TDO_dtl2
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
Dibuat oleh: Gs Tgl dibuat: 04 November 2016
