Page 5 - Dokumentasi Program Sipad

DOKUMENTASI PROGRAM

Page 5 of 25

20 NAMA_EKSPEDISI VARCHAR (40) NULL
21 JENIS_KENDARAAN VARCHAR (20) NULL
Primary Key: COMP_NAME, NO_DO

2.6. THasil_Upload_ACC
No Field Name Data Type Description
1 NO_LINK_ACC VARCHAR (50) NOT NULL NOMOR PENGHUBUNG SIPAD & ACCURATE
2 NOFAKTUR VARCHAR (50) NOT NULL
3 TGL_TRANS DATETIME NOT NULL
4 KODEBARANG_ACC VARCHAR (15) NOT NULL KODE BARANG ACCURATE
5 IDPELANGGAN NVARCHAR (50) NOT NULL
6 NAMASALES NVARCHAR (50) NOT NULL
7 JUMLAH NUMERIC (18, 4) NOT NULL DALAM PCS
Primary Key: -

2.7. THasil_Upload_ODOCL
No Field Name Data Type Description
1 KODE_CUST NVARCHAR (50) NOT NULL
2 NAMAPELANGGAN NVARCHAR (50) NOT NULL
3 KREDIT_LIMIT MONEY NOT NULL
4 NOFAKTUR VARCHAR (50) NOT NULL
5 TGL_FAKTUR DATETIME NOT NULL
6 PIUTANG MONEY NOT NULL
7 JATUH_TEMPO VARCHAR (10) NOT NULL
8 TOP INT NOT NULL
9 TANGGAL DATETIME NOT NULL
Primary Key: -

2.8. TKota
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 KOTA VARCHAR (50) NOT NULL
5 DESKRIPSI VARCHAR (100) NULL
Primary Key: COMP_NAME, KOTA

2.9. TLokasi

Dibuat oleh: Gs Tgl dibuat: 04 November 2016