View Single Post
  #1 Old 02-20-2017, 12:23 AM
emailsnipper
 
emailsnipper's Avatar
 
Join Date: Apr 2015
Location: Carder
Posts: 157
emailsnipper is an unknown quantity at this point
Question [HELP] Please tell me what is this info?

Take from server host of https://freedomma-portals.ikaenterprise.com
GTPA_AFN_LOCKBOX_140227104226_T.TXT
Code:
1000000000     140227LOCKBOX                    US                                                                                    
700300013  80740             720015                                                                                                   
600300113350                                               13350             6070    MN00008815                       NO              
600300213350                                               13350             6070    MN00008852                       NO              
60030036100                                                6100              477     MN00006732                       NO              
60030046100                                                6100              478     MN00006733                       NO              
60030057140                                                7140              4072    MN00012007                       NO              
60030063270                                                3270              2255    MN00002958                       NO              
60030076100                                                6100              3515    MN00014346                       NO              
60030083270                                                3270              1223    MN00011454                       NO              
60030091370                                                1370              7084    MN00017014                       NO              
60030104270                                                4270              1703    MN00015898                       NO              
60030116100                                                6100              1017    MN00012048                       NO              
60030126100                                                6100              5172    MN00010305                       NO              
600301312200                                               12200             9902    MN00008771                       NO              
60030145370                                                5370              1009    MN00012002                       NO              
814    80740
GTPA_AFN_LOCKBOX_140227104226_T.TXT-Load.log
Code:
SQL*Loader: Release 11.2.0.1.0 - Production on Wed Mar 26 20:00:56 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
Control File:   D:\Billings\Freedom\AFCNC\Lockbox\Control_Scripts\Lockbox.ctl
Data File:      D:\Billings\Freedom\AFCNC\Lockbox\Inbound\GTPA_AFN_LOCKBOX_140227104226_T.TXT
  Bad File:     lockbox.bad
  Discard File: lockbox.dsc 
 (Allow 999 discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 999999
Bind array:     64 rows, maximum of 1000000 bytes
Continuation:    none specified
Path used:      Conventional
Table BNC_LOCKBOX_FILE_HEADER_M, loaded when 1:1 = 0X31(character '1')
Insert option in effect for this table: TRUNCATE
   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
RECORD_TYPE                           1:1     1           CHARACTER            
DESTINATION                          2:10     9           CHARACTER            
FILLER1                             11:15     5           CHARACTER            
DEPOSIT_DATE                        16:21     6           CHARACTER            
LOCKBOX                             22:28     7           CHARACTER            
ACCOUNT_NUMBER                      29:40    12           CHARACTER            
ROUTING                             41:48     8           CHARACTER            
CURRENCY                            49:52     4           CHARACTER            
FILLER2                            53:120    68           CHARACTER            
Table BNC_LOCKBOX_BATCH_HEADER_M, loaded when 1:1 = 0X37(character '7')
Insert option in effect for this table: TRUNCATE
   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
RECORD_TYPE                           1:1     1           CHARACTER            
BATCH_NUMBER                          2:4     3           CHARACTER            
ITEM_SEQUENCE_NO                      5:7     3           CHARACTER            
NUMBER_OF_CHECKS                     8:11     4           CHARACTER            
BATCH_TOTAL_CHECK_AMOUNT            12:29    18           CHARACTER            
FILLER                             30:120    91           CHARACTER            
Table BNC_LOCKBOX_DETAIL_MG, loaded when 1:1 = 0X36(character '6')
Insert option in effect for this table: TRUNCATE
   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
RECORD_TYPE                           1:1     1           CHARACTER            
BATCH_NUMBER                          2:4     3           CHARACTER            
ITEM_SEQUENCE_NO                      5:7     3           CHARACTER            
CHECK_AMOUNT                         8:25    18           CHARACTER            
AMOUNT_DUE                          26:43    18           CHARACTER            
STATEMENT_NUMBER                    44:59    16           CHARACTER            
STATEMENT_AMOUNT                    60:77    18           CHARACTER            
CHECK_NUMBER                        78:85     8           CHARACTER            
ACCOUNT_IDENTIFIER                  86:86     1           CHARACTER            
ACCOUNT_NUMBER                     87:102    16           CHARACTER            
GROUP_ID                          103:118    16           CHARACTER            
FILLER                            119:120     2           CHARACTER            
Table BNC_LOCKBOX_DETAIL_OVERFLOW_M, loaded when 1:1 = 0X34(character '4')
Insert option in effect for this table: TRUNCATE
   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
RECORD_TYPE                           1:1     1           CHARACTER            
BATCH_NUMBER                          2:4     3           CHARACTER            
ITEM_SEQUENCE_NO                      5:7     3           CHARACTER            
STATEMENT_NUMBER1                    8:23    16           CHARACTER            
APPLIED_AMOUNT1                     24:41    18           CHARACTER            
STATEMENT_NUMBER2                   42:57    16           CHARACTER            
APPLIED_AMOUNT2                     58:75    18           CHARACTER            
STATEMENT_NUMBER3                   76:91    16           CHARACTER            
APPLIED_AMOUNT3                    91:109    19           CHARACTER            
FILLER                            110:120    11           CHARACTER            
Table BNC_LOCKBOX_FILE_TRAILER_M, loaded when 1:1 = 0X38(character '8')
Insert option in effect for this table: TRUNCATE
   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
RECORD_TYPE                           1:1     1           CHARACTER            
TOTAL_RECORD_COUNT                    2:7     6           CHARACTER            
TOTAL_DEPOSIT_AMOUNT                 8:25    18           CHARACTER            
APPLY_TO_COUNT                      26:31     6           CHARACTER            
FILLER                             32:120    89           CHARACTER            
Table BNC_LOCKBOX_FILE_HEADER_M:
  1 Row successfully loaded.
  0 Rows not loaded due to data errors.
  16 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.
Table BNC_LOCKBOX_BATCH_HEADER_M:
  1 Row successfully loaded.
  0 Rows not loaded due to data errors.
  16 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.
Table BNC_LOCKBOX_DETAIL_MG:
  14 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  3 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.
Table BNC_LOCKBOX_DETAIL_OVERFLOW_M:
  0 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  17 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.
Table BNC_LOCKBOX_FILE_TRAILER_M:
  1 Row successfully loaded.
  0 Rows not loaded due to data errors.
  16 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.
Space allocated for bind array:                  45056 bytes(64 rows)
Read   buffer bytes: 1048576
Total logical records skipped:          0
Total logical records read:            17
Total logical records rejected:         0
Total logical records discarded:        0
Run began on Wed Mar 26 20:00:56 2014
Run ended on Wed Mar 26 20:00:56 2014
Elapsed time was:     00:00:00.69
CPU time was:         00:00:00.08
GTPA_AFN_LOCKBOX_140227104226_T.TXT-SQL.log
Code:
old   4: V_SQL:= 'BEGIN BNC_LOCKBOX_MGMT.GROUP_LOCKBOX_MAIN(''&1''); END;' ;
new   4: V_SQL:= 'BEGIN BNC_LOCKBOX_MGMT.GROUP_LOCKBOX_MAIN(''GTPA_AFN_LOCKBOX_140227104226_T.TXT''); END;' ;
TOTAL AMOUNT SENT : 940.9                                                       
IKA BATCH NUMBER: LB140227A IKA BATCH TOTAL AMOUNT: 940.9 /APPLIED: 940.9 /NOT  
APPLIED (EXCEPTION TOTAL): 0                                                    
I AM IN SEND_MAIL BLOCK                                                         
PL/SQL procedure successfully completed.
emailsnipper is offline   Reply With Quote