Column definition

This topic specifies the nullable columns, the character length, and the default value. By default the columns are nullable in the AS database model. the only columns used as primary key are not nullable.

This table shows the changes that are performed:

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