BTBG 
Default Table Name  BTBG 
Definition  
Billing Terms Billing Group Table
 

BTBG Columns 
ColumnName  Domain  Datatype  NULL  Definition 
MainWBS1(PK)    nvarchar(30)  NO  
Project for which the entire invoice is being created.
 
ConsolidatePrint    varchar(1)  NO  
Variable indicating whether to print all of the projects in the billing group as one project.
 
SeparateTerms    varchar(1)  NO  
Variable indicating whether to allow separate billing terms for each project in the billing group.
 
ConsolidatePost    varchar(1)  NO  
Variable indicating whether to post all of the sub-projects to the main project in the billing group.
 
OverallLimit    varchar(1)  NO  
Variable indicating whether the main project in the billing group has billing limits specified.
 
PrintAR    varchar(1)  YES  
Variable indicating whether to print outstanding accounts receivable for groups or projects. Valid options are G-Group, P-Project.
 
PrintBTD    varchar(1)  YES  
Variable indicating whether to print interest charges for groups or projects. Valid options are G-Group, P-Project.
 
PrintInterest    varchar(1)  YES  
Variable indicating whether to print interest charges for groups or projects. Valid options are G-Group, P-Project.
 
PrintTax    varchar(1)  YES  
Variable indicating whether to print taxes for groups or projects. Valid options are G-Group, P-Project.
 
PrintRet    varchar(1)  YES  
Variable indicating whether to print retainage for groups or projects. Valid options are G-Group, P-Project.
 
PrintAdd    varchar(1)  NO  
Flag indicating whether to print a retainer when the retainer is an add-on.
 
ConsolidateTaxPost    varchar(1)  NO  
Flag indicating whether the Consolidate tax posting option is selected.
 

BTBG Primary and Unique Keys 
Key Name  Key Type  Keys 
BTBGPK  PrimaryKey  MainWBS1 

BTBG 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