| Summary: | E-INVOICING to be implemented before 1-APR-2020 | ||
|---|---|---|---|
| Product: | [01.IMIS] IMIS SALES | Reporter: | kk <kapurk> |
| Component: | IMIS SALES FORMS AND REPORTS | Assignee: | Mahender <mahender.singh> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | sharad.sharma |
| Priority: | Normal | ||
| Version: | unspecified | ||
| Hardware: | All | ||
| OS: | All | ||
| Database: | Module ID: | ||
| Attachments: | e-invoice schema | ||
|
Comment 6
Mahender
2020-03-06 12:32:47 IST
{
"Sale_Invoice":{
"SI_RECID":20000005797050
,"COMPANY":"24"
,"INVOICE_DATE":"2020-02-03T00:00:00Z"
,"INVOICE_TYPE":"I1"
,"INVOICE_SERIES":"TI19"
,"INVOICE_NO":4926
,"Invoice_items":[
{
"ITEM_CODE":"FBPICCCP468G"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FBPICCCP468G"
,"ITEM_NAME":"PICOLO COFFEE CANDY PET JAR (3.6GM X 130) - PROMO SCHEME"
,"NET_PRICE":85.56
,"NO_OF_PACKS":320
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":130
,"INVOICE_VALUE":29278
}
,{
"ITEM_CODE":"FKFASCYJ1K69"
,"STOCK_TYPE":"003"
,"ITEM_CODE":"FKFASCYJ1K69"
,"ITEM_NAME":"FRU KIK ASSORTED JUMBO JAR 3.2 GM (1 jar=530 candy)"
,"NET_PRICE":349.11
,"NO_OF_PACKS":42
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":530
,"INVOICE_VALUE":13093.16
}
,{
"ITEM_CODE":"FMFASJLJ1924"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FMFASJLJ1924"
,"ITEM_NAME":"FRU JELLY ASSORTED JUMBO JAR (3.6gm X 520) - GW"
,"NET_PRICE":342.51
,"NO_OF_PACKS":90
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":520
,"INVOICE_VALUE":27767.34
}
,{
"ITEM_CODE":"FMFASJLP18GM"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FMFASJLP18GM"
,"ITEM_NAME":"ASSORTED FRU POUCH 18G (5 JELLY) - TOY PROMO"
,"NET_PRICE":3.29
,"NO_OF_PACKS":9680
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":5
,"INVOICE_VALUE":31470.53
}
,{
"ITEM_CODE":"FMFGVJLJ740G"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FMFGVJLJ740G"
,"ITEM_NAME":"FRU GUAVA JELLY PET JAR (3.6gm X 200) - GW"
,"NET_PRICE":131.69
,"NO_OF_PACKS":48
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":200
,"INVOICE_VALUE":6162.28
}
,{
"ITEM_CODE":"FMFSWJLJ740G"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FMFSWJLJ740G"
,"ITEM_NAME":"FRU STRAWBERRY JELLY PET JAR (3.6gm X 200) - GW"
,"NET_PRICE":131.69
,"NO_OF_PACKS":72
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":200
,"INVOICE_VALUE":9243.44
}
,{
"ITEM_CODE":"FRFASCYJ2k16"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FRFASCYJ2k16"
,"ITEM_NAME":"FRU RUS ASSORTED JUMBO JAR (01 JAR = 900 CANDY, 01 CANDY = 2.4 GM)"
,"NET_PRICE":296.37
,"NO_OF_PACKS":54
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":450
,"INVOICE_VALUE":14897.18
}
,{
"ITEM_CODE":"FRFKACYJ720G"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FRFKACYJ720G"
,"ITEM_NAME":"FRU RUS KACCHA AAM FLAVOURED CANDY(01 JAR = 300 CANDY, 01 CANDY = 2.4 GM)"
,"NET_PRICE":98.8
,"NO_OF_PACKS":48
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":150
,"INVOICE_VALUE":4414.28
}
,{
"ITEM_CODE":"FRFLECYJ720G"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FRFLECYJ720G"
,"ITEM_NAME":"FRU RUS LEMON FLAVOURED CANDY (01 JAR = 300 CANDY, 01 CANDY = 2.4 GM)"
,"NET_PRICE":98.8
,"NO_OF_PACKS":16
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":150
,"INVOICE_VALUE":1471.43
}
,{
"ITEM_CODE":"FRFORCYJ720G"
,"STOCK_TYPE":"001"
,"ITEM_CODE":"FRFORCYJ720G"
,"ITEM_NAME":"FRU RUS ORANGE FLAVOURED CANDY(01 JAR = 300 CANDY, 01 CANDY = 2.4 GM)"
,"NET_PRICE":98.8
,"NO_OF_PACKS":80
,"TAX_RATE":12
,"MAX_RETAIL_PRICE":150
,"INVOICE_VALUE":7357.12
}
]
}
,"metadata":{
"published_date":"04-FEB-2020"
,"publisher":"oracle-base.com"
}
}
Created attachment 725 [details]
e-invoice schema
see attached schema file. we need to discuss this in detail and start work on this.
|