# POI_LINE: Purchase invoice lines - Name: `POI_LINE` - Catalog: `AccountView` - Label: Purchase invoice lines - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `POI_LINE` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ART_CODE` | `string(15)` | Article Code | ☐ | | | `ART_QTY` | `decimal` | Quantity received/not processed | ☐ | | | `ART_QTYU` | `decimal` | Quantity received/not processed (unit) | ☐ | | | `CANC_AMT` | `int64` | Cancelled amount | ☐ | | | `CANC_QTY` | `decimal` | Quantity cancelled | ☐ | | | `CANC_QTYU` | `decimal` | Quantity cancelled (unit) | ☐ | | | `DEL_DATE` | `datetime` | Delivery date | ☐ | | | `INV_NR` | `string(10)` | Invoice number | ☐ | | | `LINE_ID` | `string(10)` | Line identification | ☐ | | | `ORD_NR` | `string(10)` | Order number | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PREF_DATE` | `datetime` | Promised delivery date | ☐ | | | `PREF_WEEK` | `int32` | Promised delivery date (week) | ☐ | | | `PROJ_CODE` | `string(10)` | Project code | ☐ | | | `SUP_AC` | `string(15)` | Supplier item code | ☐ | | | `TINV_QTY` | `decimal` | Quantity to be invoiced | ☐ | | | `TINV_QTYU` | `decimal` | Quantity to be invoiced (unit) | ☐ | | | `UNT_CODE` | `string(10)` | Unit | ☐ | | | `UNT_CODEP` | `string(10)` | Price unit | ☐ | |