ItemsV2ItemSupplierAssociationItemSupplierEffCategory
ItemsV2ItemSupplierAssociationItemSupplierEffCategory
Columns
| Name | Type | Description |
| ItemsV2ItemId [KEY] | Long | ItemsV2ItemId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| ItemsV2OrganizationId [KEY] | Long | ItemsV2OrganizationId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| ItemsupplierassociationAcdType [KEY] | String | ItemsupplierassociationAcdType of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| ItemsupplierassociationChangeLineId [KEY] | Int | ItemsupplierassociationChangeLineId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| ItemsupplierassociationInventoryItemId [KEY] | Long | ItemsupplierassociationInventoryItemId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| ItemsupplierassociationItemId [KEY] | Long | ItemsupplierassociationItemId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| ItemsupplierassociationOrganizationId [KEY] | Long | ItemsupplierassociationOrganizationId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| ItemsupplierassociationOrganizationId1 [KEY] | Long | ItemsupplierassociationOrganizationId1 of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| ItemsupplierassociationSupplierId [KEY] | Long | ItemsupplierassociationSupplierId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| ItemsupplierassociationSupplierSiteId [KEY] | Long | ItemsupplierassociationSupplierSiteId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| ItemsupplierassociationVersionId [KEY] | Long | ItemsupplierassociationVersionId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| AcdType [KEY] | String | AcdType of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| AssociationId | Long | AssociationId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| OrganizationId [KEY] | Long | OrganizationId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| VersionId [KEY] | Long | VersionId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| MasterOrganizationId | Long | MasterOrganizationId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| SupplierId [KEY] | Long | SupplierId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| SupplierSiteId [KEY] | Long | SupplierSiteId of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
| CategoryCode | String | CategoryCode of ItemsV2ItemSupplierAssociationItemSupplierEffCategory |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ChangeLineId | Long | ChangeLineId |
| InventoryOrganizationId | Long | InventoryOrganizationId |
| ItemId | Long | ItemId |
| ItemNumber | String | ItemNumber |
| OrganizationCode | String | OrganizationCode |
| Finder | String | finder |