POST api/Orders/Postt_orders

Request Information

URI Parameters

None.

Body Parameters

t_orders
NameDescriptionTypeAdditional 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.

email

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_orders
NameDescriptionTypeAdditional 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.

email

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"
    }
  ]
}