PurchaseOrderDetail Table

The PurchaseOrderDetail table contains a list of all the individual purchase order lines 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 PurchaseOrderDetail table

Database Column

Details

PurchaseOrderDetailID

Type: integer. Key. Generated ID

A unique identifier for the purchase order line.

PurchaseOrderID

Type: integer. Key

The parent purchase order to which this line belongs. Foreign key to the PurchaseOrder table.

PurchaseOrderDetail ParentID

Type: integer. Nullable

When a purchase order line is nested as a child of another, this link identifies the parent. Foreign key to another purchase order line in this PurchaseOrderDetail table.

ItemDescription

Type: text (max 250 characters)

A description of the item ordered in this PO line.

SequenceNumber

Type: integer. Key

The sequence number of the PO line in the overall purchase order.

PartNo

Type: text (max 100 characters). Nullable

Deprecated, use LicensePartNo.

Quantity

Type: integer. Nullable

The quantity of items purchased in this PO line.

QuantityPerUnit

Type: integer. Nullable

Where the purchase order refers to software licenses, this is the quantity of license included in per unit of this purchase order.

EffectiveQuantity

Type: integer. Nullable

The license entitlemets brought in by this purchase. If the total for this column would exceed the maximum allowable for int, then the total will be reduced to this number.

LicenseQuantity

Type: integer. Nullable

Where the purchase order refers to software licenses, this is the number of license entitlements conferred by the item ordered in this line. This is distinct from the purchase quantity on the line item. For example, it would be possible to order “Qty 50 of XYZ license 10-pack”, which would mean a Quantity field of 50 and a LicenseQuantity of 500.

LicensePartNo

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

The part number or SKU of the item ordered in this PO line.

UnitPrice

Type: currency. Nullable

The unit price of items ordered on this PO line.

UnitPriceRateID

Type: integer. Nullable

The currency rate to be applied to the above unit price. Foreign key to the CurrencyRate table.

SalesTax

Type: currency. Nullable

The amount of sales tax paid on this PO line item. May be left null if sales tax is only entered on the purchase order header.

SalesTaxRateID

Type: integer. Nullable

The currency rate to be applied to the above sales tax. Foreign key to the CurrencyRate table.

TotalPrice

Type: currency. Nullable

The total price of items in this PO line.

TotalPriceRateID

Type: integer. Nullable

The currency rate to be applied to the above total price. Foreign key to the CurrencyRate table.

AutoCalculateTotal

Type: boolean

Set this field to True (the default) for the total price to be caclulated automatically as (UnitPrice * Quantity) + ShippingAndHandling + SalesTax. If False, the operator must enter the total manually.

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 above shipping and handling costs. Foreign key to the CurrencyRate table.

InheritPOContractID

Type: boolean. Key

A bit which, if set to 1 (the default), means that the following contract ID is inherited from the parent purchase order.

ContractID

Type: integer. Key. Nullable

A link to a contract related to this PO line. Foreign key to the Contract table.

InheritPOShippingDetails

Type: boolean

Set this field to True (the default) for the following shipping details to be inherited from the parent purchase order. If False, an operator has to complete the following details manually.

ShippingDate

Type: datetime. Nullable

The date the product was shipped.

ShippingMethodID

Type: integer. Nullable

The delivery method used to deliver the item ordered in this PO line. Foreign key to the ShippingMethod table.

ShippingLocationID

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

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

MaintenanceOrService Agreement

Type: boolean

Set this field to True when this PO line includes maintenance or another type of service agreement. If False (the default), there is no maintenance or ofther service agreement associated with this PO line.

EffectiveDate

Type: datetime. Nullable

The effective date for the Purchase Order Line.

ExpiryDate

Type: datetime. Nullable

The expiry date for the Purchase Order Line.

InheritPOEnterpriseGroups

Type: boolean

Set this field to True (the default) for the following enterprise groups to be inherited from the parent purchase order. If False, an operator has to complete the following details manually.

LocationID

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

Any enterprise location associated with this PO line. Foreign key to the GroupEx table.

BusinessUnitID

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

Any corporate unit within the enterprise associated with this PO line. Foreign key to the GroupEx table.

CostCenterID

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

Any enterprise cost center associated with this PO line. Foreign key to the GroupEx table.

CategoryID

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

Any category used within the enterprise associated with this PO line. Foreign key to the GroupEx table.

InheritPOProcessDetails

Type: boolean

Set this field to True (the default) for the following process details to be inherited from the parent purchase order. If False, an operator has to complete the following details manually.

RequestNo

Type: text (max 60 characters). Nullable

The request number for the PO line.

RequestDate

Type: datetime. Nullable

The date the related product was requested.

RequestedByID

Type: integer. Key. Nullable

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

AuthorizedByID

Type: integer. Key. Nullable

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

ProcessedByID

Type: integer. Key. Nullable

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

Comments

Type: text. Nullable

Comments recorded about the purchase order line.

InheritPOInvoiceDetails

Type: boolean

Set this field to True (the default) for the following invoicing details to be inherited from the parent purchase order. If False, an operator has to complete the following details manually.

InvoiceNo

Type: text (max 50 characters). Nullable

The invoice number relating to this PO line.

InvoiceDate

Type: datetime. Nullable

The invoice date for the purchase order line.

OrderedProduct

Type: text (max 256 characters). Nullable

A description of the item ordered in this PO line.

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.

ExternalID

Type: text (max 32 characters). Nullable

A text field where an operator may record the ID of the PO line in any external system it was imported from.

PurchaseOrderDetailTypeID

Type: integer. Key

The type of the PO line. Foreign key to the PurchaseOrderDetailType table.

MSSelectPoolID

Type: integer. Nullable

Identifies the Microsoft Select pool. Foreign key to the MSSelectPool table.

MSSelectPoints

Type: decimal. Nullable

The number of points consumed by this purchase.

AutoAcceptRecommendation

Type: boolean

Set this field to True to automatically accept recommendation calculated for this purchase order line in Link Licenses node.

SoftwareSkuID

Type: integer. Key. Nullable

The SKU that was recognized. This value is optional. Foreign key to the SoftwareSku table.

PurchaseOrderDetail StatusID

Type: integer

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

PublisherID

Type: integer. Nullable

The publisher of this line item. This value is optional. Foreign key to the Vendor table.

UUID

Type: unique identifier

The UUID of the contract for external reference.