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