m_transactionallocation

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_transaction_id numeric 10 null
m_transaction.m_transaction_id mttransaction_mtrxalloc C
allocationstrategytype bpchar 1 null
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
m_product_id numeric 10 null
m_product.m_product_id mproduct_mtrxalloc R
m_attributesetinstance_id numeric 10 0
m_attributesetinstance.m_attributesetinstance_id mattributesetinst_mtrxalloc R
isallocated bpchar 1 'N'::bpchar
qty numeric 0 0
ismanual bpchar 1 'N'::bpchar
m_inoutline_id numeric 10 √ null
m_inoutline.m_inoutline_id minoutline_mtrxalloc R
m_productionline_id numeric 10 √ null
m_productionline.m_productionline_id mproductionline_mtrxalloc R
m_inventoryline_id numeric 10 √ null
m_inventoryline.m_inventoryline_id minventoryline_mtrxalloc R
out_m_transaction_id numeric 10 √ null
m_transaction.m_transaction_id mtransactionout_mtrxalloc R
out_m_inoutline_id numeric 10 √ null
m_inoutline.m_inoutline_id minoutlineout_mtrxalloc R
out_m_productionline_id numeric 10 √ null
m_productionline.m_productionline_id mproductionlineout_mtrxalloc R
out_m_inventoryline_id numeric 10 √ null
m_inventoryline.m_inventoryline_id minventorylineout_mtrxalloc R
m_transactionallocation_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
m_transactionallocation_pkey Primary key Asc/Asc m_transaction_id + allocationstrategytype
m_transactionallocation_prd Performance Asc/Asc/Asc m_product_id + m_attributesetinstance_id + isallocated
m_transactionallocation_uu_idx Must be unique Asc m_transactionallocation_uu

Check Constraints

Constraint Name Constraint
m_transactionallocation_ismanual_check ((ismanual = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_transactionallocation_isallocated_check ((isallocated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
m_transactionallocation_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation