BlanketPOs Table
The BlanketPOs table in the profiles database contains information about blanket purchase orders.
The following table describes the columns in the BlanketPOs table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
u_org_id |
nvarchar(50) |
yes |
The ID of the organization that issued the blanket purchase order. |
u_po_id |
nvarchar(50) |
no |
The ID of the blanket purchase order. This is the primary key. |
u_po_number |
nvarchar(255) |
no |
The blanket purchase order number. |
u_description |
nvarchar(255) |
yes |
A description of the blanket purchase order. |
u_user_id_changed_by |
nvarchar(50) |
yes |
The Windows user ID of the person who last modified the blanket purchase order record. |
dt_date_last_changed |
datetime |
yes |
The date that changes were last made to the blanket purchase order record. |
dt_csadapter_date_last_changed |
datetime |
yes |
The date the blanket purchase order record was last updated by BizTalk Server. |
dt_date_created |
datetime |
yes |
The date that the blanket purchase order was created. |