| Required permission: | CustomerInvoice-Transaction.GET |
| GET | /CustomerInvoices/GST/SGP/Currency/simple | ||
|---|---|---|---|
| GET | /CustomerInvoices/GST/SGP/Currency/simple/page/{Page} | Get records by given a page number | Each page consists of 20 records |
| GET | /CustomerInvoices/GST/SGP/Currency/simple/Invoice/{AcCusInvoiceMID} | Get a record by given a Document Number | Header and Detail record would be return if found. |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Page | path | int? | No | |
| AcCusInvoiceMID | path | string | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Invoices | form | List<CustomerInvoiceSimple_GST_SGP_Currency> | No | |
| ResponseStatus | form | ResponseStatus | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| DocumentHeader | form | AcCusInvoiceMSimple_GST_SGP_Currency | No | |
| DocumentDetails | form | List<AcCusInvoiceDSimple_GST_SGP_Currency> | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| AcCusInvoiceMID | form | NVARCHAR(20) | Yes | Invoice Number |
| AcCustomerID | form | NVARCHAR(20) | Yes | Customer ID |
| AcSalesmanID | form | NVARCHAR(20) | No | Salesman ID. Default to customer's salesman if not specified |
| AcLocationID | form | NVARCHAR(20) | Yes | Location ID |
| DocumentDate | form | DATE | Yes | Invoice Date |
| DocumentNetAmount | form | NUMERIC(18,2) | Yes | Net Amount. Before Round Cent Adjustment |
| DocumentCentBalance | form | NUMERIC(18,2) | Yes | Round Cent Adjustment Amount |
| DocumentFinalAmount | form | NUMERIC(18,2) | Yes | Final Amount. After Round Cent Adjustment |
| RefDocumentNo | form | NVARCHAR(100) | No | Reference Number |
| DocumentRemark | form | NVARCHAR(100) | No | Document Remark |
| ExtraRemark1 | form | NVARCHAR(100) | No | Extra Remark 1 |
| ExtraRemark2 | form | NVARCHAR(100) | No | Extra Remark 2 |
| ExtraRemark3 | form | NVARCHAR(100) | No | Extra Remark 3 |
| ExtraRemark4 | form | NVARCHAR(100) | No | Extra Remark 4 |
| DocumentYourReference | form | NVARCHAR(50) | No | Your Reference |
| ShipToRemark | form | NVARCHAR(100) | No | Ship To: Remark |
| ShipToShipVia | form | NVARCHAR(20) | No | Ship To: Ship Via |
| ShipToAddress1 | form | NVARCHAR(MAX) | No | Ship To: Address 1 |
| ShipToAddress2 | form | NVARCHAR(100) | No | Ship To: Address 2 |
| ShipToAddress3 | form | NVARCHAR(100) | No | Ship To: Address 3 |
| ShipToAddress4 | form | NVARCHAR(100) | No | Ship To: Address 4 |
| ShipToPhone1 | form | NVARCHAR(100) | No | Ship To: Phone 1 |
| ShipToPhone2 | form | NVARCHAR(100) | No | Ship To: Phone 1 |
| ShipToFax | form | NVARCHAR(100) | No | Ship To: Fax |
| ShipToContact1 | form | NVARCHAR(100) | No | Ship To: Contact 1 |
| ShipToContact2 | form | NVARCHAR(100) | No | Ship To: Contact 2 |
| ShipToAttention | form | NVARCHAR(100) | No | Ship To: Attention |
| IsEnableGST | form | NVARCHAR(1) | Yes | Is Enable GST (Y/N). SGP GST Indicator |
| DocumentItemGSTAmount | form | NUMERIC(18,6) | No | Total GST Amount (System Calculated based on Items Given) |
| DocumentItemGrossTotal | form | NUMERIC(18,2) | No | Gross Total Without GST (System Calculated based on Items Given) |
| DocumentItemDiscountTotal | form | NUMERIC(18,2) | No | Discount Total Without GST (System Calculated based on Items Given) |
| DocumentItemTotalPrice | form | NUMERIC(18,2) | No | Total Without GST (System Calculated based on Items Given) |
| DocumentItemGrossTotalWithGST | form | NUMERIC(18,6) | No | Gross Total With GST (System Calculated based on Items Given) |
| DocumentItemDiscountAmountWithGST | form | NUMERIC(18,2) | No | Discount With GST (System Calculated based on Items Given) |
| DocumentItemTotalPriceWithGST | form | NUMERIC(18,2) | No | Total With GST (System Calculated based on Items Given) |
| DocumentItemGrossTotalWithoutGST | form | NUMERIC(18,6) | No | Gross Total Without GST (System Calculated based on Items Given) |
| DocumentItemDiscountAmountWithoutGST | form | NUMERIC(18,2) | No | Discount Without GST (System Calculated based on Items Given) |
| DocumentItemTotalPriceWithoutGST | form | NUMERIC(18,2) | No | Total Without GST (System Calculated based on Items Given) |
| AcCurrencyID | form | NVARCHAR(5) | Yes | Currency ID. Default to home currency eg: MYR |
| CurrencyRate | form | NUMERIC(18,6) | Yes | Currency Rate. Default to 1 |
| DocumentLocalItemTotalPrice | form | NUMERIC(18,2) | Yes | Total of detail.ItemTotalPrice in Local Currency |
| DocumentLocalDiscountAmount | form | NUMERIC(18,2) | Yes | Document Discount Amount in Local Currency. Always 0 |
| DocumentItemLocalGSTAmount | form | NUMERIC(18,2) | Yes | Total GST Amount in Local Currency (System Calculated based on Items Given) |
| DocumentLocalItemGrossTotal | form | NUMERIC(18,2) | Yes | Total of detail.ItemGrossTotal in Local Currency |
| DocumentLocalItemGrossTotalWithGST | form | NUMERIC(18,2) | Yes | Total of detail.ItemGrossTotal in Local Currency |
| DocumentLocalItemGrossTotalWithoutGST | form | NUMERIC(18,2) | Yes | Total of detail.ItemGrossTotal in Local Currency |
| DocumentLocalItemDiscountTotalWithGST | form | NUMERIC(18,2) | Yes | Total of detail.ItemDiscountAmount in Local Currency |
| DocumentLocalItemDiscountTotalWithoutGST | form | NUMERIC(18,2) | Yes | Total of detail.ItemDiscountAmount in Local Currency |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| AcCusInvoiceMID | form | NVARCHAR(20) | Yes | Invoice Number |
| ItemNo | form | INT | Yes | Item Number |
| AcStockID | form | NVARCHAR(20) | Yes | Stock ID |
| AcStockUOMID | form | NVARCHAR(20) | Yes | Stock UOM ID |
| ItemUnitPrice | form | NUMERIC(18,4) | Yes | Item Unit Price (Tax Exclusive Price) |
| ItemQuantity | form | NUMERIC(18,4) | Yes | Item Quantity |
| ItemGrossTotal | form | NUMERIC(18,2) | Yes | Item Gross Total (Tax Exlusive). [Item Unit Price] x [Item Quantity] |
| ItemDiscountAmount | form | NUMERIC(18,2) | Yes | Item Discount Amount (Discount given based on Tax Exclusive Gross Total) |
| AcTaxID | form | NVARCHAR(20) | No | Tax Code. SGP GST Tax Codes Only |
| ItemGSTPercent | form | NUMERIC(18,2) | Yes | Tax Rate. |
| ItemGSTAmount | form | NUMERIC(18,6) | Yes | Tax Amount |
| ItemTotalPrice | form | NUMERIC(18,2) | Yes | Item Total Price. [(Unit Price x Quantity) - Discount Amount - Tax Amount] |
| ItemRemark1 | form | NVARCHAR(MAX) | Yes | Item Remark 1 |
| ItemIsGSTInclusive | form | NVARCHAR(1) | Yes | Item Unit Price is GST Inclusive? (Y/N) |
| ItemUnitPriceInput | form | NUMERIC(18,4) | Yes | Item Unit Price Input (If ItemIsGSTInclusive = Y, provide Unit Price with Tax Inclusive; If ItemIsGSTInclusive = Y, provide Unit Price with Tax Exclusive ) |
| ItemUnitPriceWithGST | form | NUMERIC(18,6) | Yes | Item Unit Price (Tax Inclusive) |
| ItemGrossTotalWithGST | form | NUMERIC(18,6) | Yes | Item Gross Total (Tax Inclusive), [ItemUnitPriceWithGST] x [Quantity] |
| ItemDiscountAmountWithGST | form | NUMERIC(18,2) | Yes | Item Discount Amount (Tax Inclusive). (Discount given based on Tax Inclusive Gross Total) |
| ItemTotalPriceWithGST | form | NUMERIC(18,2) | Yes | Item Total Price. (Tax Inclusive) |
| ItemUnitPriceWithoutGST | form | NUMERIC(18,6) | Yes | Item Unit Price (Tax Exclusive) |
| ItemGrossTotalWithoutGST | form | NUMERIC(18,6) | Yes | Item Gross Total (Tax Exclusive), [ItemUnitPriceWithoutGST] x [Quantity] |
| ItemDiscountAmountWithoutGST | form | NUMERIC(18,2) | Yes | Item Discount Amount (Tax Exclusive). (Discount given based on Tax Exclusive Gross Total) |
| ItemTotalPriceWithoutGST | form | NUMERIC(18,2) | Yes | Item Total Price. (Tax Exclusive) |
| MatchIsActive | form | NVARCHAR(1) | Yes | Match Is Active. (Y/N). Default to N. If Y, please provide MatchType;MatchDocumentNo;MatchItemNo |
| MatchType | form | NVARCHAR(20) | No | Match Document Type. Valid Value: Sales Order; Delivery Order |
| MatchDocumentNo | form | NVARCHAR(20) | No | Match Document Number. |
| MatchItemNo | form | INT | Yes | Match Document Item Number. |
| ItemLocalGrossTotal | form | NUMERIC(18,2) | Yes | Item Gross Total in Local Currency. |
| ItemLocalDiscountAmount | form | NUMERIC(18,2) | Yes | Item Discount Amount in Local Currency. |
| ItemLocalTotalPrice | form | NUMERIC(18,2) | Yes | Item Total Amount in Local Currency. |
| ItemLocalGSTAmount | form | NUMERIC(18,2) | Yes | Item Tax Amount in Local Currency |
| ItemLocalGrossTotalWithGST | form | NUMERIC(18,2) | Yes | Item Gross Total with Tax Inclusive in Local Currency |
| ItemLocalGrossTotalWithoutGST | form | NUMERIC(18,2) | Yes | Item Gross Total without Tax Inclusive in Local Currency |
| ItemLocalDiscountAmountWithGST | form | NUMERIC(18,2) | Yes | Item Discount Amount with Tax Inclusive in Local Currency |
| ItemLocalDiscountAmountWithoutGST | form | NUMERIC(18,2) | Yes | Item Discount Amount without Tax Inclusive in Local Currency |
| ItemLocalTotalPriceWithGST | form | NUMERIC(18,2) | Yes | Item Total Amount with Tax Inclusive in Local Currency |
| ItemLocalTotalPriceWithoutGST | form | NUMERIC(18,2) | Yes | Item Total Amount without Tax Inclusive in Local Currency |
To override the Content-type in your clients, use the HTTP Accept Header, append the .json suffix or ?format=json
To embed the response in a jsonp callback, append ?callback=myCallback
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
GET /CustomerInvoices/GST/SGP/Currency/simple HTTP/1.1 Host: snr2u.com Accept: application/json
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length
{"Invoices":[{"DocumentHeader":{"AcCusInvoiceMID":"String","AcCustomerID":"String","AcSalesmanID":"String","AcLocationID":"String","DocumentDate":"\/Date(-62135596800000-0000)\/","DocumentNetAmount":0,"DocumentCentBalance":0,"DocumentFinalAmount":0,"RefDocumentNo":"String","DocumentRemark":"String","ExtraRemark1":"String","ExtraRemark2":"String","ExtraRemark3":"String","ExtraRemark4":"String","DocumentYourReference":"String","ShipToRemark":"String","ShipToShipVia":"String","ShipToAddress1":"String","ShipToAddress2":"String","ShipToAddress3":"String","ShipToAddress4":"String","ShipToPhone1":"String","ShipToPhone2":"String","ShipToFax":"String","ShipToContact1":"String","ShipToContact2":"String","ShipToAttention":"String","IsEnableGST":"String","DocumentItemGSTAmount":0,"DocumentItemGrossTotal":0,"DocumentItemDiscountTotal":0,"DocumentItemTotalPrice":0,"DocumentItemGrossTotalWithGST":0,"DocumentItemDiscountAmountWithGST":0,"DocumentItemTotalPriceWithGST":0,"DocumentItemGrossTotalWithoutGST":0,"DocumentItemDiscountAmountWithoutGST":0,"DocumentItemTotalPriceWithoutGST":0,"AcCurrencyID":"String","CurrencyRate":0,"DocumentLocalItemTotalPrice":0,"DocumentLocalDiscountAmount":0,"DocumentItemLocalGSTAmount":0,"DocumentLocalItemGrossTotal":0,"DocumentLocalItemGrossTotalWithGST":0,"DocumentLocalItemGrossTotalWithoutGST":0,"DocumentLocalItemDiscountTotalWithGST":0,"DocumentLocalItemDiscountTotalWithoutGST":0},"DocumentDetails":[{"AcCusInvoiceMID":"String","ItemNo":0,"AcStockID":"String","AcStockUOMID":"String","ItemUnitPrice":0,"ItemQuantity":0,"ItemGrossTotal":0,"ItemDiscountAmount":0,"AcTaxID":"String","ItemGSTPercent":0,"ItemGSTAmount":0,"ItemTotalPrice":0,"ItemRemark1":"String","ItemIsGSTInclusive":"String","ItemUnitPriceInput":0,"ItemUnitPriceWithGST":0,"ItemGrossTotalWithGST":0,"ItemDiscountAmountWithGST":0,"ItemTotalPriceWithGST":0,"ItemUnitPriceWithoutGST":0,"ItemGrossTotalWithoutGST":0,"ItemDiscountAmountWithoutGST":0,"ItemTotalPriceWithoutGST":0,"MatchIsActive":"String","MatchType":"String","MatchDocumentNo":"String","MatchItemNo":0,"ItemLocalGrossTotal":0,"ItemLocalDiscountAmount":0,"ItemLocalTotalPrice":0,"ItemLocalGSTAmount":0,"ItemLocalGrossTotalWithGST":0,"ItemLocalGrossTotalWithoutGST":0,"ItemLocalDiscountAmountWithGST":0,"ItemLocalDiscountAmountWithoutGST":0,"ItemLocalTotalPriceWithGST":0,"ItemLocalTotalPriceWithoutGST":0}]}],"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}}}