The MEA price list is a container for MEA price list entries, each of which defines the standalone selling price for an item in a multi-element arrangement. Usage information for MEA price lists is available in the Sage Intacct product help.


List MEA Price Lists

readByQuery

<readByQuery>
    <object>CONTRACTMEAPRICELIST</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use CONTRACTMEAPRICELIST
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

query

Name Required Type Description
STATUS Optional string Status. Use T for Active, F fo Inactive

Get MEA Price List

read

<read>
    <object>CONTRACTMEAPRICELIST</object>
    <keys>1</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use CONTRACTMEAPRICELIST
keys Required string MEA price list RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Get MEA Price List by Name

readByName

<readByName>
    <object>CONTRACTMEAPRICELIST</object>
    <keys>MEA Price List</keys>
    <fields>*</fields>
</readByName>

Parameters

Name Required Type Description
object Required string Use CONTRACTMEAPRICELIST
keys Required string MEA price list NAME to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Create MEA Price List

create

<create>
    <CONTRACTMEAPRICELIST>
        <NAME>MEA price list</NAME>
    </CONTRACTMEAPRICELIST>
</create>

Parameters

Name Required Type Description
CONTRACTMEAPRICELIST Optional object Object to create

CONTRACTMEAPRICELIST

Name Required Type Description
NAME Required string MEA price list name
DESCRIPTION Optional string Description
STATUS Optional string Status. Use active for Active or inactive for Inactive. (Default: active)

Update MEA Price List

update

<update>
    <CONTRACTMEAPRICELIST>
        <NAME>MEA price list</NAME>
        <DESCRIPTION>hello world</DESCRIPTION>
    </CONTRACTMEAPRICELIST>
</update>

Parameters

Name Required Type Description
CONTRACTMEAPRICELIST Optional object Object to update

CONTRACTMEAPRICELIST

Name Required Type Description
RECORDNO Optional integer Record number of MEA price list. Required if not using NAME.
NAME Optional string MEA price list name. Required if not using RECORDNO.
DESCRIPTION Optional string Description
STATUS Optional string Status. Use active for Active or inactive for Inactive.

Delete MEA Price List

delete

<delete>
    <object>CONTRACTMEAPRICELIST</object>
    <keys>112</keys>
</delete>

Parameters

Name Required Type Description
object Required string Use CONTRACTMEAPRICELIST
keys Required string MEA price list RECORDNO to delete

List MEA Price List Entries

readByQuery

<readByQuery>
    <object>CONTRACTMEAITEMPRICELIST</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use CONTRACTMEAITEMPRICELIST
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

Get MEA Price List Entries

read

<read>
    <object>CONTRACTMEAITEMPRICELIST</object>
    <keys>15</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use CONTRACTMEAITEMPRICELIST
keys Required string MEA item price list RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Create MEA Price List Entry

You create price list entries for a given item under an existing MEA price list. There are several models for this—you can specify the item price as:

  • An amount, one of either:
    • Amount
    • Amount with price range
  • A price range

Be aware of which fields are used with the approach you choose:

fields for

Usage information for MEA price list entries is available in the Sage Intacct product help.

create

Creates an entry whose amount is 2500 dollars:

<create>
    <CONTRACTMEAITEMPRICELIST>
        <PRICELISTNAME>MEA price list</PRICELISTNAME>
        <ITEMID>SFTW</ITEMID>
        <CURRENCY>USD</CURRENCY>
        <ITMPRCLSTTYP>Amount</ITMPRCLSTTYP>
        <CONTRACTMEAITEMPRICELISTENTRIES>
            <CONTRACTMEAITEMPRICELISTENTRY>
                <STARTDATE>01/31/2017</STARTDATE>
                <VALUE>2500.00</VALUE>
                <MARKUP></MARKUP>
                <MARKDOWN></MARKDOWN>
                <MEMO></MEMO>
            </CONTRACTMEAITEMPRICELISTENTRY>
        </CONTRACTMEAITEMPRICELISTENTRIES>
    </CONTRACTMEAITEMPRICELIST>
</create>

Creates an entry with a price range between 300 and 350 dollars:

<create>
  <CONTRACTMEAITEMPRICELIST>
    <PRICELISTNAME>MEA price list</PRICELISTNAME>
    <ITEMID>SFTW</ITEMID>
    <CURRENCY>USD</CURRENCY>
    <ITMPRCLSTTYP>Price Range</ITMPRCLSTTYP>
    <CONTRACTMEAITEMPRICELISTENTRIES>
        <CONTRACTMEAITEMPRICELISTENTRY>
            <STARTDATE>01/31/2017</STARTDATE>
            <BANDDOWN>300.00</BANDDOWN>
            <BANDUP>350.00</BANDUP>
            <MEMO></MEMO>
        </CONTRACTMEAITEMPRICELISTENTRY>
    </CONTRACTMEAITEMPRICELISTENTRIES>
   </CONTRACTMEAITEMPRICELIST>
</create>

Parameters

Name Required Type Description
CONTRACTMEAITEMPRICELIST Optional object Object to create

CONTRACTMEAITEMPRICELIST

Name Required Type Description
PRICELISTNAME Required string Price list name
ITEMID Required string Item ID
CURRENCY Optional string Currency. Required if company is enabled for multi-currency.
ITMPRCLSTTYP Optional string Item priced as. Use Amount or Price Range. (Default: Amount)
USEPRICEBANDS Optional boolean Specifies whether to use the price range. Only used if Item priced as is set to Amount. Use true or false. (Default: false)
PRICEBANDTYPE Optional string Price range variances entered as. Only used if Use price range is set to true. Use Amount or Percent. (Default: Amount)
PRICEBANDRULE Optional string Price rule when outside range. Only used if Use price range is set to true. Use Fair Value or Nearest Boundary. (Default: Fair Value)
STATUS Optional string Status. Use active for Active or inactive for Inactive. (Default: active)
CONTRACTMEAITEMPRICELISTENTRIES Optional CONTRACTMEAITEMPRICELISTENTRY[0...n] MEA price list entries

CONTRACTMEAITEMPRICELISTENTRY

Name Required Type Description
STARTDATE Required string Start date in format mm/dd/yyyy
VALUE Optional currency Flat amount
MEMO Optional string Notes
MARKDOWN Optional number Range variance low. Required when Item priced as is set to Amount, but only applied if Use price range is set to true.
MARKUP Optional number Range variance high. Required when Item priced as is set to Amount, but only applied if Use price range is set to true.
BANDDOWN Optional number Lower limit. Required when Item priced as is set to Price Range.
BANDUP Optional number Upper limit. Required when Item priced as is set to Price Range.

Update MEA Price List Entry

An update creates a new MEA pricelist entry, which will support versioning of these objects (in a future release).

update

<update>
    <CONTRACTMEAITEMPRICELIST>
        <RECORDNO>15</RECORDNO>
        <STATUS>inactive</STATUS>
    </CONTRACTMEAITEMPRICELIST>
</update>

Parameters

Name Required Type Description
CONTRACTMEAITEMPRICELIST Optional object Object to update

CONTRACTMEAITEMPRICELIST

Name Required Type Description
RECORDNO Required string Record number of the MEA price list. Required if not using PRICELISTNAME.
PRICELISTNAME Required string Price list name. Required if not using RECORDNO.
CURRENCY Optional string Currency. Required if company is enabled for multi-currency.
ITMPRCLSTTYP Optional string Item priced as. Use Amount or Price Range. (Default: Amount)
USEPRICEBANDS Optional boolean Specifies whether to use the price range. Only used if Item priced as is set to Amount. Use true or false. (Default: false)
PRICEBANDTYPE Optional string Price range variances entered as. Only used if Use price range is true. Use Amount or Percent. (Default: Amount)
PRICEBANDRULE Optional string Price rule when outside range. Only used if Use price range is true. Use Fair Value or Nearest Boundary. (Default: Fair Value)
STATUS Optional string Status. Use active for Active or inactive for Inactive. (Default: active)
CONTRACTMEAITEMPRICELISTENTRIES Optional CONTRACTMEAITEMPRICELISTENTRY[0...n] MEA price list entries

CONTRACTMEAITEMPRICELISTENTRY

Name Required Type Description
STARTDATE Required string Start date in format mm/dd/yyyy
VALUE Optional currency Flat amount
MEMO Optional string Notes
MARKDOWN Optional number Range variance low. Only used if Use price range is true.
MARKUP Optional number Range variance high. Only used if Use price range is true.
BANDDOWN Optional number Lower limit. Only used if Item priced as Price Range.
BANDUP Optional number Upper limit. Only used if Item priced as Price Range.

Delete MEA Price List Entry

delete

<delete>
    <object>CONTRACTMEAITEMPRICELIST</object>
    <keys>15</keys>
</delete>

Parameters

Name Required Type Description
object Required string Use CONTRACTMEAITEMPRICELIST
keys Required string MEA price list entry RECORDNO to delete

List MEA Price List Entry Lines

readByQuery

Lists lines for the price list entry whose RECORNO is 12:

<readByQuery>
    <object>CONTRACTMEAITEMPRICELISTENTRY</object>
    <fields>*</fields>
    <query>ALLOCITEMPRCLSTKEY = 12</query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use CONTRACTMEAPRICELISTENTRY
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

query

Name Required Type Description
STATUS Optional string Status. Use T for Active, F fo Inactive

Get MEA Price List Entry Line

read

<read>
    <object>CONTRACTMEAITEMPRICELISTENTRY</object>
    <keys>1</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use CONTRACTMEAITEMPRICELISTENTRY
keys Required string MEA item price list RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Update MEA Price List Entry Line

update

<update>
    <CONTRACTMEAITEMPRICELISTENTRY>
        <RECORDNO>52</RECORDNO>
        <STARTDATE>01/31/2017</STARTDATE>
        <VALUE></VALUE>
        <MARKUP></MARKUP>
        <MARKDOWN></MARKDOWN>
        <BANDUP>350</BANDUP>
        <BANDDOWN>275</BANDDOWN>
        <MEMO>Reduced lower limit</MEMO>
    </CONTRACTMEAITEMPRICELISTENTRY>
</update>

Parameters

Name Required Type Description
RECORDNO Required string Record number of the MEA price list entry line
STARTDATE Required string Start date in format mm/dd/yyyy
VALUE Optional currency Flat amount
MEMO Optional string Notes
MARKDOWN Optional number Range variance low. Only used if USEPRICEBANDS is set to true.
MARKUP Optional number Range variance high. Only used if USEPRICEBANDS is set to true.
BANDDOWN Optional number Lower limit. Only used if ITMPRCLSTTYP is set to Price Range.
BANDUP Optional number Upper limit. Only used if ITMPRCLSTTYP is set to Price Range.

Provide feedback