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. Displays as the Purchase Order Number attribute in the Order Management work area. |
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. Is the SOLD_TO_CONTACT_ID in the base table. |
SourceTransactionIdentifier | No |
SourceTransactionNumber | No. Displays as the Source Order attribute in the Order Management work area. |
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. Is the SUPPLIER_ID in the base table. |
SupplierName | Yes |
SupplierNumber | Yes |
SupplierSiteIdentifier | Yes |
TradeComplianceResult | Yes |
TradeComplianceResultCode | No |
TransactionDocumentTypeCode | Yes |
TransactionOn | Yes. Displays as the Ordered Date attribute in the Order Management work area and is ORDERED_DATE in the base table. |
TransactionType | No |
TransactionTypeCode | Yes. Displays as the Order Type attribute in the Order Management work area. |
TransactionalCurrencyCode | Yes |
TransactionalCurrencyName | Yes |
SubEntity | - |
DocumentReferences | No |
Lines | No |
OrderTotals | No |
Payments | No |
SalesCredits | No |
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. Is FULFILL_LINE_ID in the base table. |
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 |
LotSerial | Yes. Returns an iterator that contains the lot serials for the order line. |
ManualPriceAdjustments | No |
ModifiedFlag | Yes |
OnHoldFlag | No |
OpenFlag | No |
OrchestrationProcessId | Yes |
OrchestrationProcessName | Yes. You can use OrchestrationProcessName only with REST API. |
OrderCharges | No. Returns an iterator that contains the pricing charges for the line. |
OrderedQuantity | Yes |
OrderedUOM | Yes |
OrderedUOMCode | Yes |
OrderTerms | No |
OriginalProductDescription | Yes |
OriginalProductIdentifier | Yes |
OriginalProductNumber | Yes |
OverrideScheduleDateFlag | Yes |
PackingInstructions | Yes |
ParentLineReference | Yes |
PartialShipAllowedFlag | Yes |
Payments | No. Returns an iterator that contains the payments for the line. |
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. Displays as the Source Order Number attribute in the Order Management work area. |
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. References the Line Type attribute in the Order Management work area. |
TransactionLineTypeCode | Yes |
UnitListPrice | Yes |
UnitQuantity | Yes |
UnitSellingPrice | Yes |
UnreferencedReturnFlag | No |
UserDefinedFiscClass | Yes |
UserDefinedFiscClassName | Yes |
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. 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. Is a surrogate key for the transaction item. |
TransactionAttributeCode | Yes |
TransactionAttributeIdentifier | Yes |
TransactionAttributeName | Yes |
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 |