Project:
| View Revisions: Issue #54524 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0054524: API Changes related to Handling Unit Type Sequence | ||
| Revision | 2024-02-22 19:04 by AtulOpenbravo | ||
| Description | table: AD_SEQUENCE - Constraint: AD_SEQUENCE_BASESEQ_CHK defined as: CALCULATION_METHOD = 'S' AND BASE_SEQUENCE_ID IS NOT NULL OR CALCULATION_METHOD <> 'S' AND BASE_SEQUENCE_ID IS NULL table: AD_SEQUENCE - Constraint: AD_SEQUENCE_LENGTH_CHK defined as: SEQUENCE_NUMBER_LENGTH = 'V' AND SEQUENCE_LENGTH IS NULL OR SEQUENCE_NUMBER_LENGTH = 'F' AND SEQUENCE_LENGTH IS NOT NULL AND SEQUENCE_LENGTH > 0 table: M_REFINVENTORY_TYPE - Constraint: M_REFINVENTORY_TYPE_SEQ_CH defined as: SEQUENCETYPE <> 'G' AND AD_SEQUENCE_ID IS NULL OR SEQUENCETYPE = 'G' AND AD_SEQUENCE_ID IS NOT NULL |
||
| Revision | 2024-02-01 04:14 by AtulOpenbravo | ||
| Description | M_RefInventory_Type table - Add SEQUENCETYPE - Add Check Constraint M_REFINVENTORY_TYPE_SEQ_CH SEQUENCETYPE <> 'G' OR AD_SEQUENCE_ID IS NOT NULL AD_Sequence Table - Add CALCULATION_METHOD column - Add BASE_SEQUENCE_ID and its Foreign Key constraint to AD_Sequence itself - Add CONTROL_DIGIT column - Add SEQUENCE_NUMBER_LENGTH column - Add SEQUENCE_LENGTH, its check constraint AD_SEQUENCE_LENGTH_CHK SEQUENCE_NUMBER_LENGTH = 'V' AND SEQUENCE_LENGTH IS NULL OR SEQUENCE_NUMBER_LENGTH = 'F' AND SEQUENCE_LENGTH IS NOT NULL AND SEQUENCE_LENGTH > 0 |
||
| Revision | 2024-01-31 14:02 by AtulOpenbravo | ||
| Description | M_RefInventory_Type table - Add SEQUENCETYPE - Add Check Constraint M_REFINVENTORY_TYPE_SEQ_CH SEQUENCETYPE <> 'G' OR AD_SEQUENCE_ID IS NOT NULL AD_Sequence Table - Add CALCULATION_METHOD column - Add BASE_SEQUENCE_ID and its Foreign Key constraint to AD_Sequence itself - Add CONTROL_DIGIT column - Add SEQUENCE_LENGTH_TYPE column - Add SEQUENCE_LENGTH, its check constraint AD_SEQUENCE_LENGTH_CHK SEQUENCE_LENGTH_TYPE = 'V' AND SEQUENCE_LENGTH IS NULL OR SEQUENCE_LENGTH_TYPE = 'F' AND SEQUENCE_LENGTH IS NOT NULL AND SEQUENCE_LENGTH > 0 |
||
| Revision | 2024-01-31 13:58 by AtulOpenbravo | ||
| Description | M_RefInventory_Type table - Add SEQUENCETYPE - Add Check Constraint M_REFINVENTORY_TYPE_SEQ_CH SEQUENCETYPE <> 'G' OR AD_SEQUENCE_ID IS NOT NULL AD_Sequence Table - Add CALCULATION_METHOD, its related AD_Reference, AD_Ref_List options - Add BASE_SEQUENCE_ID and its Foreign Key constraint to AD_Sequence itself - Add CONTROL_DIGIT, its AD_Reference, AD_Ref_List options - Add SEQUENCE_LENGTH_TYPE, its related AD_Reference, AD_Ref_List options - Add SEQUENCE_LENGTH, its check constraint AD_SEQUENCE_LENGTH_CHK SEQUENCE_LENGTH_TYPE = 'V' AND SEQUENCE_LENGTH IS NULL OR SEQUENCE_LENGTH_TYPE = 'F' AND SEQUENCE_LENGTH IS NOT NULL AND SEQUENCE_LENGTH > 0 |
||
| Revision | 2024-01-31 13:51 by AtulOpenbravo | ||
| Description | M_RefInventory_Type table - Add Sequence Type - Add Check Constraint if Sequence Type is Global, then AD_Sequence_ID cannot be NULL AD_Sequence Table - Add Calculation Method, its related AD_Reference, AD_Ref_List options - Add Base Sequence and its Foreign Key constraint to AD_Sequence itself - Add Control Digit, its AD_Reference, AD_Ref_List options - Add Sequence Length Type, its related AD_Reference, AD_Ref_List options - Add Sequence Length, its check constraint when Sequence Length Type is Fix Length, Sequence Length should be not empty and greater than 0 |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |