public string addSboFields()
{
string result = "Ok";
if (!sboApi.isDIConnected)
{
sboApi.connectCompany();
}
result = "Creating Configuration Table";
sboApi.AddTable("NOP_CFG", "NOP Configuration Table", BoUTBTableType.bott_NoObject);
sboApi.AddColumns("@NOP_CFG", "companyDb", "SBO Source Company", SAPbobsCOM.BoFieldTypes.db_Memo, 20, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "SboUID", "SBO User ID", SAPbobsCOM.BoFieldTypes.db_Memo, 15, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "SboPwd", "SBO User PWD", SAPbobsCOM.BoFieldTypes.db_Memo, 15, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "DbUserName", "DB User ID", SAPbobsCOM.BoFieldTypes.db_Memo, 15, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "DbPassword", "DB Password", SAPbobsCOM.BoFieldTypes.db_Memo, 15, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "ServerType", "DB User ID", SAPbobsCOM.BoFieldTypes.db_Memo, 5, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "SboServer", "DB Password", SAPbobsCOM.BoFieldTypes.db_Memo, 30, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "NopSServer", "NOP Server", SAPbobsCOM.BoFieldTypes.db_Memo, 30, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "NopDbName", "NOP DB Name", SAPbobsCOM.BoFieldTypes.db_Memo, 30, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "NopDbUserName", "NOP DB UID", SAPbobsCOM.BoFieldTypes.db_Memo, 15, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "NopDbPassword", "NOP Pwd", SAPbobsCOM.BoFieldTypes.db_Memo, 12, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "standardPricelist", "STD Price LIst", SAPbobsCOM.BoFieldTypes.db_Memo, 5, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "whsCode", "Warehouse", SAPbobsCOM.BoFieldTypes.db_Memo, 5, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "productImageFolder", "Product Image Folder", SAPbobsCOM.BoFieldTypes.db_Memo, 254, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "categorImageFolder", "Category Image Folder", SAPbobsCOM.BoFieldTypes.db_Memo, 254, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "SFI", "Sales Order Fetch Intervel", SAPbobsCOM.BoFieldTypes.db_Memo, 5, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "SSeries", "Sales Order Series", SAPbobsCOM.BoFieldTypes.db_Memo, 5, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "SSE", "Sales Employee", SAPbobsCOM.BoFieldTypes.db_Memo, 10, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_CFG", "SOwner", "Owner", SAPbobsCOM.BoFieldTypes.db_Memo, 10, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddTable("NOP_LOG", "NOP Log Table", BoUTBTableType.bott_NoObject);
sboApi.AddColumns("@NOP_LOG", "LogId", "ID", SAPbobsCOM.BoFieldTypes.db_Memo, 20, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_LOG", "DateTime", "Date Time", SAPbobsCOM.BoFieldTypes.db_Memo, 15, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_LOG", "LogBy", "Log By", SAPbobsCOM.BoFieldTypes.db_Memo, 15, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_LOG", "Action", "Action", SAPbobsCOM.BoFieldTypes.db_Memo, 15, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_LOG", "Dscription", "Description", SAPbobsCOM.BoFieldTypes.db_Memo, 250, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_LOG", "MsgType", "Message Type", SAPbobsCOM.BoFieldTypes.db_Memo, 15, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("@NOP_LOG", "CMNTS", "Additional Comments", SAPbobsCOM.BoFieldTypes.db_Memo, 250, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("OCRG", "NOPID", "NOPID", SAPbobsCOM.BoFieldTypes.db_Numeric, 8, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("OCRD", "NOPID", "NOPID", SAPbobsCOM.BoFieldTypes.db_Numeric, 8, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("OITB", "NOPID", "NOPID", SAPbobsCOM.BoFieldTypes.db_Numeric, 8, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("OITM", "NOPID", "NOPID", SAPbobsCOM.BoFieldTypes.db_Numeric, 8, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("OITB", "Father", "Fatehr Category Code", SAPbobsCOM.BoFieldTypes.db_Numeric, 8, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("OITB", "PORTAL", "Show on Web Portal", SAPbobsCOM.BoFieldTypes.db_Alpha, 1, SAPbobsCOM.BoFldSubTypes.st_None, "");
sboApi.AddColumns("OITB", "WebDscr", "Web Description", SAPbobsCOM.BoFieldTypes.db_Memo, 254, SAPbobsCOM.BoFldSubTypes.st_None, "");
return(result);
}
