1. SOAP Web Services for SCM
  2. Staged Inventory Transaction Serial Number Both Controls Version 2

Staged Inventory Transaction Serial Number Both Controls Version 2

An object representing the serial number details for the staged inventory transaction. This is for an item under both lot and serial number controls.

QName: {http://xmlns.oracle.com/apps/scm/inventory/materialTransactions/pendingTransactions/stagedInventoryTransactionServiceV2/}StagedInventoryTransactionSerialByLot

Logical Business Objects

  • SCM : Inventory Management : Pending Inventory Transaction

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

Contained by

Staged Inventory Transaction Lot Version 2

Handled by

Transaction Manager Version 2

Handled by

Staged Inventory Transaction Version 2

Attributes

The following table describes attributes in the service data object.

Name Type Description

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.

CAttribute1

string

Descriptive flexfield segment.

CAttribute10

string

Descriptive flexfield segment.

CAttribute11

string

Descriptive flexfield segment.

CAttribute12

string

Descriptive flexfield segment.

CAttribute13

string

Descriptive flexfield segment.

CAttribute14

string

Descriptive flexfield segment.

CAttribute15

string

Descriptive flexfield segment.

CAttribute16

string

Descriptive flexfield segment.

CAttribute17

string

Descriptive flexfield segment.

CAttribute18

string

Descriptive flexfield segment.

CAttribute19

string

Descriptive flexfield segment.

CAttribute2

string

Descriptive flexfield segment.

CAttribute20

string

Descriptive flexfield segment.

CAttribute3

string

Descriptive flexfield segment.

CAttribute4

string

Descriptive flexfield segment.

CAttribute5

string

Descriptive flexfield segment.

CAttribute6

string

Descriptive flexfield segment.

CAttribute7

string

Descriptive flexfield segment.

CAttribute8

string

Descriptive flexfield segment.

CAttribute9

string

Descriptive flexfield segment.

CyclesSinceMark

decimal

Number of cycles since the serial number is marked for maintenance, repair, and overhaul Industry.

CyclesSinceNew

decimal

Cycles since new for maintenance, repair, and overhaul industry.

CyclesSinceOverhaul

decimal

Cycles since overhaul for maintenance, repair, and overhaul industry.

CyclesSinceRepair

decimal

Cycles since repair for maintenance, repair, and overhaul industry.

CyclesSinceVisit

decimal

Cycles since visit for maintenance, repair, and overhaul industry .

DAttribute1

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flexfield segment.

DAttribute10

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flexfield segment.

DAttribute2

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flexfield segment.

DAttribute3

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flexfield segment.

DAttribute4

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flexfield segment.

DAttribute5

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flexfield segment.

DAttribute6

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flexfield segment.

DAttribute7

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flexfield segment.

DAttribute8

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flexfield segment.

DAttribute9

{http://xmlns.oracle.com/adf/svc/types/}date-Date

Descriptive flexfield segment.

ErrorCode

string

Indicates that there is a problem associated with the object.

FmSerialNumber

string
Starting serial number in a range of serial numbers.

  • Primary Key

LoadRequestId

long

Used by Enterprise Service Scheduler to indicate the request ID of the Interface load job that created the row.

NAttribute1

decimal

Descriptive flexfield segment.

NAttribute10

decimal

Descriptive flexfield segment.

NAttribute2

decimal

Descriptive flexfield segment.

NAttribute3

decimal

Descriptive flexfield segment.

NAttribute4

decimal

Descriptive flexfield segment.

NAttribute5

decimal

Descriptive flexfield segment.

NAttribute6

decimal

Descriptive flexfield segment.

NAttribute7

decimal

Descriptive flexfield segment.

NAttribute8

decimal

Descriptive flexfield segment.

NAttribute9

decimal

Descriptive flexfield segment.

NumberOfRepairs

decimal

Number of repairs for maintenance, repair, and overhaul industry.

OriginationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Creation date of the serial number.

ParentItemId

long

Parent item identifier.

ParentObjectId

long

Genealogy object identifier of the parent entity.

ParentObjectId2

long

Genealogy object identifier of the lot for lot and serial assembly item.

ParentObjectNumber

string

Parent object number.

ParentObjectNumber2

string

Lot number for a lot and serial assembly item.

ParentObjectType

decimal

Parent object type.

ParentObjectType2

decimal

Need clarification on this.

ParentSerialNumber

string

Parent serial number.

ProcessCode

decimal

Indicates the processing status of the transaction.

ProductCode

string

Product name to identify the source transaction for the record.

ProductTransactionId

long

Product transaction identifier.

SerialAttributeCategory

string

Structure defining column for serial attributes flexfield.

SourceCode

string

Transaction source identifier.

SourceLineId

long

Transaction source line identifier.

StatusCode

string

Indicates the status of the material.

StatusId

long

Status identifier.

StatusName

string

Material status of the serial number.

TAttribute1

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Descriptive flexfield segment.

TAttribute2

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Descriptive flexfield segment.

TAttribute3

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Descriptive flexfield segment.

TAttribute4

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Descriptive flexfield segment.

TAttribute5

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Descriptive flexfield segment.

TerritoryCode

string

Territory code for the country of origin.

TimeSinceMark

decimal

Time since the serial number is marked for maintenance, repair, and overhaul industry.

TimeSinceNew

decimal

Time since new for maintenance, repair, and overhaul industry.

TimeSinceOverhaul

decimal

Time since overhaul for maintenance, repair, and overhaul industry.

TimeSinceRepair

decimal

Time since repair for maintenance, repair, and overhaul industry.

TimeSinceVisit

decimal

Time since visit for maintenance, repair, and overhaul industry.

ToSerialNumber

string

Ending serial number in a range of serial numbers.

TransactionInterfaceId

long
Transaction interface Identifier.

  • Primary Key

VendorLotNumber

string

Lot assigned to the item by the supplier.

VendorSerialNumber

string

Serial number assigned to the item by the supplier.