Sales Cr.Memo Line

    API Details

    Property Value
    Endpoint /tablesFinance/salesCrMemoLines
    Table name Sales Cr.Memo Line
    Table id 115
    Table caption Sales Cr.Memo Line
    Data per company True
    Group Finance

    Schema

    erd

    Properties

    Property Table Fieldname Type Max.Length Key Options Table relation Version introduced Version removed Obsolete state Obsolete reason
    id System Id GUID 16
    selltoCustomerNo Sell-to Customer No. Code 20 Customer
    documentNo Document No. Code 20 * Sales Cr.Memo Header
    lineNo Line No. Integer 4 *
    type Type Option 4 , G/L Account, Item, Resource, Fixed Asset, Charge (Item), Allocation Account, Element
    no No. Code 20
    locationCode Location Code Code 10
    postingGroup Posting Group Code 20
    shipmentDate Shipment Date Date 4
    description Description Text 100
    description2 Description 2 Text 50
    unitOfMeasure Unit of Measure Text 50
    quantity Quantity Decimal 12
    unitPrice Unit Price Decimal 12
    unitCostLCY Unit Cost (LCY) Decimal 12
    vatPct VAT % Decimal 12
    lineDiscountPct Line Discount % Decimal 12
    lineDiscountAmount Line Discount Amount Decimal 12
    amount Amount Decimal 12
    amountIncludingVAT Amount Including VAT Decimal 12
    allowInvoiceDisc Allow Invoice Disc. Boolean 4
    grossWeight Gross Weight Decimal 12
    netWeight Net Weight Decimal 12
    unitsPerParcel Units per Parcel Decimal 12
    unitVolume Unit Volume Decimal 12
    appltoItemEntry Appl.-to Item Entry Integer 4
    shortcutDimension1Code Shortcut Dimension 1 Code Code 20
    shortcutDimension2Code Shortcut Dimension 2 Code Code 20
    customerPriceGroup Customer Price Group Code 10 Customer Price Group
    jobNo Maint. Order No./ Maint. Task No. Code 20 Job
    workTypeCode Work Type Code Code 10 Work Type
    orderNo Order No. Code 20
    orderLineNo Order Line No. Integer 4
    billtoCustomerNo Bill-to Customer No. Code 20 Customer
    invDiscountAmount Inv. Discount Amount Decimal 12
    genBusPostingGroup Gen. Bus. Posting Group Code 20 Gen. Business Posting Group
    genProdPostingGroup Gen. Prod. Posting Group Code 20 Gen. Product Posting Group
    vatCalculationType VAT Calculation Type Option 4 Normal VAT, Reverse Charge VAT, Full VAT, Sales Tax
    transactionType Transaction Type Code 10 Transaction Type
    transportMethod Transport Method Code 10 Transport Method
    attachedToLineNo Attached to Line No. Integer 4
    exitPoint Exit Point Code 10 Entry/Exit Point
    area Area Code 10 Area
    transactionSpecification Transaction Specification Code 10 Transaction Specification
    taxCategory Tax Category Code 10
    taxAreaCode Tax Area Code Code 20 Tax Area
    taxLiable Tax Liable Boolean 4
    taxGroupCode Tax Group Code Code 20 Tax Group
    vatClauseCode VAT Clause Code Code 20 VAT Clause
    vatBusPostingGroup VAT Bus. Posting Group Code 20 VAT Business Posting Group
    vatProdPostingGroup VAT Prod. Posting Group Code 20 VAT Product Posting Group
    blanketOrderNo Blanket Order No. Code 20
    blanketOrderLineNo Blanket Order Line No. Integer 4
    vatBaseAmount VAT Base Amount Decimal 12
    unitCost Unit Cost Decimal 12
    systemCreatedEntry System-Created Entry Boolean 4
    lineAmount Line Amount Decimal 12
    vatDifference VAT Difference Decimal 12
    vatIdentifier VAT Identifier Code 20
    icPartnerRefType IC Partner Ref. Type Option 4 , G/L Account, Item, Charge (Item), Cross Reference, Common Item No., Vendor Item No.
    icPartnerReference IC Partner Reference Code 20
    prepaymentLine Prepayment Line Boolean 4
    icPartnerCode IC Partner Code Code 20 IC Partner
    postingDate Posting Date Date 4
    icItemReferenceNo IC Item Reference No. Code 50
    pmtDiscountAmount Pmt. Discount Amount Decimal 12
    lineDiscountCalculation Line Discount Calculation Option 4 None, %, Amount
    dimensionSetID Dimension Set ID Integer 4 Dimension Set Entry
    jobTaskNo Job Task No. Code 20
    jobContractEntryNo Job Contract Entry No. Integer 4
    deferralCode Deferral Code Code 10 Deferral Template
    variantCode Variant Code Code 10
    binCode Bin Code Code 20
    qtyPerUnitOfMeasure Qty. per Unit of Measure Decimal 12
    unitOfMeasureCode Unit of Measure Code Code 10
    quantityBase Quantity (Base) Decimal 12
    faPostingDate FA Posting Date Date 4
    depreciationBookCode Depreciation Book Code Code 10 Depreciation Book
    deprUntilFAPostingDate Depr. until FA Posting Date Boolean 4
    duplicateInDepreciationBook Duplicate in Depreciation Book Code 10 Depreciation Book
    useDuplicationList Use Duplication List Boolean 4
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    itemCategoryCode Item Category Code Code 20
    nonstock Catalog Boolean 4
    purchasingCode Purchasing Code Code 10 Purchasing
    itemReferenceNo Item Reference No. Code 50
    itemReferenceUnitOfMeasure Unit of Measure (Item Ref.) Code 10
    itemReferenceType Item Reference Type Option 4 , Customer, Vendor, Bar Code
    itemReferenceTypeNo Item Reference Type No. Code 30
    applfromItemEntry Appl.-from Item Entry Integer 4
    returnReceiptNo Return Receipt No. Code 20
    returnReceiptLineNo Return Receipt Line No. Integer 4
    returnReasonCode Return Reason Code Code 10 Return Reason
    priceCalculationMethod Price Calculation Method Option 4 , Lowest Price, Test Price, Test Price (not Implemented)
    allowLineDisc Allow Line Disc. Boolean 4
    customerDiscGroup Customer Disc. Group Code 20 Customer Discount Group
    eenheidnr Object No. Code 20 OGE
    contractvolgnr Contract Line No. Integer 4
    samentelling Addition Text 30
    totaalsoort Total Type Option 4 Element, Titel, Totaal, Begintotaal, Eindtotaal
    periodefactor Period Factor Decimal 12
    elementsoort Element Type Option 4 , Service, Verbruik, Water, Kale huur, Waarborgsom, Huurmatiging, Parkeerplaats buiten, Parkeerplaats binnen, Huurkorting, BTW-compensatie, BTW
    settleWith Settle with Option 4 Owner, PropertyManager
    prolongatierunnr Prolongation Run No. Integer 4
    settleBasedOn Settle Based on Option 4 CollectedExclPrePayments, CollectedInclPrePayments, DueAmount
    commissionOn Commission on Option 4 CollectedInclVAT, DueAmountInclVAT, CollectedExclVAT, DueAmountExclVAT, None
    clusternr Cluster No. Code 20 Cluster
    afdrukken Print Boolean 4
    totaleKosten Cluster Total Cost Decimal 12
    aandeel Share (Incl. VAT) Decimal 12
    voorschot Advance (Incl. VAT) Decimal 12
    sVbatch S&C Batch Code 10
    totaalVoorschot Total Advance Decimal 12
    shareExclVAT Share (Excl. VAT) Decimal 12
    advanceExclVAT Advance (Excl. VAT) Decimal 12
    btWcorrectie VAT Correction Boolean 4
    svAfrekeningnr S&C Account Statement No. Code 20
    livDossierNo Livability Dossier No. Code 20 Livability Dossier
    empireProjectnr Project No. (Emp.) Code 20 Empire Project
    empireProjecttype Project Type Code 20 Empire Projecttype
    empireWerksoort Work Type (Emp.) Code 20 Empire Werksoort
    empireBudgetregelnr Budget Line No. Integer 4
    empireBudgetdetailregelnr Budget Detail Line No. Integer 4
    empireWerksoortboekingsgr Job Type Posting Group Code 10 Werksoortboekingsgroep
    vergoeding Fee Boolean 4
    projectfase Project Phase Code 10
    bouwnr Construction No. Code 10
    soortTermijn Soort termijn Option 4 , Bouw, Meerwerk
    termijnnr Term No. Integer 4
    projectkosten Project Cost Boolean 4
    transitoAllocationCode Transito Allocation Code Code 10 Transito Allocation
    maintenanceRequestNo Maintenance Request No. Code 20 Maintenance Request
    maintenanceTaskNo Maintenance Task No. Code 20 DM - Maintenance Task
    maintenanceOrderNo Maintenance Order No. Code 30 DM - Maintenance Order
    distributionKeyID Distribution Key ID Integer 4
    distributionReferenceDate Distribution Reference Date Date 4
    systemId System ID GUID 16
    systemCreatedAt Created At DateTime 8
    systemCreatedBy Created By GUID 16 User
    systemModifiedAt Modified At DateTime 8
    systemModifiedBy Modified By GUID 16 User
    lastModifiedDateTime Last Modified Date Time DateTime 8