📚 SAP Business One SDK Help

Table Name: TGG1

Table Description: Target Group Details

Field Description Type Size Related Default Value Constraints
TargetCode Target Group Code nVarChar 20 OTGG      
CardCode BP Code nVarChar 15 -      
CardName BP Name nVarChar 200 -      
GroupCode Group Code nVarChar 20 -      
Industry Industry Text 16 -      
validFor Active VarChar 1 -   A Active
            I Inactive
CntctPrsn Contact Person nVarChar 50 OCPR      
Title Title nVarChar 10 -      
Position Position nVarChar 90 -      
E_Mail E-Mail nVarChar 100 -      
Telephone Telephone nVarChar 50 -      
Cellolar Mobile Phone nVarChar 50 -      
Fax Fax nVarChar 50 -      
Address Address nVarChar 100 -      
Street Street nVarChar 100 -      
Block Block nVarChar 100 -      
City City nVarChar 100 -      
ZipCode Zip Code nVarChar 20 -      
County County nVarChar 100 -      
State State nVarChar 3 OCST      
Country Country/Region nVarChar 3 OCRY      
Building Building/Floor/Room Text 16 -      
LineNum Line Number Int 11 -      
FirstName First Name nVarChar 50 -      
MiddleName Middle Name nVarChar 50 -      
LastName Last Name nVarChar 50 -      
LicTradNum Federal Tax ID nVarChar 32 -      
AddrType Address Type nVarChar 100 -      
Address2 Address Name 2 nVarChar 50 -      
Address3 Address Name 3 nVarChar 50 -      
StreetNo Street No. nVarChar 100 -      
AddressID Address ID nVarChar 50 -      
Key Unique Field
PRIMARY Yes TargetCode
    LineNum