/
Sample json data of GRN Index Model

Sample json data of GRN Index Model

INDEX

Index contains basic information of GRN. To create a GRN it must have only one GRN Index data.

Structure of GRN Index

nameData TypeExampleDescription
userNameStringchinFor authentication
passwordString123456For authentication
tokenString3487384For authentication
po_idInteger1001Purchase Order PKID
branch_codeStringJETMYBranch Code of GRN
supplier_idInteger1010Supplier ID of GRN
supplier_codeStringXYZSupplier Code of GRN
reference_noStringanythingAny reference related to this GRN
remarksStringanythingAny Remarks
grn_dateStringAug 6, 2012 9:58:28 PMTransaction date of this GRN
itemListString 

List of GRN Item objects. Structure of this GRN Item object has described below

 

 

ITEM

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

Structure of GRN Item

nameData TypeExampleDescription
gl_dimension_pkidsString1001,1002GL Dimenstion PKID
gl_dimension_codeStringXYZ,ABCGL Dimension Code
gl_code_referenceStringanythingGL code Reference of this GRN Item
gl_codeStringXYZGL code of this GRN Item
item_codeStringX1000Item code of this GRN Item
item_typeStringINVItem type of this GRN Item
qtyBigDecimal10Quantity only for this Item
unit_priceBigDecimal20Unit price of this item
amountBigDecimal200Total amount for this item after multiply qty and unit_price
remarksStringanythingAny remarks
tax_codeStringA100Tax code if available
po_item_pkidString1001pkid

 

{
    "userName": "chin",
    "password": "123456",
    "token": "anything",
    "po_id": 1001,
    "branch_code": "JETMY",
    "supplier_id": "INV",
    "supplier_code": 1001,
    "reference_no": "20",
    "remarks": "200",
    "grn_date": "Aug 6, 2012 9:58:28 PM",
    "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,
            "amount": 200,
            "remarks": "anything",
            "tax_code": "A100",
            "po_item_pkid": "1001" 
        },
        {
            "gl_dimension_pkids": "1001,1002",
            "gl_dimension_code": "XYZ,ABC",
            "gl_code_reference": "anything",
            "gl_code": "XYZ",
            "item_code": "X1001",
            "item_type": "INV",
            "qty": 10,
            "unit_price": 30,
            "amount": 300,
            "remarks": "anything",
            "tax_code": "A100",
            "po_item_pkid": "1002" 
        }
    ]
}

 

Private & Confidential