Page 9 - Dokumentasi Program Sipad

DOKUMENTASI PROGRAM

Page 9 of 25

2 TGL_INPUT DATETIME NOT NULL
3 INPUTBY VARCHAR (50) NOT NULL
4 TGL_EDIT DATETIME NULL
5 EDITBY VARCHAR (50) NULL
6 TGL_CLOSE DATETIME NULL
7 CLOSEBY VARCHAR (50) NULL
8 TGL_DELETE DATETIME NULL
9 DELETEBY VARCHAR (50) NULL
10 TGL_RELEASE DATETIME NULL
11 RELEASEBY VARCHAR (50) NULL
12 NO_POCUST VARCHAR (50) NOT NULL
13 KODE_CUST NVARCHAR (50) NOT NULL
14 TGL_TRANS DATETIME NOT NULL
15 TGL_KIRIM DATETIME NULL
16 LOKASI VARCHAR (20) NOT NULL
17 STATUS VARCHAR (20) NOT NULL
18 SALES_ID NVARCHAR (50) NULL
19 NOTES VARCHAR (255) NULL CATATAN DI PO
20 ALASAN_CLOSE VARCHAR (100) NULL
21 NO_LINK_ACC VARCHAR (50) NULL NOMOR PENGHUBUNG ANTARA SIPAD
DENGAN ACCURATE
22 NAMA_PROMOSI VARCHAR (50) NULL
23 TGL_PENDING DATETIME NULL
24 PENDINGBY VARCHAR (50) NULL
25 ALASAN_PENDING VARCHAR (100) NULL
26 TGL_CEK_OD_OCL DATETIME NULL
27 CEK_OD_OCL_BY VARCHAR (50) NULL
28 STATUS_OD_OCL VARCHAR (10) NULL Diisi KOSONG, OK, OD, OCL, OD-OCL,
APPROVED
29 TGL_APPROVED DATETIME NULL
30 APPROVED_USERID VARCHAR (50) NULL USER YANG MELAKUKAN PROSES
APPROVED
31 APPROVEDBY VARCHAR (50) NULL
32 FLAG_CEK_OD_OCL VARCHAR (1) NULL Diisi NULL atau X
33 NOTES_PRINT_OD_OCL VARCHAR (500) NULL Diisi NO_POCUST + TGL_TRANS
Primary Key: COMP_NAME, NO_POCUST

2.18. TPricelist

Dibuat oleh: Gs Tgl dibuat: 04 November 2016