Posted Transactions

Overview

A posted transaction represents a finalized financial activity that has been processed and recorded on a cardholder’s account. These transactions reflect completed purchases, withdrawals, fees, or adjustments that have been authorized and officially posted to the ledger.

This section includes the required fields for posted transaction records. Each transaction is uniquely identified and includes metadata necessary for financial reconciliation, reporting, and compliance monitoring.

Posted transaction data includes:

Unique identifiers for the transaction, card, account, and cardholder
Transaction timestamps, codes, descriptions, and monetary amounts
Merchant details including name, location, and terminal information
Currency, country, and device-level metadata
Balance impact indicators and authorization references

These fields ensure that each transaction is accurately captured, categorized, and auditable, supporting secure financial operations and regulatory compliance across Newline’s card programs.

Field Definitions

FIELDS	REQUIRED	DESCRIPTION	CHARACTER LENGTH	EXAMPLE
TRANSACTION ID	Y	Unique identifier of the card transaction	20	TXN1234567890
CARD ID	Y	Unique ID of Card. Assigned by Program Manager.	40	CARD105523156
CARD NUMBER	Y	Provide full 16 digits.	16	1234567891234560
ACCOUNT NUMBER	Y	The account number that is associated with the card.	35	12345678901234500000
PERSONID	N	Unique ID identifying a PERSON. For Consumer Cards only.	35	CUST123456
TRANSACTION DATE TIME STAMP	Y	Swiped card payments - For example if a card was used at 1:00 AM in China time, provide 1:00 AM China time, not 11:00 AM EST. Web/non-swiped card payments -For example a PERSON located in Cincinnati buys something at 8:00 PM on Amazon, but the merchant was in California and the time was 5:00 PM there. Provide the time of transaction which is 8:00 PM here.	DateTimes(YYYY-MM-DDTHH:mm:ss.SSS)	2024-05-12T10:30:00.00
POSTED TRANSACTION DATE TIMESTAMP	N	Timestamp transaction posted to the account	DataTimes(YYYY-MM-DDTHH:mm:ss.SSS)	2024-05-12T10:30:00.00
TRANSACTION CODE	Y	Code representing the type of transaction posted to the card including both internal and network related activity. This code is utilized to support funds movement so any transaction that affects the balance of the card. A mapping exercise will take place between the bank and program manager.	50	P10
TRANSACTION DESCRIPTION	N	Description of the transaction.	100	PURCHASE
TRANSACTION AMOUNT SIGN	Y	“+” if transaction adds to settled balance, “-” if transaction deducts from settled balance, " " if transaction doesn’t affect settled balance.	1
TRANSACTION AMOUNT	Y	Amount of the transaction that posted to the account.	Decimal(10, 2)	150.75
AUTHORIZATION CODE	N	Identification number assigned to the approved transaction. Blank if declined.	15	123456
TRANSACTION CURRENCY CODE	Y		3	USD
TRANSACTION ORIGINATED CITY	N	The city where the transaction originated.	50	Chicago
TRANSACTION ORIGINATED COUNTRY CODE	Y	Country where the transaction took place. Code representing the country where the merchant’s business is located. Use ISO 3166-1 Alpha-2 Country code standard. https://www.nationsonline.org/oneworld/country_code_list.htm	2	US
TRANSACTION IP ADDRESS	N	This refers to the Internet Protocol (IP) address of the device or network from which the transaction originated.	39	192.168.1.1
TRANSACTION DEVICE ID	N	A unique number related to a mobile phone or device that the transactions took place on.	50	93DJ2231ADD35672X
MERCHANT TERMINAL NUMBER(TID)	N	An eight-digit alphanumeric code that identifies a point-of-sale(POS) terminal and the transactions that takes place on it.	8	12341234
MERCHANT CATEGORY CODE	Y	Code representing the merchant's line of business	4	5411
MERCHANT NAME	Y	Name of the merchant accepting the original transaction.	100	ABC Store
MERCHANT IDENTIFICATION NUMBER	N	Unique code that identifies a business and its merchant account.	35	MER1234567890
MERCHANT ADDRESS LINE 1	N	Merchant address.	35	456 Elm St
MERCHANT ADDRESS LINE 2	N	Additional address information.	35	Suite 300
MERCHANT CITY	N	Merchant city.	50	San Francisco
MERCHANT STATE	N	Merchant state.	2	CA
MERCHANT ZIPCODE	N	Merchant ZIP code.	10	94107
MERCHANT COUNTRY CODE	Y	Code representing the country where the merchant’s business is located. Use ISO 3166-1 Alpha-2 Country code standard.	2	US
MERCHANT PRIMARY PHONE NUMBER	N	Merchant phone number.	15	1-415-555-1234