ReceivingReceiptRequestslineslotSerialItemLots
ReceivingReceiptRequestslineslotSerialItemLots
Columns
| Name | Type | Description |
| ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | ReceivingReceiptRequestsHeaderInterfaceId of ReceivingReceiptRequestslineslotSerialItemLots |
| LinesInterfaceTransactionId [KEY] | Long | LinesInterfaceTransactionId of ReceivingReceiptRequestslineslotSerialItemLots |
| LotNumber [KEY] | String | Number that identifies the lot for the item 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 and serial control. |
| LotExpirationDate | Date | Date when the item of this 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 and serial 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 and serial 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 and serial control. |
| TransactionQuantity | Double | Transaction quantity 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 and serial control. |
| PrimaryQuantity | Double | Transaction quantity for this lot in the primary unit of measure that the item uses. This attribute is applicable when the warehouse places the item under lot and serial control. |
| SecondaryTransactionQuantity | Double | Transaction quantity for this lot in the secondary unit of measure that the item uses. This attribute is applicable when the warehouse places the item under lot and serial control. |
| OriginationDate | Date | Date when this lot originated for the advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under lot and serial 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 and serial 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 and serial control. |
| ReasonId | Long | Value that uniquely identifies the reason for the receiving transaction for the lot. This attribute is applicable when the warehouse places the item under lot and serial 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 and serial control. |
| MaturityDate | Date | Date when the lot matures for the advanced shipment notice (ASN) line request or receipt line request. This attribute is applicable when the warehouse places the item under lot and serial control. |
| GradeCode | String | Abbreviation that identifies the grade. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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 |