Order Status

C_OrderStatus

Overview

Table NameC_OrderStatus
Access LevelSystem + Client
Entity TypeMM02
Is DocumentYes
Is ViewNo
Has UUIDYes
Parent TableAD_Client
WikiView on iDempiere Wiki

Columns (19)

Column Type Required Default Description
Classname String(60) No - Java Classname
ExternalReference String(50) No - External identifier from another system, document, or partner
StatusColor Color(10) No - Status color of an entity
AD_Client_ID Table Direct(10) Yes @#AD_Client_ID@ Tenant for this installation.
AD_Org_ID Table Direct(10) Yes @#AD_Org_ID@ Organizational entity within tenant
C_OrderStatus_ID ID(10) Yes - -
C_OrderStatus_UU String(36) No - -
Created Date+Time(13) Yes SYSDATE Date this record was created
CreatedBy Search(10) Yes - User who created this records
Description String(255) No - Optional short description of the record
Help Text(2000) No - Comment or Hint
IsActive Yes-No(1) Yes Y The record is active in the system
IsDefault Yes-No(1) No - Default value
Name String(60) Yes - Alphanumeric identifier of the entity
OrderStatus List(2) No PE -
SOPOType List(1) No S Sales Tax applies to sales situations, Purchase Tax to purchase situations
Updated Date+Time(13) Yes SYSDATE Date this record was updated
UpdatedBy Search(10) Yes - User who updated this records
Value String(40) Yes - Search key for the record in the format required - must be unique

Foreign Keys

Column References Description
AD_Client_ID AD_Client.AD_Client_ID Tenant for this installation.
AD_Org_ID AD_Org.AD_Org_ID Organizational entity within tenant

Generated on 2026-05-03T16:35:37.688341055Z