/
Sample json data of Purchase Order Index Model

Sample json data of Purchase Order Index Model

Owned by Stephen Boey
Last updated: 2015-Jan-13

Detail of Purchase Order Structure

Purchase Order(PO) Object contains 2 different information:

INDEX

Index contains basic information of PO. To update a PO it must have only one PO Index data.

Structure of PO Index

nameData TypeExampleDescription
userNameStringchinFor authentication
passwordString123456For authentication
tokenString3487384For authentication
po_idInteger1001Purchase Order PKID
branch_codeStringJETMYBranch Code of PO
supplier_idInteger1010Supplier ID of PO
supplier_codeStringXYZSupplier Code of PO
reference_noStringanythingAny reference related to this PO
remarksStringanythingAny Remarks
po_dateStringAug 6, 2012 9:58:28 PMTransaction date of this PO
order_typeStringAug 6, 2012 9:58:28 PMPO type
itemListString List of PO Item objects. Structure of this PO Item object has described below

 

ITEM

Item contains detail of PO items. To create a PO it must have at lease one item data.

Structure of PO Item

nameData TypeExampleDescription
gl_dimension_pkidsString1001,1002GL Dimenstion PKID
gl_dimension_codeStringXYZ,ABCGL Dimension Code
gl_code_referenceStringanythingGL code Reference of this PO Item
gl_codeStringXYZGL code of this PO Item
item_codeStringX1000Item code of this PO Item
item_typeStringINVItem type of this PO Item
qtyBigDecimal10Quantity only for this Item
unit_priceBigDecimal20Unit price of this item

 

{
    "userName": "chin",
    "password": "123456",
    "token": "anything",
    "po_id": 1001,
    "branch_code": "JETMY",
    "supplier_id": "INV",
    "supplier_code": 1001,
    "reference_no": "20",
    "remarks": "200",
    "po_date": "Aug 6, 2012 9:58:28 PM",
    "order_type": "PENDING",
    "itemList": [
        {
            "gl_dimension_pkids": "1001,1002",
            "gl_dimension_code": "XYZ,ABC",
            "gl_code_reference": "anything",
            "gl_code": "XYZ",
            "item_code": "X1000",
            "item_type": "INV",
            "qty": 10,
            "unit_price": 20
        },
        {
            "gl_dimension_pkids": "1001,1002",
            "gl_dimension_code": "XYZ,ABC",
            "gl_code_reference": "anything",
            "gl_code": "XYZ",
            "item_code": "X1000",
            "item_type": "INV",
            "qty": 10,
            "unit_price": 20
        }
    ]
}

Private & Confidential