ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials
Columns
| Name | Type | Description |
| ReceivingReceiptRequestsHeaderInterfaceId [KEY] | Long | ReceivingReceiptRequestsHeaderInterfaceId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials |
| LinesInterfaceTransactionId [KEY] | Long | LinesInterfaceTransactionId of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials |
| LotserialitemlotsLotNumber [KEY] | String | LotserialitemlotsLotNumber of ReceivingReceiptRequestslineslotSerialItemLotslotSerialItemSerials |
| FromSerialNumber [KEY] | String | Starting serial number in a range of serial numbers of 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. |
| ToSerialNumber | String | Ending serial number in a range of serial numbers of 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. |
| VendorSerialNumber | String | Supplier serial number for the serial range of 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. |
| SerialAttributesDFF | String | serialAttributesDFF |
| SerialNumbersDFF | String | serialNumbersDFF |
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 |