Staged Receiving Transaction Interface Version 2
An object that represents the inbound shipment line of the receiving transaction line-level information.
QName: {http://xmlns.oracle.com/apps/scm/receiving/receiptsInterface/transactions/processorServiceV2/}StagedReceivingTransaction
Logical Business Objects
-
SCM : Receiving : Receiving Open Interface
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
| Relationship Type | Object or Service |
|---|---|
|
Contains |
|
|
Contains |
|
|
Contains |
Inventory Tracking Attributes for Receiving Transactions Interface SDO |
|
Contains |
|
|
Contains |
|
|
Contained by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
ASNLineNumber |
long |
ASN line number. |
|
ActualCost |
decimal |
Actual Cost |
|
Amount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The amount associated with the transaction. |
|
AmountCurrency |
string |
Currency for the amount associated with the transaction. |
|
AssessableValue |
decimal |
Assessable value is the deemed price at which a product is valued, by a tax authority for a given tax, for tax calculation purposes. |
|
Attribute1 |
string |
Descriptive flexfield segment. |
|
Attribute10 |
string |
Descriptive flexfield segment. |
|
Attribute11 |
string |
Descriptive flexfield segment. |
|
Attribute12 |
string |
Descriptive flexfield segment. |
|
Attribute13 |
string |
Descriptive flexfield segment. |
|
Attribute14 |
string |
Descriptive flexfield segment. |
|
Attribute15 |
string |
Descriptive flexfield segment. |
|
Attribute16 |
string |
Descriptive flexfield segment. |
|
Attribute17 |
string |
Descriptive flexfield segment. |
|
Attribute18 |
string |
Descriptive flexfield segment. |
|
Attribute19 |
string |
Descriptive flexfield segment. |
|
Attribute2 |
string |
Descriptive flexfield segment. |
|
Attribute20 |
string |
Descriptive flexfield segment. |
|
Attribute3 |
string |
Descriptive flexfield segment. |
|
Attribute4 |
string |
Descriptive flexfield segment. |
|
Attribute5 |
string |
Descriptive flexfield segment. |
|
Attribute6 |
string |
Descriptive flexfield segment. |
|
Attribute7 |
string |
Descriptive flexfield segment. |
|
Attribute8 |
string |
Descriptive flexfield segment. |
|
Attribute9 |
string |
Descriptive flexfield segment. |
|
AttributeCategory |
string |
Descriptive flexfield structure definition. |
|
AttributeDate1 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive flexfield segment. |
|
AttributeDate2 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive flexfield segment. |
|
AttributeDate3 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive flexfield segment. |
|
AttributeDate4 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive flexfield segment. |
|
AttributeDate5 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive flexfield segment. |
|
AttributeNumber1 |
decimal |
Descriptive flexfield segment. |
|
AttributeNumber10 |
decimal |
Descriptive flexfield segment. |
|
AttributeNumber2 |
decimal |
Descriptive flexfield segment. |
|
AttributeNumber3 |
decimal |
Descriptive flexfield segment. |
|
AttributeNumber4 |
decimal |
Descriptive flexfield segment. |
|
AttributeNumber5 |
decimal |
Descriptive flexfield segment. |
|
AttributeNumber6 |
decimal |
Descriptive flexfield segment. |
|
AttributeNumber7 |
decimal |
Descriptive flexfield segment. |
|
AttributeNumber8 |
decimal |
Descriptive flexfield segment. |
|
AttributeNumber9 |
decimal |
Descriptive flexfield segment. |
|
AttributeTimestamp1 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Descriptive flexfield segment. |
|
AttributeTimestamp2 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Descriptive flexfield segment. |
|
AttributeTimestamp3 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Descriptive flexfield segment. |
|
AttributeTimestamp4 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Descriptive flexfield segment. |
|
AttributeTimestamp5 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Descriptive flexfield segment. |
|
AutoTransactCode |
string |
Automatic transaction creation code that is applicable for transaction types of SHIP and RECEIVE. |
|
BUId |
long |
The identifier of the business unit. |
|
BarcodeLabel |
string |
The bar code label for the material on the shipment line. |
|
BillOfLading |
string |
A carrier's contract and receipt for the goods that the carrier agrees to transport from a specific origin address to a specific destination address. |
|
BusinessUnit |
string |
A unit of an enterprise that performs one or many business functions that can be rolled up in a management hierarchy. |
|
CategoryId |
long |
Unique identifier for item category. |
|
Comments |
string |
User entered comments. |
|
ConsignedTransaction |
string |
Indicates receipt is consigned. |
|
ContainerNumber |
string |
Container number. |
|
CountryOfOriginCode |
string |
The country from which goods are exported. |
|
CreateDebitMemoFlag |
boolean |
Flag which determines if a debit memo has to be created or not. |
|
CurrencyCode |
string |
Currency code. |
|
CurrencyConversionDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Currency conversion date. |
|
CurrencyConversionRate |
decimal |
Currency conversion rate. |
|
CurrencyConversionType |
string |
Currency conversion type. |
|
CustomerAccountNumber |
long |
Number that identifies a customer account. |
|
CustomerId |
long |
Unique identifier for the customer. |
|
CustomerItemId |
long |
Unique identifier for item received from customer. |
|
CustomerItemNumber |
string |
An alternate key for the internal item used by customers to uniquely identify the item. This number will have a cross- reference to the internal item. |
|
CustomerPartyName |
string |
Customer party name. |
|
CustomerPartyNumber |
string |
Unique identifier for customer party number. Used to derive CUSTOMER_ID in conjunction with CUSTOMER_PARTY_NUMBER. Maps to HZ_PARTIES.PARTY_NUMBER. |
|
CustomerSiteId |
long |
Customer site identifier. |
|
DefaultTaxationCountry |
string |
Taxation country code. |
|
DeliverToLocationCode |
string |
The physical location or address to which a delivery of goods or services will be made. |
|
DeliverToLocationId |
long |
Unique identifier for the deliver-to location. |
|
DeliverToPersonId |
long |
Unique identifier for the deliver-to person. |
|
DeliverToPersonName |
string |
The person to whom a delivery of goods or services will be made. |
|
DestinationContext |
string |
Destination context. |
|
DestinationTypeCode |
string |
The destination type, expense or inventory/shop floor, determines the accounting behavior of the transaction line. |
|
DocumentDistributionNumber |
long |
Document distribution number. |
|
DocumentFiscalClassification |
string |
Document fiscal classification code. |
|
DocumentLineNumber |
long |
Document line number. |
|
DocumentNumber |
string |
Document number. |
|
DocumentShipmentLineNumber |
long |
Document schedule number. |
|
DsReceiptEventType |
string |
Identifies the source that triggers the creation of the Drop Ship Receipt. |
|
DsReceiptSourceLineId |
long |
Source document line that created the Drop Ship Receipt. |
|
EmployeeId |
long |
Unique identifier associated with the employee. |
|
EmployeeName |
string |
Employee name. |
|
EwayBillDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date when the electronic waybill was generated. This value is used to calculate the goods and services tax for India. |
|
EwayBillNumber |
long |
Number that identifies the electronic waybill provided by supplier for shipment of goods. This value is used to calculate the goods and services tax for India. |
|
ExpectedReceiptDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date on which the receipt is expected. |
|
ExternalSystemPackingUnit |
string |
The license plate number (LPN) of the external/third party Warehouse Management System (WMS). |
|
FinalDischargeLocationId |
long |
Unique identifier for the final discharge location. |
|
FirstPtyRegId |
long |
Unique identifier for the first party tax registration for the transaction. |
|
FiscalDocumentAccessKnum |
string |
Fiscal Document Access Key Number. |
|
FiscalDocumentHeaderId |
long |
Unique identifier for Fiscal Document header. |
|
FiscalDocumentLineId |
long |
Unique identifier for Fiscal Document line. |
|
FreightCarrierId |
long |
Unique identifier for a carrier. |
|
FreightCarrierName |
string |
A company that transports goods from one point to another by land, sea, or air. |
|
FromLocator |
string |
Source locator concatenated segments. |
|
FromLocatorId |
long |
Unique identifier for transfer from locator. |
|
FromOrganizationCode |
string |
Organization for point of origin of the shipment. |
|
FromOrganizationId |
long |
Unique identifier for the source organization. |
|
FromSubinventory |
string |
Source subinventory name. |
|
InspectionQualityCode |
string |
The code assigned based on the inspection quality. |
|
InspectionStatusCode |
string |
The inspection status for the receipt line |
|
IntendedUse |
string |
This identifies the purpose for which the product is used. |
|
IntendedUseClassifId |
long |
Unique identifier for the intended use classification of the transaction line. This identifies the purpose for which the product is used. |
|
InterfaceSourceCode |
string |
Source of the transaction interface row. |
|
InterfaceSourceLineId |
long |
Source line identifier of the transaction interface row. |
|
IntransitOwningOrgCode |
string |
In-transit owning organization code for inter-organization transfers. |
|
IntransitOwningOrgId |
long |
Organization that owns the items while they are in transit. |
|
ItemCategory |
string |
Grouping of items with similar characteristics such as plastics, paints, inks, or foods. |
|
ItemDescription |
string |
Description of an item. |
|
ItemId |
long |
Unique identifier for an item. |
|
ItemNumber |
string |
Unique identifier for an item. |
|
ItemRevision |
string |
Revision of the item. |
|
LPNGroupId |
long |
Packing unit group identifier |
|
LPNId |
long |
Source packing unit unique identifier. |
|
LicensePlateNumber |
string |
Unique identifier assigned to a single container, or a collection of items, stored in a single location. |
|
LocationCode |
string |
Unique code for a physical location within a warehouse where inventory is received. |
|
LocationId |
long |
Unique identifier for a physical location within a warehouse where inventory is received. |
|
Locator |
string |
Location within Inventory Organization where goods are stored |
|
LocatorId |
long |
Unique identifier for a locator. |
|
MatchingBasis |
string |
Options that control the creation of invoice distributions based on purchase orders or receipts. |
|
NoticeUnitPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
EDI transaction 857 unit price. |
|
NoticeUnitPriceCurrency |
string |
Currency for EDI transaction 857 unit price. |
|
NumberOfContainers |
long |
Number of containers in the shipment. |
|
PODistributionId |
long |
Unique identifier for the purchase order distribution. |
|
POHeaderId |
long |
Unique identifier for the purchase order header. |
|
POLineId |
long |
Unique identifier for the purchase order line. |
|
POLineLocationId |
long |
Unique identifies for the purchase order schedule. |
|
PORevisionNumber |
long |
A number that distinguishes changed purchase order versions. |
|
POUnitPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Price of the item on the document line. |
|
POUnitPriceCurrency |
string |
Currency for the price of the item on the document line. |
|
PackingSlip |
string |
A document that itemizes in detail the contents of a particular package, carton, pallet, or container for shipment to a customer. |
|
ParentInterfaceTransactionId |
long |
Unique identifier used to link the current row to the parent staged transaction row. |
|
ParentSourceTransactionNumber |
string |
Unique number used to link the current row to the parent staged transaction row. |
|
ParentTransactionId |
long |
Unique identifier used to link the current row to the parent transaction. |
|
PhysicalReturnReqd |
string |
Indicates if physical return of material is required for returns against a transfer order |
|
PrimaryQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The quantity of an item expressed in its primary unit of measure. |
|
PrimaryUOMCode |
string |
Code representing the primary unit of measure. |
|
PrimaryUnitOfMeasure |
string |
The principal unit of measure in which the quantity of an item is managed. |
|
ProductCategory |
string |
Product category code of the transaction line. |
|
ProductFiscClassId |
long |
Unique identifier for the product fiscal classification of the inventory item. |
|
ProductType |
string |
Product type code of the inventory item. Possible values are GOODS and SERVICES. |
|
QcGrade |
string |
Quality grade of the received item. |
|
Quantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The quantity associated with the transaction. |
|
RMAReference |
string |
Return material authorization reference for the return to supplier transaction. |
|
RaDocumentLineNumber |
string |
Source document line number for the receipt advice. |
|
RaDocumentNumber |
string |
Source document number for the receipt advice. |
|
RaDocumentScheduleNumber |
string |
Source document schedule number for the receipt advice. |
|
RaOutsourcerPartyId |
long |
Unique identifier for the logistics outsourcer party |
|
RaOutsourcerPartyName |
string |
Logistics outsourcer party name. |
|
RcvTxnIntfInvStripingDFFVA |
Inventory Tracking Attributes for Receiving Transactions Interface SDO |
Identifies the inventory striping attributes corresponding to the staged receiving transaction interface row. |
|
ReasonId |
long |
Unique identifier for the transaction reason. |
|
ReasonName |
string |
An explanation or justification that explains why a particular action such as Cancelation, Apply Hold, Close out is performed. |
|
ReceiptAdviceHeaderId |
long |
Unique identifier for the receipt advice header. |
|
ReceiptAdviceLineId |
long |
Unique identifier for the receipt advice line. |
|
ReceiptAdviceLineNumber |
string |
Receipt advice line number. |
|
ReceiptAdviceNumber |
string |
Receipt advice number. |
|
ReceiptExceptionFlag |
boolean |
Indicates if there is an exception for the receipt line. |
|
ReceiptSourceCode |
string |
Source type of the shipment. |
|
ReferenceFiscalDocumentAccessKnum |
string |
Reference Fiscal Document Access Key Number. |
|
ReferenceFiscalDocumentHeaderId |
long |
Unique identifier for Reference Fiscal Document header. |
|
ReferenceFiscalDocumentLineId |
long |
Unique identifier for Reference Fiscal Document line. |
|
ReplenishOrderLineId |
long |
Unique identifier for the replenishment sales order line. |
|
RoutingCode |
string |
A method of simplifying transaction entry by specifying routing steps for receipts. |
|
RoutingHeaderId |
long |
Unique identifier for the receipt routing. |
|
SecondaryQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The quantity of an item expressed in its secondary unit of measure. |
|
SecondaryUOMCode |
string |
Code for the secondary unit of measure. |
|
SecondaryUnitOfMeasure |
string |
A unit of measure that does not have a fixed conversion from the primary UOM. Also, part of dual unit of measure record keeping that enables industries to maintain and use. |
|
ShipFromLocationId |
long |
Unique identifier for the ship-from location. |
|
ShipToLocationCode |
string |
The name of the location where the supplier should ship the goods. |
|
ShipToLocationId |
long |
Unique identifier for the ship-to location. |
|
ShipmentHeaderId |
long |
Unique identifier for the shipment header. |
|
ShipmentLineId |
long |
Unique identifier for the shipment line. |
|
ShipmentLineStatusCode |
string |
Status code for shipment line. |
|
ShipmentNumber |
string |
The identifier of the shipment associated with the document. |
|
ShippedDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date when goods or services were shipped by supplier. |
|
SoldtoLeId |
long |
Unique identifier for the Sold-to Legal Entity. |
|
SoldtoLegalEntity |
string |
Sold-to Legal Entity name. |
|
SourceDocumentCode |
string |
Source document type. |
|
SourceDocumentQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Transaction quantity in terms of the source document's unit of measure. |
|
SourceDocumentUOMCode |
string |
Source document's unit of measure code. |
|
SourceDocumentUnitOfMeasure |
string |
Source document's unit of measure. |
|
SourceTransactionNumber |
string |
Source transaction Number. |
|
StagedLicensePlateNumber |
Identifies the source packing unit or the transfer packing unit of the receiving transaction row. |
|
|
StagedLotSerialItemLot |
The lot number information corresponding to the staged receiving transaction interface row that is used when the item being transacted is under both lot and serial control. |
|
|
StagedTransactionLot |
The lot information corresponding to the staged receiving transaction interface row that is used when the item being transacted is under lot control, but not under serial number control. |
|
|
StagedTransactionSerial |
The serial number information corresponding to the staged receiving transaction interface row that is used when the item being transacted is under serial control, but not under lot control. |
|
|
Subinventory |
string |
The subinventory where the material is transferred. |
|
SubstituteItemId |
long |
Unique identifier for the substitute item. |
|
SubstituteItemNumber |
string |
Substitute item number. |
|
SubstituteUnorderedCode |
string |
An indicator for an unordered receipt. |
|
TaskId |
long |
Task identifier for timecard. |
|
TaxAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The monetary value of tax associated with the invoice. |
|
TaxAmountCurrency |
string |
Currency for the monetary value of tax associated with the invoice. |
|
TaxClassificationCode |
string |
Tax classification code. |
|
TaxInvoiceDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date of the fiscal document. |
|
TaxInvoiceNumber |
string |
The number of the fiscal document. |
|
TaxName |
string |
The name of the classification of a charge imposed by a government through a fiscal or tax authority. |
|
ThirdPtyRegId |
long |
Unique identifier for the third party tax registration for the transaction. |
|
ToOrganizationCode |
string |
The organization to where the transfer occurs. |
|
ToOrganizationId |
long |
Unique identifier for the organization. |
|
TransactionDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date a transaction is created. |
|
TransactionType |
string |
A subclassification of a transaction class used by Oracle applications to categorize a transaction. For example, rejection of customer return and miscellaneous issue are types of issues from store. |
|
TransferCost |
decimal |
The transfer cost for inter organizational shipments |
|
TransferLPNId |
long |
Unique identifier for the transfer packing unit. |
|
TransferLicensePlateNumber |
string |
The packing unit to which the item is transferred. |
|
TransferOrderDistId |
long |
Unique identifier for the transfer order distribution. |
|
TransferOrderHeaderId |
long |
Unique identifier for the transfer order header. |
|
TransferOrderLineId |
long |
Unique identifier for the transfer order line. |
|
TransferPercentage |
decimal |
Transfer percentage for costing. |
|
TruckNumber |
string |
A unique identifier assigned to a vehicle. |
|
TrxBusinessCategory |
string |
Transaction business category code. |
|
UOMCode |
string |
The unit of measure code for the item. |
|
UnitOfMeasure |
string |
The unit of measure for the item. |
|
UserDefinedFiscClass |
string |
User defined fiscal classification code. |
|
VendorId |
long |
Unique identifier for a supplier. |
|
VendorItemNumber |
string |
Supplier item number from the purchase order shipment line. |
|
VendorLotNumber |
string |
Lot number of the item from the supplier. |
|
VendorName |
string |
A party that provides a product in return for what may or may not require some type of payment. |
|
VendorNumber |
string |
Unique number to identify a supplier. |
|
VendorSiteCode |
string |
The entity that models how the buying organization conducts business with the supplier. |
|
VendorSiteId |
long |
Unique identifier for a supplier site. |
|
WaybillAirbillNumber |
string |
Non-negotiable document describing the contract for transporting cargo. |