Attributes That You Can Use With Order Management Extensions

Get details about the attributes that you can use with your order management extensions.

Overview

  • Use the Line entity to get the value of the ItemSubTypeCode attribute.

  • If you set a default value for the ShipSetName attribute, then you must also set the PartialShipAllowedFlag attribute to N.

  • If you set the PartialShipAllowedFlag to Y, then you must make sure the line isn't part of a shipment set or kit.
The text Identifier, Id, or ID typically identifies an identifier attribute.
  • An extension can read from or write to the attributes that identify data in a sales order, such as BillToCustomerIdentifier.

  • Order Management converts each value to an identifier when it saves your code.

  • Some identifier values use the Oracle Mobile Supply Chain identifier.

View Objects

  • Your extension code can use the attribute name of the public view object.

  • You can use a public view object, but it might be necessary for you to also use the identifier attributes.

  • You can't use the public view object for an order line that the user adds in the Order Management work area before the user clicks Submit because Order Management hasn't yet saved it to the database.

The rest of this topic lists the attributes that you can use with your extension. To get them in an Excel file, go to Technical Reference for Order Management (Doc ID 2051639.1), then download the Attributes You Can Use With Extensions attachment.

Order Header Attributes

Attribute

Updatable

AgreementHeaderId

Yes

AgreementNumber

Yes

AllowCurrencyOverrideFlag

No

AppliedCurrencyCode

No

AppliedCurrencyName

No

BillToAccountContactIdentifier

Yes

BillToAccountContactName

Yes

BillToAccountContactNumber

Yes

BillToAccountDescription

No

BillToAccountPersonFirstName

No

BillToAccountPersonLastName

No

BillToAccountPersonMiddleName

No

BillToAccountPersonNameSuffix

No

BillToAccountPersonTitle

No

BillToAddress1

No

BillToAddress2

No

BillToAddress3

No

BillToAddress4

No

BillToCity

No

BillToContactFirstName

No

BillToContactLastName

No

BillToContactMiddleName

No

BillToContactNameSuffix

No

BillToContactTitle

No

BillToCountry

No

BillToCounty

No

BillToCustomerIdentifier

Yes

BillToCustomerName

Yes

BillToCustomerNumber

Yes

BillToCustomerSiteIdentifier

Yes

BillToPartyType

Yes

BillToPostalCode

No

BillToProvince

No

BillToState

No

BusinessUnitIdentifier

Yes

BusinessUnitName

Yes

BuyingPartyContactFirstName

No

BuyingPartyContactId

Yes

BuyingPartyContactLastName

No

BuyingPartyContactMiddleName

No

BuyingPartyContactName

Yes

BuyingPartyContactNameSuffix

No

BuyingPartyContactNumber

Yes

BuyingPartyContactTitle

No

BuyingPartyIdentifier

Yes

BuyingPartyName

Yes

BuyingPartyNumber

Yes

BuyingPartyPersonFirstName

No

BuyingPartyPersonLastName

No

BuyingPartyPersonMiddleName

No

BuyingPartyPersonNameSuffix

No

BuyingPartyPersonTitle

No

BuyingPartyType

Yes

CancelReason

Yes

CancelReasonCode

Yes

CarrierId

Yes

CarrierName

Yes

ChangeVersionNumber

No

Comments

Yes

CurrencyConversionDate

Yes

CurrencyConversionRate

Yes

CurrencyConversionTypeCode

Yes

CustomerPONumber

Yes

DemandClass

Yes

DemandClassCode

Yes

EarliestAcceptableShipDate

Yes

FOBPoint

Yes

FOBPointCode

Yes

FreezePriceFlag

Yes

FreezeShippingChargeFlag

Yes

FreezeTaxFlag

Yes

FreightTerms

Yes

FreightTermsCode

Yes

FulfillmentOrganizationCode

Yes

FulfillmentOrganizationIdentifier

Yes

FulfillmentOrganizationName

Yes

HeaderId

No

LatestAcceptableShipDate

Yes

LatestAcceptArrivalDate

Yes

OrderNumber

No

OrigSysDocumentRef

Yes

PackingInstructions

Yes

PartialShipAllowedFlag

Yes

PaymentTerm

Yes

PaymentTermCode

Yes

PreCreditCheckedFlag

Yes

PreferredBillToContactPointIdentifier

Yes

PreferredShipToContactPointIdentifier

Yes

PreferredSoldToContactPointIdentifier

Yes

PricedOn

No

PricingSegmentCode

No

PricingSegmentExplanation

No

PricingStrategy

No

PricingStrategyExplanation

No

PricingStrategyIdentifier

No

ReferenceHeaderId

No

RequestArrivalDate

Yes

RequestCancelDate

Yes

RequestingBusinessUnit

No

RequestingBusinessUnitIdentifier

Yes

RequestingLegalUnit

Yes

RequestingLegalUnitIdentifier

Yes

RequestShipDate

Yes

RevisionSourceOrderSystem

Yes

SalesChannel

Yes

SalesChannelCode

Yes

Salesperson

Yes

SalespersonIdentifier

Yes

SegmentExplanationMessage

No

SegmentExplanationMsgName

No

ShipClassOfService

Yes

ShipClassOfServiceCode

Yes

ShipmentPriority

Yes

ShipmentPriorityCode

Yes

ShipModeOfTransport

Yes

ShipModeOfTransportCode

Yes

ShippingInstructions

Yes

ShipsetFlag

Yes

ShipToAddress1

No

ShipToAddress2

No

ShipToAddress3

No

ShipToAddress4

No

ShipToCity

No

ShipToContactFirstName

No

ShipToContactLastName

No

ShipToContactMiddleName

No

ShipToContactNameSuffix

No

ShipToContactTitle

No

ShipToCountry

No

ShipToCounty

No

ShipToPartyContactIdentifier

Yes

ShipToPartyContactName

Yes

ShipToPartyContactNumber

No

ShipToPartyIdentifier

Yes

ShipToPartyName

Yes

ShipToPartyNumber

Yes

ShipToPartyPersonFirstName

No

ShipToPartyPersonLastName

No

ShipToPartyPersonMiddleName

No

ShipToPartyPersonNameSuffix

No

ShipToPartyPersonTitle

No

ShipToPartySiteIdentifier

Yes

ShipToPartyType

Yes

ShipToPostalCode

No

ShipToProvince

No

ShipToState

No

SoldToPartyContactPointId

Yes

SourceTransactionIdentifier

No

SourceTransactionNumber

No

SourceTransactionRevisionNumber

No

SourceTransactionSystem

No

StatusCode

No

StrategyExplanationMessage

No

StrategyExplanationMsgName

No

SubmittedBy

Yes

SubmittedDate

Yes

SubmittedFlag

No

SubstituteAllowedFlag

Yes

SupplierAddressCity

No

SupplierAddressCountry

No

SupplierAddressCounty

No

SupplierAddressLine1

No

SupplierAddressLine2

No

SupplierAddressLine3

No

SupplierAddressLine4

No

SupplierAddressPostalCode

No

SupplierAddressProvince

No

SupplierAddressState

No

SupplierCode

Yes

SupplierName

Yes

SupplierNumber

Yes

SupplierSiteIdentifier

Yes

TradeComplianceResult

Yes

TradeComplianceResultCode

No

TransactionalCurrencyCode

Yes

TransactionalCurrencyName

Yes

TransactionDocumentTypeCode

Yes

TransactionOn

Yes

TransactionType

No

TransactionTypeCode

Yes

Lines

No

SalesCredits

No

OrderTotals

No

Payments

No

DocumentReferences

No

Order Line Attributes

Don't use the EarliestAcceptArrivalDate attribute or the EarliestAcceptArrivalDateTransient attribute in any of your extensions.

Attribute

Updatable

AccountingRule

Yes

AccountingRuleCode

Yes

ActionType

Yes

ActionTypeCode

Yes

AssessableValue

Yes

AssetGroupNumber

Yes

AssetTrackedFlag

Yes

BillingTransactionTypeIdentifier

Yes

BillToAccountContactIdentifier

Yes

BillToAccountContactName

Yes

BillToAccountContactNumber

Yes

BillToAccountPersonFirstName

No

BillToAccountPersonLastName

No

BillToAccountPersonMiddleName

No

BillToAccountPersonNameSuffix

No

BillToAccountPersonTitle

No

BillToAccountSiteUseIdentifier

Yes

BillToAddress1

No

BillToAddress2

No

BillToAddress3

No

BillToAddress4

No

BillToCity

No

BillToContactFirstName

No

BillToContactLastName

No

BillToContactMiddleName

No

BillToContactNameSuffix

No

BillToContactTitle

No

BillToCounty

No

BillToCustomerIdentifier

Yes

BillToCustomerName

Yes

BillToCustomerNumber

Yes

BillToPartyType

Yes

BillToPostalCode

No

BillToProvince

No

BillToState

No

BillingTransactionTypeIdentifier

Yes

BusinessUnitIdentifier

Yes

BusinessUnitName

Yes

CancelReason

Yes

CancelReasonCode

Yes

Comments

Yes

ComponentIdPath

Yes

ConfigHeaderId

Yes

ConfigRevisionNumber

Yes

ConfiguratorPath

Yes

ContractEndDate

Yes

ContractStartDate

Yes

ContractEndDate1

Yes

ContractStartDate1

Yes

CreditCheckAuthorizationCode

Yes

CreditCheckAuthorizationExpiryDate

Yes

CustomerPOLineNumber

Yes

CustomerPONumber

Yes

CustomerPOScheduleNumber

Yes

CustomerProductDescription

Yes

CustomerProductIdentifier

Yes

CustomerProductNumber

Yes

DefaultTaxationCountry

Yes

DefaultTaxationCountryShortName

Yes

DemandClass

Yes

DemandClassCode

Yes

DestinationShippingAddressCity

No

DestinationShippingAddressCountry

No

DestinationShippingAddressCounty

No

DestinationShippingAddressLine1

No

DestinationShippingAddressLine2

No

DestinationShippingAddressLine3

No

DestinationShippingAddressLine4

No

DestinationShippingAddressPostalCode

No

DestinationShippingAddressProvince

No

DestinationShippingAddressState

No

DestinationShippingLocationIdentifier

Yes

DestinationShippingOrganizationCode

Yes

DestinationShippingOrganizationIdentifier

Yes

DestinationShippingOrganizationName

Yes

DisplayLineNumber

No

DocumentSubType

Yes

DocumentSubTypeName

Yes

EarliestAcceptableShipDate

Yes

ExtendedAmount

Yes

FinalDischargeLocationAddressCity

No

FinalDischargeLocationAddressCountry

No

FinalDischargeLocationAddressCounty

No

FinalDischargeLocationAddressLine1

No

FinalDischargeLocationAddressLine2

No

FinalDischargeLocationAddressLine3

No

FinalDischargeLocationAddressLine4

No

FinalDischargeLocationAddressPostalCode

No

FinalDischargeLocationAddressProvince

No

FinalDischargeLocationAddressState

No

FinalDischargeLocationIdentifier

Yes

FirstPartyTaxRegistration

Yes

FirstPartyTaxRegistrationNumber

Yes

FOBPoint

Yes

FOBPointCode

Yes

FreightTerms

Yes

FreightTermsCode

Yes

FulfillInstanceId

Yes

FulfillmentLineIdentifier

No

FulfillmentOrganizationCode

Yes

FulfillmentOrganizationIdentifier

Yes

FulfillmentOrganizationName

Yes

HeaderId

No

IntendedUseClassificationIdentifier

Yes

IntendedUseClassificationName

Yes

InventoryOrganization

No

InventoryOrganizationIdentifier

No

InvoicingRule

Yes

InvoicingRuleCode

Yes

IsValidConfiguration

Yes

ItemSubTypeCode

No

LatestAcceptableArrivalDate

Yes

LatestAcceptableShipDate

Yes

LineAgreementNumber

Yes

LineId

No

LineNumber

No

LineType

No

ModifiedFlag

Yes

OrderedQuantity

Yes

OrderedUOM

Yes

OrderedUOMCode

Yes

OriginalProductDescription

Yes

OriginalProductIdentifier

Yes

OriginalProductNumber

Yes

PackingInstructions

Yes

ParentLineReference

Yes

PartialShipAllowedFlag

Yes

PaymentTerm

Yes

PaymentTermCode

Yes

PreferredBillToContactPointIdentifier

Yes

PreferredShipToContactPointIdentifier

Yes

PriceUsingSecondaryUOMFlag No

ProductCategory

Yes

ProductCategoryName

Yes

ProductDescription

Yes

ProductFiscalCategoryIdentifier

Yes

ProductFiscalCategoryName

Yes

ProductIdentifier

Yes

ProductNumber

Yes

ProductType

Yes

ProductTypeName

Yes

ProjectRecordIndicator

Yes

PromiseArrivalDate

Yes

PromiseShipDate

Yes

QuantityPerModel

Yes

ReferenceFulfillmentLineIdentifier

No

RequestCancelDate

Yes

RequestedArrivalDate

Yes

RequestedShipDate

Yes

RequestingBusinessUnitIdentifier

Yes

RequestingBusinessUnitName

Yes

RequiredFulfillmentDate

Yes

ReturnReason

Yes

ReturnReasonCode

Yes

RootParentLineReference

Yes

Salesperson

Yes

SalespersonIdentifier

Yes

SalesProductType

Yes

SalesProductTypeCode

Yes

ScheduleArrivalDate

Yes

ScheduleShipDate

Yes

SecondaryOrderedQuantity No
SecondaryRmaDeliveredQuantity No
SecondaryShippedQuantity No
SecondaryUOM No
SecondaryUOMCode No

ServiceCancelDate

Yes

ServiceDuration

Yes

ServiceDurationPeriod

Yes

ServiceDurationPeriodCode

Yes

ShipmentPriority

Yes

ShipmentPriorityCode

Yes

ShippingCarrier

Yes

ShippingCarrierCode

Yes

ShippingInstructions

Yes

ShippingMode

Yes

ShippingModeCode

Yes

ShippingServiceLevel

Yes

ShippingServiceLevelCode

Yes

ShipSetName

Yes

ShipToAddress1

No

ShipToAddress2

No

ShipToAddress3

No

ShipToAddress4

No

ShipToCity

No

ShipToContactFirstName

No

ShipToContactId

Yes

ShipToContactLastName

No

ShipToContactMiddleName

No

ShipToContactNameSuffix

No

ShipToContactTitle

No

ShipToCounty

No

ShipToPartyContactIdentifier

Yes

ShipToPartyContactName

Yes

ShipToPartyContactNumber

Yes

ShipToPartyIdentifier

Yes

ShipToPartyName

Yes

ShipToPartyNumber

Yes

ShipToPartyPersonFirstName

No

ShipToPartyPersonLastName

No

ShipToPartyPersonMiddleName

No

ShipToPartyPersonNameSuffix

No

ShipToPartyPersonTitle

No

ShipToPartySiteIdentifier

Yes

ShipToPartyType

Yes

ShipToPostalCode

No

ShipToProvince

No

ShipToRequestRegion

Yes

ShipToState

Yes

SourceTransactionIdentifier

No

SourceTransactionLineIdentifier

No

SourceTransactionLineNumber

No

SourceTransactionNumber

No

SourceTransactionRevisionNumber

No

SourceTransactionScheduleIdentifier

No

SourceTransactionScheduleNumber

No

SourceTransactionSystem

No

StatusCode

No

SubInventoryCode

Yes

SubInventoryIdentifier

Yes

SubstitutionAllowedFlag

Yes

SubstitutionReason

Yes

SubstitutionReasonCode

Yes

SupplierAddressCity

No

SupplierAddressCountry

No

SupplierAddressCounty

No

SupplierAddressLine1

No

SupplierAddressLine2

No

SupplierAddressLine3

No

SupplierAddressLine4

No

SupplierAddressPostalCode

No

SupplierAddressProvince

No

SupplierAddressState

No

SupplierCode

Yes

SupplierName

Yes

SupplierNumber

Yes

SupplierSiteIdentifier

Yes

SupplyStatusCode

Yes

TaxClassification

Yes

TaxClassificationCode

Yes

TaxExemptFlag

Yes

TaxExemptionCertificateNumber

Yes

TaxExemptReason

Yes

TaxExemptReasonCode

Yes

TaxInvoiceNumber

Yes

ThirdPartyTaxRegistration

Yes

ThirdPartyTaxRegistrationNumber

Yes

TotalContractAmount

Yes

TotalContractQuantity

Yes

TransactionBusinessCategory

Yes

TransactionBusinessCategoryName

Yes

TransactionCategoryCode

Yes

TransactionLineType

Yes

TransactionLineTypeCode

Yes

UnitListPrice

Yes

UnitQuantity

Yes

UnitSellingPrice

Yes

UnreferencedReturnFlag

No

UserDefinedFiscClass

Yes

UserDefinedFiscClassName

Yes

TransactionAttributes

No

SalesCredits

No

OrderCharges

No

ManualPriceAdjustments

No

Payments

No

DocumentReferences

No

BillingPlans

No

FulfillLineDetails

No

LotSerial

No

Projects

No

Fulfillment Line Attributes

Attribute

Updatable

ActualDeliveryDate

No

AvailabilityShipDate

No

BillingTransactionAmount

No

BillingTransactionDate

No

BillingTransactionNumber

No

BillOfLadingNumber

No

CustomerTrxLineIdentifier

No

DeliveryName

No

ExceptionFlag

No

FulfillLineDetailId

No

FulfillLineId

No

Quantity

No

RMAReceiptDate

No

RMAReceiptLineNumber

No

RMAReceiptNumber

No

RMAReceiptTransactionIdentifier

No

SecondaryQuantity No

Status

No

StatusAsOfDate

No

TaskType

No

TrackingNumber

No

TradeComplianceCode

No

TradeComplianceExplanation

No

TradeComplianceName

No

TradeComplianceResultCode

No

TradeComplianceResultName

No

TradeComplianceTypeCode

No

TradeComplianceTypeName

No

WaybillNumber

No

Order Total Attributes

Attribute

Updatable

CurrencyCode

No

DisplayName

No

EstimatedFlag

No

OrderTotalId

No

PrimaryFlag

No

TotalAmount

No

TotalCode

No

TotalGroup

No

Order Charge Attributes

Attribute

Updatable

ApplyTo

No

AverageUnitSellingPrice

No

CanAdjustFlag

No

ChargeCurrencyCode

No

ChargeCurrencyName

No

ChargeDefinition

No

ChargeDefinitionCode

No

ChargeSubtype

No

ChargeSubtypeCode

No

ChargeType

No

ChargeTypeCode

No

GSAUnitPrice

No

OrderChargeId

No

ParentEntityId

No

PricedQuantity

No

PricedQuantityUOM

No

PricedQuantityUomCode

No

PricePeriodicityCode

No

PriceType

No

PriceTypeCode

No

PrimaryFlag

No

RollupFlag

No

SequenceNumber

No

SourceChargeIdentifier

No

OrderChargeComponents

No

Charge Component Attributes

Attribute

Updatable

ChargeCurrencyCode

No

ChargeCurrencyDurationExtendedAmount

No

ChargeCurrencyExtendedAmount

No

ChargeCurrencyName

No

ChargeCurrencyUnitPrice

No

Explanation

No

HeaderCurrencyCode

No

HeaderCurrencyDurationExtendedAmount

No

HeaderCurrencyExtendedAmount

No

HeaderCurrencyName

No

HeaderCurrencyUnitPrice

No

OrderChargeComponentId

No

OrderChargeId

No

PercentOfComparisonElement

No

PriceElement

No

PriceElementCode

No

PriceElementUsage

No

PriceElementUsageCode

No

RollupFlag

No

SequenceNumber

No

SourceChargeComponentId

No

SourceChargeId

No

SourceMpaId

No

SourceParentChargeComponentId

No

TaxIncludedFlag

No

OrderTaxDetails

No

Tax Attributes

Attribute

Updatable

HeaderCurrencyTaxableUnitAmount

No

HeaderCurrencyTaxUnitAmount

No

OrderChargeComponentId

No

OrderTaxDetailId

No

TaxExemptionCertificateNumber

No

TaxExemptReason

No

TaxExemptReasonCode

No

TaxIncludedFlag

No

TaxRate

No

TaxRateIdentifier

No

Billing Plan Attributes

Attribute

Updatable

BillingNumberOfPeriods

No

BillingPeriodEndDate

No

BillingPeriodNumber

No

BillingPeriodStartDate

No

BillingPlanId

No

BillingPlanTypeCode

No

BillingTrxDate

No

CancellationEffectiveDate

No

NetBillingAmountPERPeriod

No

OverridePeriod

No

OverridePeriodAmount

No

OverridePeriodQuantity

No

PeriodicityCode

No

PeriodicityName

No

SourceBillingPlanId

No

Sales Credit Attributes

Attribute

Updatable

Percent

Yes

SalesCreditIdentifier

No

SalesCreditType

Yes

SalesCreditTypeCode

Yes

Salesperson

Yes

SalespersonIdentifier

Yes

SourceTransactionSalesCreditIdentifier

Yes

Payment Attributes

Attribute

Updatable

AuthorizationStatus

No

InstrumentAssignmentIdentifier

No

PaymentMethod

No

PaymentMethodCode

No

PaymentSetIdentifier

No

PaymentTransactionIdentifier

No

PaymentType

No

PaymentTypeCode

No

SourceTransactionPaymentIdentifier

No

Manual Price Adjustment Attributes

Attribute

Updatable

AdjustmentAmount

No

AdjustmentElementBasis

No

AdjustmentElementBasisCode

No

AdjustmentType

No

AdjustmentTypeCode

No

ChargeDefinition

No

ChargeDefinitionCode

No

ChargeRollupFlag

No

Comments

No

ManualPriceAdjustmentId

No

ParentEntityCode

No

ParentEntityId

No

PricePeriodicityCode

No

Reason

No

ReasonCode

No

SequenceNumber

No

SourceManualPriceAdjustmentIdentifier

No

ValidationStatusCode

No

Project Attributes

Attribute

Updatable

ContractId

Yes

ContractNumber

Yes

DooOrderPrjId

No

ExpenditureItemDate

Yes

ExpenditureOrganization

Yes

ExpenditureType

Yes

ExpenditureTypeId

Yes

FundingSource

Yes

OrganizationId

Yes

ParentEntityCode

No

ParentEntityId

No

ProjectId

Yes

ProjectNumber

Yes

ReferenceProjectId

No

ReservedAttribute1

Yes

TaskId

Yes

TaskNumber

Yes

Lot Attributes and Serial Attributes

Attribute

Updatable

ItemRevisionNumber

No

LocatorIdentifier

No

LotNumber

No

LotSerialId

No

SecondaryQuantity No

SerialNumberFrom

No

SerialNumberTo

No

SourceTransactionLotIdentifier

No

Transactional Attributes

Attribute

Updatable

CharacterValue

Yes

DateValue

Yes

NumberValue

Yes

SourceTransactionLineAttributeIdentifier

Yes

TimestampValue

Yes

TransactionAttributeCode

Yes

TransactionAttributeIdentifier

Yes

TransactionAttributeName

Yes

TransactionAttrId

No

Document Reference Attributes

Attribute

Updatable

DocumentAdditionaldentifier

Yes

DocumentAdditionalLineIdentifier

Yes

DocumentAdditionalLineNumber

Yes

DocumentAdditionalNumber

Yes

DocumentAdditionalSubLineIdentifier

Yes

DocumentAdditionalSubLineNumber

Yes

DocumentIdentifier

Yes

DocumentLineIdentifier

Yes

DocumentLineNumber

Yes

DocumentNumber

Yes

DocumentReferenceType

Yes

DocumentSubLineIdentifier

Yes

DocumentSubLineNumber

Yes

DocumentSystemReferenceIdentifier

No

OwnerTableId

Yes

OwnerTableName

Yes

TaskType

Yes