TRACKER WBFiMOBJAWRADMN 3 INCLUDE SQLCA BEGIN DECLARE SECTION END DECLARE SECTION DECLARE CLIENT_CURS CURSOR FOR SELECT CLIENT_NUMBER, STREET_ADDRESS, STREET_ADDRESS2, CITY, ZIP_CODE, STATE, CLIENT_NAME, PRIMARY_CONTACT, ALTERNATE_CONTACT, PRODUCT_ID, PRODUCT_VERSION, BRANCH_MANAGER, ACCOUNT_REP, COUNTRY, PHONE, FAX FROM CLIENT_INFORMATION WHERE PRODUCT_ID LIKE :szClientProduct AND BRANCH_MANAGER LIKE :szBranch AND ZIP_CODE LIKE :szZip AND COUNTRY LIKE :szCountry AND STATE LIKE :szState AND CITY LIKE :szCity AND ACCOUNT_REP LIKE :szRep AND ALTERNATE_CONTACT LIKE :szAltContact AND PRIMARY_CONTACT LIKE :szPrimContact AND CLIENT_NAME LIKE :szClientName AND CLIENT_NUMBER LIKE :szClientNbr AND PRODUCT_VERSION LIKE :szVersion ORDER BY CLIENT_NUMBER DECLARE TRACKER_CURS CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM FROM TRACKER_INFO WHERE (SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PROGRAMMER LIKE :szResource AND COMMENTS LIKE :szComments AND PRODUCT_CODE = :szProduct) ORDER BY SI_TYPE, SI_NUMBER DECLARE TRACKER_CURS2 CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM FROM TRACKER_INFO WHERE (SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PROGRAMMER LIKE :szResource AND COMMENTS LIKE :szComments AND ECD >= :szECD_Begin AND ECD <= :szECD_End AND PRODUCT_CODE = :szProduct) ORDER BY SI_TYPE, SI_NUMBER DECLARE TRACKER_CURS3 CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM FROM TRACKER_INFO WHERE (SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PROGRAMMER LIKE :szResource AND COMMENTS LIKE :szComments AND CLOSE_DATE >= :szClose_Begin AND CLOSE_DATE <= :szClose_End AND PRODUCT_CODE = :szProduct) ORDER BY SI_TYPE, SI_NUMBER DECLARE TRACKER_CURS4 CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM FROM TRACKER_INFO WHERE (SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PROGRAMMER LIKE :szResource AND COMMENTS LIKE :szComments AND ASN_DATE >= :szASN_Begin AND ASN_DATE <= :szASN_End AND PRODUCT_CODE = :szProduct) ORDER BY SI_TYPE, SI_NUMBER DECLARE TRACKER_CURS5 CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM FROM TRACKER_INFO WHERE (SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PROGRAMMER LIKE :szResource AND COMMENTS LIKE :szComments AND ECD >= :szECD_Begin AND ECD <= :szECD_End AND CLOSE_DATE >= :szClose_Begin AND CLOSE_DATE <= :szClose_End AND PRODUCT_CODE = :szProduct) ORDER BY SI_TYPE, SI_NUMBER DECLARE TRACKER_CURS6 CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM FROM TRACKER_INFO WHERE (SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PROGRAMMER LIKE :szResource AND COMMENTS LIKE :szComments AND ECD >= :szECD_Begin AND ECD <= :szECD_End AND ASN_DATE >= :szASN_Begin AND ASN_DATE <= :szASN_End AND PRODUCT_CODE = :szProduct) ORDER BY SI_TYPE, SI_NUMBER DECLARE TRACKER_CURS7 CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM FROM TRACKER_INFO WHERE (SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PROGRAMMER LIKE :szResource AND COMMENTS LIKE :szComments AND CLOSE_DATE >= :szClose_Begin AND CLOSE_DATE <= :szClose_End AND ASN_DATE >= :szASN_Begin AND ASN_DATE <= :szASN_End AND PRODUCT_CODE = :szProduct) ORDER BY SI_TYPE, SI_NUMBER DECLARE ASSIGN_SUM_CURS CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM, ASN_DATE, ECD FROM TRACKER_INFO WHERE (CLOSE_DATE = '01-01-0001' AND SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PROGRAMMER LIKE :szResource AND PRODUCT_CODE = :szProduct) ORDER BY PROGRAMMER, LOB, SI_TYPE, SI_NUMBER, PRIORITY OPEN ASSIGN_SUM_CURS FETCH ASSIGN_SUM_CURS INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem, :szASN_Date, :szECD_Date CLOSE ASSIGN_SUM_CURS DECLARE ASS_LOB_SUM_CURS CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM, ASN_DATE, ECD FROM TRACKER_INFO WHERE (CLOSE_DATE = '01-01-0001' AND SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PROGRAMMER LIKE :szResource AND PRODUCT_CODE = :szProduct AND LOB LIKE :szLOB) ORDER BY LOB, SI_TYPE, PRIORITY, SI_NUMBER OPEN ASS_LOB_SUM_CURS FETCH ASS_LOB_SUM_CURS INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem, :szASN_Date, :szECD_Date CLOSE ASS_LOB_SUM_CURS DECLARE CLOSURE_SUM_CURS CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM, CLOSE_DATE FROM TRACKER_INFO WHERE (CLOSE_DATE >= :szBegin_Date AND CLOSE_DATE <= :szEnd_Date AND SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PROGRAMMER LIKE :szResource AND PRODUCT_CODE = :szProduct) ORDER BY LOB, SI_TYPE, PRIORITY, SI_NUMBER OPEN CLOSURE_SUM_CURS FETCH CLOSURE_SUM_CURS INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem, :szClose_Date CLOSE CLOSURE_SUM_CURS DECLARE OPEN_SUM_CURS CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM, CLOSE_DATE FROM TRACKER_INFO WHERE (CLOSE_DATE = '01-01-0001' AND SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PRODUCT_CODE = :szProduct) ORDER BY LOB, SI_TYPE, PRIORITY, SI_NUMBER OPEN OPEN_SUM_CURS FETCH OPEN_SUM_CURS INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem, :szClose_Date CLOSE OPEN_SUM_CURS SELECT MAX(MEMO_ITEM) INTO :sMemo_Item FROM TRACKER_MEMO WHERE ITEM = :sItem AND SI_TYPE = :szType AND SI_NUMBER = :szNumber AND PRODUCT_CODE = :szProduct INSERT INTO TRACKER_MEMO (SI_TYPE, SI_NUMBER, ITEM, NAME_TO, NAME_FROM, SUBJECT, MEMO_TEXT, MEMO_DATE, MEMO_ITEM, PRODUCT_CODE) VALUES (:szType, :szNumber, :sItem, :szMemo_To, :szMemo_From, :szMemo_Subject, :szMemo_Text, :szMemo_Date, :sMemo_Item, :szProduct) COMMIT SELECT MAX(ITEM) INTO :sItem FROM TRACKER_INFO WHERE PRODUCT_CODE = :szProduct INSERT INTO TRACKER_INFO (SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, COMMENTS, ECD, ASN_DATE, CLOSE_DATE, PROGRAMMER, ITEM, PRODUCT_CODE) VALUES (:szType, :szNumber, :szPriority, :szLOB, :szStatus, :szComments, :szECD_Date, :szASN_Date, :szClose_Date, :szResource, :sItem, :szProduct) COMMIT SELECT CLIENT_NUMBER INTO :szClientNbrTemp FROM CLIENT_INFORMATION WHERE CLIENT_NUMBER = :szClientNbr INSERT INTO CLIENT_INFORMATION (CLIENT_NUMBER, STREET_ADDRESS, STREET_ADDRESS2, CITY, ZIP_CODE, STATE, CLIENT_NAME, PRIMARY_CONTACT, ALTERNATE_CONTACT, PRODUCT_ID, PRODUCT_VERSION, BRANCH_MANAGER, ACCOUNT_REP, COUNTRY, PHONE, FAX) VALUES (:szClientNbr , :szAddress1 , :szAddress2 , :szCity , :szZip , :szState , :szClientName , :szPrimContact , :szAltContact , :szClientProduct, :szVersion , :szBranch , :szRep , :szCountry , :szPhone , :szFax) COMMIT UPDATE CLIENT_INFORMATION SET STREET_ADDRESS = :szAddress1 , STREET_ADDRESS2 = :szAddress2 , CITY = :szCity , ZIP_CODE = :szZip , STATE = :szState , CLIENT_NAME = :szClientName , PRIMARY_CONTACT = :szPrimContact , ALTERNATE_CONTACT = :szAltContact , PRODUCT_ID = :szClientProduct , PRODUCT_VERSION = :szVersion , BRANCH_MANAGER = :szBranch , ACCOUNT_REP = :szRep , COUNTRY = :szCountry , PHONE = :szPhone , FAX = :szFax WHERE CLIENT_NUMBER = :szClientNbr COMMIT UPDATE TRACKER_INFO SET SI_TYPE = :szType, SI_NUMBER = :szNumber, PRIORITY = :szPriority, LOB = :szLOB, STATUS = :szStatus, COMMENTS = :szComments, ECD = :szECD_Date, ASN_DATE = :szASN_Date, CLOSE_DATE = :szClose_Date, PROGRAMMER = :szResource WHERE ITEM = :sItem AND PRODUCT_CODE = :szProduct COMMIT DELETE FROM CLIENT_INFORMATION WHERE CLIENT_NUMBER = :szClientItem COMMIT DELETE FROM TRACKER_INFO WHERE ITEM = :sItem AND PRODUCT_CODE = :szProduct COMMIT SELECT CLIENT_NUMBER, STREET_ADDRESS, STREET_ADDRESS2, CITY, ZIP_CODE, STATE, CLIENT_NAME, PRIMARY_CONTACT, ALTERNATE_CONTACT, PRODUCT_ID, PRODUCT_VERSION, BRANCH_MANAGER, ACCOUNT_REP, COUNTRY, PHONE, FAX INTO :szClientNbr , :szAddress1 , :szAddress2 , :szCity , :szZip , :szState , :szClientName , :szPrimContact , :szAltContact , :szClientProduct, :szVersion , :szBranch , :szRep , :szCountry , :szPhone , :szFax FROM CLIENT_INFORMATION WHERE CLIENT_NUMBER = :szClientNbr OPEN CLIENT_CURS FETCH CLIENT_CURS INTO :szClientNbr , :szAddress1 , :szAddress2 , :szCity , :szZip , :szState , :szClientName , :szPrimContact , :szAltContact , :szClientProduct, :szVersion , :szBranch , :szRep , :szCountry , :szPhone , :szFax CLOSE CLIENT_CURS SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ECD, ASN_DATE, CLOSE_DATE INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :szECD_Date:siECD_Date, :szASN_Date:siASN_Date, :szClose_Date:siClose_Date FROM TRACKER_INFO WHERE ITEM = :sItem AND PRODUCT_CODE = :szProduct SELECT MAX(MEMO_ITEM) INTO :sMemoCounter FROM TRACKER_MEMO WHERE ITEM = :sItem AND SI_TYPE = :szType AND SI_NUMBER = :szNumber AND PRODUCT_CODE = :szProduct OPEN TRACKER_CURS FETCH TRACKER_CURS INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem CLOSE TRACKER_CURS OPEN TRACKER_CURS2 FETCH TRACKER_CURS2 INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem CLOSE TRACKER_CURS2 OPEN TRACKER_CURS3 FETCH TRACKER_CURS3 INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem CLOSE TRACKER_CURS3 OPEN TRACKER_CURS4 FETCH TRACKER_CURS4 INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem CLOSE TRACKER_CURS4 OPEN TRACKER_CURS5 FETCH TRACKER_CURS5 INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem CLOSE TRACKER_CURS5 OPEN TRACKER_CURS6 FETCH TRACKER_CURS6 INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem CLOSE TRACKER_CURS6 OPEN TRACKER_CURS7 FETCH TRACKER_CURS7 INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem CLOSE TRACKER_CURS7 DECLARE PRODUCT CURSOR FOR SELECT PRODUCT FROM PRODUCT_CODE ORDER BY PRODUCT DECLARE TYPE CURSOR FOR SELECT TYPE_TXT FROM TYPE ORDER BY TYPE_TXT DECLARE LOB CURSOR FOR SELECT LOB_TXT FROM LOB ORDER BY LOB_TXT DECLARE STATUS CURSOR FOR SELECT STATUS_TXT FROM STATUS ORDER BY STATUS_TXT OPEN TYPE OPEN LOB OPEN STATUS OPEN PRODUCT FETCH PRODUCT INTO :szData FETCH TYPE INTO :szData FETCH LOB INTO :szData FETCH STATUS INTO :szData CLOSE TYPE CLOSE LOB CLOSE STATUS CLOSE PRODUCT DECLARE ASSIGN_CURS CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM, ASN_DATE, ECD FROM TRACKER_INFO WHERE (CLOSE_DATE = '01-01-0001' AND SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PROGRAMMER LIKE :szResource AND PRODUCT_CODE = :szProduct) ORDER BY PROGRAMMER, SI_TYPE, SI_NUMBER, LOB, PRIORITY OPEN ASSIGN_CURS FETCH ASSIGN_CURS INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem, :szASN_Date, :szECD_Date CLOSE ASSIGN_CURS DECLARE ASSIGN_LOB_CURS CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM, ASN_DATE, ECD FROM TRACKER_INFO WHERE (CLOSE_DATE = '01-01-0001' AND SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PROGRAMMER LIKE :szResource AND PRODUCT_CODE = :szProduct AND LOB LIKE :szLOB) ORDER BY LOB, SI_TYPE, PRIORITY, SI_NUMBER OPEN ASSIGN_LOB_CURS FETCH ASSIGN_LOB_CURS INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem, :szASN_Date, :szECD_Date SELECT LOB_NAME INTO :szLOB_Name FROM LOB WHERE LOB_TXT = :szLOB_Tmp AND PRODUCT_CODE = :szProduct SELECT LOB_NAME INTO :szLOB_Name FROM LOB WHERE LOB_TXT = :szLOB_Tmp AND PRODUCT_CODE = :szProduct CLOSE ASSIGN_LOB_CURS DECLARE CLOSURE_CURS CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM, CLOSE_DATE FROM TRACKER_INFO WHERE (CLOSE_DATE >= :szBegin_Date AND CLOSE_DATE <= :szEnd_Date AND SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PROGRAMMER LIKE :szResource AND PRODUCT_CODE = :szProduct) ORDER BY LOB, SI_TYPE, PRIORITY, SI_NUMBER OPEN CLOSURE_CURS FETCH CLOSURE_CURS INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem, :szClose_Date SELECT LOB_NAME INTO :szLOB_Name FROM LOB WHERE LOB_TXT = :szLOB_Tmp AND PRODUCT_CODE = :szProduct SELECT LOB_NAME INTO :szLOB_Name FROM LOB WHERE LOB_TXT = :szLOB_Tmp AND PRODUCT_CODE = :szProduct CLOSE CLOSURE_CURS DECLARE OPEN_CURS CURSOR FOR SELECT SI_TYPE, SI_NUMBER, PRIORITY, LOB, STATUS, PROGRAMMER, COMMENTS, ITEM, CLOSE_DATE FROM TRACKER_INFO WHERE (CLOSE_DATE = '01-01-0001' AND SI_TYPE LIKE :szType AND SI_NUMBER LIKE :szNumber AND PRIORITY LIKE :szPriority AND LOB LIKE :szLOB AND STATUS LIKE :szStatus AND PRODUCT_CODE = :szProduct) ORDER BY LOB, SI_TYPE, PRIORITY, SI_NUMBER OPEN OPEN_CURS FETCH OPEN_CURS INTO :szType, :szNumber, :szPriority, :szLOB, :szStatus, :szResource, :szComments, :sItem, :szClose_Date SELECT LOB_NAME INTO :szLOB_Name FROM LOB WHERE LOB_TXT = :szLOB_Tmp AND PRODUCT_CODE = :szProduct SELECT LOB_NAME INTO :szLOB_Name FROM LOB WHERE LOB_TXT = :szLOB_Tmp AND PRODUCT_CODE = :szProduct CLOSE OPEN_CURS DECLARE MEMO_CURS CURSOR FOR SELECT MEMO_ITEM, NAME_TO, MEMO_DATE, SUBJECT FROM TRACKER_MEMO WHERE ITEM = :sItem AND SI_TYPE = :szType AND SI_NUMBER = :szNumber AND PRODUCT_CODE = :szProduct ORDER BY MEMO_ITEM OPEN MEMO_CURS FETCH MEMO_CURS INTO :sMemo_Item, :szMemo_To, :szMemo_Date, :szMemo_Subject CLOSE MEMO_CURS SELECT SI_TYPE, SI_NUMBER, ITEM, NAME_TO, NAME_FROM, SUBJECT, MEMO_TEXT, MEMO_DATE, MEMO_ITEM, PRODUCT_CODE INTO :szType, :szNumber, :sItem, :szMemo_To, :szMemo_From, :szMemo_Subject, :szMemo_Text, :szMemo_Date, :sMemo_Item, :szProduct FROM TRACKER_MEMO WHERE ITEM = :sItem AND SI_TYPE = :szType AND SI_NUMBER = :szNumber AND PRODUCT_CODE = :szProduct AND MEMO_ITEM = :sMemo_Item UPDATE TRACKER_MEMO SET SI_TYPE = :szType, SI_NUMBER = :szNumber, NAME_TO = :szMemo_To, NAME_FROM = :szMemo_From, SUBJECT = :szMemo_Subject, MEMO_TEXT = :szMemo_Text, MEMO_DATE = :szMemo_Date, PRODUCT_CODE = :szProduct WHERE ITEM = :sItem AND SI_TYPE = :szType AND SI_NUMBER = :szNumber AND MEMO_ITEM = :sMemo_Item AND PRODUCT_CODE = :szProduct COMMIT DELETE FROM TRACKER_MEMO WHERE ITEM = :sItem AND SI_TYPE = :szType AND SI_NUMBER = :szNumber AND MEMO_ITEM = :sMemo_Item AND PRODUCT_CODE = :szProduct COMMIT SELECT MEMO_DATE INTO :szMemo_Date FROM TRACKER_MEMO WHERE ITEM = :sItem AND SI_TYPE = :szType AND SI_NUMBER = :szNumber AND PRODUCT_CODE = :szProduct AND MEMO_ITEM = :sMemo_Item szProduct Product szType szNumber szPriority szLOB szStatus szComments szECD_Date szASN_Date szClose_Date szLast_Update_Date szBegin_Date szEnd_Date szECD_Begin szASN_Begin szClose_Begin szECD_End szASN_End szClose_End szResource sItem szMemo_To szMemo_From szMemo_Subject szMemo_Text szMemo_Date sMemo_Item sMemoCounter siECD_Date siASN_Date siClose_Date siLast_Update_Date szData szType_Hld szNumber_Hld szPriority_Hld szLOB_Hld szLOB_Tmp szLOB_Name szStatus_Hld szComments_Hld szECD_Date_Hld szASN_Date_Hld szClose_Date_Hld szResource_Hld szClientProduct szBranch szZip szCountry szState szCity szAddress1 szAddress2 szFax szPhone szRep szAltContact szPrimContact szClientName szClientNameTmp szClientNbr szClientItem szVersion szClientNbrTemp