# SBS_LINE: Subscription lines - Name: `SBS_LINE` - Catalog: `AccountView` - Label: Subscription lines - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `SBS_LINE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ART_AMT` | `int64` | Item amount (entered) | ☐ | | | `ART_CA` | `boolean` | Composite item | ☐ | | | `ART_CAMT` | `int64` | Item amount | ☐ | | | `ART_CODE` | `string(15)` | Article Code | ☐ | | | `ART_DAMT` | `int64` | Amount with discount | ☐ | | | `ART_DESC1` | `string(4)` | Invoice line description | ☐ | | | `ART_LEVEL` | `int32` | Explosion level | ☐ | | | `ART_ONCE` | `boolean` | Invoice once in subscription | ☐ | | | `ART_ONCEI` | `boolean` | One-off line invoiced | ☐ | | | `ART_PX` | `int64` | Item price | ☐ | | | `BM_TAG` | `string(10)` | Unique key item composition | ☐ | | | `COST_CODE` | `string(10)` | Cost centre code | ☐ | | | `DATE_END` | `datetime` | End Date | ☐ | | | `DATE_START` | `datetime` | Start date | ☐ | | | `DISC_PCT` | `decimal` | Discount percentage | ☐ | | | `ORD_QTY` | `decimal` | Quantity | ☐ | | | `ORD_QTYU` | `decimal` | Quantity (unit) | ☐ | | | `PARENT_ID` | `string(10)` | Parent item | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PROJ_CODE` | `string(10)` | Project code | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `REC_ORD` | `int32` | Line sequence | ☐ | | | `SBS_NR` | `string(10)` | Subscription number | ☐ | | | `STD_QTY` | `decimal` | Number of components required | ☐ | | | `UNT_CODE` | `string(10)` | Unit | ☐ | | | `UNT_DESC` | `string(40)` | Unit description | ☐ | | | `USE_ARTAMT` | `boolean` | Deviating amount | ☐ | | | `VAT_AMT` | `int64` | VAT Amount | ☐ | |