[go: up one dir, main page]
Scribd
Upload
22 views4 pages

DISA Module3 All Validations Example

The document contains a table of employee claims with details such as claim numbers, dates, department IDs, and payment information. It also includes a summary of company bills, indicating their payment modes and remarks on validity or issues. Additionally, there are checks for duplicates and completeness related to claims and employee IDs.

Uploaded by

nitinsidana76
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
22 views4 pages

DISA Module3 All Validations Example

The document contains a table of employee claims with details such as claim numbers, dates, department IDs, and payment information. It also includes a summary of company bills, indicating their payment modes and remarks on validity or issues. Additionally, there are checks for duplicates and completeness related to claims and employee IDs.

Uploaded by

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

Claim Date of Date of Date of Employee Dept ID Dept Check Mobile No Mobile

No Claim Receipt Approval ID Name Digit Bill No

1001 2025-06-01 2025-06-02 2025-06-03 EMP00-1 D001 HR 1 9876543210 MB001


1002 2025-06-05 2025-06-06 2025-06-04 EMP00-2 D002 Finance 2 9876543210 MB002
1003 2025-06-10 2025-06-12 2025-06-11 EMP00-3 D003 IT 3 9001234567 MB003
1004 2025-06-15 2025-06-14 2025-06-13 EMP00-4 D004 Admin 4 123456 MB004
1004 2025-06-15 2025-06-14 2025-06-13 D005 Marketing 5 9876543210 MB004
Company Bill Mode of Date of Bill Remarks
ID Period Payment Bill Amount

C1 May-2025 C 2025-05-2 950 Valid


C2 May-2025 N 2025-05-2 0 Zero amount
C3 May-2025 X 2025-05-2 10500 Over limit
C4 May-2025 C 2025-05-2 600 Valid
C4 May-2025 N 2025-05-2 600 Duplicate
Dept ID
D001
D002
D003
D007
D008
Sequence Check (claim no)
Duplicate Check (Bill No + Company ID)
Completeness Check (Employee id)

You might also like