| 1 | /* |
| 2 | * Legal Notice |
| 3 | * |
| 4 | * This document and associated source code (the "Work") is a part of a |
| 5 | * benchmark specification maintained by the TPC. |
| 6 | * |
| 7 | * The TPC reserves all right, title, and interest to the Work as provided |
| 8 | * under U.S. and international laws, including without limitation all patent |
| 9 | * and trademark rights therein. |
| 10 | * |
| 11 | * No Warranty |
| 12 | * |
| 13 | * 1.1 TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, THE INFORMATION |
| 14 | * CONTAINED HEREIN IS PROVIDED "AS IS" AND WITH ALL FAULTS, AND THE |
| 15 | * AUTHORS AND DEVELOPERS OF THE WORK HEREBY DISCLAIM ALL OTHER |
| 16 | * WARRANTIES AND CONDITIONS, EITHER EXPRESS, IMPLIED OR STATUTORY, |
| 17 | * INCLUDING, BUT NOT LIMITED TO, ANY (IF ANY) IMPLIED WARRANTIES, |
| 18 | * DUTIES OR CONDITIONS OF MERCHANTABILITY, OF FITNESS FOR A PARTICULAR |
| 19 | * PURPOSE, OF ACCURACY OR COMPLETENESS OF RESPONSES, OF RESULTS, OF |
| 20 | * WORKMANLIKE EFFORT, OF LACK OF VIRUSES, AND OF LACK OF NEGLIGENCE. |
| 21 | * ALSO, THERE IS NO WARRANTY OR CONDITION OF TITLE, QUIET ENJOYMENT, |
| 22 | * QUIET POSSESSION, CORRESPONDENCE TO DESCRIPTION OR NON-INFRINGEMENT |
| 23 | * WITH REGARD TO THE WORK. |
| 24 | * 1.2 IN NO EVENT WILL ANY AUTHOR OR DEVELOPER OF THE WORK BE LIABLE TO |
| 25 | * ANY OTHER PARTY FOR ANY DAMAGES, INCLUDING BUT NOT LIMITED TO THE |
| 26 | * COST OF PROCURING SUBSTITUTE GOODS OR SERVICES, LOST PROFITS, LOSS |
| 27 | * OF USE, LOSS OF DATA, OR ANY INCIDENTAL, CONSEQUENTIAL, DIRECT, |
| 28 | * INDIRECT, OR SPECIAL DAMAGES WHETHER UNDER CONTRACT, TORT, WARRANTY, |
| 29 | * OR OTHERWISE, ARISING IN ANY WAY OUT OF THIS OR ANY OTHER AGREEMENT |
| 30 | * RELATING TO THE WORK, WHETHER OR NOT SUCH AUTHOR OR DEVELOPER HAD |
| 31 | * ADVANCE NOTICE OF THE POSSIBILITY OF SUCH DAMAGES. |
| 32 | * |
| 33 | * Contributors: |
| 34 | * Gradient Systems |
| 35 | */ |
| 36 | #ifndef W_WEB_RETURNS_H |
| 37 | #define W_WEB_RETURNS_H |
| 38 | /* |
| 39 | * WEB_RETURNS table structure |
| 40 | */ |
| 41 | struct W_WEB_RETURNS_TBL { |
| 42 | ds_key_t wr_returned_date_sk; |
| 43 | ds_key_t wr_returned_time_sk; |
| 44 | ds_key_t wr_item_sk; |
| 45 | ds_key_t wr_refunded_customer_sk; |
| 46 | ds_key_t wr_refunded_cdemo_sk; |
| 47 | ds_key_t wr_refunded_hdemo_sk; |
| 48 | ds_key_t wr_refunded_addr_sk; |
| 49 | ds_key_t wr_returning_customer_sk; |
| 50 | ds_key_t wr_returning_cdemo_sk; |
| 51 | ds_key_t wr_returning_hdemo_sk; |
| 52 | ds_key_t wr_returning_addr_sk; |
| 53 | ds_key_t wr_web_page_sk; |
| 54 | ds_key_t wr_reason_sk; |
| 55 | ds_key_t wr_order_number; |
| 56 | ds_pricing_t wr_pricing; |
| 57 | }; |
| 58 | |
| 59 | int mk_w_web_returns(void *row, ds_key_t kIndex); |
| 60 | |
| 61 | #endif |
| 62 | |