i_inout

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
i_inout_id numeric 10 null
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 null
createdby numeric 10 null
updated timestamp 29,6 null
updatedby numeric 10 null
bpartnervalue varchar 30 √ NULL::character varying
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id Implied Constraint R
c_bpartner_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id Implied Constraint R
c_doctype_id numeric 10 √ NULL::numeric
c_doctype.c_doctype_id Implied Constraint R
description varchar 255 √ NULL::character varying
doctypename varchar 60 √ NULL::character varying
documentno varchar 30 √ NULL::character varying
i_errormsg varchar 2000 √ NULL::character varying
i_isimported bpchar 1 'N'::bpchar
issotrx bpchar 1 √ 'N'::bpchar
linedescription varchar 255 √ NULL::character varying
m_attributesetinstance_id numeric 10 √ NULL::numeric
m_attributesetinstance.m_attributesetinstance_id Implied Constraint R
m_inout_id numeric 10 √ NULL::numeric
m_inout.m_inout_id Implied Constraint R
m_inoutline_id numeric 10 √ NULL::numeric
m_inoutline.m_inoutline_id Implied Constraint R
m_locator_id numeric 10 √ null
m_locator.m_locator_id Implied Constraint R
m_product_id numeric 10 √ NULL::numeric
m_product.m_product_id Implied Constraint R
m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id Implied Constraint R
poreference varchar 20 √ NULL::character varying
processed bpchar 1 √ NULL::bpchar
processing bpchar 1 √ NULL::bpchar
productvalue varchar 30 √ NULL::character varying
qtyentered numeric 0 √ null
locatorvalue varchar 45 √ NULL::character varying
warehousevalue varchar 45 √ NULL::character varying
i_inout_uu varchar 36 √ NULL::character varying
cof_attributesetinstancevalue varchar 2000 √ NULL::character varying
lot varchar 40 √ NULL::character varying
serno varchar 40 √ NULL::character varying
guaranteedate timestamp 29,6 √ null
movementtype varchar 2 √ NULL::character varying
c_order_id numeric 10 √ NULL::numeric
c_order.c_order_id corder_iinout R
c_order_documentno varchar 30 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
i_inout_key Primary key Asc i_inout_id
i_inout_uu_idx Must be unique Asc i_inout_uu

Check Constraints

Constraint Name Constraint
i_inout_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_inout_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
i_inout_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation