Skip to main content
It stores the customers’ purchase orders information.
Field NameData TypeDescriptionNested Field
_idobjectIdUnique Identifier of the document0
po_idstringUnique identifier for po0
po_numberstringField for po number0
business_entity_idstringUnique identifier for business entity0
business_entity_namestringName of business entity0
partner_idstringUnique identifier for partner0
partner_namestringName of partner0
typestringField for type0
statusstringCurrent status of status0
order_datedatetimeTimestamp for when order date was created/updated0
expected_deliverydatetimeField for expected delivery0
total_amountfloatField for total amount0
tax_amountfloatField for tax amount0
shipping_amountfloatField for shipping amount0
grand_totalfloatField for grand total0
itemsarray_of_objectsField for items10
items.item_idstringUnique identifier for item0
items.variant_idstringUnique identifier for variant0
items.product_idstringUnique identifier for product0
items.product_namestringName of product0
items.skustringField for sku0
items.quantityintegerQuantity of items0
items.unit_priceintegerPrice information for unit0
items.total_priceintegerPrice information for total0
items.received_quantityintegerQuantity of received0
items.notesstringField for notes0
payment_termsstringField for payment terms0
shipping_methodstringField for shipping method0
notesstringField for notes0
created_bystringTimestamp for when created by was created/updated0
approved_bystringField for approved by0
approved_datedatetimeTimestamp for when approved date was created/updated0
is_activebooleanField for is active0
created_atdatetimeTimestamp when the record was created0
updated_atdatetimeTimestamp when the record was updated0
destination_locationobjectObject containing destination location details2
destination_location.location_idstringUnique identifier for location0
destination_location.namestringName of location0
 
{
    "_id": {
        "$oid": "685d9139dc60919af77b4cc9"
    },
    "po_id": "57ce453e-bd91-49ef-b91d-39f8b4c53009",
    "po_number": "PO-2025-0001",
    "business_entity_id": "7e820970-ce75-4ddd-94a7-f2ddaf9e5ad4",
    "business_entity_name": "Ekyam Retail Inc",
    "partner_id": "bd3e1436-6c92-4e89-9256-7393527e4f26",
    "partner_name": "Global Textile Co.",
    "type": "PO",
    "status": "approved",
    "order_date": {
        "$date": "2025-03-13T23:58:09.285Z"
    },
    "expected_delivery": {
        "$date": "2025-04-02T23:58:09.285Z"
    },
    "total_amount": 23089.13,
    "tax_amount": 1847.13,
    "shipping_amount": 82.55,
    "grand_total": 25046.17,
    "items": [
        {
            "item_id": "f3d3b29d-82ba-403d-ada6-4907d3cd39c4",
            "variant_id": "584456c2-ccae-496b-a018-7df6981434b1",
            "product_id": "f7a1479d-1e8e-4df1-810c-f8220e2d1eb6",
            "product_name": "Leather Touchscreen Winter Gloves - Brown / XL",
            "sku": "LTWG-BRN-XL",
            "quantity": 143,
            "unit_price": 21.54,
            "total_price": 3080.22,
            "received_quantity": 0,
            "notes": "PO item 1"
        },
        {
            "item_id": "f5a3cb14-3c9e-41dd-9f57-7f4d94fd0658",
            "variant_id": "759f8b52-f0be-457d-851e-3c51dc56203c",
            "product_id": "4b557b76-3afc-49f9-af71-31bb0105e5ac",
            "product_name": "Leather Crossbody Bag with Tassel Detail - Black / Classic",
            "sku": "LTHRCB-BLK-CLASSIC",
            "quantity": 106,
            "unit_price": 15.42,
            "total_price": 1634.52,
            "received_quantity": 0,
            "notes": "PO item 2"
        },
        {
            "item_id": "ff1ed7a2-c771-4fe3-848d-9987df0f13bb",
            "variant_id": "d9c09d7d-45a1-45b5-b3b0-1b5b0b5c885b",
            "product_id": "7e6530b7-b94d-4a27-b4fb-de96b97306d1",
            "product_name": "Kids' Colorful Denim Overalls - Pink / XL / Cute",
            "sku": "KCO-PINK-CUTE-XL",
            "quantity": 49,
            "unit_price": 23.57,
            "total_price": 1154.93,
            "received_quantity": 0,
            "notes": "PO item 3"
        },
        {
            "item_id": "69583aba-be57-4bed-bb15-d66117f7faf9",
            "variant_id": "6a58998d-287a-4285-9273-f80fb28aaf87",
            "product_id": "29b23919-6476-4682-9f40-8ba49dd0d9d1",
            "product_name": "Hydrating Rose Infused Face Serum - White / 50ml / Without Dropper",
            "sku": "HRIFSR-WHITE-50ML-WOD",
            "quantity": 63,
            "unit_price": 18.04,
            "total_price": 1136.52,
            "received_quantity": 0,
            "notes": "PO item 4"
        }
    ],
    "payment_terms": "Net 30",
    "shipping_method": "Overnight",
    "notes": "Generated PO #1",
    "created_by": "system",
    "approved_by": "manager",
    "approved_date": {
        "$date": "2025-03-14T23:58:09.285Z"
    },
    "is_active": true,
    "created_at": {
        "$date": "2025-03-13T23:58:09.285Z"
    },
    "updated_at": {
        "$date": "2025-06-26T23:58:09.286Z"
    },
    "destination_location": {
        "location_id": "53aefc8d-4665-496a-b289-965a2db67efa",
        "name": "Central Warehouse - New York"
    }
}