Values loaded in BANK_TRX_NUMBER are truncated
Hi!
I loaded and import a statement bank, but when I review the lines imported, the values in BANK_TRX_NUMBER (number column) in the Bank Statement Lines form, has 12 digits instead of 13. How can I correct this?
.ctl file
--------------------------------------------
LOAD DATA
REPLACE
INTO TABLE ce_stmt_int_tmp
WHEN (01) = 'H'
TRAILING NULLCOLS
(rec_no RECNUM,
rec_id_no CONSTANT '0',
column1 POSITION(02:12) CHAR,
column2 POSITION(13:20) CHAR,
column3 POSITION(21:26) CHAR)
INTO TABLE ce_stmt_int_tmp
WHEN (01) <> 'H'
TRAILING NULLCOLS
(rec_no RECNUM,
rec_id_no CONSTANT '1' ,
column1 POSITION(01:11) CHAR,
column2 POSITION(12:19) CHAR,
column3 POSITION(20:35) CHAR,
I loaded and import a statement bank, but when I review the lines imported, the values in BANK_TRX_NUMBER (number column) in the Bank Statement Lines form, has 12 digits instead of 13. How can I correct this?
.ctl file
--------------------------------------------
LOAD DATA
REPLACE
INTO TABLE ce_stmt_int_tmp
WHEN (01) = 'H'
TRAILING NULLCOLS
(rec_no RECNUM,
rec_id_no CONSTANT '0',
column1 POSITION(02:12) CHAR,
column2 POSITION(13:20) CHAR,
column3 POSITION(21:26) CHAR)
INTO TABLE ce_stmt_int_tmp
WHEN (01) <> 'H'
TRAILING NULLCOLS
(rec_no RECNUM,
rec_id_no CONSTANT '1' ,
column1 POSITION(01:11) CHAR,
column2 POSITION(12:19) CHAR,
column3 POSITION(20:35) CHAR,
Tagged:
0