ReceiptCosts
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 |
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 |
| BindCostBook | String | bindCostBook |
| BindCostOrgName | String | bindCostOrgName |
| BindCostProfile | String | bindCostProfile |
| BindItem | String | bindItem |
| BindItemId | Long | bindItemId |
| BindReceiptNumber | String | bindReceiptNumber |
| BindReferenceNumber | String | bindReferenceNumber |
| BindTxnTypeName | String | bindTxnTypeName |
| BindValuationUnit | String | bindValuationUnit |
| Finder | String | finder |