# EXP_LINE: Billing proposal lines - Name: `EXP_LINE` - Catalog: `AccountView` - Label: Billing proposal lines - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `EXP_LINE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CANC_AMT` | `int64` | Amount to cancel | ☐ | | | `CANC_CODE` | `string(10)` | Cancellation reason | ☐ | | | `CANC_QTY` | `decimal` | Quantity to cancel | ☐ | | | `DSP_LEVEL` | `int32` | Billing line level | ☐ | | | `EXP_AMT` | `int64` | Chargeable amount | ☐ | | | `EXP_PX` | `int64` | Billable rate | ☐ | | | `EXP_QTY` | `decimal` | Billable quantity | ☐ | | | `HDR_ID` | `string(10)` | Unique code of billing | ☐ | | | `INV_AMT` | `int64` | Amount to invoice | ☐ | | | `INV_ART` | `string(15)` | Invoice item | ☐ | | | `INV_PX` | `int64` | Rate to invoice | ☐ | | | `INV_QTY` | `decimal` | Quantity to invoice | ☐ | | | `ITEM_DESC` | `string(4)` | Description | ☐ | | | `ITEM_PROC` | `int32` | Status | ☐ | | | `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` | Sequence | ☐ | | | `RES_AMT` | `int64` | Billing result | ☐ | | | `RES_QTY` | `decimal` | Billing result quantity | ☐ | | | `SUSP_AMT` | `int64` | Amount to defer | ☐ | | | `SUSP_QTY` | `decimal` | Quantity to defer | ☐ | |