Entities and Attributes That You Can Use When You Integrate Order Management with Other Oracle Applications

Use a variety of entities and attributes when you integrate Order Management with some other Oracle application.

Summary

Here's a summary of the entities, sources, and services you can use in a service mapping or integration algorithm.

Object	Value
Common	Header FulfillLine FilfillLineDetails
ShipmentSource	ShipmentRequestHeader ShipmentRequestLine
InvoiceSource	ARChargeInterfaceLine ARInterfaceLine Charge ChargeComponent TransactionInterfaceGdf TransactionInterfaceHeaderDff TransactionInterfaceLinkToDff TransactionInterfaceLinkToDff TransactionLineInterfaceGdf
PurchaseRequestSource	PurchaseRequestHeader PurchaseRequestLine PurchaseRequestConfig
ReceiptSource	ReceiptAdvice ReceiptAdviceLine ReceiptAdviceLineLot ReceiptAdviceLineLotWithSerials

Entities You Can Use with Other Oracle Applications

Entity	Description
Header	Sales order header.
FulfillLine	Fulfillment line on the sales order.
FulfillLineDetails	Fulfillment line details on the sales order.
ARInterfaceLine	Account receivables on the interface line.
TransactionInterfaceGdf,	Flexfield that stores receivable transactions that are available globally.
TransactionInterfaceLinkToDff,	Flexfield that stores link-to details for receivables transactions.
TransactionLineDff,	Flexfield that stores receivable invoice lines.
TransactionLineInterfaceGdf,	Flexfield that stores receivable transaction lines that are available globally.
PurchaseRequestHeader	Purchase request header.
PurchaseRequestLine	Purchase request lines.
PurchaseRequestConfig	Details of a configured item for a purchase request line.
TransactionSalesCreditDff	Flexfield that stores details about sales credits.
ShipmentRequestHeader	Shipment header.
ShipmentRequestLine	Shipment line.
ReceiptAdvice	Receipt advice.
ReceiptAdviceLine	Receipt advice line.
ReceiptAdviceLineLot	Lot number details for the receipt advice line.
ReceiptAdviceLineLotWithSerials	Serial number and lot number details for the receipt advice line.
TransactionInterfaceHeaderDff	Descriptive flexfield that stores details about the receivables transaction header.
ARChargeInterfaceLine	Account receivables on the interface line. You use this object primarily for charges, discounts, or freight.
Charge	Charges on the fulfillment line.
ChargeComponent	Charge components on the fulfillment line.

You can map the attributes that the ARInterfaceLine entity contains.

Attributes You Can Use With Drop Ship

Purchase Request Header

You can use these attributes in the PurchaseRequestHeader element.

Attribute Name	Type
ApproverEmail	string
ApproverId	long
AssessableAmount	decimal
Attribute1	string
Attribute10	string
Attribute11	string
Attribute12	string
Attribute13	string
Attribute14	string
Attribute15	string
Attribute16	string
Attribute17	string
Attribute18	string
Attribute19	string
Attribute2	string
Attribute20	string
Attribute3	string
Attribute4	string
Attribute5	string
Attribute6	string
Attribute7	string
Attribute8	string
Attribute9	string
AttributeCategory	string
AttributeDate1	date
AttributeDate10	date
AttributeDate2	date
AttributeDate3	date
AttributeDate4	date
AttributeDate5	date
AttributeDate6	date
AttributeDate7	date
AttributeDate8	date
AttributeDate9	date
AttributeNumber1	decimal
AttributeNumber10	decimal
AttributeNumber2	decimal
AttributeNumber3	decimal
AttributeNumber4	decimal
AttributeNumber5	decimal
AttributeNumber6	decimal
AttributeNumber7	decimal
AttributeNumber8	decimal
AttributeNumber9	decimal
AttributeTimestamp1	dateTime
AttributeTimestamp10	dateTime
AttributeTimestamp2	dateTime
AttributeTimestamp3	dateTime
AttributeTimestamp4	dateTime
AttributeTimestamp5	dateTime
AttributeTimestamp6	dateTime
AttributeTimestamp7	dateTime
AttributeTimestamp8	dateTime
AttributeTimestamp9	dateTime
Description	string
DocumentStatusCode	string
EmergencyPONumber	string
HeaderId	Long
InterfaceSourceLineId	long
Justification	string
RequisitionNumber	string
SoldToLegalEntityId	long
SoldToLegalEntityName	string
TaxationCountryCode	string
TaxationTerritory	string

You can't use these attributes in the PurchaseRequestHeader element.

Attribute Name	Type
AttachmentCategory	string
AttachmentEntityName	string
AttachmentPrimaryKey1	string
AttachmentPrimaryKey2	string
AttachmentPrimaryKey3	string
AttachmentPrimaryKey4	string
AttachmentPrimaryKey5	string
DocumentFiscalClassification	string
DocumentFiscalClassificationCode	string
ExternallyManagedFlag	boolean
InterfaceHeaderKey	string
PreparerEmail	string
PreparerId	long
RequisitioningBUId	long
RequisitioningBUName	string

Purchase Request Line

You can use these attributes in the PurchaseRequestLine element.

Attribute Name	Type
Amount	decimal
Attribute1	string
Attribute10	string
Attribute11	string
Attribute12	string
Attribute13	string
Attribute14	string
Attribute15	string
Attribute16	string
Attribute17	string
Attribute18	string
Attribute19	string
Attribute2	string
Attribute20	string
Attribute3	string
Attribute4	string
Attribute5	string
Attribute6	string
Attribute7	string
Attribute8	string
Attribute9	string
AttributeCategory	string
AttributeDate1	date
AttributeDate10	date
AttributeDate2	date
AttributeDate3	date
AttributeDate4	date
AttributeDate5	date
AttributeDate6	date
AttributeDate7	date
AttributeDate8	date
AttributeDate9	date
AttributeNumber1	decimal
AttributeNumber10	decimal
AttributeNumber2	decimal
AttributeNumber3	decimal
AttributeNumber4	decimal
AttributeNumber5	decimal
AttributeNumber6	decimal
AttributeNumber7	decimal
AttributeNumber8	decimal
AttributeNumber9	decimal
AttributeTimestamp1	dateTime
AttributeTimestamp10	dateTime
AttributeTimestamp2	dateTime
AttributeTimestamp3	dateTime
AttributeTimestamp4	dateTime
AttributeTimestamp5	dateTime
AttributeTimestamp6	dateTime
AttributeTimestamp7	dateTime
AttributeTimestamp8	dateTime
AttributeTimestamp9	dateTime
AutosourceFlag	boolean
BaseModelNumber	string
BaseModelPrice	decimal
BuyerEmail	string
BuyerId	long
BuyerName	string
CategoryId	long
CategoryName	string
ChangeActionReason	string
CurrencyCode	string
CustomerItemDescription	string
DaysEarlyReceiptAllowed	decimal
DeliverToCustomerContactEmail	string
DeliverToCustomerContactId	long
DeliverToCustomerContactName	string
DeliverToCustomerContactNumber	string
DeliverToCustomerId	long
DeliverToCustomerLocationCLLICode	string
DeliverToCustomerLocationOriginalSystemReference	string
DeliverToCustomerName	string
DeliverToCustomerNumber	string
DeliverToLocationCode	string
DeliverToLocationId	long
DestinationSubinventory	string
FulfillLineId	Long
GroupCode	string
HazardClass	string
HazardClassId	long
ItemDescription	string
ItemRevision	string
LineType	string
LineTypeId	long
NegotiatedByPreparerFlag	boolean
NegotiationRequiredFlag	boolean
NewSupplierFlag	boolean
NoteToBuyer	string
NoteToReceiver	string
NoteToSupplier	string
Price	decimal
ProcurementBUId	long
ProcurementBUName	string
Rate	decimal
RateDate	date
RateType	string
RequesterEmail	string
RequesterId	long
SecondaryQuantity	decimal
SecondaryUOM	string
SecondaryUOMCode	string
ShipToCustomerContactEmail	string
ShipToCustomerLocationOriginalSystemReference	string
ShipToLocationCode	string
ShipToLocationId	long
SourceAgreementId	long
SourceAgreementLineId	long
SourceAgreementLineNumber	decimal
SourceAgreementNumber	string
SupplierContactEmail	string
SupplierContactFax	string
SupplierContactId	long
SupplierContactName	string
SupplierContactPhone	string
SupplierItemNumber	string
UNNumber	string
UNNumberId	long
UrgentRequisitionLineFlag	boolean

You can't use these attributes in the PurchaseRequestLine element.

Attribute Name	Type
AssessableAmount	decimal
AttachmentCategoryItem	string
AttachmentCategoryShip	string
AttachmentEntityName	string
AttachmentPrimaryKey1	string
AttachmentPrimaryKey2	string
AttachmentPrimaryKey3	string
AttachmentPrimaryKey4	string
AttachmentPrimaryKey5	string
BackToBackFlag	boolean
BaseModelId	long
Carrier	string
CarrierId	long
ConfiguredItemFlag	boolean
CustomerItemNumber	string
CustomerPOLineNumber	string
CustomerPONumber	string
CustomerPOScheduleNumber	string
DaysLateReceiptAllowed	decimal
DeliverToCustomerLocationId	long
DeliverToOrganizationCode	string
DeliverToOrganizationId	long
DestinationTypeCode	string
FirstPartyTaxRegistrationId	long
FirstPartyTaxRegistrationNumber	string
InterfaceLineKey	string
ItemId	long
ItemNumber	string
LineIntendedUse	string
LineIntendedUseId	long
LineIntendedUseName	string
LocationOfFinalDischargeCode	string
LocationOfFinalDischargeId	long
ModeOfTransportCode	string
OrchestrationCode	string
OverReceiptTolerancePercent	decimal
ProductCategory	string
ProductCategoryName	string
ProductFiscalClassification	string
ProductFiscalClassificationId	long
ProductFiscalClassificationName	string
ProductType	string
ProductTypeName	string
Quantity	decimal
RequestedDeliveryDate	date
RequestedShipDate	date
SalesOrderLineNumber	string
SalesOrderNumber	string
SalesOrderScheduleNumber	string
ServiceLevelCode	string
ShipToCustomerContactId	long
ShipToCustomerContactName	string
ShipToCustomerContactNumber	string
ShipToCustomerId	long
ShipToCustomerLocationCLLICode	string
ShipToCustomerLocationId	long
ShipToCustomerName	string
ShipToCustomerNumber	string
SupplierId	long
SupplierName	string
SupplierSiteId	long
SupplierSiteName	string
TaxClassificationCode	string
TaxClassificationName	string
ThirdPartyTaxRegistrationId	long
ThirdPartyTaxRegistrationNumber	string
TransactionBusinessCategory	string
TransactionBusinessCategoryName	string
UnitOfMeasure	string
UnitOfMeasureCode	string
UserDefinedFiscalClassification	string
UserDefinedFiscalClassificationName	string
WorkOrderId	long
WorkOrderNumber	string
WorkOrderOperationId	long
WorkOrderOperationSequence	decimal
WorkOrderProduct	string
WorkOrderSubTypeCode	string

Purchase Request Requisition Distribution

You can't use any attributes in the PurchaseRequestInputReqDistInterface element.

Purchase Request Configuration

You can use these attributes in the PurchaseRequestConfig element.

Attribute Name	Type
Description	string
FulfillLineId	long
ItemRevision	string
Price	decimal
SupplierItemNumber	string

You can't use these attributes in the PurchaseRequestConfig element.

Attribute Name	Type
AttachmentCategory	string
AttachmentEntityName	string
AttachmentPrimaryKey1	string
AttachmentPrimaryKey2	string
AttachmentPrimaryKey3	string
AttachmentPrimaryKey4	string
AttachmentPrimaryKey5	string
BaseModelId	long
BaseModelNumber	string
ComponentLineId	long
ComponentLineNumber	long
InterfaceConfigurationComponentKey	string
ItemId	long
ItemNumber	string
ItemType	string
ParentComponentLineId	long
Quantity	decimal
UnitOfMeasure	string
UnitOfMeasureCode	string

Attributes You Can't Use in Any Element with Drop Ship

You can't use these attributes in any element with drop ship.

Attribute Name	Type
interfaceSourceCode	string
requisitioningBUId	long
requisitioningBUName	string
groupBy	string
nextRequisitionNumber	int
initiateApprovalAfterRequisitionImport	string
maximumBatchSize	int
errorProcessingLevel	string

Attributes You Can Use With Oracle Receiving

Receipt Advice

You can use these attributes in the ReceiptAdvice element.

Attribute Name	Type
Comments	string
CurrencyConversionDate	date
CurrencyConversionRate	decimal
CurrencyConversionType	string
CustomerSiteId	long
DocumentRevisionDate	dateTime
DocumentRevisionNumber	string
FreightCarrierId	long
FreightCarrierName	string
FreightTerms	string
HeaderId	long
NoteToReceiver	string
OutsourcerContactId	long
OutsourcerContactName	string
OutsourcerPartyId	long
OutsourcerPartyName	string
ShipFromLocationCode	string
ShipFromLocationId	long
ShipToLocationCode	string
ShipToLocationId	long
ShipToOrganizationCode	string
ShipToOrganizationId	long
VendorId	long
VendorName	string
VendorSiteId	long
VendorSiteName	string

You can't use these attributes in the ReceiptAdvice element.

Attribute Name	Type
CustomerPartyName	string
ActionCode	string
BUId	long
CurrencyCode	string
CustomerId	long
DocumentCreationDate	dateTime
DocumentLastUpdateDate	dateTime
DocumentNumber	string
ReceiptAdviceNumber	string
ReceiptAdviceOriginalSystemReference	string
ReceiptSourceCode	string
SourceDocumentType	string
SourceSystemId	long

ReceiptAdviceLine

You can use these attributes in the ReceiptAdviceLine element.

Attribute Name	Type
AllowSubstituteReceipt	string
Comments	string
CountryOfOriginCode	string
DaysEarlyReceiptAllowed	decimal
DaysLateReceiptAllowed	decimal
DocumentScheduleNumber	string
EnforceShipToLocCode	string
FulfillLineId	long
ItemCategory	string
ItemRevision	string
NoteToReceiver	string
OrigSourceFulfilLineNumber	string
OverReceiptExceptionCode	string
OverReceiptTolerance	decimal
ReceiptDaysExceptionCode	string
RoutingCode	string
RoutingHeaderId	long
SecondaryQuantityExpected	decimal
SecondaryUnitOfMeasure	string
SecondaryUOMCode	string
ShipFromLocationCode	string
ShipFromLocationId	long
ShipToLocationCode	string
ShipToLocationId	long
SourceLineNumber	string
SubstituteItemId	long
SubstituteItemNumber	string
VendorItemNumber	string

You can't use these attributes in the ReceiptAdviceLine element.

Attribute Name	Type
AssessableValue	decimal
CustomerItemId	long
CustomerItemNumber	string
DefaultTaxationCountry	string
DocumentFiscalClassification	string
DocumentLineCreationDate	dateTime
DocumentLineLastUpdateDate	dateTime
DocumentLineNumber	string
ExpectedReceiptDate	dateTime
FinalDischargeLocationId	long
FirstPtyRegId	long
IntendedUseClassifId	long
ItemDescription	string
ItemId	long
ItemNumber	string
OrigSalesOrderLineNumber	string
OrigSalesOrderNumber	string
OrigSourceHeaderNumber	string
OrigSourceLineNumber	string
ProductCategory	string
ProductFiscClassId	long
ProductType	string
QuantityExpected	decimal
ReceiptAdviceLineNumber	string
ReceiptSourceCode	string
ShipToOrganizationCode	string
ShipToOrganizationId	long
SourceFulfillmentLineNumber	string
SourceHeaderNumber	string
TaxClassificationCode	string
TaxInvoiceDate	date
TaxInvoiceNumber	string
TaxShipFromLocationId	long
ThirdPtyRegId	long
TransactionDate	dateTime
TrxBusinessCategory	string
UnitOfMeasure	string
UOMCode	string
UserDefinedFiscClass	string

Lot for the Receipt Advice Line

You can use these attributes in the ReceiptAdviceLineLot element.

Attribute Name	Type
FulfillLineId	long
GradeCode	string
LotExpirationDate	dateTime
ParentLotNumber	string
SecondaryTransactionQuantity	decimal
SecondaryTransactionQuantityUOMCode	string
TransactionQuantityUOMCode	string

You can't use these attributes in the ReceiptAdviceLineLot element.

Attribute Name	Type
LotNumber	string
TransactionQuantity	decimal

Serials for the Receipt Advice Line

You can use these attributes in the ReceiptAdviceLineSerials element.

Attribute Name	Type
FulfillLineId	long

You can't use these attributes in the ReceiptAdviceLineSerials element.

Attribute Name	Type
FromSerialNumber	string
ToSerialNumber	string

Lot for Receipt Advice Lines That Include Serials

You can use these attributes in the ReceiptAdviceLineLotWithSerials element.

Attribute Name	Type
FulfillLineId	long
GradeCode	string
LotExpirationDate	dateTime
ParentLotNumber	string
SecondaryTransactionQuantity	decimal
SecondaryTransactionQuantityUOMCode	string
TransactionQuantityUOMCode	string

You can't use these attributes in the ReceiptAdviceLineLotWithSerials element.

Attribute Name	Type
TransactionQuantity	decimal

Lot for Receipt Advice Line When Serials Control the Lot

You can't use any attributes in the ReceiptAdviceLineLotSerials element. Specifically, you can't use these attributes.

Attribute Name	Type
FromSerialNumber	string
ToSerialNumber	string

Attributes You Can Use With Oracle Shipping

Shipment Request Header

You can use these attributes in the ShipmentRequestHeader element.

Attribute Name	Type
CarrierPartyId	long
CarrierPartyName	string
CarrierPartyNumber	string
FobCode	string
FreightTermsCode	string
HeaderId	Long
ModeOfTransport	string
OutsourcerPartyId	long
OutsourcerPartyName	string
OutsourcerPartyNumber	string
ServiceLevel	string
ShipFromLocationId	long

You can't use these attributes in the ShipmentRequestHeader element.

Attribute Name	Type
ActionType	string
BillToContactId	long
BillToContactName	string
BillToContactNumber	string
BillToPartyId	long
BillToPartyName	string
BillToPartyNumber	string
BillToPartySiteId	long
BillToPartySiteNumber	string
ConversionDate	dateTime
ConversionRate	decimal
ConversionType	string
CurrencyCode	string
DocumentNumber	string
OrganizationCode	string
OrganizationId	long
OrganizationName	string
SalesOrderNumber	string
ShipToContactId	long
ShipToContactName	string
ShipToContactNumber	string
ShipToPartyId	long
ShipToPartyName	string
ShipToPartyNumber	string
ShipToPartySiteId	long
ShipToPartySiteNumber	string
SoldPartyName	string
SoldToContactId	long
SoldToContactName	string
SoldToContactNumber	string
SoldToPartyId	long
SoldToPartyNumber	string
SourceDocumentType	string
SourceHeaderNumber	string
SourceSystemId	long
SourceSystemName	string

Shipment Request Line

You can use these attributes in the ShipmentRequestLine element.

Attribute Name	Type
ArrivalSetName	string
CurrencyCode	string
CustomerItemNumber	string
DoNotShipAfterDate	dateTime
DoNotShipBeforeDate	dateTime
EarliestDropoffDate	dateTime
EarliestPickupDate	dateTime
EndAssemblyItemNumber	string
FinalDischargeLocCode	string
FulfillLineId	long
InitialDestinationLocationId	long
IntendedUse	string
ItemDescription	string
LatestDropoffDate	dateTime
LatestPickupDate	dateTime
OrderedQuantity2	decimal
OrderedQuantityUomCode2	string
OrderedQuantityUomName2	string
PreferredGrade	string
ShipToleranceAbove	decimal
ShipToleranceBelow	decimal
SourceLineUpdateDate	dateTime
SourceShipmentId	long
SrcAttribute1	string
SrcAttribute10	string
SrcAttribute11	string
SrcAttribute12	string
SrcAttribute13	string
SrcAttribute14	string
SrcAttribute15	string
SrcAttribute16	string
SrcAttribute17	string
SrcAttribute18	string
SrcAttribute19	string
SrcAttribute2	string
SrcAttribute20	string
SrcAttribute3	string
SrcAttribute4	string
SrcAttribute5	string
SrcAttribute6	string
SrcAttribute7	string
SrcAttribute8	string
SrcAttribute9	string
SrcAttributeCategory	string
SrcAttributeDate1	date
SrcAttributeDate2	date
SrcAttributeDate3	date
SrcAttributeDate4	date
SrcAttributeDate5	date
SrcAttributeNumber1	decimal
SrcAttributeNumber10	decimal
SrcAttributeNumber2	decimal
SrcAttributeNumber3	decimal
SrcAttributeNumber4	decimal
SrcAttributeNumber5	decimal
SrcAttributeNumber6	decimal
SrcAttributeNumber7	decimal
SrcAttributeNumber8	decimal
SrcAttributeNumber9	decimal
SrcAttributeTimestamp1	dateTime
SrcAttributeTimestamp2	dateTime
SrcAttributeTimestamp3	dateTime
SrcAttributeTimestamp4	dateTime
SrcAttributeTimestamp5	dateTime
TradeComplianceScreeningDate	dateTime
TradeComplianceScreeningReason	string
TradeComplianceScreeningStatus	string
TransportationPlanningStatus	string
TransportationShipment	string
TransportationShipmentLine	string

You can't use these attributes in the ShipmentRequestLine element.

Attribute Name	Type
AssessableValue	decimal
BaseItemId	long
BaseItemNumber	string
BillToContactId	long
BillToContactName	string
BillToContactNumber	string
BillToPartyId	long
BillToPartyName	string
BillToPartyNumber	string
BillToPartySiteId	long
BillToPartySiteNumber	string
BusinessUnitName	string
CarrierPartyId	long
CarrierPartyName	string
CarrierPartyNumber	string
CategoryId	long
CategoryName	string
CustPoNumber	string
DateRequested	dateTime
DateScheduled	dateTime
DefaultTaxationCountry	string
DocumentSubType	string
ExemptCertificateNumber	string
ExemptReasonCode	string
FinalDischargeLocationId	long
FirstPtyNumber	string
FirstPtyRegId	long
FobCode	string
FreightTermsCode	string
FromSubinventoryCode	string
IntendedUseClassifId	decimal
InventoryItemId	long
ItemNumber	string
LineActionType	string
ModeOfTransport	string
OrderedQuantity	decimal
OrderedQuantityUomCode	string
OrderedQuantityUomName	string
OrganizationCode	string
OrganizationId	long
OrganizationName	string
OrgId	long
PackingInstructions	string
ParentInventoryItemId	long
ParentItemNumber	string
ParentSourceShipmentId	long
ProductCategory	string
ProductType	string
ReleaseLock	string
RequestDateTypeCode	string
SalesOrderLineNumber	string
SalesOrderShipmentNumber	string
SellingPrice	decimal
ServiceLevel	string
ShipmentPriorityCode	string
ShippingInstructions	string
ShipSetName	string
ShipToContactId	long
ShipToContactName	string
ShipToContactNumber	string
ShipToPartyId	long
ShipToPartyName	string
ShipToPartyNumber	string
ShipToPartySiteId	long
ShipToPartySiteNumber	string
SoldToContactId	long
SoldToContactName	string
SoldToContactNumber	string
SoldToPartyId	long
SoldToPartyName	string
SoldToPartyNumber	string
SourceLineNumber	string
SourceShipmentNumber	string
TaxClassificationCode	string
TaxInvoiceDate	date
TaxInvoiceNumber	string
ThirdPtyNumber	string
ThirdPtyRegId	long
TrxBusinessCategory	string
UnitPrice	decimal
UserDefinedFiscClass	string

Order Line for a Shipment Request Hold

You can't use any attributes in the ShipmentRequestOrderLineHold element. Specifically, you can't use these attributes.

Attribute Name	Type
HoldActionCode	string
HoldId	long
HoldReasonCode	string
HoldReason	string

Attributes You Must Not Use

You must not use these fulfillment line attributes in any integration.

Unit List Price
Unit Selling Price
Extended Amount