PurchaseOrder Table

FlexNet Manager Suite 2020 R1 (On-Premises)

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.

FlexNet Manager Suite (On-Premises)

2020 R1