Query "Item Ledger Entry Entity CBCAP"
ID 70345243
Namespace: CapVision.CapBusiness.API
Properties
| Name | Value |
|---|---|
| Caption | itemLedgerEntry |
| QueryType | API |
| APIGroup | capbusiness |
| APIPublisher | capvision |
| APIVersion | 'v1.0' |
| EntityName | itemLedgerEntry |
| EntitySetName | itemLedgerEntries |
| DataAccessIntent | ReadOnly |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| entryNo | itemLedgerEntry | Integer | |
| postingDate | itemLedgerEntry | Date | |
| entryType | itemLedgerEntry | Microsoft.Inventory.Ledger."Item Ledger Entry Type" | |
| documentType | itemLedgerEntry | Microsoft.Inventory.Ledger."Item Ledger Document Type" | |
| documentNo | itemLedgerEntry | Code[20] | |
| externalDocumentNo | itemLedgerEntry | Code[35] | |
| documentLineNo | itemLedgerEntry | Integer | |
| itemNo | itemLedgerEntry | Code[20] | |
| variantCode | itemLedgerEntry | Code[10] | |
| description | itemLedgerEntry | Text[100] | |
| sourceNo | itemLedgerEntry | Code[20] | |
| locationCode | itemLedgerEntry | Code[10] | |
| quantity | itemLedgerEntry | Decimal | |
| salesAmountActual | itemLedgerEntry | Decimal | |
| costAmountActual | itemLedgerEntry | Decimal | |
| entryExitPoint | itemLedgerEntry | Code[10] | |
| countryRegionCode | itemLedgerEntry | Code[10] | |
| lotNo | itemLedgerEntry | Code[50] | |
| serialNo | itemLedgerEntry | Code[50] | |
| globalDimension1Code | itemLedgerEntry | Code[20] | |
| globalDimension2Code | itemLedgerEntry | Code[20] | |
| shortcutDimension3Code | itemLedgerEntry | Code[20] | |
| shortcutDimension4Code | itemLedgerEntry | Code[20] | |
| shortcutDimension5Code | itemLedgerEntry | Code[20] | |
| shortcutDimension6Code | itemLedgerEntry | Code[20] | |
| shortcutDimension7Code | itemLedgerEntry | Code[20] | |
| shortcutDimension8Code | itemLedgerEntry | Code[20] |