0% found this document useful (0 votes)
45 views27 pages

T&L SRS - Docx EmbeddedFile

Uploaded by

frankenstein1909
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
45 views27 pages

T&L SRS - Docx EmbeddedFile

Uploaded by

frankenstein1909
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 27

View Description

SharePoint List View View Name Type


Cod
e
Error Form V01 Unsigned Errors/By Division 1. View

V01 Unsigned Errors/By Division 2. Column


V01 Unsigned Errors/By Division 2. Column
V01 Unsigned Errors/By Division 2. Column
V01 Unsigned Errors/By Division 2. Column
V01 Unsigned Errors/By Division 2. Column
V01 Unsigned Errors/By Division 2. Column
V01 Unsigned Errors/By Division 2. Column
Error Form V02 Unsigned Errors/By Reference No. 1. View

V02 Unsigned Errors/By Reference No. 2. Column


V02 Unsigned Errors/By Reference No. 2. Column
V02 Unsigned Errors/By Reference No. 2. Column
V02 Unsigned Errors/By Reference No. 2. Column
V02 Unsigned Errors/By Reference No. 2. Column
V02 Unsigned Errors/By Reference No. 2. Column
V02 Unsigned Errors/By Reference No. 2. Column
Error Form V03 Approved Errors/By Contract 1. View

V03 Approved Errors/By Contract 2. Column


V03 Approved Errors/By Contract 2. Column
V03 Approved Errors/By Contract 2. Column
V03 Approved Errors/By Contract 2. Column
V03 Approved Errors/By Contract 2. Column
V03 Approved Errors/By Contract 2. Column
Error Form V04 Approved Errors/By Date 1. View

V04 Approved Errors/By Date 2. Column

V04 Approved Errors/By Date 2. Column


V04 Approved Errors/By Date 2. Column
V04 Approved Errors/By Date 2. Column
V04 Approved Errors/By Date 2. Column
V04 Approved Errors/By Date 2. Column
V04 Approved Errors/By Date 2. Column
Error Form V05 Approved Errors/By Department 1. View

V05 Approved Errors/By Department 2. Column


V05 Approved Errors/By Department 2. Column
V05 Approved Errors/By Department 2. Column
V05 Approved Errors/By Department 2. Column
V05 Approved Errors/By Department 2. Column
V05 Approved Errors/By Department 2. Column
V05 Approved Errors/By Department 2. Column
V05 Approved Errors/By Department 2. Column
Error Form V06 Approved Errors/By Division 1. View

V06 Approved Errors/By Division 2. Column


V06 Approved Errors/By Division 2. Column
V06 Approved Errors/By Division 2. Column
V06 Approved Errors/By Division 2. Column
V06 Approved Errors/By Division 2. Column
V06 Approved Errors/By Division 2. Column
V06 Approved Errors/By Division 2. Column
Error Form V07 Approved Errors/By Error Account 1. View

V07 Approved Errors/By Error Account 2. Column


V07 Approved Errors/By Error Account 2. Column
V07 Approved Errors/By Error Account 2. Column
V07 Approved Errors/By Error Account 2. Column
V07 Approved Errors/By Error Account 2. Column
V07 Approved Errors/By Error Account 2. Column
V07 Approved Errors/By Error Account 2. Column
Error Form V08 Approved Errors/By Market 1. View

V08 Approved Errors/By Market 2. Column


V08 Approved Errors/By Market 2. Column
V08 Approved Errors/By Market 2. Column
V08 Approved Errors/By Market 2. Column
V08 Approved Errors/By Market 2. Column
V08 Approved Errors/By Market 2. Column
V08 Approved Errors/By Market 2. Column
Error Form V09 Approved Errors/By Office 1. View

V09 Approved Errors/By Office 2. Column


V09 Approved Errors/By Office 2. Column
V09 Approved Errors/By Office 2. Column
V09 Approved Errors/By Office 2. Column
V09 Approved Errors/By Office 2. Column
V09 Approved Errors/By Office 2. Column
V09 Approved Errors/By Office 2. Column
V09 Approved Errors/By Office 2. Column
Error Form V10 Approved Errors/By Reason 1. View

V10 Approved Errors/By Reason 2. Column


V10 Approved Errors/By Reason 2. Column
V10 Approved Errors/By Reason 2. Column
V10 Approved Errors/By Reason 2. Column

V10 Approved Errors/By Reason 2. Column


V10 Approved Errors/By Reason 2. Column
V10 Approved Errors/By Reason 2. Column
Error Form V11 Approved Errors/By Reference No. 1. View

V11 Approved Errors/By Reference No. 2. Column


V11 Approved Errors/By Reference No. 2. Column
V11 Approved Errors/By Reference No. 2. Column
V11 Approved Errors/By Reference No. 2. Column
V11 Approved Errors/By Reference No. 2. Column
V11 Approved Errors/By Reference No. 2. Column
V11 Approved Errors/By Reference No. 2. Column
V11 Approved Errors/By Reference No. 2. Column
V11 Approved Errors/By Reference No. 2. Column
V11 Approved Errors/By Reference No. 2. Column
Error Form V12 Approved Errors/By Sales Person 1. View

V12 Approved Errors/By Sales Person 2. Column


V12 Approved Errors/By Sales Person 2. Column
V12 Approved Errors/By Sales Person 2. Column
V12 Approved Errors/By Sales Person 2. Column
V12 Approved Errors/By Sales Person 2. Column
V12 Approved Errors/By Sales Person 2. Column
V12 Approved Errors/By Sales Person 2. Column
Error Form V13 Approved Errors/By Positive 1. View

V13 Approved Errors/By Positive 2. Column


V13 Approved Errors/By Positive 2. Column
V13 Approved Errors/By Positive 2. Column

V13 Approved Errors/By Positive 2. Column

V13 Approved Errors/By Positive 2. Column

V13 Approved Errors/By Positive 2. Column


V13 Approved Errors/By Positive 2. Column
V13 Approved Errors/By Positive 2. Column
Error Form V14 Rejected Errors/By Division 1. View

V14 Rejected Errors/By Division 2. Column


V14 Rejected Errors/By Division 2. Column
V14 Rejected Errors/By Division 2. Column
V14 Rejected Errors/By Division 2. Column
V14 Rejected Errors/By Division 2. Column
V14 Rejected Errors/By Division 2. Column
V14 Rejected Errors/By Division 2. Column
Error Form V15 Rejected Errors/By Reference No. 1. View

V15 Rejected Errors/By Reference No. 2. Column


V15 Rejected Errors/By Reference No. 2. Column
V15 Rejected Errors/By Reference No. 2. Column
V15 Rejected Errors/By Reference No. 2. Column
V15 Rejected Errors/By Reference No. 2. Column
V15 Rejected Errors/By Reference No. 2. Column
V15 Rejected Errors/By Reference No. 2. Column
Error Form V16 Rejected Errors/By Sales Person 1. View

V16 Rejected Errors/By Sales Person 2. Column


V16 Rejected Errors/By Sales Person 2. Column
V16 Rejected Errors/By Sales Person 2. Column
V16 Rejected Errors/By Sales Person 2. Column
V16 Rejected Errors/By Sales Person 2. Column
V16 Rejected Errors/By Sales Person 2. Column
Error Form V17 EURX/By Reference No. 1. View

V17 EURX/By Reference No. 2. Column


V17 EURX/By Reference No. 2. Column
V17 EURX/By Reference No. 2. Column
V17 EURX/By Reference No. 2. Column
V17 EURX/By Reference No. 2. Column
V17 EURX/By Reference No. 2. Column
V17 EURX/By Reference No. 2. Column
V17 EURX/By Reference No. 2. Column
Contract V18 Archived/Contracts 1. View

V18 Archived/Contracts 2. Column


V18 Archived/Contracts 2. Column
V18 Archived/Contracts 2. Column
Error Account V19 Administration/Error Accounts 1. View
V19 Administration/Error Accounts 2. Column
V19 Administration/Error Accounts 2. Column
V19 Administration/Error Accounts 2. Column
V19 Administration/Error Accounts 2. Column
V19 Administration/Error Accounts 2. Column

V19 Administration/Error Accounts 2. Column

Error Form V20 Administration/Amendments 1. View


V20 Administration/Amendments 2. Column
V20 Administration/Amendments 2. Column
V20 Administration/Amendments 2. Column
V20 Administration/Amendments 2. Column
V20 Administration/Amendments 2. Column
V20 Administration/Amendments 2. Column
V20 Administration/Amendments 2. Column
V20 Administration/Amendments 2. Column
V20 Administration/Amendments 3. Action
Reason V21 Administration/Cancellation Details 1. View
V21 Administration/Cancellation Details 2. Column

V21 Administration/Cancellation Details 2. Column


V21 Administration/Cancellation Details 2. Column
Compliance V22 Administration/Compliances 1. View
V22 Administration/Compliances 2. Column
V22 Administration/Compliances 2. Column
V22 Administration/Compliances 2. Column
Contract V23 Administration/Contracts 1. View

V23 Administration/Contracts 2. Column


V23 Administration/Contracts 2. Column
V23 Administration/Contracts 2. Column
V23 Administration/Contracts 3. Action
Country V24 Administration/Countries 1. View
V24 Administration/Countries 2. Column
V24 Administration/Countries 2. Column
V24 Administration/Countries 2. Column
Currency V25 Administration/Currencies 1. View
V25 Administration/Currencies 2. Column
V25 Administration/Currencies 2. Column
V25 Administration/Currencies 2. Column

V25 Administration/Currencies 2. Column


Division V26 Administration/Divisions 1. View
V26 Administration/Divisions 2. Column
Employee V27 Administration/Employees 1. View
V27 Administration/Employees 2. Column
V27 Administration/Employees 2. Column
V27 Administration/Employees 2. Column
V27 Administration/Employees 2. Column
V27 Administration/Employees 2. Column
V27 Administration/Employees 2. Column
V27 Administration/Employees 2. Column
V27 Administration/Employees 2. Column
V27 Administration/Employees 2. Column
Error Form V28 Administration/Export View 1. View

V28 Administration/Export View 2. Column


V28 Administration/Export View 2. Column
V28 Administration/Export View 2. Column

V28 Administration/Export View 2. Column


V28 Administration/Export View 2. Column
V28 Administration/Export View 2. Column
V28 Administration/Export View 2. Column
V28 Administration/Export View 2. Column
V28 Administration/Export View 2. Column
V28 Administration/Export View 2. Column
V28 Administration/Export View 2. Column
V28 Administration/Export View 2. Column
Market V29 Administration/Markets 1. View
V29 Administration/Markets 2. Column
Office V30 Administration/Offices 1. View
V30 Administration/Offices 2. Column
V30 Administration/Offices 2. Column
V30 Administration/Offices 2. Column
V30 Administration/Offices 2. Column
V30 Administration/Offices 2. Column
V30 Administration/Offices 2. Column
Trading Region V31 Administration/Trading Regions 1. View
V31 Administration/Trading Regions 2. Column
Email Setup V32 Administration/EmailSetup 1. View
V32 Administration/EmailSetup 2. Column
V32 Administration/EmailSetup 2. Column
Error Form V33 Administration/dbIRS/Exported 1. View
Errors

V33 Administration/dbIRS/Exported Errors 2. Column


V33 Administration/dbIRS/Exported Errors 2. Column
V33 Administration/dbIRS/Exported Errors 2. Column
V33 Administration/dbIRS/Exported Errors 2. Column
V33 Administration/dbIRS/Exported Errors 2. Column

V33 Administration/dbIRS/Exported Errors 2. Column

V33 Administration/dbIRS/Exported Errors 2. Column


V33 Administration/dbIRS/Exported Errors 2. Column
V33 Administration/dbIRS/Exported Errors 2. Column
V33 Administration/dbIRS/Exported Errors 2. Column
V33 Administration/dbIRS/Exported Errors 2. Column
V33 Administration/dbIRS/Exported Errors 2. Column
V33 Administration/dbIRS/Exported Errors 2. Column
V33 Administration/dbIRS/Exported Errors 2. Column
Error Form V34 Administration/dbIRS/UnExported 1. View
Errors

V34 Administration/dbIRS/UnExported 2. Column


Errors
V34 Administration/dbIRS/UnExported 2. Column
Errors
V34 Administration/dbIRS/UnExported 2. Column
Errors
V34 Administration/dbIRS/UnExported 2. Column
Errors
V34 Administration/dbIRS/UnExported 2. Column
Errors
V34 Administration/dbIRS/UnExported 2. Column
Errors
V34 Administration/dbIRS/UnExported 2. Column
Errors
V34 Administration/dbIRS/UnExported 2. Column
Errors
V34 Administration/dbIRS/UnExported 2. Column
Errors
V34 Administration/dbIRS/UnExported 2. Column
Errors
V34 Administration/dbIRS/UnExported 2. Column
Errors
V34 Administration/dbIRS/UnExported 2. Column
Errors
V34 Administration/dbIRS/UnExported 2. Column
Errors
V34 Administration/dbIRS/UnExported 2. Column
Errors
Error Form V35 Administration/Report/By Office 1. View
V35 Administration/Report/By Office 2. Column
V35 Administration/Report/By Office 2. Column
V35 Administration/Report/By Office 2. Column
V35 Administration/Report/By Office 2. Column
V35 Administration/Report/By Office 2. Column
V35 Administration/Report/By Office 2. Column
V35 Administration/Report/By Office 2. Column
V35 Administration/Report/By Office 2. Column
V35 Administration/Report/By Office 2. Column
V35 Administration/Report/By Office 2. Column
Error Form V36 Administration/Report/Reference 1. View
Number

V36 Administration/Report/Reference 2. Column


Number
V36 Administration/Report/Reference 2. Column
Number
V36 Administration/Report/Reference 2. Column
Number
V36 Administration/Report/Reference 2. Column
Number
V36 Administration/Report/Reference 2. Column
Number
V36 Administration/Report/Reference 2. Column
Number
V36 Administration/Report/Reference 2. Column
Number
V36 Administration/Report/Reference 2. Column
Number
V36 Administration/Report/Reference 2. Column
Number
V36 Administration/Report/Reference 2. Column
Number
V36 Administration/Report/Reference 2. Column
Number
V36 Administration/Report/Reference 2. Column
Number
V36 Administration/Report/Reference 2. Column
Number
V36 Administration/Report/Reference 2. Column
Number
Error Form V37 Administration/Report/By Sales 1. View
Person
V37 Administration/Report/By Sales 2. Column
Person
V37 Administration/Report/By Sales 2. Column
Person
V37 Administration/Report/By Sales 2. Column
Person
V37 Administration/Report/By Sales 2. Column
Person
V37 Administration/Report/By Sales 2. Column
Person
V37 Administration/Report/By Sales 2. Column
Person
V37 Administration/Report/By Sales 2. Column
Person
V37 Administration/Report/By Sales 2. Column
Person
V37 Administration/Report/By Sales 2. Column
Person
Error Form V38 Administration/Report/By Specified 1. View
Dates
V38 Administration/Report/By Specified 2. Column
Dates
V38 Administration/Report/By Specified 2. Column
Dates
V38 Administration/Report/By Specified 2. Column
Dates
V38 Administration/Report/By Specified 2. Column
Dates
V38 Administration/Report/By Specified 2. Column
Dates
V38 Administration/Report/By Specified 2. Column
Dates
V38 Administration/Report/By Specified 2. Column
Dates
V38 Administration/Report/By Specified 2. Column
Dates
V38 Administration/Report/By Specified 2. Column
Dates
V38 Administration/Report/By Specified 3. Action
Dates
Error Form V39 Administration/Report/By 1. View
Technology

V39 Administration/Report/By Technology 2. Column


V39 Administration/Report/By Technology 2. Column
V39 Administration/Report/By Technology 2. Column
V39 Administration/Report/By Technology 2. Column
V39 Administration/Report/By Technology 2. Column
V39 Administration/Report/By Technology 2. Column
V39 Administration/Report/By Technology 2. Column
V39 Administration/Report/By Technology 2. Column
V39 Administration/Report/By Technology 2. Column
V39 Administration/Report/By Technology 2. Column
V39 Administration/Report/By Technology 2. Column
Error Form V40 Administration/Report/By Total 1. View

V40 Administration/Report/By Total 2. Column


V40 Administration/Report/By Total 2. Column
Title Value Sort Categoriz
(Ascending / ed
Descending) (Yes/No)
Unsigned Errors/By Division

Division [Division] Ascending Yes


Reference Number [Reference Number] Ascending
Contract [Contract] Ascending
Trader [Trader]
Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Unsigned Errors/By Reference No.

Reference Number [Reference Number] Ascending


Trader [Trader] Ascending
Sign Offs [Sign Offs]
Approvers [Approvers]
Compliance Approvers [Compliance Approvers]
Higher Approvers [Higher Approvers]
Signed By [Signed By]
Approved Errors/By Contract

Contract [Contract] Ascending Yes


Reference Number [Reference Number] Ascending
Trader [Trader] Ascending
Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Approved Errors/By Date

Date Time Position was Closed [Date Position was Ascending Yes
Closed]
Reference Number [Reference Number] Ascending
Contract [Contract] Ascending
Trader [Trader]
Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Approved Errors/By Department

Department [Department] Ascending Yes


Reference Number [Reference Number] Ascending
Trader [Trader] Ascending
Market [Market]
Account [Account]
Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Approved Errors/By Division

Division [Division] Ascending Yes


Reference Number [Reference Number] Ascending
Contract [Contract] Ascending
Trader [Trader]
Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Approved Errors/By Error Account

Account [Account] Ascending Yes


Reference Number [Reference Number] Ascending
Contract [Contract] Ascending
Trader [Trader]
Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Approved Errors/By Market

Market [Market] Ascending Yes


Contract [Contract] Ascending Yes
Reference Number [Reference Number] Ascending
Trader [Trader] Ascending
Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Approved Errors/By Office

Office [Office] Ascending Yes


Trader [Trader] Ascending Yes
Reference Number [Reference Number] Ascending
Market [Market] Ascending
Account [Account]
Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Approved Errors/By Reason

Error Reason [Error Reason] Ascending Yes


Reference Number [Reference Number] Ascending
Trader [Trader] Ascending
Client/Proprietary Trader Name [Client/Proprietary Trader
Name]
Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Approved Errors/By Reference No.

Error Identifier [Error Identifier] Ascending Yes


Reference Number [Reference Number] Ascending
Trader [Trader] Ascending
Sign Offs [Sign Offs]
Approvers [Approvers]
Compliance Approvers [Compliance Approvers]
Higher Approvers [Higher Approvers]
Signed By [Signed By]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Approved Errors/By Sales Person

Trader [Trader] Ascending Yes


Reference Number [Reference Number] Ascending
Market [Market] Ascending
Account [Account]
Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Approved Errors/By Positive

Positive Error? [Positive Error?] Ascending Yes


Reference Number [Reference Number] Ascending
Client/Proprietary Trader Name [Client/Proprietary Trader Ascending
Name]
Name of Client/Proprietary notified Trader [Name of
Client/Proprietary notified
Trader]
Client/Proprietary Trader's Account Number [Client/Proprietary
Trader's Account Number]

Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Rejected Errors/By Division

Division [Division] Ascending Yes


Reference Number [Reference Number] Ascending
Contract [Contract] Ascending
Trader [Trader]
Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Rejected Errors/By Reference No.

Reference Number [Reference Number] Ascending


Trader [Trader] Ascending
Sign Offs [Sign Offs]
Approvers [Approvers]
Compliance Approvers [Compliance Approvers]
Higher Approvers [Higher Approvers]
Signed By [Signed By]
Rejected Errors/By Sales Person

Trader [Trader] Ascending Yes


Reference Number [Reference Number] Ascending
Market [Market] Ascending
Account [Account]
Currency [Currency]
Amount [Amount]
EURX/By Reference No.

Reference Number [Reference Number] Ascending


Sales Person [Sales Person] Ascending
Sign Offs [Sign Offs]
Approvers [Approvers]
Compliance Approvers [Compliance Approvers]
Higher Approvers [Higher Approvers]
Status [Status]
Signed By [Signed By]
Archived/Contracts

Market [Market] Ascending Yes


Contract Name [Contract Name] Ascending
Currency [Currency] Ascending
Administration/Error Accounts
Account Name [Account Name] Ascending
Cost Center [Cost Center] Ascending
dbIRS Reason [dbIRS Reason]
dbIRS ID [dbIRS ID]
dbIRS Causation Category Code [dbIRS Causation
Category Code]
dbIRS Causation Category Description [dbIRS Causation
Category Description]
Administration/Amendments
Reference Number [Reference Number] Ascending
Trader [Trader] Ascending
Sign Offs [Sign Offs]
Approvers [Approvers]
Compliance Approvers [Compliance Approvers]
Higher Approvers [Higher Approvers]
Status [Status]
Signed By [Signed By]
Unlock Document N/A
Administration/Cancellation Details
Cancellation Reason For [Cancellation Reason For] Ascending Yes

Cancellation Reason [Cancellation Reason] Ascending


dbIRS ID [dbIRS ID]
Administration/Compliances
Country [Country] Ascending Yes
Employee Name [Employee Name] Ascending
E-Mail [E-Mail] Ascending
Administration/Contracts

Market [Market] Ascending Yes


Contract Name [Contract Name] Ascending
Currency [Currency] Ascending
Archive Contract(s) N/A
Administration/Countries
Region [Region] Ascending Yes
Country [Country] Ascending
Country Code [Country Code] Ascending
Administration/Currencies
Currency Symbol [Currency Symbol] Ascending
Full Name [Full Name]
Global Notification Limit [Global Notification Limit]

Euro Rate [Euro Rate]


Administration/Divisions
Division [Division] Ascending
Administration/Employees
Full Name [Full Name] Ascending
E-Mail Address [E-Mail Address] Ascending
Office [Office]
Division [Division]
Product [Product]
Department [Department]
Function [Function]
Country [Country]
Region [Region]
Administration/Export View

Reference Number [Reference Number] Ascending


Office [Office] Ascending
Date Time Position was Closed [Date Time Position was
Closed]
Account [Account]
Trader [Trader]
Contract [Contract]
Market [Market]
Currency [Currency]
Amount [Amount]
Status [Status]
Division [Division]
Product [Product]
Administration/Markets
Market Name [Market Name] Ascending
Administration/Offices
Division [Division] Ascending Yes
Office Name [Office Name] Ascending
Product [Product] Ascending
Country [Country]
Office Sign Offs [Office Sign Offs]
Technical Sign Offs [Technical Sign Offs]
Administration/Trading Regions
Region Name [Region Name] Ascending
Administration/EmailSetup
Email Keyword [Email Keyword] Ascending Yes
Email Address [Email Address] Ascending
Administration/dbIRS/Exported Errors

dbIRS Event ID [dbIRS Event ID] Descending


DBIRSREF [DBIRSREF] Ascending
Date Composed [Date Composed]
Reference Number [Reference Number]
Date Time of Initial Order [Date Time of Initial Order]

Date Time Position was Closed [Date Time Position was


Closed]
Signed Date Time [Signed Date Time]
dbIRS Location ID [dbIRS Location ID]
Cost Center [Cost Center]
Account [Account]
Booking Date [Booking Date]
Currency [Currency]
Occurred Loss [Occurred Loss]
Occurred Profit [Occurred Profit]
Administration/dbIRS/UnExported Errors

Date Composed [Date Composed] Ascending

Reference Number [Reference Number] Ascending

dbIRS Event ID [dbIRS Event ID]

dbIRS Event CategoryID [dbIRS Event CategoryID]

Date Time of Initial Order [Date Time of Initial Order]

Date Time Position was Closed [Date Time Position was


Closed]
Signed Date Time [Signed Date Time]

dbIRS Location ID [dbIRS Location ID]


Cost Center [Cost Center]

Account [Error Account]

Booking Date [Booking Date]

Currency [Currency]

Occurred Loss [Occurred Loss]

Occurred Profit [Occurred Profit]

Administration/Report/By Office
Office [Office] Ascending Yes
Trade Year - Month [Trade Year - Month] Ascending Yes
Trade Date [Trade Date] Ascending
Reference Number [Reference Number] Ascending
Contract [Contract]
Trader [Trader]
Error Reason [Error Reason]
Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Administration/Report/Reference
Number

Trade Date [Trade Date] Ascending

DBIRSREF [DBIRSREF] Ascending

Account [Account]

Market [Market]

Contract [Contract]

Error Reason [Error Reason]

Sales Person [Sales Person]

Currency [Currency]

Amount [Amount]

Euro Equivalent [Euro Equivalent]

Status [Status]

Reference Number [Reference Number]


Reference Number [Reference Number]

Date Composed [Date Composed]

Administration/Report/By Sales Person

Sales Person [Sales Person] Ascending Yes

Trade Year - Month [Trade Year - Month] Ascending Yes

Trade Date [Trade Date] Ascending

Reference Number [Reference Number] Ascending

Contract [Contract]

Office [Office]

Currency [Currency]

Amount [Amount]

Euro Equivalent [Euro Equivalent]

Administration/Report/By Specified
Dates
Office [Office] Ascending Yes

Trade Year - Month [Trade Year - Month] Ascending Yes

Trade Date [Trade Date] Ascending

Reference Number [Reference Number] Ascending

Contract [Contract]

Trader [Trader]

Currency [Currency]

Amount [Amount]

Euro Equivalent [Euro Equivalent]

Report Dates

Administration/Report/By Technology

Trade Date [Trade Date] Ascending


Account [Account] Ascending
Market [Market]
Contract [Contract]
Error Reason [Error Reason]
Sales Person [Sales Person]
Currency [Currency]
Amount [Amount]
Euro Equivalent [Euro Equivalent]
Reference Number [Reference Number]
Date Composed [Date Composed]
Administration/Report/By Total

Location [Location] Ascending Yes


Reference Number [Reference Number] Ascending
View Selection / Column Description

Select all "Error Form" items with [Document


Status] <> "Approved" and "Rejected"

Sum for each group and for all items.


Select all "Error Form" items with [Document
Status] <> "Approved" and "Rejected"

Select all "Error Form" items with [Document


Status] = "Approved"

Sum for each group and for all items.


Select all "Error Form" items with [Document
Status] = "Approved"

Sum for each group and for all items.


Select all "Error Form" items with [Document
Status] = "Approved"

Sum for each group and for all items.


Select all "Error Form" items with [Document
Status] = "Approved"

Sum for each group and for all items.


Select all "Error Form" items with [Document
Status] = "Approved"

Sum for each group and for all items.


Select all "Error Form" items with [Document
Status] = "Approved"

Sum for each group and for all items.


Select all "Error Form" items with [Document
Status] = "Approved"

Sum for each group and for all items.


Select all "Error Form" items with [Document
Status] = "Approved"

Sum for each group and for all items.


Select all "Error Form" items with [Document
Status] = "Approved"

Sum for each group and for all items.


Sum for each group and for all items.
Select all "Error Form" items with [Document
Status] = "Approved"

Sum for each group and for all items.


Select all "Error Form" items with [Document
Status] = "Approved"

Sum for each group and for all items.


Select all "Error Form" items with [Document
Status] = "Rejected"

Sum for each group and for all items.


Select all "Error Form" items with [Document
Status] = "Rejected"
Select all "Error Form" items with [Document
Status] = "Rejected"

Select all "Error Form" items with [Market] =


"EURX"

Select all "Contract" items with [Archive


Contract] = "Yes"

Select all "Account Name" items.

Select all "Error Form" items

Refer to UC "Unlock Document"


Select all "Reason" items.
Select all "Compliance" items.

Select all "Contract" items with [Archive


Contract] <> "Yes"

Refer to UC "Archive Contract"


Select all "Country" items

Select all "Currency" items

Select all "Division" items

Select all "Employee" items

Select all "Error Form" items with [Document


Status] = "Approved"

Select all "Market" items

Select all "Office" items


Select all "Trading Region" items.

Select all "Email Setup" items.

Select all "Error Form" items & [Document


Status] = "Approved" & [dbIRS Exported] =
"Yes"

- Select all "Error Form" items & [Document


Status] = "Approved" & [dbIRS Exported] <>
"Yes" and [Date Composed] before
"01/07/2002"
- Count number of items
Select all "Error Form" items

Select all "Error Form" items which [Error


Current Year] = (current year -1) or (current
year -2) or (current year -3) or (current year -
4)
Select all "Error Form" items

Sum for each group and for all items

Sum for each group and for all items

Select all "Error Form" items

Sum for each group and for all items

Sum for each group and for all items

Refer to UC "Report by Specified Date"

Select all "Error Form" items which [Error


Current Year] = current year & [Error Reason]
= "Technology Failures" or "Technical Fault"
Select all "Error Form" items which [Document
Status] = "Approved"

Sum for each group and for all items

You might also like