| Name | Description | Type | Additional information |
|---|---|---|---|
| id | integer |
None. |
|
| ilc | string |
None. |
|
| description | string |
None. |
|
| extdescription | string |
None. |
|
| ptype | string |
None. |
|
| dept | integer |
None. |
|
| cat | integer |
None. |
|
| pocost | decimal number |
None. |
|
| reorderpoint | decimal number |
None. |
|
| reorderqty | decimal number |
None. |
|
| length | decimal number |
None. |
|
| width | decimal number |
None. |
|
| height | decimal number |
None. |
|
| weight | decimal number |
None. |
|
| parentid | integer |
None. |
|
| specification | string |
None. |
|
| tags | string |
None. |
|
| notes | string |
None. |
|
| createby | string |
None. |
|
| createdate | date |
None. |
|
| updateby | string |
None. |
|
| updatedate | date |
None. |
|
| status | string |
None. |
|
| uid | string |
None. |
|
| seq | integer |
None. |
|
| companyid | integer |
None. |
|
| uom | string |
None. |
|
| commoditycode | string |
None. |
|
| notdiscountable | boolean |
None. |
|
| donotorder | boolean |
None. |
|
| salestartdate | date |
None. |
|
| saleenddate | date |
None. |
|
| manuafacturer | string |
None. |
|
| supplierid | integer |
None. |
|
| lastcounted | date |
None. |
|
| isserilized | boolean |
None. |
|
| lastsold | date |
None. |
|
| commissionpercentage | decimal number |
None. |
|
| minqty | decimal number |
None. |
|
| maxqty | decimal number |
None. |
|
| showinmobileapp | boolean |
None. |
|
| returnable | boolean |
None. |
|
| color | string |
None. |
|
| size | string |
None. |
|
| puom | string |
None. |
|
| flatpp | boolean |
None. |
|
| flatprice | decimal number |
None. |
|
| manualstockaudit | boolean |
None. |
|
| pcurrency | string |
None. |
|
| ailc | string |
None. |
|
| catalog_no | string |
None. |
|
| milc | string |
None. |
|
| store | decimal number |
None. |
|
| wholesale | decimal number |
None. |
|
| online | decimal number |
None. |
|
| service | decimal number |
None. |
|
| landedcost | decimal number |
None. |
|
| tpcode | string |
None. |
|
| ahservice | decimal number |
None. |
|
| ohservice | decimal number |
None. |
|
| rhservice | decimal number |
None. |
|
| salepricepercentage | decimal number |
None. |
|
| mfgdate | date |
None. |
|
| pckgdate | date |
None. |
|
| avgcost | decimal number |
None. |
|
| qtyinpack | decimal number |
None. |
|
| offerprice | decimal number |
None. |
|
| offerstartdate | date |
None. |
|
| offerenddate | date |
None. |
|
| webdisplayorder | integer |
None. |
|
| homepage | boolean |
None. |
|
| donotsell | boolean |
None. |
|
| salespricepercentageminimum | decimal number |
None. |
|
| storemin | decimal number |
None. |
|
| coa_costofsales | integer |
None. |
|
| coa_inventorystock | integer |
None. |
|
| warranty_in | string |
None. |
|
| warranty_period | integer |
None. |
|
| auth_onsale | boolean |
None. |
|
| emails_onsale | string |
None. |
|
| lot_tracking | boolean |
None. |
|
| tpcodeextra | string |
None. |
|
| coa_income | integer |
None. |
|
| discount_type | string |
None. |
|
| discount | decimal number |
None. |
|
| deletedate | date |
None. |
|
| web_url | string |
None. |
|
| sale_online | boolean |
None. |
|
| days_to_restock | integer |
None. |
|
| wastage_per | decimal number |
None. |
|
| subcat | integer |
None. |
|
| deleteby | string |
None. |
|
| abc_type | string |
None. |
|
| avgcost_fifo | decimal number |
None. |
|
| avgcost_weighted | decimal number |
None. |
|
| pos_description | string |
None. |
|
| pic | string |
None. |
|
| landatper | decimal number |
None. |
|
| tv_code | string |
None. |
|
| prefer_to_produce | boolean |
None. |
|
| prefer_to_purchase | boolean |
None. |
|
| inventory_lead_time | integer |
None. |
|
| production_lead_time | integer |
None. |
|
| ahservice_agg | decimal number |
None. |
|
| ohservice_agg | decimal number |
None. |
|
| rhservice_agg | decimal number |
None. |
|
| coa_sales | integer |
None. |
|
| coa_salereturn | integer |
None. |
|
| coa_purchase | integer |
None. |
|
| coa_purchasereturn | integer |
None. |
|
| keywords | string |
None. |
|
| deplete_onsale_bin | integer |
None. |
|
| shservice | decimal number |
None. |
|
| shservice_agg | decimal number |
None. |
|
| tpid | string |
None. |
|
| t_assemblyhdr | Collection of t_assemblyhdr |
None. |
|
| t_binlocations | t_binlocations |
None. |
|
| t_coas | t_coas |
None. |
|
| t_coas1 | t_coas |
None. |
|
| t_coas2 | t_coas |
None. |
|
| t_credit_note_entry | Collection of t_credit_note_entry |
None. |
|
| t_customer_site_materials | Collection of t_customer_site_materials |
None. |
|
| t_cyclecountmanual | Collection of t_cyclecountmanual |
None. |
|
| t_cyclecountsystem | Collection of t_cyclecountsystem |
None. |
|
| t_debit_note_entry | Collection of t_debit_note_entry |
None. |
|
| t_device_materials | Collection of t_device_materials |
None. |
|
| t_estimate_entry | Collection of t_estimate_entry |
None. |
|
| t_invadjentry | Collection of t_invadjentry |
None. |
|
| t_inventry | Collection of t_inventry |
None. |
|
| t_orderentry | Collection of t_orderentry |
None. |
|
| t_pientry | Collection of t_pientry |
None. |
|
| t_poentry | Collection of t_poentry |
None. |
|
| t_prod_timings | Collection of t_prod_timings |
None. |
|
| t_prodaddons | Collection of t_prodaddons |
None. |
|
| t_prodaddons1 | Collection of t_prodaddons |
None. |
|
| t_prodalias | Collection of t_prodalias |
None. |
|
| t_prodbins | Collection of t_prodbins |
None. |
|
| t_prodcats | t_prodcats |
None. |
|
| t_proddepts | t_proddepts |
None. |
|
| t_prodlots | Collection of t_prodlots |
None. |
|
| t_prodloyalityprograms | Collection of t_prodloyalityprograms |
None. |
|
| t_prodpictures | Collection of t_prodpictures |
None. |
|
| t_prodpricinglog | Collection of t_prodpricinglog |
None. |
|
| t_prodreviews | Collection of t_prodreviews |
None. |
|
| t_prodsaleuom | Collection of t_prodsaleuom |
None. |
|
| t_prodserials | Collection of t_prodserials |
None. |
|
| t_prodsuppliers | Collection of t_prodsuppliers |
None. |
|
| t_prodtags | Collection of t_prodtags |
None. |
|
| t_prodtax | Collection of t_prodtax |
None. |
|
| t_prodtransactionentries | Collection of t_prodtransactionentries |
None. |
|
| t_product_details | Collection of t_product_details |
None. |
|
| t_product_substitues | Collection of t_product_substitues |
None. |
|
| t_product_substitues1 | Collection of t_product_substitues |
None. |
|
| t_production_order_material | Collection of t_production_order_material |
None. |
|
| t_prs_entry | Collection of t_prs_entry |
None. |
|
| t_products1 | Collection of t_products |
None. |
|
| t_products2 | t_products |
None. |
|
| t_suppliers | t_suppliers |
None. |
|
| t_quoteentry | Collection of t_quoteentry |
None. |
|
| t_rfqentry | Collection of t_rfqentry |
None. |
|
| t_standing_orderentry | Collection of t_standing_orderentry |
None. |
|
| t_transferreqentry | Collection of t_transferreqentry |
None. |