expensesheetlines
Parameter | Type |
---|---|
Company | String |
Action | String |
Input | Date |
Response | XML / 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": ""
}
]
}