Query "Value Entry Entity CBCAP"
ID 70345245
Namespace: CapVision.CapBusiness.API
Properties
| Name | Value |
|---|---|
| Caption | valueEntry |
| QueryType | API |
| APIGroup | capbusiness |
| APIPublisher | capvision |
| APIVersion | 'v1.0' |
| EntityName | valueEntry |
| EntitySetName | valueEntries |
| DataAccessIntent | ReadOnly |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| entryNo | valueEntry | Integer | |
| itemNo | valueEntry | Code[20] | |
| itemLedgerEntryNo | valueEntry | Integer | |
| itemLedgerEntryType | valueEntry | Microsoft.Inventory.Ledger."Item Ledger Entry Type" | |
| itemLedgerEntryQuantity | valueEntry | Decimal | |
| postingDate | valueEntry | Date | |
| valuationDate | valueEntry | Date | |
| documentDate | valueEntry | Date | |
| documentType | valueEntry | Microsoft.Inventory.Ledger."Item Ledger Document Type" | |
| documentNo | valueEntry | Code[20] | |
| genBusPostingGroup | valueEntry | Code[20] | |
| genProdPostingGroup | valueEntry | Code[20] | |
| locationCode | valueEntry | Code[10] | |
| sourceCode | valueEntry | Code[10] | |
| reasonCode | valueEntry | Code[10] | |
| valuedQuantity | valueEntry | Decimal | |
| invoicedQuantity | valueEntry | Decimal | |
| costPerUnit | valueEntry | Decimal | |
| costPostedToGL | valueEntry | Decimal | |
| expectedCost | valueEntry | Boolean | |
| costAmountActual | valueEntry | Decimal | |
| costAmountExpected | valueEntry | Decimal | |
| salesAmountActual | valueEntry | Decimal | |
| salesAmountExpected | valueEntry | Decimal | |
| purchaseAmountActual | valueEntry | Decimal | |
| purchaseAmountExpected | valueEntry | Decimal | |
| dimensionSetID | valueEntry | Integer | |
| salespersonPurchaserCode | valueEntry | Code[20] | |
| itemDescription | item | Text[100] |