Table Structure of RES-1900 Project

Every Task processed in production group have a table repository:
ex: [E1] Entry 1
     dbo.e1_hdr
        -> batch header that contains batch no, user id, date issue, number of docs, number of record, number of character.
     dbo.e1
        -> main record captured on the documents.
     dbo.e1_bbd_names
        -> (sub-record) in one document are allowed four record of borrower names to be captured.
     dbo.e1_sgp_names
        -> (sub-record) in one document are allowed two record of seller names to be captured.

Batch Header Table


Entry 1 Main Table


Entry 1 sub table - borrower names


Entry 1 sub table - seller names


Visual idea of s2xde database schema and table structure, on my next post we proceed Batching module.


Previous Post of S2xDE Software