SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments
SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments
Columns
| Name | Type | Description |
| SupplyRequestsSupplyOrderReferenceNumber [KEY] | String | SupplyRequestsSupplyOrderReferenceNumber of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
| SupplyorderlinesSupplyLineId [KEY] | Long | SupplyorderlinesSupplyLineId of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
| TransfersupplySupplyTrackingLineId [KEY] | Long | TransfersupplySupplyTrackingLineId of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
| SupplyOrderHeaderId | Long | SupplyOrderHeaderId of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
| SupplyLineId | Long | SupplyLineId of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
| SupplyTrackingLineId | Long | SupplyTrackingLineId of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
| SupplyDocumentType | String | SupplyDocumentType of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
| SupplyDocumentNumber | String | SupplyDocumentNumber of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
| SupplyDocumentStatus | String | SupplyDocumentStatus of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
| SupplyDocumentLineNumber | String | SupplyDocumentLineNumber of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
| SupplyDocumentLineQuantity | Double | SupplyDocumentLineQuantity of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
| SupplyDocumentLineQuantityUOM | String | SupplyDocumentLineQuantityUOM of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
| SupplyDocumentHeaderId | String | SupplyDocumentHeaderId of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
| SupplyDocumentLineId | String | SupplyDocumentLineId of SupplyRequestssupplyOrderLinestransferSupplysupplyDocuments |
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 |