BlanketPOs Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
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. |