unControl 
Default Table Name  unControl 
Definition  
Units Table - Data Entry Control
 

unControl Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Batch(PK)    nvarchar(30)  NO  
Name of the unit transaction data entry file.
 
PostPeriod    int  NO  
The accounting period when the file was posted.
 
PostSeq    int  NO  
The file's internal posting sequence number.
 
Recurring    varchar(1)  NO  
Flag indicating whether this is a recurring transaction file.
 
Selected    varchar(1)  NO  
Flag indicating whether this file has been selected for posting.
 
Posted    varchar(1)  NO  
Flag indicating whether the transaction file has been posted.
 
Creator    nvarchar(20)  YES  
Username of the person who created the transaction data entry file.
 
Period    int  NO  
Accounting period when the transaction file was created.
 
EndDate    datetime  YES  
The transaction file's end date.
 
Total    decimal(19, 4)  NO  
Total entered for the transaction file.
 
Company    nvarchar(14)  NO  
The company owning the data entry file; that is, the company that is the active company when the file is created.
 
SubmittedBy    nvarchar(20)  YES  
The Employee ID of the employee who submitted the data entry file for approval.
 
SubmittedDate    datetime  YES  
The date and time when the data entry file was submitted for approval.
 
Diary    nvarchar(10)  YES  
Diary
 
DiaryNo    int  NO  
Diary Number
 

unControl Primary and Unique Keys 
Key Name  Key Type  Keys 
unControlPK  PrimaryKey  Batch 

unControl Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication