Column Definitions

In the AS database model, columns are nullable by default. Only the columns that are used as primary key are not nullable. This changes are performed:

Nullable columns
Table name Column name AS 5.4 AS 5.5
AS_Downtime as_resource NO YES
AS_Enditem as_product_code NO YES
AS_Global as_unique_key YES NO
AS_InventoryLevel as_product_code NO YES
AS_Orders as_end_item NO YES
AS_ProcessBatch as_main_product NO YES
as_resource NO YES
as_resource_group NO YES
as_version NO YES
AS_ProcessBatchByProduct as_unique_key YES NO
AS_ProcessBatchClaimedResource as_resource NO YES
AS_ProcessBatchInflowProduct as_unique_key YES NO
AS_ProcessStep as_product_group NO YES
as_stage_code NO YES
as_unique_key YES NO
AS_ProcessStepByProduct as_unique_key YES NO
AS_ProcessStepInflowProduct as_unique_key YES NO
AS_ProcessStepMatrixCriteria as_unique_key YES NO
AS_ProcessStepResourceGrpsTbl as_resource_type NO YES
AS_Product as_product_group NO YES
AS_ResourceAvailabilityExcept as_unique_key YES NO
AS_ResourceDependentRules as_default NO YES
as_filling_level NO YES
as_filling_standing_time NO YES
as_outflow_rate NO YES
as_standard_quantity NO YES
AS_ResourceGroup as_category NO YES
AS_ResourceGroupResource as_unique_key YES NO
AS_ResourceTransition as_resource_code NO YES
AS_ResourceUtilizationExport as_resource NO YES
AS_StageProductGroup as_unique_key YES NO
AS_StageResourceGroup as_resource_group_type NO YES
as_unique_key YES NO
AS_TankBatch as_process_step NO YES
as_product NO YES
as_resource NO YES
as_resource_group NO YES
as_version NO YES
AS_TankBatchClaimedResource as_resource NO YES
AS_TimetableTimePeriod as_unique_key YES NO
AS_TransitionMatrixElements as_changeover NO YES
as_unique_key YES NO
AS_UtilityAvailabilityExcept as_available NO YES
as_unique_key YES NO