SupplyRequestssupplyOrderLines
SupplyRequestssupplyOrderLines
Columns
| Name | Type | Description |
| SupplyRequestsSupplyOrderReferenceNumber [KEY] | String | SupplyRequestsSupplyOrderReferenceNumber of SupplyRequestssupplyOrderLines |
| SupplyLineId [KEY] | Long | SupplyLineId of SupplyRequestssupplyOrderLines |
| SupplyOrderHeaderId | Long | SupplyOrderHeaderId of SupplyRequestssupplyOrderLines |
| SupplyLineNumber | Long | SupplyLineNumber of SupplyRequestssupplyOrderLines |
| SupplyLineStatus | String | SupplyLineStatus of SupplyRequestssupplyOrderLines |
| SupplyType | String | SupplyType of SupplyRequestssupplyOrderLines |
| ItemId | Long | ItemId of SupplyRequestssupplyOrderLines |
| ItemRevision | String | ItemRevision of SupplyRequestssupplyOrderLines |
| SupplyOrderReferenceLineNumber | String | SupplyOrderReferenceLineNumber of SupplyRequestssupplyOrderLines |
| Quantity | Double | Quantity of SupplyRequestssupplyOrderLines |
| UOMCode | String | UOMCode of SupplyRequestssupplyOrderLines |
| SupplyOrderReferenceLineId | Long | SupplyOrderReferenceLineId of SupplyRequestssupplyOrderLines |
| NeedByDate | Datetime | NeedByDate of SupplyRequestssupplyOrderLines |
| PreparerId | Long | PreparerId of SupplyRequestssupplyOrderLines |
| SupplyOrderSource | String | SupplyOrderSource of SupplyRequestssupplyOrderLines |
| DestinationOrganizationId | Long | DestinationOrganizationId of SupplyRequestssupplyOrderLines |
| DestinationOrganizationCode | String | DestinationOrganizationCode of SupplyRequestssupplyOrderLines |
| ItemNumber | String | ItemNumber of SupplyRequestssupplyOrderLines |
| ItemDescription | String | ItemDescription of SupplyRequestssupplyOrderLines |
| UOMName | String | UOMName of SupplyRequestssupplyOrderLines |
| DestinationOrganizationName | String | DestinationOrganizationName of SupplyRequestssupplyOrderLines |
| PreparerName | String | PreparerName of SupplyRequestssupplyOrderLines |
| PreparerEmail | String | PreparerEmail of SupplyRequestssupplyOrderLines |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| SupplyOrderReferenceNumber | String | SupplyOrderReferenceNumber |
| BindDestOrganizationCode | String | bindDestOrganizationCode |
| BindDocumentNumber | String | bindDocumentNumber |
| BindItemNumber | String | bindItemNumber |
| BindNeedByDate | Datetime | bindNeedByDate |
| BindSupplyOrderNumber | String | bindSupplyOrderNumber |
| BindSupplyOrderReferenceNumber | String | bindSupplyOrderReferenceNumber |
| BindSupplyOrderSource | String | bindSupplyOrderSource |
| BindSupplyRequestDate | Datetime | bindSupplyRequestDate |
| BindSupplyStatus | String | bindSupplyStatus |
| BindSupplyType | String | bindSupplyType |
| Finder | String | finder |