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 |
|
Handled by |
|
Handled by |
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.
|
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.
|
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. |