GetBankTransitInformation

F0030 Get Bank Transit Information

Minor Business Rule

Object Name: B0000205

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
This function is used to retrieve bank transit information from the F0030 table. The function uses
Address Number (Customer Number, Supplier Number, etc) and Bank Type and returns all the fields of the
record matched in F0030. The function can also be used to verify that a record for a specific address
number and bank type combination exists in F0030.

Setup Notes and Prerequisites
A valid Address Number (AN8) and a valid Bank Type (BKTP) are required for calling this function.
Also, users of this function need to specify if they want to suppress error messages or not (suppressing
error messages can be useful if you are only checking if a record exists in F0030). If errors are
suppressed, basic initialization failures will still be reported. When suppressing errors, it is
recommended that the value of the cRecordFoundFlag is checked to verify success or failure in accessing F0030.

Special Logic
In cases that there is more than one matching record in F0030 for the parameters passed to the
function, the first record found will be returned by this function.

Technical Specification



Parameters


Item Description I/O  Req?Notes


AN8mnAddressNumberIYCustomer Number, Supplier Number, etc.


BKTPcBankTypeIYThe bank transit record type, i.e. 'D' for Drafts.


TNSTszBankTransitNumberON


CBNKszCustBankAcctNumberON


DL01szBankAcctDescriptionON


CHKDszControlDigitON


EV01cSuppressErrorMessageIYEnter '1' if you want to suppress error messaging 

otherwise enter '0'.


EV01cRecordFoundFlagON'1' means a matching record was found; '0' means a 

matching record was not found.


AIDszAccountIDON


NXTCmnNextCheckNumberON


CRCDszCurrencyCodeFromON


RLNszReferenceRollNumberON


BACSmnBacsUserNumberON


RFNMszBacsReferenceNameON


BAIDszBankTransitShortIDON


MCUszCostCenterON


SWFTszSwiftCodeON


ADPIcPreNoteOptionCodeON


CHKQszCheckPrintQueueON


ATTQszCheckAttachmentsPrintON


DBTQszDebitMemoPrintQueueON


ALGNmnNumberOfAlignmentChecksON


SDTLmnDetailLinesperAPPaymentON


FLRmnFloatDaysforChecksRcvON


FLPmnFloatDaysforChecksPayablON


CKSVcCheckingorSavingsAccountON


UKIDmnUniqueKeyIDInternalONInternal F0030 table primary key ID.





Related Tables


F0030Bank Transit Number Master File





Related Functions


None.





Processing


Perform Initializations.


If (Address Number is '0' or Bank Type is ),


 If SuppressErrorMessage is '0',


  Set error.


 Endif.


Else,


 Open F0030 table.


 If table was opened successfully,


  Fetch first matching record from table.


  If table fetch was successful,


   Load return variables.


  Else,


   If SuppressErrorMessage is '0',


    Set "table fetch" error.


   Endif.


  Endif.


 Else,


  If SuppressErrorMessage is '0',


   Set "table open" error.


  Endif.


 Endif.


Endif.


Perform Function clean up.

Data Structure

D0000205 - F0030 Get Bank Transit Information

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnAddressNumber	AN8	MATH_NUMERIC	REQ	INPUT
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or location.
cBankType	BKTP	char	REQ	INPUT
A code that distinguishes external bank accounts from internal bank accounts. Valid values are: B Valid bank transit numbers C Customer bank accounts D Default bank account for Accounts Receivable drafts and auto debits G Internal general ledger bank accounts H Dutch bank accounts M General ledger bank account and business unit that is used to define print information in Accounts Payable payments P Auto reciepts payor V Supplier bank account for payment via bank tape X Alternate bank account for a supplier Y Multiple bank accounts for a supplier Note: When you use bank type B, no other bank types are allowed. When you use bank type V, no other V bank types are allowed. When you use bank type D, no other D bank types are allowed.
szBankTransitNumber	TNST	char	OPT	OUTPUT
The number assigned to a particular bank by the Federal Reserve to facilitate the clearing of funds.
szCustBankAcctNumber	CBNK	char	OPT	OUTPUT
The number assigned by a bank to identify the account for a company, customer, or supplier. Note for Nordic users: Enter your bank, Bankgiro, or Postgiro account number.
szBankAcctDescription	DL01	char	OPT	OUTPUT
A user defined name or remark.
szControlDigit	CHKD	char	OPT	OUTPUT
A number that represents a check digit for a bank account number. This number is optional, and is not part of the key to the Bank Transit Master table (F0030). Note for Nordic users: This field is not used for Nordic electronic payments.
cSuppressErrorMessage	EV01	char	REQ	INPUT
An option that specifies the type of processing for an event.
cRecordFoundFlag	EV01	char	OPT	OUTPUT
An option that specifies the type of processing for an event.
szAccountId	AID	char	OPT	OUTPUT
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.
mnNextCheckNumber	NXTC	MATH_NUMERIC	OPT	OUTPUT
A number that represents the next payment number to be processed for the specified bank account. The system updates this field during Accounts Payable payment processing.
szCurrencyCodeFrom	CRCD	char	OPT	OUTPUT
A code that identifies the currency of a transaction.
szReferenceRollNumber	RLN	char	OPT	OUTPUT
The recipient's reference number. This is not used by all banks or in all countries. The following countries use this field for specific purposes: o In Italy, the SIA code is used here. o In France, for electronic funds transfer, the Banque de France assigns a sender's number. o In Norway, DNB Telebank provides this number. o In Finland, the payee business code is used here. o In other nordic countries, this field is not used.
mnBacsUserNumber	BACS	MATH_NUMERIC	OPT	OUTPUT
The number assigned by the sponsor in the particular bank system (for example,the UK BACS system). This number will be included on all files submitted by the user.
szBacsReferenceName	RFNM	char	OPT	OUTPUT
The name of the account associated with the user number (within the particular bank system). In Norway, DNB Telebank provides this information. In other Nordic countries, this field is not used.
szBankTransitShortId	BAID	char	OPT	OUTPUT
A number that identifies the bank transit account. This account number is maintained in the A/R Ledger file (F0311), the A/P Ledger file (F0411) and the Bank Transit Number file (F0030).
szCostCenter	MCU	char	OPT	OUTPUT
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szSwiftCode	SWFT	char	OPT	OUTPUT
The beneficiary's SWIFT address or routing/transit number is required by the bank. If you do not enter the beneficiary's SWIFT address or routing/transit number, the bank will reject the file. PeopleSoft does not provide the ability to enter a vendor's bank address and name on the German foreign payment file. This field defaults from the Bank Transit Master (F0030) table.
cPreNoteOptionCode	ADPI	char	OPT	OUTPUT
An option that specifies whether the system overrides the prenote processing for electronic funds transfer for the bank account specified. Valid values are: On Override the prenote code that is assigned to the supplier. The system produces a bank tape without producing a paper check, regardless of how the Pre-Note Code option (AB1) is set. Off Use the prenote code that is assigned to the supplier.
szCheckPrintQueue	CHKQ	char	OPT	OUTPUT
This is the print output queue for A/P payments.
szCheckAttachmentsPrint	ATTQ	char	OPT	OUTPUT
This is the A/P payments attachments output queue.
szDebitMemoPrintQueue	DBTQ	char	OPT	OUTPUT
This is the A/P payments debit statements output queue.
mnNumberOfAlignmentChecks	ALGN	MATH_NUMERIC	OPT	OUTPUT
The number of checks that are needed at the start of check printing for the printer operator to align the check stock properly.
mnDetailLinesperAPPaymentS	SDTL	MATH_NUMERIC	OPT	OUTPUT
The number of detail lines that can appear on an A/P payment stub.
mnFloatDaysforChecksRcv	FLR	MATH_NUMERIC	OPT	OUTPUT
The number of days the system adds to the draft due date to determine the G/L date for journal entries created during the draft collection process.
mnFloatDaysforChecksPayabl	FLP	MATH_NUMERIC	OPT	OUTPUT
The number of days the system adds to the payment date to calculate the value date that is used in draft processing.
cCheckingorSavingsAccount	CKSV	char	OPT	OUTPUT
A code that specifies the type of bank account. This code is used during bank tape processing for automatic payments. The code you specifiy must exist in UDC H00/CK.
mnUniqueKeyIDInternal	UKID	MATH_NUMERIC	OPT	OUTPUT
This field is a unique number used to identify a record in a file.
szCountry_CTR	CTR	char	OPT	OUTPUT
A user defined code (00/CN) that identifies a country. The country code has no effect on currency conversion. The Address Book system uses the country code for data selection and address formatting.
mnNextAutoDebitNumber_NXTA	NXTA	MATH_NUMERIC	OPT	OUTPUT
A number that represents the next automatic debit number to be processed for a specified bank account. The J.D. Edwards software updates this field during accounts payable payment processing.
jdDateUpdated_UPMJ	UPMJ	JDEDATE	OPT	OUTPUT
The date that specifies the last update to the file record.
mnTimeLastUpdated_UPMT	UPMT	MATH_NUMERIC	OPT	OUTPUT
The time that specifies when the program executed the last update to this record.
szProgramId_PID	PID	char	OPT	OUTPUT
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
szUserId_USER	USER	char	OPT	OUTPUT
The code that identifies a user profile.
szWorkStationId_JOBN	JOBN	char	OPT	OUTPUT
The code that identifies the work station ID that executed a particular job.
szInternationalBankAcctNo_IBAN	IBAN	char	OPT	OUTPUT
A string of alphanumeric characters that uniquely identifies a customer's account in a bank anywhere in the world. The IBAN has a maximum of 34 alphanumeric characters; the first two alpha characters identify the country in which the account is held, and the next two digits are the check digits, which validate the complete IBAN. The final part of the IBAN is the domestic account number, which in most cases consists of the account number itself, the number that identifies the bank and the branch, and one or more check digits. For some countries, an extra bank identifier is included.
mnAddressNumberBank_AN8BK	AN8BK	MATH_NUMERIC	OPT	OUTPUT
The address book number of the bank.

Related Functions

None

Related Tables

F0030 Bank Transit Master