Package value fact table
bi_factpackagevalue
Field | Field Type |
|---|---|
Factsegmentwid | BIGINT |
FactSegmentId | bigint |
CenterWID | bigint |
UserWId | bigint |
SaleByWId | bigint |
CloseBywid | bigint |
CreatedByWID | bigint |
OrganizationID | VARCHAR(36) |
ItemTypeWID | bigint |
Itemwid | bigint |
UnitItemType | int -- |
ProductWId | bigint |
ServiceWId | bigint |
PackageRecordType | int |
PackageVersionWId | bigint |
packageuserwid | bigint |
PackageStartDate | timestamp |
PackageEndDate | timestamp |
GracePeriod | timestamp |
Quantity | int |
QuantityRedeemed | int |
SalePrice | float |
Discount | float |
Tax | float |
FinalSalePrice | float |
SaleLiability | float |
PackageIRR | float |
PackagePaymentAmount | float |
ItemPaymentAmount | float |
PackagePaymentAmountTax | float |
ItemPaymentAmountTax | float |
AdjustedPaymentAmount | float |
AdjustedItemPaymentAmount | float |
AdjustedPaymentAmountTax | float |
AdjustedItemPaymentAmountTax | float |
Suspense | float |
PaymentModeNumber | varchar(200) |
PaymentDateTimeInCenter | timestamp |
PaymentDateInCenter | date |
SaleDateTimeInCenter | timestamp |
SaleDateInCenter | date |
ClosedDateTimeInCenter | timestamp |
ClosedDateInCenter | date |
CreatedDateTimeInCenter | timestamp |
CreatedDateInCenter | date |
ItemSalePrice | float |
ItemFinalSalePrice | float |
InvoiceId | VARCHAR(36) |
InvoiceItemId | VARCHAR(36) |
InvoiceStatus | int |
TransactionId | VARCHAR(36) |
PaymentOptionType | varchar(200) |
PackagePaymentType | varchar(200) |
Invoice_No | nvarchar(320) |
RedemptionDate | timestamp |
RedeemedInvoiceItemId | VARCHAR(36) |
ItemSaleByWId | bigint |
ItemDiscount | float |
UnitItemDiscount | nvarchar(256) |
ItemListPrice | float |
ApprovalNumber | nvarchar(512) |
CreditCardLastFourDigits | nvarchar(128) |
PaymentCollectionCenterWID | bigint |
ItemRedemptionCenterWID | bigint |
RefundInvoiceID | VARCHAR(36) |
RefundInvoiceItemID | VARCHAR(36) |
TotalRefundValue | float |
ProductCategoryName | nvarchar(2048) |
ProductCategoryCode | nvarchar(256) |
ProductParentCategoryName | nvarchar(2048) |
ProductParentCategoryCode | nvarchar(256) |
ProductTagName | nvarchar(2048) |
ServiceCategoryName | nvarchar(2048) |
ServiceCategoryCode | nvarchar(256) |
ServiceParentCategoryName | nvarchar(2048) |
ServiceParentCategoryCode | nvarchar(256) |
ServiceTagname | nvarchar(2048) |
IsRevenueRecognized | boolean |
IsFirstPaymentOnPackage | boolean |
ItemLevelApportionFactor | float |
ClassWId | bigint |
ClassCategoryName | nvarchar(2048) |
ClassCategoryCode | nvarchar(256) |
ClassParentCategoryName | nvarchar(2048) |
ClassParentCategoryCode | nvarchar(256) |
ClassTagname | nvarchar(2048) |
BenefitRefundQty | int |
void | boolean |
EtlCreatedBy | bigint |
EtlCreatedDate | timestamp |
podname | VARCHAR(200) |
groupid | bigint |