# PO_BUFF: Draft orders - Name: `PO_BUFF` - Catalog: `AccountView` - Label: Draft orders - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `PO_BUFF` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `APX_LIST` | `string(5)` | Price list item prices | ☐ | | | `ART_AMT` | `int64` | Line total | ☐ | | | `ART_CODE` | `string(15)` | Article Code | ☐ | | | `ART_DATE` | `datetime` | Original delivery date | ☐ | | | `ART_PX` | `int64` | Sales/purchase price | ☐ | | | `ART_QTY` | `decimal` | Original quantity ordered | ☐ | | | `ART_WEEK` | `int32` | Original delivery date (week) | ☐ | | | `CNG_DATE` | `datetime` | Date modified | ☐ | | | `CNG_NR` | `int32` | Change number | ☐ | | | `CNG_USR` | `string(20)` | Employee last modified | ☐ | | | `COST_CODE` | `string(10)` | Cost centre code | ☐ | | | `CPY_ORD` | `boolean` | Copy delivery address and item description from sales order | ☐ | | | `CUR_CODE` | `string(3)` | Currency code | ☐ | | | `DEL_DATE` | `datetime` | Expected delivery date | ☐ | | | `DEL_WEEK` | `int32` | Expected delivery date (week) | ☐ | | | `DISC_PCT` | `decimal` | Discount percentage | ☐ | | | `EMP_NR` | `string(10)` | Employee code | ☐ | | | `GEN_TYPE` | `decimal` | Type | ☐ | | | `INP_DATE` | `datetime` | Entry date | ☐ | | | `INP_USR` | `string(20)` | Entered by employee | ☐ | | | `LOC_CODE` | `string(5)` | Warehouse location | ☐ | | | `NO_COLL` | `boolean` | Do not consolidate order | ☐ | | | `NO_OPT` | `boolean` | Do not optimise order | ☐ | | | `ORD_DATE` | `datetime` | Order date | ☐ | | | `ORD_QTY` | `decimal` | Quantity to order | ☐ | | | `ORD_QTYP` | `decimal` | Quantity to order (price unit) | ☐ | | | `ORD_QTYU` | `decimal` | Quantity to order (unit) | ☐ | | | `ORD_WEEK` | `int32` | Order date (week) | ☐ | | | `PACK_PX` | `decimal` | Sales/purchase price per unit | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PCT_LIST` | `string(5)` | Discount percentages price list | ☐ | | | `POL_ID` | `string(10)` | Unique code | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `SUB_NR` | `string(10)` | Customer/supplier number | ☐ | | | `UNT_CODE` | `string(10)` | Unit | ☐ | | | `UNT_CODEP` | `string(10)` | Price unit | ☐ | | | `UNT_PX` | `int64` | Sales/purchase price per price unit | ☐ | | | `WHS_CODE` | `string(5)` | Warehouse code | ☐ | |