Page 10 - Dokumentasi Program Sipad
P. 10
DOKUMENTASI PROGRAM
Page 10 of 25
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 INT NOT NULL
5 KELOMPOKBARANG NVARCHAR (20) NOT NULL
6 KATEGORI NVARCHAR (40) NOT NULL
7 SUBKATEGORI_3 NVARCHAR (50) NOT NULL
8 PRICELIST MONEY NOT NULL
Primary Key: COMP_NAME, SUBKATEGORI_3
2.19. TPromosi_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 NAMA_PROMOSI VARCHAR (50) NOT NULL
5 SUBKATEGORI_BRG NVARCHAR (50) NOT NULL
Primary Key: COMP_NAME, NAMA_PROMOSI, SUBKATEGORI_BRG
2.20. TPromosi_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
4 NAMA_PROMOSI VARCHAR (50) NOT NULL
5 SUBKATEGORI_BRG_BONUS NVARCHAR (50) NOT NULL
Primary Key: COMP_NAME, NAMA_PROMOSI, SUBKATEGORI_BRG_BONUS
2.21. TPromosi_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_EDIT DATETIME NULL
5 EDITBY VARCHAR (50) NULL
6 TGL_DELETE DATETIME NULL
7 DELETEBY VARCHAR (50) NULL
Dibuat oleh: Gs Tgl dibuat: 04 November 2016
