| Label |
DataType |
Length |
Raw |
Description |
| OrderId |
DT_WSTR |
100 |
False |
|
| ProductId |
DT_WSTR |
255 |
False |
|
| Quantity |
DT_I8 |
0 |
False |
|
| Display |
DT_WSTR |
4000 |
False |
|
| Sku |
DT_WSTR |
255 |
False |
|
| ShortDisplay |
DT_WSTR |
1000 |
False |
|
| SubscriptionId |
DT_WSTR |
88 |
False |
|
| ImageUrl |
DT_WSTR |
1000 |
False |
|
| SubtotalDisplay |
DT_WSTR |
52 |
False |
|
| Subtotal |
DT_R8 |
0 |
False |
|
| SubtotalInPayoutCurrency |
DT_R8 |
0 |
False |
|
| SubtotalInPayoutCurrencyDisplay |
DT_WSTR |
48 |
False |
|
| AttributesPathFrom |
DT_WSTR |
60 |
False |
|
| AttributesPathTo |
DT_WSTR |
60 |
False |
|
| AttributesQuantityFrom |
DT_I8 |
0 |
False |
|
| AttributesQuantityTo |
DT_I8 |
0 |
False |
|
| AttributesDisplay |
DT_WSTR |
2048 |
False |
|
| AttributesTotalChange |
DT_R8 |
0 |
False |
|
| AttributesTotalProratedCharge |
DT_R8 |
0 |
False |
|
| AttributesTotalProratedCredit |
DT_R8 |
0 |
False |
|
| AttributesTotalNetCharge |
DT_R8 |
0 |
False |
|
| AttributesPreviousCharge |
DT_R8 |
0 |
False |
|
| AttributesUpcomingCharge |
DT_R8 |
0 |
False |
|
| AttributesUtilizedPrevious |
DT_R8 |
0 |
False |
|
| AttributesLapsedPrevious |
DT_R8 |
0 |
False |
|
| Discount |
DT_R8 |
0 |
False |
|
| DiscountDisplay |
DT_WSTR |
36 |
False |
|
| DiscountInPayoutCurrency |
DT_R8 |
0 |
False |
|
| DiscountInPayoutCurrencyDisplay |
DT_WSTR |
36 |
False |
|
| IsSubscription |
DT_BOOL |
0 |
False |
|
| ChangeQuantity |
DT_BOOL |
0 |
False |
|
| WithholdingsTaxWithholdings |
DT_BOOL |
0 |
False |
|
| ProratedItemChangeAmount |
DT_R8 |
0 |
False |
|
| ProratedItemChangeAmountDisplay |
DT_WSTR |
28 |
False |
|
| ProratedItemChangeAmountInPayoutCurrency |
DT_R8 |
0 |
False |
|
| ProratedItemChangeAmountInPayoutCurrencyDisplay |
DT_WSTR |
32 |
False |
|
| ProratedItemProratedCharge |
DT_R8 |
0 |
False |
|
| ProratedItemProratedChargeDisplay |
DT_WSTR |
36 |
False |
|
| ProratedItemProratedChargeInPayoutCurrency |
DT_R8 |
0 |
False |
|
| ProratedItemProratedChargeInPayoutCurrencyDisplay |
DT_WSTR |
36 |
False |
|
| ProratedItemCreditAmount |
DT_R8 |
0 |
False |
|
| ProratedItemCreditAmountDisplay |
DT_WSTR |
36 |
False |
|
| ProratedItemCreditAmountInPayoutCurrency |
DT_R8 |
0 |
False |
|
| ProratedItemCreditAmountInPayoutCurrencyDisplay |
DT_WSTR |
36 |
False |
|
| ProratedItemTaxAmount |
DT_R8 |
0 |
False |
|
| ProratedItemTaxAmountDisplay |
DT_WSTR |
24 |
False |
|
| ProratedItemTaxAmountInPayoutCurrency |
DT_R8 |
0 |
False |
|
| ProratedItemTaxAmountInPayoutCurrencyDisplay |
DT_WSTR |
32 |
False |
|
| ProratedItemTotal |
DT_R8 |
0 |
False |
|
| ProratedItemTotalDisplay |
DT_WSTR |
28 |
False |
|
| ProratedItemTotalInPayoutCurrency |
DT_R8 |
0 |
False |
|
| ProratedItemTotalInPayoutCurrencyDisplay |
DT_WSTR |
32 |
False |
|
| AttributesMigratedProductId |
DT_WSTR |
88 |
False |
|
| AttributesClassicProduct |
DT_WSTR |
1068 |
False |
|
| IsAddon |
DT_BOOL |
0 |
False |
|
| Reference |
DT_WSTR |
100 |
False |
|
| BuyerReference |
DT_WSTR |
100 |
False |
|
| IpAddress |
DT_WSTR |
50 |
False |
|
| Completed |
DT_BOOL |
0 |
False |
|
| Changed |
DT_I8 |
0 |
False |
|
| ChangedValue |
DT_I8 |
0 |
False |
|
| ChangedInSeconds |
DT_I8 |
0 |
False |
|
| ChangedDisplay |
DT_WSTR |
50 |
False |
|
| OrderDate |
DT_DBDATE |
0 |
False |
|
| ChangedDisplayEmailEnhancements |
DT_WSTR |
50 |
False |
|
| ChangedDisplayEmailEnhancementsWithTime |
DT_WSTR |
96 |
False |
|
| Language |
DT_WSTR |
8 |
False |
|
| Live |
DT_BOOL |
0 |
False |
|
| Currency |
DT_WSTR |
12 |
False |
|
| PayoutCurrency |
DT_WSTR |
12 |
False |
|
| QuoteId |
DT_WSTR |
1020 |
False |
|
| InvoiceUrl |
DT_WSTR |
440 |
False |
|
| SiteId |
DT_WSTR |
50 |
False |
|
| AccountId |
DT_WSTR |
88 |
False |
|
| Total |
DT_R8 |
0 |
False |
|
| TotalDisplay |
DT_WSTR |
50 |
False |
|
| TotalInPayoutCurrency |
DT_R8 |
0 |
False |
|
| TotalInPayoutCurrencyDisplay |
DT_WSTR |
50 |
False |
|
| Tax |
DT_R8 |
0 |
False |
|
| TaxDisplay |
DT_WSTR |
50 |
False |
|
| TaxInPayoutCurrency |
DT_R8 |
0 |
False |
|
| TaxInPayoutCurrencyDisplay |
DT_WSTR |
50 |
False |
|
| OrderSubtotal |
DT_R8 |
0 |
False |
|
| OrderSubtotalDisplay |
DT_WSTR |
50 |
False |
|
| OrderSubtotalInPayoutCurrency |
DT_R8 |
0 |
False |
|
| OrderSubtotalInPayoutCurrencyDisplay |
DT_WSTR |
50 |
False |
|
| OrderDiscount |
DT_R8 |
0 |
False |
|
| OrderDiscountDisplay |
DT_WSTR |
50 |
False |
|
| OrderDiscountInPayoutCurrency |
DT_R8 |
0 |
False |
|
| OrderDiscountInPayoutCurrencyDisplay |
DT_WSTR |
50 |
False |
|
| OrderDiscountWithTax |
DT_R8 |
0 |
False |
|
| OrderDiscountWithTaxDisplay |
DT_WSTR |
50 |
False |
|
| OrderDiscountWithTaxInPayoutCurrency |
DT_R8 |
0 |
False |
|
| OrderDiscountWithTaxInPayoutCurrencyDisplay |
DT_WSTR |
50 |
False |
|
| BillDescriptor |
DT_WSTR |
50 |
False |
|
| PaymentType |
DT_WSTR |
50 |
False |
|
| PaymentCardEnding |
DT_WSTR |
50 |
False |
|
| CustomerFirst |
DT_WSTR |
50 |
False |
|
| CustomerLast |
DT_WSTR |
50 |
False |
|
| CustomerEmail |
DT_WSTR |
255 |
False |
|
| CustomerCompany |
DT_WSTR |
255 |
False |
|
| CustomerPhone |
DT_WSTR |
100 |
False |
|
| CustomerSubscribed |
DT_BOOL |
0 |
False |
|
| AddressCity |
DT_WSTR |
255 |
False |
|
| AddressRegionCode |
DT_WSTR |
10 |
False |
|
| AddressRegionDisplay |
DT_WSTR |
255 |
False |
|
| AddressRegion |
DT_WSTR |
50 |
False |
|
| AddressPostalCode |
DT_WSTR |
20 |
False |
|
| AddressCountry |
DT_WSTR |
255 |
False |
|
| AddressDisplay |
DT_WSTR |
128 |
False |
|
