Fields - Purchase Order Line
Fields
| Field Name | Data Type | Description, Example |
|---|---|---|
| purchaseorderlineid | bigint | Unique line identifier |
| purchaseorderid | bigint | Purchase order identifier |
| partnumber | text | Item part number |
| secondarypartnumber | text | Alternate part number |
| suppliercode | text | Supplier code |
| description | text | Item description |
| categorycode | text | Category code |
| cost | money | Item cost |
| orderedqty | integer | Quantity ordered |
| receivedqty | integer | Quantity received |
| soldqty | integer | Quantity sold |
| cancelledqty | integer | Quantity cancelled |
| backorderedqty | integer | Quantity backordered |
| specialorderid | bigint | Special order identifier |
| specialorderlineid | bigint | Special order line identifier |
| receivingnotes | text | Receiving notes |
| iscompleted | smallint | Completion status |
| backordereddate | timestamp without time zone | Backorder date |
| cancelleddate | timestamp without time zone | Cancellation date |
| receiveddate | timestamp without time zone | Date received |
| etadate | timestamp without time zone | Estimated arrival date |
| weborderitemid | bigint | Web order item identifier |
| oemmessage | text | OEM message |
| oemlineid | text | OEM line identifier |
| storeid | integer | Store identifier |
| storeidluid | bigint | Store LUID identifier |