24/08/2022 11:32
Database History for C:\Users\[Link]\Downloads\Monetary [Link]
Database Date User
Base Fornecedores-Base [Link]
Import from Excel 24/08/2022 11:07:44 [Link]
Imported from: C:\Users\[Link]\OneDrive - BDO RCS\Área de Trabalho\Base
[Link]
Data Source: Excel
Sheet Name: Base Fornecedores
Number of records: 40
First record as title: TRUE
IDEAScript code: Set task = [Link]("ImportExcel")
dbName = "C:\Users\[Link]\OneDrive - BDO RCS\Área de
Trabalho\Base [Link]"
[Link] = dbName
[Link] = "Base Fornecedores"
[Link] = "Base Fornecedores"
[Link] = "TRUE"
[Link] = "TRUE"
[Link]
dbName = [Link]("Base Fornecedores")
Set task = Nothing
[Link](dbName)
Control Total Field Changed 24/08/2022 11:07:48 [Link]
Field name: SALDO
Control total: 239.250,39
IDEAScript code: Set db = [Link]("Base Fornecedores-Base
[Link]")
[Link] "SALDO"
Monetary Unit Sample - Pl... 24/08/2022 11:08:21 [Link]
Confidence Level: 86,50%
Total Value of Sample ... 287402,15
Tolerable error: 75287,00
Expected error: 0,00
Sample Size: 7
Sampling Interval: 41057,45
Tolerable Taintings: 0
Basic Precision Pricing: 100
Monetary [Link]
Control Total Field Changed 24/08/2022 11:08:22 [Link]
Field name: SALDO
Control total: 36.175,84
1
24/08/2022 11:32
Database History for C:\Users\[Link]\Downloads\Monetary [Link]
Database Date User
IDEAScript code: Set db = [Link]("Monetary [Link]")
[Link] "SALDO"
Monetary Unit Sample - E... 24/08/2022 11:08:22 [Link]
File name: Monetary [Link]
Number of records: 2
Control field: SALDO
Control total: 36.175,84
File name: Base Fornecedores-Base [Link]
Number of records: 40
Field to sample: CRÉDITO
Sampling interval: 41057,45
Random starting point: 25561,91
Extraction method: Fixed interval
Range of values used: Absolute
High value amount: 41057,45
High value handling: File
High value file: High [Link]
2
24/08/2022 11:32
Database History for C:\Users\[Link]\Downloads\Monetary [Link]
Database Date User
IDEAScript code: Const WI_HighValueHandling_AGGREGATE = 0
Const WI_HighValueHandling_FILE = 1
Const WI_RangeOfValues_POSITIVES = 0
Const WI_RangeOfValues_NEGATIVES = 1
Const WI_RangeOfValues_ABSOLUTES = 2
Const WI_TaskType_FIXED = 0
Const WI_TaskType_CELL = 1
Set db = [Link]("Base Fornecedores-Base
[Link]")
Set task = [Link]
[Link]
[Link] = WI_TaskType_FIXED
[Link] = WI_RangeOfValues_ABSOLUTES
[Link] = WI_HighValueHandling_FILE
[Link] = "High [Link]"
[Link] = 41057.45
[Link] = 25561.91
[Link] = "CRÉDITO"
dbName = "Monetary [Link]"
[Link] = dbName
[Link]
Set task = Nothing
Set db = Nothing
[Link] (dbName)
Export Database 24/08/2022 11:08:26 [Link]
Export database to: C:\Users\[Link]\OneDrive - BDO RCS\Área de Trabalho\IDEA -
Fornecedores\[Link]\Monetary [Link]
Export Type: Microsoft Excel 2007 - 2010
Record range: 1-2
3
24/08/2022 11:32
Database History for C:\Users\[Link]\Downloads\Monetary [Link]
Database Date User
IDEAScript code: Set db = [Link]("Monetary [Link]")
Set task = [Link]
[Link]
eqn = ""
[Link] "C:\Users\[Link]\OneDrive - BDO RCS\Área de
Trabalho\IDEA - Fornecedores\[Link]\Monetary [Link]",
"Database", "XLSX", 1, [Link], eqn
Set db = Nothing
Set task = Nothing