t_replenish

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_pinstance_id numeric 10 null
ad_pinstance.ad_pinstance_id adpinstance_treplenish C
m_warehouse_id numeric 10 null
m_warehouse.m_warehouse_id mwarehouse_treplenish C
m_product_id numeric 10 null
m_product.m_product_id mproduct_treplenish C
ad_client_id numeric 10 null
ad_org_id numeric 10 null
qtyonhand numeric 0 0
qtyreserved numeric 0 0
qtyordered numeric 0 0
replenishtype bpchar 1 null
level_min numeric 0 0
level_max numeric 0 0
c_bpartner_id numeric 10 null
c_bpartner.c_bpartner_id Implied Constraint R
order_min numeric 0 0
order_pack numeric 0 0
qtytoorder numeric 0 0
replenishmentcreate bpchar 3 √ null
m_warehousesource_id numeric 10 √ null
m_warehouse.m_warehouse_id mwarehousesource_treplenish C
c_doctype_id numeric 10 √ null
c_doctype.c_doctype_id cdoctype_treplenish C
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 √ null
t_replenish_uu varchar 36 √ NULL::character varying
cof_producttype_id numeric 10 √ NULL::numeric
cof_producttype.cof_producttype_id cofproducttype_treplenish R
cof_productclass_id numeric 10 √ NULL::numeric
cof_productclass.cof_productclass_id cofproductclass_treplenish R
cof_productgroup_id numeric 10 √ NULL::numeric
cof_productgroup.cof_productgroup_id cofproductgroup_treplenish R
cof_abc varchar 2 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
t_replenish_pkey Primary key Asc/Asc/Asc ad_pinstance_id + m_warehouse_id + m_product_id
t_replenish_uu_idx Must be unique Asc t_replenish_uu

Relationships

Close relationships within degrees of separation