Table Name | Field Name | Descriptive Name | Field Type | Theory of operation |
CAL | org_id | Organization Identification | numeric | |
CAL | cal_id | Calendar Identification | numeric | A serial number assigned by the system |
CAL | cal_year | Financial Year | numeric | |
CAL | cal_prd | Financial period | numeric | >From 0 to 52 |
CAL | start_date | First day of this financial period | date | |
CAL | end_date | Last day of this financial period | date | |
CAL | gl_open | Posting status from General Journal | Yes/No | Yes = Open to posting, No = Close to posting |
CAL | ar_open | Posting status from Accounts Receivable | Yes/No | Yes = Open to posting, No = Close to posting |
CAL | ap_open | Posting status from Accounts Payable | Yes/No | Yes = Open to posting, No = Close to posting |
CAL | so_open | Posting status from Sales Order | Yes/No | Yes = Open to posting, No = Close to posting |
CAL | po_open | Posting status from Purchase Order | Yes/No | Yes = Open to posting, No = Close to posting |
CAL | ic_open | Posting status from inventory Control | Yes/No | Yes = Open to posting, No = Close to posting |
CAL | br_open | Posting status from Bank reconciliation | Yes/No | Yes = Open to posting, No = Close to posting |
CAL | pr_open | Posting status from Payroll | Yes/No | Yes = Open to posting, No = Close to posting |