Touchstone 4.0 Database Documentation
tUNICEDE2CountryLOBXref Table
Description

System reference table used to identify the Line of Business by country that can be used in UNICEDE/2. This information is used to enable the use of the UNICEDE/2 Line of Business by country codes in Touchstone.

Properties
Creation Date1/10/2012 12:18 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows632
Data Space Used24.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key UNICEDE2LineofBusinessCode

Code that represents the UNICEDE/2 Line of Business.

For a complete list of codes, see tUNICEDE2LineofBusiness Table.

UnsignedTinyInt1   
Primary Key CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

VarChar15   
Objects that tUNICEDE2CountryLOBXref depends on
 Database ObjectObject TypeDescriptionDep Level
tUNICEDE2LineofBusiness tabletUNICEDE2LineofBusinessTable

Stores information regarding Line of Business types that can be used in UNICEDE/2. This information is used to enable the use of the UNICEDE/2 Line of Business type codes in Touchstone.

1
See Also

Related Objects

AIRReference Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.