Page 15 - Dokumentasi Program Sipad
P. 15
DOKUMENTASI PROGRAM
Page 15 of 25
Primary Key: COMP_NAME, NO_SO, KODE_BRG
2.30. TSOF_dtl_temp
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_EDITQTY DATETIME NULL
5 EDITQTYBY VARCHAR (50) NULL
6 NO_SO VARCHAR (50) NOT NULL
7 NO_POCUST VARCHAR (50) NOT NULL
8 NO_DO VARCHAR (50) NULL
9 KODE_BRG NVARCHAR (15) NOT NULL KODE BARANG SIPAD
10 KODE_BRG_ACC VARCHAR (15) NOT NULL KODE BARANG ACCURATE
11 SUBKATEGORI_BRG NVARCHAR (50) NOT NULL
12 KODEBAGIAN NVARCHAR (50) NULL
13 QTY_SO INT NOT NULL QTY DI SO
14 QTY_SOF INT NOT NULL QTY SOF (SO FINAL) DALAM DUS
15 QTY_SOF_PCS INT NOT NULL QTY SOF (SO FINAL) DALAM PCS
16 KETERANGAN NVARCHAR (150) NULL
17 LOCKEDBY VARCHAR (50) NULL
18 SATUAN VARCHAR (5) NULL
Primary Key: COMP_NAME, NO_SO, KODE_BRG
2.31. TSOF_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 NO_SO VARCHAR (50) NOT NULL
5 NO_POCUST VARCHAR (50) NOT NULL
6 KODE_CUST NVARCHAR (50) NOT NULL
7 TGL_KIRIM DATETIME NULL
8 LOKASI VARCHAR (20) NOT NULL
9 STATUS VARCHAR (20) NOT NULL
10 SALES_ID NVARCHAR (50) NULL
11 NOTES VARCHAR (255) NULL CATATAN 1 DI SO
12 NOTES2 VARCHAR (255) NULL CATATAN 2 DI SO
Dibuat oleh: Gs Tgl dibuat: 04 November 2016
