ItemCostscostDetails
ItemCostscostDetails
Columns
| Name | Type | Description |
| ItemCostsCostBookId [KEY] | Long | ItemCostsCostBookId of ItemCostscostDetails |
| ItemCostsCostMethod [KEY] | String | ItemCostsCostMethod of ItemCostscostDetails |
| ItemCostsCostOrganizationId [KEY] | Long | ItemCostsCostOrganizationId of ItemCostscostDetails |
| ItemCostsItemId [KEY] | Long | ItemCostsItemId of ItemCostscostDetails |
| ItemCostsTransactionId [KEY] | Long | ItemCostsTransactionId of ItemCostscostDetails |
| ItemCostsValuationUnitId [KEY] | Long | ItemCostsValuationUnitId of ItemCostscostDetails |
| CostElementId [KEY] | Long | CostElementId of ItemCostscostDetails |
| CostElement | String | CostElement of ItemCostscostDetails |
| CostElementType | String | CostElementType of ItemCostscostDetails |
| UnitCostAverage | Double | UnitCostAverage of ItemCostscostDetails |
| CurrencyCode | String | CurrencyCode of ItemCostscostDetails |
| CostPercent | Double | CostPercent of ItemCostscostDetails |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CostBookId | Long | CostBookId |
| CostMethod | String | CostMethod |
| CostOrganizationId | Long | CostOrganizationId |
| ItemId | Long | ItemId |
| TransactionId | Long | TransactionId |
| ValuationUnitId | Long | ValuationUnitId |
| 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 |