Array
(
[netshopv_shopos_local] => Array
(
[0] => pos_closing_receipt
[1] => pos_current_cart
[2] => pos_cust_loyalty_generate
[3] => pos_loyalty_detail
[4] => pos_screen_saver
)
)
pos_cust_credit |
Database Name |
Field Name |
Data Type |
Max Length |
Is Nullable |
Column Default |
netshopv_testdb | customer_id | int | | YES | |
netshopv_testdb | order_id | int | | YES | |
netshopv_testdb | return_id | int | | YES | |
netshopv_testdb | staff_id | int | | YES | |
netshopv_testdb | store_id | int | | YES | |
netshopv_testdb | store_id | int | | YES | |
netshopv_testdb | store_id | int | | YES | |
netshopv_testdb | store_id | int | | YES | |
pos_order_detail |
Database Name |
Field Name |
Data Type |
Max Length |
Is Nullable |
Column Default |
netshopv_testdb | order_coupon | varchar | 45 | YES | |
netshopv_testdb | staff_id | int | | YES | |
netshopv_shopos_local | delivery_charge | decimal | | YES | 0.00 |
netshopv_shopos_local | loyalty_amount | decimal | | YES | 0.00 |
netshopv_shopos_local | loyalty_cashi_point | int | | YES | |
netshopv_shopos_local | loyalty_gen_trans_id | varchar | 45 | YES | |
netshopv_shopos_local | loyalty_generate_history | blob | 65535 | YES | |
netshopv_shopos_local | loyalty_generate_point | int | | YES | 0 |
netshopv_shopos_local | loyalty_generate_status | tinyint | | YES | 0 |
netshopv_shopos_local | loyalty_point | int | | YES | 0 |
netshopv_shopos_local | loyalty_redeem_history | blob | 65535 | YES | |
netshopv_testdb | total_amount | decimal | | YES | 0.00 |
netshopv_shopos_local | packaging_charges | decimal | | YES | 0.00 |
netshopv_shopos_local | qr_code_link | text | 65535 | YES | |
netshopv_shopos_local | service_charge | decimal | | YES | 0.00 |
netshopv_shopos_local | speical_discount | decimal | | YES | 0.00 |
netshopv_testdb | total_amount | decimal | | YES | 0.00 |
netshopv_shopos_local | sv_fees | decimal | | YES | 0.00 |
netshopv_shopos_local | total_cess | decimal | | YES | 0.00 |
netshopv_shopos_local | vat_amount | decimal | | YES | 0.00 |
pos_product_category |
Database Name |
Field Name |
Data Type |
Max Length |
Is Nullable |
Column Default |
netshopv_shopos_local | cate_sorting | int | | YES | 0 |
pos_product_detail |
Database Name |
Field Name |
Data Type |
Max Length |
Is Nullable |
Column Default |
netshopv_testdb | product_id | int | | YES | |
netshopv_testdb | upc | varchar | 45 | YES | |
netshopv_shopos_local | vat_tax | decimal | | YES | 0.00 |
pos_product_inventory |
Database Name |
Field Name |
Data Type |
Max Length |
Is Nullable |
Column Default |
netshopv_shopos_local | pro_sell_price | decimal | | YES | 0.00 |
pos_cust_credit |
Database Name |
Field Name |
Data Type |
Max Length |
Is Nullable |
Column Default |
netshopv_testdb | customer_id | int | | YES | |
netshopv_testdb | order_id | int | | YES | |
netshopv_testdb | return_id | int | | YES | |
netshopv_testdb | staff_id | int | | YES | |
netshopv_testdb | store_id | int | | YES | |
netshopv_testdb | store_id | int | | YES | |
netshopv_testdb | store_id | int | | YES | |
netshopv_testdb | store_id | int | | YES | |
pos_order_detail |
Database Name |
Field Name |
Data Type |
Max Length |
Is Nullable |
Column Default |
netshopv_testdb | order_coupon | varchar | 45 | YES | |
netshopv_testdb | staff_id | int | | YES | |
netshopv_shopos_local | delivery_charge | decimal | | YES | 0.00 |
netshopv_shopos_local | loyalty_amount | decimal | | YES | 0.00 |
netshopv_shopos_local | loyalty_cashi_point | int | | YES | |
netshopv_shopos_local | loyalty_gen_trans_id | varchar | 45 | YES | |
netshopv_shopos_local | loyalty_generate_history | blob | 65535 | YES | |
netshopv_shopos_local | loyalty_generate_point | int | | YES | 0 |
netshopv_shopos_local | loyalty_generate_status | tinyint | | YES | 0 |
netshopv_shopos_local | loyalty_point | int | | YES | 0 |
netshopv_shopos_local | loyalty_redeem_history | blob | 65535 | YES | |
netshopv_testdb | total_amount | decimal | | YES | 0.00 |
netshopv_shopos_local | packaging_charges | decimal | | YES | 0.00 |
netshopv_shopos_local | qr_code_link | text | 65535 | YES | |
netshopv_shopos_local | service_charge | decimal | | YES | 0.00 |
netshopv_shopos_local | speical_discount | decimal | | YES | 0.00 |
netshopv_testdb | total_amount | decimal | | YES | 0.00 |
netshopv_shopos_local | sv_fees | decimal | | YES | 0.00 |
netshopv_shopos_local | total_cess | decimal | | YES | 0.00 |
netshopv_shopos_local | vat_amount | decimal | | YES | 0.00 |
pos_product_category |
Database Name |
Field Name |
Data Type |
Max Length |
Is Nullable |
Column Default |
netshopv_shopos_local | cate_sorting | int | | YES | 0 |
pos_product_detail |
Database Name |
Field Name |
Data Type |
Max Length |
Is Nullable |
Column Default |
netshopv_testdb | product_id | int | | YES | |
netshopv_testdb | upc | varchar | 45 | YES | |
netshopv_shopos_local | vat_tax | decimal | | YES | 0.00 |
pos_product_inventory |
Database Name |
Field Name |
Data Type |
Max Length |
Is Nullable |
Column Default |
netshopv_shopos_local | pro_sell_price | decimal | | YES | 0.00 |