Class CU_SCRMLink_bus

Inherits

SY_Common, SY_OpenObject, SY_Password

Properties

LOCAL cCommandTimeout=0  
LOCAL cInterfaceVersion=2  
LOCAL cUsersEntity=0  
LOCAL cCompanyEntity=1  
LOCAL cPersonEntity=2  
LOCAL cAddressEntity=3  
LOCAL cAddressLinkEntity=4  
LOCAL cEmailEntity=5  
LOCAL cPhoneEntity=6  
LOCAL cOpportunityEntity=7  
LOCAL cOrderQuoteEntity=8  
LOCAL cNotesEntity=9  
LOCAL cCountryEntity=10  
LOCAL c61OrderEntity=11  
LOCAL c61QuoteEntity=12  
LOCAL cEmailLinkEntity=13  
LOCAL cPhoneLinkEntity=14  
LOCAL cMASCompanyEntity=15  
LOCAL cInstanceConfigEntity=100  
LOCAL cOrderQuoteDetailEntity=101  
LOCAL c61OrderDetailEntity=102  
LOCAL c61QuoteDetailEntity=103  
LOCAL cEntityOrder$="15, 0, 10, 1, 2, 3, 4, 5, 13, 6, 14, 7, 8, 12, 11, 9"  
LOCAL cMASUpdatedColumn$="UPDATED$"  
LOCAL cMASDateColumn$="DATETIMESTAMP$"  
LOCAL cMaxTextLength=5000  
LOCAL adCmdText=1  
LOCAL adCmdStoredProc=4  
LOCAL adClipString=2  
LOCAL adExecuteNoRecords=128  
LOCAL adVarChar=200  
LOCAL adInteger=3  
LOCAL adParamInput=1  
LOCAL adParamOutput=2  
LOCAL adParamInputOutput=3  
LOCAL adParamReturnValue=4  
LOCAL adTextNoRecords=129  
LOCAL adOpenForwardOnly=0  
LOCAL adOpenStatic=3  
LOCAL adLockReadOnly=1  
LOCAL adUseServer=2  
LOCAL adUseClient=3  
LOCAL cModuleCode$="C/U"  

Methods

FUNCTION CloseCRMConnection()  

Close connection to CRM Database.

Returns [boolean] Always returns True = success
FUNCTION Init(companyCode$, notifyHwnd, notifyMsg, transactionsOff, reserved$)  
FUNCTION Init(companyCode$, notifyHwnd, notifyMsg, transactionsOff, threadKey$, engineVersion, extendedData$)  

Initialize class, setup required to push data to / from Sage 100 / CRM

ParameterDescription
companyCode$ [input, string] The Company Code of the data to push
notifyHwnd [input, numeric] Used to set cNotifyHwnd in SetNotify()
notifyMsg [input, boolean] Used to set cNotifyMsg in SetNotify()
transactionsOff [input, boolean] Sets local propery, cTransactionsOff
reserved$ [input, string] Placeholder for null threadKey$
threadKey$ [input, string] Sets local propery, cThreadKey$
engineVersion {optional} [input, numeric] Sets local propery, cThreadKey$
extendedData$ {optional} [input, string] Currently not used
Returns [boolean] True = success, False = failure
FUNCTION OpenCRMConnection()  

Open connection to CRM Database.

Returns [boolean] True = success, False = failure
FUNCTION PreSync()  

Executes OpenCRMConnection()

Returns [boolean] True = success, False = failure (from OpenCRMConnection())
FUNCTION PushToCRM()  

Push data from Sage 100 to CRM, requires Init() be processed before this call

Returns [boolean] True = success, False = failure
FUNCTION PushToMAS()  

Push data from Sage 100 to CRM, requires Init() be processed before this call when SetNotify returns greater than zero

Returns [boolean] True = success, False = failure
FUNCTION RepairMAS(progressObj)  
FUNCTION SetNotify(notifyHwnd, notifyMsg)  
FUNCTION SetTransactionMode(transactionsOff)  
FUNCTION Sync(syncDirection, reserved1$, reserved2$)  

Initialize class, setup required to push data to / from Sage 100 / CRM

ParameterDescription
syncDirection [input, numeric] 1 = PushToMas(), 2 = PushToCRM()
reserved1$ [input, string] Currently not used
reserved2$ [input, string] Currently not used
Returns [boolean] True = success, False = failure (Based upon syncDirection return value is from PushToMas() or PushToCRM(); if syncDirection = 0, will return failure.)

Properties inherited from: SY_OpenObject

cLockInfoNOKEY$

Properties inherited from: SY_Password

AESCipher$, AES256Cipher$

Methods inherited from: SY_Common

FormatAddress(), ParseCityStateZip(), ClassValidateDirectory(), DirectoryCheck(), GetNextSequence(), GetUNCNamedDrive(), IsInstalled(), LocalizeFileIOList(), LocalizeIOList(), PackSequence$(), UnpackSequence(), UseChildKeyColl()

Methods inherited from: SY_OpenObject

CheckWhoHasLock(), CreateLockInfo(), RemoveLockInfo(), OpenTable(), OpenTempFile()

Methods inherited from: SY_Password

ConfirmAESKey(), ConfirmPassword(), EncryptAESData(), EncryptAESKey(), EncryptAESPassword(), EncryptPassword(), GetAESDataTest$(), PasswordAcceptable(), ValidateAESData(), ValidateAESPassword(), ValidatePassword(), VerifyAESDataEncryption(), DecryptAESData(), DecryptAESKey(), DecryptAESPassword(), DecryptAltAESData(), DecryptPassword(), EncryptAltAESData(), GetKEK$(), InitAESKey(), InitializeAES(), InitializeAltAES(), ValidateAltAESData(), VerifyAltAESDataEncryption()