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 | 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 |