| Attributes |
Description |
Data Type |
Length |
|
| itemId |
Item Code |
Int |
|
|
| itemName |
Item Name |
string |
100 |
|
| locationId |
Item Branch Id |
Int |
|
|
| Stock |
List of details about item |
array |
|
|
|
|
stock |
Item Stock detail |
Decimal |
20 |
| mrp |
Item Mrp Price |
Decimal |
20 |
|
| salePrice |
Item Sell Price |
Decimal |
30 |
|
| itemReferenceCode |
Item Code |
Int |
|
|
| taxPercentage |
Item Tax Percentage |
Decimal |
20 |
|
| discountpercentage |
Item Discount Percentage |
Decimal |
53 |
|
| itemTimeStamp |
Item Time Stamp |
Numeric |
|
|
| Attributes |
Description |
Data Type |
Length |
|
| onlineReferenceNo* |
Sale Order Id |
numeric |
|
|
| createdAt* |
Order Created Time (YYYY-MM-DD HH:MM:SS) |
datetime |
100 |
|
| updatedAt |
Order Updated Time (YYYY-MM-DD HH:MM:SS) |
datetime |
100 |
|
| status |
Order Status (Pending,Cancel,Delivered) |
string |
19 |
|
| orderRemarks |
Customer remarks if any |
string |
200 |
|
| Channel |
Order received from market or mobile store |
string |
35 |
|
| totalQuantity* |
Order Quantity |
numeric |
|
|
| totalAmount* |
Order Total Amount (Inclusive All Taxes And Discounts) |
decimal |
15 |
|
| paymentMode |
Payment Type (2=Card,1=Cod) |
List |
2 |
|
| totalTaxAmount |
Total Tax Amount |
decimal |
15 |
|
| totalDiscountAmount |
Total Discount Amount |
decimal |
15 |
|
| courierPartner |
Courier Vendor Name |
string |
50 |
|
| shippingId* |
Shipping Id |
string |
40 |
|
| shippingName* |
Shipping Name |
string |
100 |
|
| shippingAddress1* |
Shipping Address 1 |
string |
100 |
|
| ShippingAddress2 |
Shipping Address 2 |
string |
100 |
|
| shippingPlace |
Shipping Place |
string |
50 |
|
| shippingState* |
Shipping State |
string |
50 |
|
| shippingCountry* |
Shipping Country |
string |
50 |
|
| shippingPincode* |
Shipping Address Pincode |
string |
10 |
|
| shippingPhone |
Shipping Address Phone Number |
string |
50 |
|
| shippingMobile* |
Shipping Owner Mobile Number |
string |
40 |
|
| shippingEmail |
Shipping Owner Email Id |
string |
50 |
|
| shippingCharge |
Shipping Charge |
decimal |
15 |
|
| shippingMethod (String) |
Shipping Method (EXP -Speed ,ECN -Economy) |
string |
50 |
|
| ShipmentPointsUsed |
Customer reward points[Total accumulated points till now] |
decimal |
15 |
|
| shipmentItems |
Total line items counts |
Int |
|
|
| shipmentAbn |
Airway bill number |
string |
50 |
|
| shipmentWeight |
shipment weight |
decimal |
50 |
|
| discountCoupon |
Discount coupon name |
string |
50 |
|
| deliveryDate* |
Order Delivery Time (YYYY-MM-DD HH:MM:SS) |
datetime |
100 |
|
| locationId |
Order Branch Id |
numeric |
|
|
| userId |
UserId of Ecommerce user |
string |
15 |
|
|
|
rowNo |
Serial Number Of Item |
numeric |
|
| itemId |
Item Id |
numeric |
|
|
| itemName |
Item Name |
string |
|
|
| itemReferenceCode |
Unique Id of each items |
Int |
|
|
| salePrice |
Item Sale Price inclusive of tax & exclusive of discount |
decimal |
|
|
| quantity |
Item Sale Quantity |
numeric |
|
|
| itemAmount |
Item Amount inclusive of tax & exclusive of discount |
decimal |
|
|
| taxPercentage |
Particular Item Tax Id |
numeric |
|
|
| discountPercentage |
Particular Item discount Percentage |
decimal |
|
|
| itemRemarks |
Item remarks |
string |
|
|
| itemMarketPrice |
Item MRP/Market price |
decimal |
|
|
| customerId* |
Customer Code |
numeric |
|
|
| customerName* |
Customer Name |
string |
100 |
|
| customerType |
Customer Type |
string |
50 |
|
| customerAddressLine1 |
Address Line1 |
string |
250 |
|
| customerAddressLine2 |
Address Line2 |
string |
250 |
|
| customerAddressLine3 |
Address Line3 |
string |
250 |
|
| customerArea |
Customer Area |
string |
80 |
|
| customerCity |
Customer City |
string |
50 |
|
| customerState |
Customer State |
string |
50 |
|
| customerCountry |
Customer Country |
string |
50 |
|
| customerPincode* |
Customer Address Pincode |
string |
Int |
|
| customerPhone |
Customer Phone number |
string |
30 |
|
| customerMobile* |
Customer Mobile Number |
string |
40 |
|
| customerEmail* |
customerEmail |
string |
100 |
|