t_transaction

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_pinstance_id numeric 10 null
ad_pinstance.ad_pinstance_id adpinstance_ttransaction C
m_transaction_id numeric 10 null
m_transaction.m_transaction_id mtransaction_ttransaction C
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
movementtype bpchar 2 null
m_locator_id numeric 10 null
m_locator.m_locator_id mlocator_ttransaction C
m_product_id numeric 10 null
m_product.m_product_id mproduct_ttransaction C
m_attributesetinstance_id numeric 10 null
m_attributesetinstance.m_attributesetinstance_id masi_ttransaction C
movementdate timestamp 29,6 null
movementqty numeric 0 0
m_inoutline_id numeric 10 √ null
m_inoutline.m_inoutline_id minoutline_ttransaction C
m_inout_id numeric 10 √ null
m_inout.m_inout_id Implied Constraint R
m_movementline_id numeric 10 √ null
m_movementline.m_movementline_id mmovementline_ttransaction C
m_movement_id numeric 10 √ null
m_movement.m_movement_id Implied Constraint R
m_inventoryline_id numeric 10 √ null
m_inventoryline.m_inventoryline_id minventoryline_ttransaction C
m_inventory_id numeric 10 √ null
m_inventory.m_inventory_id Implied Constraint R
m_productionline_id numeric 10 √ null
m_productionline.m_productionline_id mproductionline_ttransaction C
m_production_id numeric 10 √ null
m_production.m_production_id Implied Constraint R
c_projectissue_id numeric 10 √ null
c_projectissue.c_projectissue_id cprojectissue_ttransaction C
c_project_id numeric 10 √ null
c_project.c_project_id Implied Constraint R
search_order_id numeric 10 √ null
search_invoice_id numeric 10 √ null
search_inout_id numeric 10 √ null
t_transaction_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
t_transaction_pkey Primary key Asc/Asc ad_pinstance_id + m_transaction_id
t_transaction_uu_idx Must be unique Asc t_transaction_uu

Check Constraints

Constraint Name Constraint
t_transaction_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation