ActiveSubinventories
ActiveSubinventories
Columns
| Name | Type | Description |
| SubinventoryId | Long | SubinventoryId of ActiveSubinventories |
| SecondaryInventoryName [KEY] | String | SecondaryInventoryName of ActiveSubinventories |
| OrganizationId [KEY] | Long | OrganizationId of ActiveSubinventories |
| OrganizationCode | String | OrganizationCode of ActiveSubinventories |
| OrganizationName | String | OrganizationName of ActiveSubinventories |
| Description | String | Description of ActiveSubinventories |
| DisableDate | Date | DisableDate of ActiveSubinventories |
| InventoryATPCode | Int | InventoryATPCode of ActiveSubinventories |
| IncludeInATP | String | IncludeInATP of ActiveSubinventories |
| NettableCode | Int | NettableCode of ActiveSubinventories |
| Nettable | String | Nettable of ActiveSubinventories |
| ReservableType | Int | ReservableType of ActiveSubinventories |
| AllowReservations | String | AllowReservations of ActiveSubinventories |
| LocatorTypeCode | String | LocatorTypeCode of ActiveSubinventories |
| LocatorType | String | LocatorType of ActiveSubinventories |
| PickingOrder | Int | PickingOrder of ActiveSubinventories |
| QuantityTrackedCode | Int | QuantityTrackedCode of ActiveSubinventories |
| QuantityTracked | String | QuantityTracked of ActiveSubinventories |
| AssetInventoryCode | Int | AssetInventoryCode of ActiveSubinventories |
| AssetInventory | String | AssetInventory of ActiveSubinventories |
| SourceTypeCode | String | SourceTypeCode of ActiveSubinventories |
| SourceType | String | SourceType of ActiveSubinventories |
| SourceSubinventory | String | SourceSubinventory of ActiveSubinventories |
| SourceOrganizationId | Long | SourceOrganizationId of ActiveSubinventories |
| SourceOrganizationCode | String | SourceOrganizationCode of ActiveSubinventories |
| SourceOrganizationName | String | SourceOrganizationName of ActiveSubinventories |
| PreprocessingLeadTime | Int | PreprocessingLeadTime of ActiveSubinventories |
| ProcessingLeadTime | Int | ProcessingLeadTime of ActiveSubinventories |
| PostprocessingLeadTime | Int | PostprocessingLeadTime of ActiveSubinventories |
| LocationId | Long | LocationId of ActiveSubinventories |
| LocationName | String | LocationName of ActiveSubinventories |
| DepreciableCode | Int | DepreciableCode of ActiveSubinventories |
| Depreciable | String | Depreciable of ActiveSubinventories |
| StatusId | Long | StatusId of ActiveSubinventories |
| StatusCode | String | StatusCode of ActiveSubinventories |
| SubinventoryTypeCode | String | SubinventoryTypeCode of ActiveSubinventories |
| SubinventoryType | String | SubinventoryType of ActiveSubinventories |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BindItemId | Long | bindItemId |
| BindTransactionTypeId | Long | bindTransactionTypeId |
| Finder | String | finder |