LinesToReceive
LinesToReceive
Columns
| Name | Type | Description |
| ToOrganizationCode | String | ToOrganizationCode of LinesToReceive |
| ToOrganizationId | Long | ToOrganizationId of LinesToReceive |
| FromOrganizationName | String | FromOrganizationName of LinesToReceive |
| FromOrganizationCode | String | FromOrganizationCode of LinesToReceive |
| FromOrganizationId | Long | FromOrganizationId of LinesToReceive |
| ItemNumber | String | ItemNumber of LinesToReceive |
| ItemDescription | String | ItemDescription of LinesToReceive |
| ItemId | Long | ItemId of LinesToReceive |
| ItemRevision | String | ItemRevision of LinesToReceive |
| DocumentType | String | DocumentType of LinesToReceive |
| SourceDocumentCode [KEY] | String | SourceDocumentCode of LinesToReceive |
| DocumentNumber | String | DocumentNumber of LinesToReceive |
| DocumentLineNumber | String | DocumentLineNumber of LinesToReceive |
| DocumentScheduleNumber | String | DocumentScheduleNumber of LinesToReceive |
| DocumentDistributionNumber | Long | DocumentDistributionNumber of LinesToReceive |
| SoldtoLegalEntity | String | SoldtoLegalEntity of LinesToReceive |
| SourceSystem | String | SourceSystem of LinesToReceive |
| DocumentLineId [KEY] | Long | DocumentLineId of LinesToReceive |
| DueDate | Date | DueDate of LinesToReceive |
| VendorName | String | VendorName of LinesToReceive |
| VendorSiteCode | String | VendorSiteCode of LinesToReceive |
| VendorId | Long | VendorId of LinesToReceive |
| VendorSiteId | Long | VendorSiteId of LinesToReceive |
| VendorItemNumber | String | VendorItemNumber of LinesToReceive |
| TOShipmentNumber | String | TOShipmentNumber of LinesToReceive |
| ASNNumber | String | ASNNumber of LinesToReceive |
| ASNLineNumber | Long | ASNLineNumber of LinesToReceive |
| CustomerPartyName | String | CustomerPartyName of LinesToReceive |
| CustomerId | Long | CustomerId of LinesToReceive |
| AvailableQuantity | Double | AvailableQuantity of LinesToReceive |
| UOMCode | String | UOMCode of LinesToReceive |
| UnitOfMeasure | String | UnitOfMeasure of LinesToReceive |
| SecondaryAvailableQuantity | Double | SecondaryAvailableQuantity of LinesToReceive |
| SecondaryUOMCode | String | SecondaryUOMCode of LinesToReceive |
| SecondaryUnitOfMeasure | String | SecondaryUnitOfMeasure of LinesToReceive |
| DestinationType | String | DestinationType of LinesToReceive |
| DestinationTypeCode | String | DestinationTypeCode of LinesToReceive |
| ShipToLocation | String | ShipToLocation of LinesToReceive |
| ShipToLocationId | Long | ShipToLocationId of LinesToReceive |
| Routing | String | Routing of LinesToReceive |
| RoutingHeaderId | Long | RoutingHeaderId of LinesToReceive |
| OrderedQuantity | Double | OrderedQuantity of LinesToReceive |
| OrderedUnitOfMeasure | String | OrderedUnitOfMeasure of LinesToReceive |
| POHeaderId | Long | POHeaderId of LinesToReceive |
| POLineLocationId | Long | POLineLocationId of LinesToReceive |
| POLineId | Long | POLineId of LinesToReceive |
| PODistributionId | Long | PODistributionId of LinesToReceive |
| PORevisionNumber | Long | PORevisionNumber of LinesToReceive |
| ShipmentHeaderId | Long | ShipmentHeaderId of LinesToReceive |
| ShipmentLineId | Long | ShipmentLineId of LinesToReceive |
| TransferOrderHeaderId | Long | TransferOrderHeaderId of LinesToReceive |
| TransferOrderLineId | Long | TransferOrderLineId of LinesToReceive |
| TransferOrderDistId | Long | TransferOrderDistId of LinesToReceive |
| ReceiptAdviceHeaderId | Long | ReceiptAdviceHeaderId of LinesToReceive |
| ReceiptAdviceLineId | Long | ReceiptAdviceLineId of LinesToReceive |
| ReceiptSourceCode | String | ReceiptSourceCode of LinesToReceive |
| ConsignedItems | String | ConsignedItems of LinesToReceive |
| BackToBack | String | BackToBack of LinesToReceive |
| CategoryName | String | CategoryName of LinesToReceive |
| CategoryId | Long | CategoryId of LinesToReceive |
| CurrencyCode | String | CurrencyCode of LinesToReceive |
| CurrencyConversionRate | Double | CurrencyConversionRate of LinesToReceive |
| CurrencyConversionDate | Date | CurrencyConversionDate of LinesToReceive |
| CurrencyConversionType | String | CurrencyConversionType of LinesToReceive |
| InventoryTransactionTypeId | Long | InventoryTransactionTypeId of LinesToReceive |
| POUnitPrice | Double | POUnitPrice of LinesToReceive |
| MatchOption | String | MatchOption of LinesToReceive |
| HeaderNoteToReceiver | String | HeaderNoteToReceiver of LinesToReceive |
| ScheduleNoteToReceiver | String | ScheduleNoteToReceiver of LinesToReceive |
| IntegrationStatus | String | IntegrationStatus of LinesToReceive |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BindASNLineNumber | Long | bindASNLineNumber |
| BindASNNumber | String | bindASNNumber |
| BindBackToBack | String | bindBackToBack |
| BindConsigned | String | bindConsigned |
| BindDocumentDistributionNumber | Long | bindDocumentDistributionNumber |
| 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 |
| BindPODistributionId | Long | bindPODistributionId |
| BindPOLineId | Long | bindPOLineId |
| BindPOLineLocationId | Long | bindPOLineLocationId |
| BindReceiptAdviceHeaderId | Long | bindReceiptAdviceHeaderId |
| BindReceiptAdviceLineId | Long | bindReceiptAdviceLineId |
| BindShipmentHeaderId | Long | bindShipmentHeaderId |
| BindShipmentLineId | Long | bindShipmentLineId |
| BindSourceDocumentCode | String | bindSourceDocumentCode |
| BindToDate | Date | bindToDate |
| BindTransferOrderDistId | Long | bindTransferOrderDistId |
| BindTransferOrderHeaderId | Long | bindTransferOrderHeaderId |
| BindTransferOrderLineId | Long | bindTransferOrderLineId |
| Finder | String | finder |