Specification » History » Version 7
chin-yeh, 09/05/2011 10:54 AM
1 | 1 | chin-yeh | {{toc}} |
---|---|---|---|
2 | |||
3 | h1. Specification |
||
4 | |||
5 | 5 | chin-yeh | h2. Activity Diagram |
6 | |||
7 | * [[Activity Diagram - Sales]] |
||
8 | * [[Activity Diagram - Return/Exchange]] |
||
9 | * [[Activity Diagram - VIP Upgrade]] |
||
10 | |||
11 | 7 | chin-yeh | h2. Reference |
12 | 1 | chin-yeh | |
13 | 7 | chin-yeh | h3. Transaction Code |
14 | |||
15 | 1 | chin-yeh | !dp_transaction_code.jpg! |
16 | 7 | chin-yeh | |
17 | h3. Error Code |
||
18 | |||
19 | !dp_error_code.jpg! |
||
20 | 6 | chin-yeh | |
21 | |||
22 | 3 | chin-yeh | h2. Table Schema |
23 | 1 | chin-yeh | |
24 | h3. DP_INTERFACE |
||
25 | 3 | chin-yeh | |
26 | This table stores those events which are needed to submit to DP services. It can also be used to track the status of the submitted events. |
||
27 | 1 | chin-yeh | |
28 | <pre> |
||
29 | <code class="SQL"> |
||
30 | create table dp_interface ( |
||
31 | id int not null generated always as identity, |
||
32 | 2 | chin-yeh | process_code varchar(30), |
33 | 1 | chin-yeh | trx_id varchar(30) not null, |
34 | trx_type varchar(15), |
||
35 | 2 | chin-yeh | country_code varchar(10), |
36 | 4 | chin-yeh | member_name varchar(100), |
37 | 2 | chin-yeh | member_id varchar(20), |
38 | 4 | chin-yeh | new_member_id varchar(20), |
39 | 2 | chin-yeh | trx_date varchar(8), |
40 | dp_amount decimal(10,2), |
||
41 | invoice_amount decimal(10,2), |
||
42 | 1 | chin-yeh | status varchar(15), |
43 | last_updated timestamp, |
||
44 | error_code varchar(10), |
||
45 | error_message varchar(255), |
||
46 | primary key (id) |
||
47 | ); |
||
48 | |||
49 | 2 | chin-yeh | create unique index idx_dp_id_type on dp_interface(trx_id,trx_type); |
50 | 1 | chin-yeh | create index idx_dp_status on dp_interface(status); |
51 | create index idx_dp_err_code on dp_interface(error_code); |
||
52 | </code> |
||
53 | </pre> |