-
Notifications
You must be signed in to change notification settings - Fork 2
Create Data Documentation Item
seansimit edited this page Mar 30, 2022
·
6 revisions
Using CURL in terminal console to create the Item data. (* If there is no data in the data column, user may direct remove the column from the create data array.)
curl --header "Content-Type: application/x-www-form-urlencoded" \
--request POST \
--data '
{
"action": "createItemProfile",
"module": "inventory",
"token": null,
"uid": "admin",
"org": "SIMIT",
"branch": "HQ",
"data": {
"header": {
"item_code": "ITEM_001",
"item_name": "SOFTWARE",
"item_alternatename": "",
"item_barcode": "SOFTWARE01234",
"seqno": "10",
"isactive": "1"
},
"line": {
"baseuom_code": "Unit",
"salesuom_code": "Unit",
"salesuom_rate": "1",
"purchaseuom_code": "Unit",
"purchaseuom_rate": "1",
"costingmethod_code": "FIFO",
"sell_price": "1000",
"purchase_price": "600",
"isstock": "0",
"ispurchase": "1",
"issold": "1",
"purchaseaccount_code": "2000\/004",
"creditsalesaccount_code": "4009\/202",
"cashsalesaccount_code": "4009\/202"
}
}
}
' \
https://simbiz_system_url/simbiz/api.php
The available field for create Item Data
| Item Header Data | ||||
|---|---|---|---|---|
| No | Field Name | Data Type (Size) | Required | Description |
| 1 | item_code | varchar(255) | Y | Item Code (* will pick either one between item_id and item_code, item_id will be the first priority) |
| 2 | item_name | varchar(255) | Y | Item's name |
| 3 | item_alternatename | varchar(255) | Item's Alternate Name | |
| 4 | item_barcode | varchar(255) | Item's Barcode | |
| 5 | category_id | varchar(50) | Item's Category | |
| 6 | category_code | varchar(255) | Item's Category Code | |
| 7 | type_id | varchar(50) | Item's Type | |
| 8 | type_code | varchar(255) | Item's Type Code | |
| 9 | brand_id | varchar(50) | Item's Brand | |
| 10 | brand_code | varchar(255) | Item's Brand Code | |
| 11 | isgetpoint | smallint(1) | Item is available for point? (yes[1]/no[0]) | |
| 12 | isredeem | smallint(1) | Item is redeemable? (yes[1]/no[0]) | |
| 13 | minqty | int(11) | Item's minimum quantity | |
| 14 | item_width | decimal(14,4) | Item's width | |
| 15 | item_thickness | decimal(14,4) | Item's Thickness | |
| 16 | item_length | decimal(14,4) | Item's Length | |
| 17 | item_weight | decimal(14,4) | Item's Weight | |
| 18 | item_size | decimal(14,4) | Item's Size | |
| 19 | item_schedule | varchar(255) | Item's Schedule | |
| 20 | item_country | varchar(50) | Item's Country | |
| 21 | item_capacity | double | Item's Capacity | |
| 22 | item_tooltips | varchar(255) | Item's Tooltips | |
| 23 | item_desc | text | Item's Description | |
| 24 | item_docnote | text | Item's document note | |
| 25 | serialtextarea | text | Item's Serial No | |
| 26 | pos_pointmethod | varchar(20) | Item's point given method (POS) | |
| 27 | pos_requiredpoint | int(11) | Is the item required point to redeem? (yes[1]/no[0]) (POS) | |
| 28 | pos_givenpointperunit | decimal(10,4) | Item's given point per unit (POS) | |
| 29 | pos_allowtopup | int(11) | Is the item allow top up (yes[1]/no[0]) (POS) | |
| 30 | pos_valueamt | decimal(10,2) | Item's value amount (POS) | |
| 31 | pos_com_fixamt | decimal(10,2) | Item's fix commission amount (POS) | |
| 32 | pos_com_allowchange | int(11) | Is the item's commission allow for modify? (yes[1]/no[0]) (POS) | |
| 33 | pos_serviceduration | int(11) | Item's service duration (POS) | |
| 34 | pos_allowBuyProduct | int(11) | Is the customer allow to buy product? (yes[1]/no[0]) (POS) | |
| 35 | formula | text | ||
| 36 | isbom | smallint(1) | is bill of materials? (yes[1]/no[0]) | |
| 37 | seqno | smallint(6) [10] | Sequence Number | |
| 38 | isactive | smallint(1) [1] | Active [1]/ Not Active [0] | |
| 39 | item_image | text | Item's Image file (convert in base 64) | |
| 40 | hscode_id | varchar(50) | Item's HS code id | |
| 41 | hscode_code | varchar(255) | Item's HS code code | |
| 42 | pos_givenpointperqty | decimal(10,4) | Item's point given method (per quantity) (POS) | |
| 43 | pos_givenpointperamount | decimal(10,4) | Item's point given method (per amount) (POS) | |
| 44 | created | datetime | Item's created date in the system | |
| 45 | createdby | varchar(50) | Item's creator | |
| 46 | updated | datetime | Item's last updated date | |
| 47 | updatedby | varchar(50) | Item's last updated user | |
| 48 | organization_id | int(11) | Item was created under which organization | |
| 49 | branch_id | int(11) | Item details was created under which branch | |
| 50 | item_image | text NULL | Item's image path | |
| 51 | hscode_id | varchar(50) | Item's HS Code | |
| 52 | pos_givenpointperqty | decimal(10,4) | Item's given point per unit (POS) | |
| 53 | pos_givenpointperamount | decimal(10,4) | Item's given point per amount (POS) | |
| Item Line Data | ||||
| No | Field Name | Data Type (Size) | Required | Description |
| 1 | baseuom_id | varchar(255) | Item's Base UOM ID | |
| 2 | baseuom_code | varchar(255) | Item's Base UOM Code | |
| 3 | salesuom_id | varchar(255) | Item's Sales UOM ID | |
| 4 | salesuom_code | varchar(255) | Item's Sales UOM Code | |
| 5 | salesuom_rate | decimal(12,2) | Item's Sales UOM Rate | |
| 6 | purchaseuom_id | varchar(255) | Item's Purchase UOM ID | |
| 7 | purchaseuom_code | varchar(255) | Item's Purchase UOM Code | |
| 8 | purchaseuom_rate | decimal(12,2) | Item's Purchase UOM Rate | |
| 9 | costingmethod_code | varchar(50) | Item's Costing Method | |
| 10 | fixcost | decimal(24,4) | Item's Fix Cost | |
| 11 | sell_price | decimal(24,4) | Item's Sell Price | |
| 12 | purchase_price | decimal(24,4) | Item's Purchase Price | |
| 13 | isbom | int(11) | Item's is BOM? (yes[1]/no[0]) | |
| 14 | isstock | int(11) | Item's is Stock? (yes[1]/no[0]) | |
| 15 | ispurchase | int(11) | Item's is Purchase? (yes[1]/no[0]) | |
| 16 | issold | int(11) | Item's is Sold? (yes[1]/no[0]) | |
| 17 | ispackage | int(11) | Item's is Package? (yes[1]/no[0]) | |
| 18 | isinclusive | int(11) | Item's is Inclusive? (yes[1]/no[0]) | |
| 19 | isallowdiscount | int(11) | Item's Allow Discount? (yes[1]/no[0]) | |
| 20 | isallowprice | int(11) | Item's Allow Price? (yes[1]/no[0]) | |
| 21 | purchaseaccount_id | varchar(255) | Item's Purchase Account (yes[1]/no[0]) | |
| 22 | purchaseaccount_code | varchar(50) | Item's Purchase Account Code | |
| 23 | creditsalesaccount_id | varchar(255) | Item's Credit Sales Account | |
| 24 | creditsalesaccount_code | varchar(50) | Item's Credit Sales Account Code | |
| 25 | cashsalesaccount_id | varchar(255) | Item's Cash Sales Account | |
| 26 | cashsalesaccount_code | varchar(50) | Item's Cash Sales Account Code | |
| 27 | stockadjustaccount_id | varchar(255) | Item's Stock Adjust Account | |
| 28 | stockadjustaccount_code | varchar(50) | Item's Stock Adjust Account Code | |
| 29 | expensesaccount_id | varchar(255) | Item's Expenses Account | |
| 30 | expensesaccount_code | varchar(50) | Item's Expenses Account Code | |
| 31 | output_tax_id | varchar(255) | Item's Output Tax ID | |
| 32 | output_tax_code | varchar(100) | Item's Output Tax Code | |
| 33 | input_tax_id | varchar(255) | Item's Input Tax ID | |
| 34 | input_tax_code | varchar(100) | Item's Input Tax Code | |
| 35 | msic_id | varchar(255) | Item's MSIC ID | |
| 36 | msic_code | varchar(255) | Item's MSIC Code | |
| 37 | location_id | varchar(255) | Item's location ID | |
| 38 | location_code | varchar(255) | Item's location Code | |
| 39 | grndr_acc | varchar(255) | Goods Receiving Debit account ID | |
| 40 | grndr_acc_code | varchar(50) | Goods Receiving Debit account Code | |
| 41 | sidr_acc | varchar(255) | Sales Cost Entry Debit account ID | |
| 42 | sidr_acc_code | varchar(50) | Sales Cost Entry Debit account Code | |
| 43 | grncr_acc | varchar(255) | Goods Receiving Credit account ID | |
| 44 | grncr_acc_code | varchar(50) | Goods Receiving Credit account Code | |
| 45 | dodr_acc | varchar(255) | Delivery Order Debit account ID | |
| 46 | dodr_acc_code | varchar(50) | Delivery Order Debit account Code | |
| 47 | docr_acc | varchar(255) | Delivery Order Credit account ID | |
| 48 | docr_acc_code | varchar(50) | Delivery Order Credit account Code | |
| 49 | pidr_acc | varchar(255) | Purchase Billing Debit account ID | |
| 50 | pidr_acc_code | varchar(50) | Purchase Billing Debit account Code | |
| 51 | sicr_acc | varchar(255) | Sales Cost Entry Credit account ID | |
| 52 | sicr_acc_code | varchar(50) | Sales Cost Entry Credit account Code | |
| 53 | batchsetting | varchar(255) | Not Applicable / Compulsory / Optional | |
| 54 | serialsetting | varchar(255) | Not Applicable / Compulsory / Optional | |
| 55 | lotsetting | varchar(255) | Not Applicable / Compulsory / Optional | |
| 56 | serialallowdirectkey | varchar(255) | Yes [1] / No [0] | |
| 57 | lotallowdirectkey | varchar(255) | Yes [1] / No [0] | |
| 58 | batchallowdirectkey | varchar(255) | Yes [1] / No [0] | |
| 59 | isserial | smallint(1) [0] | Yes [1] / No [0] | |
| 60 | autosicr | varchar(255) | Sales Cost Entry Credit account ID | |
| 61 | autosicr_code | varchar(50) | Sales Cost Entry Credit account Code | |
| 62 | autosidr | varchar(255) | Sales Cost Entry Debit account ID (* Direct issue Sales Invoice without issue DO) | |
| 63 | autosidr_code | varchar(50) | Sales Cost Entry Debit account Code | |
| 64 | iucr_acc | varchar(255) | Internal Use Credit account ID | |
| 65 | iucr_acc_code | varchar(50) | Internal Use Credit account Code | |
| 66 | track1_id | varchar(50) | Item's Tracking 1 ID | |
| 67 | track1_code | varchar(255) | Item's Tracking 1 Code | |
| 68 | track2_id | varchar(50) | Item's Tracking 2 ID | |
| 69 | track2_code | varchar(255) | Item's Tracking 2 Code | |
| 70 | track3_id | varchar(50) | Item's Tracking 3 ID | |
| 71 | track3_code | varchar(255) | Item's Tracking 3 Code | |
| 72 | track4_id | varchar(50) | Item's Tracking 4 ID | |
| 73 | track4_code | varchar(255) | Item's Tracking 4 Code | |
| 74 | track5_id | varchar(50) | Item's Tracking 5 ID | |
| 75 | track5_code | varchar(255) | Item's Tracking 5 Code | |
| 76 | purchasereturnacc_id | varchar(255) | Item's Purchase return account ID | |
| 77 | purchasereturnacc_code | varchar(50) | Item's Purchase return account Code | |
| 78 | salesreturnacc_id | varchar(255) | Item's Sales return account ID | |
| 79 | salesreturnacc_code | varchar(50) | Item's Sales return account Code | |
| 80 | sell_price_label | varchar(100) | ||
| 81 | purchase_price_label | varchar(100) |