|
Id
|
integer
|
|
|
|
|
|
BatchId
|
integer
|
|
N
|
|
|
|
Solicitor
|
string
|
|
N
|
|
|
| FK: T_METUSER.userid Resource: Users |
|
OrderDateTime
|
date
|
|
N
|
|
|
|
HoldUntilDateTime
|
date
|
|
N
|
|
|
|
TotalPurchaseAmount
|
decimal number
|
|
N
|
|
|
|
TotalReturnAmount
|
decimal number
|
|
N
|
|
|
|
TotalContributionAmount
|
decimal number
|
|
N
|
|
|
|
TotalContributionPaidAmount
|
decimal number
|
|
N
|
|
|
|
TotalFeeAmount
|
decimal number
|
|
N
|
|
|
|
TotalFeePaidAmount
|
decimal number
|
|
N
|
|
|
|
TotalDueAmount
|
decimal number
|
|
N
|
|
|
|
TotalPaidAmount
|
decimal number
|
|
|
|
|
|
AddressId
|
integer
|
|
N
|
|
|
| FK: T_ADDRESS.address_no Resource: Addresses |
|
PhoneId
|
integer
|
|
N
|
|
|
| FK: T_PHONE.phone_no Resource: Phones |
|
BookingId
|
integer
|
|
N
|
|
|
| FK: T_BOOKING.booking_id Resource: Bookings |
|
ElectronicAddressId
|
integer
|
|
N
|
|
|
|
OrderNotes
|
string
|
|
N
|
|
|
|
CustomDataItems
|
Collection of CustomDataItem
|
|
|
|
|
|
DeliveryMethod
|
EntitySummary
|
|
N
|
|
|
| FK: TR_ORDER_SHIP_METHOD. Resource: DeliveryMethods |
|
BusinessUnit
|
EntitySummary
|
|
N
|
|
|
| FK: TR_BU. Resource: BusinessUnits |
|
Category
|
EntitySummary
|
|
N
|
|
|
| FK: TR_ORDER_CATEGORY. Resource: OrderCategories |
|
Constituent
|
ConstituentDisplaySummary
|
|
N
|
|
|
| FK: T_CUSTOMER.customer_no Resource: Constituents |
|
Initiator
|
ConstituentDisplaySummary
|
|
N
|
|
|
| FK: T_CUSTOMER.customer_no Resource: Constituents |
|
ModeOfSale
|
EntitySummary
|
|
N
|
|
|
| FK: TR_MOS.id Resource: ModesOfSale |
|
Source
|
EntitySummary
|
|
N
|
|
|
| FK: TX_APPEAL_MEDIA_TYPE.source_no Resource: Sources |
|
Appeal
|
EntitySummary
|
|
N
|
|
|
| FK: T_APPEAL.appeal_no Resource: Appeals |
|
PaymentPlans
|
Collection of OrderProductViewPaymentPlan
|
|
N
|
|
|
|
OrderFees
|
Collection of OrderProductViewFeeDetail
|
|
N
|
|
|
|
Payments
|
Collection of OrderProductViewPayment
|
|
N
|
|
|
|
Messages
|
Collection of PricingRuleMessage
|
|
N
|
|
|
|
Products
|
Collection of OrderProductViewProduct
|
|
N
|
|
|