ReceiptCosts

Columns


Name	Type	Description
TransactionId [KEY]	Long	TransactionId of ReceiptCosts
CostOrganizationId	Long	CostOrganizationId of ReceiptCosts
CostOrganizationName	String	CostOrganizationName of ReceiptCosts
CostBookId	Long	CostBookId of ReceiptCosts
CostBook	String	CostBook of ReceiptCosts
InventoryOrganizationId	Long	InventoryOrganizationId of ReceiptCosts
InventoryOrganizationName	String	InventoryOrganizationName of ReceiptCosts
ItemId	Long	ItemId of ReceiptCosts
Item	String	Item of ReceiptCosts
TransactionTypeName	String	TransactionTypeName of ReceiptCosts
ValuationUnitId	Long	ValuationUnitId of ReceiptCosts
ValuationUnit	String	ValuationUnit of ReceiptCosts
CostProfileId	Long	CostProfileId of ReceiptCosts
CostProfile	String	CostProfile of ReceiptCosts
CostDate	Datetime	CostDate of ReceiptCosts
CostEffectiveDate	Datetime	CostEffectiveDate of ReceiptCosts
ReceiptNumber	String	ReceiptNumber of ReceiptCosts
ReferenceNumber	String	ReferenceNumber of ReceiptCosts
ReceiptQuantity	Double	ReceiptQuantity of ReceiptCosts
QuantityOnhand	Double	QuantityOnhand of ReceiptCosts
TotalUnitCost	Double	TotalUnitCost of ReceiptCosts
CurrencyCode	String	CurrencyCode of ReceiptCosts
UOMName	String	UOMName of ReceiptCosts
UOMCode	String	UOMCode of ReceiptCosts

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