WBC - Westpac Banking Corporation

This layout can be used for both manual payments and the standard Payrun.

Header Record      
Field Name Type Length Preceda Mapping
Record Type

Alpha/Numeric

 1 Record Type = A
Filler Numeric 1  
Bank Number Numeric 2 Positions 1-2 of KBSBC
Branch Number Numeric 4 Positions 3-6 of KBSBC field
Filler Numeric 16 Zeros
Processing Date Numeric 8 KDATE converted to DDMMYYYY format
Bank Name Alpha/Numeric 120 DABDES field from KBSBC's NCTLAB record
User ID Numeric 6 KBDUNU record from PAYS64EX record
Filler Numeric 6 Zeros

 

Detailed Transaction Record
Field Name Type Length Preceda Mapping
Record Type Alpha/Numeric 1 Record Type = D
Filler Numeric 1  
Bank Numeric 2 The bank number of the account to which the transaction will be applied.
(The Account to be Credited)
Position 1-2 of employee's BSB e.g. 06
Branch Numeric 4 The branch number of the account to which the transaction will be applied
(The account to be credited)
Position 3-6 of employee's BSB e.g. 0153
Account Numeric 8 Account Number to which the transaction will be applied
(The account to be credited)
1st 7 digits of employee account number
Right justified zero filled
Account Suffix Numeric 4 Suffix of account number above
Remaining digits of employee account number
Right justified and zero filled
Transaction Code Numeric 2 To contain a valid transaction code:
50 - General Credit - 2nd and subsequent Bank Account. Allow/Deduct classification K.
52 - Salary - Main Bank Account
Filler Numeric 4  
Amount Numeric 11 Amount of transaction in cents
Input Source Alpha/Numeric 2 Input Source - DC Direct Credit denotes that the file is Direct Credit file, and must be the same for all transactions in one file (whether transaction is a credit or debit)
Databank Centre Alpha/Numeric 2 Leave Blank
Originating Bank Numeric 2 Originating Bank (Westpac) 03
Originating Branch Numeric 4 Originating Branch (Westpac Int) 0058
Batch Number Numeric 4 Batch Number - 0601
All clients using Wespac from Australia will have a batch number as above.
This Party Name Alpha/Numeric 20 Name of account to which the transaction will be applied.
(The name of account position 9-16 to be credited)
Employee Bank Account Name
This Party Reference Alpha/Numeric 12 Reference Data or descriptive information relating to the transaction
If Transaction Code is 50 take reference from employee's 2nd and subsequent Bank Account K Classification.
If Transaction Code 52 take Reference from employee's main Bank Account.
This Party Particulars Alpha/Numeric 12 Descriptive data relating to the transaction
If Transaction Code is 50 take Reference from employee's 2nd and subsequent Bank Account K Classification.
If Transaction Code 52 take Reference from employee's main Bank Account.
This Party Analysis Alpha/Numeric 12 Analysis Code or further descriptive information relating to the transaction
If Transaction Code is 50 take Reference from employee's 2nd and subsequent Bank Account K Classification.,
If Transaction Code 52 take Reference from employee's main Bank Account.
Other Party Name Alpha/Numeric 20 Name of entity initiating the transaction
Account Name from Company Bank Detail window.
Filler Alpha/Numeric 1 Leave Blank
Other Party Account Number Numeric 18 The trace account number for the initiator of credits (rejected and returned items will be applied to this account)
BSB Number and Account Number from Company Bank Details window.
The string should look like:
030114003836950000

129 - 134 = Company Bank BSB #
135 - 135 = Filler - 0
136 - 136 = First 7 digits of Company Acct #
143 - 146 = Suffix - last 2 digits of Company Acct # (Right Justified & zero filled)
Filler Alpha/Numeric 1 Leave Blank
Due Date Numeric 8 Date for transactions to be processed
(DDMMCCYYY)
Direct Credit Date keyed in Job Submission Parameters
Filler Numeric 5 Zeroes

 

Settlement Trailer Record
Field Name Type Length Preceda Mapping
Record Type Alpha/Numeric 1 Record Type - S
This Bank Numeric 2 Bank number of the bank to which settlement of transactions i being sent.
There must be one bank settlement record for each bank that a transaction applies to
Position 1 - 2 of employee BSB e.g. 06, 03, 16 etc.
Other Bank Numeric 2 Other Bank (Westpac) = 03
Read this value from the submission screen or data area that will be created fro the previous section.
Filler Numeric 14 Zeroes
Total Credit From Numeric 15 Total amount of credits to accounts at This Bank
Total Debit From Numeric 15 Total amount of debits to accounts at This Bank
Net Value Numeric 15 Net Value = the difference between credit and debit transactions in the file with a destination of This Bank (should equal Total Credits)
Sign Character 1 Sign of Net Value = C
for Net Value is equal to 0 or is a credit amount
Filler Character 95 Leave Blank
Record Type Character 1 Record Type - T
Count Numeric 6 Number of transaction detail records on the file
Hash Total Numeric 7 Sum of account number fields on all transaction detail records}
Field is 7 digits in length
For resultant sum less than 7 digits, right justify and zero fill
For resultant sum greater than 7 digits, truncate so that the Hash Total has the last 7 digits
Filler Character 6 Leave Blank
Total Credits Numeric 15 Total amount of all credit transactions on file
Total Debits Numeric 15 Total amount of all debit transactions on file
Net Value Numeric 15 Net Value = the difference between credit and debit transactions in the file with a destination of This Bank (should equal Total Credits)
Sign Character 1 Sign of Net Value - C
Net Value is equal to 0 or is a credit amount
Grand Total Numeric 15 Total of debit transactions added to the total of credit transactions, ignoring the sign
Net Settlement Numeric 15 Net Settlement = Sum of the Net Value fields in the Settlement Trailers
Should be equal to the sum of the Net Values in the Settlement Trailers
Sign Character 1 Sign of Net Settlement - C
For Net Settlement is equal to 0 or is a credit amount
Filler Character 63 Leave Blank