Hasil Query API Sales OrderLine

From InfiniteERP Wiki
Revision as of 10:56, 2 February 2022 by Wikiadmin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Contoh hasil query API Sales Order dalam format JSON. Query menghasilkan 3 baris data untuk 3 produk berbeda. 

{
    "response": {
        "data": [
            {
                "_identifier": "TEST-WEBSTORE-001 - 02-02-2022 - 693966.00 - 30 - 54327.00",
                "_entityName": "OrderLine",
                "$ref": "OrderLine/F1F4F75D17254FBA91D50D507FDFFAA1",
                "id": "F1F4F75D17254FBA91D50D507FDFFAA1",
                "client": "0866093A2EEE4EE88399C8CE4E664858",
                "client$_identifier": "KREASI FESYEN SINERGI PT",
                "organization": "7F844AE4060B41CDB7E943F75B76F4B2",
                "organization$_identifier": "PT Kreasi Fesyen Sinergi",
                "active": true,
                "creationDate": "2022-02-02T07:41:07+07:00",
                "createdBy": "100",
                "createdBy$_identifier": "Openbravo",
                "updated": "2022-02-02T07:41:07+07:00",
                "updatedBy": "100",
                "updatedBy$_identifier": "Openbravo",
                "salesOrder": "0E8FEF9276C04CDDA88053EF8C9432A5",
                "salesOrder$_identifier": "TEST-WEBSTORE-001 - 02-02-2022 - 693966.00",
                "lineNo": 30,
                "businessPartner": "1DF416E52D30419CBAF6C13C8DD27B95",
                "businessPartner$_identifier": "WEBSTORE - WEBSTORE",
                "partnerAddress": "80537B71C48742219669AF2EEA18DEE7",
                "partnerAddress$_identifier": "Permata Darussalam, Depok, Jawa Barat",
                "orderDate": "2022-02-02",
                "scheduledDeliveryDate": "2022-02-02",
                "dateDelivered": null,
                "invoiceDate": null,
                "description": null,
                "product": "A7E42D4501F14215A7EC9A1BCDADC780",
                "product$_identifier": "CERELIA DRESS DISOL WARNA - PASTEL GREEN,SIZE - M",
                "warehouse": "69B6CC4F386A4BEC93906C53C16C16E5",
                "warehouse$_identifier": "S1-SRENGSENG",
                "directShipment": false,
                "uOM": "E4D60A0ECD0E4BAA902D9A844327B46D",
                "uOM$_identifier": "Piece",
                "orderedQuantity": 1,
                "reservedQuantity": 0,
                "deliveredQuantity": 0,
                "invoicedQuantity": 0,
                "shippingCompany": "984C01BD749B4C09B618021EB6A5A618",
                "shippingCompany$_identifier": "JNE",
                "currency": "303",
                "currency$_identifier": "IDR",
                "listPrice": 199000,
                "unitPrice": 54327,
                "priceLimit": 199000,
                "lineNetAmount": 54327,
                "discount": 0,
                "freightAmount": 0,
                "charge": null,
                "chargeAmount": 0,
                "tax": "F0EBB5B87F484A8298CE62FF87678DF8",
                "tax$_identifier": "Non Tax",
                "resourceAssignment": null,
                "sOPOReference": null,
                "attributeSetValue": null,
                "descriptionOnly": false,
                "orderQuantity": null,
                "orderUOM": null,
                "priceAdjustment": null,
                "standardPrice": 199000,
                "cancelPriceAdjustment": false,
                "orderDiscount": null,
                "editLineAmount": false,
                "taxableAmount": 54327,
                "goodsShipmentLine": null,
                "returnReason": null,
                "grossUnitPrice": 0,
                "lineGrossAmount": 0,
                "grossListPrice": null,
                "costcenter": null,
                "baseGrossUnitPrice": 0,
                "asset": null,
                "warehouseRule": null,
                "stDimension": null,
                "quotationLine": null,
                "ndDimension": null,
                "createReservation": null,
                "project": null,
                "reservationStatus": null,
                "manageReservation": false,
                "managePrereservation": false,
                "explode": false,
                "bOMParent": null,
                "oezOrderlineIdLink": null,
                "printDescription": false,
                "overdueReturnDays": null,
                "selectOrderLine": false,
                "replacedorderline": null,
                "operativeUOM": null,
                "operativeQuantity": null,
                "oezMakenetunitpricefixed": false,
                "oezDiscountAmount": 0,
                "oezPoreference": null,
                "vEPPolinestatus": null,
                "oezGrQuantity": null,
                "_computedColumns": "F1F4F75D17254FBA91D50D507FDFFAA1",
                "_computedColumns$_identifier": "OrderLine_ComputedColumns (F1F4F75D17254FBA91D50D507FDFFAA1)",
                "recordTime": 1643773747685
            },
            {
                "_identifier": "TEST-WEBSTORE-001 - 02-02-2022 - 693966.00 - 10 - 114114.00",
                "_entityName": "OrderLine",
                "$ref": "OrderLine/3795BD82616E431998175F881CD37DA7",
                "id": "3795BD82616E431998175F881CD37DA7",
                "client": "0866093A2EEE4EE88399C8CE4E664858",
                "client$_identifier": "KREASI FESYEN SINERGI PT",
                "organization": "7F844AE4060B41CDB7E943F75B76F4B2",
                "organization$_identifier": "PT Kreasi Fesyen Sinergi",
                "active": true,
                "creationDate": "2022-02-02T07:40:04+07:00",
                "createdBy": "100",
                "createdBy$_identifier": "Openbravo",
                "updated": "2022-02-02T07:40:04+07:00",
                "updatedBy": "100",
                "updatedBy$_identifier": "Openbravo",
                "salesOrder": "0E8FEF9276C04CDDA88053EF8C9432A5",
                "salesOrder$_identifier": "TEST-WEBSTORE-001 - 02-02-2022 - 693966.00",
                "lineNo": 10,
                "businessPartner": "1DF416E52D30419CBAF6C13C8DD27B95",
                "businessPartner$_identifier": "WEBSTORE - WEBSTORE",
                "partnerAddress": "80537B71C48742219669AF2EEA18DEE7",
                "partnerAddress$_identifier": "Permata Darussalam, Depok, Jawa Barat",
                "orderDate": "2022-02-02",
                "scheduledDeliveryDate": "2022-02-02",
                "dateDelivered": null,
                "invoiceDate": null,
                "description": null,
                "product": "ED2EFD6D436E4965AC6CDAAF3EA35096",
                "product$_identifier": "BLOSSOM PAJAMAS WARNA - ASPEN GREEN,SIZE - L",
                "warehouse": "69B6CC4F386A4BEC93906C53C16C16E5",
                "warehouse$_identifier": "S1-SRENGSENG",
                "directShipment": false,
                "uOM": "E4D60A0ECD0E4BAA902D9A844327B46D",
                "uOM$_identifier": "Piece",
                "orderedQuantity": 2,
                "reservedQuantity": 0,
                "deliveredQuantity": 0,
                "invoicedQuantity": 0,
                "shippingCompany": "984C01BD749B4C09B618021EB6A5A618",
                "shippingCompany$_identifier": "JNE",
                "currency": "303",
                "currency$_identifier": "IDR",
                "listPrice": 209000,
                "unitPrice": 57057,
                "priceLimit": 209000,
                "lineNetAmount": 114114,
                "discount": 0,
                "freightAmount": 0,
                "charge": null,
                "chargeAmount": 0,
                "tax": "F0EBB5B87F484A8298CE62FF87678DF8",
                "tax$_identifier": "Non Tax",
                "resourceAssignment": null,
                "sOPOReference": null,
                "attributeSetValue": null,
                "descriptionOnly": false,
                "orderQuantity": null,
                "orderUOM": null,
                "priceAdjustment": null,
                "standardPrice": 209000,
                "cancelPriceAdjustment": false,
                "orderDiscount": null,
                "editLineAmount": false,
                "taxableAmount": 114114,
                "goodsShipmentLine": null,
                "returnReason": null,
                "grossUnitPrice": 0,
                "lineGrossAmount": 0,
                "grossListPrice": null,
                "costcenter": null,
                "baseGrossUnitPrice": 0,
                "asset": null,
                "warehouseRule": null,
                "stDimension": null,
                "quotationLine": null,
                "ndDimension": null,
                "createReservation": null,
                "project": null,
                "reservationStatus": null,
                "manageReservation": false,
                "managePrereservation": false,
                "explode": false,
                "bOMParent": null,
                "oezOrderlineIdLink": null,
                "printDescription": false,
                "overdueReturnDays": null,
                "selectOrderLine": false,
                "replacedorderline": null,
                "operativeUOM": null,
                "operativeQuantity": null,
                "oezMakenetunitpricefixed": false,
                "oezDiscountAmount": 0,
                "oezPoreference": null,
                "vEPPolinestatus": null,
                "oezGrQuantity": null,
                "_computedColumns": "3795BD82616E431998175F881CD37DA7",
                "_computedColumns$_identifier": "OrderLine_ComputedColumns (3795BD82616E431998175F881CD37DA7)",
                "recordTime": 1643773747688
            },
            {
                "_identifier": "TEST-WEBSTORE-001 - 02-02-2022 - 693966.00 - 20 - 525525.00",
                "_entityName": "OrderLine",
                "$ref": "OrderLine/237589D87FEB4CCB9E0FACFA2709A1EF",
                "id": "237589D87FEB4CCB9E0FACFA2709A1EF",
                "client": "0866093A2EEE4EE88399C8CE4E664858",
                "client$_identifier": "KREASI FESYEN SINERGI PT",
                "organization": "7F844AE4060B41CDB7E943F75B76F4B2",
                "organization$_identifier": "PT Kreasi Fesyen Sinergi",
                "active": true,
                "creationDate": "2022-02-02T07:40:24+07:00",
                "createdBy": "100",
                "createdBy$_identifier": "Openbravo",
                "updated": "2022-02-02T07:40:24+07:00",
                "updatedBy": "100",
                "updatedBy$_identifier": "Openbravo",
                "salesOrder": "0E8FEF9276C04CDDA88053EF8C9432A5",
                "salesOrder$_identifier": "TEST-WEBSTORE-001 - 02-02-2022 - 693966.00",
                "lineNo": 20,
                "businessPartner": "1DF416E52D30419CBAF6C13C8DD27B95",
                "businessPartner$_identifier": "WEBSTORE - WEBSTORE",
                "partnerAddress": "80537B71C48742219669AF2EEA18DEE7",
                "partnerAddress$_identifier": "Permata Darussalam, Depok, Jawa Barat",
                "orderDate": "2022-02-02",
                "scheduledDeliveryDate": "2022-02-02",
                "dateDelivered": null,
                "invoiceDate": null,
                "description": null,
                "product": "A61A3716219C4E219F48D1A5E0C5D1B4",
                "product$_identifier": "AZMA PRAYER SET PLATINUM SERIES, SIZE - DEWASA,WISTFUL MAUVE",
                "warehouse": "69B6CC4F386A4BEC93906C53C16C16E5",
                "warehouse$_identifier": "S1-SRENGSENG",
                "directShipment": false,
                "uOM": "E4D60A0ECD0E4BAA902D9A844327B46D",
                "uOM$_identifier": "Piece",
                "orderedQuantity": 5,
                "reservedQuantity": 0,
                "deliveredQuantity": 0,
                "invoicedQuantity": 0,
                "shippingCompany": "984C01BD749B4C09B618021EB6A5A618",
                "shippingCompany$_identifier": "JNE",
                "currency": "303",
                "currency$_identifier": "IDR",
                "listPrice": 385000,
                "unitPrice": 105105,
                "priceLimit": 0,
                "lineNetAmount": 525525,
                "discount": 0,
                "freightAmount": 0,
                "charge": null,
                "chargeAmount": 0,
                "tax": "F0EBB5B87F484A8298CE62FF87678DF8",
                "tax$_identifier": "Non Tax",
                "resourceAssignment": null,
                "sOPOReference": null,
                "attributeSetValue": null,
                "descriptionOnly": false,
                "orderQuantity": null,
                "orderUOM": null,
                "priceAdjustment": null,
                "standardPrice": 385000,
                "cancelPriceAdjustment": false,
                "orderDiscount": null,
                "editLineAmount": false,
                "taxableAmount": 525525,
                "goodsShipmentLine": null,
                "returnReason": null,
                "grossUnitPrice": 0,
                "lineGrossAmount": 0,
                "grossListPrice": null,
                "costcenter": null,
                "baseGrossUnitPrice": 0,
                "asset": null,
                "warehouseRule": null,
                "stDimension": null,
                "quotationLine": null,
                "ndDimension": null,
                "createReservation": null,
                "project": null,
                "reservationStatus": null,
                "manageReservation": false,
                "managePrereservation": false,
                "explode": false,
                "bOMParent": null,
                "oezOrderlineIdLink": null,
                "printDescription": false,
                "overdueReturnDays": null,
                "selectOrderLine": false,
                "replacedorderline": null,
                "operativeUOM": null,
                "operativeQuantity": null,
                "oezMakenetunitpricefixed": false,
                "oezDiscountAmount": 0,
                "oezPoreference": null,
                "vEPPolinestatus": null,
                "oezGrQuantity": null,
                "_computedColumns": "237589D87FEB4CCB9E0FACFA2709A1EF",
                "_computedColumns$_identifier": "OrderLine_ComputedColumns (237589D87FEB4CCB9E0FACFA2709A1EF)",
                "recordTime": 1643773747690
            }
        ],
        "status": 0,
        "totalRows": 3,
        "startRow": 0,
        "endRow": 2
    }
}
Retrieved from "https://wiki.infinite-erp.co.id/index.php?title=Hasil_Query_API_Sales_OrderLine&oldid=3465"