Fields - Purchase Order
Fields
| Field Name | Data Type | Description, Example |
|---|---|---|
| purchaseorderid | bigint | Purchase order identifier |
| purchaseordernumber | integer | Purchase order number |
| supplierordernumber | text | Supplier order number |
| ordersuppliercode | text | Order supplier code |
| orderdate | timestamp without time zone | Order date |
| lastmodifieddate | timestamp without time zone | Last modified date |
| shipdate | timestamp without time zone | Ship date |
| ordertype | text | Order type |
| shipvia | text | Shipping method |
| orderterms | text | Order terms |
| allreceived | smallint | All items received status |
| isuploaded | smallint | Upload status |
| supplierreference | text | Supplier reference |
| dropship | boolean | Drop ship indicator |
| createdbyoem | boolean | Created by OEM indicator |
| oemorderid | text | OEM order identifier |
| oeminitialorder | boolean | OEM initial order indicator |
| rimorder | boolean | RIM order indicator |
| storeid | integer | Store identifier |
| storeidluid | bigint | Store LUID identifier |
| note | text | Order note |