apControl 
Default Table Name  apControl 
Definition  
Accounts Payable Table - Data Entry Control
 

apControl Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Batch(PK)    nvarchar(32)  NO  
Name of the accounts payable data entry transaction file.
 
PostPeriod    int  NO  
Accounting period when this transaction was posted.
 
PostSeq    int  NO  
The posting sequence number.
 
Recurring    varchar(1)  NO  
Flag indicating whether this is a recurring transaction file. Y-Yes, N-No.
 
Selected    varchar(1)  NO  
Flag indicating whether this file has been selected for posting. Y-Yes, N-No.
 
Posted    varchar(1)  NO  
Flag indicating whether this file has been posted. Y-Yes, N-No.
 
Creator    nvarchar(32)  YES  
Username of the file's creator.
 
Period    int  NO  
Accounting period when the transaction was entered.
 
EndDate    datetime  YES  
The end date of the accounting period when the transaction was entered.
 
Total    decimal(19, 4)  NO  
Total amount entered for the transaction file.
 
DefaultLiab    nvarchar(10)  YES  
Default liability code to use for entries in the data entry file.
 
DefaultBank    nvarchar(10)  YES  
Default bank code to use for entries in the data entry file.
 
DefaultDate    datetime  YES  
Default date to use for entries in the data entry 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.
 
DefaultCurrencyCode    nvarchar(3)  YES  
The default transaction currency code to use in the data entry file.
 
SubmittedBy    nvarchar(20)  YES  
The EmployeeID of the employee who submitted the data entry file for approval.
 
SubmittedDate    datetime  YES  
The date when the SubmittedBy employee submitted the data entry file for approval.
 
Description    nvarchar(40)  YES  
Name of the accounts payable data entry transaction file.
 
VoucheredFromPO    varchar(1)  NO  
For future use.
 
CloseFullyVoucheredPO    varchar(1)  NO  
For future use.
 

apControl Primary and Unique Keys 
Key Name  Key Type  Keys 
apControlPK  PrimaryKey  Batch 

apControl 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