Industry

RBC STANDARD (STD152) CREDIT FILE FORMAT SPECIFICATIONS

Description
RBC STANDARD (STD152) CREDIT FILE FORMAT SPECIFICATIONS Summary Clients that previously subscribed to the Payment Distribution Service (PDS) may continue to: Use their previously assigned ten digit client
Categories
Published
of 10
48
Categories
Published
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Transcript
RBC STANDARD (STD152) CREDIT FILE FORMAT SPECIFICATIONS Summary Clients that previously subscribed to the Payment Distribution Service (PDS) may continue to: Use their previously assigned ten digit client number, if they have no subsidiaries, and Conform to the previously issued RBC Standard (STD) format specifications. RBC Standard Format (STD) layout is unique to RBC Global Services and is recommended for clients whose electronic CAD or USD payments are destined to Canadian Banks and/or electronic USD payments are destined to USA Banks, and currency conversion. A mixture of electronic USD payments and CAD payments can be part of the same file. This layout can also be used by clients who require payments in CAD or USD dollars to be produced by cheques. This is identified by the transaction code of CHQ entered on the Basic Payment Record under the Transaction Code field. NOTE: All output reports will indicate the new GRADS client number and must be referred to when corresponding with your Client Service Centre or Account Manager. Format and Organization Each first and last logical record of any file must be logical record types A (Header) and Z (Trailer) respectively. All other logical records contain transaction information. A logical file may only contain payment type C transactions. s to be used are restricted to A-Z and 0-9. Any other characters are not to be used. Multiple logical files can be submitted on a physical transmission. For transmission protocols consult your Client Service Centre. September Basic Specifications Currency a. Input must conform to RBC Standard Record Descriptions (152 characters per record). b. All fields on the records have an indicator as to their format: (N) = Numeric (AN) = Alphanumeric c. All numeric fields must be unsigned and right justified. d. Alphanumeric fields shall be left justified with unused spaces left blank unless noted otherwise. e. All unused fields should have an initial value of zeros ( binary code EBCDIC or binary code ASCII), if numeric, or spaces ( binary code EBCDIC or ASCII), if alphanumeric. Header record Currency of service can be Canadian or United States dollars. Basic record Destination currency can be Canadian or United States dollars. If blank the currency will default to the currency of service. Furthermore, if in the Destination Currency field on the file layout, the input is other than CAD, or USD or Blank, we will put a T level error on each payment. Use of Client Numbers in File Clients with No Subsidiaries (Centralized) All basic records must have the same subsidiary number (0000) as the header record. Operating Subsidiaries All basic records must have the same subsidiary number as the header record. Non-operating Subsidiaries The header and trailer must be the Parent 6 digit number assigned plus Each basic record may have the last 4 digits different, depending on where the record would be returned. 1-2 September 2003 Destination Country The financial institution on which the item is drawn can be in Canada or the United States. When payment transactions are destined for a U.S. financial institution: The destination currency must be USD. U.S. bank identification number: First four positions TTTT = transit routing and ABA number Second four positions AAAA = financial institution number Ninth R = transit routing code Basic Payment Record The Destination Country field is Mandatory.. Account Numbers Service The maximum length for a savings or chequing account number drawn on a Canadian financial institution is 12 digits even though STD format will accept a length of 18. This 12 digit restriction is set by the Canadian Payments Association (CPA). The maximum length of an account number drawn on a U.S. financial institution is 17 digits. Do not zero fill account numbers. Input only the significant digits. Clients using this file format will be able to utilize: The PDS Canadian service PDS CAD or PC PDS CAD The PDS U.S. service PDS USD or PC PDS USD Input Format This format requires the use of a ten digit client number, comprised of six digits assigned by RBC Global Services and four digits assigned b the client to identify a subsidiary (may be zeros). Previous subscribers to the PDS service wishing to process payments using subsidiary status of either operating or non-operating, must use the new ten digit (6 + 4) client number and use RBC Standard format detailed on the following pages. September DESCRIPTION OF RECORD FORMATS HEADER RECORD This header record is used to delimit the beginning of each input file and must be the first record on each file. Format Name Data Requirements N Record Count AN Record Type A AN Transaction Code HDR AN Client Number 10 digit client number as follows: 6 digit client number assigned by RBC Global Services and 4 digit subsidiary number assigned by the client. (Where no subsidiary exists insert zeros as the last 4 digits of this field.) AN Client Name Mandatory AN File Creation Number 4 digit number (numeric) to identify this file, must be different from previous 9 numbers submitted for processing. When submitting a test file, the FCN must be TEST N File Creation Date Julian Date Format YYYYDDD AN Currency Type Currency of service CAD or USD AN Input Type AN Filler Blank AN Reserved Blank AN Reserved Blank AN Reserved Blank AN Filler Blank AN Filler Blank AN Client Optional Record Y if client level optional records exist, otherwise enter N 1-4 September 2003 BASIC PAYMENT RECORD Complete this basic payment record for each credit payment to be produced. Format name Data Requirements N Record Count Increment by AN Record Type C credit payment AN Transaction Code Three digit code as defined in PDS Service manual (Chapter 6) for CPA coded or USA codes. For payments destined to Canada, if no transaction code is entered, it will default to the transaction code on the profile. For payments destined to the USA, it is mandatory to enter the transaction code, otherwise the payment will be T level error AN Client Number 10 digit client number as follows: 6 digit client number assigned by the Royal Bank, and 4 digit subsidiary number assigned by the client. (Where no subsidiary exists insert zeros as the last 4 digits of this field.) AN Filler Blank AN Customer Number Client Assigned, Left Justify N Payment Number 00 to N CAD Financial Institution Number N CAD Financial Institution Branch Number OR 08/ N USA Routing Number Format 0999 (bank number) Note: If CPA Transaction code field 03 above is CHQ , leave blank. Although this is a numerical field, our system will accept it. Format (branch/transit number). Note: If CPA Transaction code field 03 above is CHQ , leave blank. Although this is a numerical field, our system will accept it. 9 digit number as supplied by customermust be an ACH participant AN Account Number Your customer s account number. must be left justified. Enter significant digits only. Do not zero fill. Note: If CPA Transaction code field 03 above is CHQ , leave blank. September Format Name Data Requirements AN Filler Blank N Payment/Input Amount Format $$$$$$$$. Amount must be in the currency of the service AN Reserved Blank N Payment Date Payment due date, format YYYYDDD. Cannot be more than 30 days in the past or 173 in the future AN Customer Name Mandatory AN Language Code E English F French AN Reserved Blank AN Client Short Name For customer statements. This will appear on most bank statements. If left blank, client short name from client profile will default. Do not enter ZEROS in this field AN Destination Currency AN Reserved Blank Currency that the funds are to be made payable in. CAD Canadian $$ USD American $$ If blank = defaults to the currency of the service. If other than CAD or USD or Blank = payment will be T level error AN Destination Country Mandatory The country where the payment should be made. CAN Canada USA United States AN Filler Blank AN Reserved Blank AN Optional Record Indicator Y if customer level optional information follows, otherwise enter N 1-6 September 2003 ELECTRONIC FUNDS TRANSFER MESSAGE RECORD This is an optional customer level record and when used must immediately follow the basic payment record. The client s sundry information may be printed on the destination account bank statement, except for RBC Royal Bank accounts where no such service exists. Format Name Data Requirements N Record Count Increment by AN Record Type C AN Transaction Code RET AN Client Number 10 digit client number as follows: 6 digit client number assigned by RBC Global Services and 4 digit subsidiary number assigned by the client. (Where no subsidiary exists isert zeros as the last 4 digits of this field) AN Filler Blank AN Reserved Blank AN Client's Sundry Information Optional, for customer's bank statement (if applicable) AN Reserved Blank AN Filler Blank AN Reserved Blank AN Filler Blank AN Reserved Blank AN Filler Blank September ADDRESS RECORD This optional record is used to specify address information to be printed on the cheque. This record will only be used if the basic payment transaction code is CHQ. Format Name Data Requirements N Record Count Increment by AN Record Type C AN Transaction Code ADR AN Client Number Must be the same as the Basic Payment Record AN Address Line 1 C/O or street AN Address Line 2 Street AN Reserved Blank AN Address Line 3 City AN Address Line 4 Province/State AN Postal Code/ Zip Code Postal Code or Zip Code AN Filler Blank AN Reserved Blank AN Filler Blank 1-8 September 2003 MISCELLANEOUS STATEMENT INFORMATION RECORD This optional record is used to specify information to be printed on the cheque form. This record will only be used if the basic payment transaction code is CHQ. Format Name Data Requirements N Record Count Increment by AN Record Type C AN Transaction Code MSR AN Client Number Mandatory field- Must be the same as the Basic Payment Record. This information is not printed on the cheque N Customer SIN Optional Record. Customer s social insurance number. This information is not printed on the cheque AN Customer Occupation Optional. This information is not printed on the cheque AN Cheque Message Message information printed on the cheque AN Reserved Blank N Period End Date Format YYYYDDDD (Julian date) AN Filler Blank AN Reserved Blank AN Filler Blank September TRAILER RECORD This trailer record is used to delimit the end of the input file and must be the last record on each file. When the file is processed, all payment records will be totalled and balanced to values on this trailer record. Format Name Data Requirements N Record Count Increment by AN Record Type Z Trailer Record AN Transaction Code TRL AN Client Number Must be the same as the header record N Total Number of Credit Payment Transactions Number of credit payment transactions (type C). Right justify with leading zeros N Total Value of Credit Payment Transactions Amount of credit payment transaction (type C). Right justify with leading zeros. Format $$$$$$$$$$$$ N Reserved Zero fill N Reserved Zero fill N Reserved Zero fill N Total Number Optional Customer Information Records Number Optional Customer Information Records with leading zeros AN Filler Blank AN Reserved Blank AN Filler Blank AN Reserved Blank AN Filler Blank 1-10 September 2003
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks
SAVE OUR EARTH

We need your sign to support Project to invent "SMART AND CONTROLLABLE REFLECTIVE BALLOONS" to cover the Sun and Save Our Earth.

More details...

Sign Now!

We are very appreciated for your Prompt Action!

x