Inicio Explorar Axuda
Iniciar sesión
paul
/
gps.docker
1
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Árbore: 171bbf76d0
Ramas Etiquetas
gps.docker
/
daldb
/
SeedData
/
AlexisReadWrite
/
TransactionTable.sql

TransactionTable.sql 6.5 KB
Histórico Raw

1234567891011121314151617181920212223242526 
  1. DELETE FROM [Transaction] where ID in (200000001, 200000002, 200000003, 200000004, 200000005)
    2. 

  2. 

  3. SET IDENTITY_INSERT [dbo].[Transaction] ON 
    4. 

  4. 

  5. INSERT [dbo].[Transaction] 
    6. 

  6. ([ID], [PAN], [SysDate], [TransDate], [TransCcy], [BillAmt], [Description], [OldStatus], [NewStatus], [TransactionType], [RecordID], [TransactionStatus], [TransAmt], [BillNat_Conv], [Actual_Balance], [Blocked_Amount], [flCredit], [ProcessingCode], [AuthMethod], [LoadSRC], [LoadType], [OrigStan], [Note], [Amount_other], [Fixed_Fee], [Rate_Fee], [Fx_Padding], [Mcc_Padding], [AuthPresDiff], [txnCountry], [FeeID], [Trans_Link], [SettlementAmt], [Additional_Data], [BillCcy], [SettleCcy], [TxnTypeProcCode], [Account_From], [Account_To], [traceid_lifecycle], [payment_token_id])
    7. 

  7. VALUES (200000001, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-01T12:06:15.347' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'EMV-CHIP-VISA-TEST1-ARQC-PASSED         ', N'04', N'04', N'A', 214792766, N'S', 10.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(00.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'010000', 0, 0, 0, N'', N'Read Write Hot Transaction', N'0', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.01 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 190228407906002900, CAST(10.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)
    8. 

  8. 

  9. INSERT [dbo].[Transaction] 
    10. 

  10. ([ID], [PAN], [SysDate], [TransDate], [TransCcy], [BillAmt], [Description], [OldStatus], [NewStatus], [TransactionType], [RecordID], [TransactionStatus], [TransAmt], [BillNat_Conv], [Actual_Balance], [Blocked_Amount], [flCredit], [ProcessingCode], [AuthMethod], [LoadSRC], [LoadType], [OrigStan], [Note], [Amount_other], [Fixed_Fee], [Rate_Fee], [Fx_Padding], [Mcc_Padding], [AuthPresDiff], [txnCountry], [FeeID], [Trans_Link], [SettlementAmt], [Additional_Data], [BillCcy], [SettleCcy], [TxnTypeProcCode], [Account_From], [Account_To], [traceid_lifecycle], [payment_token_id])
    11. 

  11. VALUES (200000002, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-01T12:06:15.347' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'EMV-CHIP-VISA-TEST1-ARQC-PASSED         ', N'04', N'04', N'A', 214792766, N'S', 10.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(00.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'010000', 0, 0, 0, N'', N'Read Write Hot Transaction 2', N'0', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.01 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 190228407906002900, CAST(10.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)
    12. 

  12. 

  13. INSERT [dbo].[Transaction] 
    14. 

  14. ([ID], [PAN], [SysDate], [TransDate], [TransCcy], [BillAmt], [Description], [OldStatus], [NewStatus], [TransactionType], [RecordID], [TransactionStatus], [TransAmt], [BillNat_Conv], [Actual_Balance], [Blocked_Amount], [flCredit], [ProcessingCode], [AuthMethod], [LoadSRC], [LoadType], [OrigStan], [Note], [Amount_other], [Fixed_Fee], [Rate_Fee], [Fx_Padding], [Mcc_Padding], [AuthPresDiff], [txnCountry], [FeeID], [Trans_Link], [SettlementAmt], [Additional_Data], [BillCcy], [SettleCcy], [TxnTypeProcCode], [Account_From], [Account_To], [traceid_lifecycle], [payment_token_id])
    15. 

  15. VALUES (200000003, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-01T12:06:15.347' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'EMV-CHIP-VISA-TEST1-ARQC-PASSED         ', N'04', N'04', N'A', 214792766, N'S', 10.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(00.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'010000', 0, 0, 0, N'', N'Read Write Hot Transaction 3', N'0', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.01 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 190228407906002900, CAST(10.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)
    16. 

  16. 

  17. INSERT [dbo].[Transaction] 
    18. 

  18. ([ID], [PAN], [SysDate], [TransDate], [TransCcy], [BillAmt], [Description], [OldStatus], [NewStatus], [TransactionType], [RecordID], [TransactionStatus], [TransAmt], [BillNat_Conv], [Actual_Balance], [Blocked_Amount], [flCredit], [ProcessingCode], [AuthMethod], [LoadSRC], [LoadType], [OrigStan], [Note], [Amount_other], [Fixed_Fee], [Rate_Fee], [Fx_Padding], [Mcc_Padding], [AuthPresDiff], [txnCountry], [FeeID], [Trans_Link], [SettlementAmt], [Additional_Data], [BillCcy], [SettleCcy], [TxnTypeProcCode], [Account_From], [Account_To], [traceid_lifecycle], [payment_token_id])
    19. 

  19. VALUES (200000004, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-01T12:06:15.347' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'EMV-CHIP-VISA-TEST1-ARQC-PASSED         ', N'04', N'04', N'A', 214792766, N'S', 10.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(00.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'010000', 0, 0, 0, N'', N'Read Write Hot Transaction 4', N'0', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.01 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 190228407906002900, CAST(10.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)
    20. 

  20. 

  21. INSERT [dbo].[Transaction] 
    22. 

  22. ([ID], [PAN], [SysDate], [TransDate], [TransCcy], [BillAmt], [Description], [OldStatus], [NewStatus], [TransactionType], [RecordID], [TransactionStatus], [TransAmt], [BillNat_Conv], [Actual_Balance], [Blocked_Amount], [flCredit], [ProcessingCode], [AuthMethod], [LoadSRC], [LoadType], [OrigStan], [Note], [Amount_other], [Fixed_Fee], [Rate_Fee], [Fx_Padding], [Mcc_Padding], [AuthPresDiff], [txnCountry], [FeeID], [Trans_Link], [SettlementAmt], [Additional_Data], [BillCcy], [SettleCcy], [TxnTypeProcCode], [Account_From], [Account_To], [traceid_lifecycle], [payment_token_id])
    23. 

  23. VALUES (200000005, 3211927544494378, CAST(N'2020-10-01T12:06:15.440' AS DateTime), CAST(N'2020-10-01T12:06:15.347' AS DateTime), N'826', CAST(10.00 AS Decimal(9, 2)), N'EMV-CHIP-VISA-TEST1-ARQC-PASSED         ', N'04', N'04', N'A', 214792766, N'S', 10.00, CAST(1.000000000000000 AS Decimal(18, 15)), CAST(00.00 AS Decimal(9, 2)), CAST(-10.00 AS Decimal(9, 2)), -1, N'010000', 0, 0, 0, N'', N'Read Write Hot Transaction 5', N'0', CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.01 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), CAST(0.00 AS Decimal(9, 2)), N'USA', 0, 190228407906002900, CAST(10.00 AS Decimal(9, 2)), N'', N'978', N'978', NULL, NULL, NULL, NULL, NULL)
    24. 

  24. 

  25. 

  26. SET IDENTITY_INSERT [dbo].[Transaction] OFF
    27.