Package value fact table
Bi_FactPackageValue_s3
Field | Field type | |
|---|---|---|
FactSegmentId | BIGINT | |
CenterId | VARCHAR(36) | |
UserId | VARCHAR(36) | |
SaleById | VARCHAR(36) | |
ClosedBy | VARCHAR(36) | |
CreatedBy | VARCHAR(36) | |
OrganizationID | VARCHAR(36) | |
ItemType | INT | |
Itemid | VARCHAR(36) | |
UnitItemType | INT | |
ProductId | VARCHAR(36) | |
ServiceId | VARCHAR(36) | |
PackageRecordType | INT | |
PackageVersionId | VARCHAR(36) | |
PackageUserId | VARCHAR(36) | |
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) | |
ItemSaleByEmployeeId | VARCHAR(36) | |
ItemDiscount | FLOAT | |
UnitItemDiscount | NVARCHAR(256) | |
ItemListPrice | FLOAT | |
ApprovalNumber | NVARCHAR(512) | |
CreditCardLastFourDigits | NVARCHAR(64) | |
PaymentCollectionCenterID | VARCHAR(36) | |
ItemRedemptionCenterID | VARCHAR(36) | |
RefundInvoiceID | VARCHAR(36) | |
RefundInvoiceItemID | VARCHAR(36) | |
TotalRefundValue | FLOAT | |
ProductCategoryName | NVARCHAR(2048) | |
ProductCategoryCode | NVARCHAR(256) | |
ProductParentCategoryName | NVARCHAR(2048) | |
ProductParentCategoryCode | NVARCHAR(256) | |
ProductTagName | NVARCHAR(2040) | |
ServiceCategoryName | NVARCHAR(2048) | |
ServiceCategoryCode | NVARCHAR(256) | |
ServiceParentCategoryName | NVARCHAR(2048) | |
ServiceParentCategoryCode | NVARCHAR(256) | |
ServiceTagname | NVARCHAR(2040) | |
IsRevenueRecognized | BOOLEAN | |
IsFirstPaymentOnPackage | BOOLEAN | |
ItemLevelApportionFactor | FLOAT | |
PackageClassId | VARCHAR(36) | |
ClassCategoryName | NVARCHAR(1024) | |
ClassCategoryCode | NVARCHAR(200) | |
ClassParentCategoryName | NVARCHAR(1024) | |
ClassParentCategoryCode | NVARCHAR(200) | |
ClassTagname | NVARCHAR(1020) | |
BenefitRefundQty | INT | |
PodName | VARCHAR(20) | |
Void | BOOLEAN | |
groupid | BIGINT | |
EtlCreatedDate | TIMESTAMP | |
EtlCreatedBy | BIGINT | |
LPRedemption | float | |
SaleLiabilityExclLPRedemption | float | |
SuspenseExclLPRedemption | float |