Schema Information for Rakuten RMS
Schema Information for Rakuten RMS
In this article, we will look at the schema information of the supported APIs and tables for Rakuten RMS.
Find the links to other articles related to Rakuten RMS below:
Tables/APIs Supported
The tables and APIs associated with the Rakuten RMS connector are as follows.
Purchase_Items
Purpose: The Purchase_Items API retrieves item-level details of products purchased in orders that match specified conditions, supporting order validation, inventory tracking, and reporting.
Source API Documentation: https://webservice.rms.rakuten.co.jp/merchant-portal/view/ja/common/1-1_service_index/purchaseitemapi/
Replication Type: Key Based
Field Name |
Data Type |
| orderNumber | STRING |
| orderProgress | NUMERIC |
| orderDatetime | STRING |
| shopOrderCfmDatetime | STRING |
| orderFixDatetime | STRING |
| shippingInstDatetime | STRING |
| shippingCmplRptDatetime | STRING |
| deliveryDate | STRING |
| giftCheckFlag | NUMERIC |
| isolatedIslandFlag | NUMERIC |
| orderType | NUMERIC |
| goodsPrice | NUMERIC |
| postagePrice | NUMERIC |
| deliveryPrice | NUMERIC |
| paymentCharge | NUMERIC |
| paymentChargeTaxRate | NUMERIC |
| totalPrice | NUMERIC |
| requestPrice | NUMERIC |
| couponAllTotalPrice | NUMERIC |
| couponShopPrice | NUMERIC |
| couponOtherPrice | NUMERIC |
| additionalFeeOccurAmountToUser | NUMERIC |
| additionalFeeOccurAmountToShop | NUMERIC |
| asurakuFlag | NUMERIC |
| drugFlag | NUMERIC |
| dealFlag | NUMERIC |
| deliveryCertPrgFlag | NUMERIC |
| oneDayOperationFlag | NUMERIC |
| OrdererModel | RECORD |
| OrdererModel.prefecture | STRING |
| SettlementModel | RECORD |
| SettlementModel.settlementMethodCode | NUMERIC |
| DeliveryModel | RECORD |
| DeliveryModel.deliveryName | STRING |
| PointModel | RECORD |
| PointModel.usedPoint | NUMERIC |
| PackageModelList | RECORD |
| PackageModelList.basketId | NUMERIC |
| PackageModelList.postagePrice | NUMERIC |
| PackageModelList.postageTaxRate | NUMERIC |
| PackageModelList.deliveryPrice | NUMERIC |
| PackageModelList.deliveryTaxRate | NUMERIC |
| PackageModelList.goodsPrice | NUMERIC |
| PackageModelList.totalPrice | NUMERIC |
| PackageModelList.defaultDeliveryCompanyCode | STRING |
| PackageModelList.ItemModelList | RECORD |
| PackageModelList.ItemModelList.itemDetailId | NUMERIC |
| PackageModelList.ItemModelList.itemName | STRING |
| PackageModelList.ItemModelList.itemId | NUMERIC |
| PackageModelList.ItemModelList.itemNumber | STRING |
| PackageModelList.ItemModelList.manageNumber | STRING |
| PackageModelList.ItemModelList.price | NUMERIC |
| PackageModelList.ItemModelList.units | NUMERIC |
| PackageModelList.ItemModelList.includePostageFlag | NUMERIC |
| PackageModelList.ItemModelList.includeTaxFlag | NUMERIC |
| PackageModelList.ItemModelList.includeCashOnDeliveryPostageFlag | NUMERIC |
| PackageModelList.ItemModelList.inventoryType | NUMERIC |
| PackageModelList.ItemModelList.dealFlag | NUMERIC |
| PackageModelList.ItemModelList.drugFlag | NUMERIC |
| PackageModelList.ItemModelList.taxRate | NUMERIC |
| PackageModelList.ItemModelList.priceTaxIncl | NUMERIC |
| PackageModelList.ItemModelList.isSingleItemShipping | NUMERIC |
| PackageModelList.ItemModelList.SkuModelList | RECORD |
| PackageModelList.ItemModelList.SkuModelList.variantId | STRING |
| PackageModelList.ItemModelList.SkuModelList.merchantDefinedSkuId | STRING |
| TaxSummaryModelList | RECORD |
| TaxSummaryModelList.taxRate | NUMERIC |
| TaxSummaryModelList.reqPrice | NUMERIC |
| TaxSummaryModelList.reqPriceTax | NUMERIC |
| TaxSummaryModelList.totalPrice | NUMERIC |
| TaxSummaryModelList.paymentCharge | NUMERIC |
| TaxSummaryModelList.couponPrice | NUMERIC |
| TaxSummaryModelList.point | NUMERIC |
| shippingTerm | NUMERIC |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |
Inventory
Purpose: The Inventory table in Rakuten RMS retrieves inventory details such as quantity, shipping lead time, and delivery lead time for each SKU
Source API Documentation: https://webservice.rms.rakuten.co.jp/merchant-portal/view/ja/common/1-1_service_index/inventoryapi2_1/inventories_bulk_get_range/
Replication Type: Key Based
Field Name |
Data Type |
| manageNumber | STRING |
| variantId | STRING |
| quantity | NUMERIC |
| shipFromIds | STRING |
| created | TIMESTAMP |
| updated | TIMESTAMP |
| operationLeadTime | RECORD |
| operationLeadTime.normalDeliveryTimeId | NUMERIC |
| _daton_user_id | NUMERIC |
| _daton_batch_runtime | NUMERIC |
| _daton_batch_id | NUMERIC |