-
Notifications
You must be signed in to change notification settings - Fork 2
Get Debtors Aging Detail
seansimit edited this page May 12, 2022
·
1 revision
Using CURL in terminal console to retrieve the Debtors Aging Detail. (* If there is no data in the data column, user may direct remove the column from the get data array.)
{yourtoken} : Get your Token here
curl --header "Content-Type: application/x-www-form-urlencoded" \
--request POST \
--data '
{
"action":"getDebtorsAgingDetail",
"module":"accounting",
"token":"{yourtoken}",
"uid":"{youruid}",
"org":"{yourorg}",
"branch":"{yourbranch}",
"data":
{
"till date":"2022-04-29"
}
}
' \
https://simbiz_system_url/simbiz/api.php
The available field for retrieve Debtors Aging Detail Data (same as simbiz Debtors Aging Detail Report) Required field for calling API
| No | Field Name | Data Type (Size) | Required | Description |
|---|---|---|---|---|
| 1 | till date | date (YYYY-mm-dd) | Till date for transaction, if empty will auto set as today | |
| 2 | currency code | varchar(3) | Transaction currency code | |
| 3 | accounts code | varchar(50) | Account Code | |
| 4 | bpartner no | varchar(50) | Business Partner No | |
| 5 | bpartnergroup code | varchar(50) | Business Partner Group | |
| 6 | industry code | varchar(50) | Industry Code | |
| 7 | salesagent no | varchar(50) | Sales Agent | |
| 8 | agentfiltertype | varchar(10) | access Value (bytrans or bybpartner) The sales agent filter capture from document or Business Partner. Default by business partner. |
Debtors Aging Detail Data
| No | Field Name | Data Type (Size) | Required | Description |
|---|---|---|---|---|
| 1 | Document Id | varchar(50) | Backend id for the document | |
| 2 | Document No | varchar(255) | Document No | |
| 3 | Document Type | varchar(10) | Document Type | |
| 4 | Document Reference No | varchar(255) | Document Reference No | |
| 5 | Document Date | date(YYYY-mm-dd) | Document Date | |
| 6 | Sales Agent | varchar(50) | Document Sales Agent | |
| 7 | Customer Sales Agent | varchar(50) | Business Partner Sales Agent | |
| 8 | Sales Limit | decimal(12,2) | Business Partner Sales Limit | |
| 9 | Document Currency | varchar(3) | Document Currency | |
| 10 | Terms Code | varchar(50） | Document Terms Code | |
| 11 | Terms Day | int(11) | Document Terms Day | |
| 12 | Due Date | date(YYYY-mm-dd) | Document due date (document date + terms day) | |
| 13 | Customer Id | varchar(50) | Backend id for the Business Partner | |
| 14 | Customer Name | varchar(255) | Business Partner Name | |
| 15 | Customer No | varchar(50) | Business Partner No | |
| 16 | Customer Terms Code | varchar(50) | Business Partner Terms Code | |
| 17 | Customer Terms Day | varchar(50) | Business Partner Terms Day | |
| 18 | Over Due Days | date(YYYY-mm-dd) | Over due days (untill filter till date) | |
| 19 | Contact Tel | varchar(20) | Business Partner contact Tel | |
| 20 | Contact Name | varchar(60) | Business Partner contact name | |
| 21 | Contact Fax | varchar(20) | Business Partner Contact Fax | |
| 22 | Address Tel1 | varchar(255) | Business Partner Address Tel1 | |
| 23 | Address Tel2 | varchar(255) | Business Partner Address Tel2 | |
| 24 | Address | varchar(255) | Business Partner Address | |
| 25 | Billaddress Country | varchar(50) | Business Partner Billaddress Country | |
| 26 | Billaddress Area | varchar(50) | Business Partner Billaddress Area | |
| 27 | Industry Name | varchar(50) | Business Partner Industry Name | |
| 28 | Total Balance Amount | decimal(22,2) | Total over due balance amount | |
| 29 | Total Balance Amount Local | decimal(22,2) | Total over due balance amount Local (show only when filter currency) | |
| 30 | Transaction Amount | decimal(22,2) | Document Transaction Amount | |
| 31 | Current Month | decimal(22,2) | Current Month Amount | |
| 32 | 1 Months | decimal(22,2) | Over due 1 Months Amount | |
| 33 | 2 Months | decimal(22,2) | Over due 2 Months Amount | |
| 34 | 3 Months | decimal(22,2) | Over due 3 Months Amount | |
| 35 | 4 Months | decimal(22,2) | Over due 4 Months Amount | |
| 36 | 5 Months | decimal(22,2) | Over due 5 Months Amount | |
| 37 | 6 Months | decimal(22,2) | Over due 6 Months Amount | |
| 38 | 7 Months | decimal(22,2) | Over due 7 Months Amount | |
| 39 | 8 Months | decimal(22,2) | Over due 8 Months Amount | |
| 40 | 9 Months | decimal(22,2) | Over due 9 Months Amount | |
| 41 | 10 Months | decimal(22,2) | Over due 10 Months Amount | |
| 42 | 11 Months | decimal(22,2) | Over due 11 Months Amount | |
| 43 | 12 Months | decimal(22,2) | Over due 12 Months Amount | |
| 44 | Over 12 Months | decimal(22,2) | Over due over 12 Months Amount |
{
"status": "OK",
"msg": "",
"data": {
"S01": {
"Customer Id": "1-1-1",
"Customer Name": "SIMIT SDN BHD",
"Customer No": "S01",
"Default Sales Agent": "",
"Customer Terms Code": "120D",
"Customer Terms Day": "120",
"Contact Tel": "",
"Contact Name": "",
"Contact Fax": "",
"Address Tel1": "",
"Address Tel2": "",
"Address": "",
"Billaddress Country": "",
"Billaddress Area": "",
"Sales Limit": "0.00",
"Industry Name": ,
"Total Balance Amount": "2060.00",
"Total Balance Amount Local": "2060.00",
"data": {
[
{
"Document Id": "1-1-1",
"Document No": "SI 00001",
"Document Type": "SI",
"Document Reference No": "",
"Document Date": "2019-04-30",
"Transaction Sales Agent": "",
"Document Currency": "MYR",
"Terms Code": "120D",
"Terms Day": "120",
"Due Date": "2019-08-28",
"Over Due Days": "876",
"Transaction Amount": "2060.00",
"Current Month": "0.00",
"1 Months": "0.00",
"2 Months": "0.00",
"3 Months": "0.00",
"4 Months": "0.00",
"5 Months": "0.00",
"6 Months": "0.00",
"7 Months": "0.00",
"8 Months": "0.00",
"9 Months": "0.00",
"10 Months": "0.00",
"11 Months": "0.00",
"12 Months": "0.00",
"Over 12 Months": "2060.00"
}
]
}
}
}
}