# CRS_SOT: Backorder/order analysis - Name: `CRS_SOT` - Catalog: `AccountView` - Label: Backorder/order analysis - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `CRS_SOT` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `DEL_DATE` | `datetime` | Delivery date | ☐ | | | `DEL_FREE` | `decimal` | Unlinked inventory to be delivered | ☐ | | | `DEL_POSO` | `decimal` | Linked inventory to be delivered | ☐ | | | `DEL_QTY` | `decimal` | Inventory to be delivered | ☐ | | | `DEL_WEEK` | `string(7)` | Delivery week | ☐ | | | `END_STOCK` | `decimal` | Free inventory | ☐ | | | `INIT_STOCK` | `decimal` | Available inventory | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `REC_FREE` | `decimal` | Unlinked inventory to be received | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `REC_POSO` | `decimal` | Linked inventory to be received | ☐ | | | `REC_QTY` | `decimal` | Inventory to be received | ☐ | |