-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathresult.sql
More file actions
7 lines (7 loc) · 4.23 KB
/
result.sql
File metadata and controls
7 lines (7 loc) · 4.23 KB
1
2
3
4
5
6
7
INSERT INTO items
(AddConsumptionToCost, AddConsumptionToPurchase, AddHealthyTaxToCost, AddHealthyTaxToPurchase, AddHealthyTaxToSale, AddIVAtoCost, AddSingleUsePlasticTax, AverageCost, BarCode, BrandId, Code, Color, CommissionUnit, CommissionUnit2, CompanyCost, CompanyId, ConsumptionPUCId, ConsumptionPercentage, ConversionFactor, ConversionFactor2, CostPUCId, CreatedBy, CreationDate, DateChangeCommission, Description, DisccountToUnitValue, DiscountPercentage, GiftBag, GramsOfPlastic, HealthyTaxCategory, HealthyTaxPUCId, HealthyTaxValue, INVIMADueDate, INVIMARegister, IVAGiftBag, IVAPurchasePUCId, IVASalePUCId, ImageId, IncomingPUCID, InitialDateCommission, InventoryGroupId, InventoryPUCId, IsDeleted, ItemId, LastCost, LastPurchaseDate, Lot, MeasurementUnit2Id, MeasurementUnit3Id, MeasurementUnitId, MinimumStock, Name, NamePOS, OrderQuantity, PLU, PackagePrice, PercentageICA, PercentagePurchaseIVA, PercentageSaleIVA, PreviousCommission, PriceList1, PriceList10, PriceList2, PriceList3, PriceList4, PriceList5, PriceList6, PriceList7, PriceList8, PriceList9, PriceListA1, PriceListA10, PriceListA2, PriceListA3, PriceListA4, PriceListA5, PriceListA6, PriceListA7, PriceListA8, PriceListA9, PriceListB1, PriceListB10, PriceListB2, PriceListB3, PriceListB4, PriceListB5, PriceListB6, PriceListB7, PriceListB8, PriceListB9, ProviderId, PurchaseIVAId, Reference, SaleIVAId, Serial, SingleUsePlasticTaxPUCId, Size, State, SubInventoryGroup1Id, SubInventoryGroup2Id, SubInventoryGroup3Id, TypeItem, UpdateBy, UpdateDate, ValueCommissionUnit, ValueCommissionUnit2, ValueUnid, ValueUnid2, Weight, WithholdingICA, WithholdingPurchasePercentage, WithholdingSalePercentage, WithholdingTaxPurchasePUCId, WithholdingTaxSalePUCId)
VALUES
(0, 0, 0, 0, 0, 0, 0, 0, null, null, 'PACK-100-EMPL', 0, 0, 0, 0, 1, null, 0, 0, 0, null, 'JOHANNA FLAKER', '2024-01-02 16:53:12', null, 'Pack anual de 51 a 100 empleados en el sistema de nómina de Pymes+©', 0, 0, 0, 0, null, null, null, null, null, 0, 7823, 7796, null, 8716, null, null, 10702, 0, 606, 0, null, 0, null, null, 4, 0, 'PACK 51 -100 EMPLEADOS ANUAL', 'PACK 51 -100 EMPLEADOS ANUAL', 0, null, 0, 0, 0, 0, 0, 890000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, 1, null, 1, 0, null, 0, 'A', null, null, null, 'S', 'JOCELYN ORDOÑEZ', '2024-01-30 09:52:17', 0, 0, 0, 0, 0, 1, '3.5', 0, 7715, 6543),
(0, 0, 0, 0, 0, 0, 0, 0, null, null, 'PACK-200-EMPL', 0, 0, 0, 0, 1, null, 0, 0, 0, null, 'JOHANNA FLAKER', '2024-01-02 16:53:12', null, 'Pack anual de 101 a 200 empleados en el sistema de nómina de Pymes+©', 0, 0, 0, 0, null, null, null, null, null, 0, 7823, 7796, null, 8716, null, null, 10702, 0, 607, 0, null, 0, null, null, 4, 0, 'PACK 101 - 200 EMPLEADOS ANUAL', 'PACK 101 - 200 EMPLEADOS ANUAL', 0, null, 0, 0, 0, 0, 0, 1290000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, 1, null, 1, 0, null, 0, 'A', null, null, null, 'S', 'JOCELYN ORDOÑEZ', '2024-01-30 09:52:44', 0, 0, 0, 0, 0, 1, '3.5', 0, 7715, 6543),
(0, 0, 0, 0, 0, 0, 0, 0, null, null, 'SA-UA-2024', 0, 0, 0, 0, 1, null, 0, 0, 0, null, 'JOHANNA FLAKER', '2024-01-02 16:53:12', null, 'Suscripción a Pymes+© para usuario adicional por 12 meses', 0, 0, 0, 0, null, null, null, null, null, 0, 7823, 7796, null, 8715, null, null, 10702, 0, 604, 0, null, 0, null, null, 4, 0, 'USUARIO ADICIONAL PYMES+©', 'USUARIO ADICIONAL PYMES+©', 0, null, 0, 0, 0, 0, 0, 550000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, 1, null, 1, 0, null, 0, 'A', null, null, null, 'S', 'JOCELYN ORDOÑEZ', '2024-01-30 10:05:20', 0, 0, 0, 0, 0, 1, '3.5', 0, 7715, 6543),
(0, 0, 0, 0, 0, 0, 0, 0, null, null, 'SUC-AD-2024', 0, 0, 0, 0, 1, null, 0, 0, 0, null, 'JOHANNA FLAKER', '2024-01-02 16:53:12', null, 'Sucursal adicional en Pymes+© por 12 meses', 0, 0, 0, 0, null, null, null, null, null, 0, 7823, 7796, null, 8715, null, null, 10702, 0, 605, 0, null, 0, null, null, 4, 0, 'SUCURSAL ADICIONAL EN PYMES+', 'SUCURSAL ADICIONAL EN PYMES+', 0, null, 0, 0, 0, 0, 0, 890000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, null, 1, null, 1, 0, null, 0, 'A', null, null, null, 'S', 'JOCELYN ORDOÑEZ', '2024-01-30 10:04:23', 0, 0, 0, 0, 0, 1, '3.5', 0, 7715, 6543);