Page 6 - Dokumentasi Program Sipad
P. 6
DOKUMENTASI PROGRAM
Page 6 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 LOKASI VARCHAR (20) NOT NULL
5 DESKRIPSI VARCHAR (100) NULL
Primary Key: COMP_NAME, LOKASI
2.10. TMasalah_UploadData
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 NOFAKTUR VARCHAR (50) NOT NULL
5 NO_POCUST VARCHAR (50) NOT NULL
6 NO_LINK_ACC VARCHAR (50) NOT NULL NOMOR PENGHUBUNG SIPAD & ACCURATE
7 KODE_CUST NVARCHAR (50) NOT NULL
8 TGL_TRANS DATETIME NOT NULL
9 LOKASI VARCHAR (20) NOT NULL
10 SUBKATEGORI_BRG NVARCHAR (50) NOT NULL
11 QTY_SIPAD NUMERIC (18, 0) NULL QTY YANG ADA DI SIPAD
12 QTY_ACC NUMERIC (18, 0) NULL QTY YANG ADA DI ACCURATE
13 MASALAH VARCHAR (200) NOT NULL
Primary Key: COMP_NAME, NOFAKTUR, SUBKATEGORI_BRG, MASALAH
2.11. TMaster_Alasan
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 KODE_TRANS VARCHAR (10) NOT NULL
5 ALASAN VARCHAR (50) NOT NULL
6 DESKRIPSI VARCHAR (50) NULL
Primary Key: COMP_NAME, KODE_TRANS, ALASAN
2.12. TMaster_Ekspedisi
No Field Name Data Type Description
1 TGL_INPUT DATETIME NOT NULL
Dibuat oleh: Gs Tgl dibuat: 04 November 2016
