Sales Header

    API Details

    Property Value
    Endpoint /tablesFinance/salesHeaders
    Table name Sales Header
    Table id 36
    Table caption Sales Header
    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
    documentType Document Type Option 4 * Quote, Order, Invoice, Credit Memo, Blanket Order, Return Order
    selltoCustomerNo Sell-to Customer No. Code 20 Customer
    no No. Code 20 *
    billtoCustomerNo Bill-to Customer No. Code 20 Customer
    billtoName Bill-to Name Text 100 Customer
    billtoName2 Bill-to Name 2 Text 50
    billtoAddress Bill-to Address Text 100
    billtoAddress2 Bill-to Address 2 Text 50
    billtoCity Bill-to City Text 30
    billtoContact Bill-to Contact Text 100
    yourReference Your Reference Text 35
    shiptoCode Ship-to Code Code 10
    shiptoName Ship-to Name Text 100
    shiptoName2 Ship-to Name 2 Text 50
    shiptoAddress Ship-to Address Text 100
    shiptoAddress2 Ship-to Address 2 Text 50
    shiptoCity Ship-to City Text 30
    shiptoContact Ship-to Contact Text 100
    orderDate Order Date Date 4
    postingDate Posting Date Date 4
    shipmentDate Shipment Date Date 4
    postingDescription Posting Description Text 100
    paymentTermsCode Payment Terms Code Code 10 Payment Terms
    dueDate Due Date Date 4
    paymentDiscountPct Payment Discount % Decimal 12
    pmtDiscountDate Pmt. Discount Date Date 4
    shipmentMethodCode Shipment Method Code Code 10 Shipment Method
    locationCode Location Code Code 10
    shortcutDimension1Code Shortcut Dimension 1 Code Code 20
    shortcutDimension2Code Shortcut Dimension 2 Code Code 20
    customerPostingGroup Customer Posting Group Code 20 Customer Posting Group
    currencyCode Currency Code Code 10 Currency
    currencyFactor Currency Factor Decimal 12
    customerPriceGroup Customer Price Group Code 10 Customer Price Group
    pricesIncludingVAT Prices Including VAT Boolean 4
    invoiceDiscCode Invoice Disc. Code Code 20
    customerDiscGroup Customer Disc. Group Code 20 Customer Discount Group
    languageCode Language Code Code 10 Language
    formatRegion Format Region Text 80 Language Selection
    salespersonCode Salesperson Code Code 20
    orderClass Order Class Code 10
    noPrinted No. Printed Integer 4
    onHold On Hold Code 3 On Hold Code
    appliestoDocType Applies-to Doc. Type Option 4 , Payment, Invoice, Credit Memo, Finance Charge Memo, Reminder, Refund, Storno, Arrangement, Arrangement Term
    appliestoDocNo Applies-to Doc. No. Code 20
    balAccountNo Bal. Account No. Code 20
    ship Ship Boolean 4
    invoice Invoice Boolean 4
    printPostedDocuments Print Posted Documents Boolean 4
    shippingNo Shipping No. Code 20
    postingNo Posting No. Code 20
    lastShippingNo Last Shipping No. Code 20 Sales Shipment Header
    lastPostingNo Last Posting No. Code 20 Sales Invoice Header
    prepaymentNo Prepayment No. Code 20
    lastPrepaymentNo Last Prepayment No. Code 20 Sales Invoice Header
    prepmtCrMemoNo Prepmt. Cr. Memo No. Code 20
    lastPrepmtCrMemoNo Last Prepmt. Cr. Memo No. Code 20 Sales Cr.Memo Header
    vatRegistrationNo VAT Registration No. Text 20
    combineShipments Combine Shipments Boolean 4
    reasonCode Reason Code Code 10 Reason Code
    genBusPostingGroup Gen. Bus. Posting Group Code 20 Gen. Business Posting Group
    eU3PartyTrade EU 3-Party Trade Boolean 4
    transactionType Transaction Type Code 10 Transaction Type
    transportMethod Transport Method Code 10 Transport Method
    vatCountryRegionCode VAT Country/Region Code Code 10 Country/Region
    selltoCustomerName Sell-to Customer Name Text 100 Customer
    selltoCustomerName2 Sell-to Customer Name 2 Text 50
    selltoAddress Sell-to Address Text 100
    selltoAddress2 Sell-to Address 2 Text 50
    selltoCity Sell-to City Text 30
    selltoContact Sell-to Contact Text 100
    billtoPostCode Bill-to Post Code Code 20 Post Code
    billtoCounty Bill-to County Text 30
    billtoCountryRegionCode Bill-to Country/Region Code Code 10 Country/Region
    selltoPostCode Sell-to Post Code Code 20
    selltoCounty Sell-to County Text 30
    selltoCountryRegionCode Sell-to Country/Region Code Code 10 Country/Region
    shiptoPostCode Ship-to Post Code Code 20
    shiptoCounty Ship-to County Text 30
    shiptoCountryRegionCode Ship-to Country/Region Code Code 10 Country/Region
    balAccountType Bal. Account Type Option 4 G/L Account, Bank Account
    exitPoint Exit Point Code 10 Entry/Exit Point
    correction Correction Boolean 4
    documentDate Document Date Date 4
    externalDocumentNo External Document No. Code 35
    area Area Code 10 Area
    transactionSpecification Transaction Specification Code 10 Transaction Specification
    paymentMethodCode Payment Method Code Code 10 Payment Method
    shippingAgentCode Shipping Agent Code Code 10 Shipping Agent
    packageTrackingNo Package Tracking No. Text 30
    noSeries No. Series Code 20 No. Series
    postingNoSeries Posting No. Series Code 20 No. Series
    shippingNoSeries Shipping No. Series Code 20 No. Series
    taxAreaCode Tax Area Code Code 20 Tax Area
    taxLiable Tax Liable Boolean 4
    vatBusPostingGroup VAT Bus. Posting Group Code 20 VAT Business Posting Group
    reserve Reserve Option 4 Never, Optional, Always
    appliestoID Applies-to ID Code 50
    vatBaseDiscountPct VAT Base Discount % Decimal 12
    status Status Option 4 Open, Released, Pending Approval, Pending Prepayment
    invoiceDiscountCalculation Invoice Discount Calculation Option 4 None, %, Amount
    invoiceDiscountValue Invoice Discount Value Decimal 12
    sendICDocument Send IC Document Boolean 4
    icStatus IC Status Option 4 New, Pending, Sent
    selltoICPartnerCode Sell-to IC Partner Code Code 20 IC Partner
    billtoICPartnerCode Bill-to IC Partner Code Code 20 IC Partner
    icReferenceDocumentNo IC Reference Document No. Code 20
    icDirection IC Direction Option 4 Outgoing, Incoming
    prepaymentPct Prepayment % Decimal 12
    prepaymentNoSeries Prepayment No. Series Code 20 No. Series
    compressPrepayment Compress Prepayment Boolean 4
    prepaymentDueDate Prepayment Due Date Date 4
    prepmtCrMemoNoSeries Prepmt. Cr. Memo No. Series Code 20 No. Series
    prepmtPostingDescription Prepmt. Posting Description Text 100
    prepmtPmtDiscountDate Prepmt. Pmt. Discount Date Date 4
    prepmtPaymentTermsCode Prepmt. Payment Terms Code Code 10 Payment Terms
    prepmtPaymentDiscountPct Prepmt. Payment Discount % Decimal 12
    quoteNo Quote No. Code 20
    quoteValidUntilDate Quote Valid To Date Date 4
    quoteSentToCustomer Quote Sent to Customer DateTime 8
    quoteAccepted Quote Accepted Boolean 4
    quoteAcceptedDate Quote Accepted Date Date 4
    jobQueueStatus Job Queue Status Option 4 , Scheduled for Posting, Error, Posting
    jobQueueEntryID Job Queue Entry ID GUID 16
    companyBankAccountCode Company Bank Account Code Code 20
    incomingDocumentEntryNo Incoming Document Entry No. Integer 4 Incoming Document
    isTest IsTest Boolean 4
    selltoPhoneNo Sell-to Phone No. Text 30
    selltoEMail Email Text 80
    journalTemplName Journal Template Name Code 10
    vatReportingDate VAT Date Date 4
    rcvdfromCountRegionCode Received-from Country/Region Code Code 10 Country/Region
    dimensionSetID Dimension Set ID Integer 4 Dimension Set Entry
    paymentServiceSetID Payment Service Set ID Integer 4
    directDebitMandateID Direct Debit Mandate ID Code 35
    docNoOccurrence Doc. No. Occurrence Integer 4
    campaignNo Campaign No. Code 20 Campaign
    selltoContactNo Sell-to Contact No. Code 20 Contact
    billtoContactNo Bill-to Contact No. Code 20 Contact
    opportunityNo Opportunity No. Code 20
    selltoCustomerTemplCode Sell-to Customer Template Code Code 20 Customer Templ.
    billtoCustomerTemplCode Bill-to Customer Template Code Code 20 Customer Templ.
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    shippingAdvice Shipping Advice Option 4 Partial, Complete
    postingFromWhseRef Posting from Whse. Ref. Integer 4
    requestedDeliveryDate Requested Delivery Date Date 4
    promisedDeliveryDate Promised Delivery Date Date 4
    shippingTime Shipping Time DateFormula 32
    outboundWhseHandlingTime Outbound Whse. Handling Time DateFormula 32
    shippingAgentServiceCode Shipping Agent Service Code Code 10
    receive Receive Boolean 4
    returnReceiptNo Return Receipt No. Code 20
    returnReceiptNoSeries Return Receipt No. Series Code 20 No. Series
    lastReturnReceiptNo Last Return Receipt No. Code 20 Return Receipt Header
    priceCalculationMethod Price Calculation Method Option 4 , Lowest Price, Test Price, Test Price (not Implemented)
    allowLineDisc Allow Line Disc. Boolean 4
    getShipmentUsed Get Shipment Used Boolean 4
    assignedUserID Assigned User ID Code 50 User Setup
    factuursoort Invoice Subject Option 4 , Diversen, Beheer, S&V-kosten, , , , , , , Verkoop
    factuurtype Invoice Type Option 4 Geen, Factuur, Factuur + OLA, OLA
    leegstandsboekingsgroep Vacancy Posting Group Code 30 VacancyPostingGroupFDN
    eenheidnr Realty Object No. Code 20 OGE
    contractvolgnr Contract Entry No. Integer 4
    prolongatierunnr Prolongation Run No. Integer 4
    boekingsfoutOpgetreden Posting Error Occurred Boolean 4
    suStartDatePeriod1 Start Date Settlement Period 1 Date 4
    suEndDatePeriod1 End Date Settlement Period 1 Date 4
    suStartDateRentalPeriod1 Start Date Rental Period 1 Date 4
    suEndDateRentalPeriod1 End Date Rental Period 1 Date 4
    suStartDateNewAdvance Start Date New Advance Date 4
    suNewAdvanceAmount New Advance Amount Decimal 12
    suStartDatePeriod2 Start Date Settlement Period 2 Date 4
    suEndDatePeriod2 End Date Settlement Period 2 Date 4
    suStartDateRentalPeriod2 Start Date Rental Period 2 Date 4
    suEndDateRentalPeriod2 End Date Rental Period 2 Date 4
    naam3 Name 3 Text 30
    naam4 Name 4 Text 30
    factuurnaam3 Invoice Name 3 Text 30
    factuurnaam4 Invoice Name 4 Text 30
    vvEfactuur Invoice Owners Association Boolean 4
    frequentie Frequency DateFormula 32
    periodiekeFactuur Periodical Invoice Boolean 4
    clusternr Cluster No. Code 20 Cluster
    gereedmelding Completed Boolean 4
    aflevertelefoon Delivery Phone No. Text 30
    weigeringsbedrag Refusal Amount Decimal 12
    eersteFactuur First Invoice Boolean 4
    soortContract Invoice Option Option 4 , Huur, Erfpacht, , Onderh.tlv huurder, Onderh.tlv derden, 1e verhuurnota, Pro-formafactuur
    svBatchnaam S&C Batch Name Text 30
    soortVerrekeningSV SC Settlement Type Option 4 , Gehele verrekening saldo, Gedeeltelijke verrekening saldo, Afrekening buiten afrekengrenzen
    betalingsregeling Payment Scheme Boolean 4
    deurwaarder Bailiff Boolean 4
    aanbieding Proposal Code 20
    contractsoort Proposal Model Code 20 Proposal Model
    taxatiewaarde Appraised Value Decimal 12
    korting Discount Code 20
    kortingsPct Discount % Decimal 12
    extraKortingsPct Extra Discount % Decimal 12
    koopsomA Purchase Price (A) Decimal 12
    afkoopsomB Redemption Value (B) Decimal 12
    totaleKoopsom Total Purchase Price Decimal 12
    mutatienr Mutation No. Text 30
    datumVoorlopigKoopcontract Date Temporary Purchase Contract Date 4
    verwachteTransportdatum Expected Transfer Date Date 4
    transportdatum Transfer Date Date 4
    definitiefGetransporteerd Permanently Transferred Boolean 4
    koper Buyer Code 20 Contact
    bankGiroKoper Bank Buyer Code 10
    aanbiedingssoort Offer type Code 20 Proposal Type
    woningzoekendenr House Hunter No. Code 20
    salesCosts Sales Costs Decimal 12
    empireProjectnr Project No. (Emp.) Code 20 Empire Project
    empireProjecttype Project Type Code 20 Empire Projecttype
    empireBudgetregelnr Budget Line No. Integer 4
    empireBudgetdetailregelnr Budget Detail Line No. Integer 4
    bouwnr Maintenance Task No. Code 10
    meerEnMinderwerk Contract Variations Boolean 4
    disReferenceNo DIS Reference No. Code 50
    transactionModeCode Transaction Mode Code Code 20
    bankAccountCode Bank Account Code Code 20
    sortingID Sorting ID Code 20
    exploitationEndReasonCode Exploitation End Reason Code Code 20 Exploitation End Reason Code
    maintenanceRequestNo Maintenance Request No. Code 20 Maintenance Request
    maintenanceTaskNo Maintenance Task No. Code 20 DM - Maintenance Task
    mandateCode Mandate Code Code 20
    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