How to LIST ASSET.TYPE in FBNK.RE.STAT.LINE.CONT

  • EDA001
  • Topic Author
  • Offline
  • User is blocked
  • User is blocked
  • Posts: 16
  • Thank you received: 0

EDA001 created the topic: How to LIST ASSET.TYPE in FBNK.RE.STAT.LINE.CONT

Dear All

Recently , i have tried to list the ASSET.TYPE filed in FBNK.RE.STAT.LINE.CONT from the jshell for reporting purpose. when i do that the SOME OF THE VALUES in ASSET.TYPE filed are truncated to the next line instead of being listed together with other fields. can anyone help how to list the values in ASSET.TYPE fields with out being truncated to the next line. My list statement looks like the following.

LIST FBNK.RE.STAT.LINE.CONT WITH @ID LIKE BOAGL... ASST.CONSOL.KEY ASSET.TYPE .

i have attached the sample output and i have highlighted in yellow the problem i have encountered.

Thank you
#16635

Please Log in or Create an account to join the conversation.

  • Posts: 2839
  • Karma: 512
  • Thank you received: 643

jpb replied the topic: How to LIST ASSET.TYPE in FBNK.RE.STAT.LINE.CONT

As the attachment is missing I can only speculate that ASSET.TYPE with more than 12 characters are printed on two lines. To avoid this just specify the maximum length for the defined ASSEt.TYPES, e.g.

LIST FBNK.RE.STAT.LINE.CONT WITH @ID LIKE BOAGL... ASST.CONSOL.KEY ASSET.TYPE FMT"20L"

Some people feel the rain - others just get wet (Bob Marley)
#16648
The following user(s) said Thank You: gm.saran, EDA001

Please Log in or Create an account to join the conversation.

  • EDA001
  • Topic Author
  • Offline
  • User is blocked
  • User is blocked
  • Posts: 16
  • Thank you received: 0

EDA001 replied the topic: How to LIST ASSET.TYPE in FBNK.RE.STAT.LINE.CONT

Thank you jpb.
It works for me as i desired it to be !!!!!!!
#16659

Please Log in or Create an account to join the conversation.

  • Posts: 11
  • Thank you received: 1

Louis_CL16 replied the topic: How to LIST ASSET.TYPE in FBNK.RE.STAT.LINE.CONT

Dear JBP,
Could you help me to explain the meaning of ASSET TYPE? Which tables in T24 control ASSET TYPE?
When mapping line, I don't know what basis to fill the field "asset type"

Thank you!
#17291

Please Log in or Create an account to join the conversation.

  • armin
  • armin's Avatar
  • Offline
  • Elite Member
  • Elite Member
  • “So long - and thanks for all the fish!”
  • Posts: 300
  • Karma: 13
  • Thank you received: 57

armin replied the topic: How to LIST ASSET.TYPE in FBNK.RE.STAT.LINE.CONT

I'm also not JPB but for ASSET.TYPE in RE.STAT.REP.LINE just use the helptext and you will get quite good general information.

To see what ASSET.TYPES exist in the area of interest you can scan thru CAL (CONSOLIDATE.ASST.LIAB) to see the different K.TYPE that exist.

using R11 on Unix
#17304

Please Log in or Create an account to join the conversation.

  • Posts: 16
  • Karma: 3
  • Thank you received: 3

T24_SATHISH replied the topic: How to LIST ASSET.TYPE in FBNK.RE.STAT.LINE.CONT

simple use saving with eval and then save the file in savedlists
#17338

Please Log in or Create an account to join the conversation.

  • Posts: 4
  • Thank you received: 0

HIENTT replied the topic: How to LIST ASSET.TYPE in FBNK.RE.STAT.LINE.CONT

HI ALL
I don't know this ASSET.TYPE values and list all with the values in the system.
Exampe: OVERDUECE
OVERDUCS
CONTRAAC
CREDIT
DEBIT
LIVECR
LIVEDB...
Could you pls let me know how to list ASSET.TYPE. Not the ASSET.TYPE application or SUB.ASSET.TYPE.
Thanks for your kind support,
#17935

Please Log in or Create an account to join the conversation.

Time to create page: 0.318 seconds