Preflight Validation Cheat Sheet

Quick reference for ADR-075 In-Memory Preflight Validation.

MCP Tools

Column Prefix Notation

Examples:

S#Name              → VARCHAR(60) NOT NULL
S120#LongName       → VARCHAR(120)
ID#C_BPartner_ID    → FK to C_BPartner
Y#IsApproved        → CHAR(1) DEFAULT 'N'
D#DateDoc           → TIMESTAMP
Q#Qty               → NUMERIC

Validation Rules

Table Name

• ✅ Start with uppercase: XX_MyTable
• ✅ Max 40 characters
• ✅ Alphanumeric + underscore only
• ⚠️ Should have prefix: XX_, CE_, etc.

Column Name

• ✅ Start with uppercase: MyColumn
• ✅ Max 40 characters
• ✅ Alphanumeric + underscore only
• ⚠️ YesNo should start with Is, Has, Can
• ⚠️ TableDir should end with _ID

Required Columns (auto-added)

• {Table}_ID - Primary key
• {Table}_UU - UUID (v11+)
• AD_Client_ID, AD_Org_ID - Multi-tenant
• IsActive - Active flag
• Created, CreatedBy - Audit
• Updated, UpdatedBy - Audit

Quick Examples

1. Validate Only

{
  "tool": "wfValidateTable",
  "arguments": {
    "tableName": "XX_Task",
    "columns": "S#Name,T#Description,D#DueDate,Y#IsComplete"
  }
}

2. Plan Deployment

{
  "tool": "wfPlanDeployTable",
  "arguments": {
    "tableName": "XX_Task",
    "columns": "S#Name,D#DueDate,Y#IsComplete",
    "windowName": "Task Management",
    "deploy": false
  }
}

3. Execute Deployment

{
  "tool": "wfDeployTable",
  "arguments": {
    "tableName": "XX_Task",
    "columns": "S#Name,D#DueDate,Y#IsComplete",
    "windowName": "Tasks",
    "deploy": true
  }
}

Response Structure

Success (validation passed)

{
  "success": true,
  "message": "Validation passed. Ready to deploy.",
  "preflight": {
    "tableName": "XX_Task",
    "validation": {
      "valid": true,
      "state": "OK",
      "warnings": []
    },
    "tableSpec": {
      "tableName": "XX_Task",
      "columnCount": 11,
      "columns": [...]
    },
    "previews": {
      "sql": "CREATE TABLE XX_Task (...)",
      "xml": "<?xml version=\"1.0\"?>..."
    }
  }
}

Error (validation failed)

{
  "success": false,
  "errorCode": "VALIDATION_FAILED",
  "message": "Validation failed: 2 error(s)",
  "preflight": {
    "validation": {
      "valid": false,
      "state": "BLOCKED",
      "errors": [
        {
          "field": "tableName",
          "message": "Table name exceeds maximum length of 40",
          "rule": "MTable.TABLENAME_LENGTH",
          "suggestion": "Shorten to 40 characters"
        }
      ]
    }
  }
}

Validation States

Workflow Pattern (Nx-style)

┌─────────────┐    ┌─────────────┐    ┌─────────────┐
│  VALIDATE   │───▶│    PLAN     │───▶│   EXECUTE   │
│             │    │             │    │             │
│ wfValidate  │    │ wfPlanDeploy│    │ wfDeploy    │
│ Table()     │    │ Table()     │    │ Table()     │
└─────────────┘    └─────────────┘    └─────────────┘
     │                   │                   │
     ▼                   ▼                   ▼
  Errors?            Preview OK?         Success!
  Fix them           Confirm              Done

Common Errors

Files Reference