The framework uses five system tables to define and process files:
- sgs_file: Each row in this table defines a file that needs to be processed. Its columns include:
- File ID
- Transaction Code Position
- Transaction Code Length
- Header Group Position
- Header Group Length
- Inbox Path Code
- Staging Path Code
- Processed Path Code
- Error Path Code
- Inbound Mask
- XML File Layout
- Inbound/Outbound Flag
- Group Process Flag
- Delimited By
- sgs_file_hdr: Each row in this table defines an instance of a file that the application has processed. Its columns include:
- Mailbox File Name
- Processed File Name
- Processed Date
- File ID
- Reference ID
- Status
- Number of Rows
- Error Message
- sgs_file_hrd_error: Each row in this table reports an error in a processed file.
- sgs_file_dtl: This table contains all the records from the file instance (see sgs_file_hdr). Its columns include:
- File Detail ID
- File Header ID
- Transaction Code Value
- Header Group Value
- Line Number
- Record Data
- Status
- sgs_file_dtl_error: Each row in this table reports an error in a processed record.
This post is part of the Files topic. Click here to open the Files Overview.