next up previous contents
Next: Journal Entry Header table Up: Calendar Table Previous: Theory of operation   Contents

Definition



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
         
         
         
         
         
         
         
         




next up previous contents
Next: Journal Entry Header table Up: Calendar Table Previous: Theory of operation   Contents
Derek Neighbors 2001-03-19