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 |