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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。