ODBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

ReceivingReceiptRequestslineslotItemLots

The Lots for Lot Items resource manages the lot number information for a line whose item is lot controlled and not serial controlled.

Columns

Name Type Description
ReceivingReceiptRequestsHeaderInterfaceId [KEY] Long ReceivingReceiptRequestsHeaderInterfaceId of ReceivingReceiptRequestslineslotItemLots
LinesInterfaceTransactionId [KEY] Long LinesInterfaceTransactionId of ReceivingReceiptRequestslineslotItemLots
LotNumber [KEY] String Number that identifies the lot corresponding to the advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under lot control.
LotExpirationDate Date Date when the item of the lot corresponding to the advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under lot control.
ParentLotNumber String Number that identifies the parent lot of the lot corresponding to the advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under lot control.
VendorLotNumber String Number that identifies the supplier lot for the lot corresponding to the advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under lot control.
TransactionQuantity Decimal Transaction quantity of the item for the lot corresponding to the advanced shipment notice (ASN) line request or receipt line request expires. This attribute is applicable when the warehouse places the item under lot control.
PrimaryQuantity Decimal Transaction quantity for the lot in the primary unit of measure that the item uses. This attribute is applicable when the warehouse places the item under lot control.
SecondaryTransactionQuantity Decimal Transaction quantity for the lot in the secondary unit of measure that the item uses. This attribute is applicable when the warehouse places the item under lot control.
OriginationDate Date Date when the lot originated corresponding to the advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under lot control.
OriginationType String Type of origination for the lot corresponding to the advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under lot control.
HoldDate Date Date when the warehouse applied a hold on the lot corresponding to the advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under lot control.
ReasonId Long Value that uniquely identifies the reason for the receiving transaction. This attribute is applicable when the warehouse places the item under lot control.
ReasonName String Name of the reason for the receiving transaction for the lot. This attribute is applicable when the warehouse places the item under lot control.
MaturityDate Date Date when the lot matures. This attribute is applicable when the warehouse places the item under lot control.
GradeCode String Abbreviation that identifies the grade.
CustomerId Long CustomerId of ReceivingReceiptRequestslineslotItemLots
CustomerPartyName String CustomerPartyName of ReceivingReceiptRequestslineslotItemLots
DocumentNumber String DocumentNumber of ReceivingReceiptRequestslineslotItemLots
ExternalSystemTransactionReference String ExternalSystemTransactionReference of ReceivingReceiptRequestslineslotItemLots
Finder String Finder of ReceivingReceiptRequestslineslotItemLots
FromDate Datetime FromDate of ReceivingReceiptRequestslineslotItemLots
FromOrganizationCode String FromOrganizationCode of ReceivingReceiptRequestslineslotItemLots
FromOrganizationId Long FromOrganizationId of ReceivingReceiptRequestslineslotItemLots
GroupId Long GroupId of ReceivingReceiptRequestslineslotItemLots
HeaderInterfaceId Long HeaderInterfaceId of ReceivingReceiptRequestslineslotItemLots
ItemId Long ItemId of ReceivingReceiptRequestslineslotItemLots
ItemNumber String ItemNumber of ReceivingReceiptRequestslineslotItemLots
OrganizationCode String OrganizationCode of ReceivingReceiptRequestslineslotItemLots
OrganizationId Long OrganizationId of ReceivingReceiptRequestslineslotItemLots
POHeaderId Long POHeaderId of ReceivingReceiptRequestslineslotItemLots
ProcessingStatusCode String ProcessingStatusCode of ReceivingReceiptRequestslineslotItemLots
ReceiptAdviceHeaderId Long ReceiptAdviceHeaderId of ReceivingReceiptRequestslineslotItemLots
RMANumber String RMANumber of ReceivingReceiptRequestslineslotItemLots
ShipmentHeaderId Long ShipmentHeaderId of ReceivingReceiptRequestslineslotItemLots
ShipmentNumber String ShipmentNumber of ReceivingReceiptRequestslineslotItemLots
SourceDocumentCode String SourceDocumentCode of ReceivingReceiptRequestslineslotItemLots
ToDate Datetime ToDate of ReceivingReceiptRequestslineslotItemLots
TransactionStatusCode String TransactionStatusCode of ReceivingReceiptRequestslineslotItemLots
TransactionType String TransactionType of ReceivingReceiptRequestslineslotItemLots
TransferOrderHeaderId Long TransferOrderHeaderId of ReceivingReceiptRequestslineslotItemLots
VendorId Long VendorId of ReceivingReceiptRequestslineslotItemLots
VendorName String VendorName of ReceivingReceiptRequestslineslotItemLots
VendorNumber String VendorNumber of ReceivingReceiptRequestslineslotItemLots

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