Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
ad_client_id |
numeric |
10 |
√ |
|
null |
|
|
ad_org_id |
numeric |
10 |
√ |
|
null |
|
|
movementdate |
timestamp |
29,6 |
√ |
|
null |
|
|
movementqty |
numeric |
0 |
√ |
|
null |
|
|
m_product_id |
numeric |
10 |
√ |
|
null |
|
|
m_locator_id |
numeric |
10 |
√ |
|
null |
|
|
m_attributesetinstance_id |
numeric |
10 |
√ |
|
null |
|
|
m_product_category_id |
numeric |
10 |
√ |
|
null |
|
|
value |
varchar |
510 |
√ |
|
null |
|
|
c_bpartner_id |
numeric |
10 |
√ |
|
null |
|
|
pricepo |
numeric |
0 |
√ |
|
null |
|
|
pricelastpo |
numeric |
0 |
√ |
|
null |
|
|
pricelist |
numeric |
0 |
√ |
|
null |
|
|
c_projectissue_id |
numeric |
10 |
√ |
|
null |
|
|
m_transaction_created |
timestamp |
29,6 |
√ |
|
null |
|
|
m_transaction_createdby |
numeric |
10 |
√ |
|
null |
|
|
m_transaction_isactive |
bpchar |
1 |
√ |
|
null |
|
|
m_inoutline_id |
numeric |
10 |
√ |
|
null |
|
|
movementtype |
bpchar |
2 |
√ |
|
null |
|
|
m_productionline_id |
numeric |
10 |
√ |
|
null |
|
|
m_transaction_id |
numeric |
10 |
√ |
|
null |
|
|
pp_cost_collector_id |
numeric |
10 |
√ |
|
null |
|
|
m_transation_updated |
timestamp |
29,6 |
√ |
|
null |
|
|
m_transation_updatedby |
numeric |
10 |
√ |
|
null |
|
|
m_product_ad_org_id |
numeric |
10 |
√ |
|
null |
|
|
classification |
varchar |
12 |
√ |
|
null |
|
|
m_product_copyfrom |
bpchar |
1 |
√ |
|
null |
|
|
m_product_created |
timestamp |
29,6 |
√ |
|
null |
|
|
m_product_createdby |
numeric |
10 |
√ |
|
null |
|
|
c_revenuerecognition_id |
numeric |
10 |
√ |
|
null |
|
|
c_subscriptiontype_id |
numeric |
10 |
√ |
|
null |
|
|
c_taxcategory_id |
numeric |
10 |
√ |
|
null |
|
|
m_product_c_uom_id |
numeric |
10 |
√ |
|
null |
|
|
m_product_description |
varchar |
255 |
√ |
|
null |
|
|
descriptionurl |
varchar |
120 |
√ |
|
null |
|
|
m_product_discontinued |
bpchar |
1 |
√ |
|
null |
|
|
m_product_discontinuedat |
timestamp |
29,6 |
√ |
|
null |
|
|
documentnote |
varchar |
2000 |
√ |
|
null |
|
|
group1 |
varchar |
255 |
√ |
|
null |
|
|
group2 |
varchar |
255 |
√ |
|
null |
|
|
guaranteedays |
numeric |
10 |
√ |
|
null |
|
|
guaranteedaysmin |
numeric |
10 |
√ |
|
null |
|
|
help |
varchar |
2000 |
√ |
|
null |
|
|
imageurl |
varchar |
120 |
√ |
|
null |
|
|
m_product_isactive |
bpchar |
1 |
√ |
|
null |
|
|
isdropship |
bpchar |
1 |
√ |
|
null |
|
|
isexcludeautodelivery |
bpchar |
1 |
√ |
|
null |
|
|
isinvoiceprintdetails |
bpchar |
1 |
√ |
|
null |
|
|
ispicklistprintdetails |
bpchar |
1 |
√ |
|
null |
|
|
ispurchased |
bpchar |
1 |
√ |
|
null |
|
|
isselfservice |
bpchar |
1 |
√ |
|
null |
|
|
issold |
bpchar |
1 |
√ |
|
null |
|
|
isstocked |
bpchar |
1 |
√ |
|
null |
|
|
m_product_issummary |
bpchar |
1 |
√ |
|
null |
|
|
isverified |
bpchar |
1 |
√ |
|
null |
|
|
iswebstorefeatured |
bpchar |
1 |
√ |
|
null |
|
|
lowlevel |
numeric |
10 |
√ |
|
null |
|
|
m_product_m_attributeset_id |
numeric |
10 |
√ |
|
null |
|
|
m_product_m_asi_id |
numeric |
10 |
√ |
|
null |
|
|
m_freightcategory_id |
numeric |
10 |
√ |
|
null |
|
|
m_product_m_locator_id |
numeric |
10 |
√ |
|
null |
|
|
m_product_name |
varchar |
255 |
√ |
|
null |
|
|
m_product_processing |
bpchar |
1 |
√ |
|
null |
|
|
producttype |
bpchar |
1 |
√ |
|
null |
|
|
r_mailtext_id |
numeric |
10 |
√ |
|
null |
|
|
m_product_salesrep_id |
numeric |
10 |
√ |
|
null |
|
|
s_expensetype_id |
numeric |
10 |
√ |
|
null |
|
|
shelfdepth |
numeric |
10 |
√ |
|
null |
|
|
shelfheight |
numeric |
0 |
√ |
|
null |
|
|
shelfwidth |
numeric |
10 |
√ |
|
null |
|
|
sku |
varchar |
30 |
√ |
|
null |
|
|
s_resource_id |
numeric |
10 |
√ |
|
null |
|
|
unitsperpack |
numeric |
10 |
√ |
|
null |
|
|
unitsperpallet |
numeric |
0 |
√ |
|
null |
|
|
m_product_upc |
varchar |
30 |
√ |
|
null |
|
|
m_product_updated |
timestamp |
29,6 |
√ |
|
null |
|
|
m_product_updatedby |
numeric |
10 |
√ |
|
null |
|
|
versionno |
varchar |
20 |
√ |
|
null |
|
|
volume |
numeric |
0 |
√ |
|
null |
|
|
weight |
numeric |
0 |
√ |
|
null |
|
|
m_product_po_ad_org_id |
numeric |
10 |
√ |
|
null |
|
|
m_product_po_c_currency_id |
numeric |
10 |
√ |
|
null |
|
|
costperorder |
numeric |
0 |
√ |
|
null |
|
|
m_product_po_created |
timestamp |
29,6 |
√ |
|
null |
|
|
m_product_po_createdby |
numeric |
10 |
√ |
|
null |
|
|
m_product_po_c_uom_id |
numeric |
10 |
√ |
|
null |
|
|
deliverytime_actual |
numeric |
10 |
√ |
|
null |
|
|
deliverytime_promised |
numeric |
10 |
√ |
|
null |
|
|
m_product_po_discontinued |
bpchar |
1 |
√ |
|
null |
|
|
m_product_po_discontinuedat |
timestamp |
29,6 |
√ |
|
null |
|
|
m_product_po_isactive |
bpchar |
1 |
√ |
|
null |
|
|
iscurrentvendor |
bpchar |
1 |
√ |
|
null |
|
|
manufacturer |
varchar |
30 |
√ |
|
null |
|
|
m_product_po_m_product_id |
numeric |
10 |
√ |
|
null |
|
|
order_min |
numeric |
0 |
√ |
|
null |
|
|
order_pack |
numeric |
0 |
√ |
|
null |
|
|
priceeffective |
timestamp |
29,6 |
√ |
|
null |
|
|
pricelastinv |
numeric |
0 |
√ |
|
null |
|
|
qualityrating |
numeric |
0 |
√ |
|
null |
|
|
royaltyamt |
numeric |
0 |
√ |
|
null |
|
|
m_product_po_upc |
varchar |
20 |
√ |
|
null |
|
|
m_product_po_updated |
timestamp |
29,6 |
√ |
|
null |
|
|
m_product_po_updatedby |
numeric |
10 |
√ |
|
null |
|
|
vendorcategory |
varchar |
30 |
√ |
|
null |
|
|
vendorproductno |
varchar |
40 |
√ |
|
null |
|
|
Analyzed at 2024-01-03 13:44 +0100
|