SAP Payment Format
SAP Payment Format
Modality: Deposit to Bancolombia accounts, ACH Entities, Cash Payments, and Check Payments
with individual delivery at the branch
THE CLIENT will send a file containing the 'batch' of information they wish to be processed.
The "lot" consists of three record formats to know:
The first format corresponds to a control record that will contain information that will allow validation
dates, origin and contents of the lot (this record must be the first of the lot); the second format
corresponds to the detail transactions informing the payments to be made in that batch and the third
Registration (optional) refers to additional information that you wish to send for each payment.
1
Document Registration (optional): In structured format for Fax transmission.
Document Registration (optional) in free format (to provide the email address)
GENERAL NOTES:
ACH payments to suppliers with NIT identification document must include a check digit.
2. The fields marked with an asterisk (*) must be right-aligned and filled in.
from zeros on the left.
2
NOTE # 1: The field 'Beneficiary Bank Account' is filled out differently depending on the type.
of transaction, as follows:
If the transaction type is 'Deposit to Account' (27 or 37), the 'Beneficiary Bank Account' must contain the
destination bank code.
If the transaction type is 'Cash Payment' (25) or 'Check Payment with individual delivery, in
"Beneficiary Bank Account" must be zeros.
NOTE # 2: The field 'Beneficiary Account Number' is filled out differently, depending on the
type of transaction, in the following way:
If the type of transaction is 'Credit to Account' (27 or 37), in 'Account Number of Beneficiary' it should go the
beneficiary account number at the destination bank.
If the type of transaction is 'Cash Payment' (25) or 'Individual Check Payment', in
NOTE # 3: The field 'Payment Location Indicator' is filled out differently, depending on the type of
transaction, as follows:
If the transaction type is 'Account Credit' (27 or 37), the 'Payment Location Indicator' must go with
S
If the type of transaction is 'Manager's Check', in the field 'Payment Location Indicator' it must be
you must put the number 1.
At the client's discretion for transactions other than 'Cash Payments' (25) and 'Check Payments'
individual delivery" (26).
It is redefined for the transactions of "Cash Payment" (25) and "Check Payments delivered
individual
For master accounts of the contributory regime, both the concept of Giro and the type of
Identification of the beneficiary is mandatory.
3
01: Payment to Health Service Providers,
suppliers of inputs and/or related supplies
with health care.
02: Payment to Healthcare Service Providers,
suppliers of related inputs and/or supplies
with healthcare focused on extraordinary services
Concept of Turn Alphanumeric in health 2
03: Refund of Contributions
04: Economic Benefits
05: Administrative expenses of the EPS
06: Financial cost of banking collection agreement and
payment
07: Payment to the Information Operator
5: Passport
Filling Alphanumeric "blank space" 1
NOTE # 4.1: The field 'Office where it is Delivered' is filled out differently, depending on the type.
of transaction, in the following way:
If the type of transaction is 'Deposit to Account' (27 or 37), the 'Office where it is Delivered' must go with
zeros (00000).
If the transaction type is "Cash Payment" (25) or "Individual Check Payment" (26), the
The "Office where it is Delivered" must be the number of the Bancolombia branch, where it should be.
deliver the money or the check. (According to the list provided by Bancolombia)
If a type of transaction 'Individual check delivery payment' is reported, you must send the form of the
authorized to claim the check at the office, in which case it must be sent justified to the
left with spaces to the right. If this field is not reported for this type of
transaction, the payment cannot be automatically rejected by the system.
If you require the bank to generate a fax to the payment beneficiary, to inform them of the credit,
you must send the fax number, in which case you must fill it out as follows:
The first eleven positions: They are the fax number. Where the area code must go first and
then the fax number. The area code and the fax number should only contain numerical data.
It should be aligned to the left and white to the right.
Important: If the fax is from the city of Medellín, the area code SHOULD NOT be sent, since they will be
sent from this city.
4
The last position: It must have the letter 'F' indicating that a fax should be sent.
If it is none of the above cases, it can be filled out at the client's discretion to send.
additional information, in which case it is 12 characters.
NOTE # 6: The 'Detail' field of the Document Registration is filled out differently.
depending on the type of transaction, as follows:
If the type of transaction is 'Credit to Account' (27 or 37), the 'Detail' has a free field, at discretion.
from the client.
If the type of transaction is 'Manager's Check', the 'Detail' field must include in the
first 30 positions the full name of the beneficiary to print it on the check of
management. If the space 'Beneficiary Name' of the detail record (of 18 positions) is
sufficient to include the beneficiary's name, it is not necessary to fill out what is explained in the
note 6.
The bank will provide the means by which the customer can know the final status of each one.
of the ordered payments (approved and rejected), according to the table in Annex # 1.
5
ANNEX # 1. TRANSACTION STATUS CODES
REJECTIONS
Code Description
6
C31 SUM OF DEBTS MUST BE ZERO
C32 SUM OF CREDITS MUST NOT BE ZERO
C33 THE SUMMARY OF CREDITS DOES NOT MATCH WITH THE DETAIL
C35 Account to debit and NIT do not correspond
C36 Non-Numeric Record Number
C37 Sum of Debits Not Numeric
C38 Total Credits Is Not Numeric
C39 Account Is Not Numeric
D01 TYPE OF RECORD DETAIL DOES NOT EXIST
D02 THE BANK OF THE ACCOUNT TO BE AFFECTED DOES NOT EXIST
7
D36 INVALID PLACE INDICATOR
D37 OFFICE NOT VALID
D38 THE BENEFICIARY IS NOT REGISTERED FOR VISAPAGOS
D39 TYPE OF IDENTIFICATION IS NOT VALID
D40 UNAUTHORIZED OFFICE FOR THE TRANSACTION
D41 PAYMENT DOES NOT RECORD ID OF THE AUTHORIZED
D42 PENDING FOR DUPLICATE, CONTACT THE LINE
E01 CHANNEL NOT ACTIVE TO RECEIVE INFORMATION
F01 MARKED FOR RETURN
F02 RETURNED
F03 CANCELLED RETURN. STILL APPLIED
M01 INVALID TRANSACTION TYPE
M02 PAYMENT NOT IN BANCOLOMBIA OR CHECK DIGIT IS WRONG
M03 ACCOUNT NUMBER NON-NUMERIC
M04 ACCOUNT NUMBER DOES NOT EXIST
M05 ACCOUNT CANCELED
M06 UNAUTHORIZED ACCOUNT
M07 NON-NUMERIC FIELD VALUE
M08 INVALID ADDITIONAL INDICATOR
M09 SENT NIT DOES NOT MATCH
M10 INVALID RECORD TYPE
M11 REJECTION WITHOUT ADDITIONAL OR MULTIERROR
M12 REJECTED MAL ROUTED
M13 INCORRECT TRACKING NUMBER
M14 ORIGINAL TRANSACTION NOT FOUND
M15 INCORRECT REJECTION VALUE
M16 INCORRECT IDENTIFICATION NUMBER
M17 INCORRECT TRANSACTION CODE
M18 ORIGINATING NIT DOES NOT MATCH HEADER-BATCH
M25 DUPLICATE RETURN
N01 TRANSACTION IS NOT FOR BANCOLOMBIA
N02 TRANSACTION NOT SENT BY SAP
N03 INVALID TRANSMISSION DATE
N04 INVALID TRANSACTIONS CLASS IN HEADER-BATCH
N05 INVALID STANDARD CODE
N06 INVALID APPLICATION DATE
N07 LOT NUMBER NOT NUMERIC IN HEADER-LOT
N08 INVALID TRANSACTIONS CLASS IN CONTROL-BATCH
N09 NON-NUMERIC TOTALS IN CONTROL-BATCH
N10 LOT NUMBER NOT NUMERIC IN CONTROL-LOT
N11 NON-NUMERIC TOTALS IN CONTROL-FILE
N12 LOT TOTALS DO NOT MATCH
8
N13 FILE TOTALS DO NOT MATCH
OK The file was successfully received.
OKA SUBSCRIBED IN BANCOLOMBIA, COMING FROM CLIENT
OKB SUBSCRIBED IN ACH ENTITY
D74 INVALID ACCOUNT TYPE FOR DESTINATION BANK
OKD AUTOMATIC DAT CONSTITUTED
C49 CLIENT NOT ENABLED FOR SFA CHANNEL
OK UPDATED SURVIVAL NEWS
OKF SUBSCRIBED AT BANCOLOMBIA, SENT BY ACH 4G
OKG TO BE VERIFIED IN ACH
OKH FOR CHECKING IN 4G
OKI VERIFIED IN BANCOLOMBIA
OKJ VERIFIED IN ACH
OKK SUBSCRIBED AT BANCOLOMBIA
OKL FOR DELIVERY AT THE COUNTER
OKM DELIVERED AT COUNTER
OKN FOR VERIFICATION IN BANCOLOMBIA
EYE SUBSCRIBED AT BANCOLOMBIA, COMING FROM CENIT
OKP FOR VERIFICATION IN CENIT
OKQ SUBSCRIBED AT CENIT
OKR CHECKED AT CENIT
OKS TO APPLY ON CARD
OKT SUBSCRIBED BY CARD
OKV FOR DELIVERY IN BOX
OK0 TO APPLY AT CENIT
OK1 TO APPLY AT BANCOLOMBIA, SENT BY CLIENT
OK2 TO APPLY IN ACH ENTITY
OK3 MANAGER'S CHECK GENERATED
OK4 SUBSCRIBED AT BANCOLOMBIA, SENT BY ACH
D86 INVALID APPLICATION DATE FOR TYPE OF TRANSACTION
OK6 SUCCESSFUL CREDIT REGISTRATION
OK7 CHECK DELIVERED
OK8 FOR APPLICATION IN BANCOLOMBIA PENDING CONFIRMATION
OK9 FOR APPLICATION IN WALLET
RC1 REJECTED IN CENIT, HAS PROBLEMS
RC2 PAYMENT REJECTED AT CENIT, ACCOUNT DOES NOT EXIST
RC5 VERIFICATION REJECTED CENIT, ACCOUNT DOES NOT EXIST
RC6 VERIFICATION REJECTED IN CENIT, ACCOUNT HAS PROBLEM
R01 CHECK REJECTED WHEN DEPOSITED
R02 CHECK CANCELED FOR NOT BEING CLAIMED
R03 PAYMENT REJECTED IN ACH, ACCOUNT DOES NOT EXIST
D76 ADDENDUM TYPE 7 REQUIRED FOR PAYMENT CLASS 242
9
D75 ADDENDUM TYPE 7 IN PAYMENT CLASS DIFFERENT FROM 242
INFORMATION OPERATOR CODE ADDENDUM-7
D77 INVALID
R07 REJECTED IN ACH, ACCOUNT HAS PROBLEMS
R08 REJECTED AT BANCOLOMBIA - ACCOUNT DOES NOT EXIST
R09 REJECTED BY BANCOLOMBIA - ACCOUNT WITH PROBLEMS
R10 NOT EXECUTED IN BANCOLOMBIA-DUE TO COMMUNICATIONS
R11 REJECTED IN ACH 4G, ACCOUNT HAS PROBLEMS
R12 PAYMENT REJECTED IN ACH 4G, ACCOUNT DOES NOT EXIST
R13 INVALID ACCOUNT NUMBER
R14 IDENTIFICATION DOES NOT MATCH WITH CLIENT ACCOUNT
R15 VERIFICATION REJECTED IN 4G, ACCOUNT DOES NOT EXIST
VERIFICATION REJECTED IN 4G, ACCOUNT HAS
R16 PROBLEMS
VERIFICATION REJECTED BANCOLOMBIA, ACCOUNT NOT
R17 EXIS
VERIFICATION REJECTED BANCOLOMBIA, ACCOUNT WITH
R18 PRO
R19 WINDOW PAYMENT CANCELED. NOT CLAIMED
R20 COUNTER PAYMENT BLOCKED. CUSTOMER ORDER
R21 INVALID BENEFICIARY NIT TYPE
R22 OFFICE DELIVERY DOES NOT EXIST
R23 REJECTION ACH, NIT-ACCOUNT DOES NOT MATCH
R24 NO CREDIT CARD, BAD ORDERING
R25 NO PAYMENT CARD, BAD ID.BENEFICIARY
R26 NO CREDIT CARD PAYMENT, BENEFICIARY BLOCKED
R27 NO CREDIT CARD, WRONG ACCOUNT NUMBER
R28 NO CREDIT CARD, BAD NEWS
R29 NO CREDIT CARD, BAD VALUE
R30 NO PAYMENT CARD, ERROR NOT CLEAR
R31 Cancelled by order of the client
U01 AMOUNT PAID DOES NOT MATCH DOCUMENTS
U02 BAD SIGNS IN DOCUMENTS
U03 NON-NUMERIC VALUES IN DOCUMENTS
U04 DOCUMENT WITH DISAGREEMENT VALUES
V01 CONTROL TOTALS DO NOT MATCH CONTENT
C43 YOU MUST ENTER THE ACCOUNT TO DEBIT
C44 FILE WITH NON-VALID SEQUENCES IN REG 6 AND 3
D51 BENEFICIARY CLIENT NOT ACCEPTED BY BANCOLOMBIA
F04 PARTIALLY REVERSED PAYMENT
P01 EA-THE FIRST RECORD IS NOT TYPE 1
P02 THERE ARE MORE THAN ONE TYPE 1 RECORD
P03 THE DESTINATION ENTITY IS NOT BANCOLOMBIA
10
P04 EA-ENTITY ORIGIN DOES NOT CORRESPOND
P05 CREATION DATE GREATER THAN PROCESS DATE
P06 THE-CLASS INVALID TRANSACTION
P07 THE IDENTIFICATION NUMBER IS BLANK
P08 THE TRANSACTION DATE GREATER THAN PROCESS DATE
P09 THE INVALID FINANCIAL ENTITY
P10 THE BATCH NUMBER IS NOT NUMERIC
P11 INVALID TYPE TRX
P12 DL-ENTITY FINANCIAL RECEIVER MUST BE BANCOLOMBIA
P13 INVALID ACCOUNT NUMBER
P14 DL-VALOR TRX CANNOT BE ZERO
P15 DL-VALOR TRX MUST BE ZERO (PRE-NOTIFICATION)
P16 DL-IDENTIFICATION NUMBER MUST BE NUMERIC
P17 DL-INCORRECT ADDENDUM INDICATOR
P18 DL-SEQ NUMBER MUST BE NUMERIC
P19 DL-NO REGISTER ADDENDUM FOR RETURN TRANSACTION
P20 REGISTRATION TYPE MUST BE 05
P21 REGISTRATION TYPE MUST BE 99
P22 RA-REQUIRES CAUSAL RETURN
P23 RA-REQUIRES ORIGINAL SEQUENCE
P24 RA-NON NUMERIC SEQUENCE
P25 RA-REQUIRES CLIENT ORIGINATOR CODE
P26 RA-REQUIRES REFERENCE
P27 RA-REQUIRES SERVICE DESCRIPTION
P28 RA-SEQ NUMBER DOES NOT MATCH WITH DETAIL
P29 CL-INVALID TRANSACTION CLASS
P30 CL-TRX SUM DOES NOT MATCH DETAILS
P31 TOTAL CONTROL FIGURES DO NOT MATCH
P32 TOTAL DEBT CL-DOES NOT MATCH
P33 TOTAL CREDITS DO NOT MATCH
P34 CL-ENTITY FINANC ORIG DOES NOT MATCH WITH HEADER LOT
P35 CL-LOT NUMBER MUST BE NUMERIC
P36 TOTAL NUMBER OF LOTS DOES NOT MATCH SUM REG 5
P37 CA-TRANSACTION NUMBER DOES NOT MATCH THE SUM OF REG 6 AND 7
11
D46 INVALID AFFILIATION CODE
D47 INVALID ALLOWANCE PERIOD
D48 INVALID ALLOWANCE NUMBER
D49 BANK CODE NOT ALLOWED
OKU PENDING PAYMENT FOR ACCOUNT OPENING
D50 PAYMENT CANCELED DUE TO DUPLICATION
C45 LOT BOOKED, PAYMENT CANNOT BE PROCESSED AGAINST ACCOUNT
D53 BENEFICIARY ACCOUNT NOT REGISTERED FOR PAYMENTS
D52 CANCELED BY SURVIVAL CONTROL
D54 ACCOUNT REGISTRATION REJECTED
D55 UNREGISTERED PAYMENT TO BANCOLOMBIA
D56 INVALID PAYMENT CLASS FOR BANK DEPOSITS
C46 PAYING ENTITY DOES NOT CONTROL SURVIVAL
C47 APPLICATION MUST BE IMMEDIATE IN NOV.SURVIVAL
D20 REJECTED CONTACT CUSTOMER SERVICE LINE
D57 INSUFFICIENT AVAILABLE BALANCE FOR PAYMENT
D58 THERE IS NO CREDIT LIMIT FOR THE NIT
D59 CREDIT LIMIT BLOCKED
D60 OVERDUE CREDIT LIMIT
D61 CREDIT LINE CANCELLED
D62 NIT IS NOT A BANCOLOMBIA CLIENT
D63 PROBLEMS IN CREDIT USAGE TRANSACTION
D64 INCOME - EXPENSES DO NOT MATCH WITH AMOUNT TO PAY
D65 NRO. RECORDS OF DOCUMENTS GREATER THAN ALLOWED
D67 THERE IS NO RECORD OF DOCUMENTS AND IT IS MANDATORY
D70 ERROR IN THE ORDER OF DOCUMENT RECORDS
D71 INVALID DOCUMENT REGISTRATION IN PAYMENT CLASS
R32 CANCELLED DUE TO SERVICE PAYMENT CANCELLATION
C48 INVALID TRANSACTION CLASS FOR SOURCE CHANNEL
ACR SUBSCRIBED IN BANCOLOMBIA
TES CONSTITUTED FROM TREASURY - COMING FROM ACH
DAT AUTOMATIC DATA CONSTITUTED - COMING FROM ACH
OKZ ESTABLISHED IN DATA TREASURY
D72 BANK NOT AUTHORIZED TO RECEIVE THE TRANSACTION
D73 PAYMENT CANCELED DUE TO TECHNICAL PROBLEMS
D78 ADENDA-7 INVALID SHEET NUMBER
D79 INVALID PAYROLL RECORDS NUMBER ADENDA-7
D80 INVALID ADDENDUM-7 ORIGINATING ENTITY CODE
D82 INVALID ADMINISTRATOR CODE ADDENDUM-7
D81 INVALID CONTRIBUTOR NIT ADDENDUM-7
D83 INVALID PAYMENT PERIOD ADDENDUM-7
D84 INVALID PAYMENT CHANNEL ADDENDUM-7
12
D85 NAME OF THE CONTRIBUTOR ADDENDUM-7 INVALID
13