3700 SQL Database Tables
Uploaded by
Immanuel3700 SQL Database Tables
Uploaded by
Immanuel3700 SQL / Database Access Contents 1st Page Index
Revenue Center Shift Employee Order Type Totals
shift_rvc_emp_ot_ttl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Store ID store_id STORE_ID PK FK AK1 NOT NULL
Employee Sequence emp_seq SEQ_NUM PK FK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Order Type Sequence order_type_seq SEQ_NUM PK FK NOT NULL
Rev Ctr Sequence rvc_seq SEQ_NUM PK FK NOT NULL
Revenue Center Shift Employee Order Type Totals
Net Sales Total net_sls_ttl MONEY18 NOT NULL
Check Count chk_cnt COUNT6 NOT NULL
Cover Count cov_cnt COUNT6 NOT NULL
Table Turn Count tbl_turn_cnt COUNT6 NOT NULL
Table Dine Time tbl_dine_time SECONDS NOT NULL
Sequence ID em_ttl_repl_seq EM_TTL_SEQ_NUM AK1 NOT NULL
Database Tables
9-288
Contents 1st Page Index
Revenue Center Shift Employee Total
Database Tables
9-289
Revenue Center Shift Employee Total
shift_rvc_emp_ttl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Store ID store_id STORE_ID PK FK AK1 NOT NULL
Employee Sequence emp_seq SEQ_NUM PK FK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Rev Ctr Sequence rvc_seq SEQ_NUM PK FK NOT NULL
Net Sales Total net_sls_ttl MONEY18 NOT NULL
Item Discount Total item_dsc_ttl MONEY18 NOT NULL
Subtotal Discount Total sttl_dsc_ttl MONEY18 NOT NULL
Service Total svc_ttl MONEY18 NOT NULL
Return Count rtn_cnt COUNT6 NOT NULL
Return Total rtn_ttl MONEY18 NOT NULL
Void Count void_cnt COUNT6 NOT NULL
Void Total void_ttl MONEY18 NOT NULL
Tax Collected Total tax_coll_ttl MONEY18 NOT NULL
Credit Total credit_ttl MONEY18 NOT NULL
Rounding Total rounding_ttl MONEY18 NOT NULL
Change in Grand Total change_grand_ttl MONEY18 NOT NULL
Training Total training_ttl MONEY18 NOT NULL
Cancel Count cancel_cnt COUNT6 NOT NULL
Cancel Total cancel_ttl MONEY18 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Manager Void Count mgr_void_cnt COUNT6 NOT NULL
Manager Void Total mgr_void_ttl MONEY18 NOT NULL
Error Correct Count error_correct_cnt COUNT6 NOT NULL
Error Correct Total error_correct_ttl MONEY18 NOT NULL
Checks Carried Over Count chk_carry_over_cnt COUNT6 NOT NULL
Checks Carried Over Total chk_carry_over_ttl MONEY18 NOT NULL
Checks Begun Count chk_begun_cnt COUNT6 NOT NULL
Checks Begun Total chk_begun_ttl MONEY18 NOT NULL
Checks Paid Count chk_paid_cnt COUNT6 NOT NULL
Checks Paid Total chk_paid_ttl MONEY18 NOT NULL
Checks Transferred In Count chk_xfer_in_cnt COUNT6 NOT NULL
Revenue Center Shift Employee Total
Checks Transferred In Total chk_xfer_in_ttl MONEY18 NOT NULL
Checks Transferred Out Count chk_xfer_out_cnt COUNT6 NOT NULL
Checks Transferred Out Total chk_xfer_out_ttl MONEY18 NOT NULL
Cover Count cov_cnt COUNT6 NOT NULL
Check Count chk_cnt COUNT6 NOT NULL
Table Turn Count tbl_turn_cnt COUNT6 NOT NULL
Database Tables
Table Dine Time tbl_dine_time SECONDS NOT NULL
No Sale Count no_sale_cnt COUNT6 NOT NULL
Gross Receipts Total gross_rcpts_ttl MONEY18 NOT NULL
Charged Receipts Total charged_rcpts_ttl MONEY18 NOT NULL
9-290
Charged Tips Total charged_tips_ttl MONEY18 NOT NULL
Contents 1st Page Index
Revenue Center Shift Employee Total
Database Tables
9-291
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tip Service Charge Total tip_svc_ttl MONEY18 NOT NULL
Tips Paid Total tips_paid_ttl MONEY18 NOT NULL
Tips Declared Total tips_decl_ttl MONEY18 NOT NULL
Shift Start Date/Time shift_start_time DATETIME NOT NULL
Shift End Date/Time shift_end_time DATETIME
Sequence ID em_ttl_repl_seq EM_TTL_SEQ_NUM AK1 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Revenue Center Shift Employee Tracking Total Temp
shift_rvc_emp_trk_ttl_temp
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Revenue Center Sequence rvc_seq SECONDS PK NOT NULL
Employee Sequence emp_seq SEQ_NUM PK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Tracking Group Sequence trk_grp_seq SEQ_NUM PK NOT NULL
Revenue Center Shift Employee Tracking Total Temp
Tracking Total Sequence trk_ttl_seq SEQ_NUM PK NOT NULL
Count cnt COUNT6
Total ttl MONEY18
Database Tables
9-292
Contents 1st Page Index
Revenue Center Shift Employee Tracking Totals
Database Tables
9-293
Revenue Center Shift Employee Tracking Totals
shift_rvc_emp_trk_ttl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Store ID store_id STORE_ID PK FK AK1 NOT NULL
Employee Sequence emp_seq SEQ_NUM PK FK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Rev Ctr Sequence rvc_seq SEQ_NUM PK FK NOT NULL
Tracking Group Sequence trk_grp_seq SEQ_NUM FK
Tracking Count 1 trk_cnt_01 COUNT6 NOT NULL
Tracking Total 1 trk_ttl_01 MONEY18 NOT NULL
Tracking Count 2 trk_cnt_02 COUNT6 NOT NULL
Tracking Total 2 trk_ttl_02 MONEY18 NOT NULL
Tracking Count 3 trk_cnt_03 COUNT6 NOT NULL
Tracking Total 3 trk_ttl_03 MONEY18 NOT NULL
Tracking Count 4 trk_cnt_04 COUNT6 NOT NULL
Tracking Total 4 trk_ttl_04 MONEY18 NOT NULL
Tracking Count 5 trk_cnt_05 COUNT6 NOT NULL
Tracking Total 5 trk_ttl_05 MONEY18 NOT NULL
Tracking Count 6 trk_cnt_06 COUNT6 NOT NULL
Tracking Total 6 trk_ttl_06 MONEY18 NOT NULL
Tracking Count 7 trk_cnt_07 COUNT6 NOT NULL
Tracking Total 7 trk_ttl_07 MONEY18 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Count 8 trk_cnt_08 COUNT6 NOT NULL
Tracking Total 8 trk_ttl_08 MONEY18 NOT NULL
Tracking Count 9 trk_cnt_09 COUNT6 NOT NULL
Tracking Total 9 trk_ttl_09 MONEY18 NOT NULL
Tracking Count 10 trk_cnt_10 COUNT6 NOT NULL
Tracking Total 10 trk_ttl_10 MONEY18 NOT NULL
Tracking Count 11 trk_cnt_11 COUNT6 NOT NULL
Tracking Total 11 trk_ttl_11 MONEY18 NOT NULL
Revenue Center Shift Employee Tracking Totals
Tracking Count 12 trk_cnt_12 COUNT6 NOT NULL
Tracking Total 12 trk_ttl_12 MONEY18 NOT NULL
Tracking Count 13 trk_cnt_13 COUNT6 NOT NULL
Tracking Total 13 trk_ttl_13 MONEY18 NOT NULL
Tracking Count 14 trk_cnt_14 COUNT6 NOT NULL
Tracking Total 14 trk_ttl_14 MONEY18 NOT NULL
Tracking Count 15 trk_cnt_15 COUNT6 NOT NULL
Tracking Total 15 trk_ttl_15 MONEY18 NOT NULL
Tracking Count 16 trk_cnt_16 COUNT6 NOT NULL
Database Tables
Tracking Total 16 trk_ttl_16 MONEY18 NOT NULL
Tracking Count 17 trk_cnt_17 COUNT6 NOT NULL
Tracking Total 17 trk_ttl_17 MONEY18 NOT NULL
Tracking Count 18 trk_cnt_18 COUNT6 NOT NULL
9-294
Tracking Total 18 trk_ttl_18 MONEY18 NOT NULL
Contents 1st Page Index
Revenue Center Shift Employee Tracking Totals
Database Tables
9-295
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Count 19 trk_cnt_19 COUNT6 NOT NULL
Tracking Total 19 trk_ttl_19 MONEY18 NOT NULL
Tracking Count 20 trk_cnt_20 COUNT6 NOT NULL
Tracking Total 20 trk_ttl_20 MONEY18 NOT NULL
Tracking Count 21 trk_cnt_21 COUNT6 NOT NULL
Tracking Total 21 trk_ttl_21 MONEY18 NOT NULL
Tracking Count 22 trk_cnt_22 COUNT6 NOT NULL
Tracking Total 22 trk_ttl_22 MONEY18 NOT NULL
Tracking Count 23 trk_cnt_23 COUNT6 NOT NULL
Tracking Total 23 trk_ttl_23 MONEY18 NOT NULL
Tracking Count 24 trk_cnt_24 COUNT6 NOT NULL
Tracking Total 24 trk_ttl_24 MONEY18 NOT NULL
Tracking Count 25 trk_cnt_25 COUNT6 NOT NULL
Tracking Total 25 trk_ttl_25 MONEY18 NOT NULL
Tracking Count 26 trk_cnt_26 COUNT6 NOT NULL
Tracking Total 26 trk_ttl_26 MONEY18 NOT NULL
Tracking Count 27 trk_cnt_27 COUNT6 NOT NULL
Tracking Total 27 trk_ttl_27 MONEY18 NOT NULL
Tracking Count 28 trk_cnt_28 COUNT6 NOT NULL
Tracking Total 28 trk_ttl_28 MONEY18 NOT NULL
Tracking Count 29 trk_cnt_29 COUNT6 NOT NULL
Tracking Total 29 trk_ttl_29 MONEY18 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Count 30 trk_cnt_30 COUNT6 NOT NULL
Tracking Total 30 trk_ttl_30 MONEY18 NOT NULL
Tracking Count 31 trk_cnt_31 COUNT6 NOT NULL
Tracking Total 31 trk_ttl_31 MONEY18 NOT NULL
Tracking Count 32 trk_cnt_32 COUNT6 NOT NULL
Tracking Total 32 trk_ttl_32 MONEY18 NOT NULL
Tracking Count 33 trk_cnt_33 COUNT6 NOT NULL
Tracking Total 33 trk_ttl_33 MONEY18 NOT NULL
Revenue Center Shift Employee Tracking Totals
Tracking Count 34 trk_cnt_34 COUNT6 NOT NULL
Tracking Total 34 trk_ttl_34 MONEY18 NOT NULL
Tracking Count 35 trk_cnt_35 COUNT6 NOT NULL
Tracking Total 35 trk_ttl_35 MONEY18 NOT NULL
Tracking Count 36 trk_cnt_36 COUNT6 NOT NULL
Tracking Total 36 trk_ttl_36 MONEY18 NOT NULL
Tracking Count 37 trk_cnt_37 COUNT6 NOT NULL
Tracking Total 37 trk_ttl_37 MONEY18 NOT NULL
Tracking Count 38 trk_cnt_38 COUNT6 NOT NULL
Database Tables
Tracking Total 38 trk_ttl_38 MONEY18 NOT NULL
Tracking Count 39 trk_cnt_39 COUNT6 NOT NULL
Tracking Total 39 trk_ttl_39 MONEY18 NOT NULL
Tracking Count 40 trk_cnt_40 COUNT6 NOT NULL
9-296
Tracking Total 40 trk_ttl_40 MONEY18 NOT NULL
Contents 1st Page Index
Revenue Center Shift Employee Tracking Totals
Database Tables
9-297
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Count 41 trk_cnt_41 COUNT6 NOT NULL
Tracking Total 41 trk_ttl_41 MONEY18 NOT NULL
Tracking Count 42 trk_cnt_42 COUNT6 NOT NULL
Tracking Total 42 trk_ttl_42 MONEY18 NOT NULL
Tracking Count 43 trk_cnt_43 COUNT6 NOT NULL
Tracking Total 43 trk_ttl_43 MONEY18 NOT NULL
Tracking Count 44 trk_cnt_44 COUNT6 NOT NULL
Tracking Total 44 trk_ttl_44 MONEY18 NOT NULL
Tracking Count 45 trk_cnt_45 COUNT6 NOT NULL
Tracking Total 45 trk_ttl_45 MONEY18 NOT NULL
Tracking Count 46 trk_cnt_46 COUNT6 NOT NULL
Tracking Total 46 trk_ttl_46 MONEY18 NOT NULL
Tracking Count 47 trk_cnt_47 COUNT6 NOT NULL
Tracking Total 47 trk_ttl_47 MONEY18 NOT NULL
Tracking Count 48 trk_cnt_48 COUNT6 NOT NULL
Tracking Total 48 trk_ttl_48 MONEY18 NOT NULL
Tracking Count 49 trk_cnt_49 COUNT6 NOT NULL
Tracking Total 49 trk_ttl_49 MONEY18 NOT NULL
Tracking Count 50 trk_cnt_50 COUNT6 NOT NULL
Tracking Total 50 trk_ttl_50 MONEY18 NOT NULL
Tracking Count 51 trk_cnt_51 COUNT6 NOT NULL
Tracking Total 51 trk_ttl_51 MONEY18 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Count 52 trk_cnt_52 COUNT6 NOT NULL
Tracking Total 52 trk_ttl_52 MONEY18 NOT NULL
Tracking Count 53 trk_cnt_53 COUNT6 NOT NULL
Tracking Total 53 trk_ttl_53 MONEY18 NOT NULL
Tracking Count 54 trk_cnt_54 COUNT6 NOT NULL
Tracking Total 54 trk_ttl_54 MONEY18 NOT NULL
Tracking Count 55 trk_cnt_55 COUNT6 NOT NULL
Tracking Total 55 trk_ttl_55 MONEY18 NOT NULL
Revenue Center Shift Employee Tracking Totals
Tracking Count 56 trk_cnt_56 COUNT6 NOT NULL
Tracking Total 56 trk_ttl_56 MONEY18 NOT NULL
Tracking Count 57 trk_cnt_57 COUNT6 NOT NULL
Tracking Total 57 trk_ttl_57 MONEY18 NOT NULL
Tracking Count 58 trk_cnt_58 COUNT6 NOT NULL
Tracking Total 58 trk_ttl_58 MONEY18 NOT NULL
Tracking Count 59 trk_cnt_59 COUNT6 NOT NULL
Tracking Total 59 trk_ttl_59 MONEY18 NOT NULL
Tracking Count 60 trk_cnt_60 COUNT6 NOT NULL
Database Tables
Tracking Total 60 trk_ttl_60 MONEY18 NOT NULL
Tracking Count 61 trk_cnt_61 COUNT6 NOT NULL
Tracking Total 61 trk_ttl_61 MONEY18 NOT NULL
Tracking Count 62 trk_cnt_62 COUNT6 NOT NULL
9-298
Tracking Total 62 trk_ttl_62 MONEY18 NOT NULL
Contents 1st Page Index
Revenue Center Shift Employee Tracking Totals
Database Tables
9-299
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Count 63 trk_cnt_63 COUNT6 NOT NULL
Tracking Total 63 trk_ttl_63 MONEY18 NOT NULL
Tracking Count 64 trk_cnt_64 COUNT6 NOT NULL
Tracking Total 64 trk_ttl_64 MONEY18 NOT NULL
Sequence ID em_ttl_repl_seq EM_TTL_SEQ_NUM AK1 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Revenue Center Sign-In Key Status
rvc_sign_in_status
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Rev Ctr Sequence rvc_seq SEQ_NUM PK FK NOT NULL
Sign-In Sequence rvc_sign_in_seq SEQ_NUM PK NOT NULL
Sign-In Employee emp_seq SEQ_NUM FK
Revenue Center Sign-In Key Status
Database Tables
9-300
Contents 1st Page Index
Revenue Center Status
Database Tables
9-301
Revenue Center Status
rvc_status
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Rev Ctr Sequence rvc_seq SEQ_NUM PK FK NOT NULL
Next Guest Check Number next_chk_num CHECK_NUM
Current srv_period_seq SEQ_NUM FK
Sign-In Key Update Counter sign_in_key_update_count NUMERIC(10) NOT NULL
Serial Number 1 serial_num_1 INTEGER
Serial Number 2 serial_num_2 INTEGER
3700 SQL / Database Access Contents 1st Page Index
Revenue Center/System Params (Denormalized View)
rvc_cfg_temp
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Rev Ctr Sequence rvc_seq SEQ_NUM PK FK NOT NULL
Store ID store_id STORE_ID PK FK NOT NULL
Restaurant Name rest_name NAME16
Revenue Center/System Params (Denormalized View)
Location Name 1 location_name_1 NAME16
Location Name 2 location_name_2 NAME16
Revenue Center Name rvc_name NAME16
Revenue Center Number rvc_obj_num OBJ_NUM NOT NULL
Main Menu Level 1 Name main_mlvl_1_name NAME8
Main Menu Level 2 Name main_mlvl_2_name NAME8
Main Menu Level 3 Name main_mlvl_3_name NAME8
Main Menu Level 4 Name main_mlvl_4_name NAME8
Sub Menu Level 1 Name sub_mlvl_1_name NAME8
Sub Menu Level 2 Name sub_mlvl_2_name NAME8
Sub Menu Level 3 Name sub_mlvl_3_name NAME8
Database Tables
Sub Menu Level 4 Name sub_mlvl_4_name NAME8
9-302
Contents 1st Page Index
Rvc Automatic Menu Level
Database Tables
9-303
Rvc Automatic Menu Level
rvc_auto_mlvl_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Rev Ctr Sequence rvc_seq SEQ_NUM PK FK NOT NULL
Auto Menu Lvl Sequence auto_mlvl_seq SEQ_NUM PK NOT NULL
Period Sequence prd_seq SEQ_NUM FK
Number obj_num OBJ_NUM AK1 NOT NULL
Name name OBJ_NAME IE1
Main Menu Level Number main_mlvl MLVL
Sub Menu Level Number sub_mlvl MLVL
Updating Employee last_updated_by SEQ_NUM FK
Last Updated Date last_updated_date DATETIME
3700 SQL / Database Access Contents 1st Page Index
Sale
sale_dtl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Transaction Sequence trans_seq SEQ_NUM PK FK NOT NULL
Order Type Sequence order_type_seq SEQ_NUM FK NOT NULL
Sales Itemizer 1 Total sls_itmzr_01 MONEY12 NOT NULL
Sales Itemizer 2 Total sls_itmzr_02 MONEY12 NOT NULL
Sales Itemizer 3 Total sls_itmzr_03 MONEY12 NOT NULL
Sales Itemizer 4 Total sls_itmzr_04 MONEY12 NOT NULL
Sales Itemizer 5 Total sls_itmzr_05 MONEY12 NOT NULL
Sales Itemizer 6 Total sls_itmzr_06 MONEY12 NOT NULL
Sales Itemizer 7 Total sls_itmzr_07 MONEY12 NOT NULL
Sales Itemizer 8 Total sls_itmzr_08 MONEY12 NOT NULL
Taxable Sales Itemizer 1 Total txbl_sls_itmzr_01 MONEY12 NOT NULL
Taxable Sales Itemizer 2 Total txbl_sls_itmzr_02 MONEY12 NOT NULL
Taxable Sales Itemizer 3 Total txbl_sls_itmzr_03 MONEY12 NOT NULL
Taxable Sales Itemizer 4 Total txbl_sls_itmzr_04 MONEY12 NOT NULL
Database Tables
Taxable Sales Itemizer 5 Total txbl_sls_itmzr_05 MONEY12 NOT NULL
Taxable Sales Itemizer 6 Total txbl_sls_itmzr_06 MONEY12 NOT NULL
Taxable Sales Itemizer 7 Total txbl_sls_itmzr_07 MONEY12 NOT NULL
Taxable Sales Itemizer 8 Total txbl_sls_itmzr_08 MONEY12 NOT NULL
9-304
Sale
Tax Exempt Sales Itemizer 1 Total tax_exempt_sls_itmzr_01 MONEY12 NOT NULL
Contents 1st Page Index
Sale
Database Tables
9-305
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tax Exempt Sales Itemizer 2 Total tax_exempt_sls_itmzr_02 MONEY12 NOT NULL
Tax Exempt Sales Itemizer 3 Total tax_exempt_sls_itmzr_03 MONEY12 NOT NULL
Tax Exempt Sales Itemizer 4 Total tax_exempt_sls_itmzr_04 MONEY12 NOT NULL
Tax Exempt Sales Itemizer 5 Total tax_exempt_sls_itmzr_05 MONEY12 NOT NULL
Tax Exempt Sales Itemizer 6 Total tax_exempt_sls_itmzr_06 MONEY12 NOT NULL
Tax Exempt Sales Itemizer 7 Total tax_exempt_sls_itmzr_07 MONEY12 NOT NULL
Tax Exempt Sales Itemizer 8 Total tax_exempt_sls_itmzr_08 MONEY12 NOT NULL
Tax Itemizer 1 Total tax_itmzr_01 MONEY12 NOT NULL
Tax Itemizer 2 Total tax_itmzr_02 MONEY12 NOT NULL
Tax Itemizer 3 Total tax_itmzr_03 MONEY12 NOT NULL
Tax Itemizer 4 Total tax_itmzr_04 MONEY12 NOT NULL
Tax Itemizer 5 Total tax_itmzr_05 MONEY12 NOT NULL
Tax Itemizer 6 Total tax_itmzr_06 MONEY12 NOT NULL
Tax Itemizer 7 Total tax_itmzr_07 MONEY12 NOT NULL
Tax Itemizer 8 Total tax_itmzr_08 MONEY12 NOT NULL
Auto Service Charge Total auto_svc_ttl MONEY12 NOT NULL
Other Service Charge Total other_svc_ttl MONEY12 NOT NULL
Net Sales Total net_sls_ttl MONEY12 NOT NULL
Return Count rtn_cnt COUNT4 NOT NULL
Return Total rtn_ttl MONEY12 NOT NULL
Void Count void_cnt COUNT4 NOT NULL
Void Total void_ttl MONEY12 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Item Discount Total item_dsc_ttl MONEY12 NOT NULL
Subtotal Discount Total sttl_dsc_ttl MONEY12 NOT NULL
Tax Collected Total tax_coll_ttl MONEY12 NOT NULL
Tax Credit Total credit_ttl MONEY12 NOT NULL
Non Taxable Total non_txbl_ttl MONEY12 NOT NULL
Rounding Total rounding_ttl MONEY12 NOT NULL
Change In Grand Total change_grand_ttl MONEY12 NOT NULL
Payment Total pymnt_ttl MONEY12 NOT NULL
Training Total training_ttl MONEY12 NOT NULL
Cover Count cov_cnt COUNT4 NOT NULL
Guest Check Begun Count chk_begun_cnt COUNT4 NOT NULL
Guest Check Paid Count chk_paid_cnt COUNT4 NOT NULL
Table Turn Count tbl_turn_cnt COUNT4 NOT NULL
Table Dining Duration tbl_dine_time SECONDS NOT NULL
Guest Check Printed Flag ob_sl01_chk_prntd LOGICAL NOT NULL
Gross Receipts Total gross_rcpts MONEY12 NOT NULL
Charge Receipts Total chg_rcpts_ttl MONEY12 NOT NULL
Database Tables
Charged Tip Total charged_tip_ttl MONEY12 NOT NULL
Tip Service Charge Total tip_svc_chg_ttl MONEY12 NOT NULL
Manager Void Count mgr_void_cnt COUNT4 NOT NULL
Manager Void Total mgr_void_ttl MONEY12 NOT NULL
9-306
Sale
Error Correct Count error_correct_cnt COUNT4 NOT NULL
Contents 1st Page Index
Sale
Database Tables
9-307
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Error Correct Total error_correct_ttl MONEY12 NOT NULL
Order Type Changed Flag ob_order_type_changed LOGICAL NOT NULL
Current Order Type Net Sales Total cur_ot_net_sls_ttl MONEY12 NOT NULL
Current Order Type Cover Count cur_ot_cov_cnt COUNT4 NOT NULL
Current Order Type Check Count cur_ot_chk_cnt COUNT4 NOT NULL
Current Order Type Table Turn Count cur_ot_tbl_turn_cnt COUNT4 NOT NULL
Current Order Type Table Dining Time cur_ot_tbl_dine_time SECONDS NOT NULL
Previous Order Type Net Sales Total prev_ot_net_sls_ttl MONEY12 NOT NULL
Previous Order Type Cover Count prev_ot_cov_cnt COUNT4 NOT NULL
Previous Order Type Check Count prev_ot_chk_cnt COUNT4 NOT NULL
Previous Order Type Table Turn Count prev_ot_tbl_turn_cnt COUNT4 NOT NULL
Previous Order Type Table Dining Time prev_ot_tbl_dine_time SECONDS NOT NULL
Previous Order Type prev_order_type_seq SEQ_NUM FK
3700 SQL / Database Access Contents 1st Page Index
Sales Itemizer
sales_itmzr_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Sales Itemizer Sequence sls_itmzr_seq SEQ_NUM PK NOT NULL
Name name NAME12
Updating Employee last_updated_by SEQ_NUM FK
Last Updated Date last_updated_date DATETIME
Database Tables
Sales Itemizer
9-308
Contents 1st Page Index
Schedule Class
Database Tables
9-309
Schedule Class
sched_class_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Schedule Class Sequence sched_class_seq SEQ_NUM PK NOT NULL
Number obj_num OBJ_NUM AK1 NOT NULL
Name name OBJ_NAME
Start Time start_time HHMM
End Time end_time HHMM
Repeat Period repeat_period SECONDS
Schedule Date Type sched_date_type SCHEDULE_DATE_
TYPE
Active Sunday Flag ob_active_sun LOGICAL NOT NULL
Active Monday Flag ob_active_mon LOGICAL NOT NULL
Active Tuesday Flag ob_active_tue LOGICAL NOT NULL
Active Wednesday Flag ob_active_wed LOGICAL NOT NULL
Active Thursday Flag ob_active_thu LOGICAL NOT NULL
Active Friday Flag ob_active_fri LOGICAL NOT NULL
Active Saturday Flag ob_active_sat LOGICAL NOT NULL
Bi-weekly Start Date biweekly_start_date DATETIME
Day of Month 1 day_of_month_1 NUMERIC(2)
Day of Month 2 day_of_month_2 NUMERIC(2)
Day of Month 3 day_of_month_3 NUMERIC(2)
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Day of Month 4 day_of_month_4 NUMERIC(2)
Month of Year 1 month_of_year_1 NUMERIC(2)
Month of Year 2 month_of_year_2 NUMERIC(2)
Month of Year 3 month_of_year_3 NUMERIC(2)
Month of Year 4 month_of_year_4 NUMERIC(2)
Specified Date specified_date DATETIME
Updating Employee last_updated_by SEQ_NUM FK
Last Updated Date last_updated_date DATETIME
Database Tables
Schedule Class
9-310
Contents 1st Page Index
Serving Period Definition
Database Tables
9-311
Serving Period Definition
srv_period_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Serving Period Def Sequence srv_period_seq SEQ_NUM PK NOT NULL
Rev Ctr Sequence rvc_seq SEQ_NUM FK
Period Sequence prd_seq SEQ_NUM FK
Number obj_num OBJ_NUM AK1 NOT NULL
Name name OBJ_NAME IE1
Main Menu Level main_mlvl MLVL
Sub Menu Level sub_mlvl MLVL
Updating Employee last_updated_by SEQ_NUM FK
Last Updated Date last_updated_date DATETIME
3700 SQL / Database Access Contents 1st Page Index
Shift Cashier Dtl
shift_cshr_dtl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Store ID store_id STORE_ID PK FK NOT NULL
Cashier Total Sequence cshr_ttl_seq SEQ_NUM PK FK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Shift Start Date/Time shift_start_time DATETIME NOT NULL
Shift End Date/Time shift_end_time DATETIME
Reserved Logical 1 ob_rsvd01 LOGICAL NOT NULL
Database Tables
Shift Cashier Dtl
9-312
Contents 1st Page Index
Shift Cashier Order Type Totals
Database Tables
9-313
Shift Cashier Order Type Totals
shift_cshr_ot_ttl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Store ID store_id STORE_ID PK FK AK1 NOT NULL
Cashier Total Sequence cshr_ttl_seq SEQ_NUM PK FK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Order Type Sequence order_type_seq SEQ_NUM PK FK NOT NULL
Net Sales Total net_sls_ttl MONEY18 NOT NULL
Check Count chk_cnt COUNT6 NOT NULL
Cover Count cov_cnt COUNT6 NOT NULL
Table Turn Count tbl_turn_cnt COUNT6 NOT NULL
Table Dine Time tbl_dine_time SECONDS NOT NULL
Sequence ID em_ttl_repl_seq EM_TTL_SEQ_NUM AK1 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Shift Cashier Totals
shift_cshr_ttl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Store ID store_id STORE_ID PK FK AK1 NOT NULL
Cashier Total Sequence cshr_ttl_seq SEQ_NUM PK FK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Net Sales Total net_sls_ttl MONEY18 NOT NULL
Item Discount Total item_dsc_ttl MONEY18 NOT NULL
Subtotal Discount Total sttl_dsc_ttl MONEY18 NOT NULL
Service Total svc_ttl MONEY18 NOT NULL
Return Count rtn_cnt COUNT6 NOT NULL
Return Total rtn_ttl MONEY18 NOT NULL
Void Count void_cnt COUNT6 NOT NULL
Void Total void_ttl MONEY18 NOT NULL
Tax Collected Total tax_coll_ttl MONEY18 NOT NULL
Credit Total credit_ttl MONEY18 NOT NULL
Rounding Total rounding_ttl MONEY18 NOT NULL
Shift Cashier Totals
Database Tables
Change in Grand Total change_grand_ttl MONEY18 NOT NULL
Cancel Count cancel_cnt COUNT6 NOT NULL
Cancel Total cancel_ttl MONEY18 NOT NULL
Manager Void Count mgr_void_cnt COUNT6 NOT NULL
9-314
Manager Void Total mgr_void_ttl MONEY18 NOT NULL
Contents 1st Page Index
Shift Cashier Totals
Database Tables
9-315
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Error Correct Count error_correct_cnt COUNT6 NOT NULL
Error Correct Total error_correct_ttl MONEY18 NOT NULL
Check Begun Count chk_begun_cnt COUNT6 NOT NULL
Check Begun Total chk_begun_ttl MONEY18 NOT NULL
Check Paid Count chk_paid_cnt COUNT6 NOT NULL
Check Paid Total chk_paid_ttl MONEY18 NOT NULL
Check Transferred In Count chk_xfer_in_cnt COUNT6 NOT NULL
Check Transferred In Total chk_xfer_in_ttl MONEY18 NOT NULL
Check Transferred Out Count chk_xfer_out_cnt COUNT6 NOT NULL
Check Transferred Out Total chk_xfer_out_ttl MONEY18 NOT NULL
No Sale Count no_sale_cnt COUNT6 NOT NULL
Shift Start Date/Time shift_start_time DATETIME NOT NULL
Shift End Date/Time shift_end_time DATETIME
Sequence ID em_ttl_repl_seq EM_TTL_SEQ_NUM AK1 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Shift Cashier Tracking Total Temp
shift_cshr_trk_ttl_temp
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Cashier Total Sequence cshr_ttl_seq SEQ_NUM PK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Tracking Group Sequence trk_grp_seq SEQ_NUM PK NOT NULL
Tracking Total Sequence trk_ttl_seq SEQ_NUM PK NOT NULL
Count cnt COUNT6
Total ttl MONEY18
Shift Cashier Tracking Total Temp
Database Tables
9-316
Contents 1st Page Index
Shift Cashier Tracking Totals
Database Tables
9-317
Shift Cashier Tracking Totals
shift_cshr_trk_ttl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Store ID store_id STORE_ID PK FK AK1 NOT NULL
Cashier Total Sequence cshr_ttl_seq SEQ_NUM PK FK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Tracking Group Sequence trk_grp_seq SEQ_NUM FK NOT NULL
Tracking Count 1 trk_cnt_01 COUNT6 NOT NULL
Tracking Total 1 trk_ttl_01 MONEY18 NOT NULL
Tracking Count 2 trk_cnt_02 COUNT6 NOT NULL
Tracking Total 2 trk_ttl_02 MONEY18 NOT NULL
Tracking Count 3 trk_cnt_03 COUNT6 NOT NULL
Tracking Total 3 trk_ttl_03 MONEY18 NOT NULL
Tracking Count 4 trk_cnt_04 COUNT6 NOT NULL
Tracking Total 4 trk_ttl_04 MONEY18 NOT NULL
Tracking Count 5 trk_cnt_05 COUNT6 NOT NULL
Tracking Total 5 trk_ttl_05 MONEY18 NOT NULL
Tracking Count 6 trk_cnt_06 COUNT6 NOT NULL
Tracking Total 6 trk_ttl_06 MONEY18 NOT NULL
Tracking Count 7 trk_cnt_07 COUNT6 NOT NULL
Tracking Total 7 trk_ttl_07 MONEY18 NOT NULL
Tracking Count 8 trk_cnt_08 COUNT6 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Total 8 trk_ttl_08 MONEY18 NOT NULL
Tracking Count 9 trk_cnt_09 COUNT6 NOT NULL
Tracking Total 9 trk_ttl_09 MONEY18 NOT NULL
Tracking Count 10 trk_cnt_10 COUNT6 NOT NULL
Tracking Total 10 trk_ttl_10 MONEY18 NOT NULL
Tracking Count 11 trk_cnt_11 COUNT6 NOT NULL
Tracking Total 11 trk_ttl_11 MONEY18 NOT NULL
Tracking Count 12 trk_cnt_12 COUNT6 NOT NULL
Tracking Total 12 trk_ttl_12 MONEY18 NOT NULL
Tracking Count 13 trk_cnt_13 COUNT6 NOT NULL
Tracking Total 13 trk_ttl_13 MONEY18 NOT NULL
Tracking Count 14 trk_cnt_14 COUNT6 NOT NULL
Tracking Total 14 trk_ttl_14 MONEY18 NOT NULL
Tracking Count 15 trk_cnt_15 COUNT6 NOT NULL
Shift Cashier Tracking Totals
Tracking Total 15 trk_ttl_15 MONEY18 NOT NULL
Tracking Count 16 trk_cnt_16 COUNT6 NOT NULL
Tracking Total 16 trk_ttl_16 MONEY18 NOT NULL
Database Tables
Tracking Count 17 trk_cnt_17 COUNT6 NOT NULL
Tracking Total 17 trk_ttl_17 MONEY18 NOT NULL
Tracking Count 18 trk_cnt_18 COUNT6 NOT NULL
Tracking Total 18 trk_ttl_18 MONEY18 NOT NULL
9-318
Tracking Count 19 trk_cnt_19 COUNT6 NOT NULL
Contents 1st Page Index
Shift Cashier Tracking Totals
Database Tables
9-319
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Total 19 trk_ttl_19 MONEY18 NOT NULL
Tracking Count 20 trk_cnt_20 COUNT6 NOT NULL
Tracking Total 20 trk_ttl_20 MONEY18 NOT NULL
Tracking Count 21 trk_cnt_21 COUNT6 NOT NULL
Tracking Total 21 trk_ttl_21 MONEY18 NOT NULL
Tracking Count 22 trk_cnt_22 COUNT6 NOT NULL
Tracking Total 22 trk_ttl_22 MONEY18 NOT NULL
Tracking Count 23 trk_cnt_23 COUNT6 NOT NULL
Tracking Total 23 trk_ttl_23 MONEY18 NOT NULL
Tracking Count 24 trk_cnt_24 COUNT6 NOT NULL
Tracking Total 24 trk_ttl_24 MONEY18 NOT NULL
Tracking Count 25 trk_cnt_25 COUNT6 NOT NULL
Tracking Total 25 trk_ttl_25 MONEY18 NOT NULL
Tracking Count 26 trk_cnt_26 COUNT6 NOT NULL
Tracking Total 26 trk_ttl_26 MONEY18 NOT NULL
Tracking Count 27 trk_cnt_27 COUNT6 NOT NULL
Tracking Total 27 trk_ttl_27 MONEY18 NOT NULL
Tracking Count 28 trk_cnt_28 COUNT6 NOT NULL
Tracking Total 28 trk_ttl_28 MONEY18 NOT NULL
Tracking Count 29 trk_cnt_29 COUNT6 NOT NULL
Tracking Total 29 trk_ttl_29 MONEY18 NOT NULL
Tracking Count 30 trk_cnt_30 COUNT6 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Total 30 trk_ttl_30 MONEY18 NOT NULL
Tracking Count 31 trk_cnt_31 COUNT6 NOT NULL
Tracking Total 31 trk_ttl_31 MONEY18 NOT NULL
Tracking Count 32 trk_cnt_32 COUNT6 NOT NULL
Tracking Total 32 trk_ttl_32 MONEY18 NOT NULL
Tracking Count 33 trk_cnt_33 COUNT6 NOT NULL
Tracking Total 33 trk_ttl_33 MONEY18 NOT NULL
Tracking Count 34 trk_cnt_34 COUNT6 NOT NULL
Tracking Total 34 trk_ttl_34 MONEY18 NOT NULL
Tracking Count 35 trk_cnt_35 COUNT6 NOT NULL
Tracking Total 35 trk_ttl_35 MONEY18 NOT NULL
Tracking Count 36 trk_cnt_36 COUNT6 NOT NULL
Tracking Total 36 trk_ttl_36 MONEY18 NOT NULL
Tracking Count 37 trk_cnt_37 COUNT6 NOT NULL
Shift Cashier Tracking Totals
Tracking Total 37 trk_ttl_37 MONEY18 NOT NULL
Tracking Count 38 trk_cnt_38 COUNT6 NOT NULL
Tracking Total 38 trk_ttl_38 MONEY18 NOT NULL
Database Tables
Tracking Count 39 trk_cnt_39 COUNT6 NOT NULL
Tracking Total 39 trk_ttl_39 MONEY18 NOT NULL
Tracking Count 40 trk_cnt_40 COUNT6 NOT NULL
Tracking Total 40 trk_ttl_40 MONEY18 NOT NULL
9-320
Tracking Count 41 trk_cnt_41 COUNT6 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Total 41 trk_ttl_41 MONEY18 NOT NULL
Tracking Count 42 trk_cnt_42 COUNT6 NOT NULL
Tracking Total 42 trk_ttl_42 MONEY18 NOT NULL
Tracking Count 43 trk_cnt_43 COUNT6 NOT NULL
Tracking Total 43 trk_ttl_43 MONEY18 NOT NULL
Tracking Count 44 trk_cnt_44 COUNT6 NOT NULL
Tracking Total 44 trk_ttl_44 MONEY18 NOT NULL
Tracking Count 45 trk_cnt_45 COUNT6 NOT NULL
Tracking Total 45 trk_ttl_45 MONEY18 NOT NULL
Tracking Count 46 trk_cnt_46 COUNT6 NOT NULL
Tracking Total 46 trk_ttl_46 MONEY18 NOT NULL
Tracking Count 47 trk_cnt_47 COUNT6 NOT NULL
Tracking Total 47 trk_ttl_47 MONEY18 NOT NULL
Tracking Count 48 trk_cnt_48 COUNT6 NOT NULL
Shift Cashier Tracking Totals
Tracking Total 48 trk_ttl_48 MONEY18 NOT NULL
Tracking Count 49 trk_cnt_49 COUNT6 NOT NULL
Tracking Total 49 trk_ttl_49 MONEY18 NOT NULL
Database Tables
Tracking Count 50 trk_cnt_50 COUNT6 NOT NULL
Tracking Total 50 trk_ttl_50 MONEY18 NOT NULL
Tracking Count 51 trk_cnt_51 COUNT6 NOT NULL
Tracking Total 51 trk_ttl_51 MONEY18 NOT NULL
9-321
Tracking Count 52 trk_cnt_52 COUNT6 NOT NULL
Contents 1st Page Index
Shift Cashier Tracking Totals
Database Tables
9-322
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Total 52 trk_ttl_52 MONEY18 NOT NULL
Tracking Count 53 trk_cnt_53 COUNT6 NOT NULL
Tracking Total 53 trk_ttl_53 MONEY18 NOT NULL
Tracking Count 54 trk_cnt_54 COUNT6 NOT NULL
Tracking Total 54 trk_ttl_54 MONEY18 NOT NULL
Tracking Count 55 trk_cnt_55 COUNT6 NOT NULL
Tracking Total 55 trk_ttl_55 MONEY18 NOT NULL
Tracking Count 56 trk_cnt_56 COUNT6 NOT NULL
Tracking Total 56 trk_ttl_56 MONEY18 NOT NULL
Tracking Count 57 trk_cnt_57 COUNT6 NOT NULL
Tracking Total 57 trk_ttl_57 MONEY18 NOT NULL
Tracking Count 58 trk_cnt_58 COUNT6 NOT NULL
Tracking Total 58 trk_ttl_58 MONEY18 NOT NULL
Tracking Count 59 trk_cnt_59 COUNT6 NOT NULL
Tracking Total 59 trk_ttl_59 MONEY18 NOT NULL
Tracking Count 60 trk_cnt_60 COUNT6 NOT NULL
Tracking Total 60 trk_ttl_60 MONEY18 NOT NULL
Tracking Count 61 trk_cnt_61 COUNT6 NOT NULL
Tracking Total 61 trk_ttl_61 MONEY18 NOT NULL
Tracking Count 62 trk_cnt_62 COUNT6 NOT NULL
Tracking Total 62 trk_ttl_62 MONEY18 NOT NULL
Tracking Count 63 trk_cnt_63 COUNT6 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Total 63 trk_ttl_63 MONEY18 NOT NULL
Tracking Count 64 trk_cnt_64 COUNT6 NOT NULL
Tracking Total 64 trk_ttl_64 MONEY18 NOT NULL
Sequence ID em_ttl_repl_seq EM_TTL_SEQ_NUM AK1 NOT NULL
Shift Cashier Tracking Totals
Database Tables
9-323
Contents 1st Page Index
Shift Employee Dtl
Database Tables
9-324
Shift Employee Dtl
shift_emp_dtl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Store ID store_id STORE_ID PK FK NOT NULL
Employee Sequence emp_seq SEQ_NUM PK FK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Shift Start Date/Time shift_start_time DATETIME NOT NULL
Shift End Date/Time shift_end_time DATETIME
Reserved Logical 1 ob_rsvd01 LOGICAL NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Shift Employee Order Type Totals
shift_emp_ot_ttl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Store ID store_id STORE_ID PK FK AK1 NOT NULL
Employee Sequence emp_seq SEQ_NUM PK FK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Order Type Sequence order_type_seq SEQ_NUM PK FK NOT NULL
Net Sales Total net_sls_ttl MONEY18 NOT NULL
Check Count chk_cnt COUNT6 NOT NULL
Cover Count cov_cnt COUNT6 NOT NULL
Table Turn Count tbl_turn_cnt COUNT6 NOT NULL
Table Dine Time tbl_dine_time SECONDS NOT NULL
Sequence ID em_ttl_repl_seq EM_TTL_SEQ_NUM AK1 NOT NULL
Shift Employee Order Type Totals
Database Tables
9-325
Contents 1st Page Index
Shift Employee Total
Database Tables
9-326
Shift Employee Total
shift_emp_ttl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Store ID store_id STORE_ID PK FK AK1 NOT NULL
Employee Sequence emp_seq SEQ_NUM PK FK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Net Sales Total net_sls_ttl MONEY18 NOT NULL
Item Discount Total item_dsc_ttl MONEY18 NOT NULL
Subtotal Discount Total sttl_dsc_ttl MONEY18 NOT NULL
Service Total svc_ttl MONEY18 NOT NULL
Return Count rtn_cnt COUNT6 NOT NULL
Return Total rtn_ttl MONEY18 NOT NULL
Void Count void_cnt COUNT6 NOT NULL
Void Total void_ttl MONEY18 NOT NULL
Tax Collected Total tax_coll_ttl MONEY18 NOT NULL
Credit Total credit_ttl MONEY18 NOT NULL
Rounding Total rounding_ttl MONEY18 NOT NULL
Change in Grand Total change_grand_ttl MONEY18 NOT NULL
Training Total training_ttl MONEY18 NOT NULL
Cancel Count cancel_cnt COUNT6 NOT NULL
Cancel Total cancel_ttl MONEY18 NOT NULL
Manager Void Count mgr_void_cnt COUNT6 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Manager Void Total mgr_void_ttl MONEY18 NOT NULL
Error Correct Count error_correct_cnt COUNT6 NOT NULL
Error Correct Total error_correct_ttl MONEY18 NOT NULL
Checks Carried Over Count chk_carry_over_cnt COUNT6 NOT NULL
Checks Carried Over Total chk_carry_over_ttl MONEY18 NOT NULL
Checks Begun Count chk_begun_cnt COUNT6 NOT NULL
Checks Begun Total chk_begun_ttl MONEY18 NOT NULL
Checks Paid Count chk_paid_cnt COUNT6 NOT NULL
Checks Paid Total chk_paid_ttl MONEY18 NOT NULL
Checks Transferred In Count chk_xfer_in_cnt COUNT6 NOT NULL
Checks Transferred In Total chk_xfer_in_ttl MONEY18 NOT NULL
Checks Transferred Out Count chk_xfer_out_cnt COUNT6 NOT NULL
Checks Transferred Out Total chk_xfer_out_ttl MONEY18 NOT NULL
Cover Count cov_cnt COUNT6 NOT NULL
Check Count chk_cnt COUNT6 NOT NULL
Table Turn Count tbl_turn_cnt COUNT6 NOT NULL
Shift Employee Total
Table Dine Time tbl_dine_time SECONDS NOT NULL
Database Tables
No Sale Count no_sale_cnt COUNT6 NOT NULL
Gross Receipts Total gross_rcpts_ttl MONEY18 NOT NULL
Charged Receipts Total charged_rcpts_ttl MONEY18 NOT NULL
Charged Tips Total charged_tips_ttl MONEY18 NOT NULL
9-327
Tip Service Charge Total tip_svc_ttl MONEY18 NOT NULL
Contents 1st Page Index
Shift Employee Total
Database Tables
9-328
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tips Paid Total tips_paid_ttl MONEY18 NOT NULL
Tips Declared Total tips_decl_ttl MONEY18 NOT NULL
Shift Start Date/Time shift_start_time DATETIME NOT NULL
Shift End Date/Time shift_end_time DATETIME
Sequence ID em_ttl_repl_seq EM_TTL_SEQ_NUM AK1 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Shift Employee Tracking Total Temp
shift_emp_trk_ttl_temp
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Employee Sequence emp_seq SEQ_NUM PK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Tracking Group Sequence trk_grp_seq SEQ_NUM PK NOT NULL
Tracking Total Sequence trk_ttl_seq SEQ_NUM PK NOT NULL
Count cnt COUNT6
Total ttl MONEY18
Shift Employee Tracking Total Temp
Database Tables
9-329
Contents 1st Page Index
Shift Employee Tracking Totals
Database Tables
9-330
Shift Employee Tracking Totals
shift_emp_trk_ttl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Store ID store_id STORE_ID PK FK AK1 NOT NULL
Employee Sequence emp_seq SEQ_NUM PK FK NOT NULL
Shift Sequence Number shift_seq SEQ_NUM PK NOT NULL
Tracking Group Sequence trk_grp_seq SEQ_NUM FK NOT NULL
Tracking Count 1 trk_cnt_01 COUNT6 NOT NULL
Tracking Total 1 trk_ttl_01 MONEY18 NOT NULL
Tracking Count 2 trk_cnt_02 COUNT6 NOT NULL
Tracking Total 2 trk_ttl_02 MONEY18 NOT NULL
Tracking Count 3 trk_cnt_03 COUNT6 NOT NULL
Tracking Total 3 trk_ttl_03 MONEY18 NOT NULL
Tracking Count 4 trk_cnt_04 COUNT6 NOT NULL
Tracking Total 4 trk_ttl_04 MONEY18 NOT NULL
Tracking Count 5 trk_cnt_05 COUNT6 NOT NULL
Tracking Total 5 trk_ttl_05 MONEY18 NOT NULL
Tracking Count 6 trk_cnt_06 COUNT6 NOT NULL
Tracking Total 6 trk_ttl_06 MONEY18 NOT NULL
Tracking Count 7 trk_cnt_07 COUNT6 NOT NULL
Tracking Total 7 trk_ttl_07 MONEY18 NOT NULL
Tracking Count 8 trk_cnt_08 COUNT6 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Total 8 trk_ttl_08 MONEY18 NOT NULL
Tracking Count 9 trk_cnt_09 COUNT6 NOT NULL
Tracking Total 9 trk_ttl_09 MONEY18 NOT NULL
Tracking Count 10 trk_cnt_10 COUNT6 NOT NULL
Tracking Total 10 trk_ttl_10 MONEY18 NOT NULL
Tracking Count 11 trk_cnt_11 COUNT6 NOT NULL
Tracking Total 11 trk_ttl_11 MONEY18 NOT NULL
Tracking Count 12 trk_cnt_12 COUNT6 NOT NULL
Tracking Total 12 trk_ttl_12 MONEY18 NOT NULL
Tracking Count 13 trk_cnt_13 COUNT6 NOT NULL
Tracking Total 13 trk_ttl_13 MONEY18 NOT NULL
Tracking Count 14 trk_cnt_14 COUNT6 NOT NULL
Tracking Total 14 trk_ttl_14 MONEY18 NOT NULL
Shift Employee Tracking Totals
Tracking Count 15 trk_cnt_15 COUNT6 NOT NULL
Tracking Total 15 trk_ttl_15 MONEY18 NOT NULL
Tracking Count 16 trk_cnt_16 COUNT6 NOT NULL
Tracking Total 16 trk_ttl_16 MONEY18 NOT NULL
Database Tables
Tracking Count 17 trk_cnt_17 COUNT6 NOT NULL
Tracking Total 17 trk_ttl_17 MONEY18 NOT NULL
Tracking Count 18 trk_cnt_18 COUNT6 NOT NULL
Tracking Total 18 trk_ttl_18 MONEY18 NOT NULL
9-331
Tracking Count 19 trk_cnt_19 COUNT6 NOT NULL
Contents 1st Page Index
Shift Employee Tracking Totals
Database Tables
9-332
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Total 19 trk_ttl_19 MONEY18 NOT NULL
Tracking Count 20 trk_cnt_20 COUNT6 NOT NULL
Tracking Total 20 trk_ttl_20 MONEY18 NOT NULL
Tracking Count 21 trk_cnt_21 COUNT6 NOT NULL
Tracking Total 21 trk_ttl_21 MONEY18 NOT NULL
Tracking Count 22 trk_cnt_22 COUNT6 NOT NULL
Tracking Total 22 trk_ttl_22 MONEY18 NOT NULL
Tracking Count 23 trk_cnt_23 COUNT6 NOT NULL
Tracking Total 23 trk_ttl_23 MONEY18 NOT NULL
Tracking Count 24 trk_cnt_24 COUNT6 NOT NULL
Tracking Total 24 trk_ttl_24 MONEY18 NOT NULL
Tracking Count 25 trk_cnt_25 COUNT6 NOT NULL
Tracking Total 25 trk_ttl_25 MONEY18 NOT NULL
Tracking Count 26 trk_cnt_26 COUNT6 NOT NULL
Tracking Total 26 trk_ttl_26 MONEY18 NOT NULL
Tracking Count 27 trk_cnt_27 COUNT6 NOT NULL
Tracking Total 27 trk_ttl_27 MONEY18 NOT NULL
Tracking Count 28 trk_cnt_28 COUNT6 NOT NULL
Tracking Total 28 trk_ttl_28 MONEY18 NOT NULL
Tracking Count 29 trk_cnt_29 COUNT6 NOT NULL
Tracking Total 29 trk_ttl_29 MONEY18 NOT NULL
Tracking Count 30 trk_cnt_30 COUNT6 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Total 30 trk_ttl_30 MONEY18 NOT NULL
Tracking Count 31 trk_cnt_31 COUNT6 NOT NULL
Tracking Total 31 trk_ttl_31 MONEY18 NOT NULL
Tracking Count 32 trk_cnt_32 COUNT6 NOT NULL
Tracking Total 32 trk_ttl_32 MONEY18 NOT NULL
Tracking Count 33 trk_cnt_33 COUNT6 NOT NULL
Tracking Total 33 trk_ttl_33 MONEY18 NOT NULL
Tracking Count 34 trk_cnt_34 COUNT6 NOT NULL
Tracking Total 34 trk_ttl_34 MONEY18 NOT NULL
Tracking Count 35 trk_cnt_35 COUNT6 NOT NULL
Tracking Total 35 trk_ttl_35 MONEY18 NOT NULL
Tracking Count 36 trk_cnt_36 COUNT6 NOT NULL
Tracking Total 36 trk_ttl_36 MONEY18 NOT NULL
Shift Employee Tracking Totals
Tracking Count 37 trk_cnt_37 COUNT6 NOT NULL
Tracking Total 37 trk_ttl_37 MONEY18 NOT NULL
Tracking Count 38 trk_cnt_38 COUNT6 NOT NULL
Tracking Total 38 trk_ttl_38 MONEY18 NOT NULL
Database Tables
Tracking Count 39 trk_cnt_39 COUNT6 NOT NULL
Tracking Total 39 trk_ttl_39 MONEY18 NOT NULL
Tracking Count 40 trk_cnt_40 COUNT6 NOT NULL
Tracking Total 40 trk_ttl_40 MONEY18 NOT NULL
9-333
Tracking Count 41 trk_cnt_41 COUNT6 NOT NULL
Contents 1st Page Index
Shift Employee Tracking Totals
Database Tables
9-334
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Total 41 trk_ttl_41 MONEY18 NOT NULL
Tracking Count 42 trk_cnt_42 COUNT6 NOT NULL
Tracking Total 42 trk_ttl_42 MONEY18 NOT NULL
Tracking Count 43 trk_cnt_43 COUNT6 NOT NULL
Tracking Total 43 trk_ttl_43 MONEY18 NOT NULL
Tracking Count 44 trk_cnt_44 COUNT6 NOT NULL
Tracking Total 44 trk_ttl_44 MONEY18 NOT NULL
Tracking Count 45 trk_cnt_45 COUNT6 NOT NULL
Tracking Total 45 trk_ttl_45 MONEY18 NOT NULL
Tracking Count 46 trk_cnt_46 COUNT6 NOT NULL
Tracking Total 46 trk_ttl_46 MONEY18 NOT NULL
Tracking Count 47 trk_cnt_47 COUNT6 NOT NULL
Tracking Total 47 trk_ttl_47 MONEY18 NOT NULL
Tracking Count 48 trk_cnt_48 COUNT6 NOT NULL
Tracking Total 48 trk_ttl_48 MONEY18 NOT NULL
Tracking Count 49 trk_cnt_49 COUNT6 NOT NULL
Tracking Total 49 trk_ttl_49 MONEY18 NOT NULL
Tracking Count 50 trk_cnt_50 COUNT6 NOT NULL
Tracking Total 50 trk_ttl_50 MONEY18 NOT NULL
Tracking Count 51 trk_cnt_51 COUNT6 NOT NULL
Tracking Total 51 trk_ttl_51 MONEY18 NOT NULL
Tracking Count 52 trk_cnt_52 COUNT6 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Total 52 trk_ttl_52 MONEY18 NOT NULL
Tracking Count 53 trk_cnt_53 COUNT6 NOT NULL
Tracking Total 53 trk_ttl_53 MONEY18 NOT NULL
Tracking Count 54 trk_cnt_54 COUNT6 NOT NULL
Tracking Total 54 trk_ttl_54 MONEY18 NOT NULL
Tracking Count 55 trk_cnt_55 COUNT6 NOT NULL
Tracking Total 55 trk_ttl_55 MONEY18 NOT NULL
Tracking Count 56 trk_cnt_56 COUNT6 NOT NULL
Tracking Total 56 trk_ttl_56 MONEY18 NOT NULL
Tracking Count 57 trk_cnt_57 COUNT6 NOT NULL
Tracking Total 57 trk_ttl_57 MONEY18 NOT NULL
Tracking Count 58 trk_cnt_58 COUNT6 NOT NULL
Tracking Total 58 trk_ttl_58 MONEY18 NOT NULL
Shift Employee Tracking Totals
Tracking Count 59 trk_cnt_59 COUNT6 NOT NULL
Tracking Total 59 trk_ttl_59 MONEY18 NOT NULL
Tracking Count 60 trk_cnt_60 COUNT6 NOT NULL
Tracking Total 60 trk_ttl_60 MONEY18 NOT NULL
Database Tables
Tracking Count 61 trk_cnt_61 COUNT6 NOT NULL
Tracking Total 61 trk_ttl_61 MONEY18 NOT NULL
Tracking Count 62 trk_cnt_62 COUNT6 NOT NULL
Tracking Total 62 trk_ttl_62 MONEY18 NOT NULL
9-335
Tracking Count 63 trk_cnt_63 COUNT6 NOT NULL
Contents 1st Page Index
Shift Employee Tracking Totals
Database Tables
9-336
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Total 63 trk_ttl_63 MONEY18 NOT NULL
Tracking Count 64 trk_cnt_64 COUNT6 NOT NULL
Tracking Total 64 trk_ttl_64 MONEY18 NOT NULL
Sequence ID em_ttl_repl_seq EM_TTL_SEQ_NUM AK1 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Stored Procedure
stored_proc_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Stored Procedure Sequence stored_proc_seq SEQ_NUM PK NOT NULL
Number obj_num OBJ_NUM AK1 NOT NULL
Name name VARCHAR(80)
Procedure ID proc_id VARCHAR(80)
Object Type obj_type RPT_OBJ_TYPE
User Visible Flag ob_user_visible LOGICAL NOT NULL
Reserved Logical 1 ob_rsvd01 LOGICAL NOT NULL
Reserved Logical 2 ob_rsvd02 LOGICAL NOT NULL
Updating Employee last_updated_by SEQ_NUM FK
Last Updated Date last_updated_date DATETIME
Stored Procedure
Database Tables
9-337
Contents 1st Page Index
Stored Procedure Parameter
Database Tables
9-338
Stored Procedure Parameter
stored_proc_parm_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Stored Procedure Sequence stored_proc_seq SEQ_NUM PK FK NOT NULL
Parameter Sequence stored_proc_parm_seq SEQ_NUM PK NOT NULL
Name name VARCHAR(80)
Parameter ID parm_id VARCHAR(80)
Parameter Data Type parm_data_type PARM_DATA_TYPE
Default Numeric Value default_numeric_value NUMERIC
Default String Value default_string_value VARCHAR(80)
Maximum String Length max_string_len NUMERIC(2)
User Data Type user_data_type USER_DATA_TYPE
Updating Employee last_updated_by SEQ_NUM FK
3700 SQL / Database Access Contents 1st Page Index
Stored Procedure Parameters Temp
sp_parm_temp
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Process ID process_id INT PK NOT NULL
Starting Business Date start_business_date DATETIME NOT NULL
Ending Business Date end_business_date DATETIME NOT NULL
Employee emp_seq SEQ_NUM
Title title CHAR(60)
Stored Procedure Option sp_option CHAR(32)
Stored Procedure Parameters Temp
Database Tables
9-339
Contents 1st Page Index
Structure Xref Cfg
Database Tables
9-340
Structure Xref Cfg
struct_xref_cfg
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Structure Sequence Number struct_seq INT PK NOT NULL
Table Name table_name VARCHAR(32) PK NOT NULL
Structure Name struct_name VARCHAR(64) NOT NULL
Primary Flag primary_flag LOGICAL
Secondary Select secondary_select VARCHAR(255)
3700 SQL / Database Access Contents 1st Page Index
Table
tbl_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Table Sequence tbl_seq SEQ_NUM PK NOT NULL
Number obj_num OBJ_NUM AK1 NOT NULL
Rev Ctr Sequence rvc_seq SEQ_NUM FK AK1 NOT NULL
Name name NAME4 IE1
Updating Employee last_updated_by SEQ_NUM FK
Last Updated Date last_updated_date DATETIME
Database Tables
Table
9-341
Contents 1st Page Index
Tax Breakpoint
Database Tables
9-342
Tax Breakpoint
tax_brkpt_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tax Rate Sequence tax_rate_seq SEQ_NUM PK FK NOT NULL
Tax Breakpoint Sequence tax_brkpnt_seq SEQ_NUM PK NOT NULL
Amount amt BREAKPOINT
Updating Employee last_updated_by SEQ_NUM FK
3700 SQL / Database Access Contents 1st Page Index
Tax Class
tax_class_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tax Class Sequence tax_class_seq SEQ_NUM PK NOT NULL
Number obj_num OBJ_NUM AK1 NOT NULL
Name name OBJ_NAME IE1
Tax 1 Rate Active ob_tax_1_active LOGICAL NOT NULL
Tax 2 Rate Active ob_tax_2_active LOGICAL NOT NULL
Tax 3 Rate Active ob_tax_3_active LOGICAL NOT NULL
Tax 4 Rate Active ob_tax_4_active LOGICAL NOT NULL
Tax 5 Rate Active ob_tax_5_active LOGICAL NOT NULL
Tax 6 Rate Active ob_tax_6_active LOGICAL NOT NULL
Tax 7 Rate Active ob_tax_7_active LOGICAL NOT NULL
Tax 8 Rate Active ob_tax_8_active LOGICAL NOT NULL
Reserved Logical 1 ob_rsvd01 LOGICAL NOT NULL
Reserved Logical 2 ob_rsvd02 LOGICAL NOT NULL
Reserved Logical 3 ob_rsvd03 LOGICAL NOT NULL
Database Tables
Reserved Logical 4 ob_rsvd04 LOGICAL NOT NULL
Reserved Logical 5 ob_rsvd05 LOGICAL NOT NULL
Reserved Logical 6 ob_rsvd06 LOGICAL NOT NULL
Tax Class
Reserved Logical 7 ob_rsvd07 LOGICAL NOT NULL
9-343
Reserved Logical 8 ob_rsvd08 LOGICAL NOT NULL
Contents 1st Page Index
Tax Class
Database Tables
9-344
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Updating Employee last_updated_by SEQ_NUM FK
Last Updated Date last_updated_date DATETIME
3700 SQL / Database Access Contents 1st Page Index
Tax Rate
tax_rate_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tax Rate Sequence tax_rate_seq SEQ_NUM PK NOT NULL
Name name OBJ_NAME
Tax Collected Name tax_coll_name NAME12
Taxable Sales Name txbl_sls_name NAME12
Tax Exempt Name tax_exempt_name NAME12
Net Sales Name net_sls_name NAME12
Type type TAX_TYPE NOT NULL
Percentage percentage PCNT
Start Amount start_amt MONEY12
Begin Repeated Breakpoint Number brkpt_repeat_start SEQ_NUM
End Repeated Breakpoint Number brkpt_repeat_end SEQ_NUM
CT1 Compound Tax with GST Flag ob_ct01_cmpd_tax_with_gst LOGICAL NOT NULL
CT2 Print Canadian Tax Trailer Flag ob_ct02_prn_canada_tax_trlr LOGICAL NOT NULL
CT11 Threshold 1 Active Flag ob_ct11_thrsh_1_active LOGICAL NOT NULL
Database Tables
CT12 Threshold 1 use if zero Flag ob_ct12_thrsh_1_use_if_zero LOGICAL NOT NULL
CT15 Threshold 1 Include Taxable 2 Flag ob_ct15_thresh_1_incl_txbl_2 LOGICAL NOT NULL
CT16 Threshold 1 Include Taxable 3 Flag ob_ct16_thresh_1_incl_txbl_3 LOGICAL NOT NULL
Tax Rate
CT17 Threshold 1 Include GST Flag ob_ct17_thresh_1_incl_gst LOGICAL NOT NULL
9-345
Canada Tax Threshold 1 Amount canada_tax_thresh_1_amt MONEY12
Contents 1st Page Index
Tax Rate
Database Tables
9-346
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
CT21 Threshold 2 Active Flag ob_ct21_thresh_2_active LOGICAL NOT NULL
CT22 Threshold 2 use if zero Flag ob_ct22_thresh_2_use_if_zero LOGICAL NOT NULL
CT25 Threshold 2 Include Taxable 2 Flag ob_ct25_thresh_2_incl_txbl_2 LOGICAL NOT NULL
CT26 Threshold 2 Include Taxable 3 Flag ob_ct26_thresh_2_incl_txbl_3 LOGICAL NOT NULL
CT27 Threshold 2 Include GST Flag ob_ct27_thresh_2_incl_gst LOGICAL NOT NULL
Canada Tax Threshold 2 Amount canada_tax_thresh_2_amt MONEY12
Reserved Logical 1 ob_rsvd01 LOGICAL NOT NULL
Reserved Logical 2 ob_rsvd02 LOGICAL NOT NULL
Reserved Logical 3 ob_rsvd03 LOGICAL NOT NULL
Reserved Logical 4 ob_rsvd04 LOGICAL NOT NULL
Updating Employee last_updated_by SEQ_NUM FK
Last Updated Date last_updated_date DATETIME
3700 SQL / Database Access Contents 1st Page Index
Tender Preset Amount
preset_tmed_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
TMed Sequence tmed_seq SEQ_NUM PK FK NOT NULL
Preset Tender Amount Sequence preset_tender_amt_seq SEQ_NUM PK AK1 NOT NULL
Name name NAME12
Amount amt MONEY12
NLU Number nlu_num NLU4
Key Number key_num KEY_NUM
TMed SLU Sequence tmed_slu_seq SEQ_NUM FK
Updating Employee last_updated_by SEQ_NUM FK
Tender Preset Amount
Database Tables
9-347
Contents 1st Page Index
Tender/Media
Database Tables
9-348
Tender/Media
tmed_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
TMed Sequence tmed_seq SEQ_NUM PK NOT NULL
Number obj_num OBJ_NUM AK1 NOT NULL
Name name NAME12 IE1
Type type TMED_TYPE IE2 NOT NULL
TMED1 Open Cash Drawer Flag ob_tmed01_open_drwr LOGICAL NOT NULL
TPAY2 Amount Entry Required Flag ob_tpay02_req_amt_entry LOGICAL NOT NULL
TPAY3 Assume Paid In Full Flag ob_tpay03_assume_pd_in_full LOGICAL NOT NULL
TPAY4 Check Endorsement Required Flag ob_tpay04_chk_endorse_req LOGICAL NOT NULL
TMED5 Reference Required Flag ob_tmed05_ref_req LOGICAL NOT NULL
TMED6 Validation Required Flag ob_tmed06_valdtn_req LOGICAL NOT NULL
TPAY10 Post To Gross Receipts Flag ob_tpay10_post_to_gross_rcpt LOGICAL NOT NULL
TPAY11 Post To Charge Receipts Flag ob_tpay11_post_to_chg_rcpts LOGICAL NOT NULL
TMED12 Exempt Auto Service Charge Flag ob_tmed12_exempt_auto_svc LOGICAL NOT NULL
TPAY17 High Amount Lockout Active Flag ob_tpay17_halo_active LOGICAL NOT NULL
TSTL17 Chain Order Flag ob_tstl17_chain_order LOGICAL NOT NULL
TPAY18 High Amount Lockout Operates on ob_tpay18_halo_by_amt LOGICAL NOT NULL
Amount Entry
TSTL18 Do Not Fire Order Flag ob_tstl18_dont_fire_order LOGICAL NOT NULL
TPAY19 Employee Meal Flag ob_tpay19_emp_meal LOGICAL NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
TSTL19 Reprint Check Flag ob_tstl19_reprint_chk LOGICAL NOT NULL
TDEC19 Tips Paid ob_tdec19_tips_paid LOGICAL NOT NULL
TMED20 Print Sales Itemzers Flag ob_tmed20_prn_sls_itmzrs LOGICAL NOT NULL
TMED21 Print Summary Totals Flag ob_tmed21_prn_summ_ttls LOGICAL NOT NULL
TMED22 Print Trailer Flag ob_tmed22_prn_trlr LOGICAL NOT NULL
TMED23 Print Check Flag ob_tmed23_prn_chk LOGICAL NOT NULL
TMED24 Print VAT Total Flag ob_tmed24_prn_vat_ttl LOGICAL NOT NULL
TPAY25 Required Expiration Date Entry Flag ob_tpay25_req_expr_date_entr LOGICAL NOT NULL
TPAY26 Allow Use with Recall Flag ob_tpay26_allow_recall LOGICAL NOT NULL
TMED27 Allow Use with Currecncy Conversion ob_tmed27_allow_curr_cnv LOGICAL NOT NULL
Flag
TPAY28 PMS Post 0 ob_tpay28_pms_post_0 LOGICAL NOT NULL
TPAY29 Print 2 PMS Reference Lines Flag ob_tpay29_prn_2_pms_ref LOGICAL NOT NULL
TPAY30 Use 19 Digit PMS Reference Number ob_tpay30_19_digit_pms_ref LOGICAL NOT NULL
Flag
TPAY31 2800 Enable PMS Flag ob_tpay31_enable_pms LOGICAL NOT NULL
TPAY33 Do not net PMS Posting with Change ob_tpay33_dont_net_pms_chng LOGICAL NOT NULL
Due Flag
TPAY34 Post as Credit Card Outlet Payment to ob_tpay34_cc_post_to_pms LOGICAL NOT NULL
Database Tables
PMS Flag
Tender/Media
TMED35 Print Memo Check Flag ob_tmed35_prn_memo_chk LOGICAL NOT NULL
TSTL36 Print Seat Check Flag ob_tstl36_prn_seat_chk LOGICAL NOT NULL
9-349
TMED37 Increment Filter Flag ob_tmed37_incr_filter LOGICAL NOT NULL
Contents 1st Page Index
Tender/Media
Database Tables
9-350
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
TPAY38 Print FCR Check Flag ob_tpay38_prn_fcr_chk LOGICAL NOT NULL
TPAY39 Post FCR Credit Flag ob_tpay39_post_fcr_credit LOGICAL NOT NULL
TPAY40 Print Personal Check Flag ob_tpay38_prn_personal_chk LOGICAL NOT NULL
TPAY41 Require Credit Authorization Flag ob_tpay41_req_ca LOGICAL NOT NULL
TPAY42 Prompt for CA/EDC Immediate ob_tpay42_prompt_ca_imm_pymt LOGICAL NOT NULL
Payment Flag
TPAY43 Do Not Save PMS Response Flag ob_tpay43_dont_save_pms_resp LOGICAL NOT NULL
TPAY44 Tax Exempt Coupon Flag ob_tpay44_tax_exempt_coupon LOGICAL NOT NULL
TPAY45 Weighed Mod 10 Check Digit Flag ob_tpay45_vrfy_cc_mod_10 LOGICAL NOT NULL
TPAY46 Do not Check Expiration Date Flag ob_tpay46_dont_chk_expr_date LOGICAL NOT NULL
TPAY47 Print with Lookup Flag ob_tpay47_prn_with_lookup LOGICAL NOT NULL
TPAY48 Do Not Validate Expiration Date Flag ob_tpay48_no_valdt_expr_date LOGICAL NOT NULL
TPAY49 Tender must Exceed Tip Flag ob_tpay49_tnd_must_excd_tip LOGICAL NOT NULL
TMED50 Sort Mi By Seat Flag ob_tmed50_sort_mi_by_seat LOGICAL NOT NULL
TPAY51 Prompt for CC Issue Number Flag ob_tpay51_prompt_cc_issu_num LOGICAL NOT NULL
TPAY52 Prompt for Issued Date Flag ob_tpay52_prompt_cc_iss_date LOGICAL NOT NULL
TPAY53 Prompt for Optional Line Flag ob_tpay53_prompt_opt_trlr LOGICAL NOT NULL
TPAY54 Credit Final Amt Required Flag ob_tpay54_cc_final_amt_reqd LOGICAL NOT NULL
TSTL38 Print On receipt Printer Flag ob_tstl38_prn_on_rcpt_prntr LOGICAL NOT NULL
TSTL43 Print Shared Check Flag ob_tstl43_prn_shared_chk LOGICAL NOT NULL
TSTL51 Suspend Transaction Flag ob_tstl51_suspend_trans LOGICAL NOT NULL
Item is Shareable Flag ob_item_shareable LOGICAL NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
TPAY Supress Trailer Printing After Initial ob_tpay_no_trlr_multi_round LOGICAL NOT NULL
Service Round Flag
TPAY Print Thai Tax Accounts Receivable Line ob_tpay_prn_thai_tax_ar_line LOGICAL NOT NULL
Flag
TPAY Print Thai Tax Invoice Line Flag ob_tpay_prn_thai_tax_invoice LOGICAL NOT NULL
TSTL Send Order Flag ob_tstl_send_order LOGICAL NOT NULL
Reserved Logical 1 ob_rsvd01 LOGICAL NOT NULL
Reserved Logical 2 ob_rsvd02 LOGICAL NOT NULL
Reserved Logical 3 ob_rsvd03 LOGICAL NOT NULL
Reserved Logical 4 ob_rsvd04 LOGICAL NOT NULL
Reserved Logical 5 ob_rsvd05 LOGICAL NOT NULL
Reserved Logical 6 ob_rsvd06 LOGICAL NOT NULL
Privilege Level priv_lvl PRIV_LEVEL NOT NULL
Exempt tax_class_seq SEQ_NUM FK
PMS pms SEQ_NUM FK
Menu Lvl Class Sequence mlvl_class_seq SEQ_NUM FK
Prnt Def Class Sequence prn_def_class_seq SEQ_NUM FK
Charged Tip chg_tip_dsvc_seq SEQ_NUM FK
Database Tables
TMed SLU Sequence tmed_slu_seq SEQ_NUM FK
Tender/Media
NLU Number nlu_num NLU4
Key Number key_num KEY_NUM
Icon Resource ID icon_id ICON_ID
9-351
Contents 1st Page Index
Tender/Media
Database Tables
9-352
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
High Lockout Amount halo MONEY12
Category cat TMED_CATEGORY
CA Tip Percent ca_tip_pct PCNT
CA Difference Percent ca_diff_pct PCNT
CA Secondary Floor Limit ca_scndary_flr_limit MONEY12
CA Initial Auth Amount ca_init_auth_amt MONEY12
Effective From Date effective_from DATETIME
Effective To Date effective_to DATETIME
CA Driver ca_driver SEQ_NUM FK
EDC Driver edc_driver SEQ_NUM FK
Updating Employee last_updated_by SEQ_NUM FK
Last Updated Date last_updated_date DATETIME
3700 SQL / Database Access Contents 1st Page Index
Tender/Media Detail
tmed_dtl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Transaction Sequence trans_seq SEQ_NUM PK FK
Detail Sequence dtl_seq SEQ_NUM PK FK
TMed Sequence tmed_seq SEQ_NUM FK NOT NULL
Other other_emp_seq SEQ_NUM FK
Tax Rate 1 Exempt Flag ob_tax_1_exempt LOGICAL NOT NULL
Tax Rate 2 Exempt Flag ob_tax_2_exempt LOGICAL NOT NULL
Tax Rate 3 Exempt Flag ob_tax_3_exempt LOGICAL NOT NULL
Tax Rate 4 Exempt Flag ob_tax_4_exempt LOGICAL NOT NULL
Tax Rate 5 Exempt Flag ob_tax_5_exempt LOGICAL NOT NULL
Tax Rate 6 Exempt Flag ob_tax_6_exempt LOGICAL NOT NULL
Tax Rate 7 Exempt Flag ob_tax_7_exempt LOGICAL NOT NULL
Tax Rate 8 Exempt Flag ob_tax_8_exempt LOGICAL NOT NULL
Account Number cc_acct_num CHAR(20)
Tender/Media Detail
Expiration Date expiration_date CHAR(4)
Database Tables
Charge Tip Total chg_tip_ttl MONEY12 NOT NULL
Allocated Tax Total allocated_tax_ttl MONEY12 NOT NULL
Type Definition type_def BINARY(8) NOT NULL
Immediate Payment Flag ob_immed_pymnt LOGICAL NOT NULL
9-353
Tips Paid Flag ob_tips_paid LOGICAL NOT NULL
Contents 1st Page Index
Tender/Media Detail
Database Tables
9-354
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Foreign Currency Sequence frgn_cncy_seq SEQ_NUM FK
Foreign Currency Total frgn_cncy_ttl FOREIGN_CNCY
Foreign Currency Number of Decimal Places frgn_cncy_num_decimal_places DECIMAL_DIGITS
3700 SQL / Database Access Contents 1st Page Index
Tender/Media Preamble
tmed_preamble_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
TMed Sequence tmed_seq SEQ_NUM PK FK NOT NULL
TMed Preamble Sequence tmed_preamble_seq SEQ_NUM PK NOT NULL
Start Preamble start_preamble CC_PREAMBLE
End Preamble end_preamble CC_PREAMBLE
Number Account Digits num_acct_digits NUMERIC(2)
Updating Employee last_updated_by SEQ_NUM FK
Tender/Media Preamble
Database Tables
9-355
Contents 1st Page Index
Tender/Media SLU
Database Tables
9-356
Tender/Media SLU
tmed_slu_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
TMed SLU Sequence tmed_slu_seq SEQ_NUM PK NOT NULL
Number obj_num OBJ_NUM AK1 NOT NULL
Name name OBJ_NAME IE1
TS Style Sequence ts_style_seq SEQ_NUM FK
Updating Employee last_updated_by SEQ_NUM FK
Last Updated Date last_updated_date DATETIME
3700 SQL / Database Access Contents 1st Page Index
Time and Attendance
time_clock_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Store ID store_id STORE_ID PK FK NOT NULL
Labor Week Start Day lab_wk_start_day WEEKDAY
Hours Before Daily OT hrs_before_daily_otm HOURS
Hours Before Period OT hrs_before_prd_otm HOURS
Regular Paid Minimum Break Duration reg_paid_min_brk_duratn MINUTES
Regular Paid Maximum Break Duration reg_paid_max_brk_duratn MINUTES
Regular Unpaid Minimum Break Duration reg_unpaid_min_brk_duratn MINUTES
Regular Unpaid Maximum Break Duration reg_unpaid_max_brk_duratn MINUTES
Minor Paid Minimum Break Duration minor_paid_min_brk_duratn MINUTES
Minor Paid Maximum Break Duration minor_paid_max_brk_duratn MINUTES
Minor Unpaid Minimum Break Duration minor_unpaid_min_brk_duratn MINUTES
Minor Unpaid Maximum Break Duration minor_unpaid_max_brk_duratn MINUTES
Clk In Early Grace clk_in_early_grace MINUTES
Time and Attendance
Clk In Late Grace clk_in_late_grace MINUTES
Database Tables
Clk Out Early Grace clk_out_early_grace MINUTES
Clk Out Late Grace clk_out_late_grace MINUTES
Labor Category 1 Name lab_cat_1_name OBJ_NAME
Labor Category 2 Name lab_cat_2_name OBJ_NAME
9-357
Labor Category 3 Name lab_cat_3_name OBJ_NAME
Contents 1st Page Index
Time and Attendance
Database Tables
9-358
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Labor Category 4 Name lab_cat_4_name OBJ_NAME
All Labor to Clock-in Business Date Flag ob_all_labor_to_clk_in_date LOGICAL NOT NULL
OB65 Prompt for Break Flag ob_rvc065_prompt_for_brk LOGICAL NOT NULL
OB66 Auth Early Break Flag ob_rvc066_auth_early_brk LOGICAL NOT NULL
OB67 Auth Late Break Flag ob_rvc067_auth_late_brk LOGICAL NOT NULL
OB68 Prompt for Paid Break Flag ob_rvc068_prompt_paid_brk LOGICAL NOT NULL
OB69 Auth Early Paid Break Flag ob_rvc069_auth_early_pd_brk LOGICAL NOT NULL
OB70 Auth Late Paid Break Flag ob_rvc070_auth_late_paid_brk LOGICAL NOT NULL
OB72 Use Time Clock Schedule Flag ob_rvc072_use_tm_clk_sched LOGICAL NOT NULL
OB74 Auth Early Clock In Flag ob_rvc074_auth_early_in_grc LOGICAL NOT NULL
OB76 Auth Late Clock In Grace Flag ob_rvc076_auth_late_in_grc LOGICAL NOT NULL
OB78 Auth Early Clock Out Grace Flag ob_rvc078_auth_early_out_grc LOGICAL NOT NULL
OB80 Auth Late Clock Out Grace Flag ob_rvc080_auth_late_out_grc LOGICAL NOT NULL
Number of Lines on Timecard num_lines_on_tm_card NUMERIC(2)
Pay Period Start Date pay_period_start_date DATETIME
Payroll Type payroll_type PAYROLL_TYPE
Number of Days of Time Card Detail to Store num_days_time_card_dtl NUMERIC(3)
Updating Employee last_updated_by SEQ_NUM FK
Last Updated Date last_updated_date DATETIME
3700 SQL / Database Access Contents 1st Page Index
Time Clock Labor Category Temp
time_clock_lab_cat_temp
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Labor Category lab_cat LABOR_CATEGORY NOT NULL
Name name OBJ_NAME
Time Clock Labor Category Temp
Database Tables
9-359
Contents 1st Page Index
Time Clock Status
Database Tables
9-360
Time Clock Status
time_clock_status
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Store ID store_id STORE_ID PK FK NOT NULL
Earliest Uncomputed Clk In Date and Time compute_from_clk_in_date_tm DATETIME
Last Purge Cutoff Date last_purge_cutoff_date DATETIME
Last Fixed Period Posted Time last_posted_time DATETIME
3700 SQL / Database Access Contents 1st Page Index
Time Period Definition
time_period_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Time Period Def Sequence time_period_seq SEQ_NUM PK NOT NULL
Object Number obj_num OBJ_NUM AK1 NOT NULL
Name name OBJ_NAME IE1
Period Sequence prd_seq SEQ_NUM FK
2800 System Unit Tracking Group Sequence su_trk_grp_seq SEQ_NUM FK
TPRD 2800 Do Not Print Overhead Totals Flag ob_tprd_dont_prn_ohd LOGICAL NOT NULL
Last Updated Date last_updated_date DATETIME
Updating Employee last_updated_by SEQ_NUM FK
Time Period Definition
Database Tables
9-361
Contents 1st Page Index
Tip Declared
Database Tables
9-362
Tip Declared
tip_declared_dtl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Transaction Sequence trans_seq SEQ_NUM PK FK NOT NULL
Declared Amount decl_amt MONEY12 NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Touchscreen Definition
ts_scrn_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
TS Scrn Def Sequence ts_scrn_seq SEQ_NUM PK NOT NULL
Number obj_num OBJ_NUM AK1 NOT NULL
Name name NAME12
Comments comments VARCHAR(80)
TS Layout Sequence ts_layout_seq SEQ_NUM NOT NULL
Updating Employee last_updated_by SEQ_NUM
Last Updated Date last_updated_date DATETIME
Touchscreen Definition
Database Tables
9-363
Contents 1st Page Index
Touchscreen Key
Database Tables
9-364
Touchscreen Key
ts_key_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
TS Scrn Def Sequence ts_scrn_seq SEQ_NUM PK FK NOT NULL
TS Key Sequence ts_key_seq SEQ_NUM PK NOT NULL
Row Start row_start TS_ROW
Column Start col_start TS_COLUMN
Height height TS_HEIGHT
Width width TS_WIDTH
Font font TS_FONT NOT NULL
Color Combination color_combo TS_COLOR NOT NULL
Icon Placement icon_placement TS_ICON_PLACEMENT
Icon Resource ID icon_id ICON_ID
Legend legend NAME16
Key Type key_type KEY_TYPE
Key Number key_num KEY_NUM
Next next SEQ_NUM FK
Updating Employee last_updated_by SEQ_NUM FK
3700 SQL / Database Access Contents 1st Page Index
Touchscreen Layout
ts_layout_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
TS Layout Sequence ts_layout_seq SEQ_NUM PK NOT NULL
Number obj_num OBJ_NUM AK1 NOT NULL
Name name OBJ_NAME
Height height TS_HEIGHT
Width width TS_WIDTH
Updating Employee last_updated_by SEQ_NUM
Last Updated Date last_updated_date DATETIME
Touchscreen Layout
Database Tables
9-365
Contents 1st Page Index
Touchscreen Style
Database Tables
9-366
Touchscreen Style
ts_style_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
TS Style Sequence ts_style_seq SEQ_NUM PK NOT NULL
Number obj_num OBJ_NUM AK1 NOT NULL
Name name NAME12
Height height TS_HEIGHT
Width width TS_WIDTH
Font font TS_FONT NOT NULL
Color Combination color_combo TS_COLOR NOT NULL
Icon Placement icon_placement TS_ICON_PLACEMENT
TSS1 Alphabetize Keys Flag ob_tss01_sort_keys LOGICAL NOT NULL
TSS2 Stay Down Flag ob_tss02_stay_down LOGICAL NOT NULL
TSS3 Condiment Flag ob_tss03_cond LOGICAL NOT NULL
TSS4 Display Menu Item Special Count Flag ob_tss04_mi_count LOGICAL NOT NULL
Reserved Logical 1 ob_rsvd01 LOGICAL NOT NULL
Reserved Logical 2 ob_rsvd02 LOGICAL NOT NULL
Reserved Logical 3 ob_rsvd03 LOGICAL NOT NULL
Reserved Logical 4 ob_rsvd04 LOGICAL NOT NULL
Reserved Logical 5 ob_rsvd05 LOGICAL NOT NULL
Key Arrangement Method key_arrangement TS_ARRANGE_TYPE
Template template SEQ_NUM FK
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Updating Employee last_updated_by SEQ_NUM FK
Last Updated Date last_updated_date DATETIME
Touchscreen Style
Database Tables
9-367
Contents 1st Page Index
Tracking Group Definition
Database Tables
9-368
Tracking Group Definition
trk_grp_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Group Sequence trk_grp_seq SEQ_NUM PK NOT NULL
Object Number obj_num OBJ_NUM AK1 NOT NULL
Name name NAME20 IE1
Tracking Group In Use Flag ob_grp_in_use LOGICAL NOT NULL
Last Updated Date last_updated_date DATETIME
Updating Employee last_updated_by SEQ_NUM FK
3700 SQL / Database Access Contents 1st Page Index
Tracking Group Total Definition
trk_ttl_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Group Sequence trk_grp_seq SEQ_NUM PK FK NOT NULL
Tracking Total Sequence trk_ttl_seq SEQ_NUM PK NOT NULL
Name name NAME20 IE1
Total Type ttl_type TRK_TTL_TYPE IE2
Total Number ttl_num TRK_TTL_NUM
Updating Employee last_updated_by SEQ_NUM FK
Tracking Group Total Definition
Database Tables
9-369
Contents 1st Page Index
Tracking Total Definition Temp
Database Tables
9-370
Tracking Total Definition Temp
trk_ttl_def_temp
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Tracking Group Sequence trk_grp_seq SEQ_NUM PK NOT NULL
Total Name 01 ttl_name_01 NAME20
Total Name 02 ttl_name_02 NAME20
Total Name 03 ttl_name_03 NAME20
Total Name 04 ttl_name_04 NAME20
Total Name 05 ttl_name_05 NAME20
Total Name 06 ttl_name_06 NAME20
Total Name 07 ttl_name_07 NAME20
Total Name 08 ttl_name_08 NAME20
Total Name 09 ttl_name_09 NAME20
Total Name 10 ttl_name_10 NAME20
Total Name 11 ttl_name_11 NAME20
Total Name 12 ttl_name_12 NAME20
Total Name 13 ttl_name_13 NAME20
Total Name 14 ttl_name_14 NAME20
Total Name 15 ttl_name_15 NAME20
Total Name 16 ttl_name_16 NAME20
Total Name 17 ttl_name_17 NAME20
Total Name 18 ttl_name_18 NAME20
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Total Name 19 ttl_name_19 NAME20
Total Name 20 ttl_name_20 NAME20
Total Name 21 ttl_name_21 NAME20
Total Name 22 ttl_name_22 NAME20
Total Name 23 ttl_name_23 NAME20
Total Name 24 ttl_name_24 NAME20
Total Name 25 ttl_name_25 NAME20
Total Name 26 ttl_name_26 NAME20
Total Name 27 ttl_name_27 NAME20
Total Name 28 ttl_name_28 NAME20
Total Name 29 ttl_name_29 NAME20
Total Name 30 ttl_name_30 NAME20
Total Name 31 ttl_name_31 NAME20
Tracking Total Definition Temp
Total Name 32 ttl_name_32 NAME20
Total Name 33 ttl_name_33 NAME20
Total Name 34 ttl_name_34 NAME20
Total Name 35 ttl_name_35 NAME20
Database Tables
Total Name 36 ttl_name_36 NAME20
Total Name 37 ttl_name_37 NAME20
Total Name 38 ttl_name_38 NAME20
Total Name 39 ttl_name_39 NAME20
9-371
Total Name 40 ttl_name_40 NAME20
Contents 1st Page Index
Tracking Total Definition Temp
Database Tables
9-372
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Total Name 41 ttl_name_41 NAME20
Total Name 42 ttl_name_42 NAME20
Total Name 43 ttl_name_43 NAME20
Total Name 44 ttl_name_44 NAME20
Total Name 45 ttl_name_45 NAME20
Total Name 46 ttl_name_46 NAME20
Total Name 47 ttl_name_47 NAME20
Total Name 48 ttl_name_48 NAME20
Total Name 49 ttl_name_49 NAME20
Total Name 50 ttl_name_50 NAME20
Total Name 51 ttl_name_51 NAME20
Total Name 52 ttl_name_52 NAME20
Total Name 53 ttl_name_53 NAME20
Total Name 54 ttl_name_54 NAME20
Total Name 55 ttl_name_55 NAME20
Total Name 56 ttl_name_56 NAME20
Total Name 57 ttl_name_57 NAME20
Total Name 58 ttl_name_58 NAME20
Total Name 59 ttl_name_59 NAME20
Total Name 60 ttl_name_60 NAME20
Total Name 61 ttl_name_61 NAME20
Total Name 62 ttl_name_62 NAME20
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Total Name 63 ttl_name_63 NAME20
Total Name 64 ttl_name_64 NAME20
Tracking Total Definition Temp
Database Tables
9-373
Contents 1st Page Index
Trailer
Database Tables
9-374
Trailer
trlr_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Trailer Sequence trlr_seq SEQ_NUM PK NOT NULL
Number obj_num OBJ_NUM AK1 NOT NULL
Name name NAME16
Line 1 line_01 TEXTLINE32
Line 2 line_02 TEXTLINE32
Line 3 line_03 TEXTLINE32
Line 4 line_04 TEXTLINE32
Line 5 line_05 TEXTLINE32
Line 6 line_06 TEXTLINE32
Line 7 line_07 TEXTLINE32
Line 8 line_08 TEXTLINE32
Line 9 line_09 TEXTLINE32
Line 10 line_10 TEXTLINE32
Line 11 line_11 TEXTLINE32
Line 12 line_12 TEXTLINE32
Print Line 1 in Red ob_print_line_01_red LOGICAL NOT NULL
Print Line 2 in Red ob_print_line_02_red LOGICAL NOT NULL
Print Line 3 in Red ob_print_line_03_red LOGICAL NOT NULL
Print Line 4 in Red ob_print_line_04_red LOGICAL NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Print Line 5 in Red ob_print_line_05_red LOGICAL NOT NULL
Print Line 6 in Red ob_print_line_06_red LOGICAL NOT NULL
Print Line 7 in Red ob_print_line_07_red LOGICAL NOT NULL
Print Line 8 in Red ob_print_line_08_red LOGICAL NOT NULL
Print Line 9 in Red ob_print_line_09_red LOGICAL NOT NULL
Print Line 10 in Red ob_print_line_10_red LOGICAL NOT NULL
Print Line 11 in Red ob_print_line_11_red LOGICAL NOT NULL
Print Line 12 in Red ob_print_line_12_red LOGICAL NOT NULL
Print Line 1 Wide ob_print_line_01_wide LOGICAL NOT NULL
Print Line 2 Wide ob_print_line_02_wide LOGICAL NOT NULL
Print Line 3 Wide ob_print_line_03_wide LOGICAL NOT NULL
Print Line 4 Wide ob_print_line_04_wide LOGICAL NOT NULL
Print Line 5 Wide ob_print_line_05_wide LOGICAL NOT NULL
Print Line 6 Wide ob_print_line_06_wide LOGICAL NOT NULL
Print Line 7 Wide ob_print_line_07_wide LOGICAL NOT NULL
Print Line 8 Wide ob_print_line_08_wide LOGICAL NOT NULL
Print Line 9 Wide ob_print_line_09_wide LOGICAL NOT NULL
Database Tables
Print Line 10 Wide ob_print_line_10_wide LOGICAL NOT NULL
Print Line 11 Wide ob_print_line_11_wide LOGICAL NOT NULL
Print Line 12 Wide ob_print_line_12_wide LOGICAL NOT NULL
Updating Employee last_updated_by SEQ_NUM FK
Trailer
9-375
Last Updated Date last_updated_date DATETIME
Contents 1st Page Index
Transaction
Database Tables
9-376
Transaction
trans_dtl
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Transaction Sequence trans_seq SEQ_NUM PK NOT NULL
Type type TRANS_TYPE NOT NULL
Guest Check Sequence chk_seq SEQ_NUM FK IE1
Rev Ctr Sequence rvc_seq SEQ_NUM FK NOT NULL
Check chk_emp_seq SEQ_NUM FK
Check Employee Shift Sequence Number chk_emp_shift_seq SEQ_NUM
Transaction trans_emp_seq SEQ_NUM FK
Transaction Employee Shift Sequence Number trans_emp_shift_seq SEQ_NUM
Employee Current Job job_seq SEQ_NUM FK
Cashier Total Sequence cshr_ttl_seq SEQ_NUM FK
Cashier Total Shift Sequence Number cshr_ttl_shift_seq SEQ_NUM
Business Date business_date DATETIME NOT NULL
Outside Business Date Flag ob_outside_business_date LOGICAL NOT NULL
Fixed Period Sequence fixed_period_seq SEQ_NUM FK
Start Date and Time start_date_tm DATETIME NOT NULL
End Date and Time end_date_tm DATETIME NOT NULL
Serving Period Def Sequence srv_period_seq SEQ_NUM FK
Training Status training_status TRAINING_STATUS NOT NULL
Closed Check Edit Flag ob_closed_check_edit LOGICAL NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
UWS Sequence uws_seq SEQ_NUM FK NOT NULL
UWS Transaction Number uws_trans_num NUMERIC(4) NOT NULL
Standalone Transaction Sequence standalone_trans_seq SEQ_NUM
2800 Round round INTEGER
Open On System Overridden open_on_sys_uws_seq SEQ_NUM FK
Database Tables
Transaction
9-377
Contents 1st Page Index
User Workstation
Database Tables
9-378
User Workstation
uws_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
UWS Sequence uws_seq SEQ_NUM PK NOT NULL
Number obj_num OBJ_NUM AK1 NOT NULL
Owning rvc_seq SEQ_NUM FK
Color Scheme Sequence color_scheme_seq SEQ_NUM FK
User Workstation uws_dev_seq SEQ_NUM FK AK2 NOT NULL
Default Order Type order_type_seq SEQ_NUM FK
Default Touchscreen ts_scrn_seq SEQ_NUM FK
Default Sign In Help Screen hlp_scrn_seq SEQ_NUM FK
Default Keyboard default_kybd_num NUMERIC(1)
Auto Signoff Duration auto_signoff_duration SECONDS
2800 Open Drawer Timeout open_drwr_timeout POS2800_DRAWER_
TIMEOUT
Overide Guest Check Start Number override_chk_start_num CHECK_NUM
Overide Guest Check End Number override_chk_end_num CHECK_NUM
SU1 Assign Cash Drawer by Workstation Flag ob_su01_assign_drwr_by_ws LOGICAL NOT NULL
SU2 Compulse Cash Drawer Closure Flag ob_su02_compulse_drwr_close LOGICAL NOT NULL
SU3 Disable Keyboard Beep Flag ob_su03_no_kybd_beep LOGICAL NOT NULL
SU4 Disable Error Beep Flag ob_su04_no_error_beep LOGICAL NOT NULL
SU5 Assign Cashier By Workstation Flag ob_su05_assign_cshr_by_ws LOGICAL NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
SU6 Do Not Clear Transaction Screen Flag ob_su06_dont_clr_trans_scrn LOGICAL NOT NULL
SU7 Use Other Cash Drawer for Foreign ob_su07_other_drawer_frgn LOGICAL NOT NULL
Currency Flag
SU8 2800 Use Local ISN Baud Rate Flag ob_su08_lcl_isn_baud_rate LOGICAL NOT NULL
SU9 Enable Automatic Employee Sign Off Flag ob_su09_enable_auto_sign_off LOGICAL NOT NULL
SU11 Format guest checks and receipts in 40 ob_su11_print_40_col LOGICAL NOT NULL
columns flag
SU12 Display Service Total Time Flag ob_su12_disp_svc_ttl_time LOGICAL NOT NULL
SU14 2800 Buffer Mag Card Flag ob_su14_buffer_mag_card LOGICAL NOT NULL
SU15 2800 Allow Open Drawer Flag ob_su15_allow_open_drwr LOGICAL NOT NULL
SU Allow Multiple Revenue Center Flag ob_su_allow_multi_rvc LOGICAL NOT NULL
Allow Keyed ID Entry Flag ob_allow_keyed_id_entry LOGICAL NOT NULL
Workstation is Mono Flag ob_uws_mono LOGICAL NOT NULL
Standalone Enabled Flag ob_standalone_enabled LOGICAL NOT NULL
Number of Color Bits num_color_bits NUM_COLOR_BITS
Number Of Cash Drawers num_drawers NUM_OF_DRAWERS NOT NULL
Client Key Sequence client_key_seq SEQ_NUM AK3 NOT NULL
Enable Order Device 1 Flag ob_enable_ordr_dev_01 LOGICAL NOT NULL
Database Tables
User Workstation
Enable Order Device 2 Flag ob_enable_ordr_dev_02 LOGICAL NOT NULL
Enable Order Device 3 Flag ob_enable_ordr_dev_03 LOGICAL NOT NULL
Enable Order Device 4 Flag ob_enable_ordr_dev_04 LOGICAL NOT NULL
Enable Order Device 5 Flag ob_enable_ordr_dev_05 LOGICAL NOT NULL
9-379
Contents 1st Page Index
User Workstation
Database Tables
9-380
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Enable Order Device 6 Flag ob_enable_ordr_dev_06 LOGICAL NOT NULL
Enable Order Device 7 Flag ob_enable_ordr_dev_07 LOGICAL NOT NULL
Enable Order Device 8 Flag ob_enable_ordr_dev_08 LOGICAL NOT NULL
Enable Order Device 9 Flag ob_enable_ordr_dev_09 LOGICAL NOT NULL
Enable Order Device 10 Flag ob_enable_ordr_dev_10 LOGICAL NOT NULL
Enable Order Device 11 Flag ob_enable_ordr_dev_11 LOGICAL NOT NULL
Enable Order Device 12 Flag ob_enable_ordr_dev_12 LOGICAL NOT NULL
Enable Order Device 13 Flag ob_enable_ordr_dev_13 LOGICAL NOT NULL
Enable Order Device 14 Flag ob_enable_ordr_dev_14 LOGICAL NOT NULL
Enable Order Device 15 Flag ob_enable_ordr_dev_15 LOGICAL NOT NULL
Reserved Logical 1 ob_rsvd01 LOGICAL NOT NULL
Reserved Logical 2 ob_rsvd02 LOGICAL NOT NULL
Reserved Logical 3 ob_rsvd03 LOGICAL NOT NULL
Reserved Logical 4 ob_rsvd04 LOGICAL NOT NULL
Reserved Logical 5 ob_rsvd05 LOGICAL NOT NULL
Reserved Logical 6 ob_rsvd06 LOGICAL NOT NULL
Customer Receipt Printer cust_rcpt_prntr SEQ_NUM FK
Guest Check Printer chk_prntr SEQ_NUM FK
Local Order Printer local_ordr_prntr SEQ_NUM FK
Memo Check Printer memo_chk_prntr SEQ_NUM FK
Validation Printer validation_prntr SEQ_NUM FK
Check Endorsement Printer chk_endorse_prntr SEQ_NUM FK
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
Timecard Printer tm_card_prntr SEQ_NUM FK
Time Chit Printer tm_chit_prntr SEQ_NUM FK
Journal Printer jnl_prntr SEQ_NUM FK
Backup Journal Printer backup_jnl_prntr SEQ_NUM FK
CA Voucher Printer ca_vchr_prntr SEQ_NUM FK
Report Printer rpt_prntr SEQ_NUM FK
Fiscal Cash Register Printer gui_fcr_prntr SEQ_NUM FK
2800 Second Report Printer rpt_prntr_2 SEQ_NUM FK
2800 LDS Printer lds_prntr SEQ_NUM FK
2800 Program Dump Printer prg_dump_prntr SEQ_NUM FK
Backup Local Printer local_bu_prntr SEQ_NUM FK
2800 System Unit Status su_status POS2800_SU_STATUS NOT NULL
Thai Tax UWS RD Number Line thai_tax_uws_rd_num_line TEXTLINE32
Update Counter update_count NUMERIC(10)
Updating Employee last_updated_by SEQ_NUM FK
Last Updated Date last_updated_date DATETIME
Database Tables
User Workstation
9-381
Contents 1st Page Index
UWS Peripheral
Database Tables
9-382
UWS Peripheral
uws_peripheral_def
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
UWS Sequence uws_seq SEQ_NUM PK FK NOT NULL
UWS Peripheral Sequence uws_peripheral_seq SEQ_NUM PK NOT NULL
Peripheral Type peripheral_type PERIPHERAL_TYPE NOT NULL
Connection Type connection_type CONNECTION_TYPE NOT NULL
Configuration String opos_cfg_string CHAR(32)
LAN Node Sequence lan_node_seq SEQ_NUM FK
Communications Port Sequence com_port_seq SEQ_NUM FK
Scanner Data Format Type 1 scanner_format_type_1 SCANNER_FORMAT_
TYPE
Scanner Data String Size 1 scanner_data_string_size_1 SCANNER_DATA_SIZE
Scanner Data Start Byte 1 scanner_data_start_byte_1 NUMERIC(2)
Scanner Data Size 1 scanner_data_size_1 SCANNER_DATA_SIZE
Scanner Data Format Type 2 scanner_format_type_2 SCANNER_FORMAT_T
YPE
Scanner Data String Size 2 scanner_data_string_size_2 SCANNER_DATA_SIZE
Scanner Data Start Byte 2 scanner_data_start_byte_2 NUMERIC(2)
Scanner Data Size 2 scanner_data_size_2 SCANNER_DATA_SIZE
OPOS Option 1 Flag ob_opos_option_1 LOGICAL NOT NULL
OPOS Option 2 Flag ob_opos_option_2 LOGICAL NOT NULL
3700 SQL / Database Access Contents 1st Page Index
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
OPOS Option 3 Flag ob_opos_option_3 LOGICAL NOT NULL
OPOS Option 4 Flag ob_opos_option_4 LOGICAL NOT NULL
OPOS Option 5 Flag ob_opos_option_5 LOGICAL NOT NULL
OPOS Option 6 Flag ob_opos_option_6 LOGICAL NOT NULL
OPOS Option 7 Flag ob_opos_option_7 LOGICAL NOT NULL
OPOS Option 8 Flag ob_opos_option_8 LOGICAL NOT NULL
Updating Employee last_updated_by SEQ_NUM FK
Database Tables
UWS Peripheral
9-383
Contents 1st Page Index
UWS Status
Database Tables
9-384
UWS Status
uws_status
Primary Foreign Alternate Null
Logical Column Name Physical Column Name Column Datatype
Key Key Key Option
UWS Sequence uws_seq SEQ_NUM PK FK NOT NULL
Cashier Total Sequence cshr_ttl_seq SEQ_NUM FK
Next Transaction Number next_trans_num NUMERIC(4)
Override override CHECK_NUM
You might also like
- Chapter-13-Table Creation and Data Manipulation Commands - NOTESNo ratings yetChapter-13-Table Creation and Data Manipulation Commands - NOTES8 pages
- 1741822113-Database (9) - 250405 - 191030No ratings yet1741822113-Database (9) - 250405 - 191030180 pages
- This Study Resource Was: Aim: To Know How The Constraints Are Used To Make Table Is ConsistentNo ratings yetThis Study Resource Was: Aim: To Know How The Constraints Are Used To Make Table Is Consistent6 pages
- DB2 Course: Functions, SQL, and Data ManagementNo ratings yetDB2 Course: Functions, SQL, and Data Management137 pages
- School of Computer Science and Engineering: CSE2004 - Database Management Systems Lab Cycle Sheet - I100% (2)School of Computer Science and Engineering: CSE2004 - Database Management Systems Lab Cycle Sheet - I21 pages
- This Is Only A Guiding Note: Refer To Chapters 6&7 of The Text Book For SQLNo ratings yetThis Is Only A Guiding Note: Refer To Chapters 6&7 of The Text Book For SQL33 pages
- HANA Golden Rule and Performance Guidelines For ABAP Development On ..No ratings yetHANA Golden Rule and Performance Guidelines For ABAP Development On ..4 pages
- Recorder - Problem Solving - Recorder - Verint CommunityNo ratings yetRecorder - Problem Solving - Recorder - Verint Community3 pages
- TR1091 Best Practices With EqualLogic and VMware PDFNo ratings yetTR1091 Best Practices With EqualLogic and VMware PDF35 pages
- 9618 Example Candidate Responses Paper 4 (For Examination From 2021)No ratings yet9618 Example Candidate Responses Paper 4 (For Examination From 2021)40 pages
- Test Code Mytap Mysql Dan Jawaban MahasiswaNo ratings yetTest Code Mytap Mysql Dan Jawaban Mahasiswa17 pages
- 08 - Traditional File Environment and Relational Database Management SystemsNo ratings yet08 - Traditional File Environment and Relational Database Management Systems25 pages
- X.500 and LDAP: Access Protocol (LDAP), A Derivative of The X.500 Protocol Developed AsNo ratings yetX.500 and LDAP: Access Protocol (LDAP), A Derivative of The X.500 Protocol Developed As8 pages
- Tle-Ict Computer Systems Servicing: Quarter 1 - Module 4No ratings yetTle-Ict Computer Systems Servicing: Quarter 1 - Module 410 pages
- Computer Memory.......... : Presented By: Pooja KushwahNo ratings yetComputer Memory.......... : Presented By: Pooja Kushwah13 pages
- CISSP 125 Question Answers and References: Answer Content Where Answers FoundNo ratings yetCISSP 125 Question Answers and References: Answer Content Where Answers Found3 pages
