LinesToInspect
LinesToInspect
Columns
| Name | Type | Description |
| ToOrganizationCode | String | ToOrganizationCode of LinesToInspect |
| ToOrganizationId | Long | ToOrganizationId of LinesToInspect |
| FromOrganizationName | String | FromOrganizationName of LinesToInspect |
| FromOrganizationCode | String | FromOrganizationCode of LinesToInspect |
| FromOrganizationId | Long | FromOrganizationId of LinesToInspect |
| ItemNumber | String | ItemNumber of LinesToInspect |
| ItemDescription | String | ItemDescription of LinesToInspect |
| ItemId | Long | ItemId of LinesToInspect |
| ItemRevision | String | ItemRevision of LinesToInspect |
| ReceiptNumber | String | ReceiptNumber of LinesToInspect |
| LineStatus | String | LineStatus of LinesToInspect |
| DocumentType | String | DocumentType of LinesToInspect |
| SourceDocumentCode | String | SourceDocumentCode of LinesToInspect |
| DocumentNumber | String | DocumentNumber of LinesToInspect |
| DocumentLineNumber | String | DocumentLineNumber of LinesToInspect |
| DocumentScheduleNumber | String | DocumentScheduleNumber of LinesToInspect |
| TransactionDate | Date | TransactionDate of LinesToInspect |
| VendorName | String | VendorName of LinesToInspect |
| VendorId | Long | VendorId of LinesToInspect |
| VendorSiteCode | String | VendorSiteCode of LinesToInspect |
| VendorSiteId | Long | VendorSiteId of LinesToInspect |
| VendorItemNumber | String | VendorItemNumber of LinesToInspect |
| TOShipmentNumber | String | TOShipmentNumber of LinesToInspect |
| ASNType | String | ASNType of LinesToInspect |
| ASNNumber | String | ASNNumber of LinesToInspect |
| ASNLineNumber | Long | ASNLineNumber of LinesToInspect |
| CustomerPartyName | String | CustomerPartyName of LinesToInspect |
| CustomerId | Long | CustomerId of LinesToInspect |
| AvailableQuantity | Double | AvailableQuantity of LinesToInspect |
| UOMCode | String | UOMCode of LinesToInspect |
| UnitOfMeasure | String | UnitOfMeasure of LinesToInspect |
| SecondaryAvailableQuantity | Double | SecondaryAvailableQuantity of LinesToInspect |
| SecondaryUOMCode | String | SecondaryUOMCode of LinesToInspect |
| SecondaryUnitOfMeasure | String | SecondaryUnitOfMeasure of LinesToInspect |
| DestinationType | String | DestinationType of LinesToInspect |
| DestinationTypeCode | String | DestinationTypeCode of LinesToInspect |
| Location | String | Location of LinesToInspect |
| LocationId | Long | LocationId of LinesToInspect |
| Routing | String | Routing of LinesToInspect |
| RoutingHeaderId | Long | RoutingHeaderId of LinesToInspect |
| POHeaderId | Long | POHeaderId of LinesToInspect |
| POLineLocationId | Long | POLineLocationId of LinesToInspect |
| POLineId | Long | POLineId of LinesToInspect |
| PORevisionNumber | Long | PORevisionNumber of LinesToInspect |
| ShipmentHeaderId | Long | ShipmentHeaderId of LinesToInspect |
| ShipmentLineId | Long | ShipmentLineId of LinesToInspect |
| TransferOrderHeaderId | Long | TransferOrderHeaderId of LinesToInspect |
| TransferOrderLineId | Long | TransferOrderLineId of LinesToInspect |
| TransferOrderDistId | Long | TransferOrderDistId of LinesToInspect |
| ReceiptAdviceHeaderId | Long | ReceiptAdviceHeaderId of LinesToInspect |
| ReceiptAdviceLineId | Long | ReceiptAdviceLineId of LinesToInspect |
| ReceiptSourceCode | String | ReceiptSourceCode of LinesToInspect |
| ConsignedItems | String | ConsignedItems of LinesToInspect |
| BackToBack | String | BackToBack of LinesToInspect |
| CategoryName | String | CategoryName of LinesToInspect |
| CategoryId | Long | CategoryId of LinesToInspect |
| CurrencyCode | String | CurrencyCode of LinesToInspect |
| CurrencyConversionRate | Double | CurrencyConversionRate of LinesToInspect |
| CurrencyConversionDate | Date | CurrencyConversionDate of LinesToInspect |
| CurrencyConversionType | String | CurrencyConversionType of LinesToInspect |
| ParentTransactionType | String | ParentTransactionType of LinesToInspect |
| ParentTransactionId [KEY] | Long | ParentTransactionId of LinesToInspect |
| InspectionStatus | String | InspectionStatus of LinesToInspect |
| InspectionStatusCode | String | InspectionStatusCode of LinesToInspect |
| PrimaryUOMCode | String | PrimaryUOMCode of LinesToInspect |
| Reason | String | Reason of LinesToInspect |
| ReasonId | Long | ReasonId of LinesToInspect |
| ReceiptException | String | ReceiptException of LinesToInspect |
| EmployeeName | String | EmployeeName of LinesToInspect |
| EmployeeId | Long | EmployeeId of LinesToInspect |
| Comments | String | Comments of LinesToInspect |
| Subinventory | String | Subinventory of LinesToInspect |
| Locator | String | Locator of LinesToInspect |
| LocatorId | Long | LocatorId of LinesToInspect |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BindASNLineNumber | Long | bindASNLineNumber |
| BindASNNumber | String | bindASNNumber |
| BindBackToBack | String | bindBackToBack |
| BindConsigned | String | bindConsigned |
| BindDocumentLineNumber | String | bindDocumentLineNumber |
| BindDocumentNumber | String | bindDocumentNumber |
| BindDocumentScheduleNumber | String | bindDocumentScheduleNumber |
| BindDocumentType | String | bindDocumentType |
| BindFromDate | Date | bindFromDate |
| BindItemId | Long | bindItemId |
| BindItemNumber | String | bindItemNumber |
| BindOrganizationCode | String | bindOrganizationCode |
| BindOrganizationId | Long | bindOrganizationId |
| BindPOHeaderId | Long | bindPOHeaderId |
| BindPOLineId | Long | bindPOLineId |
| BindPOLineLocationId | Long | bindPOLineLocationId |
| BindParentTransactionId | Long | bindParentTransactionId |
| BindReceiptAdviceHeaderId | Long | bindReceiptAdviceHeaderId |
| BindReceiptAdviceLineId | Long | bindReceiptAdviceLineId |
| BindReceiptNumber | String | bindReceiptNumber |
| BindShipmentHeaderId | Long | bindShipmentHeaderId |
| BindShipmentLineId | Long | bindShipmentLineId |
| BindSourceDocumentCode | String | bindSourceDocumentCode |
| BindToDate | Date | bindToDate |
| BindTransferOrderHeaderId | Long | bindTransferOrderHeaderId |
| BindTransferOrderLineId | Long | bindTransferOrderLineId |
| Finder | String | finder |