Purch. Inv. Line

    API Details

    Property Value
    Endpoint /tablesFinance/purchInvLines
    Table name Purch. Inv. Line
    Table id 123
    Table caption Purch. Inv. 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
    buyfromVendorNo Buy-from Vendor No. Code 20 Vendor
    documentNo Document No. Code 20 * Purch. Inv. Header
    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
    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
    receiptNo Receipt No. Code 20
    receiptLineNo Receipt Line No. Integer 4
    orderNo Order No. Code 20
    orderLineNo Order Line No. Integer 4
    paytoVendorNo Pay-to Vendor No. Code 20 Vendor
    invDiscountAmount Inv. Discount Amount Decimal 12
    vendorItemNo Vendor Item No. Text 50
    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
    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
    icCrossReferenceNo 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
    deferralCode Deferral Code Code 10 Deferral Template
    allocationAccountNo Allocation Account No. Code 20
    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
    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
    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
    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
    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
    tabel Table Option 4 , Cluster, Eenheid
    costCodeType Cost Code Type Option 4 , Service, Verbruik, Water, Individueel
    tenLasteVan Charged to Option 4 Beheergever, Beheerder
    afrekeningTot Account Settlement Until Date 4
    clusternr Cluster No. Code 20 Cluster
    rcCode Current Account Code Code 10 RC Verhoudingen
    verdelingsmethode Division Method Option 4 , Lineair, Oppervlakte, Kale huur, WOZ-waarde, Teller/Noemer
    grootboekrekeningBudget Budget G/L Account Code 20
    budget Budget Code 10
    budgetdatum Budget Date Date 4
    kostenLV Cost (LCY) Decimal 12
    automatischGegenereerd Generated Boolean 4
    verzameldVanafOrdernr Accumulated from Order No. Code 20
    externBonnr Ticket No. Code 20
    verzamelregelnr Accumulation Line No. Integer 4
    kostenNietBoeken No Cost Posting Boolean 4
    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
    gekoppeldAanSubsidienr Linked to Benefit/Order No. Code 20
    gekoppeldAanSubsidieregelnr Linked to Line No. Integer 4
    projectfase Project Phase Code 10
    subsidie Benefit Boolean 4
    contractnr Contract No. Code 20 Maintenance Contract
    surchargeCode Surcharge Code Code 10
    surchargePercentage Surcharge Percentage Decimal 12
    appliedCostAccountSurcharge Applied Cost Account Surcharge Code 20 G/L Account
    transitoAllocationCode Transito Allocation Code Code 10 Transito Allocation
    orderCommitmentPerUnit Order Commitment per Unit Decimal 12
    scBatchName SC Batch Name Code 10
    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
    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
    prodOrderLineNo Prod. Order Line No. Integer 4
    overheadRate Overhead Rate Decimal 12
    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