Purchase Header

    API Details

    Property Value
    Endpoint /tablesFinance/purchaseHeaders
    Table name Purchase Header
    Table id 38
    Table caption Purchase 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
    buyfromVendorNo Buy-from Vendor No. Code 20 Vendor
    no No. Code 20 *
    paytoVendorNo Pay-to Vendor No. Code 20 Vendor
    paytoName Pay-to Name Text 100 Vendor
    paytoName2 Pay-to Name 2 Text 50
    paytoAddress Pay-to Address Text 100
    paytoAddress2 Pay-to Address 2 Text 50
    paytoCity Pay-to City Text 30
    paytoContact Pay-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
    expectedReceiptDate Expected Receipt 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
    vendorPostingGroup Vendor Posting Group Code 20 Vendor Posting Group
    currencyCode Currency Code Code 10 Currency
    currencyFactor Currency Factor Decimal 12
    pricesIncludingVAT Prices Including VAT Boolean 4
    invoiceDiscCode Invoice Disc. Code Code 20
    languageCode Language Code Code 10 Language
    formatRegion Format Region Text 80 Language Selection
    purchaserCode Purchaser 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
    receive Receive Boolean 4
    invoice Invoice Boolean 4
    printPostedDocuments Print Posted Documents Boolean 4
    receivingNo Receiving No. Code 20
    postingNo Posting No. Code 20
    lastReceivingNo Last Receiving No. Code 20 Purch. Rcpt. Header
    lastPostingNo Last Posting No. Code 20 Purch. Inv. Header
    vendorOrderNo Vendor Order No. Code 35
    vendorShipmentNo Vendor Shipment No. Code 35
    vendorInvoiceNo Vendor Invoice No. Code 35
    vendorCrMemoNo Vendor Cr. Memo No. Code 35
    vatRegistrationNo VAT Registration No. Text 20
    selltoCustomerNo Sell-to Customer No. Code 20 Customer
    reasonCode Reason Code Code 10 Reason Code
    genBusPostingGroup Gen. Bus. Posting Group Code 20 Gen. Business Posting Group
    transactionType Transaction Type Code 10 Transaction Type
    transportMethod Transport Method Code 10 Transport Method
    vatCountryRegionCode VAT Country/Region Code Code 10 Country/Region
    buyfromVendorName Buy-from Vendor Name Text 100 Vendor
    buyfromVendorName2 Buy-from Vendor Name 2 Text 50
    buyfromAddress Buy-from Address Text 100
    buyfromAddress2 Buy-from Address 2 Text 50
    buyfromCity Buy-from City Text 30
    buyfromContact Buy-from Contact Text 100
    paytoPostCode Pay-to Post Code Code 20
    paytoCounty Pay-to County Text 30
    paytoCountryRegionCode Pay-to Country/Region Code Code 10 Country/Region
    buyfromPostCode Buy-from Post Code Code 20
    buyfromCounty Buy-from County Text 30
    buyfromCountryRegionCode Buy-from 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
    orderAddressCode Order Address Code Code 10
    entryPoint Entry Point Code 10 Entry/Exit Point
    correction Correction Boolean 4
    documentDate Document Date Date 4
    area Area Code 10 Area
    transactionSpecification Transaction Specification Code 10 Transaction Specification
    paymentMethodCode Payment Method Code Code 10 Payment Method
    noSeries No. Series Code 20 No. Series
    postingNoSeries Posting No. Series Code 20 No. Series
    receivingNoSeries Receiving 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
    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
    buyfromICPartnerCode Buy-from IC Partner Code Code 20 IC Partner
    paytoICPartnerCode Pay-to IC Partner Code Code 20 IC Partner
    icReferenceDocumentNo IC Reference Document No. Code 20
    icDirection IC Direction Option 4 Outgoing, Incoming
    prepaymentNo Prepayment No. Code 20
    lastPrepaymentNo Last Prepayment No. Code 20 Purch. Inv. Header
    prepmtCrMemoNo Prepmt. Cr. Memo No. Code 20
    lastPrepmtCrMemoNo Last Prepmt. Cr. Memo No. Code 20 Purch. Cr. Memo Hdr.
    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
    jobQueueStatus Job Queue Status Option 4 , Scheduled for Posting, Error, Posting
    jobQueueEntryID Job Queue Entry ID GUID 16
    incomingDocumentEntryNo Incoming Document Entry No. Integer 4 Incoming Document
    creditorNo Creditor No. Code 20
    paymentReference Payment Reference Code 50
    invoiceReceivedDate Invoice Received Date Date 4
    journalTemplName Journal Template Name Code 10
    vatReportingDate VAT Date Date 4
    dimensionSetID Dimension Set ID Integer 4 Dimension Set Entry
    remittoCode Remit-to Code Code 20
    docNoOccurrence Doc. No. Occurrence Integer 4
    campaignNo Campaign No. Code 20 Campaign
    buyfromContactNo Buy-from Contact No. Code 20 Contact
    paytoContactNo Pay-to Contact No. Code 20 Contact
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    postingFromWhseRef Posting from Whse. Ref. Integer 4
    requestedReceiptDate Requested Receipt Date Date 4
    promisedReceiptDate Promised Receipt Date Date 4
    leadTimeCalculation Lead Time Calculation DateFormula 32
    inboundWhseHandlingTime Inbound Whse. Handling Time DateFormula 32
    vendorAuthorizationNo Vendor Authorization No. Code 35
    returnShipmentNo Return Shipment No. Code 20
    returnShipmentNoSeries Return Shipment No. Series Code 20 No. Series
    ship Ship Boolean 4
    lastReturnShipmentNo Last Return Shipment No. Code 20 Return Shipment Header
    priceCalculationMethod Price Calculation Method Option 4 , Lowest Price, Test Price, Test Price (not Implemented)
    assignedUserID Assigned User ID Code 50 User Setup
    docAmountInclVAT Doc. Amount Incl. VAT Decimal 12
    docAmountVAT Doc. Amount VAT Decimal 12
    factuursoort Invoice Type Option 4 , Onderhoud, , Afrekening, , , , , , , , , , , , , , , Verkoop, Terugkoop
    eenheidnr Realty Object No. Code 20 OGE
    batchboeken Post Batch Boolean 4
    afrekeningTot Statement To Date Date 4
    offertenrLeverancier Vendor Quote No. Code 35
    ontvangstdatum Receipt Date Date 4
    pctDoorbelasten Perc. Charged Decimal 12
    pctNaarGrekening % to B-Account Decimal 12
    bedragNaarGrekening Amount to B-Account Decimal 12
    aanbieding Proposal Code 20
    contractsoort Type Contract Code 20 Proposal Model
    taxatiewaarde Appraised Value Decimal 12
    korting Discount Code 20
    kortingsPct Discount % Decimal 12
    extraKortingsPct Extra Discount % Decimal 12
    koopsomA Purchase Value (A) Decimal 12
    afkoopsomB Redemption Value (B) Decimal 12
    totaleKoopsom Total Purchase Value Decimal 12
    mutatienr Modification No. Text 30
    datumVoorlopigKoopcontract Date Agreement For Sale Date 4
    verwachteTransportdatum Expected Transfer Date Date 4
    transportdatum Transfer Date Date 4
    definitiefGetransporteerd Permanently Transferred Boolean 4
    nhgVerstrekt NHG provided Boolean 4
    hypotheekverstrekker Mortgage Provider Code 20 Vendor
    hypotheeksom Mortgage Amount Decimal 12
    nhG2Verstrekt NHG2 provided Boolean 4
    hypotheekverstrekker2 Mortgage Provider 2 Code 20 Vendor
    hypotheeksom2 Mortgage Amount 2 Decimal 12
    koper Buyer Code 20 Contact
    bankGiroKoper Bank / Giro Buyer Code 10
    clusternr Cluster No. Code 20 Cluster
    budget Budget Code 10 G/L Budget Name
    awarded Awarded Boolean 4
    ingevoerdDoor Inserted by Code 50 User
    nietPlanmatigOnderhoud Non-Systematic Maintenance Boolean 4
    nogNietToegekend Not Yet Assigned Boolean 4
    factuurbedrag Invoice Amount Decimal 12
    gegundGefiatBedragInclBTW Awarded/Approved Order Amount Incl. VAT Decimal 12
    docAmountExclVAT Appr. Doc. Amount incl. VAT Decimal 12
    postingStatus Posting Status Option 4 Unposted, Commitment Posted
    timestampModified Timestamp Modified DateTime 8
    empireProjectnr Project No. Code 20 Empire Project
    empireProjecttype Project Type Code 20 Empire Projecttype
    empireNoEmailSent No. Sent E-mails Integer 4
    empireDateEmailSent Date E-mail Sent Date 4
    empireTimeEmailSent Time E-mail Sent Time 4
    empireMeerwerk Extra Work Boolean 4
    regieorder Call-down Order Boolean 4
    projectfase Project Phase Code 10
    bedragGoedgekeurd Amount Approved Boolean 4
    herhaaldGunnen Repeated Awarding Boolean 4
    projectsoort Project Form Option 4 Project, Planmatig, Niet planmatig,
    overschrijdtBudget Budget Overrun Boolean 4
    pctLoonkostenbestand % Wage Part Decimal 12
    pctPremiedeel % Premium Part Decimal 12
    awardedBy Awarded By Code 50 User Setup
    dateAwarded Date Awarded Date 4
    revChVATProdPostingGrp Reverse Charge VAT Prod. Posting Group Code 20
    invoiceVATAmount Invoice VAT Amount Decimal 12
    disReferenceNo DIS Reference No. Code 50
    transactionModeCode Transaction Mode Code Code 20
    bankAccountCode Bank Account Code Code 20
    vendorStatus Vendor Status Option 4 , , Submitted, , , Accepted, , Planned, Cancelled, , Completed, , , , , Refused
    purchaseReasonCode Purchase Reason Code Code 10 Purchase Reason Code
    settlementCode Service Call Settlement Code Code 20 Service Call Settlement Code
    datePortalReady Date portal ready Date 4
    suppressNotificationMail Suppress Notification mail Boolean 4
    suppressOrderNotfMail Suppress Order Notf. MailEMP Boolean 4
    vatBaseAmountZeroOCR VAT Base Amount Zero OCR Decimal 12
    vatBaseAmountLowOCR VAT Base Amount Low OCR Decimal 12
    vatAmountLowOCR VAT Amount Low OCR Decimal 12
    vatPctLowOCR VAT % Low OCR Decimal 12
    vatBaseAmountHighOCR VAT Base Amount High OCR Decimal 12
    vatAmountHighOCR VAT Amount High OCR Decimal 12
    vatPctHighOCR VAT % High OCR Decimal 12
    maintenanceService Maintenance Service Boolean 4
    maintenanceRequestNo Maintenance Request No. Code 20 Maintenance Request
    maintenanceTaskNo Maintenance Task No. Code 20 DM - Maintenance Task
    maintDemandOrderNo Maint. Demand Order No. Code 20 DM - Maintenance Order
    maintOrderNo Maint. Order No. Code 20 DM - Maintenance Order
    maintOrderCommitment Maint. Order Commitment Decimal 12
    processMethod Process Method Option 4 Traditional, Vendor Portal, Kovra
    submittedFromVendorPortal Submitted from Vendor Portal Boolean 4
    showOnVendorPortal Show on Portal Boolean 4
    vpInvoiceEntryNo VP Invoice Entry No. Integer 4
    randomVendorCheck Random Vendor Check Boolean 4
    reverseChargeVATApplicable Reverse Charge VAT Applicable Boolean 4
    attachmentSetID Attachment Set IDEMP Integer 4
    descriptionSetID Description Set IDEMP Integer 4
    statusAutoCreatedInvLines Status Automatically Created Invoice Lines Option 4 , Open, NotFound, NotReady, CompleteCostSpecification, InvoiceLinesCreated, MatchAndPostFailed
    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