ItemCosts
ItemCosts
Columns
| Name | Type | Description |
| CostOrganizationId [KEY] | Long | CostOrganizationId of ItemCosts |
| CostOrganizationName | String | CostOrganizationName of ItemCosts |
| CostOrganizationCode | String | CostOrganizationCode of ItemCosts |
| CostBookId [KEY] | Long | CostBookId of ItemCosts |
| CostBook | String | CostBook of ItemCosts |
| CostProfile | String | CostProfile of ItemCosts |
| CostProfileId | Long | CostProfileId of ItemCosts |
| ItemCategory | String | ItemCategory of ItemCosts |
| ItemCategoryId | Double | ItemCategoryId of ItemCosts |
| ItemId [KEY] | Long | ItemId of ItemCosts |
| ItemNumber | String | ItemNumber of ItemCosts |
| ItemDescription | String | ItemDescription of ItemCosts |
| CostMethodCode | String | CostMethodCode of ItemCosts |
| ValuationStructureId | Long | ValuationStructureId of ItemCosts |
| ValuationStructureCode | String | ValuationStructureCode of ItemCosts |
| ValuationUnitId [KEY] | Long | ValuationUnitId of ItemCosts |
| ValuationUnit | String | ValuationUnit of ItemCosts |
| ReceiptNumber | String | ReceiptNumber of ItemCosts |
| TransactionId [KEY] | Long | TransactionId of ItemCosts |
| CurrencyCode | String | CurrencyCode of ItemCosts |
| UOMName | String | UOMName of ItemCosts |
| UOMCode | String | UOMCode of ItemCosts |
| TotalUnitCost | Double | TotalUnitCost of ItemCosts |
| CostChange | Double | CostChange of ItemCosts |
| CostAsOfDate | Datetime | CostAsOfDate of ItemCosts |
| EffectiveStartDate | Date | EffectiveStartDate of ItemCosts |
| EffectiveEndDate | Date | EffectiveEndDate of ItemCosts |
| QuantityOnhand | Double | QuantityOnhand of ItemCosts |
| CostMethod [KEY] | String | CostMethod of ItemCosts |
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 |
| BindCategoryName | String | bindCategoryName |
| BindCostBook | String | bindCostBook |
| BindCostDate | Datetime | bindCostDate |
| BindCostMethod | String | bindCostMethod |
| BindCostOrg | String | bindCostOrg |
| BindCostProfile | String | bindCostProfile |
| BindEffectiveEndDate | Date | bindEffectiveEndDate |
| BindEffectiveStartDate | Date | bindEffectiveStartDate |
| BindItem | String | bindItem |
| BindItemDescription | String | bindItemDescription |
| BindItemId | Long | bindItemId |
| BindReceiptNumber | String | bindReceiptNumber |
| BindTotalUnitCost | String | bindTotalUnitCost |
| BindValStructureCode | String | bindValStructureCode |
| BindValuationUnit | String | bindValuationUnit |
| Finder | String | finder |