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 | This indicates whether the invoice is open or closed. Hardcoded values: 4 indicates a closed invoice. Else, it is an open invoice. | 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 | |
LPRedemption | float | |
SaleLiabilityExclLPRedemption | float | |
SuspenseExclLPRedemption | float |