CostAdjustments
CostAdjustments
Columns
| Name | Type | Description |
| AdjustmentHeaderId [KEY] | Long | AdjustmentHeaderId of CostAdjustments |
| AdjustmentNumber | String | AdjustmentNumber of CostAdjustments |
| AdjustmentTypeCode | String | Abbreviation that identifies the adjustment type. Values include P-Perpetual, R-Receipt, or L-Layer. |
| AdjustmentDate | Datetime | Date when the cost adjustment was made. |
| AdjustmentStatusCode | String | Abbreviation that identifies the adjustment status. Values include P-Pending, S-Submitted, or C-Voided. |
| ReasonCode | String | Abbreviation that identifies the reason for the cost adjustment transaction. |
| TransactionId | Long | Value that uniquely identifies the transaction in costing. |
| CostOrganizationId | Long | Value that uniquely identifies the cost organization. |
| CostBookId | Long | Value that uniquely identifies the cost book. |
| ItemId | Long | Value that uniquely identifies the item. |
| InventoryOrganizationId | Long | Value that uniquely identifies the inventory organization. |
| ReceiptQuantity | Double | Quantity of the item received. |
| QuantityOnhand | Double | Remaining quantity of the item. |
| TotalUnitCost | Double | Total cost of the received item. |
| TotalNewCost | Double | Total new cost of the received item. |
| ValuationUnitId | Long | Value that uniquely identifies the valuation unit. |
| CostDate | Datetime | Date of the costing transaction for the adjustment. |
| ReceiptNumber | String | Number that identifies the receipt of the transaction for the adjustment. |
| CurrencyCode | String | Abbreviation that identifies the currency. |
| CostOrganizationName | String | Name of the cost organization for the adjustment. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Cost Organizations task. |
| CostBook | String | Name of the cost book for the adjustment. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Cost Books task. |
| InventoryOrganizationName | String | Name of the inventory organization for the adjustment. |
| Item | String | Name of the inventory item for the adjustment. |
| ValuationUnit | String | Valuation unit for the adjustment. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Valuation Units task. |
| AdjustmentType | String | Type of adjustment. Values include Perpetual, Receipt, or Layer. |
| AdjustmentStatus | String | Status of the adjustment. Values include Pending, Submitted, or Voided. |
| Reason | String | Reason for the cost adjustment transaction. |
| UOMCode | String | Abbreviation that identifies the unit of measure. |
| UOMName | String | Name of the unit of measure. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BindAdjustmentDate | Datetime | bindAdjustmentDate |
| BindAdjustmentNumber | String | bindAdjustmentNumber |
| BindAdjustmentStatus | String | bindAdjustmentStatus |
| BindAdjustmentType | String | bindAdjustmentType |
| BindCostBook | String | bindCostBook |
| BindCostOrgName | String | bindCostOrgName |
| BindItem | String | bindItem |
| BindReason | String | bindReason |
| BindReceiptNumber | String | bindReceiptNumber |
| BindValuationUnit | String | bindValuationUnit |
| Finder | String | finder |