Page 8 - Dokumentasi Program Sipad
P. 8
DOKUMENTASI PROGRAM
Page 8 of 25
2.15. TPOCust_dtl
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_EDITQTYBY DATETIME NULL
5 EDITQTYBY VARCHAR (50) NULL
6 NO_POCUST VARCHAR (50) NOT NULL
7 SUBKATEGORI_BRG NVARCHAR (50) NOT NULL
8 KODEBAGIAN NVARCHAR (50) NULL
9 QTY_PO INT NOT NULL
10 QTY_PO_RELEASED INT NULL
11 QTY_SO INT NOT NULL
12 QTY_TEMP INT NOT NULL
13 SATUAN VARCHAR (5) NULL
Primary Key: COMP_NAME, NO_POCUST, SUBKATEGORI_BRG
2.16. TPOCust_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_EDITQTYBY DATETIME NULL
5 EDITQTYBY VARCHAR (50) NULL
6 NO_POCUST VARCHAR (50) NOT NULL
7 SUBKATEGORI_BRG NVARCHAR (50) NOT NULL
8 KODEBAGIAN NVARCHAR (50) NULL
9 QTY_PO INT NOT NULL
10 QTY_PO_RELEASED INT NULL
11 QTY_SO INT NOT NULL
12 QTY_TEMP INT NOT NULL
13 LOCKEDBY VARCHAR (50) NULL
14 SATUAN VARCHAR (5) NULL
Primary Key: COMP_NAME, NO_POCUST, SUBKATEGORI_BRG
2.17. TPOCust_mst
No Field Name Data Type Description
1 COMP_NAME VARCHAR (6) NOT NULL COMPANY NAME, default: IPP
Dibuat oleh: Gs Tgl dibuat: 04 November 2016
