Telegram: | maintex |
|
Carding for Beginners Learning to carding |
![]() |
|
Thread Tools | Search this Thread |
Join Date: Apr 2015
Location: Carder
Posts: 157
![]() |
![]()
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 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 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. |
![]() |
![]() |
![]() |
Tags |
info, support |
|
|