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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
ChangeLineId | Long | ChangeLineId |
InventoryOrganizationId | Long | InventoryOrganizationId |
ItemId | Long | ItemId |
ItemNumber | String | ItemNumber |
OrganizationCode | String | OrganizationCode |
Finder | String | finder |