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 |
Inventory Tracking Attributes for Receiving Transactions Interface SDO |
Contains |
|
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. |