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.
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 you add in the Order Management work area before you click 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 | Can Update |
|---|---|
| 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 |
| LatestAcceptArrivalDate | Yes |
| LatestAcceptableShipDate | Yes |
| ModifiedFlag | No |
| OpenFlag | 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 |
| RequestShipDate | Yes |
| RequestingBusinessUnit | No |
| RequestingBusinessUnitIdentifier | Yes |
| RequestingLegalUnit | Yes |
| RequestingLegalUnitIdentifier | Yes |
| RevisionSourceOrderSystem | Yes |
| SalesChannel | Yes |
| SalesChannelCode | Yes |
| Salesperson | Yes |
| SalespersonIdentifier | Yes |
| SegmentExplanationMessage | No |
| SegmentExplanationMsgName | No |
| ShipClassOfService | Yes |
| ShipClassOfServiceCode | Yes |
| ShipModeOfTransport | Yes |
| ShipModeOfTransportCode | 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 |
| ShipmentPriority | Yes |
| ShipmentPriorityCode | Yes |
| ShippingInstructions | Yes |
| ShipsetFlag | Yes |
| 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 |
| TransactionDocumentTypeCode | Yes |
| TransactionOn | Yes |
| TransactionType | No |
| TransactionTypeCode | Yes |
| TransactionalCurrencyCode | Yes |
| TransactionalCurrencyName | Yes |
| SubEntity | - |
| DocumentReferences | No |
| Lines | No |
| OrderTotals | No |
| Payments | No |
| SalesCredits | No |
Note
- CustomerPONumber displays as the Purchase Order Number attribute in the Order Management workarea.
- SoldToPartyContactPointId is the SOLD_TO_CONTACT_ID in the base table.
- SourceTransactionNumber displays as the Source Order attribute in the Order Management workarea.
- SupplierCode is the SUPPLIER_ID in the base table.
- TransactionOn displays as the Ordered Date attribute in the Order Management workarea and is ORDERED_DATE in the base table.
- TransactionTypeCode displays as the Order Type attribute in the Order Management workarea.
Order Line Attributes
Don't use the EarliestAcceptArrivalDate attribute or the EarliestAcceptArrivalDateTransient attribute in any of your extensions.
| Attribute | Can Update |
|---|---|
| AccountingRule | Yes |
| AccountingRuleCode | Yes |
| ActionType | Yes |
| ActionTypeCode | Yes |
| AgreementHeaderId | Yes |
| AssessableValue | Yes |
| AssetGroupNumber | Yes |
| AssetTrackedFlag | Yes |
| AssetTransactionDetails | No |
| BillingPlans | No |
| 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 |
| BusinessUnitIdentifier | Yes |
| BusinessUnitName | Yes |
| CanceledFlag | No |
| CanceledQuantity | No |
| CancelReason | Yes |
| CancelReasonCode | Yes |
| ChannelPrograms | No |
| Comments | Yes |
| ComponentIdPath | Yes |
| ConfigHeaderId | Yes |
| ConfigRevisionNumber | Yes |
| ConfiguratorPath | Yes |
| ContractStartDate | Yes |
| ContractEndDate | Yes |
| ContractStartDateTime | Yes |
| ContractEndDateTime | 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 |
| DemandSourceLineReference | Yes |
| DemandSourceScheduledFlag | No |
| 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 |
| DocumentReferences | No |
| DocumentSubType | Yes |
| DocumentSubTypeName | Yes |
| EarliestAcceptableShipDate | Yes |
| EndCreditMethod | Yes |
| EndCreditMethodCode | Yes |
| EndDate | Yes |
| EndReason | Yes |
| EndReasonCode | Yes |
| ExtendedAmount | Yes |
| ExternalPriceBookName | 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 |
| FulfilledQuantity | No |
| FulfillInstanceId | Yes |
| FulfillLineDetails | No |
| FulfillmentLineIdentifier | No |
| FulfillmentOrganizationCode | Yes |
| FulfillmentOrganizationIdentifier | Yes |
| FulfillmentOrganizationName | Yes |
| FulfillmentSplitReferenceId | No |
| FulfillToleranceAbove | Yes |
| FulfillToleranceBelow | Yes |
| FulfillUpdateParentRefId | No |
| HeaderId | No |
| Holds | No |
| IntegrateSubscriptionFlag | No |
| IntendedUseClassificationIdentifier | Yes |
| IntendedUseClassificationName | Yes |
| InventoryInterfacedFlag | No |
| InventoryOrganization | No |
| InventoryOrganizationIdentifier | No |
| InventoryTransactionFlag | Yes |
| InvoiceInterfacedFlag | No |
| InvoicingRule | Yes |
| InvoicingRuleCode | Yes |
| IsValidConfiguration | Yes |
| ItemSubTypeCode | No |
| LatestAcceptableArrivalDate | Yes |
| LatestAcceptableShipDate | Yes |
| LineAgreementNumber | Yes |
| LineId | No |
| LineNumber | No |
| LineType | No |
| LotSerial | Yes |
| ManualPriceAdjustments | No |
| ModifiedFlag | Yes |
| OnHoldFlag | No |
| OpenFlag | No |
| OrchestrationProcessId | Yes |
| OrchestrationProcessName | Yes |
| OrderCharges | No |
| OrderedQuantity | Yes |
| OrderedUOM | Yes |
| OrderedUOMCode | Yes |
| OrderTerms | No |
| OriginalProductDescription | Yes |
| OriginalProductIdentifier | Yes |
| OriginalProductNumber | Yes |
| OverrideScheduleDateFlag | Yes |
| PackingInstructions | Yes |
| ParentLineReference | Yes |
| PartialShipAllowedFlag | Yes |
| Payments | No |
| 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 |
| Projects | No |
| PromiseArrivalDate | Yes |
| PromiseShipDate | Yes |
| QuantityPerModel | Yes |
| ReferenceFulfillmentLineIdentifier | No |
| RemnantFlag | No |
| RequestCancelDate | Yes |
| RequestedArrivalDate | Yes |
| RequestedRatePlanId | Yes |
| RequestedRatePlanNumber | Yes |
| RequestedShipDate | Yes |
| RequestingBusinessUnitIdentifier | Yes |
| RequestingBusinessUnitName | Yes |
| RequiredFulfillmentDate | Yes |
| ReturnReason | Yes |
| ReturnReasonCode | Yes |
| RMADeliveredQuantity | No |
| RootParentLineReference | Yes |
| SalesCredits | No |
| Salesperson | Yes |
| SalespersonIdentifier | Yes |
| SalesProductType | Yes |
| SalesProductTypeCode | Yes |
| ScheduleArrivalDate | Yes |
| ScheduleShipDate | Yes |
| SecondaryOrderedQuantity | No |
| SecondaryRmaDeliveredQuantity | No |
| SecondaryShippedQuantity | No |
| SecondaryUOM | No |
| SecondaryUOMCode | No |
| SellingProfitCenter | Yes |
| SellingProfitCenterBuId | Yes |
| ServiceCancelDate | Yes |
| ServiceDuration | Yes |
| ServiceDurationPeriod | Yes |
| ServiceDurationPeriodCode | Yes |
| ShipmentPriority | Yes |
| ShipmentPriorityCode | Yes |
| ShippedQuantity | No |
| 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 |
| SubEntity | |
| SubInventoryCode | Yes |
| Subinventoryidentifier | Yes |
| SubscriptionInterfacedFlag | No |
| SubscriptionProfileIdentifier | Yes |
| SubscriptionProfileName | 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 |
| TaxInvoiceDate | Yes |
| TaxInvoiceNumber | Yes |
| ThirdPartyTaxRegistration | Yes |
| ThirdPartyTaxRegistrationNumber | Yes |
| TotalContractAmount | Yes |
| TotalContractQuantity | Yes |
| TransactionAttributes | Yes |
| TransactionBusinessCategory | Yes |
| TransactionBusinessCategoryName | Yes |
| TransactionCategoryCode | Yes |
| TransactionLineType | Yes |
| TransactionLineTypeCode | Yes |
| UnitListPrice | Yes |
| UnitQuantity | Yes |
| UnitSellingPrice | Yes |
| UnreferencedReturnFlag | No |
| UserDefinedFiscClass | Yes |
| UserDefinedFiscClassName | Yes |
Note
- FulfillmentLineIdentifier is FULFILL_LINE_ID in the base table.
- LotSerial returns an iterator that contains the lot serials for the order line.
- You can use OrchestrationProcessName only with REST API.
- OrderCharges returns an iterator that contains the pricing charges for the line.
- Payments returns an iterator that contains the payments for the line.
- SourceTransactionNumber displays as the Source Order Number attribute in the Order Management workarea.
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 | Can Update |
|---|---|
| CurrencyCode | No |
| DisplayName | No |
| EstimatedFlag | No |
| HeaderId | No |
| OrderTotalId | No |
| PrimaryFlag | No |
| TotalAmount | No |
| TotalCode | No |
| TotalGroup | No |
Order Charge Attributes
| Attribute | Can Update |
|---|---|
| ApplyTo | No |
| AverageUnitSellingPrice | No |
| BlockAllowance | No |
| BlockSize | 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 |
| PricePeriodicityCode | No |
| PriceType | No |
| PriceTypeCode | No |
| PricedQuantity | No |
| PricedQuantityUOM | No |
| PricedQuantityUomCode | No |
| PrimaryFlag | No |
| RollupFlag | No |
| SequenceNumber | No |
| SourceChargeIdentifier | No |
| TierAggregationMethodCode | No |
| TierAppliesTo | No |
| TierAppliesToCode | No |
| TierBasisTypeCode | No |
| TieredFlag | No |
| UsagePriceLockFlag | No |
| SubEntity | |
| OrderChargeComponents | No |
| OrderChargeTiers | No |
Charge Component Attributes
| Attribute | Can Update |
|---|---|
| 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 |
| SubEntity | - |
| OrderTaxDetails | No |
Note
- OrderTaxDetails returns an iterator that contains tax details for the charge component.
Tax Attributes
| Attribute | Can Update |
|---|---|
| HeaderCurrencyTaxUnitAmount | No |
| HeaderCurrencyTaxableUnitAmount | No |
| OrderChargeComponentId | No |
| OrderTaxDetailId | No |
| TaxExemptReason | No |
| TaxExemptReasonCode | No |
| TaxExemptionCertificateNumber | No |
| TaxIncludedFlag | No |
| TaxRate | No |
| TaxRateIdentifier | No |
Billing Plan Attributes
| Attribute | Can Update |
|---|---|
| BillingNumberOfPeriods | No |
| BillingPeriodEndDate | No |
| BillingPeriodNumber | No |
| BillingPeriodStartDate | No |
| BillingPlanId | No |
| BillingPlanTypeCode | No |
| BillingTrxDate | No |
| CancellationEffectiveDate | No |
| FulfillLineId | No |
| NetBillingAmountPERPeriod | No |
| OverridePeriod | No |
| OverridePeriodAmount | No |
| OverridePeriodQuantity | No |
| PeriodicityCode | No |
| PeriodicityName | No |
| SourceBillingPlanId | No |
Sales Credit Attributes
| Attribute | Can Update |
|---|---|
| FulfillLineId | No |
| HeaderId | No |
| 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 Serial Attributes
| Attribute | Can Update |
|---|---|
| FulfillLineId | No |
| ItemRevisionNumber | Yes |
| Locator | Yes |
| LocatorIdentifier | Yes |
| LotNumber | Yes |
| LotSerialId | No |
| Quantity | No |
| SecondaryQuantity | No |
| SerialNumberFrom | Yes |
| SerialNumberTo | Yes |
| SourceTransactionLotIdentifier | Yes |
Transactional Attributes
| Attribute | Can Update |
|---|---|
| CharacterValue | Yes |
| DateValue | Yes |
| FulfillLineId | No |
| HeaderId | No |
| LineId | No |
| NumberValue | Yes |
| SourceTransactionLineAttributeIdentifier | Yes |
| TimestampValue | Yes |
| TransactionAttrId | No |
| TransactionAttributeCode | Yes |
| TransactionAttributeIdentifier | Yes |
| TransactionAttributeName | Yes |
Note
- TransactionAttrId is a surrogate key for the transaction item.
Payment Attributes
| Attribute | Can Update |
|---|---|
| Amount | No |
| AuthorizationStatus | No |
| AuthorizedInSourceFlag | No |
| FulfillLineId | No |
| HeaderId | No |
| InstrumentAssignmentIdentifier | No |
| PaymentIdentifier | No |
| PaymentMethod | No |
| PaymentMethodCode | No |
| PaymentSetIdentifier | No |
| PaymentTransactionIdentifier | No |
| PaymentType | No |
| PaymentTypeCode | No |
| SourceTransactionPaymentIdentifier | No |
Document Reference Attributes
| Attribute | Can Update |
|---|---|
| DocumentAdditionalLineIdentifier | Yes |
| DocumentAdditionalLineNumber | Yes |
| DocumentAdditionalNumber | Yes |
| DocumentAdditionalSubLineIdentifier | Yes |
| DocumentAdditionalSubLineNumber | Yes |
| DocumentAdditionaldentifier | Yes |
| DocumentIdentifier | Yes |
| DocumentLineIdentifier | Yes |
| DocumentLineNumber | Yes |
| DocumentNumber | Yes |
| DocumentReferenceType | Yes |
| DocumentSubLineIdentifier | Yes |
| DocumentSubLineNumber | Yes |
| DocumentSystemReferenceIdentifier | No |
| FulfillLineIdentifier | No |
| HeaderId | No |
| LineIdentifier | No |
| OwnerTableId | Yes |
| OwnerTableName | Yes |
| TaskType | Yes |
Manual Price Adjustment Attributes
| Attribute | Can Update |
|---|---|
| AdjustmentAmount | No |
| AdjustmentElementBasis | No |
| AdjustmentElementBasisCode | No |
| AdjustmentType | No |
| AdjustmentTypeCode | No |
| ChargeDefinition | No |
| ChargeDefinitionCode | No |
| ChargeRollupFlag | No |
| Comments | No |
| EffectivityType | No |
| EffectivityTypeCode | No |
| ManualPriceAdjustmentId | No |
| NumberOfPeriods | No |
| ParentEntityCode | No |
| ParentEntityId | No |
| PeriodFrom | No |
| PeriodUntil | No |
| PricePeriodicityCode | No |
| Reason | No |
| ReasonCode | No |
| SequenceNumber | No |
| SourceManualPriceAdjustmentIdentifier | No |
| ValidationStatusCode | No |
Fulfillment Line Detail Attributes
| Attribute | Can Update |
|---|---|
| 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 |
Project Attributes
| Attribute | Can Update |
|---|---|
| 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 |
Term Attributes
| Attribute | Can Update |
|---|---|
| ModifiedFlag | No |
| OrderTermIdentifier | No |
| ParentEntityCode | No |
| ParentEntityIdentifier | No |
| ReferenceOrderTermIdentifier | No |
| SourceOrderTermIdentifier | No |
| TermAdjustmentPercent | No |
| TermApplicationMethod | No |
| TermApplicationMethodCode | No |
| TermDuration | No |
| TermEndDate | No |
| TermPeriod | No |
| TermPeriodCode | No |
| TermStartDate | No |
| TermSubtypeCode | No |
| TermTypeCode | No |
Charge Tier Attributes
| Attribute | Can Update |
|---|---|
| AdjustmentAmount | No |
| AdjustmentBasisIdentifier | No |
| AdjustmentType | No |
| AdjustmentTypeCode | No |
| ApplicationMethod | No |
| ApplicationMethodCode | No |
| BlockSize | No |
| DeltaType | No |
| ModifiedFlag | No |
| OrderChargeIdentifier | No |
| OrderChargeTierIdentifier | No |
| PartialBlockAction | No |
| ReferenceOrderChargeTierIdentifier | No |
| SourceOrderChargeTierIdentifier | No |
| TierFrom | No |
| TierSequenceNumber | No |
| TierTo | No |
Asset Attributes
| Attribute | Can Update |
|---|---|
| AssetIdentifier | Yes |
| AssetTransactionDetailId | No |
| AssetUomCode | Yes |
| CustomerAssetEndDate | Yes |
| FulfillLineIdentifier | No |
| ModifiedFlag | No |
| Quantity | No |
| ReferenceAssetTransactionDtlId | No |
| SourceAssetTransactionDetailId | No |
| StatusIdentifier | Yes |
| TransactionActionCode | Yes |
Channel Program Attributes
| Attribute | Can Update |
|---|---|
| ProgramDetails | No |
| ProgramId | Yes |
| ProgramLine | No |
| ProgramLineId | Yes |
| ProgramName | No |
| ProgramTypeName | No |
| ReferenceIncentiveIdentifier | No |
| SourceTransactionIncentiveIdentifier | Yes |
| StartDate | No |
| Status | Yes |
| StatusCode | Yes |
Hold Attributes
| Attribute | Can Update |
|---|---|
| ActiveFlag | No |
| ApplyDate | No |
| ApplySystem | No |
| ApplyUserId | No |
| CreatedBy | No |
| CreationDate | No |
| DeletedFlag | No |
| DooHeaderId | No |
| DooLineId | No |
| FulfillLineId | No |
| HoldCode | No |
| HoldCodeId | No |
| HoldComments | Yes |
| HoldInstanceId | No |
| HoldReleaseComments | Yes |
| HoldReleaseReasonCode | Yes |
| HoldRunningTaskFlag | No |
| LastUpdateDate | No |
| LastUpdatedBy | No |
| ObjectVersionNumber | Yes |
| PendingFlag | No |
| ReleaseDate | No |
| ReleaseUserId | No |
| SourceRequestId | No |
| TransactionEntityId1 | No |
| TransactionEntityId2 | No |
| TransactionEntityName1 | No |
| TransactionEntityName2 | No |