Purchase Line

    API Details

    Property Value
    Endpoint /tablesFinance/purchaseLines
    Table name Purchase Line
    Table id 39
    Table caption Purchase 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
    documentType Document Type Option 4 * Quote, Order, Invoice, Credit Memo, Blanket Order, Return Order
    buyfromVendorNo Buy-from Vendor No. Code 20 Vendor
    documentNo Document No. Code 20 *
    lineNo Line No. Integer 4 *
    type Type Option 4 , G/L Account, Item, Resource, Fixed Asset, Charge (Item), Allocation Account, Cost Centre
    no No. Code 20
    locationCode Location Code Code 10
    postingGroup Posting Group Code 20
    expectedReceiptDate Expected Receipt Date Date 4
    description Description Text 100
    description2 Description 2 Text 50
    unitOfMeasure Unit of Measure Text 50
    quantity Quantity Decimal 12
    outstandingQuantity Outstanding Quantity Decimal 12
    qtyToInvoice Qty. to Invoice Decimal 12
    qtyToReceive Qty. to Receive Decimal 12
    directUnitCost Direct Unit Cost 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
    unitPriceLCY Unit Price (LCY) 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
    jobNo Job No. Code 20 Job
    indirectCostPct Indirect Cost % Decimal 12
    recalculateInvoiceDisc Recalculate Invoice Disc. Boolean 4
    outstandingAmount Outstanding Amount Decimal 12
    qtyRcdNotInvoiced Qty. Rcd. Not Invoiced Decimal 12
    amtRcdNotInvoiced Amt. Rcd. Not Invoiced Decimal 12
    quantityReceived Quantity Received Decimal 12
    quantityInvoiced Quantity Invoiced Decimal 12
    receiptNo Receipt No. Code 20
    receiptLineNo Receipt Line No. Integer 4
    orderNo Order No. Code 20
    orderLineNo Order Line No. Integer 4
    profitPct Profit % Decimal 12
    paytoVendorNo Pay-to Vendor No. Code 20 Vendor
    invDiscountAmount Inv. Discount Amount Decimal 12
    vendorItemNo Vendor Item No. Text 50
    salesOrderNo Sales Order No. Code 20
    salesOrderLineNo Sales Order Line No. Integer 4
    dropShipment Drop Shipment Boolean 4
    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
    entryPoint Entry Point Code 10 Entry/Exit Point
    area Area Code 10 Area
    transactionSpecification Transaction Specification Code 10 Transaction Specification
    taxAreaCode Tax Area Code Code 20 Tax Area
    taxLiable Tax Liable Boolean 4
    taxGroupCode Tax Group Code Code 20 Tax Group
    useTax Use Tax Boolean 4
    vatBusPostingGroup VAT Bus. Posting Group Code 20 VAT Business Posting Group
    vatProdPostingGroup VAT Prod. Posting Group Code 20 VAT Product Posting Group
    currencyCode Currency Code Code 10 Currency
    outstandingAmountLCY Outstanding Amount (LCY) Decimal 12
    amtRcdNotInvoicedLCY Amt. Rcd. Not Invoiced (LCY) Decimal 12
    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
    invDiscAmountToInvoice Inv. Disc. Amount to Invoice 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
    prepaymentPct Prepayment % Decimal 12
    prepmtLineAmount Prepmt. Line Amount Decimal 12
    prepmtAmtInv Prepmt. Amt. Inv. Decimal 12
    prepmtAmtInclVAT Prepmt. Amt. Incl. VAT Decimal 12
    prepaymentAmount Prepayment Amount Decimal 12
    prepmtVATBaseAmt Prepmt. VAT Base Amt. Decimal 12
    prepaymentVATPct Prepayment VAT % Decimal 12
    prepmtVATCalcType Prepmt. VAT Calc. Type Option 4 Normal VAT, Reverse Charge VAT, Full VAT, Sales Tax
    prepaymentVATIdentifier Prepayment VAT Identifier Code 20
    prepaymentTaxAreaCode Prepayment Tax Area Code Code 20 Tax Area
    prepaymentTaxLiable Prepayment Tax Liable Boolean 4
    prepaymentTaxGroupCode Prepayment Tax Group Code Code 20 Tax Group
    prepmtAmtToDeduct Prepmt Amt to Deduct Decimal 12
    prepmtAmtDeducted Prepmt Amt Deducted Decimal 12
    prepaymentLine Prepayment Line Boolean 4
    prepmtAmountInvInclVAT Prepmt. Amount Inv. Incl. VAT Decimal 12
    prepmtAmountInvLCY Prepmt. Amount Inv. (LCY) Decimal 12
    icPartnerCode IC Partner Code Code 20 IC Partner
    prepmtVATAmountInvLCY Prepmt. VAT Amount Inv. (LCY) Decimal 12
    prepaymentVATDifference Prepayment VAT Difference Decimal 12
    prepmtVATDiffToDeduct Prepmt VAT Diff. to Deduct Decimal 12
    prepmtVATDiffDeducted Prepmt VAT Diff. Deducted Decimal 12
    icItemReferenceNo IC Item Reference No. Code 50
    outstandingAmtExVATLCY Outstanding Amt. Ex. VAT (LCY) Decimal 12
    aRcdNotInvExVATLCY A. Rcd. Not Inv. Ex. VAT (LCY) Decimal 12
    pmtDiscountAmount Pmt. Discount Amount Decimal 12
    prepmtPmtDiscountAmount Prepmt. Pmt. Discount Amount Decimal 12
    dimensionSetID Dimension Set ID Integer 4 Dimension Set Entry
    jobTaskNo Job Task No. Code 20
    jobLineType Job Line Type Option 4 , Budget, Billable, Both Budget and Billable
    jobUnitPrice Job Unit Price Decimal 12
    jobTotalPrice Job Total Price Decimal 12
    jobLineAmount Job Line Amount Decimal 12
    jobLineDiscountAmount Job Line Discount Amount Decimal 12
    jobLineDiscountPct Job Line Discount % Decimal 12
    jobUnitPriceLCY Job Unit Price (LCY) Decimal 12
    jobTotalPriceLCY Job Total Price (LCY) Decimal 12
    jobLineAmountLCY Job Line Amount (LCY) Decimal 12
    jobLineDiscAmountLCY Job Line Disc. Amount (LCY) Decimal 12
    jobCurrencyFactor Job Currency Factor Decimal 12
    jobCurrencyCode Job Currency Code Code 20
    jobPlanningLineNo Job Planning Line No. Integer 4
    jobRemainingQty Job Remaining Qty. Decimal 12
    jobRemainingQtyBase Job Remaining Qty. (Base) Decimal 12
    deferralCode Deferral Code Code 10 Deferral Template
    returnsDeferralStartDate Returns Deferral Start Date Date 4
    selectedAllocAccountNo Allocation Account No. Code 20 Allocation Account
    allocationAccountNo Posting Allocation Account No. Code 20 Allocation Account
    prodOrderNo Prod. Order No. Code 20
    variantCode Variant Code Code 10
    binCode Bin Code Code 20
    qtyPerUnitOfMeasure Qty. per Unit of Measure Decimal 12
    qtyRoundingPrecision Qty. Rounding Precision Decimal 12
    qtyRoundingPrecisionBase Qty. Rounding Precision (Base) Decimal 12
    unitOfMeasureCode Unit of Measure Code Code 10
    quantityBase Quantity (Base) Decimal 12
    outstandingQtyBase Outstanding Qty. (Base) Decimal 12
    qtyToInvoiceBase Qty. to Invoice (Base) Decimal 12
    qtyToReceiveBase Qty. to Receive (Base) Decimal 12
    qtyRcdNotInvoicedBase Qty. Rcd. Not Invoiced (Base) Decimal 12
    qtyReceivedBase Qty. Received (Base) Decimal 12
    qtyInvoicedBase Qty. Invoiced (Base) Decimal 12
    faPostingDate FA Posting Date Date 4
    faPostingType FA Posting Type Option 4 , Acquisition Cost, Maintenance, Appreciation
    depreciationBookCode Depreciation Book Code Code 10 Depreciation Book
    salvageValue Salvage Value Decimal 12
    deprUntilFAPostingDate Depr. until FA Posting Date Boolean 4
    deprAcquisitionCost Depr. Acquisition Cost Boolean 4
    maintenanceCode Maintenance Code Code 10 Maintenance
    insuranceNo Insurance No. Code 20 Insurance
    budgetedFANo Budgeted FA No. Code 20 Fixed Asset
    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 Item Category
    nonstock Catalog Boolean 4
    purchasingCode Purchasing Code Code 10 Purchasing
    specialOrder Special Order Boolean 4
    specialOrderSalesNo Special Order Sales No. Code 20
    specialOrderSalesLineNo Special Order Sales Line No. Integer 4
    itemReferenceNo Item Reference No. Code 50
    itemReferenceUnitOfMeasure Item Reference Unit of Measure Code 10
    itemReferenceType Item Reference Type Option 4 , Customer, Vendor, Bar Code
    itemReferenceTypeNo Item Reference Type No. Code 30
    completelyReceived Completely Received Boolean 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
    plannedReceiptDate Planned Receipt Date Date 4
    orderDate Order Date Date 4
    allowItemChargeAssignment Allow Item Charge Assignment Boolean 4
    returnQtyToShip Return Qty. to Ship Decimal 12
    returnQtyToShipBase Return Qty. to Ship (Base) Decimal 12
    returnQtyShippedNotInvd Return Qty. Shipped Not Invd. Decimal 12
    retQtyShpdNotInvdBase Ret. Qty. Shpd Not Invd.(Base) Decimal 12
    returnShpdNotInvd Return Shpd. Not Invd. Decimal 12
    returnShpdNotInvdLCY Return Shpd. Not Invd. (LCY) Decimal 12
    returnQtyShipped Return Qty. Shipped Decimal 12
    returnQtyShippedBase Return Qty. Shipped (Base) Decimal 12
    nonDeductibleVATPct Non-Deductible VAT % Decimal 12
    nonDeductibleVATBase Non-Deductible VAT Base Decimal 12
    nonDeductibleVATAmount Non-Deductible VAT Amount Decimal 12
    nonDeductibleVATDiff Non-Deductible VAT Difference Decimal 12
    prepmtNonDeductVATBase Prepmt. Non-Deductible VAT Base Decimal 12
    prepmtNonDeductVATAmount Prepmt. on-Deductible VAT Amount Decimal 12
    returnShipmentNo Return Shipment No. Code 20
    returnShipmentLineNo Return Shipment Line No. Integer 4
    returnReasonCode Return Reason Code Code 10 Return Reason
    subtype Subtype Option 4 , Item - Inventory, Item - Service, Comment
    copiedFromPostedDoc Copied From Posted Doc. Boolean 4
    priceCalculationMethod Price Calculation Method Option 4 , Lowest Price, Test Price, Test Price (not Implemented)
    overReceiptQuantity Over-Receipt Quantity Decimal 12
    overReceiptCode Over-Receipt Code Code 20 Over-Receipt Code
    overReceiptApprovalStatus Over-Receipt Approval Status Option 4 , Pending, Approved
    suggestedLine Suggested Line Boolean 4
    eenheidnr Realty Object No. Code 20
    eenheidnrKostentabel Object No. Cost Table Code 20 OGE
    tabel Table Option 4 , Cluster, Eenheid
    kostencodesoort Cost Code Type Option 4 , Service, Verbruik, Water, Individueel
    tenLasteVan Charged to Option 4 Beheergever, Beheerder
    afrekeningTot Statement To Date Date 4
    clusternr Cluster No. Code 20
    costCodeEntryNo Cost Code Entry No. Integer 4 Cost Code Entry
    afrekeningsoort Settlement Type Option 4 Revenue, Deposit, AdministrationReimbursement, Costs
    huisnr House No. Code 20
    toevoegsel House No. Addition Code 20
    tenLasteVanKlant Charged to Customer Boolean 4
    pctDoorbelasten % Charged Decimal 12
    bedragDoorbelasten Amount Charged Decimal 12
    rcCode RC Code Code 10 RC Verhoudingen
    verdelingsmethode Allocation Method Option 4 , Lineair, Oppervlakte, Kale huur, WOZ-waarde, Teller/Noemer
    grootboekrekeningBudget G/L Account Budget Code 20
    verplichtingGeboekt Commitment Posted Boolean 4
    budget Budget Code 10 G/L Budget Name
    budgetdatum Date Budget Date 4
    verplichtingLV Commitment (LCY) Decimal 12
    automatischGegenereerd Generated Boolean 4
    verzameldVanafOrdernr Order No. Code 20
    externBonnr External Receipt No. Code 20
    verzamelregelnr Order Line No. Integer 4
    verwachteFactuurdatum Expected Invoice Date Date 4
    vanuitGeboekteFactuur FromPostedInvoice Code 20
    kostenNietBoeken No Cost Posting Boolean 4
    doorgeboekt Transferred Boolean 4
    toInvoice To get in Invoice Boolean 4
    livDossierNo Liv. Dossier No. Code 20 Livability Dossier
    tenLasteVanDerden Charged to Others Boolean 4
    doorbelastenAan Charge to Code 20 Customer
    postingStatus Posting Status Option 4 Unposted, Commitment Posted
    approvalStatus Approval Status Option 4 No Budget Holders, Not Approved, Partially Approved, Fully Approved
    commitmentLine Commitment Line Boolean 4
    empireProjectnr Project No. (Emp.) Code 20 Empire Project
    empireProjecttype Project Type (Emp.) Code 20 Empire Projecttype
    empireWerksoort Work Type Code 20 Empire Werksoort
    empireBudgetregelnr Budget Line No. Integer 4
    empireBudgetdetailregelnr Budget Detail Line No. Integer 4
    empireWerksoortboekingsgr Work Type Posting Group Code 10 Werksoortboekingsgroep
    gekoppAanSubsidieOrdernr Linked To Subsidy/Order No. Code 20
    gekoppAanRegelnr Linked To Line No. (Emp.) Integer 4
    oorspronkelijkBedragLV Original Amount (LC) Decimal 12
    regieorder Call-down Order Boolean 4
    regiebedragExclBTW Call-down Amount Excl. VAT Decimal 12
    regiebedragInclBTW Call-down Amount Incl. VAT Decimal 12
    regelGereedgemeld Line Finished Boolean 4
    projectfase Project Phase Code 10
    subsidie Subsidy Boolean 4
    maintenanceTemplate Repair Template Code 20 DM - Repair Template
    contractNo Contract No. Code 20 Maintenance Contract
    automatischGereedgemeld Automatically set to Finished Boolean 4
    completionDate Completion Date Date 4
    transitoAllocationCode Transito Allocation Code Code 10
    allocation Allocation Boolean 4
    orderCommitmentPerUnit Order Commitment per Unit Decimal 12
    scBatchName SC Batch Name Code 10
    componentModelNo Component Model No. Code 20 Projectmodel
    copiedForVATSpecification Copied for VAT specification Boolean 4
    vatAmount VAT Amount Decimal 12
    maintenanceRequestNo Maintenance Request No. Code 20 Maintenance Request
    maintenanceTaskNo Maintenance Task No. Code 20
    maintDemandOrderNo Maint. Demand Order No. Code 20 DM - Maintenance Order
    maintDemandLineNo Maint. Demand Task Line No. Integer 4
    externalCostsExclVAT External Costs excl. VAT Decimal 12
    externalVATProdPostingGrp External VAT Prod. Posting Group Code 10 VAT Product Posting Group
    maintenanceOrderNo Maintenance Order No. Code 30 DM - Maintenance Order
    taskSpecificationType Task Specification Type Option 4 , Arbeid, Materiaal, Voorrijkosten, Diverse kosten
    copiedFromLineNo Copied From Line No. Integer 4
    takeAwayMaterialNo Take Away Material No. Integer 4 Connect-It Take Away Material
    distributionKeyID Distribution Key ID Integer 4
    distributionReferenceDate Distribution Reference Date Date 4
    routingNo Routing No. Code 20 Routing Header
    operationNo Operation No. Code 10
    workCenterNo Work Center No. Code 20 Work Center
    finished Finished Boolean 4
    prodOrderLineNo Prod. Order Line No. Integer 4
    overheadRate Overhead Rate Decimal 12
    mpsOrder MPS Order Boolean 4
    planningFlexibility Planning Flexibility Option 4 Unlimited, None
    safetyLeadTime Safety Lead Time DateFormula 32
    routingReferenceNo Routing Reference No. Integer 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