OrderDetails
Generated schema file.
Columns
| Name | Type | References | |
| UniqueKey | String |
Orders.UniqueKey | |
| Ordered | Datetime | ||
| Cancelled | String | ||
| Dispatched | Datetime | ||
| Payment | String | ||
| ShippingMethod | String | ||
| ShippingFee | Integer | ||
| CodFee | Decimal | ||
| Total | Decimal | ||
| FirstName | String | ||
| LastName | String | ||
| Country | String | ||
| ZipCode | String | ||
| Prefecture | String | ||
| Address | String | ||
| Address2 | String | ||
| MailAddress | String | ||
| Tel | String | ||
| Remark | String | ||
| AddComment | String | ||
| DeliveryCompanyId | Integer | ||
| TrackingNumber | String | ||
| DeliveryDate | Date | ||
| DeliveryTimeZone | String | ||
| Terminated | Boolean | ||
| DispatchStatus | String | ||
| Modified | Datetime | ||
| OrderReceiverFirstName | String | ||
| OrderReceiverLastName | String | ||
| OrderReceiverZipCode | String | ||
| OrderReceiverPrefecture | String | ||
| OrderReceiverAddress | String | ||
| OrderReceiverAddress2 | String | ||
| OrderReceiverTel | String | ||
| OrderDiscountDiscount | Decimal | ||
| OrderDiscountNote | String | ||
| OrderDiscountIsAllocateUserBalanceLog | Integer | ||
| OrderAmountAdjustmentAdjustedAmount | Decimal | ||
| OrderHeaderCoinDiscount | Decimal | ||
| OrderHeaderCoinNote | String | ||
| OrderChargeCollectedFee | Decimal | ||
| CCPaymentTransactionCollectedFee | Decimal | ||
| CCPaymentTransactionStatus | String | ||
| CvsPaymentTransactionCollectedFee | Decimal | ||
| CvsPaymentTransactionStatus | String | ||
| BtPaymentTransactionCollectedFee | Decimal | ||
| BtPaymentTransactionStatus | String | ||
| AtobaraiPaymentTransactionCollectedFee | Decimal | ||
| AtobaraiPaymentTransactionStatus | String | ||
| CarrierPaymentTransactionCollectedFee | Decimal | ||
| CarrierPaymentTransactionStatus | String | ||
| PaypalPaymentTransactionCollectedFee | Decimal | ||
| PaypalPaymentTransactionStatus | String | ||
| CoinPaymentTransactionCollectedFee | Decimal | ||
| CoinPaymentTransactionStatus | String | ||
| UserBalanceLogs | String | ||
| OrderItems | String | ||
| SubscriptionUniqueKey | String | ||
| SubscriptionRepeatNumber | Integer | ||
| SubscriptionRepeatTimes | Integer |