POST api/Orders/Postt_orders
Request Information
URI Parameters
None.
Body Parameters
t_ordersName | Description | Type | Additional information |
---|---|---|---|
id | integer |
None. |
|
schoolid | integer |
None. |
|
status | string |
None. |
|
notes | string |
None. |
|
type | string |
None. |
|
pm | string |
None. |
|
origin | string |
None. |
|
payrefid | string |
None. |
|
paynotes | string |
None. |
|
paycurrency | string |
None. |
|
paidtotal | decimal number |
None. |
|
emailsent | boolean |
None. |
|
dor | date |
None. |
|
dos | date |
None. |
|
childid | integer |
None. |
|
vendorid | integer |
None. |
|
staffid | integer |
None. |
|
token | string |
None. |
|
classid | integer |
None. |
|
wallet_amt | decimal number |
None. |
|
change | decimal number |
None. |
|
adminnotes | string |
None. |
|
credit_authrized | boolean |
None. |
|
cancelledby | string |
None. |
|
datecancelled | date |
None. |
|
reason | string |
None. |
|
createby | string |
None. |
|
show_parents | boolean |
None. |
|
balance_reminders | boolean |
None. |
|
cancelled_date | date |
None. |
|
update_by | string |
None. |
|
updatedate | date |
None. |
|
userid | integer |
None. |
|
mergeto | integer |
None. |
|
seq | integer |
None. |
|
orderref | string |
None. |
|
string |
None. |
||
t_childs | t_childs |
None. |
|
t_order_payments | Collection of t_order_payments |
None. |
|
t_vendors | t_vendors |
None. |
|
t_user_wallet | Collection of t_user_wallet |
None. |
|
t_users | t_users |
None. |
|
t_orderentry | Collection of t_orderentry |
None. |
Request Formats
application/json, text/json
Sample:
{ "id": 1, "schoolid": 2, "status": "sample string 3", "notes": "sample string 4", "type": "sample string 5", "pm": "sample string 6", "origin": "sample string 7", "payrefid": "sample string 8", "paynotes": "sample string 9", "paycurrency": "sample string 10", "paidtotal": 1.0, "emailsent": true, "dor": "2024-11-01T13:26:30.8240246+00:00", "dos": "2024-11-01T13:26:30.8240246+00:00", "childid": 1, "vendorid": 11, "staffid": 1, "token": "sample string 12", "classid": 1, "wallet_amt": 1.0, "change": 1.0, "adminnotes": "sample string 13", "credit_authrized": true, "cancelledby": "sample string 14", "datecancelled": "2024-11-01T13:26:30.8240246+00:00", "reason": "sample string 15", "createby": "sample string 16", "show_parents": true, "balance_reminders": true, "cancelled_date": "2024-11-01T13:26:30.8240246+00:00", "update_by": "sample string 19", "updatedate": "2024-11-01T13:26:30.8240246+00:00", "userid": 1, "mergeto": 1, "seq": 20, "orderref": "sample string 21", "email": "sample string 22", "t_childs": { "$id": "2", "id": 1, "schoolid": 2, "classid": 3, "name": "sample string 4", "qrcode": "sample string 5", "code": "sample string 6", "upn": "sample string 7", "dob": "2024-11-01T13:26:30.8240246+00:00", "gender": "sample string 8", "dadcell": "sample string 9", "dadworkphone": "sample string 10", "dadworkemail": "sample string 11", "dadpersonalemail": "sample string 12", "momcell": "sample string 13", "momworkphone": "sample string 14", "momworkemail": "sample string 15", "mompersonalemail": "sample string 16", "healthconditions": "sample string 17", "pic": "sample string 18", "active": true, "notes": "sample string 19", "lastupdated": "2024-11-01T13:26:30.8240246+00:00", "updateby": "sample string 20", "free_meal": true, "breakfast_limit": 1.0, "lunch_limit": 1.0, "snacks_limit": 1.0, "beverages_limit": 1.0, "signupdate": "2024-11-01T13:26:30.8240246+00:00", "deletedate": "2024-11-01T13:26:30.8240246+00:00", "deleteby": "sample string 21", "moeid": 1, "old_upn": "sample string 22", "del_id": 1, "school_email": "sample string 23", "daily_limit": 24.0, "first_name": "sample string 25", "last_name": "sample string 26", "t_childs1": { "$ref": "2" }, "t_childs2": { "$ref": "2" }, "t_school_classes": { "$id": "3", "id": 1, "code": "sample string 2", "name": "sample string 3", "description": "sample string 4", "poc": "sample string 5", "schoolid": 6, "building": "sample string 7", "floor": "sample string 8", "room": "sample string 9", "active": true, "type": "sample string 10", "note": "sample string 11", "yr": "sample string 12", "t_childs": [ { "$ref": "2" }, { "$ref": "2" } ], "t_class_teachers": [ { "$id": "4", "id": 1, "classid": 2, "code": "sample string 3", "name": "sample string 4", "email": "sample string 5", "phone": "sample string 6", "schoolid": 1, "position_title": "sample string 7", "gender": "sample string 8", "childid": 1, "t_school_classes": { "$ref": "3" }, "t_schools": { "$id": "5", "id": 1, "name": "sample string 2", "description": "sample string 3", "poc": "sample string 4", "email": "sample string 5", "phone": "sample string 6", "address": "sample string 7", "active": true, "menu_file": "sample string 8", "isschool": true, "allow_preordering": true, "type": "sample string 9", "logo": "sample string 10", "primary_breakfast_limit": 1.0, "primary_lunch_limit": 1.0, "primary_snacks_limit": 1.0, "primary_beverages_limit": 1.0, "secondary_breakfast_limit": 1.0, "secondary_lunch_limit": 1.0, "secondary_snacks_limit": 1.0, "secondary_beverages_limit": 1.0, "code": "sample string 11", "application_form_file": "sample string 12", "tution_fee_schedule_file": "sample string 13", "infant_supply_list_file": "sample string 14", "toddler_supply_list_file": "sample string 15", "preschooler_supply_list_file": "sample string 16", "kg_supply_list_file": "sample string 17", "grade_supply_list_file": "sample string 18", "school_calender_file": "sample string 19", "yr": "sample string 20", "waitlist_form_file": "sample string 21", "t_childs": [ { "$ref": "2" }, { "$ref": "2" } ], "t_class_teachers": [ { "$ref": "4" }, { "$ref": "4" } ], "t_moe_schools": [ { "$id": "6", "id": 1, "moeid": 1, "schoolid": 1, "active": true, "t_moe": { "$id": "7", "id": 1, "name": "sample string 2", "avatar": "sample string 3", "email": "sample string 4", "phone": "sample string 5", "api_key": "sample string 6", "address": "sample string 7", "city": "sample string 8", "country": "sample string 9", "signupdate": "2024-11-01T13:26:30.8240246+00:00", "status": "sample string 10", "startdate": "2024-11-01T13:26:30.8240246+00:00", "enddate": "2024-11-01T13:26:30.8240246+00:00", "poc": "sample string 11", "email_group": "sample string 12", "notify_newsignups": true, "supportemail": "sample string 13", "privacy_policy": "sample string 14", "t_moe_schools": [ { "$ref": "6" }, { "$ref": "6" } ], "t_moe_staffs": [ { "$id": "8", "id": 1, "name": "sample string 2", "avatar": "sample string 3", "email": "sample string 4", "phone": "sample string 5", "password": "QEA=", "token": "sample string 6", "moeid": 7, "status": "sample string 8", "pospin": "sample string 9", "t_moe": { "$ref": "7" } }, { "$ref": "8" } ], "t_moe_users": [ { "$id": "9", "id": 1, "moeid": 1, "userid": 1, "t_moe": { "$ref": "7" }, "t_users": { "$id": "10", "id": 1, "email": "sample string 2", "phone": "sample string 3", "password": "QEA=", "name": "sample string 4", "address": "sample string 5", "notes": "sample string 6", "type": "sample string 7", "notifyorders": true, "notifypromo": true, "notifylowbal": true, "status": "sample string 8", "lastlogin": "2024-11-01T13:26:30.8240246+00:00", "displayname": "sample string 9", "low_bal_point": 1.0, "createdate": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 10", "avatar": "sample string 11", "token": "sample string 12", "device_token": "sample string 13", "device_id": "sample string 14", "device_type": "sample string 15", "mobile_notifications": true, "tpcode": "sample string 17", "seq": 18, "t_moe_users": [ { "$ref": "9" }, { "$ref": "9" } ], "t_orders": [ { "$ref": "1" }, { "$ref": "1" } ], "t_user_cards": [ { "$id": "11", "id": 1, "user_id": 2, "card_holder": "sample string 3", "card_hash": "sample string 4", "card_id": "sample string 5", "is_default": 1, "created_at": "2024-11-01T13:26:30.8240246+00:00", "updated_at": "2024-11-01T13:26:30.8240246+00:00", "card_type": "sample string 6", "expiry": "sample string 7", "is_deleted": true, "currency": "sample string 8", "t_users": { "$ref": "10" } }, { "$ref": "11" } ], "t_user_childs": [ { "$id": "12", "child_id": 1, "user_id": 2, "id": 3, "relationship": "sample string 4", "court_order": "sample string 5", "t_childs": { "$ref": "2" }, "t_users": { "$ref": "10" } }, { "$ref": "12" } ], "t_notification": [ { "$id": "13", "id": 1, "device_token": "sample string 2", "message": "sample string 3", "createdate": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 4", "type": "sample string 5", "userid": 1, "subject": "sample string 6", "unread": true, "updateby": "sample string 8", "updatedate": "2024-11-01T13:26:30.8240246+00:00", "t_users": { "$ref": "10" } }, { "$ref": "13" } ], "t_vendor_users": [ { "$id": "14", "id": 1, "vendorid": 1, "userid": 1, "t_vendors": { "$id": "15", "id": 1, "business_name": "sample string 2", "address": "sample string 3", "city": "sample string 4", "phone": "sample string 5", "email": "sample string 6", "logo": "sample string 7", "api_key": "sample string 8", "status": "sample string 9", "startdate": "2024-11-01T13:26:30.8240246+00:00", "enddate": "2024-11-01T13:26:30.8240246+00:00", "terms": "sample string 10", "type": "sample string 11", "showprice": true, "currency": "sample string 12", "posscreensections": 1, "supportemail": "sample string 13", "orderbcc": "sample string 14", "ordercc": "sample string 15", "transubline": "sample string 16", "intraip": "sample string 17", "postransubline": "sample string 18", "online_pay": true, "pnp_account": "sample string 19", "pnp_password": "sample string 20", "pnp_url": "sample string 21", "pnp_email": "sample string 22", "pnp_site_key": "sample string 23", "country": "sample string 24", "posthemecolor": "sample string 25", "ItemAccountRef": "sample string 26", "ClassRef": "sample string 27", "qb_invoice_note": "sample string 28", "navbarBgColor": "sample string 29", "navbarTxtColor": "sample string 30", "online_member_signup": true, "change_pos_login": true, "qb_statement_note": "sample string 31", "signupdate": "2024-11-01T13:26:30.8240246+00:00", "guest_memberid": 1, "print_receipt": true, "print_receipt_confirmation": true, "docurl": "sample string 34", "weburl": "sample string 35", "enable_daily_limit": 36, "open_food_item": 1, "head_chief_email": "sample string 37", "notify_production_summary": true, "notify_distribution_summary": true, "posubline": "sample string 39", "notify_payment_summary": true, "notify_query_summary": true, "tag_line": "sample string 40", "about": "sample string 41", "t_moe_vendors": [ { "$id": "16", "id": 1, "moeid": 1, "vendorid": 2, "active": true, "t_moe": { "$ref": "7" }, "t_vendors": { "$ref": "15" } }, { "$ref": "16" } ], "t_orders": [ { "$ref": "1" }, { "$ref": "1" } ], "t_vendor_devices": [ { "$id": "17", "id": 1, "vendorid": 2, "device_token": "sample string 3", "doe": "2024-11-01T13:26:30.8240246+00:00", "t_vendors": { "$ref": "15" } }, { "$ref": "17" } ], "t_vendor_schools": [ { "$id": "18", "id": 1, "schoolid": 2, "vendorid": 3, "active": 1, "t_vendors": { "$ref": "15" }, "t_schools": { "$ref": "5" } }, { "$ref": "18" } ], "t_vendor_staffs": [ { "$id": "19", "id": 1, "name": "sample string 2", "avatar": "sample string 3", "email": "sample string 4", "phone": "sample string 5", "password": "QEA=", "token": "sample string 6", "vendorid": 7, "status": "sample string 8", "pospin": "sample string 9", "mop": "sample string 10", "pic": "sample string 11", "bio": "sample string 12", "show_on_website": true, "job_title": "sample string 14", "t_vendors": { "$ref": "15" } }, { "$ref": "19" } ], "t_vendor_users": [ { "$ref": "14" }, { "$ref": "14" } ], "t_pohdr": [ { "$id": "20", "id": 1, "pon": "sample string 2", "seq": 3, "supplierid": 1, "podate": "2024-11-01T13:26:30.8240246+00:00", "duedate": "2024-11-01T13:26:30.8240246+00:00", "terms": "sample string 4", "notes": "sample string 5", "vendorid": 1, "status": "sample string 6", "type": "sample string 7", "receivedby": "sample string 8", "receiveddate": "2024-11-01T13:26:30.8240246+00:00", "shipto": "sample string 9", "invoiceno": "sample string 10", "currency": "sample string 11", "roe": 12.0, "t_poentry": [ { "$id": "21", "id": 1, "hdrid": 1, "itemid": 1, "code": "sample string 2", "description": "sample string 3", "cost": 4.0, "qty": 5.0, "receivedqty": 6.0, "t_pohdr": { "$ref": "20" }, "t_vendor_items": { "$id": "22", "id": 1, "vendorid": 2, "categoryid": 3, "name": "sample string 4", "description": "sample string 5", "pic": "sample string 6", "status": "sample string 7", "ingredients": "sample string 8", "cost": 1.0, "price": 1.0, "addedby": "sample string 9", "dateadded": "2024-11-01T13:26:30.8240246+00:00", "dateofexpiry": "2024-11-01T13:26:30.8240246+00:00", "frontpage": true, "displayorder": 1, "barcode": "sample string 10", "subtag": "sample string 11", "inventory": true, "seq": 13, "tpcode": "sample string 14", "dateupdated": "2024-11-01T13:26:30.8240246+00:00", "updateby": "sample string 15", "color": "sample string 16", "style": "sample string 17", "gender": "sample string 18", "t_item_categories": { "$id": "23", "id": 1, "name": "sample string 2", "description": "sample string 3", "pic": "sample string 4", "displayorder": 1, "active": true, "type": "sample string 5", "vendorid": 6, "parent_id": 1, "t_vendor_items": [ { "$ref": "22" }, { "$ref": "22" } ] }, "t_item_transactions": [ { "$id": "24", "id": 1, "itemid": 1, "qty": 2.0, "refno": "sample string 3", "txndate": "2024-11-01T13:26:30.8240246+00:00", "tranby": "sample string 4", "txntype": "sample string 5", "notes": "sample string 6", "binid": 1, "t_binlocations": { "$id": "25", "id": 1, "code": "sample string 2", "description": "sample string 3", "active": true, "createby": "sample string 4", "createdate": "2024-11-01T13:26:30.8240246+00:00", "updateby": "sample string 5", "updatedate": "2024-11-01T13:26:30.8240246+00:00", "vendorid": 6, "lvl": "sample string 7", "sec": "sample string 8", "bintype": "sample string 9", "t_item_transactions": [ { "$ref": "24" }, { "$ref": "24" } ] }, "t_vendor_items": { "$ref": "22" } }, { "$ref": "24" } ], "t_poentry": [ { "$ref": "21" }, { "$ref": "21" } ], "t_standing_orderentry": [ { "$id": "26", "id": 1, "itemid": 1, "description": "sample string 2", "qty": 1.0, "price": 1.0, "orderid": 1, "discount": 3.0, "pic": "sample string 4", "tag": "sample string 5", "subtag": "sample string 6", "t_standing_orders": { "$id": "27", "id": 1, "childid": 1, "vendorid": 1, "notes": "sample string 2", "delivery_instructions": "sample string 3", "status": "sample string 4", "notify_parent": true, "recurr_pattern": "sample string 5", "standing_days": "sample string 6", "createdate": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 7", "updatedate": "2024-11-01T13:26:30.8240246+00:00", "updateby": "sample string 8", "t_childs": { "$ref": "2" }, "t_standing_orderentry": [ { "$ref": "26" }, { "$ref": "26" } ], "t_vendors": { "$ref": "15" } }, "t_vendor_items": { "$ref": "22" } }, { "$ref": "26" } ], "t_vendors": { "$ref": "15" }, "t_orderentry": [ { "$id": "28", "id": 1, "itemid": 1, "description": "sample string 2", "qty": 3.0, "price": 4.0, "orderid": 1, "pic": "sample string 5", "tag": "sample string 6", "subtag": "sample string 7", "oldorderid": 1, "discount": 8.0, "t_vendor_items": { "$ref": "22" }, "t_orders": { "$ref": "1" } }, { "$ref": "28" } ] } }, { "$ref": "21" } ], "t_suppliers": { "$id": "29", "id": 1, "name": "sample string 2", "email": "sample string 3", "address": "sample string 4", "phone": "sample string 5", "vendorid": 1, "active": true, "t_pohdr": [ { "$ref": "20" }, { "$ref": "20" } ] }, "t_vendors": { "$ref": "15" } }, { "$ref": "20" } ], "t_standing_orders": [ { "$ref": "27" }, { "$ref": "27" } ], "t_vendor_items": [ { "$ref": "22" }, { "$ref": "22" } ], "t_vendor_terms": [ { "$id": "30", "id": 1, "description": "sample string 2", "createdate": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 3", "updateby": "sample string 4", "updatedate": "2024-11-01T13:26:30.8240246+00:00", "vendorid": 1, "t_vendors": { "$ref": "15" } }, { "$ref": "30" } ], "t_events": [ { "$id": "31", "id": 1, "subject": "sample string 2", "details": "sample string 3", "vdo_url": "sample string 4", "pic_url": "sample string 5", "start_date": "2024-11-01T13:26:30.8240246+00:00", "end_date": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 7", "createdate": "2024-11-01T13:26:30.8240246+00:00", "vendorid": 1, "uk": "13dcbbcc-71ff-43ce-a95c-761ce5da0522", "status": "sample string 8", "type": "sample string 9", "t_event_enrollments": [ { "$id": "32", "id": 1, "eventid": 1, "name": "sample string 2", "email": "sample string 3", "phone": "sample string 4", "address": "sample string 5", "status": "sample string 6", "createdate": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 7", "t_events": { "$ref": "31" } }, { "$ref": "32" } ], "t_vendors": { "$ref": "15" } }, { "$ref": "31" } ], "t_waitlist": [ { "$id": "33", "id": 1, "schoolid": 1, "referred": true, "referred_by": "sample string 2", "first_name": "sample string 3", "last_name": "sample string 4", "initial": "sample string 5", "dob": "2024-11-01T13:26:30.8240246+00:00", "sex": "sample string 6", "fulltime": true, "meals": true, "grade": "sample string 7", "parent_name": "sample string 8", "parent_email": "sample string 9", "parent_phone": "sample string 10", "parent_address": "sample string 11", "parent_country": "sample string 12", "createby": "sample string 13", "createdate": "2024-11-01T13:26:30.8240246+00:00", "vendorid": 1, "t_vendors": { "$ref": "15" }, "t_schools": { "$ref": "5" } }, { "$ref": "33" } ], "t_agency_terms": [ { "$id": "34", "id": 1, "description": "sample string 2", "createdate": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 3", "updateby": "sample string 4", "updatedate": "2024-11-01T13:26:30.8240246+00:00", "vendorid": 1, "t_vendors": { "$ref": "15" } }, { "$ref": "34" } ] }, "t_users": { "$ref": "10" } }, { "$ref": "14" } ] } }, { "$ref": "9" } ], "t_moe_vendors": [ { "$ref": "16" }, { "$ref": "16" } ] }, "t_schools": { "$ref": "5" } }, { "$ref": "6" } ], "t_school_childs": [ { "$id": "35", "childid": 1, "schoolid": 1, "id": 1, "t_childs": { "$ref": "2" }, "t_schools": { "$ref": "5" } }, { "$ref": "35" } ], "t_school_classes": [ { "$ref": "3" }, { "$ref": "3" } ], "t_waitlist": [ { "$ref": "33" }, { "$ref": "33" } ], "t_vendor_schools": [ { "$ref": "18" }, { "$ref": "18" } ] } }, { "$ref": "4" } ], "t_schools": { "$ref": "5" } }, "t_orders": [ { "$ref": "1" }, { "$ref": "1" } ], "t_user_childs": [ { "$ref": "12" }, { "$ref": "12" } ], "t_school_childs": [ { "$ref": "35" }, { "$ref": "35" } ], "t_standing_orders": [ { "$ref": "27" }, { "$ref": "27" } ], "t_carts": [ { "$id": "36", "id": 1, "cartid": "sample string 2", "prodid": 3, "qty": 4.0, "datecreated": "2024-11-01T13:26:30.8240246+00:00", "price": 6.0, "ilc": "sample string 7", "description": "sample string 8", "pic": "sample string 9", "saveforlater": true, "scheduledate": "2024-11-01T13:26:30.8240246+00:00", "childid": 1, "checkout": 1, "tag": "sample string 11", "vendorid": 12, "subtag": "sample string 13", "t_childs": { "$ref": "2" } }, { "$ref": "36" } ], "t_schools": { "$ref": "5" } }, "t_order_payments": [ { "$id": "37", "id": 1, "orderid": 1, "amount": 2.0, "narration": "sample string 3", "trandate": "2024-11-01T13:26:30.8240246+00:00", "tranby": "sample string 4", "pm": "sample string 5", "change": 6.0, "t_orders": { "$ref": "1" } }, { "$ref": "37" } ], "t_vendors": { "$ref": "15" }, "t_user_wallet": [ { "$id": "38", "id": 1, "amount": 2.0, "narration": "sample string 3", "type": "sample string 4", "trandate": "2024-11-01T13:26:30.8240246+00:00", "tranby": "sample string 6", "pm": "sample string 7", "payref": "sample string 8", "currency": "sample string 9", "userid": 1, "vendorid": 1, "orderid": 1, "t_orders": { "$ref": "1" } }, { "$ref": "38" } ], "t_users": { "$ref": "10" }, "t_orderentry": [ { "$ref": "28" }, { "$ref": "28" } ] }
Response Information
Resource Description
t_ordersName | Description | Type | Additional information |
---|---|---|---|
id | integer |
None. |
|
schoolid | integer |
None. |
|
status | string |
None. |
|
notes | string |
None. |
|
type | string |
None. |
|
pm | string |
None. |
|
origin | string |
None. |
|
payrefid | string |
None. |
|
paynotes | string |
None. |
|
paycurrency | string |
None. |
|
paidtotal | decimal number |
None. |
|
emailsent | boolean |
None. |
|
dor | date |
None. |
|
dos | date |
None. |
|
childid | integer |
None. |
|
vendorid | integer |
None. |
|
staffid | integer |
None. |
|
token | string |
None. |
|
classid | integer |
None. |
|
wallet_amt | decimal number |
None. |
|
change | decimal number |
None. |
|
adminnotes | string |
None. |
|
credit_authrized | boolean |
None. |
|
cancelledby | string |
None. |
|
datecancelled | date |
None. |
|
reason | string |
None. |
|
createby | string |
None. |
|
show_parents | boolean |
None. |
|
balance_reminders | boolean |
None. |
|
cancelled_date | date |
None. |
|
update_by | string |
None. |
|
updatedate | date |
None. |
|
userid | integer |
None. |
|
mergeto | integer |
None. |
|
seq | integer |
None. |
|
orderref | string |
None. |
|
string |
None. |
||
t_childs | t_childs |
None. |
|
t_order_payments | Collection of t_order_payments |
None. |
|
t_vendors | t_vendors |
None. |
|
t_user_wallet | Collection of t_user_wallet |
None. |
|
t_users | t_users |
None. |
|
t_orderentry | Collection of t_orderentry |
None. |
Response Formats
application/json, text/json
Sample:
{ "id": 1, "schoolid": 2, "status": "sample string 3", "notes": "sample string 4", "type": "sample string 5", "pm": "sample string 6", "origin": "sample string 7", "payrefid": "sample string 8", "paynotes": "sample string 9", "paycurrency": "sample string 10", "paidtotal": 1.0, "emailsent": true, "dor": "2024-11-01T13:26:30.8240246+00:00", "dos": "2024-11-01T13:26:30.8240246+00:00", "childid": 1, "vendorid": 11, "staffid": 1, "token": "sample string 12", "classid": 1, "wallet_amt": 1.0, "change": 1.0, "adminnotes": "sample string 13", "credit_authrized": true, "cancelledby": "sample string 14", "datecancelled": "2024-11-01T13:26:30.8240246+00:00", "reason": "sample string 15", "createby": "sample string 16", "show_parents": true, "balance_reminders": true, "cancelled_date": "2024-11-01T13:26:30.8240246+00:00", "update_by": "sample string 19", "updatedate": "2024-11-01T13:26:30.8240246+00:00", "userid": 1, "mergeto": 1, "seq": 20, "orderref": "sample string 21", "email": "sample string 22", "t_childs": { "$id": "2", "id": 1, "schoolid": 2, "classid": 3, "name": "sample string 4", "qrcode": "sample string 5", "code": "sample string 6", "upn": "sample string 7", "dob": "2024-11-01T13:26:30.8240246+00:00", "gender": "sample string 8", "dadcell": "sample string 9", "dadworkphone": "sample string 10", "dadworkemail": "sample string 11", "dadpersonalemail": "sample string 12", "momcell": "sample string 13", "momworkphone": "sample string 14", "momworkemail": "sample string 15", "mompersonalemail": "sample string 16", "healthconditions": "sample string 17", "pic": "sample string 18", "active": true, "notes": "sample string 19", "lastupdated": "2024-11-01T13:26:30.8240246+00:00", "updateby": "sample string 20", "free_meal": true, "breakfast_limit": 1.0, "lunch_limit": 1.0, "snacks_limit": 1.0, "beverages_limit": 1.0, "signupdate": "2024-11-01T13:26:30.8240246+00:00", "deletedate": "2024-11-01T13:26:30.8240246+00:00", "deleteby": "sample string 21", "moeid": 1, "old_upn": "sample string 22", "del_id": 1, "school_email": "sample string 23", "daily_limit": 24.0, "first_name": "sample string 25", "last_name": "sample string 26", "t_childs1": { "$ref": "2" }, "t_childs2": { "$ref": "2" }, "t_school_classes": { "$id": "3", "id": 1, "code": "sample string 2", "name": "sample string 3", "description": "sample string 4", "poc": "sample string 5", "schoolid": 6, "building": "sample string 7", "floor": "sample string 8", "room": "sample string 9", "active": true, "type": "sample string 10", "note": "sample string 11", "yr": "sample string 12", "t_childs": [ { "$ref": "2" }, { "$ref": "2" } ], "t_class_teachers": [ { "$id": "4", "id": 1, "classid": 2, "code": "sample string 3", "name": "sample string 4", "email": "sample string 5", "phone": "sample string 6", "schoolid": 1, "position_title": "sample string 7", "gender": "sample string 8", "childid": 1, "t_school_classes": { "$ref": "3" }, "t_schools": { "$id": "5", "id": 1, "name": "sample string 2", "description": "sample string 3", "poc": "sample string 4", "email": "sample string 5", "phone": "sample string 6", "address": "sample string 7", "active": true, "menu_file": "sample string 8", "isschool": true, "allow_preordering": true, "type": "sample string 9", "logo": "sample string 10", "primary_breakfast_limit": 1.0, "primary_lunch_limit": 1.0, "primary_snacks_limit": 1.0, "primary_beverages_limit": 1.0, "secondary_breakfast_limit": 1.0, "secondary_lunch_limit": 1.0, "secondary_snacks_limit": 1.0, "secondary_beverages_limit": 1.0, "code": "sample string 11", "application_form_file": "sample string 12", "tution_fee_schedule_file": "sample string 13", "infant_supply_list_file": "sample string 14", "toddler_supply_list_file": "sample string 15", "preschooler_supply_list_file": "sample string 16", "kg_supply_list_file": "sample string 17", "grade_supply_list_file": "sample string 18", "school_calender_file": "sample string 19", "yr": "sample string 20", "waitlist_form_file": "sample string 21", "t_childs": [ { "$ref": "2" }, { "$ref": "2" } ], "t_class_teachers": [ { "$ref": "4" }, { "$ref": "4" } ], "t_moe_schools": [ { "$id": "6", "id": 1, "moeid": 1, "schoolid": 1, "active": true, "t_moe": { "$id": "7", "id": 1, "name": "sample string 2", "avatar": "sample string 3", "email": "sample string 4", "phone": "sample string 5", "api_key": "sample string 6", "address": "sample string 7", "city": "sample string 8", "country": "sample string 9", "signupdate": "2024-11-01T13:26:30.8240246+00:00", "status": "sample string 10", "startdate": "2024-11-01T13:26:30.8240246+00:00", "enddate": "2024-11-01T13:26:30.8240246+00:00", "poc": "sample string 11", "email_group": "sample string 12", "notify_newsignups": true, "supportemail": "sample string 13", "privacy_policy": "sample string 14", "t_moe_schools": [ { "$ref": "6" }, { "$ref": "6" } ], "t_moe_staffs": [ { "$id": "8", "id": 1, "name": "sample string 2", "avatar": "sample string 3", "email": "sample string 4", "phone": "sample string 5", "password": "QEA=", "token": "sample string 6", "moeid": 7, "status": "sample string 8", "pospin": "sample string 9", "t_moe": { "$ref": "7" } }, { "$ref": "8" } ], "t_moe_users": [ { "$id": "9", "id": 1, "moeid": 1, "userid": 1, "t_moe": { "$ref": "7" }, "t_users": { "$id": "10", "id": 1, "email": "sample string 2", "phone": "sample string 3", "password": "QEA=", "name": "sample string 4", "address": "sample string 5", "notes": "sample string 6", "type": "sample string 7", "notifyorders": true, "notifypromo": true, "notifylowbal": true, "status": "sample string 8", "lastlogin": "2024-11-01T13:26:30.8240246+00:00", "displayname": "sample string 9", "low_bal_point": 1.0, "createdate": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 10", "avatar": "sample string 11", "token": "sample string 12", "device_token": "sample string 13", "device_id": "sample string 14", "device_type": "sample string 15", "mobile_notifications": true, "tpcode": "sample string 17", "seq": 18, "t_moe_users": [ { "$ref": "9" }, { "$ref": "9" } ], "t_orders": [ { "$ref": "1" }, { "$ref": "1" } ], "t_user_cards": [ { "$id": "11", "id": 1, "user_id": 2, "card_holder": "sample string 3", "card_hash": "sample string 4", "card_id": "sample string 5", "is_default": 1, "created_at": "2024-11-01T13:26:30.8240246+00:00", "updated_at": "2024-11-01T13:26:30.8240246+00:00", "card_type": "sample string 6", "expiry": "sample string 7", "is_deleted": true, "currency": "sample string 8", "t_users": { "$ref": "10" } }, { "$ref": "11" } ], "t_user_childs": [ { "$id": "12", "child_id": 1, "user_id": 2, "id": 3, "relationship": "sample string 4", "court_order": "sample string 5", "t_childs": { "$ref": "2" }, "t_users": { "$ref": "10" } }, { "$ref": "12" } ], "t_notification": [ { "$id": "13", "id": 1, "device_token": "sample string 2", "message": "sample string 3", "createdate": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 4", "type": "sample string 5", "userid": 1, "subject": "sample string 6", "unread": true, "updateby": "sample string 8", "updatedate": "2024-11-01T13:26:30.8240246+00:00", "t_users": { "$ref": "10" } }, { "$ref": "13" } ], "t_vendor_users": [ { "$id": "14", "id": 1, "vendorid": 1, "userid": 1, "t_vendors": { "$id": "15", "id": 1, "business_name": "sample string 2", "address": "sample string 3", "city": "sample string 4", "phone": "sample string 5", "email": "sample string 6", "logo": "sample string 7", "api_key": "sample string 8", "status": "sample string 9", "startdate": "2024-11-01T13:26:30.8240246+00:00", "enddate": "2024-11-01T13:26:30.8240246+00:00", "terms": "sample string 10", "type": "sample string 11", "showprice": true, "currency": "sample string 12", "posscreensections": 1, "supportemail": "sample string 13", "orderbcc": "sample string 14", "ordercc": "sample string 15", "transubline": "sample string 16", "intraip": "sample string 17", "postransubline": "sample string 18", "online_pay": true, "pnp_account": "sample string 19", "pnp_password": "sample string 20", "pnp_url": "sample string 21", "pnp_email": "sample string 22", "pnp_site_key": "sample string 23", "country": "sample string 24", "posthemecolor": "sample string 25", "ItemAccountRef": "sample string 26", "ClassRef": "sample string 27", "qb_invoice_note": "sample string 28", "navbarBgColor": "sample string 29", "navbarTxtColor": "sample string 30", "online_member_signup": true, "change_pos_login": true, "qb_statement_note": "sample string 31", "signupdate": "2024-11-01T13:26:30.8240246+00:00", "guest_memberid": 1, "print_receipt": true, "print_receipt_confirmation": true, "docurl": "sample string 34", "weburl": "sample string 35", "enable_daily_limit": 36, "open_food_item": 1, "head_chief_email": "sample string 37", "notify_production_summary": true, "notify_distribution_summary": true, "posubline": "sample string 39", "notify_payment_summary": true, "notify_query_summary": true, "tag_line": "sample string 40", "about": "sample string 41", "t_moe_vendors": [ { "$id": "16", "id": 1, "moeid": 1, "vendorid": 2, "active": true, "t_moe": { "$ref": "7" }, "t_vendors": { "$ref": "15" } }, { "$ref": "16" } ], "t_orders": [ { "$ref": "1" }, { "$ref": "1" } ], "t_vendor_devices": [ { "$id": "17", "id": 1, "vendorid": 2, "device_token": "sample string 3", "doe": "2024-11-01T13:26:30.8240246+00:00", "t_vendors": { "$ref": "15" } }, { "$ref": "17" } ], "t_vendor_schools": [ { "$id": "18", "id": 1, "schoolid": 2, "vendorid": 3, "active": 1, "t_vendors": { "$ref": "15" }, "t_schools": { "$ref": "5" } }, { "$ref": "18" } ], "t_vendor_staffs": [ { "$id": "19", "id": 1, "name": "sample string 2", "avatar": "sample string 3", "email": "sample string 4", "phone": "sample string 5", "password": "QEA=", "token": "sample string 6", "vendorid": 7, "status": "sample string 8", "pospin": "sample string 9", "mop": "sample string 10", "pic": "sample string 11", "bio": "sample string 12", "show_on_website": true, "job_title": "sample string 14", "t_vendors": { "$ref": "15" } }, { "$ref": "19" } ], "t_vendor_users": [ { "$ref": "14" }, { "$ref": "14" } ], "t_pohdr": [ { "$id": "20", "id": 1, "pon": "sample string 2", "seq": 3, "supplierid": 1, "podate": "2024-11-01T13:26:30.8240246+00:00", "duedate": "2024-11-01T13:26:30.8240246+00:00", "terms": "sample string 4", "notes": "sample string 5", "vendorid": 1, "status": "sample string 6", "type": "sample string 7", "receivedby": "sample string 8", "receiveddate": "2024-11-01T13:26:30.8240246+00:00", "shipto": "sample string 9", "invoiceno": "sample string 10", "currency": "sample string 11", "roe": 12.0, "t_poentry": [ { "$id": "21", "id": 1, "hdrid": 1, "itemid": 1, "code": "sample string 2", "description": "sample string 3", "cost": 4.0, "qty": 5.0, "receivedqty": 6.0, "t_pohdr": { "$ref": "20" }, "t_vendor_items": { "$id": "22", "id": 1, "vendorid": 2, "categoryid": 3, "name": "sample string 4", "description": "sample string 5", "pic": "sample string 6", "status": "sample string 7", "ingredients": "sample string 8", "cost": 1.0, "price": 1.0, "addedby": "sample string 9", "dateadded": "2024-11-01T13:26:30.8240246+00:00", "dateofexpiry": "2024-11-01T13:26:30.8240246+00:00", "frontpage": true, "displayorder": 1, "barcode": "sample string 10", "subtag": "sample string 11", "inventory": true, "seq": 13, "tpcode": "sample string 14", "dateupdated": "2024-11-01T13:26:30.8240246+00:00", "updateby": "sample string 15", "color": "sample string 16", "style": "sample string 17", "gender": "sample string 18", "t_item_categories": { "$id": "23", "id": 1, "name": "sample string 2", "description": "sample string 3", "pic": "sample string 4", "displayorder": 1, "active": true, "type": "sample string 5", "vendorid": 6, "parent_id": 1, "t_vendor_items": [ { "$ref": "22" }, { "$ref": "22" } ] }, "t_item_transactions": [ { "$id": "24", "id": 1, "itemid": 1, "qty": 2.0, "refno": "sample string 3", "txndate": "2024-11-01T13:26:30.8240246+00:00", "tranby": "sample string 4", "txntype": "sample string 5", "notes": "sample string 6", "binid": 1, "t_binlocations": { "$id": "25", "id": 1, "code": "sample string 2", "description": "sample string 3", "active": true, "createby": "sample string 4", "createdate": "2024-11-01T13:26:30.8240246+00:00", "updateby": "sample string 5", "updatedate": "2024-11-01T13:26:30.8240246+00:00", "vendorid": 6, "lvl": "sample string 7", "sec": "sample string 8", "bintype": "sample string 9", "t_item_transactions": [ { "$ref": "24" }, { "$ref": "24" } ] }, "t_vendor_items": { "$ref": "22" } }, { "$ref": "24" } ], "t_poentry": [ { "$ref": "21" }, { "$ref": "21" } ], "t_standing_orderentry": [ { "$id": "26", "id": 1, "itemid": 1, "description": "sample string 2", "qty": 1.0, "price": 1.0, "orderid": 1, "discount": 3.0, "pic": "sample string 4", "tag": "sample string 5", "subtag": "sample string 6", "t_standing_orders": { "$id": "27", "id": 1, "childid": 1, "vendorid": 1, "notes": "sample string 2", "delivery_instructions": "sample string 3", "status": "sample string 4", "notify_parent": true, "recurr_pattern": "sample string 5", "standing_days": "sample string 6", "createdate": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 7", "updatedate": "2024-11-01T13:26:30.8240246+00:00", "updateby": "sample string 8", "t_childs": { "$ref": "2" }, "t_standing_orderentry": [ { "$ref": "26" }, { "$ref": "26" } ], "t_vendors": { "$ref": "15" } }, "t_vendor_items": { "$ref": "22" } }, { "$ref": "26" } ], "t_vendors": { "$ref": "15" }, "t_orderentry": [ { "$id": "28", "id": 1, "itemid": 1, "description": "sample string 2", "qty": 3.0, "price": 4.0, "orderid": 1, "pic": "sample string 5", "tag": "sample string 6", "subtag": "sample string 7", "oldorderid": 1, "discount": 8.0, "t_vendor_items": { "$ref": "22" }, "t_orders": { "$ref": "1" } }, { "$ref": "28" } ] } }, { "$ref": "21" } ], "t_suppliers": { "$id": "29", "id": 1, "name": "sample string 2", "email": "sample string 3", "address": "sample string 4", "phone": "sample string 5", "vendorid": 1, "active": true, "t_pohdr": [ { "$ref": "20" }, { "$ref": "20" } ] }, "t_vendors": { "$ref": "15" } }, { "$ref": "20" } ], "t_standing_orders": [ { "$ref": "27" }, { "$ref": "27" } ], "t_vendor_items": [ { "$ref": "22" }, { "$ref": "22" } ], "t_vendor_terms": [ { "$id": "30", "id": 1, "description": "sample string 2", "createdate": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 3", "updateby": "sample string 4", "updatedate": "2024-11-01T13:26:30.8240246+00:00", "vendorid": 1, "t_vendors": { "$ref": "15" } }, { "$ref": "30" } ], "t_events": [ { "$id": "31", "id": 1, "subject": "sample string 2", "details": "sample string 3", "vdo_url": "sample string 4", "pic_url": "sample string 5", "start_date": "2024-11-01T13:26:30.8240246+00:00", "end_date": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 7", "createdate": "2024-11-01T13:26:30.8240246+00:00", "vendorid": 1, "uk": "15aeb18a-c4b1-4b0d-9c0b-2e01816c2b77", "status": "sample string 8", "type": "sample string 9", "t_event_enrollments": [ { "$id": "32", "id": 1, "eventid": 1, "name": "sample string 2", "email": "sample string 3", "phone": "sample string 4", "address": "sample string 5", "status": "sample string 6", "createdate": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 7", "t_events": { "$ref": "31" } }, { "$ref": "32" } ], "t_vendors": { "$ref": "15" } }, { "$ref": "31" } ], "t_waitlist": [ { "$id": "33", "id": 1, "schoolid": 1, "referred": true, "referred_by": "sample string 2", "first_name": "sample string 3", "last_name": "sample string 4", "initial": "sample string 5", "dob": "2024-11-01T13:26:30.8240246+00:00", "sex": "sample string 6", "fulltime": true, "meals": true, "grade": "sample string 7", "parent_name": "sample string 8", "parent_email": "sample string 9", "parent_phone": "sample string 10", "parent_address": "sample string 11", "parent_country": "sample string 12", "createby": "sample string 13", "createdate": "2024-11-01T13:26:30.8240246+00:00", "vendorid": 1, "t_vendors": { "$ref": "15" }, "t_schools": { "$ref": "5" } }, { "$ref": "33" } ], "t_agency_terms": [ { "$id": "34", "id": 1, "description": "sample string 2", "createdate": "2024-11-01T13:26:30.8240246+00:00", "createby": "sample string 3", "updateby": "sample string 4", "updatedate": "2024-11-01T13:26:30.8240246+00:00", "vendorid": 1, "t_vendors": { "$ref": "15" } }, { "$ref": "34" } ] }, "t_users": { "$ref": "10" } }, { "$ref": "14" } ] } }, { "$ref": "9" } ], "t_moe_vendors": [ { "$ref": "16" }, { "$ref": "16" } ] }, "t_schools": { "$ref": "5" } }, { "$ref": "6" } ], "t_school_childs": [ { "$id": "35", "childid": 1, "schoolid": 1, "id": 1, "t_childs": { "$ref": "2" }, "t_schools": { "$ref": "5" } }, { "$ref": "35" } ], "t_school_classes": [ { "$ref": "3" }, { "$ref": "3" } ], "t_waitlist": [ { "$ref": "33" }, { "$ref": "33" } ], "t_vendor_schools": [ { "$ref": "18" }, { "$ref": "18" } ] } }, { "$ref": "4" } ], "t_schools": { "$ref": "5" } }, "t_orders": [ { "$ref": "1" }, { "$ref": "1" } ], "t_user_childs": [ { "$ref": "12" }, { "$ref": "12" } ], "t_school_childs": [ { "$ref": "35" }, { "$ref": "35" } ], "t_standing_orders": [ { "$ref": "27" }, { "$ref": "27" } ], "t_carts": [ { "$id": "36", "id": 1, "cartid": "sample string 2", "prodid": 3, "qty": 4.0, "datecreated": "2024-11-01T13:26:30.8240246+00:00", "price": 6.0, "ilc": "sample string 7", "description": "sample string 8", "pic": "sample string 9", "saveforlater": true, "scheduledate": "2024-11-01T13:26:30.8240246+00:00", "childid": 1, "checkout": 1, "tag": "sample string 11", "vendorid": 12, "subtag": "sample string 13", "t_childs": { "$ref": "2" } }, { "$ref": "36" } ], "t_schools": { "$ref": "5" } }, "t_order_payments": [ { "$id": "37", "id": 1, "orderid": 1, "amount": 2.0, "narration": "sample string 3", "trandate": "2024-11-01T13:26:30.8240246+00:00", "tranby": "sample string 4", "pm": "sample string 5", "change": 6.0, "t_orders": { "$ref": "1" } }, { "$ref": "37" } ], "t_vendors": { "$ref": "15" }, "t_user_wallet": [ { "$id": "38", "id": 1, "amount": 2.0, "narration": "sample string 3", "type": "sample string 4", "trandate": "2024-11-01T13:26:30.8240246+00:00", "tranby": "sample string 6", "pm": "sample string 7", "payref": "sample string 8", "currency": "sample string 9", "userid": 1, "vendorid": 1, "orderid": 1, "t_orders": { "$ref": "1" } }, { "$ref": "38" } ], "t_users": { "$ref": "10" }, "t_orderentry": [ { "$ref": "28" }, { "$ref": "28" } ] }