ADO.NET Provider for Lohaco

Build 21.0.7930

OrderPayments

Retrieve and update information related to order payments.

Columns

Name Type ReadOnly References Description
OrderId [KEY] String True

The id of the product line.

SellerId String True

The Id of the seller.

PayStatus Integer False

Status of the payment. Possible options are 0 and 1. 0: Not received 1: Paid in.

使用できる値は次のとおりです。0, 1

SettleStatus Integer True

Status of the settlement. Possible options are 1,2,3,4,5,6,7,8,9,10,11. 1: Settlement application 2: Waiting for payment 3: Payment completion 4: Waiting for payment 5: Settlement is completed 6: Cancel 7: Refund 8: Expired 9: Applying for settlement 10: Authorization error 11: Sales cancel.

使用できる値は次のとおりです。1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11

PayMethod String True

Method of the payment. Possible options are payment_a1: Credit card payment payment_a16: Yahoo! Money / Deposit payment, payment_d1: Item cash on delivery, payment_z1: Point full payment, payment_z2: 0 yen settlement, payment_z3: store's own settlement method, payment_z4:PayPay Full payment, payment_a17:PayPay Balance payment.

PayMethodName String True

Apart from the payment method, we have names such as Yahoo! settlement name, bank transfer bank name, postal savings account and so on.

PayActionTime Datetime True

Purchase history detail screen It is the payment update date and time.

PayDate Date False

The payment date that has been entered in the order management tool.

PayNotes String False

The contents of the remarks column of the deposit entered by the order management tool.

SettleId String True

Id of the settlement.

CardPayType Integer True

Type of payment. Possible options are 1:Lump sum payment 2:Bonus lump sum payment 3:Ribbon payment and 4:Installment payment.

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

CardPayCount Integer True

The number of payments in installments.

UseYahooCard Boolean True

An order flag using Yahoo! card for payment.

UseWallet Boolean True

An order flag that use Yahoo! Wallet registration credit card for payment.

NeedDetailedSlip Boolean False

The presence or absence of the desired invoice.

BillFirstName String False

Billing Name.

BillFirstNameKana String False

Billing name (phonetic).

BillLastName String False

Billing surname.

BillLastNameKana String False

Billing surname (phonetic).

BillZipCd String False

Billing Postal Code.

BillPrefecture String False

Billing address. Prefecture 'Overseas' is entered for foreign countries.

BillCity String False

Billing city / county.

BillAddress1 String False

Billing address 1.

BillAddress2 String False

Billing address 2.

BillPhoneNumber String False

Billing phone number.

BillMailAddress String False

The e-mail address entered by the purchaser.

OperationUser String False

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

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