Field RYIN where stored in AR ?

Hello all,
When I make an inquiry on P03B2002, standard accounts receivables, I can
see a column which shows the payment type, alias RYIN (C for Check, W
for wire transfert...).

Unless I need to wash my eyes, I cannot find it in F03B11 wherther the
invoice is paid or not, nor in F03B13 nor in F03B14 when the invoiced is
paid.

It MUST be somewhere : I'm wondering in which file JDE store the RYIN
field in AR.

Can you please help me on this ?

Many thanks in advance.

Michel MAUREL
OW XE B7333, SP15.
--
Privileged/Confidential Information may be contained in this message.
If you are not the addressee indicated in this message (or responsible
for delivery of the
message to such person), you may not copy or deliver this message to
anyone. In such case, you should destroy this message and kindly notify
the sender by reply
email.

Here are all of the tables that contain the data item (alias)
RYIN...complements of the Cross Reference Facility.

Data Item Name Data Item Description Table Name Table Description
Table Sequence
RYIN Payment Instrument F0301 Customer Master 16
RYIN Payment Instrument F03012 Customer Master by Line of Bus 17
RYIN Payment Instrument F0101Z1 Address Book - Batch File 137
RYIN Payment Instrument F03012Z1 Customer Master LOB-Batch
File 30
RYIN Payment Instrument F0101A Address Book Master File Audit 105
RYIN Payment Instrument F004201 Prepayment Transaction Table 8
RYIN Payment Instrument F47091 EDI Request for Quote Header - 49
RYIN Payment Instrument F470371 EDI Shipping Notice Detail - O 118
RYIN Payment Instrument F47046 EDI Invoice Header (Sales) - O 46
RYIN Payment Instrument F47047 EDI Invoice Detail (Sales) - O 105
RYIN Payment Instrument F40338 Preference Profile - Payment T 15
RYIN Payment Instrument F40338R Preference Resolution Ledger - 17
RYIN Payment Instrument F47027 EDI P.O. Acknowledgment Detail 105
RYIN Payment Instrument F47026 EDI P.O. Acknowledgment Header 46
RYIN Payment Instrument F4817 Service Order Extension 12
RYIN Payment Instrument F03B01 Customer Master by Co Table 17
RYIN Payment Instrument F03B11 Customer Ledger 99
RYIN Payment Instrument F03B11P Customer Ledger Purge File 99
RYIN Payment Instrument F03B11Z1 Invoice Transactions - Batch
F 115
RYIN Payment Instrument F03B13 Receipts Header File 39
RYIN Payment Instrument F03B13P Receipts Header Purge File 39
RYIN Payment Instrument F03B575 Auto Debit Invoice Select and 102
RYIN Payment Instrument F03B672 Draft Remittance Work File - O 38
RYIN Payment Instrument F1720 Contract Header 50
RYIN Payment Instrument F4001Z Batch Receiver File - Order He 54
RYIN Payment Instrument F40330 Preference Profile - Document 20
RYIN Payment Instrument F47092 EDI Request for Quote Detail - 105
RYIN Payment Instrument F4201 Sales Order Header File 30
RYIN Payment Instrument F42019 Sales Order Header History Fil 31
RYIN Payment Instrument F4201Z1 Sales Order Header Unedited Tr 44
RYIN Payment Instrument F4211 Sales Order Detail File 91
RYIN Payment Instrument F42119 Sales Order History File - Fle 91
RYIN Payment Instrument F4213 Sales Order Reprice File 91
RYIN Payment Instrument F42199 S.O. Detail Ledger File - Flex 91
RYIN Payment Instrument F42UI01 SO Header Cache File (MBF) 34
RYIN Payment Instrument F42UI12 Sales Order Detail Cache 2 (MB 28
RYIN Payment Instrument F42UI521 Pick Slips Detail File 81
RYIN Payment Instrument F42UI800 Sales Detail Work File -
Sales 76
RYIN Payment Instrument F47012 EDI Purchase Order Detail - In 105
RYIN Payment Instrument F47037 EDI Shipping Notice Detail - O 108
RYIN Payment Instrument F47147 EDI P.O. Change Acknowledgment 107
RYIN Payment Instrument F47107 EDI Response to RFQ Detail - O 105
RYIN Payment Instrument F47131 EDI Purchase Order Change Head 46
RYIN Payment Instrument F47106 EDI Response to RFQ Header - O 46
RYIN Payment Instrument F47146 EDI P.O. Change Acknowledgment 47
RYIN Payment Instrument F47132 EDI Purchase Order Change Deta 106
RYIN Payment Instrument F4011Z Batch Receiver File - Order De 104
RYIN Payment Instrument F40301R Preference Resolution Ledger - 15
RYIN Payment Instrument F40301 Preference Profile - Payment T 13
RYIN Payment Instrument F4211Z1 Sales Order Detail Unedited Tr 104
RYIN Payment Instrument F47011 EDI Purchase Order Header - In 49

Michel, this field is in F03b11.
It tells you the method of payment used by the
customer.
You should, also, be able to find it in f0301. F0301
is where the input of the value was made to this
field.
F03b11 is the ledger file and keeps information about
customer number (AN8)(common fields between these 2
files).

Si mon explication n'est pas tout a fait
comprehensible, vous pouvez m'envoyer une missive
electronique par : [email protected] ou
[email protected].

J'espere vous avoir aide avec ceci.

Sincerement.

--- m_maurel79 <[email protected]> wrote:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=23750
-+


=====
Ulrick Ceus
A JDEdwards Product Certified Consultant
USMTech Consulting Group, Inc
Gilbert, Arizona
602-770-0158(Mobile)
[email protected]
[email protected]

__________________________________________________

The Payment Instrument, RYIN, can be found in both F03B11 and F03B13. For the application you are using, P03B2002, the RYIN alias is coming from the Customer Ledger file (F03B11). Check the table definition of this file and (in Xe) you'll see it is the 99th attribute.

Regards,
srdeprez
OW XE Technical, Developer
XE - SP16.1
AS400 - NT

Hi all who answered,

many thanks to all of you, I now can work ahead.
Best regards.

Michel.
--
Toute information contenue dans ce courrier électronique est confidentielle et Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the
message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply
email.