Order Addresses

The Order Addresses view object that extracts customer, account, and address details from the sales orders.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.OrderAddressExtractPVO

Primary Keys : OrderAddressId

Initial Extract Date : OrderAddressCreationDate

Incremental Extract Date : OrderAddressLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
OrderAddressContactId	Value that identifies the contact of the customer.
OrderAddressCreatedBy	User who created the order address row.
OrderAddressCreationDate	Date when the order address row was created.
OrderAddressCustAccountContactId	Value that identifies the contact of the account.
OrderAddressCustAcctId	Value that identifies the account of the customer.
OrderAddressCustAcctSiteUseId	Value that identifies the address of the account.
OrderAddressDeltaType	Value that identifies the type of change, such as update, cancel, and so on. Order Management uses this values when processing change order.
OrderAddressFulfillLineId	Value that identifies the fulfillment line associated to the order address row. This is a foreign key to the Fulfillment Lines view object.
OrderAddressHeaderId	Value that identifies the sales order header associated to the order address row. This is a foreign key to the Sales Order Headers view object.
OrderAddressId	Value that uniquely identifies the order address row. This is the primary key of the Order Addresses view object.
OrderAddressLastUpdateDate	Date when the order address row was last updated.
OrderAddressLastUpdateLogin	Session login associated to the user who most recently updated the order address row.
OrderAddressLastUpdatedBy	User who most recently updated the order address row.
OrderAddressModifiedFlag	Indicates whether the order address row has been modified. A list of accepted values is defined in the lookup type YES_NO. The default value is N.
OrderAddressObjectVersionNumber	Number of times the order address row has been updated.
OrderAddressPartyId	Value that identifies the customer.
OrderAddressPartySiteId	Value that identifies the address of the customer.
OrderAddressPrefContactPointId	Value that identifies the preferred contact point for the customer or account.
OrderAddressReferenceAddressId	Value that identifies the previous order address row. Order Management uses this values when processing change order.
OrderAddressUseType	Code that identifies the type of order address. Contains one of the following values: SHIP_TO, BILL_TO, or SUPPLIER.