BlanketPOs Profile Schema
An instance of this profile schema stores purchase orders issued by an organization. The profile is mapped to the physical BlanketPOs table. The Commerce Server Core Systems User Import DTS Task extends and exports data into the Data Warehouse for properties with the Exported (Exp) attribute marked as True (1). For information about the table entries, see Conventions.
Property Name |
Data Type |
Req |
Exp |
Group |
Display Name/ Description |
|---|---|---|---|---|---|
po_id (primary and join key) |
GUID |
T |
T |
GeneralInfo |
Unique ID of the purchase order |
org_id |
GUID |
F |
F |
GeneralInfo |
ID of the organization this purchase order is associated with |
po_number |
Unicode String |
T |
F |
GeneralInfo |
Numeric ID of this purchase order |
description |
Unicode String |
F |
F |
GeneralInfo |
Description of this purchase order |
user_id_changed_by |
Unicode String |
F |
F |
ProfileSystem |
ID of the user that last changed this purchase order |
date_last_changed |
Date Time |
F |
F |
ProfileSystem |
Date that this purchase order was last changed |
date_created |
Date Time |
F |
F |
ProfileSystem |
Date that this purchase order was created |
csadapter_date_last_changed |
Date Time |
F |
F |
ProfileSystem |
Reserved for BizTalk adapter functionality |