# PJ_SET: Project billing methods - Name: `PJ_SET` - Catalog: `AccountView` - Label: Project billing methods - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `PJ_SET` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ART_TYPE` | `string(10)` | Invoice item per dimension | ☐ | | | `ASC_1` | `boolean` | Level 1 ascending | ☐ | | | `ASC_2` | `boolean` | Level 2 ascending | ☐ | | | `ASC_3` | `boolean` | Level 3 ascending | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `DESC_1` | `string(4)` | Level 1 description | ☐ | | | `DESC_2` | `string(4)` | Level 2 description | ☐ | | | `DESC_3` | `string(4)` | Level 3 description | ☐ | | | `EXPR_1` | `string(4)` | Level 1 expression | ☐ | | | `EXPR_2` | `string(4)` | Level 2 expression | ☐ | | | `EXPR_3` | `string(4)` | Level 3 expression | ☐ | | | `GRP_1` | `string(10)` | Level 1 summarisation | ☐ | | | `GRP_2` | `string(10)` | Level 2 summarisation | ☐ | | | `GRP_3` | `string(10)` | Level 3 summarisation | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `INV_ART` | `string(15)` | Invoice item | ☐ | | | `INV_DIM` | `string(10)` | Billing meth. per dim | ☐ | | | `INV_MDESC` | `string(40)` | Billing method description | ☐ | | | `INV_METH` | `string(10)` | Billing method | ☐ | | | `INV_TYPE` | `string(25)` | Billing type | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `RES_ORD` | `string(4)` | Source type order | ☐ | | | `XML_LEVEL1` | `string(4)` | XML expression level 1 | ☐ | | | `XML_LEVEL2` | `string(4)` | XML expression level 2 | ☐ | | | `XML_LEVEL3` | `string(4)` | XML expression level 3 | ☐ | |