1. SOAP Web Services for SCM
  2. Staged Inventory Transaction Lot Version 2

Staged Inventory Transaction Lot Version 2

An object representing the lot details for the staged inventory transaction.

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

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

Contains

Staged Inventory Transaction Serial Number Both Controls SDO Version 2

Contained by

Staged Inventory Transaction 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

Age

decimal

Age of the lot in days after the creation date.

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.

BestByDate

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

Date on which the lot is best used by.

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.

ChangeDate

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

Date on which an attribute of the lot was changed.

Color

string

Lot color.

CurlWrinkleFold

string

Used in the pulp and paper industry to identify potential problems when feeding the paper through machinery.

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.

DateCode

string

Identifies the date of packaging or assembly.

Description

string

Lot description.

ErrorCode

string

Indicates that there is a problem associated with the object.

ExpirationActionCode

string

The action to take when the lot expires.

ExpirationActionDate

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

The date the expiration action takes place based on the expiration date and the expiration action interval.

ExpirationActionName

string

The action to take when the lot expires.

GradeCode

string

Description of the lot grade.

HoldDate

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

The date on which the lot can be released.

ItemSize

decimal

Item size.

LengthUOM

string

Length unit of measure associated with the lot.

LengthUOMName

string

Length unit of measure associated with the lot.

LoadRequestId

long

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

LotAttributeCategory

string

Lot attributes descriptive flexfield structure defining column.

LotExpirationDate

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

The date when an asset becomes obsolete or unserviceable.

LotLength

decimal

Length associated with the lot.

LotNumber

string
A quantity of items that are produced together and that share the same production costs and specifications.

  • Primary Key

LotThickness

decimal

Thickness associated with the lot.

LotVolume

decimal

Volume associated with the lot.

LotWidth

decimal

Width associated with the lot.

MaturityDate

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

The date the lot has reached its full maturity.

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.

OriginationDate

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

Lot creation date.

OriginationType

decimal

Signifies whether the lot was created on the lot master, or while performing a transaction.

ParentItemId

long

Parent item identifier.

ParentLotNumber

string

A lot from which one or multiple child lots are created.

ParentObjectId

long

Genealogy object identifier of the parent entity.

ParentObjectId2

long

Genealogy object identifier of the lot that corresponds to the serial number.

ParentObjectNumber

string

Parent object number.

ParentObjectNumber2

string

Indicates the lot that corresponds to the serial number.

ParentObjectType

decimal

Parent object type.

ParentObjectType2

decimal

Need clarification on this.

PlaceOfOrigin

string

Indicates the place the inventory originated.

PrimaryQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

The quantity of an item expressed in its primary unit of measure.

PrimaryQuantityUOM

string

UOM associated with the primary quantity.

ProcessCode

string

Row process flag.

ProductCode

string

Product name to identify the source transaction for the record.

ProductTransactionId

long

Product transaction identifier.

ReasonCode

string

Reason for the inventory transaction.

ReasonId

long

Transaction reason identifier.

ReasonName

string

Reason for the inventory transaction.

RecycledContent

decimal

Percentage of a product made from recycled material.

RetestDate

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

The date to retest the lot based on the lot origination date and the retest interval.

SecondaryQuantityUOM

string

UOM associated with the secondary quantity.

SecondaryTransactionQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

Transaction quantity of an item expressed in its secondary unit of measure.

SerialTransactionTempId

long

Serial transaction identifier.

SourceCode

string

Transaction source identifier.

SourceLineId

long

Transaction source line identifier.

StagedInventoryTransactionSerialByLot

Staged Inventory Transaction Serial Number Both Controls Version 2

Staged Inventory Transaction Serial Number Both Controls SDO.

StatusCode

string

Indicates the status of the material.

StatusId

long

The material status associated with the lot.

SublotNumber

string

Sub lot number.

SupplierLotNumber

string

The lot assigned to the item by the supplier.

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.

TerritoryShortName

string

Territory short name.

ThicknessUOM

string

Thickness unit of measure associated with the lot.

TransactionInterfaceId

long
Transaction interface Identifier.

  • Primary Key

TransactionQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

The quantity of an item transacted in the transaction UOM.

TransactionQuantityUOM

string

UOM associated with the transaction quantity.

VendorId

long

Supplier identifier.

VendorName

string

A party that provides a product in return for what may or may not require some type of payment.

VolumeUOM

string

Volume unit of measure associated with the lot.

VolumeUOMName

string

Volume unit of measure associated with the lot.

WidthUOM

string

Width unit of measure associated with the lot.

WidthUOMName

string

Width unit of measure associated with the lot.