PurchaseOrder Table

The PurchaseOrder table contains a list of all the purchase orders in the system.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for PurchaseOrder table

Database Column

Details

PurchaseOrderID

Type: integer. Key. Generated ID

A unique identifier for the purchase order.

PurchaseOrderNo

Type: text (max 50 characters). Key

The purchase order number.

ShortDescription

Type: text (max 250 characters). Nullable

A short description of the purchase order.

PurchaseOrderDate

Type: datetime

The date recorded for the purchase order.

PurchaseOrderStatusID

Type: integer. Nullable

The current state of the purchase order. Foreign key to the PurchaseOrderStatus table. The default value of 1 links to a “New” status.

PurchaseOrderTypeID

Type: integer. Nullable

The type of the purchase order. Foreign key to the PurchaseOrderType table.

InvoiceNo

Type: text (max 50 characters). Nullable

The invoice number that relates to the purchase order.

InvoiceDate

Type: datetime. Nullable

The date on the invoice that relates to the purchase order.

TotalPrice

Type: currency. Nullable

The total price of the purchase order.

TotalPriceRateID

Type: integer. Nullable

The currency rate to be applied to this purchase order. Foreign key to the CurrencyRate table.

ShippingAndHandling

Type: currency. Nullable

The amount of money spent on shipping and handling.

ShippingAndHandlingRateID

Type: integer. Nullable

The currency rate to be applied to the shipping and handling costs related to this purchase order. Foreign key to the CurrencyRate table.

SalesTax

Type: currency. Nullable

The amount of sales tax paid as part of this purchase order.

SalesTaxRateID

Type: integer. Nullable

The currency rate to be applied to the sales tax related to this purchase order. Foreign key to the CurrencyRate table.

AutoCalculateCostFrom Children

Type: boolean

The default value of True indicates that the total price, shipping, and sales tax values should be calculated from the purchase order lines that are children of this purchase order. A value of False means that these values are manually inserted into this purchase order header.

ShippingMethodID

Type: integer. Nullable

The type shipping used to deliver the product. Foreign key to the ShippingMethod table.

ShippingLocationID

Type: text (max 128 characters). Key. Nullable

The location to which the ordered material is shipped. Foreign key to the GroupEx table.

ShippingDate

Type: datetime. Nullable

The date the ordered material was shipped.

RequestNo

Type: text (max 60 characters). Nullable

The request number for the purchase order.

RequestDate

Type: datetime. Nullable

The date the purchase order was requested.

RequestedByID

Type: integer. Key. Nullable

The person who requested the purchase order. Foreign key to the ComplianceUser table.

AuthorizedByID

Type: integer. Key. Nullable

The person who authorized the purchase order. Foreign key to the ComplianceUser table.

ProcessedByID

Type: integer. Key. Nullable

The person who processed the purchase order. Foreign key to the ComplianceUser table.

Comments

Type: text. Nullable

Comments recorded about the purchase order.

VendorID

Type: integer. Key. Nullable

The vendor fulfilling this purchase order. Foreign key to the Vendor table.

ContractID

Type: integer. Key. Nullable

Foreign key to the Contract table, identifying any existing contract related to this purchase order.

LocationID

Type: text (max 128 characters). Key. Nullable

Any enterprise location associated with this purchase order. Foreign key to the GroupEx table.

BusinessUnitID

Type: text (max 128 characters). Key. Nullable

Any corporate unit in the enterprise associated with this purchase order. Foreign key to the GroupEx table.

CostCenterID

Type: text (max 128 characters). Key. Nullable

Any cost center in the enterprise associated with this purchase order. Foreign key to the GroupEx table.

CategoryID

Type: text (max 128 characters). Key. Nullable

Any enterprise category associated with this purchase order. Foreign key to the GroupEx table.

CreationUser

Type: text (max 128 characters). Nullable

The operator who created the record.

CreationDate

Type: datetime

The date the record was created.

UpdatedUser

Type: text (max 128 characters). Nullable

The operator who last updated the record.

UpdatedDate

Type: datetime. Nullable

The date the record was last updated.

UUID

Type: unique identifier

The UUID of the contract for external reference.