Create Order Request Item Entity for Admin

Learn about step to create entity for administrator who will add possible supplier.

1. From the App space screen, click Form and then popup dialog will opens.

2. Enter name in field Component Name and click Start Design.

3. From Tools > Tabs drag 2-Layer Tab to the silver box under entity name. The dialog of Add Tab data opens. Put "Order Request Item" to Title and then click Add.

4. From Tools > Module drag 1-1 to the box under the Order Request Item tab.

  • Click icon pencil. The dialog of Module Configuration opens.

  • Change Module Name to "Order Item".

  • Change Table Name to "wf_order_req_item (T)"

  • Click OK.

  • Click icon Configuration Layout and the dialog opens.

  • Select 2 Column and then click Accept. The table that has 2 columns will show.

5. From Tools > Field drag Dynamic List to the first cell of the table (From step 4.6) The dropdownLabel shows.

  • Click icon pencil. The dialog of Dynamic List Box Configuration opens.

  • Change Table Name to "wf_ms_hardware".

  • Change Column Show to "HARDWARE_NAME".

  • Change Column Value to "HARDWARE_ID".

  • Change FIELD_ID to "HARDWAREID".

  • Change ShowFieldName to "Hardware Id".

  • Switch viewFlag to "Y".

  • Click OK.

6. From Tools > Field drag Textarea to the second cell of the table. (From step 4.6) The textareaLabel shows.

  • Click icon pencil. The dialog of Text Area Configuration opens.

  • Change FIELD_ID to "SPEC".

  • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Spec".

  • Switch viewFlag to "Y".

  • Click OK.

7. From Order Item Module click icon append row. The system will append new row to the table.

8. From Tools > Field drag Text Box to the first cell of new row. (From step 7) The textLabel shows.

  • Click icon pencil. The dialog of Text box Configuration opens.

  • Select "Integer" at Number Formatter.

  • Change FIELD_ID to "UNIT".

  • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Unit".

  • Switch viewFlag to "Y".

  • Click OK.

9. From Tools > Field drag Textarea to the second cell of new row (From step 7) The textareaLabel shows.

  • Click icon pencil. The dialog of Text Area Configuration opens.

  • Change FIELD_ID to "REMARK".

  • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Remark".

  • Switch viewFlag to "Y".

  • Click OK.

10. From Order Item Module click icon append row. The system will append new row to the table.

11. From Tools > Field drag Hidden to the first cell of new row. (From step 10) The hiddenLabel shows.

  • Click icon pencil. The dialog of Hidden Field Configuration opens.

  • Put "id = 'ORDER_ITEM_ID'" to Source tag (for link with parent entity).

  • Change FIELD_ID to "ORDER_ITEM_ID".

  • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Order Item Id".

  • Click OK.

12. From Tools > Field drag Hidden to the first cell of new row. (From step 10) The hiddenLabel shows.

  • Click icon pencil. The dialog of Hidden Field Configuration opens.

  • Put "id = 'REQUEST_ID'" to Source tag (for link with parent entity).

  • Change FIELD_ID to "REQUEST_ID".

  • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Request Id".

  • Click OK.

13. From Tools > Button drag Entity Button to space under the Module Order Request. The SUBMIT_VALUE show.

  • Click icon pencil. The dialog of Button Configuration opens.

  • Change buttonName to "SAVE".

  • Change Page Action to "ENTITY_INSERT".

  • At Button Action select first radio and change button action to "saveEntity()".

  • Click OK.

14. From Tools > Button drag Entity Button to space under the Module Order Request. The SUBMIT_VALUE show.

  • Click icon pencil. The dialog of Button Configuration opens.

  • Change buttonName to "SAVE".

  • Change Page Action to "ENTITY_UPDATE".

  • At Button Action select first radio and change button action to "saveEntity()".

  • Click OK.

15. From Tools > Button drag Entity Button to space under the Module Order Request. The SUBMIT_VALUE show.

  • Click icon pencil. The dialog of Button Configuration opens.

  • Change buttonName to "CANCEL".

  • Change Page Action to "ENTITY_INSERT".

  • At Button Action select first radio and change button action to "cancelEntity()".

  • Click OK.

16. From Tools > Button drag Entity Button to space under the Module Order Request. The SUBMIT_VALUE show.

  • Click icon pencil. The dialog of Button Configuration opens.

  • Change buttonName to "CANCEL".

  • Change Page Action to "ENTITY_UPDATE".

  • At Button Action select first radio and change button action to "cancelEntity()".

  • Click OK.

17. From Tools > Tabs drag Normal Tab to the silver box under the table. The dialog of Add Tab data opens. Put "Supplier List" to Title, select 1 column and then click Add. The Order Item tab show.

18. From Tools > Module drag 1-Many to the box under the Order Item tab.

  • Click icon pencil. The dialog of Module Configuration opens.

  • Change Module Name to "Supplier".

  • Change Table Name to "wf_order_req_item_supplier (T)".

  • Click OK.

19. From Tools > Field drag Hidden to Module Supplier. The hiddenLabel shows.

  • Click icon pencil. The dialog of Hidden Field Configuration opens.

  • Change FIELD_ID to "ORDER_ITEM_SUPPLIER_ID".

  • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Order Item Supplier Id".

  • Click OK.

20. From Tools > Field drag Hidden to Module Supplier. The hiddenLabel shows.

  • Click icon pencil. The dialog of Hidden Field Configuration opens.

  • Change FIELD_ID to "ORDER_ITEM_ID".

  • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Order Item Id"

  • Click OK.

21. From Tools > Field drag Text Box to Module Supplier. The textLabel shows.

  • Click icon pencil. The dialog of Text box Configuration opens.

  • Change FIELD_ID to "SUPPLIER_NAME".

  • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Supplier Name".

  • Change FieldGroup to "1" and change Seq to "1".

  • Switch ShowSearch to "Y".

  • Change showSearchSeq to "1".

  • Select "CHECK_NULL" at Validate Code and click icon plus. The new record of Validate Code show.

  • Click OK.

22. From Tools > Field drag Text Box to Module Supplier. The textLabel shows.

  • Click icon pencil. The dialog of Text box Configuration opens.

  • Select "Integer" at Number Formatter.

  • Change FIELD_ID to "IN_STOC

  • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "In Stock".

  • Change FieldGroup to "1" and change Seq to "2".

  • Switch ShowSearch to "Y".

  • Change showSearchSeq to "2".

  • Select "CHECK_NULL" at Validate Code and click icon plus. The new record of Validate Code show.

  • Click OK.

23. From Tools > Field drag Text Box to Module Supplier. The textLabel shows.

  • Click icon pencil. The dialog of Text box Configuration opens.

  • Select "Currency" at Number Formatter

  • Change FIELD_ID to "UNIT_PRICE".

  • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Unit Price".

  • Change FieldGroup to "2" and change Seq to "1".

  • Switch ShowSearch to "Y".

  • Change showSearchSeq to "3".

  • Select "CHECK_NULL" at Validate Code and click icon plus. The new record of Validate Code show.

  • Click OK.

24. From Tools > Field drag Textarea to Module Supplier. The textareaLabel shows.

  • Click icon pencil. The dialog of Text Area Configuration opens.

  • Change FIELD_ID to "REMARK".

  • Click icon Populate from FIELD_ID. The system will auto generate ShowFieldName to "Remark".

  • Change FieldGroup to "2" and change Seq to "2".

  • Click OK.

25. From Tools > Button drag Module Button to space under the Module Supplier. The SUBMIT_VALUE show.

  • Click icon pencil. The dialog of Button Configuration opens.

  • Change buttonName to "ADD".

  • Change Page Action to "SUB_SEARCH".

  • At Button Action select first radio and change button action to "popupActionFlow('[MODULE_ID]')".

  • Click OK.

27. From Tools > Button drag Module Button to space under the Module Supplier. The SUBMIT_VALUE show.

  • Click icon pencil. The dialog of Button Configuration opens.

  • Change buttonName to "SAVE".

  • Change Page Action to "INSERT".

  • At Button Action select first radio and change button action to "actionFormSubmit('insertMany','Y')".

  • Click OK.

28. From Tools > Button drag Module Button to space under the Module Supplier. The SUBMIT_VALUE show.

  • Click icon pencil. The dialog of Button Configuration opens.

  • Change buttonName to "SAVE".

  • Change Page Action to "UPDATE".

  • At Button Action select first radio and change button action to "actionFormSubmit('insertMany','Y')".

  • Click OK.

29. From Tools > Button drag Module Button to space under the Module Supplier. The SUBMIT_VALUE show.

  • Click icon pencil. The dialog of Button Configuration opens.

  • Change buttonName to "CANCEL".

  • Change Page Action to "INSERT".

  • At Button Action select first radio and change button action to "$('#many_[MODULE_ID]_dialog').dialog('close');".

  • Click OK.

30. From Tools > Button drag Module Button to space under the Module Supplier. The SUBMIT_VALUE show.

  • Click icon pencil. The dialog of Button Configuration opens.

  • Change buttonName to "CANCEL".

  • Change Page Action to "UPDATE".

  • At Button Action select first radio and change button action to "$('#many_[MODULE_ID]_dialog').dialog('close');".

  • Click OK.

31. Configure Order Item module key.

  • From module Order Item click icon pencil. The dialog of Module Configuration opens.

  • Select "ORDER_ITEM_ID at Module Key.

  • Put "IT" to Prefix.

  • Put "18" to KeyLen.

  • Put "ORDER_ITEM_ID_SEQ" to Sequence.

  • Click icon plus. The new record of Module Key show.

  • Click OK.

32. Configure Supplier module key.

  • From module Supplier click icon pencil. The dialog of Module Configuration opens.

  • Select "ORDER_ITEM_SUPPLIER_ID" at Module Key.

  • Put "SP" to Prefix.

  • Put "18" to KeyLen.

  • Put "ORDER_ITEM_SUPPLIER_ID_SEQ" to Sequence.

  • Click icon plus. The new record of Module Key show.

  • Select "ORDER_ITEM_ID" at Module Key.

  • Select "ORDER_ITEM_ID" at Parent Key.

  • Click icon plus. The new record of Module Key show.

  • Click OK.

33. Click button Save this Entity.

The completed entity looks as shown below

Last updated