Purchase Line Archive

    API Details

    Property Value
    Endpoint /tablesFinance/purchaseLineArchives
    Table name Purchase Line Archive
    Table id 5110
    Table caption Purchase Line Archive
    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
    quantityDiscPct Quantity Disc. % 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
    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
    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
    icPartnerCode IC Partner Code Code 20 IC Partner
    icItemReferenceNo IC Item Reference No. Code 50
    pmtDiscountAmount 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
    versionNo Version No. Integer 4 *
    docNoOccurrence Doc. No. Occurrence Integer 4 *
    prodOrderNo Prod. Order No. Code 20
    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
    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 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
    returnShipmentNo Return Shipment No. Code 20
    returnShipmentLineNo Return Shipment 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)
    eenheidnr Object No. Code 20 OGE
    eenheidnrKostentabel Object No. Cost Table Code 20 OGE
    tabel Table Option 4 , Cluster, Eenheid
    costCodeType Cost Code Type Option 4 , Service, Verbruik, Water, Individueel
    tenLasteVan Charged To Option 4 Beheergever, Beheerder
    afrekeningTot Settlement Until Date 4
    clusternr Cluster No. Code 20
    costCodePostingLineNo Cost Code Posting Line No. Integer 4 Cost Code Entry
    afrekeningsoort Settlement Type Option 4 Inkomsten, Waarborgsom, Provisie, Uitgaven
    huisnr House No. Code 20
    toevoegsel Addition Code 20
    tenLasteVanHuurder Charged To Tenant Boolean 4
    pctDoorbelasten % Charged Out To Decimal 12
    bedragDoorbelasten Amount Charged Out To Decimal 12
    verdelingsmethode Division Method Option 4 , Lineair, Oppervlakte, Kale huur, WOZ-waarde, Teller/Noemer
    grootboekrekeningBudget Budget G/L Account Code 20
    verplichtingGeboekt Posted Obligation Boolean 4
    budget Budget Code 10 G/L Budget Name
    budgetdatum Budget Date Date 4
    verplichtingLV Obligation (LCY) Decimal 12
    automatischGegenereerd Auto Generated Boolean 4
    verzameldVanafOrdernr Collected from Order No. Code 20
    externBonnr Ticket No. Code 20
    verzameldOnderFactuurNr Collected by Invoice No. Code 20
    verzamelregelnr Collection Line No. Integer 4
    gemarkeerdDoorGebruiker Marked by User Code 30
    verwachteFactuurdatum Expected Date Invoice Date 4
    vanuitGeboekteFactuur From Posted Invoice Code 20
    kostenNietBoeken No Cost Posting Boolean 4
    doorgeboekt Posted Boolean 4
    tenLasteVanDerden Charged Out To Third Party Boolean 4
    doorbelastenAan Charge Out To Code 20 Customer
    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 Empire Job Type Posting Group Code 10 Werksoortboekingsgroep
    regiebedragExclBTW Amount Time and Material excl. VAT Decimal 12
    regiebedragInclBTW Amount Time and Material incl. VAT Decimal 12
    contractNo Contract No. Code 20 Maintenance Contract
    completionDate Completion Date Date 4
    componentModelNo Component Model No. Code 20 Projectmodel
    maintenanceTaskNo Maintenance Task No. Code 20 DM - Maintenance Task
    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