Cmdlets for Oracle Fusion Cloud SCM

Build 23.0.8839

ReceivingReceiptRequestslineslotItemLots

ReceivingReceiptRequestslineslotItemLots

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 Double 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 Double 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 Double 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.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
CustomerId Long CustomerId
CustomerPartyName String CustomerPartyName
DocumentNumber String DocumentNumber
ExternalSystemTransactionReference String ExternalSystemTransactionReference
FromDate Datetime FromDate
FromOrganizationCode String FromOrganizationCode
FromOrganizationId Long FromOrganizationId
GroupId Long GroupId
HeaderInterfaceId Long HeaderInterfaceId
ItemId Long ItemId
ItemNumber String ItemNumber
OrganizationCode String OrganizationCode
OrganizationId Long OrganizationId
POHeaderId Long POHeaderId
ProcessingStatusCode String ProcessingStatusCode
RMANumber String RMANumber
ReceiptAdviceHeaderId Long ReceiptAdviceHeaderId
ShipmentHeaderId Long ShipmentHeaderId
ShipmentNumber String ShipmentNumber
SourceDocumentCode String SourceDocumentCode
ToDate Datetime ToDate
TransactionStatusCode String TransactionStatusCode
TransactionType String TransactionType
TransferOrderHeaderId Long TransferOrderHeaderId
VendorId Long VendorId
VendorName String VendorName
VendorNumber String VendorNumber
Finder String finder

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