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