Page 12 - Dokumentasi Program Sipad

DOKUMENTASI PROGRAM

Page 12 of 25

2.24. TPYO_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
8 NO_PYO VARCHAR (50) NOT NULL
9 KODE_CUST NVARCHAR (50) NOT NULL
10 TGL_TRANS DATETIME NOT NULL
11 KODE_TRANS VARCHAR (10) NOT NULL
12 LOKASI VARCHAR (20) NOT NULL
13 STATUS VARCHAR (20) NOT NULL
14 SALES_ID NVARCHAR (50) NULL
15 NOTES VARCHAR (200) NULL
16 ALASAN_DELETE VARCHAR (100) NULL
Primary Key: COMP_NAME, NO_PYO

2.25. TReport_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 KODE_RPT VARCHAR (4) NOT NULL
5 KODE_TRANS VARCHAR (10) NOT NULL
6 NAMA_LAPORAN VARCHAR (100) NOT NULL
7 BAGIAN_LAPORAN VARCHAR (10) NOT NULL Diisi ORDER, PENGIRIMAN, atau SALES
Primary Key: COMP_NAME, KODE_RPT

2.26. TSO_dtl
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

Dibuat oleh: Gs Tgl dibuat: 04 November 2016