VI_ImportJobMaintenance

Class VI_ImportJobMaintenance_bus

Inherits

SY_Maint, VI_Common, VI_CommonEntry

Properties

LOCAL cIsSysDB=isTRUE

isTRUE=MAS_SYSTEM, isFalse=MAS_XXX

LOCAL cMainTable$="VI_JobHeader"

Table maintained by business object

LOCAL cTempPrefix$="Temp"

variable to preface Temp field names

PROPERTY ObsoleteLinks$ * Read Only *

Methods

FUNCTION CalcColumns(col$, col)

FUNCTION CheckElemCount()

FUNCTION Clear()

FUNCTION ClearMemFiles()

FUNCTION ColToElemSeq(colPfx$, col$, seq$)

FUNCTION ColToSelSeq(col$, seq$)

FUNCTION CompileJob(job$, CompiledName$)

FUNCTION CopyJob(copyFromJob$, copyToJob$)

FUNCTION CreateCompiledName$()

FUNCTION CreateLib(job$)

FUNCTION CreateTempField()

FUNCTION CreateTempField(TempFieldName$)

CreateTempField creates the name of the temp field, characters will be formatted as Temp_xxx, numerics as Temp000 or Temp1234 if > 999

Parameter	Description
TempFieldName$	[input, string] field name to be prepended with "Temp"

Returns

[boolean] True = success, False = failure

FUNCTION Delete(Key$)

FUNCTION DictElemToEMem(colPfx$, ddeKey$, seq$)

FUNCTION DictElemToRMem(desc$, ddeKey$, iTyp$, rTyp$)

FUNCTION DictElemToSMem(colPfx$, ddeKey$)

FUNCTION GetAvailTables$(pfx$)

FUNCTION GetAvailTreeFlds(tbl$, col$, ref$, dde$, first)

FUNCTION GetBusObjName(mainTable$, busObj$, UDTable$)

FUNCTION GetColFromDde(tbl$, col$, rec$, iol$)

FUNCTION GetColumns(table$, colList$, keyList$)

FUNCTION GetCurrentCols$()

FUNCTION GetHeaderRecord(job$, rec$, iol$)

FUNCTION GetImportFileType$()

FUNCTION GetIolist(ch$, iolist$)

FUNCTION GetLinkKey(priTbl$, lnkTbl$, priKey$)

FUNCTION GetMainTables$()

FUNCTION GetNextTempField$()

Gets Next 3 Character Sequence for end of Temp Field

FUNCTION GetPerforms$()

FUNCTION GetTableInfo(mainTable$, lineTable$, keyCols$, extnTBL.BusObj$, UDTable$, table3$)

FUNCTION GetTableInfo(mainTable$, lineTable$, keyCols$, extnTBL.BusObj$, UDTable$, table3$, bmOpt$, bmOptDtl$, bmInt$, bmIntDtl$, bmOptCat$, pmtInfo$, prTax$, wtStep$)

GetTableInfo returns main table key columns list and dependent table info (detail lines, payment, etc.) associated with a business object

Parameter	Description
mainTable$	[input, string] main table associated with a business object
lineTable$	[output, string] detail line table associated with the main table business object, if applicable
keyCols$	[output, string] comma separated list of key columns associated with the main table business object
extnTBL.BusObj$	[output, string] extended business object associated with the main table business object, if applicable
UDTable$	[output, string] UDT table associated with the main table business object, if applicable
table3$	[output, string] tertiary table (lot / serial tier or check distribution) associated with the lineTable$ business object, if applicable
bmOpt$	[output, string] bill options header table associated with the bill header main table business object, if applicable
bmOptDtl$	[output, string] bill options detail table associated with the bill header options header table business object, if applicable
bmInt$	[output, string] bill options interactions header table associated with the bill options header table business object, if applicable
bmIntDtl$	[output, string] bill options interactions detail line table associated with the bill options interactions header table business object, if applicable
bmOptCat$	[output, string] bill options categories table associated with the bill header main table business object, if applicable
pmtInfo$	[output, string] payment table associated with the main table business object, if applicable
prTax$	[output, string] payrol tax detail table associated with the main table business object, if applicable
wtStep$	[output, string] PM work ticket step detail table associated with the work ticket main table business object, if applicable

Returns

[boolean] True = success, False = failure

FUNCTION LoadAvailFields$(param)

FUNCTION LoadAvailRecTypes$()

FUNCTION LoadDfltPerforms()

FUNCTION LoadDfltPerforms(resetExisting)

LoadDfltPerforms loads default performs established for a table / business object on demand

Parameter	Description
resetExisting	{optional} [input, boolean] when true (1) reset, when false (0) do not reset, existing perform to default when it already exists on the job

Returns

[integer] count of default performs processed on the job

FUNCTION LoadElements()

FUNCTION LoadImportFlds$()

FUNCTION LoadLinkedTbls(HSTable$, LnTable$, LLnTable$, PYTable$, PTTable$)

FUNCTION LoadLinkedTbls(HSTable$, LnTable$, LLnTable$, PYTable$, PTTable$, OHTable$, OLnTable$, OIHTable$, OILnTable$, OCTable$, WTStepTable$)

LoadLinkedTbls returns list of tables linked with a business object as defined in SY_ExportLink.M4T (using VI clone of SY0DCT dictionary for legacy and child collection definitions in business objects for framework)

Parameter	Description
HSTable$	[output, string] linked tables associated with the HSTable$ business object
LnTable$	[output, string] linked tables associated with the detail business object included in the header business object, if applicable
LLnTable$	[output, string] linked tables associated with the tertiary (lot / serial tier or check distribution) business object included in the LnTable$ business object, if applicable
PYTable$	[output, string] linked tables associated with the payments table included in the HSTable$ business object, if applicable
PTTable$	[output, string] linked tables associated with the PR tax detail tables included in the HSTable$ business object, if applicable
OHTable$	[output, string] linked tables associated with the bill options header table included in the main bill header business object, if applicable
OLnTable$	[output, string] linked tables associated with the bill options detail table included in the bill options header table business object, if applicable
OIHTable$	[output, string] linked tables associated with the bill options interactions header table included in the bill options header table business object, if applicable
OILnTable$	[output] linked tables associated with the bill options interactions detail line table included in the bill options interactions header table business object, if applicable
OCTable$	[output, string] linked tables associated with the bill options categories table included in the bill options header table business object, if applicable
WTStepTable$	[output, string] linked tables associated with the work ticket step detail table included in the work ticket header table business object, if applicable

Returns

[boolean] Always returns True = success

FUNCTION LoadPerforms()

FUNCTION LoadRecTypes()

FUNCTION LoadSelects()

FUNCTION MemToElemRow(seq$, field$)

FUNCTION MemToElemRows(fields$)

FUNCTION MemToERec(seq$, rec$)

FUNCTION MemToRecTypeRow(seq$, field$)

FUNCTION MemToRecTypeRows(fields$)

FUNCTION MemToRRec(seq$, rec$)

FUNCTION MemToSelRow(seq$, field$)

FUNCTION MemToSelRows(fields$)

FUNCTION MemToSRec(seq$, rec$)

FUNCTION ODBCAddAllFields$()

FUNCTION ODBCAddAllTables$()

FUNCTION ODBCAddField(key$, field$)

FUNCTION ODBCAddLink(tbl1$, fld1$, rel$, tbl2$, fld2$)

FUNCTION ODBCAddTable(key$, table$)

FUNCTION ODBCChangeSQLStmt(sql$)

FUNCTION ODBCDelAllFields()

FUNCTION ODBCDelAllTables()

FUNCTION ODBCDelField(key$)

FUNCTION ODBCDelLink(lnkKey$)

FUNCTION ODBCDelTable(key$)

FUNCTION ODBCGetLink(lnkKey$, rec$, iol$)

FUNCTION ODBCGetSqlStmt$()

FUNCTION ODBCLinkField$(tableName$)

FUNCTION ODBCLinkTable$(excludeTable$)

FUNCTION ODBCLoadMemFields()

FUNCTION ODBCLoadMemLinks()

FUNCTION ODBCLoadMemTables()

FUNCTION ODBCLoadSelFields$()

FUNCTION ODBCLoadSelLinks$()

FUNCTION ODBCLoadSelTables$()

FUNCTION ODBCReadData(key$, List$, title$)

FUNCTION ODBCResetSqlStmt()

FUNCTION ODBCSetSQLModified()

FUNCTION ODBCTestSQL$(FIRST)

FUNCTION RecToMem(seq$, rec$)

FUNCTION RecToRMem(seq$, rec$)

FUNCTION RecToSMem(seq$, rec$)

FUNCTION RemoveElemFld(seq$)

FUNCTION RemoveRecTypeFld(seq$)

FUNCTION RemoveSelFld(seq$)

FUNCTION SetInsAllFlg(val$)

FUNCTION SetSepHdrFlg(val$)

FUNCTION SwitchElemMemFields(seq1$, seq2$)

FUNCTION SwitchRecMemFields(seq1$, seq2$)

FUNCTION SwitchSelMemFields(seq1$, seq2$)

FUNCTION WRITE()

FUNCTION WriteOdbc()

FUNCTION WritePerform(rec$, action$)

Properties inherited from: SY_Maint

cActionWrite, cActionDelete, cActivityLogFilePrefix$, DocDateWarnDisplayed, DocDateWarnStatus, EditState, RecordChanged, FirstFailure$, DocumentTotal, ReadOnlyReason$, UDTValidation$, ViewOnly, CurrentPrecision, DocDateWarnForceOff, DocDateWarnObject, ScriptObject, ImportTest, SkipNullCheck$, AFSRequiredFields$

Properties inherited from: VI_Common

cTempFieldLength

Methods inherited from: SY_Maint

ChangedRecordCompare(), ChangedRecordInfo(), Clear(), ClearRecord(), ConfirmDelete(), CopyFrom(), ExportToCSV(), GetColumnInfo(), GetColumnProperties$(), GetDefaults(), GetOrigRecord$(), GetPropertyValue(), GetValidationGroups$(), ResetDocDateWarnState(), SetCopyKeyValue(), SetDocDateWarnDisplayed(), SetDocDateWarnOff(), SetKey(), SetKeyValue(), SetPartialRecord(), SetRecord(), SetToReadOnly(), SetValue(), SetValues(), Write(), ActivityLogCreateFile(), ActivityLogPrepare(), ActivityLogSetMessage$(), ActivityLogWrite(), CallScript(), CheckForAdvancedFieldSettings(), CheckForScripts(), CheckNullRequiredField(), PERFORM ChildValidate(), ClassValidateDate(), ClassValidateTelephoneNo(), ClearSetFiles(), ColInfoInitAll(), ColInfoInitDefaults(), CommitRow(), GetPropertyCommon(), InitColInfo(), InitScriptEngine(), InitSearchForUpdate(), InitWorkTable(), IsColInIOList(), IsValid(), LoadColInfo(), OpenMainTable(), ParseExtField(), PreWriteScripts(), RemoveColToSkip(), ResetRow(), RetrieveColInfo(), SetDefaults(), SetFilter(), SetMode(), SetParentHandle(), SetValueNoValidate(), StoreColToSkip(), ValidateAll(), ValidateAllRecord(), ValidateColInfo(), ValidateRule()

Methods inherited from: VI_Common

AddDays$(), CheckTempFieldName(), ConvertIEEEDate$(), ConvertStepNoToStepLineKey(), ConvertToEmployeeKey$(), ConvertToFFA$(), ConvertToMFGEmployeeKey$(), ConvertToSRG$(), ConvertToWorkTicketKey$(), DaysDiff(), EncryptValue$(), FormatDate$(), FormatFFA$(), FormatTempFieldName(), GetFFALength(), GetLogFileInfo(), GetOptParameter$(), GetProductLineAccount$(), GetSegmentLength(), PayCyclePostWrite(), SpecialBusObjConsiderations(), SubstituteEmployeeKey$(), SubstituteMFGEmployeeKey$(), SubstituteWorkTicketKey$(), UserCode$(), UserKey$(), ValidateCustomer(), ValidateJobStatus(), ValidateVendor(), PERFORM DecryptAPVendorTaxPayerIDSSN(), PERFORM ParseDate(), PERFORM PIIDecrypt(), TestPerformMethod()

Methods inherited from: VI_CommonEntry

CheckCalcExpr(), ODBCFieldColumnLookup(), ODBCGetDataSrcs$(), ODBCLoadAvailFlds$(), ODBCLoadAvailTbls$(), ODBCLoadDSNFields(), ODBCLoadDSNTables(), PERFORM ODBCWriteField(), PERFORM ODBCWriteTable(), ValidateNextJobChain()