Skip to content
Client Resources 717.442.3247
Technical Documentation > Entities

INVPRICE

Product price

A single pricing option for a product

Inherits from EbmsDetailEntity

Properties

    AUTOID (EbmsAutoID, String, read-only)
    Auto ID
    The id that identifies the record in EBMS
    GL_CODE (EbmsGLCode, String)
    G/L Account
    ID (EbmsIDSearch, String, read-only)
    Product
    ID_Reference (RealINVENTRY, reference)
    Product
    IsDeleted (Boolean, Boolean, virtual, read-only)
    Is deleted
    IsNewEntity (Boolean, Boolean, virtual)
    Is new entity
    A virtual property that we can base computes off of to show if an entity is virtual
    LEVEL (EbmsID, String)
    Price level
    LEVEL_Reference (INPRICE, reference)
    Level
    MARGMARK (Decimal, Decimal, read-only)
    {$INOPTION.MARG_MARK}
    MARKUP (EbmsFormulaText, String)
    Formula
    Price level formula template
    MARKUP_ID (EbmsID, String)
    Formula
    Price level formula
    MARKUP_ID_Reference (FORMULA, reference)
    Formula
    Price level formula
    PRICE (Decimal, Decimal)
    Price
    QRY_AMOUNT (Price, Decimal)
    Query amount
    QRY_CUST (Text, String)
    Query customer
    QRY_PRICE (Price, Decimal)
    Query price
    QRY_QUAN_V (Quantity, Decimal)
    Query quantity
    QRY_RETAIN (Boolean, Boolean)
    Query retain
    Subtitle (BasicHtmlCompact, String, virtual, read-only)
    Subtitle
    Title (Title, String, virtual, read-only)
    Title
    UNIT (EbmsUnit, String)
    Unit
Version 1.6.436, Updated on Monday, April 29, 2024

Reading products

GEThttps://ecc123456789012345.servicebus.windows.net/MyEbms/ABC/OData/INVPRICE?$filter=ID eq 'DIRSHO'

Updating a price

PATCHhttps://ecc123456789012345.servicebus.windows.net/MyEbms/ABC/OData/INVENTRY('061PBSEDENMPC801')
{
"INVPRICEs@delta": [
    {
     "@id": "08UKK87FDNANGPA1",
     "MARKUP_ID": "4IS",
     "MARKUP": "Is $10.45"
     }

Getting the price of a product for a specific customer

GET
NATURALKEY:  https://ecc123456789012345.servicebus.windows.net/MyEbms/ABC/OData/INVENTRY(ID='BANANAS')/Model.Entities.GetPrice 
GUID: https://ecc123456789012345.servicebus.windows.net/MyEbms/ABC/OData/INVENTRY(50313630-5342-4445-454e-d5043383031)/Model.Entities.GetPrice
EBMS AUTOID: https://ecc123456789012345.servicebus.windows.net/MyEbms/ABC/OData/INVENTRY('061PBSEDENMPC801')/Model.Entities.GetPrice

{

    "PriceLevel": "Wholesale",
    "Uom": "cs",
    "CustomerId": "AMERET", 
   "Quantity": 10

}