Page 13 - Dokumentasi Program Sipad

DOKUMENTASI PROGRAM

Page 13 of 25

6 NO_SO VARCHAR (50) NOT NULL
7 NO_POCUST VARCHAR (50) NOT NULL
8 SUBKATEGORI_BRG NVARCHAR (50) NOT NULL
9 KODEBAGIAN NVARCHAR (50) NULL
10 QTY_PO INT NOT NULL QTY DI PO
11 QTY_SO INT NOT NULL QTY DI SO
12 SATUAN VARCHAR (5) NULL
Primary Key: COMP_NAME, NO_SO, SUBKATEGORI_BRG

2.27. TSO_dtl_temp
No Field Name Data Type Description
1 COMP_NAME VARCHAR (6) NOT NULL COMPANY NAME, default: IPP
2 TGL_RELEASE DATETIME NOT NULL
3 RELEASEBY 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 SUBKATEGORI_BRG NVARCHAR (50) NOT NULL
9 KODEBAGIAN NVARCHAR (50) NULL
10 QTY_PO INT NOT NULL
11 QTY_SO INT NOT NULL
12 LOCKEDBY VARCHAR (50) NULL
13 SATUAN VARCHAR (5) NULL
Primary Key: COMP_NAME, NO_SO, SUBKATEGORI_BRG

2.28. TSO_mst
No Field Name Data Type Description
1 COMP_NAME VARCHAR (6) NOT NULL COMPANY NAME, default: IPP
2 TGL_RELEASE DATETIME NOT NULL
3 RELEASEBY VARCHAR (50) NOT NULL
4 TGL_CANCEL DATETIME NULL
5 CANCELBY VARCHAR (50) NULL
6 TGL_PRINT DATETIME NULL
7 PRINTBY VARCHAR (50) NULL
8 TGL_REPRINT DATETIME NULL
9 REPRINTBY VARCHAR (50) NULL
10 TGL_CONFIRM DATETIME NULL SUDAH TIDAK DIPAKAI LAGI

Dibuat oleh: Gs Tgl dibuat: 04 November 2016