ADO.NET Provider for Lohaco

Build 21.0.7930

OrderDetails

Retrieve and update information related to order details.

Select

The 本製品 will use the Lohaco API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品. For example, the following query is processed server side:

SELECT * FROM OrderDetails

SELECT * FROM OrderDetails WHERE OrderId = 'orderid'
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Update

Lohaco allows updates. Groupcd should be spefied

Update OrderDetails set OrderStatus = '1', OperationUser = 'test', CancelReason = '110'    Where OrderId = 'L000000045338384'

Columns

Name Type ReadOnly References Description
OrderId [KEY] String False

The id of the product line.

SellerId String False

The Id of the seller.

OperationUser String False

Used on Updates, if updater name is not specified, system is entered.

OrderStatus Integer False

0: Not entered 1: Reserved 2: In process 3: Hold 4: Cancel 5: Complete 8: Wait for consent.

使用できる値は次のとおりです。0, 1, 2, 3, 4, 5, 8

CancelReason Integer False

Cancellation reason code. Order Cancellation - 100: Cancel, 110: Returned, 120: Not Received, 130: Address Unknown, 140: Refuse Receipt, 150 No Connection, 160 Duplicate Order, 170 Payment Unavailable, 180 Others; Store Concerned, 200: Payment Method Concerned, 210: Missing Item, 220: Discontinued, 230: Other.

使用できる値は次のとおりです。110, 120, 130, 140, 150, 160, 170, 180, 200, 210, 220, 230

HistoryId String True

An ID that manages the update history of orders.

AutoDoneDate Date True

This is the scheduled automatic completion date of the order.

FirstOrderDoneDate Date True

The the date order status was first changed to complete.

LastUpdateTime Datetime True

The last modification date of order information.

SendConfirmTime Datetime True

The date and time of sending the order confirmation email sent when the order is newly entered.

SendPayTime Datetime True

The mail transmission date sent at the time of settlement.

PrintSlipTime Datetime False

The date and time when the order slip was output.

PrintDeliveryTime Datetime False

The date and time when we output the invoice.

BuyerComments String False

The comment string displayed by the buyer.

SellerComments String False

The comment string displayed by the store in the store.

Notes String False

A memo in the store when the store is entered with the order management tool.

PayCharge Integer False

The fee set by the store (cash on delivery commission etc.), the settlement fee of Yahoo! settlement is different.

ShipCharge Integer False

Shipping fee.

GiftWrapCharge Integer False

Gift wrapping fee.

Discount Integer False

Discount of the item.

TotalMallCouponDiscount Integer True

Discount amount of the mall coupon.

StoreCouponDiscount Integer True

Discount amount of the store coupon.

Adjustments Integer False

Adjustment of the amount.

UsePoint Integer True

The number of used points.

TotalPrice Integer True

Total price of the order. Product unit price is the unit price after applying coupons when using store coupons.

UsePaypayAmount Integer True

GetPointFixDate Date True

It is a fixed schedule date before confirmation.

IsGetPointFixAll String True

Indicates whether or not the process of finalizing the grant points of all lines (goods) has been completed.

IsLogin Boolean True

Login order.

CustomerCd String True

The customer code.

FspLicenseCd String True

FSP license code. No item: Guest, 'ERR': Acquisition error, '2000': None, '2100': Bronze, '2200': Silver, '2300': Gold, '2400': Platinum, '2500': Diamond.

FspLicenseName String True

FSP license name. No item: Guest, 'ERR': Acquisition error, 'None': None, 'Bronze': Bronze, 'Silver': Silver, 'Gold': Gold, 'Platinum': Platinum, 'Diamond': Diamond.

YjCardStatus String True

YJ Card Membership Status. 0: Non-members and application possible, 1: Application completed and under review, 2: Application completed and shipment in progress, 3: Application completed and card arrived, 4: Invalid 5: Judging NG 6: Withdrawal.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930