JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

InventoryCompletedTransactionslots

The Lots in Completed Transactions resource gets lot details for inventory transactions when the item is under lot control. The details include lot, parent lot, quantity, grade, expiration action, maturity date, and so on.

Columns

Name Type Description
InventoryCompletedTransactionsTransactionId [KEY] Long InventoryCompletedTransactionsTransactionId of InventoryCompletedTransactionslots
LotNumber [KEY] String LotNumber of InventoryCompletedTransactionslots
ParentLot String ParentLot of InventoryCompletedTransactionslots
TransactionQuantity Decimal TransactionQuantity of InventoryCompletedTransactionslots
Status String Status of InventoryCompletedTransactionslots
StatusId Long StatusId of InventoryCompletedTransactionslots
SupplierLotNumber String SupplierLotNumber of InventoryCompletedTransactionslots
GradeCode String GradeCode of InventoryCompletedTransactionslots
OriginationTypeCode Long OriginationTypeCode of InventoryCompletedTransactionslots
OriginationType String OriginationType of InventoryCompletedTransactionslots
OriginationDate Date OriginationDate of InventoryCompletedTransactionslots
RetestDate Date RetestDate of InventoryCompletedTransactionslots
ExpirationActionCode String ExpirationActionCode of InventoryCompletedTransactionslots
ExpirationAction String ExpirationAction of InventoryCompletedTransactionslots
ExpirationActionDate Date ExpirationActionDate of InventoryCompletedTransactionslots
HoldDate Date HoldDate of InventoryCompletedTransactionslots
MaturityDate Date MaturityDate of InventoryCompletedTransactionslots
Reason String Reason of InventoryCompletedTransactionslots
ReasonId Long ReasonId of InventoryCompletedTransactionslots
BindInventoryItemId Long BindInventoryItemId of InventoryCompletedTransactionslots
BindItem String BindItem of InventoryCompletedTransactionslots
BindOrganization String BindOrganization of InventoryCompletedTransactionslots
BindOrganizationId Long BindOrganizationId of InventoryCompletedTransactionslots
BindPJCProjectId String BindPJCProjectId of InventoryCompletedTransactionslots
BindPJCProjectNumber String BindPJCProjectNumber of InventoryCompletedTransactionslots
BindPJCTaskId String BindPJCTaskId of InventoryCompletedTransactionslots
BindPJCTaskNumber String BindPJCTaskNumber of InventoryCompletedTransactionslots
BindTransactionDate Datetime BindTransactionDate of InventoryCompletedTransactionslots
BindTransactionId Long BindTransactionId of InventoryCompletedTransactionslots
Finder String Finder of InventoryCompletedTransactionslots
TransactionId Long TransactionId of InventoryCompletedTransactionslots

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062