× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

EB.ALTERNATE.KEY

Start
Prev
1
Next
End

Ramesh
Topic Author
Offline
New Member

1 year 10 months ago #24243 by Ramesh

EB.ALTERNATE.KEY was created by Ramesh

Hi All,

I wanted how the field that is set as EB.ALTERNATE.KEY can be used in enquiry? How can we search throgh the file that is created by EB.ALTERNATE.KEY?

Thanks in advance

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

VK
Offline
Platinum Member
Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test

1 year 10 months ago - 1 year 10 months ago #24244 by VK

Replied by VK on topic EB.ALTERNATE.KEY

Hi
an example from Model Bank:

 Model Bank              EB.ALTERNATE.KEY SEE

     APPLICATION....... AC.LOCKED.EVENTS    LOCKED EVENTS
 ------------------------------------------------------------------------------
   1 ALT.KEY.MAX.LENGTH 65
   2. 1 ALT.KEY.FIELD.. RESERVE.ALT.KEY
   3. 1 CONCAT.TYPE.... SYSTEM
   4. 1 ACCESS.METHOD.. READ
   5. 1 UNIQUE......... SYSTEM
  32 CURR.NO........... 1
  33. 1 INPU 1_201705
  33. 2 INPU 3_CONV.EB.ALTERNATE.KEY.201802
  34. 1 DATE.TIME...... 23 MAY 23 03:00
  35 AUTHORI 8_TRAIN511_OFS_MB.OFS
  36 CO.CODE........... GB-001-0001         Model Bank
  37 DEPT.CODE......... 1                   Implementation

Record in AC.LOCKED.EVENTS (note field 14 - RESERVE.ALT.KEY):

 Model Bank              LOCKED EVENTS SEE

     TRANSACTION.REF... ACLK2310732951
 ------------------------------------------------------------------------------
   1 ACCOUNT.NUMBER.... 11215               NIKE
   3 FROM.DATE......... 17 APR 2023
   5 LOCKED.AMOUNT..... 0.00
  10 TRANS.R PITPSGPIPYMNT06
  11 PAYMENT.AMT....... 42.24
  12 PAYMENT.CCY....... GBP                 Pound Sterling
  14 RESERVE BNKPITPSGPIPYMNT06
  18 TXN.SIGN.......... DR
  27 CURR.NO........... 1
  28. 1 INPU 32640_OFFICER
  29. 1 DATE.TIME...... 23 MAY 23 19:13
  30 AUTHORI 32640_OFFICER
  31 CO.CODE........... GB-001-0001         Model Bank

Record BNKPITPSGPIPYMNT06 in F.AC.LOCKED.EVENTS.RESERVE.ALT.KEY:

GB0010001*ACLK2310732951

Cheers
VK

Last edit: 1 year 10 months ago by VK.

The following user(s) said Thank You: Ramesh

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

Start
Prev
1
Next
End

Time to create page: 0.050 seconds