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.

See Also

Other Resources

Profiles System Database Tables