Line

Determines whether or not to evaluate line level shipping-related charges. Value is either true or false (default).

QName: {http://xmlns.oracle.com/apps/scm/pricing/priceExecution/pricingProcesses/priceRequestService/}Line

Logical Business Objects

  • SCM : Pricing : Price Request

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contained by

Validate Sales Price

Contained by

Price Sales Transaction

Contained by

Get Sales Pricing Strategy

Contained by

Calculate Sales Totals

Contained by

Calculate Sales Order Totals

Handled by

Price Request Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

AllowCurrencyOverrideFlag

boolean

Indicate whether the currency can be overridden.

AllowPriceListUpdateFlag

boolean

Indicate whether a previously selected price list can be changed to a different price list.

AppliedPriceListId

long

Id of the price list applied.

AssessableValue

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The taxable amount in the currency that the sales order uses. The value is either the list price, or the net price, or a value that the user enters. The value is an extended amount.

AssessableValueCurrencyCode

string

Abbreviation that identifies the currency of the assessable value.

AssessableValueOverrideFlag

boolean

Indicates whether the user entered a value for attribute AssessableValue. Values include true: user entered a value. false: user didn't enter a value.

BillFromLocationAddress1

string

Address line 1 of the bill-from location.

BillFromLocationAddress2

string

Address line 2 of the bill-from location.

BillFromLocationAddress3

string

Address line 3 of the bill-from location.

BillFromLocationAddress4

string

Address line 4 of the bill-from location.

BillFromLocationCity

string

City of the bill-from location.

BillFromLocationCountry

string

Country of the bill-from location.

BillFromLocationCounty

string

County of the bill-from location.

BillFromLocationId

long

Indicates the bill from location ID

BillFromLocationPostalCode

string

Postal code of the bill-from location.

BillFromLocationProvince

string

Province of the bill-from location.

BillFromLocationState

string

State of the bill-from location.

BillToLocationAddress1

string

Address line 1 of the bill-to location.

BillToLocationAddress2

string

Address line 2 of the bill-to location.

BillToLocationAddress3

string

Address line 3 of the bill-to location.

BillToLocationAddress4

string

Address line 4 of the bill-to location.

BillToLocationCity

string

City of the bill-to location.

BillToLocationCountry

string

Country of the bill-to location.

BillToLocationCounty

string

County of the bill-to location.

BillToLocationId

long

Indicates the bill to location ID.

BillToLocationPostalCode

string

Postal code of the bill-to location.

BillToLocationProvince

string

Province of the bill-to location.

BillToLocationState

string

State of the bill-to location.

BillToPartyId

long

Indicates the bill to party ID.

BillToPartyName

string

Name that identifies the bill-to party.

BillToPartyNumber

string

Number that identifies the bill-to party.

BillToPartySiteId

long

indicates the bill to party site ID.

BillToPartySiteNumber

string

Number that identifies the bill-to party site.

ComponentIdPath

string

Item ID path for component items. Contains the Root Model Inventory Item Id to the immediate parent Inventory Item Id delimited with '>'

ComponentPath

string

Item Number path for component items. Contains the Root Model Item Number to the immediate parent Item Number delimited with '>'

DefaultCurrencyCode

string

Default currency code determined by the pricing strategy.

DefaultPriceListId

long

Id of the default price list.

DefaultTaxationCountry

string

Specifies the country of taxation for tax calculation purposes.

DocumentSubType

string

Classification used for both tax calculation and tax reporting depending upon the requirements of different countries.

ExemptionControlCode

string

Controls the application of exemptions to the transaction line during tax lines calculation.

ExtendedQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Rolled-up quantity for the Line. For standard items this value is the same as the line requested quantity. For configurable products the value is a product of the requested quantity of the line and all of its parent configurable items.

FinalDischargeLocationId

long

Indicates the location of the final destination for purchases made by a customer, and is applicable to all transactions at line level.

FirstPartyTaxRegistration

string

Tax registration that the first-party organization uses for the transaction.

FirstPartyTaxRegistrationId

long

Indicates the tax registration that the first party organization used for a transaction.

FulfillmentGeographyId

long

This attribute represents the geography ID of the fulfillment.

HeaderId

long

Identification of the parent header for the line.

IntendedUseClassificationCode

string

Abbreviation that identifies the classification that describes how the purchaser intends to use the item.

IntendedUseClassificationId

long

Indicates the classification purpose for which a product is used in a business by the purchaser.

InventoryItemId

long

Item to be priced.

InventoryItemNumber

string

The number of the item that pricing must price.

InventoryOrganizationCode

string

The code for the inventory Organization for this Inventory Item Number.

InventoryOrganizationId

long

The Inventory Organization Id for this Inventory Item. For anonymous browsing the value of this attribute may be null.

LineCategoryCode

string

Code used to identify the category of the line.

LineId

long

Id of the Line SDO entity.
  • Primary Key

LineQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Quantity requested to be priced. In the case of a component item, the value should be a relative quantity. In the case of standard items, value of LineQuantity and ExtendedQuality are equal.

LineQuantityUOMCode

string

The Quantity UOM Code

LineTypeCode

string

This identifies the action performed when the order line is fulfilled.

OverrideCurrencyCode

string

If the 'AllowCurrencyOverride' flag is set to be true on the pricing strategy, the value of this attribute will be be used as the default currency for any non-overridden currency on charges and totals.

OverridePriceListId

long

If allowed by pricing, this is the price list that user selects to override the price to for a particular line item.

OverridePriceListName

string

Name of the price list the user selects to override the price for a line item. Pricing uses this attribute only if a price list override is allowed. Name of the price list the user selects to override the price for a line item. Pricing uses this attribute only if a price list override is allowed.

PerModelUnitQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Indicates the unit quantity per root model for the lines of a configuration

PooLocationId

long

Indicates the location that initiates or negotiates a sales order for products and services. This ID represents the Point of Order Origin location.

PooPartyId

long

Indicates the party that initiates or negotiates a sales order for products and services. This ID represents the Point of Order Origin party identifier.

PooPartyName

string

Name that identifies the Point of Order Origin party. This party starts or negotiates a sales order for an item.

PooPartyNumber

string

Number that identifies the Point of Order Origin party. This party starts or negotiates a sales order for an item.

PriceAsOf

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

This attribute is used to compare effectivities on pricing setups. Caller (e.g. QOC) can default header PriceAsOf to lines.

PriceValidFrom

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Price valid from date.

PriceValidUntil

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Price valid until date.

PricedOn

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the line is priced. This attribute will be populated with the system date at the beginning of a pricing process.

PricingStrategyId

long

Id of the pricing strategy applied on this line.

PricingStrategyName

string

Name of the pricing strategy that pricing applied on this line.

ProductCategory

string

Classification of products as product categories for tax purposes.

ProductFiscalClassificationId

long

Classification of products based on the inventory item category for tax purposes.

ProductType

string

Classification of products as product types for tax purposes.

ReferenceLineId

long

Indicates the order line to be used as reference in returns pricing processing.

ReturnReasonCode

string

Indicates the return reason code.

RootCoverageLineId

long

Indicates the root coverage line in the hierarchy.

RootLineId

long

Top most root line Id.

RoundingBillToPartyId

long

Indicates the rounding bill to party ID.

RoundingBillToPartyName

string

Name that identifies the rounding bill-to party.

RoundingBillToPartyNumber

string

Number that identifies the rounding bill-to party.

RoundingShipToPartyId

long

Indicates the rounding ship to party ID.

RoundingShipToPartyNumber

string

Number that identifies the rounding ship-to party.

RoundingShiptoPartyName

string

Name that identifies the rounding ship-to party.

ServiceDuration

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Duration for the service.

ServiceDurationPeriodCode

string

Service duration period code.

ServiceEndDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Date when the service ends. This date applies to each item that is defined with the Sales Product Type as Installation, Subscription, and so on, and where the Service Duration Type is Fixed, Variable, or Open Ended.

ServiceStartDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Date when the service starts. This date applies to each item that is defined with the Sales Product Type as Installation, Subscription, and so on, and where the Service Duration Type is Fixed, Variable, or Open Ended.

ShipFromLocationAddress1

string

Address line 1 of the ship-from location.

ShipFromLocationAddress2

string

Address line 2 of the ship-from location.

ShipFromLocationAddress3

string

Address line 3 of the ship-from location.

ShipFromLocationAddress4

string

Address line 4 of the ship-from location.

ShipFromLocationCity

string

City of the ship-from location.

ShipFromLocationCountry

string

Country of the ship-from location.

ShipFromLocationCounty

string

County of the ship-from location.

ShipFromLocationId

long

Indicates the ship from location ID.

ShipFromLocationPostalCode

string

Postal code of the ship-from location.

ShipFromLocationProvince

string

Province of the ship-from location.

ShipFromLocationState

string

State of the ship-from location.

ShipFromOrganizationCode

string

Organization from where logistics ships the goods.

ShipFromOrganizationId

long

Organization from where the goods are shipped.

ShipFromPartyId

long

Indicates the ship from party ID.

ShipFromPartyName

string

Name that identifies the ship-from party.

ShipFromPartyNumber

string

Number that identifies the ship-from party.

ShipFromPartySiteId

long

Indicates the ship from party site ID.

ShipFromPartySiteNumber

string

Number that identifies the ship-from party site.

ShipMethodCode

string

Abbreviation that identifies the shipping method, such as overnight. Logistics uses this method to transfer goods from one destination to another destination.

ShipMethodId

long

The shipping method such as UPS-Parcel-Ground used for transfer of goods from one destination to another.

ShipToLocationAddress1

string

Address line 1 of the ship-to location.

ShipToLocationAddress2

string

Address line 2 of the ship-to location.

ShipToLocationAddress3

string

Address line 3 of the ship-to location.

ShipToLocationAddress4

string

Address line 4 of the ship-to location.

ShipToLocationCity

string

City of the ship-to location.

ShipToLocationCountry

string

Country of the ship-to location.

ShipToLocationCounty

string

County of the ship-to location.

ShipToLocationId

long

indicates the ship to location ID.

ShipToLocationPostalCode

string

Postal code of the ship-to location.

ShipToLocationProvince

string

Province of the ship-to location.

ShipToLocationState

string

State of the ship-to location.

ShipToPartyId

long

Indicates the ship to party ID.

ShipToPartyName

string

Name that identifies the ship-to party.

ShipToPartyNumber

string

Number that identifies the ship-to party.

ShipToPartySiteId

long

Indicates the ship to party site ID.

ShipToPartySiteNumber

string

Number that identifies the ship-to party site.

SkipShippingChargesFlag

boolean

Indicates the line to be skipped to apply shipping charges when true. Values: true or false.

TaxClassificationCode

string

Indicates the tax codes or groups defined in Fusion Payables.

TaxExemptionCertificateNumber

string

Number used in conjunction with Tax Exemption Reason Code for tax exemption handling.

TaxExemptionReasonCode

string

Code used in conjunction with Tax Exemption Certificate Number for tax exemption handling.

ThirdPartyTaxRegistrationId

long

Indicates the Tax Registration Number used by the third party involved in the transaction.

ThirdPartyTaxRegistrationNumber

string

Tax registration that the third-party organization uses for the transaction.

TradingHQLocationAddress1

string

Address line 1 of the trading headquarters location.

TradingHQLocationAddress2

string

Address line 2 of the trading headquarters location.

TradingHQLocationAddress3

string

Address line 3 of the trading headquarters location.

TradingHQLocationAddress4

string

Address line 4 of the trading headquarters location.

TradingHQLocationCity

string

City of the trading headquarters location.

TradingHQLocationCountry

string

Country of the trading headquarters location.

TradingHQLocationCounty

string

County of the trading headquarters location.

TradingHQLocationId

long

Indicates the trading HQ location ID.

TradingHQLocationPostalCode

string

Postal code of the trading headquarters location.

TradingHQLocationProvince

string

Province of the trading headquarters location.

TradingHQLocationState

string

State of the trading headquarters location.

TradingHQPartySiteId

long

Indicates the trading HQ party site ID.

TradingHQPartySiteNumber

string

Number that identifies the site where the trading headquarters party resides.

TransactionBusinessCategory

string

Classifies a transaction for tax purposes, as required by a tax authority.

TransactionOn

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

This attribute stores the date of the transaction.

UserDefinedFiscalClassificationCode

string

Additional classification of a transaction for tax purpose, as required by a tax authority.

UserDefinedFiscalClassificationId

long

Additional classification of a transaction for tax purpose, as required by a tax authority.