Hello,
I'm currently working on creating an electronic reporting import format for processing credit card transactions from AMEX. Here's how it's structured:
- Header record: identified by '0' at at the starting position.
- Market summary record: identified by '8' at at the starting position.
- Employee transaction records (multiple per employee): identified by '1' at at the starting position.
- Employee summary record (one per employee): identified by '2' at at the starting position.
- Trailer record: identified by '9' at at the starting position.
Each employee's records are repeated multiple times within the file.
Here’s a sample sequence (txt):
Note there are no delimiters it's position based.
0 (Header)
8 (Market summary)
1 (Employee transaction - EMP001)
1 (Employee transaction - EMP001)
1 (Employee transaction - EMP001)
2 (Employee summary - EMP001)
1 (Employee transaction - EMP002)
1 (Employee transaction - EMP002)
2 (Employee summary - EMP002)
9 (Trailer)
Could you please provide advice on how to handle multiple employees' transactions effectively within this structure, especially regarding the possible impact of the employee summary records?
Thank you in advance.
Best regards,