Skip to content

Get Data Documentation Invoice

Jump to bottom
liqian-simit edited this page Sep 2, 2019 · 19 revisions

GET Invoice Data

Required field for calling API
No Field Name Data Type (Size) Required Description
1 document_id varchar(50) Y Backend ID for the sales invoice (* will pick either one between document_id and document_no, document_id will be the first priority)
2 document_no varchar(255) Y Document Number (* will pick either one between document_id and document_no, document_id will be the first priority)
3 bpartner_id varchar(50) Business Partner ID
4 bpartner_no varchar(50) Business Partner No
5 date_from date Sales Invoice date from (document_date)
6 date_to date Sales Invoice date to (document_date)
Sales Invoice Header Data
No Field Name Data Type (Size) Required Description
1 Document ID varchar(50) Y Sales Invoice's document ID
2 Document No varchar(255) Y Sales Invoice's document No
3 Document Type varchar(10) IN : SI, ARDN; OUT : PI, ARCN
4 Document Reference No varchar(255) Sales Invoice's document reference number
5 Document Date date Sales Invoice's document date
6 Document Status varchar(30) Sales Invoice's Status
7 Document Prepared By varchar(50) Sales Invoice's Prepared By
8 Document Description text Sales Invoice's Description
9 Document Note text Sales Invoice's Internal Note
10 Document Reason varchar(255) Sales Invoice's Document Void Reason
11 Document GLMemo varchar(255) Sales Invoice's GL Memo
12 BPartner Name varchar(255) Sales Invoice's business partner name
13 BPartner Account varchar(50) Sales Invoice's business partner account
14 Bill Contact Name varchar(255) Sales Invoice's bill contact name
15 Bill Contact HP varchar(255) Sales Invoice's bill contact handphone number
16 Bill Address Combination of all the bill contact address data
17 Ship Adress Combination of all the ship contact address data
18 Shipping Info varchar(255) Sales Invoice's shipping info
19 Ship Contact Name varchar(255) Sales Invoice's shipping contact name
20 Ship Contact HP varchar(50) Sales Invoice's shipping contact handphone number
21 Delivery Method varchar(50) Sales Invoice's delivery method
22 Delivery Term varchar(50) Sales Invoice's delivery term
23 Total Amount decimal(22,2) Sales Invoice's total amount
24 Total Amount Local decimal(22,2) Sales Invoice's total amount in local currency
25 Total Tax Amount decimal(22,2) Sales Invoice's total tax amount
26 Total Tax Amount Local decimal(22,2) Sales Invoice's total tax amount in local currency
27 Total Nett Amount decimal(22,2) Sales Invoice's total net amount (amt + tax)
28 Total Nett Amount Local decimal(22,2) Sales Invoice's total net amount in local currency
29 Sales Agent varchar(255) Sales Invoice's sales agent
30 Terms Name varchar(255) Sales Invoice's term name
31 Terms Day int(11) Sales Invoice's term day
32 Currency Code varchar(255) Sales Invoice's currency code
33 Currency Rate decimal(14,8) NULL Sales Invoice's currency rate
34 Track Date date [1970-01-01] Sales Invoice's track date
35 Track Type varchar(100) Sales Invoice's track type
36 Track Remark text Sales Invoice's track remark
37 Track Updated datetime Sales Invoice's track last updated date
38 Track Updated By varchar(50) Sales Invoice's track last updated user
39 Track 1 varchar(50) Sales Invoice's Track 1 ID
40 Track 1 Value varchar(200) Sales Invoice's Track 1 Name
41 Track 2 varchar(50) Sales Invoice's Track 2 ID
42 Track 2 Value varchar(255) Sales Invoice's Track 2 Name
43 Track 3 varchar(50) Sales Invoice's Track 3 ID
44 Track 3 Value varchar(255) Sales Invoice's Track 3 Name
45 Track 4 varchar(50) Sales Invoice's Track 4 ID
46 Track 4 Value varchar(255) Sales Invoice's Track 4 Name
47 Track 5 varchar(50) Sales Invoice's Track 5 ID
48 Track 5 Value varchar(255) Sales Invoice's Track 5 Name
49 Is Print smallint(1)
50 Is OP smallint(1) [0]
51 Is Import smallint(1)
52 Import Declaration No text
53 Import Declaration Description text
54 From Order varchar(50) Sales Invoice's generate from document
55 Revision From varchar(50)
56 Filling Date date Sales Invoice's filling Date
57 Filling Date Last Change varchar(50) Sales Invoice's filling Date last updated user
58 Baddebtrelief Batch ID varchar(50)
59 IT Sent Date date
60 IT Type varchar(60)
61 IT Remark text
62 IT Updated datetime
63 IT Updated By varchar(50)
64 Created datetime Sales Invoice's created date in the system
65 Created By varchar(50) Sales Invoice's creator
66 Updated datetime Sales Invoice's last updated date
67 Updated By varchar(50) Sales Invoice's last updated user
68 Organization int(11) Sales Invoice was created under which organization
69 Branch int(11) Sales Invoice was created under which branch
70 Rounding Account ID varchar(50) Sales Invoice's rounding account ID
71 Rounding Amount decimal(22,2) Sales Invoice's rounding amount
72 Outstanding decimal(22,2) Sales Invoice's Outstanding amount
Sales Invoice line data
No Field Name Data Type (Size) Required Description
1 Document Line ID varchar(50) Y Sales Invoice's document line ID
2 Line Seq No smallint(6) Sales Invoice's document line Sequence No
3 Line Description text Sales Invoice's Line description
4 Line Promise Date date Sales Invoice's line promise date
5 Item Code varchar(255) Sales Invoice's line item code
6 Item Name varchar(255) Sales Invoice's line item name
7 Quantity decimal(28,8) Sales Invoice's line item quantity
8 Base Quantity decimal(28,8) Sales Invoice's line item base quantity
9 UOM varchar(255) Sales Invoice's line item UOM
10 Base UOM varchar(255) Sales Invoice's line item base UOM
11 Unit Price decimal(24,4) Sales Invoice's line item unit price
12 Unit Price Local decimal(24,4) Sales Invoice's line item unit price in local currency
13 Discount varchar(255) Sales Invoice's line item discount percentage
14 Discount Amount decimal(24,2) Sales Invoice's line item discount amount
15 Sub Amount decimal(22,2) Sales Invoice's line sub amount (unitprice * quantity)
16 Sub Amount Local decimal(22,2) Sales Invoice's line sub amount in local currency
17 Tax Amount decimal(22,2) Sales Invoice's line tax amount
18 Tax Amount Local decimal(22,2) Sales Invoice's line tax amount in local currency
19 Nett Total decimal(22,2) Sales Invoice's line net total (sub amount + tax amount)
20 Nett Total Local decimal(22,2) Sales Invoice's line net total in local currency
21 Is Inclusive smallint(11) Is Inclusive tax? (Yes/No)
22 Tax Name varchar(255) Sales Invoice's line tax name
23 Tax Rate decimal(10,4) Sales Invoice's line tax rate
24 Tax Account varchar(50) Sales Invoice's line tax account
25 MSIC varchar(30) Sales Invoice's line MSIC code
26 Serial No text NULL Sales Invoice's line item's serial number
27 Batch No varchar(255) Sales Invoice's line item's batch number
28 Lot No varchar(255) Sales Invoice's line item's lot number
29 Location Name varchar(50) Sales Invoice's line item's location name
30 Account varchar(50) [0] Sales Invoice's line account
31 Track 1 varchar(50) Sales Invoice's line track 1
32 Track 2 varchar(50) Sales Invoice's line track 2
33 Track 3 varchar(50) Sales Invoice's line track 3
34 Track 4 varchar(50) Sales Invoice's line track 4
35 Track 5 varchar(50) Sales Invoice's line track 5
36 Custom Field 1 varchar(255) Sales Invoice's line custom field 1
37 Custom Field 2 varchar(255) Sales Invoice's line custom field 2
38 Custom Field 3 varchar(255) Sales Invoice's line custom field 3
39 From Order varchar(50) Sales Invoice's line generate from ID (stock_order table [document_id])
40 From Order Line varchar(50) Sales Invoice's line generate from line ID (stock_orderline table [documentline_id])
41 From Parent varchar(50)
42 Knock Off varchar(50) Sales Invoice's line knock off to's document ID
43 PR Tranfer LIne varchar(50)
44 Created datetime Sales Invoice line's created date in the system
45 Created By varchar(50) Sales Invoice line's creator
46 Updated datetime Sales Invoice line's last updated date
47 Updated By varchar(50) Sales Invoice line's last updated user
48 Is Print smallint(1) [1] Sales Invoice's line is avaliable for printing? (yes/no)
49 Is Remark int(11)
50 Is Tax Variance smallint(1) [0]
51 Is DO 21 Days smallint(1) [0]
52 Line Document No varchar(255)
53 Head Document Line ID varchar(50)
54 Inventory Debit Account varchar(50) Sales Invoice's line item inventory debit account
55 Inventory Credit Account varchar(50) Sales Invoice's line item inventory credit account
56 GST Amount decimal(14,2) Sales Invoice's line item GST amount
57 IM Tax Able Amount decimal(22,2)
58 Tax Updated By varchar(50)
59 Inventory Cost decimal(22,2) NULL Sales Invoice's line inventory cost
60 Landed Cost decimal(22,2) NULL Sales Invoice's line landed cost
61 HS Code varchar(50) Sales Invoice's line item HS code id
62 HS Code Name varchar(50) Sales Invoice's line item HS code name

Sample Data

[getSalesInvoiceData] => Array ( [status] => OK [msg] => OK [data] => Array ( [0] => Array ( [Sales Invoice Header] => Array ( [Document ID] => 1-1-5363 [Document No] => SI 001 [Document Type] => SI [Document Reference No] => [Document Date] => 2019-07-15 [Document Status] => CO [Document Prepared By] => simit [Document Description] => DOCUMENT DESCRIPTION [Document Note] => [Document Reason] => [Document GLMemo] => [BPartner Name] => SIMIT SDN BHD [BPartner Account] => RHB Bank - 001 [Bill Contact Name] => [Bill Conatct HP] => [Bill Address] => 20, Jalan Ekoperniagaan 2/5, Taman Ekoperniagaan, 81100 Johor Bahru, Johor [Ship Address] => 20, Jalan Ekoperniagaan 2/5, Taman Ekoperniagaan, 81100 Johor Bahru, Johor [Shipping Info] => [Ship Contact Name] => [Ship Contact HP] => [Delivery Method] => [Delivery Term] => [Total Amount] => 150360.00 [Total Amount Local] => 150360.00 [Total Tax Amount] => 0.00 [Total Tax Amount Local] => 0.00 [Total Nett Amount] => 150360.00 [Total Nett Amount Local] => 150360.00 [Sales Agent] => [Terms Name] => 30 Days [Terms Day] => 30 [Currency Code] => MYR [Currency Rate] => 1.00000000 [Track Date] => 0000-00-00 [Track Type] => [Track Remark] => [Track Updated] => 0000-00-00 00:00:00 [Track Updated By] => [Track 1] => Foundation Centre [Track 1 Value] => 008 [Track 2] => [Track 2 Value] => [Track 3] => [Track 3 Value] => [Track 4] => [Track 4 Value] => [Track 5] => [Track 5 Value] => [Is Print] => 0 [Is OP] => 0 [Is Import] => 0 [Import Declaration No] => [Import Declaration Description] => [From Order] => [Revision From] => [Filling Date] => 2019-07-15 [Filling Date Last Change] => simit [Baddebtrelief Batch ID] => [IT Sent Date] => 0000-00-00 [IT Type] => [IT Remark] => [IT Updated] => 0000-00-00 00:00:00 [IT Updated By] => [Created] => 2019-07-15 21:59:26 [Created By] => simit [Updated] => 2019-08-01 21:09:08 [Updated By] => simit [Organization] => SIMIT SDN BHD [Branch] => HQ [Rounding Account ID] => [Rounding Amount] => 0.00 [Outstanding] => 150360.00 )

[Sales Invoice Line Details] => Array ( [0] => Array ( [Document Line ID] => 1-1-5363-1563199166053 [Line Seq No] => 10 [Line Description] => DOCUMENT LINE DESCRIPTION [Line Promise Date] => 0000-00-00 [Item Code] => [Item Name] => ITEM B [Quantity] => 24.00000000 [Base Quantity] => 24.00000000 [UOM] => Unit(s) [Base UOM] => Unit(s) [Unit Price] => 6265.0000 [Unit Price Local] => 6265.0000 [Discount] => [Discount Amount] => 0.00 [Sub Amount] => 150360.00 [Sub Amount Local] => 150360.00 [Tax Amount] => 0.00 [Tax Amount Local] => 0.00 [Nett Total] => 150360.00 [Nett Total Local] => 150360.00 [Is Inclusive] => 0 [Tax Name] => [Tax Rate] => 0.0000 [Tax Account] => DEFERRED REVENUE [MSIC] => [Serial No] => [Batch No] => [Lot No] => [Location Name] => [Account] => DEFERRED REVENUE [Track 1] => Foundation Centre [Track 2] => [Track 3] => [Track 4] => [Track 5] => [Custom Field 1] => [Custom Field 2] => [Custom Field 3] => [From Order] => [From Order Line] => [From Parent] => [Knock Off] => [PR_Tranfer_Line] => [Created] => 2019-07-15 21:59:26 [Created By] => simit [Updated] => 2019-08-01 21:09:08 [Updated By] => simit [Is Print] => 0 [Is Remark] => 0 [Is Tax Variance] => 0 [Is DO 21 Days] => 0 [Line Document No] => [Head Document Line ID] => [Inventory Debit Account] => [Inventory Credit Account] => [GST Amount] => 0.00 [IM Tax Able Amount] => 0.00 [Tax Updated By] => [Inventory Cost] => 0.00 [Landed Cost] => 0.00 [HS Code] => [HS Code Name] => )

                            )

                    )

            )

    )

Clone this wiki locally