Expense Sheet Lines

expensesheetlines

ParameterType
CompanyString
ActionString
InputDate
ResponseXML / JSON

Description

Calling the expenses API with an action of expensesheetlines retrieves a list of expense sheet line entries.

Return Values

Response – List of expense sheet line entries.

The structure of the response is:

<expenselines morepages="False" totalpages="1" totalrows="1">
  <expenseline>
    <array_expenselineapprove>false</array_expenselineapprove>
    <expenselines_queryrejectreason/>
    <array_expenselineattachmentdelete>true</array_expenselineattachmentdelete>
    <array_expenselineattachmentupload>true</array_expenselineattachmentupload>
    <array_expenselineattachmentview>true</array_expenselineattachmentview>
    <array_expenselineclientname>A Test for Prospect Mail merge</array_expenselineclientname>
    <array_expenselinecopy>true</array_expenselinecopy>
    <expenselines_currencycode>1/USD</expenselines_currencycode>
    <array_expenselinecurrencydescription>US Dollars</array_expenselinecurrencydescription>
    <array_expenselinecurrencysymbol>$</array_expenselinecurrencysymbol>
    <expenselines_currencytotal>23</expenselines_currencytotal>
    <expenselines_currencyrate>23</expenselines_currencyrate>
    <expenselines_expensedate>2014-11-17</expenselines_expensedate>
    <array_expenselinedelete>true</array_expenselinedelete>
    <expenselines_description>Miscellaneous </expenselines_description>
    <array_expenselineedit>true</array_expenselineedit>
    <array_expenselineexchangerate>1.5</array_expenselineexchangerate>
    <array_expenselineheld>false</array_expenselineheld>
    <expenselines_expenselineinternal>2005</expenselines_expenselineinternal>
    <array_expenselinejobdescription>test team alert</array_expenselinejobdescription>
    <expenselines_jobandphase>1/00008562.001</expenselines_jobandphase>
    <array_expenselinejobphasesimple>8562.001</array_expenselinejobphasesimple>
    <array_expenselinejobphasestage>35</array_expenselinejobphasestage>
    <array_expenselinejobphasestagedesc>dqs</array_expenselinejobphasestagedesc>
    <array_expenselinejobsimple>8562</array_expenselinejobsimple>
    <expenselines_linenumber>1</expenselines_linenumber>
    <expenselines_quantity>1</expenselines_quantity>
    <array_expenselinequery>false</array_expenselinequery>
    <array_expenselinereject>false</array_expenselinereject>
    <array_expenselineresubmit>false</array_expenselineresubmit>
    <expenselines_statuscode>S</expenselines_statuscode>
    <array_expenselinestatusdisplay>Unsubmitted</array_expenselinestatusdisplay>
    <array_expenselinesubmit>false</array_expenselinesubmit>
    <array_expenselinesubmitted>false</array_expenselinesubmitted>
    <expenselines_resubmitreason/>
    <expenselines_supplytype>Miscellaneous </expenselines_supplytype>
    <expenselines_total>15.33</expenselines_total>
    <expenselines_rate>15.33</expenselines_rate>
    <array_expenselinevaluesedit>true</array_expenselinevaluesedit>
    <expenselines_vatcode>0</expenselines_vatcode>
    <expenselines_vatamount>0</expenselines_vatamount>
    <expenselines_workflowcode/>
    <array_expenselineworkflowdescription/>
  </expenseline>
</expenselines>
{
    "responsecode": 1,
    "responsestatus": "OK",
    "errorcode": 0,
    "errormessage": "",
    "totalrows": 1,
    "totalpages": 1,
    "responsemessage": "",
    "pagerows": 0,
    "pagenumber": 1,
    "success": true,
    "data": [
        {
            "array_expenselineapprove": false,
            "expenselines_queryrejectreason": "",
            "array_expenselineattachmentdelete": true,
            "array_expenselineattachmentupload": true,
            "array_expenselineattachmentview": true,
            "array_expenselineclientname": "A Test for Prospect Mail merge",
            "array_expenselinecopy": true,
            "expenselines_currencycode": "1/USD",
            "array_expenselinecurrencydescription": "US Dollars",
            "array_expenselinecurrencysymbol": "$",
            "expenselines_currencytotal": 23,
            "expenselines_currencyrate": 23,
            "expenselines_expensedate": "2014-11-17",
            "array_expenselinedelete": true,
            "expenselines_description": "Miscellaneous ",
            "array_expenselineedit": true,
            "array_expenselineexchangerate": 1.5,
            "array_expenselineheld": false,
            "expenselines_expenselineinternal": 2005,
            "array_expenselinejobdescription": "test team alert",
            "expenselines_jobandphase": "1/00008562.001",
            "array_expenselinejobphasesimple": "8562.001",
            "array_expenselinejobphasestage": 35,
            "array_expenselinejobphasestagedesc": "dqs",
            "array_expenselinejobsimple": "8562",
            "expenselines_linenumber": 1,
            "expenselines_quantity": 1,
            "array_expenselinequery": false,
            "array_expenselinereject": false,
            "array_expenselineresubmit": false,
            "expenselines_statuscode": "S",
            "array_expenselinestatusdisplay": "Unsubmitted",
            "array_expenselinesubmit": false,
            "array_expenselinesubmitted": false,
            "expenselines_resubmitreason": "",
            "expenselines_supplytype": "Miscellaneous ",
            "expenselines_total": 15.33,
            "expenselines_rate": 15.33,
            "array_expenselinevaluesedit": true,
            "expenselines_vatcode": 0,
            "expenselines_vatamount": 0,
            "expenselines_workflowcode": "",
            "array_expenselineworkflowdescription": ""
        }
    ]
}