SeanHoppe.com > CLEO Integrator Examples > 3 Trading Partner Information in EXTTPRL1

Query Trading Partner Information in EXTTPRL1


At times users want to be able to query a file to review trading partner pertinent informatio. In the files LIB: EXTSYSF, users can SQL/RUNQRY table: EXTTPRL1.

Below are the fields users can query in EXTTPRL1



Formatted file with field names

Seq# Select Only Line Page Dup Case Null Name Type Length

10 X Trading partner code K01 TPTPCD A 6

20 X Trading partner name TPTRNM A 35

30 X Trading partner address TPTRAD A 30

40 X Trading partner city TPTRCY A 30

50 X Trd pnr state/province TPTRST A 6

60 X Trading partner post code TPTRPC A 9

70 X Trading partner voice no. TPTRPN A 25

80 X Interchange ctl last sent TPICLS A 14

90 X Interchange ctl last rcvd TPICLR A 14

100 X Ctl ref fmt gen - intchg TPCRGI A 1

110 X Ctl ref fmt test - intchg TPCRTI A 1

120 X Control ref mthd gen int TPCMGI A 1

130 X Control ref mthd test int TPCMTI A 1

140 X Ack level to generate Tp TPAKGT A 1

150 X Ack level to receive Tp TPAKRT A 1

160 X Ack error report lvl Tp TPAKET A 1

170 X Ack err resp map int Tp TPAEIT A 30

180 X Ack err resp map grp Tp TPAEGT A 20

190 X Ack err resp map msg Tp TPAEMT A 20

200 X Ack err resp map seg Tp TPAEST A 20

210 X Ack err resp map elm Tp TPAEET A 20

220 X Element delimiter Tp TPELDT A 1

230 X Sub-element delimiter Tp TPSEDT A 1

240 X Decimal notation Tp TPDCTT A 1

250 X Release indicator char Tp TPRLIT A 1

260 X Reserved space in Una Tp TPRSST A 1

270 X Segment delimiter Tp TPSGDT A 1

280 X Interchange syntax Id Tp TPISIT A 4

290 X Interchange version Id Tp TPIVIT A 5

300 X Sender Id qualifier Tp TPSNQT A 4

310 X Sender Id Tp TPSNIT A 35

320 X Address for reverse rtgtp TPSNRT A 14

330 X Receiver Id qualifier Tp TPRCQT A 4

340 X Receiver Id Tp TPRCIT A 35

350 X Routing address Tp TPRCRT A 14

360 X Authorization qualifiertp TPAUQT A 2

370 X Authorization info Tp TPAUTT A 10

380 X Security qualifier Tp TPSEQT A 2

390 X Security information Tp TPSECT A 10

400 X Application reference Tp TPAPRT A 14

410 X Priority code Tp TPNPRT A 1

420 X Interchange ack requesttp TPAKTT A 1

430 X Comm agreement Tp TPCAIT A 35

440 X Test indicator Tp TPTSTT A 1

450 X Application sndr Id qlftp TPASQT A 4

460 X Application sender Id Tp TPASIT A 35

470 X Application rcvr Id qlftp TPARQT A 4

480 X Application receiver Idtp TPARIT A 35

490 X Controlling agency codetp TPCTCT A 2

500 X Standard class code Tp TPSCCT A 1

510 X Industry group code Tp TPIGCT A 1

520 X V-r Trading partner TPVRTP A 6

530 X Industry group Id Tp TPIGIT A 6

540 X Application password Tp TPAPPT A 14

550 X Call window code Tp TPCDWT A 6

560 X Window effective dt/tm Tp TPWETT P 11

570 X Network Id default Tp TPNWIT A 15

580 X Network name TPNWNM A 30

590 X Network account cd dft Tp TPNATT A 6

600 X Network account desc TPNACD A 25

610 X Network account number TPNACN A 25

620 X Network account password TPNAPW A 25

630 X Network port code dft Tp TPPONT A 6

640 X Network port description TPPORD A 25

650 X Telephone number TPPNNO A 14

660 X Connection nbr (dial cmd) TPCNBR A 25

670 X Line description TPLIND A 10

680 X Controller description TPCTLD A 10

690 X Device description TPDEVD A 10

700 X Generator control code TPGCTL A 10

710 X Messages per group (max) TPMSGG P 7

720 X Groups per intchg (max) TPGRPI P 7

730 X Messages per intchg (max) TPMSGI P 7

740 X Session control TPSNCN P 7

750 X Last change date/time TPLCDT S 8

760 X Last change job name TPLCJB A 10

770 X Last change job user name TPLCJU A 10

780 X Last change job number TPLCJN A 6

790 X Last change by program TPLCPG A 10








By: on
EXTOL Business Partner Logo

More EXTOL Examples

We have over 300+ examples of how EXTOL can be customized to meet your organization's needs

Each of our exmaples are free to review and use.