# EXP_HDR: Billing proposals - Name: `EXP_HDR` - Catalog: `AccountView` - Label: Billing proposals - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `EXP_HDR` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BLK_AMT` | `int64` | G-account amount | ☐ | | | `BV_AMT` | `int64` | UWV amount | ☐ | | | `CANC_AMT` | `int64` | Total to cancel | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `COMMENT1` | `string(40)` | Billing description | ☐ | | | `COMMENT2` | `string(4)` | External note | ☐ | | | `COMMENT3` | `string(4)` | Internal note | ☐ | | | `CUR_CODE` | `string(3)` | Currency code | ☐ | | | `CUR_UNIT` | `int64` | Billing currency unit | ☐ | | | `EMP_NR` | `string(10)` | Project manager | ☐ | | | `EXCH_RATE` | `decimal` | Exchange rate | ☐ | | | `EXCHA_RATE` | `decimal` | Exchange rate | ☐ | | | `EXP_AMT` | `int64` | Total billable | ☐ | | | `EXP_DATE` | `datetime` | Billing date | ☐ | | | `EXP_NR` | `string(10)` | Billing number | ☐ | | | `EXP_STAT` | `int32` | Billing status | ☐ | | | `INV_AMT` | `int64` | Total to invoice | ☐ | | | `LB_AMT` | `int64` | Payroll tax amount | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PG_CODE` | `string(10)` | Project group | ☐ | | | `PROJ_CODE` | `string(10)` | Project code | ☐ | | | `RES_AMT` | `int64` | Billing result | ☐ | | | `SEL_CODE` | `string(5)` | Selection code | ☐ | | | `SUB_NR` | `string(10)` | Customer number | ☐ | | | `SUSP_AMT` | `int64` | Total to defer | ☐ | | | `WAGE_SH` | `int64` | Wage share | ☐ | |