Purchase Status Line

    API Details

    Property Value
    Endpoint /tablesFinance/purchaseStatusLines
    Table name Purchase Status Line
    Table id 11024173
    Table caption Purchase Status 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
    entryNo Entry No. Integer 4 *
    maintenanceTaskNo Maintenance Task No. Code 20 DM - Maintenance Task
    maintenanceRequestNo Maintenance Request No. Code 20 Maintenance Request
    documentType Document Type Option 4 Quote, Order, Invoice, Credit Memo, Blanket Order, Return Order
    purchaseDocumentNo Purchase Document No. Code 20
    documentLineNo Document Line No. Integer 4
    dateCreated Entry Date Date 4
    vendorNo Vendor No. Code 20 Vendor
    description Description Text 100
    description2 Description 2 Text 50
    lineAmount Line Amount Decimal 12
    lineAmountIncludingVAT Line Amount Including VAT Decimal 12
    amount Amount Decimal 12
    amountIncludingVAT Amount Including VAT Decimal 12
    archDocNoOccurrence Doc. No. Occurrence Integer 4
    archVersionNo Version No. Integer 4
    purchaseDocumentStatus Line Status Option 4 , Request, In Progress, Converted, Rejected, , , Order, Work Completed, Closed
    completionDate Completion Date Date 4
    dateCompletedEntry Date Completed (Entry) Date 4
    purchaseStatus Order Status Option 4 Open, Released, Pending Approval, Pending Prepayment
    purchaseOrderAwarded Purchase Order Awarded Boolean 4
    completionTime Completion Time Time 4
    dateAwarded Date Awarded DateTime 8
    processMethod Process Method Option 4 Traditional, Vendor Portal, Kovra
    utmostReadyDate Utmost ready date Date 4
    appointmentDate Appointment Date Date 4
    documentNo Document No. Code 20
    plannerFinishCode Finish Code Order Code 20 DM - Order Finish Code
    quoteNo Quote No. Code 20
    assignedUserID Assigned User ID Code 50 User Setup
    costsSpecified Costs Specified Boolean 4
    inInvoice In Invoice Boolean 4
    awardedBy Awarded By Code 50
    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
    purchaserCode Purchaser Code Code 20 Salesperson/Purchaser
    projectNo Project No. Code 20 Empire Project
    createdBy Created By Code 50 User
    type Type Option 4 , Daily Maintenance, Project, Planned Maintenance
    budgetLineNo Budget Line No. Integer 4
    detailLineNo Detail Line No. Integer 4
    realtyObjectNo Realty Object No. Code 20 OGE
    adress Adress Text 100
    costCode Cost Code Code 20
    clusterNo Cluster No. Code 20 Cluster
    showOnVendorPortal Show on Portal Boolean 4
    paymentMethod Purchase Method Option 4 Subsequent Calculation, Fixed Price, Contract, Quote
    postcode ZIP Code Code 20 Post Code
    plaats City Text 30
    costSpecificationType Cost Specification Type Option 4 Calculation, Fixed Price
    projectName Project Name Text 50
    projectDescription Project Description Text 50
    purchaseLineVATType Purchase Line VAT Type Option 4 Normal VAT, Reverse Charge VAT, Full VAT, Sales Tax
    maintenanceOrderStatus Maintenance Order Status Option 4 New, , , , Quote Requested, , , , Quote Received, , , , Quote Accepted, , , , Quote Rejected, , , , Pending Approval, , , , Released, , , , Awarded, , , , Accepted, , , , Refused, , , , To Plan, , , , Planned, , , , Def. Planned, , , , In Progress, , , , Intermittent, , , , Work Completed, , , , Closed
    maintenanceType Maintenance Type Option 4 , , , Repair maintenance, , , , Mutation maintenance, , , , Planned maintenance, , , , Livability maintenance, , , , WMO maintenance, , , , Improvement
    maintenanceOrderDescription Maintenance Order Description Text 150
    maintOrderAmount Maintenance Order Amount Decimal 12
    maintOrderAmountInclVAT Maintenance Order Amount Incl. VAT Decimal 12
    maintOrderAmtFixedPrice Maintenance Order Amount Fixed Price Decimal 12
    vpConceptInvoiceDM Portal Concept Invoice Boolean 4
    vpConceptInvoiceGen VP Concept Invoice Gen. Boolean 4
    kovraStatusCode KOVRA Status Code 3 KVStatus
    hasUnreadVendorComment Has Unread Vendor Comment Boolean 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