Try to display the Requested Quantity Explanation without dispaying the requested quantity attribute.
URL: http://10.222.17.134/requisition/api/requisitionTemplates/5a268780-fafd-4243-9551-5c7daa824913?access_token=76b30c32-216f-43df-a9d7-a6f1ba62d752
Method: PUT
Body:
{
"id": "5a268780-fafd-4243-9551-5c7daa824913",
"programId": "dce17f2e-af3e-40ad-8e00-3496adef44c3",
"columnsMap": {
"beginningBalance": {
"name": "beginningBalance",
"label": "Beginning Balance",
"indicator": "A",
"displayOrder": 3,
"isDisplayed": true,
"source": "USER_INPUT",
"columnDefinition": {
"id": "33b2d2e9-3167-46b0-95d4-1295be9afc22",
"name": "beginningBalance",
"sources": [
"USER_INPUT"
],
"label": "Beginning Balance",
"indicator": "A",
"mandatory": false,
"isDisplayRequired": false,
"canChangeOrder": true,
"canBeChangedByUser": false,
"columnType": "NUMERIC"
}
},
"productCode": {
"name": "orderableProduct.productCode",
"label": "Product Code",
"indicator": "O",
"displayOrder": 1,
"isDisplayed": true,
"source": "REFERENCE_DATA",
"columnDefinition": {
"id": "bde01507-3837-47b7-ae08-cec92c0c3cd2",
"name": "productCode",
"sources": [
"REFERENCE_DATA"
],
"label": "Product Code",
"indicator": "O",
"mandatory": false,
"isDisplayRequired": false,
"canChangeOrder": true,
"canBeChangedByUser": false,
"columnType": "TEXT"
}
},
"totalConsumedQuantity": {
"name": "totalConsumedQuantity",
"label": "Total Consumed Quantity",
"indicator": "C",
"displayOrder": 5,
"isDisplayed": true,
"source": "USER_INPUT",
"columnDefinition": {
"id": "9e825396-269d-4873-baa4-89054e2722f4",
"name": "totalConsumedQuantity",
"sources": [
"CALCULATED",
"USER_INPUT"
],
"label": "Total Consumed Quantity",
"indicator": "C",
"mandatory": false,
"isDisplayRequired": false,
"canChangeOrder": true,
"canBeChangedByUser": false,
"columnType": "NUMERIC"
}
},
"requestedQuantity": {
"name": "requestedQuantity",
"label": "Requested Quantity",
"indicator": "J",
"displayOrder": 8,
"isDisplayed": false,
"source": "USER_INPUT",
"columnDefinition": {
"id": "4a2e9fd3-1127-4b68-9912-84a5c00f6999",
"name": "requestedQuantity",
"sources": [
"USER_INPUT"
],
"label": "Requested Quantity",
"indicator": "J",
"mandatory": false,
"isDisplayRequired": false,
"canChangeOrder": true,
"canBeChangedByUser": false,
"columnType": "NUMERIC"
}
},
"requestedQuantityExplanation": {
"name": "requestedQuantityExplanation",
"label": "Requested Quantity Explanation",
"indicator": "W",
"displayOrder": 9,
"isDisplayed": true,
"source": "USER_INPUT",
"columnDefinition": {
"id": "6b8d331b-a0dd-4a1f-aafb-40e6a72ab9f5",
"name": "requestedQuantityExplanation",
"sources": [
"USER_INPUT"
],
"label": "Requested Quantity Explanation",
"indicator": "W",
"mandatory": false,
"isDisplayRequired": false,
"canChangeOrder": true,
"canBeChangedByUser": false,
"columnType": "TEXT"
}
},
"stockOnHand": {
"name": "stockOnHand",
"label": "Stock On Hand",
"indicator": "E",
"displayOrder": 7,
"isDisplayed": true,
"source": "CALCULATED",
"columnDefinition": {
"id": "752cda76-0db5-4b6e-bb79-0f531ab78e2c",
"name": "stockOnHand",
"sources": [
"CALCULATED",
"USER_INPUT"
],
"label": "Stock On Hand",
"indicator": "E",
"mandatory": false,
"isDisplayRequired": false,
"canChangeOrder": true,
"canBeChangedByUser": false,
"columnType": "NUMERIC"
}
},
"totalLossesAndAdjustments": {
"name": "totalLossesAndAdjustments",
"label": "Total Losses And Adjustments",
"indicator": "D",
"displayOrder": 6,
"isDisplayed": true,
"source": "USER_INPUT",
"columnDefinition": {
"id": "cd57f329-f549-4717-882e-ecbf98122c38",
"name": "totalLossesAndAdjustments",
"sources": [
"USER_INPUT"
],
"label": "Total Losses And Adjustments",
"indicator": "D",
"mandatory": false,
"isDisplayRequired": false,
"canChangeOrder": true,
"canBeChangedByUser": false,
"columnType": "NUMERIC"
}
},
"productName": {
"name": "orderableProduct.name",
"label": "Product",
"indicator": "N",
"displayOrder": 2,
"isDisplayed": true,
"source": "REFERENCE_DATA",
"columnDefinition": {
"id": "e53e80de-fc63-4ecb-b6b2-ef376b34c926",
"name": "productName",
"sources": [
"REFERENCE_DATA"
],
"label": "Product",
"indicator": "N",
"mandatory": false,
"isDisplayRequired": false,
"canChangeOrder": true,
"canBeChangedByUser": false,
"columnType": "TEXT"
}
},
"remarks": {
"name": "remarks",
"label": "Remarks",
"indicator": "L",
"displayOrder": 11,
"isDisplayed": true,
"source": "USER_INPUT",
"columnDefinition": {
"id": "2ed8c74a-f424-4742-bd14-cfbe67b6e7be",
"name": "remarks",
"sources": [
"USER_INPUT"
],
"label": "Remarks",
"indicator": "L",
"mandatory": false,
"isDisplayRequired": false,
"canChangeOrder": true,
"canBeChangedByUser": false,
"columnType": "TEXT"
}
},
"approvedQuantity": {
"name": "approvedQuantity",
"label": "Approved Quantity",
"indicator": "K",
"displayOrder": 10,
"isDisplayed": true,
"source": "USER_INPUT",
"columnDefinition": {
"id": "a62a5fed-c0b6-4d49-8a96-c631da0d0113",
"name": "approvedQuantity",
"sources": [
"USER_INPUT"
],
"label": "Approved Quantity",
"indicator": "K",
"mandatory": false,
"isDisplayRequired": false,
"canChangeOrder": true,
"canBeChangedByUser": false,
"columnType": "NUMERIC"
}
},
"totalReceivedQuantity": {
"name": "totalReceivedQuantity",
"label": "Total Received Quantity",
"indicator": "B",
"displayOrder": 4,
"isDisplayed": true,
"source": "USER_INPUT",
"columnDefinition": {
"id": "5ba8b72d-277a-4da8-b10a-23f0cda23cb4",
"name": "totalReceivedQuantity",
"sources": [
"USER_INPUT"
],
"label": "Total Received Quantity",
"indicator": "B",
"mandatory": false,
"isDisplayRequired": false,
"canChangeOrder": true,
"canBeChangedByUser": false,
"columnType": "NUMERIC"
}
},
"totalStockoutDays" : {
"name": "total Stockout Days",
"label": "total Stockout Days",
"indicator": "X",
"displayOrder": 12,
"isDisplayed": true,
"source": "USER_INPUT",
"columnDefinition": {
"id": "750b9359-c097-4612-8328-d21671f88920",
"name": "total Stockout Days",
"sources": [
"USER_INPUT"
],
"label": "total Stockout Days",
"indicator": "X",
"mandatory": false,
"isDisplayRequired": false,
"canChangeOrder": true,
"canBeChangedByUser": false,
"columnType": "NUMERIC"
}
},
"total": {
"name": "total",
"label": "total",
"indicator": "Y",
"displayOrder": 13,
"isDisplayed": true,
"source": "USER_INPUT",
"columnDefinition": {
"id": "ef524868-9d0a-11e6-80f5-76304dec7eb7",
"name": "total",
"sources": [
"USER_INPUT"
],
"label": "total",
"indicator": "Y",
"mandatory": false,
"isDisplayRequired": false,
"canChangeOrder": true,
"canBeChangedByUser": false,
"columnType": "NUMERIC"
}
}
}
}