Attribute Values for Transactional Items for Order Lines

Input information to the Change Order Allowed Attribute service, including information that identifies a line, and the list of attributes.

QName: {http://xmlns.oracle.com/apps/scm/doo/decomposition/orderDetailServices/orderInformationService/}ChangeAllowedAttributeLineRequest

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

Contains

Extensible Flexfield Contexts, Grouped for Order Line

Contained by

Attribute Values for Transactional Items for Order Lines

Handled by

Order Information Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

AccountingRule

string

Accounting Rule Identifier to determine the accounting period or periods in which the revenue distributions for an invoice line are recorded.

AccountingRuleCode

string

Code that represents an accounting rule that determines the accounting period or periods in which the revenue distributions for an invoice line are recorded.

AdditionalFulfillmentLineInformationCategories

Extensible Flexfield Contexts, Grouped for Order Line

Provides information on the FulfillLine Eff Categories.

AssessableValue

decimal

Price at which a product is valued by a tax authority for a given tax.

BillToAccountContactIdentifier

long

Reference to the unique identifier for the bill-to customer contact

BillToAccountContactName

string

Indicates the contact name for the billing address.

BillToAccountContactNumber

string

Indicates the contact number for the billing address.

BillToAccountPersonFirstName

string

Bill To Account Person FirstName

BillToAccountPersonLastName

string

Bill To Account Person Last Name

BillToAccountPersonMiddleName

string

Bill To Account Person MiddleName

BillToAccountPersonNameSuffix

string

Bill To Account Person Name Suffix

BillToAccountPersonTitle

string

Bill To Account Person Title

BillToAccountSiteUseIdentifier

long

Reference to the unique identifier for the bill-to customer location

BillToAddress1

string

Address Line1 of the party site responsible for the payment

BillToAddress2

string

Address Line2 of the party site responsible for the payment

BillToAddress3

string

Address Line3 of the party site responsible for the payment

BillToAddress4

string

Address Line4 of the party site responsible for the payment

BillToCity

string

City of the party site responsible for the payment

BillToContactFirstName

string

BillTo Contact FirstName

BillToContactLastName

string

BillTo Contact LastName

BillToContactMiddleName

string

BillTo Contact MiddleName

BillToContactNameSuffix

string

BillTo ContactName Suffix

BillToContactTitle

string

BillTo Contact Title

BillToCounty

string

County of the party site responsible for payment.

BillToCustomerIdentifier

long

Identifier of the party legally responsible for the payment.

BillToCustomerName

string

Name of the Party legally responsible for the payment

BillToCustomerNumber

string

Number of the party legally responsible for the payment.

BillToPartyType

string

BillTo Party Type

BillToPostalCode

string

Postal Code of the party site responsible for the payment

BillToProvince

string

Province of the party site responsible for payment

BillToState

string

State of the party site responsible for payment

BusinessUnitIdentifier

long

The internal organization identifier thats Fulfilling the Order

BusinessUnitName

string

The internal organization name thats Fulfilling the Order

CancelReason

string

Reason Provided for Cancellation Request

CancelReasonCode

string

Code that represents the reason the line was canceled.

Comments

string

Comments for the line.

CustomerPOLineNumber

string

Unique identifier of the line record of a transaction. The purchase order line describes an item or service, with a price and quantity ordered.

CustomerPONumber

string

Commercial document that is used to request that a seller supply a product or service in return for payment.

CustomerPOScheduleNumber

string

Contains the customer's purchase order shipment schedule number, if specified, while submitting an order.

CustomerProductIdentifier

long

Unique identifier of the customer item.

DefaultTaxationCountry

string

Country used for tax calculation purposes.

DefaultTaxationCountryShortName

string

Default Taxation Country Short Name

DemandClass

string

A demand class may represent a particular grouping of customers, such as governmental and commercial customers, or it may represent sales channels or regions. Demand classes which can represent different sources of demand, such as retail, mail order, and wholesale.

DemandClassCode

string

Demand class used by the order promising engine to consume target allocation amounts.

DestinationShippingAddressCity

string

Destination Shipping Address City

DestinationShippingAddressCountry

string

Destination Shipping Address Country

DestinationShippingAddressCounty

string

Destination Shipping Address County

DestinationShippingAddressLine1

string

Destination Shipping Address Line1

DestinationShippingAddressLine2

string

Destination Shipping Address Line2

DestinationShippingAddressLine3

string

Destination Shipping Address Line3

DestinationShippingAddressLine4

string

Destination Shipping Address Line4

DestinationShippingAddressPostalCode

string

Destination Shipping Address Postal Code

DestinationShippingAddressProvince

string

Destination Shipping Address Province

DestinationShippingAddressState

string

Destination Shipping Address State

DestinationShippingLocationIdentifier

long

Destination Location to which the product is Shipped

DestinationShippingOrganizationCode

string

Destination Shippping Organization Code

DestinationShippingOrganizationIdentifier

long

Destination Org to which the product is Shipped

DestinationShippingOrganizationName

string

Destination Shippping Organization Name

DocumentSubType

string

Classification that is used for tax calculation and tax reporting, depending upon the requirements of different countries.

DocumentSubTypeName

string

Document Sub Type Name that is used for tax calculation and tax reporting depending upon the requirements of different countries.

EarliestAcceptableArrivalDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Earliest date that the customer is willing to receive a product.

EarliestAcceptableShipDate

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

Earliest date that the customer is willing to receive a shipment.

ExtendedAmount

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

Monetary amount of the order line quantity.

FOBPoint

string

FOB point

FOBPointCode

string

Code that indicates the point at which the responsibility of the goods transfers from shipper to buyer.

FinalDischargeLocationAddressCity

string

Final Discharge Location Address City

FinalDischargeLocationAddressCountry

string

Final Discharge Location Address Country

FinalDischargeLocationAddressCounty

string

Final Discharge Location Address County

FinalDischargeLocationAddressLine1

string

Final Discharge Location Address Line1

FinalDischargeLocationAddressLine2

string

Final Discharge Location Address Line2

FinalDischargeLocationAddressLine3

string

Final Discharge Location Address Line3

FinalDischargeLocationAddressLine4

string

Final Discharge Location Address Line4

FinalDischargeLocationAddressPostalCode

string

Final Discharge Location Address Postal Code

FinalDischargeLocationAddressProvince

string

Final Discharge Location Address Province

FinalDischargeLocationAddressState

string

Final Discharge Location Address State

FinalDischargeLocationIdentifier

long

This is the final destination location for the purchases made by the customer.

FirstPartyTaxRegistration

long

This is the registration which is quoted to the supplier. Supplier would use this to tax the transaction.

FirstPartyTaxRegistrationNumber

string

Registration number that is quoted to the supplier. Supplier uses this number to tax the transaction.

FreightTerms

string

Identifies the terms for paying freight charges, i.e. paid by shipper, collect, prepaid, etc

FreightTermsCode

string

Code that represents the terms specifying the responsibility for freight charges.

FulfillmentLineIdentifier

long

Unique Identifier of the Fulfillment Line that can be used to identify the specific Fulfillment line that is being referenced in context of Change.

IntendedUseClassificationIdentifier

long

Unique identifier of the classification for intended use of the item for tax calculation purposes.

IntendedUseClassificationName

string

Intended Use Classification Name

InventoryOrganization

string

This is the Inventory Organization the product belongs to.

InventoryOrganizationIdentifier

long

Unique identifier of the inventory organization.

InvoicingRule

string

Invoicing rules to determine when to recognize receivable for invoices

InvoicingRuleCode

string

Code that represents invoicing rules that determine when to recognize a receivable for invoices.

LatestAcceptableArrivalDate

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

Latest date that the customer is willing to receive a product.

LatestAcceptableShipDate

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

Latest date that the customer is willing to have a warehouse ship a product.

OrderedQuantity

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

Quantity of an ordered good or service.

OrderedUOM

string

Ordered UOM

OrderedUOMCode

string

Unit of measure for the quantity ordered. A predetermined amount, quantity, or quality that is adopted as a standard of measurement. Examples: length, time, heat, value.

OriginalProductIdentifier

long

The internal id of the product thats originally requested or ordered and which was subsequently substituted

OriginalProductNumber

string

Displayed Name of the Product that is being fulfilled

PackingInstructions

string

Document that contains information concerning the packing of an item.

ParentLineReference

string

Alphanumeric reference of the line that is the immediate parent of this line in a configurable product hierarchy or in any other situation with parent-child relationships.

PartialShipAllowedFlag

boolean

Indicates that the items on the order can be shipped in multiple shipments, rather than as one shipment.

PaymentTerms

string

The payment terms to apply to collection of this payment.

PaymentTermsCode

string

Code that represents payment terms to apply to collect this payment.

PreferredBillToContactPointIdentifier

long

Identifier of a bill-to contact point.

PreferredBillToContactPointOrigSystemReference

string

PreferrredBillToContactPointOrigSystemReference

PreferredShipToContactPointIdentifier

long

Identifier of a ship-to contact point

PreferredShipToContactPointOrigSystemReference

string

Preferred Ship To Contact Point Orig System Reference

ProductCategory

string

Product classification for tax purposes.

ProductCategoryName

string

Product Ctaegory Name

ProductDescription

string

Display Name of the product that is being fulfilled.

ProductFiscalCategoryIdentifier

long

Unique identifier of the classification of the products by tax authority for tax purposes.

ProductFiscalCategoryName

string

Product Fiscal Category Name

ProductIdentifier

long

Unique identifier of the inventory item.

ProductNumber

string

SKU of product that is being fulfilled.

ProductType

string

Product-related classification in Oracle Fusion Tax. The value of the product type specifies whether the transaction line is for a good or service, or whether it is a memo line.

ProductTypeName

string

Product Type Name

PromiseArrivalDate

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

Date that was promised to the customer that the item would arrive.

PromiseShipDate

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

Date that was promised to the customer that the item would ship.

QuantityPERModel

decimal

Component quantity for a single model.

RequestCancelDate

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

Date that the customer canceled the line.

RequestedArrivalDate

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

Original date the customer requested the to item arrive.

RequestedFulfillmentOrganizationCode

string

Code that represents the organization from which the product was shipped.

RequestedFulfillmentOrganizationIdentifier

long

Unique identifier of the fulfillment organization.

RequestedFulfillmentOrganizationName

string

Organization Name from which the shipment was actually shipped.

RequestedShipDate

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

Original date the customer requested the item to ship.

RequestedSupplierCode

string

This will hold the value for Supplier on whom Purchase Order is created.

RequestedSupplierName

string

Supplier responsible for shipment of the product. A specific supplier may be used based on contractual obligations in drop ship

RequestedSupplierNumber

string

Supplier number responsible for shipment of the product. A specific supplier may be used based on contractual obligations in drop ship

RequestedSupplierSiteCode

string

Supplier responsible for shipment of the product. A specific supplier may be used based on contractual obligations in drop ship

RequestingBusinessUnitIdentifier

long

The internal organization identifier that initiated/captured this transaction

RequestingBusinessUnitName

string

The internal organization that initiated/captured this transaction

RequiredFulfillmentDate

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

Customer required fulfillment date.

ReturnReason

string

Reason Code expressed by customer for wanting to return the product

ReturnReasonCode

string

Code that represents the justification for a return of a specific product. Many companies have standard reasons that are assigned to returns to be used to analyze the quantity and types of returns.

RootParentLineReference

string

Alphanumeric reference of the line at the root of the configurable product hierarchy that the line is a component of.

ScheduleArrivalDate

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

Date the shipment is scheduled to arrive.

ScheduleShipDate

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

Date when goods are expected to be shipped.

ShipSetName

string

Group of order lines within an order that need to ship together from their common origin to a common destination and which have the same scheduled ship date.

ShipToAddress1

string

Address Line1 where the goods are to be sent.

ShipToAddress2

string

Address Line2 where the goods are to be sent.

ShipToAddress3

string

Address Line3 where the goods are to be sent.

ShipToAddress4

string

Address Line4 where the goods are to be sent.

ShipToCity

string

City where the goods are to be sent.

ShipToContactFirstName

string

Ship To Contact FirstName

ShipToContactLastName

string

Ship To Contact LastName

ShipToContactMiddleName

string

Ship To Contact MiddleName

ShipToContactNameSuffix

string

Ship To Contact NameSuffix

ShipToContactTitle

string

Ship To Contact Title

ShipToCounty

string

County where the goods are sent

ShipToPartyContactIdentifier

long

Indicates the contact for the shipping address.

ShipToPartyContactName

string

Indicates the contact name for the shipping address.

ShipToPartyContactNumber

string

Indicates the contact number for the shipping address.

ShipToPartyIdentifier

long

Indicates the party the goods are to be sent.

ShipToPartyName

string

Indicates the party name the goods are to be sent.

ShipToPartyNumber

string

Indicates the party number the goods are to be sent.

ShipToPartyPersonFirstName

string

Ship To Party Person First Name

ShipToPartyPersonLastName

string

Ship To Party Person Last Name

ShipToPartyPersonMiddleName

string

Ship To Party Person Middle Name

ShipToPartyPersonNameSuffix

string

Ship ToParty Person Name Suffix

ShipToPartyPersonTitle

string

Ship To Party Person Title

ShipToPartySiteIdentifier

long

Reference to the unique identifier for the ship-to Party Site.

ShipToPartyType

string

Ship To Party Type

ShipToPostalCode

string

Postal Code where the goods are to be sent

ShipToProvince

string

Province where the goods are to be sent

ShipToRequestRegion

string

Attribute used by GOP for region based promising.

ShipToState

string

State where the goods are to be sent

ShipmentPriority

string

Shipment priority enables to group shipments into different categories of urgency

ShipmentPriorityCode

string

Code that represents the priority of the fulfillment lines to be shipped.

ShippingCarrier

string

shipping Carrier that actually delivered the goods.

ShippingCarrierCode

string

Identifier of the shipping Carrier that actually delivered the goods.

ShippingInstructions

string

Message on a document that provides details about cargo and any requirements for its physical movement.

ShippingMode

string

Shipping Mode that was actually used to deliver the goods.

ShippingModeCode

string

Code that represents the type of transportation used to ship the product, such as truck, air, or boat.

ShippingServiceLevel

string

Shipping Level of Service to be used for delivery of the shipment.

ShippingServiceLevelCode

string

Code that represents the priority of transportation that affects how quickly goods are transported.

SourceTransactionIdentifier

string

Unique identifier of the transaction in the system that captured the transaction.

SourceTransactionLineIdentifier

string

Unique identifier of the transaction line from the system that captured the transaction.
  • Primary Key

SourceTransactionLineNumber

string

Number of the transaction line from the system that captured the transaction.

SourceTransactionNumber

string

Order Capture order number that is the origin of the contract line.

SourceTransactionRevisionNumber

long

The revision number of the transaction

SourceTransactionScheduleIdentifier

string

Unique identifier of a schedule, shipment, or subline, as assigned by the system that captured the transaction.
  • Primary Key

SourceTransactionScheduleNumber

string

Number of a schedule, shipment, or subline, as assigned by the system that captured the transaction.

SourceTransactionSystem

string

System or application that submitted the order request.

SubInventory

string

Sub Inventory

SubInventoryCode

string

Code that represents the physical or logical location of the item.

SubstitutionAllowedFlag

boolean

Indicates that items on the fulfillment line can be substituted for various reasons like shortage of material, or as a goodwill gesture to the customer.

SubstitutionReasonCode

string

Code that describes why an item was substituted on a fulfillment line.

SupplierAddressCity

string

City of the supplier from where the items are to be shipped.

SupplierAddressCountry

string

Country of the supplier from where the items are to be shipped.

SupplierAddressCounty

string

County of the supplier from where the items are to be shipped.

SupplierAddressLine1

string

Address Line 1of the supplier from where the items are to be shipped.

SupplierAddressLine2

string

Address Line 2of the supplier from where the items are to be shipped.

SupplierAddressLine3

string

Address Line 3of the supplier from where the items are to be shipped.

SupplierAddressLine4

string

Address Line 4of the supplier from where the items are to be shipped.

SupplierAddressProvince

string

Province of the supplier from where the items are to be shipped.

SupplierAddressState

string

State of the supplier from where the items are to be shipped.

SupplierAddressZipCode

string

Postal Code of the supplier from where the items are to be shipped.

TaxClassification

string

Tax Classification

TaxClassificationCode

string

Code that represents a grouping of taxes for reporting and processing purposes.

TaxExempt

string

Indicates that a quote or fulfillment line is exempt from taxes.

TaxExemptReason

string

The reason a tax exemption was granted and taken.

TaxExemptReasonCode

string

Code that represent the reason a tax exemption was granted and taken.

TaxExemptionCertificateNumber

string

Certification number of tax exemption granted by taxing authority for tax exempt customers.

ThirdPartyTaxRegistration

long

This is the customer registration specified by the customer in the purchase order

ThirdPartyTaxRegistrationNumber

string

Customer registration number that is specified by the customer on the purchase order.

TotalContractAmount

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

Total Contract Amount

TotalContractQuantity

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

Total Contract Quantity

TransactionBusinessCategory

string

Classification of a transaction for tax purposes as required by a tax authority.

TransactionBusinessCategoryName

string

Transactional Business Category Name

TransactionCategoryCode

string

Code used to group and process journal entries with similar characteristics, such as adjustments, accruals, or reclassifications.

TransactionLineType

string

Identifies the type of the line or action in the upstream system. Some of the example values are Buy, Replace with, Return For Credit, Upgrade and so on.

TransactionLineTypeCode

string

Defines the system behavior for the order line transaction, in terms of values required, defaulted, and displayed.

TransactionalCurrencyCode

string

Transactional Currency Code

UnitListPrice

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

Base selling price before applying discounts. It typically defaults from the item definition.

UnitQuantity

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

Requested component quantity of a child option for one unit of a parent item component in a configuration.

UnitSellingPrice

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

Price per unit that a buyer paid for an item.

UserDefinedFiscClass

string

Classification of the transaction into different categories for tax purposes.

UserDefinedFiscClassName

string

User Defined Fisc Class Name