Description: Learn how Lighthouse Business Manager (LBM) Extracts streamlines enterprise data retrieval by consolidating gateway and settlement information into a single, automated file.
Overview
Lighthouse Business Manager (LBM) Extracts provide Enterprise customers with an automated method to retrieve consolidated gateway and settlement data. This system enhances reconciliation workflows by delivering a unified view of the entire transaction lifecycle within a single file.
Extract Specifications and Procedures
File Naming Convention
LBM Extract files follow a standard naming format for clarity and consistency.
Format: LBMCustomer_YYYYMMDD_Enterprise_Custom_Transaction_Extract.csv
How to Initiate an Extract Request
To set up a new LBM Extract, contact your designated Account Manager, who will guide you through the standardized onboarding process.
Customizing Data Fields
If your organization requires additional data fields beyond the standard extract, notify your Account Manager to request a custom field assessment.
Strategic Update
A self-service module for LBM Extract management is currently in development. This enhancement will enable users to configure and control data retrieval settings independently.
Data Availability
Refer to the delivery schedule for details on when LBM Extract data becomes available.
Extract Information Table
LBM Extract Field Name | Description | Example | Datatype | Additional Notes |
| Merchant ID | An unique identifier associated with the merchant processing. | TSYS MID | STRING | |
| Shift4 Mid | An unique identifier associated with the merchant in Shift4. | BIG INT | ||
| Merchant Name | The description of the store at which the POS transaction was processed. | STRING | ||
| Transaction Datetime | The date and time when the transaction was processed. | 9/9/2025 22:17:47 | TIMESTAMP | |
| Settled Date | Date the GL records resulting from the POS transaction was pushed to GL. | 9/10/2025 | DATE (mm/dd/yyyy) | |
| Transaction ID | A unique identifier assigned to a specific transaction. | |||
| Merchant Reference | Vendor reference number unique to a transaction passed into the gateway to identify the transaction in the merchant records. Generated and managed by the merchant. | STRING | ||
| Transaction Amount | Credit payment authorized amount. | numeric(10,2) | ||
| Card Brand | Credit card network. | Visa, Mastercard | STRING | |
| Card Type | The type of the card - can be a credit card, debit card or a gift card. | STRING | ||
| Last 4 of Card | The last 4 digits of credit card. | STRING(4) | ||
| Company Name | Interface company name | STRING | ||
| Interface Name | Interface name | STRING | ||
| Interface Version | Interface version | |||
| Currency Code | The currency of the payment amount. | 3 char. alpha | STRING | |
| Processor ID | The processor code - TSYS. | TSYS | STRING | |
| Amex Direct Flag | A yes or No flag to identify Amex direct set up. | N/Y | ||
| Deposit ID | Unique Payment number when funds are deposited to bank. | 36480077745 | ||
| Batch Number | Shift4 generated batch ID | 0022554772-20250904-1130 | STRING | |
| Processor Batch ID | Batch ID provided by the processor | |||
| Decision | If a transaction is rejected or accepted by the processor. | Accepted/ Rejected | STRING | |
| Transaction Type | Describes the type of transaction such as Authorized, Sale, Refunded, or Voided. In this extract it'll be either a SALE or a REFUND. | SALE or REFUND | STRING | |
| Customer Reference | Reference received from the merchant. | |||
| Invoice | A unique identifier assigned to a transaction, used for tracking and reference purposes. | STRING | ||
| Auth Code | A unique code provided by the bank or card issuer confirming that the transaction has been authorized. | STRING | ||
| Entry Mode | The method used to input the payment information, such as swiping or chip. | STRING | ||
| AVSResponseCode | Indicates whether the billing address matches the address on file with the bank. | STRING | ||
| CVVResponseCode | Shows if the security code on the card was verified successfully. | STRING | ||
| Auth Amount | The transaction maximum authorized amount. | numeric(10,2) | ||
| Payout Date | Indicated the date of the payout. Depending on bank holidays or weekends, this date might be different than the actual date the payout in reflected in the merchant's bank account. | Coming soon - not populated currently. | ||
| Auth Approved Date | The date Authorization was approved. | DATE | ||
| Debit Credit Indicator | Indicator for a debit or credit | Debit or Credit | STRING | |
| Customer Name | Name of the customer as received by the gateway. | STRING | ||
| Customer Email | Email of the customer as recieved by the gateway. | STRING | ||
| Card Token | A secure, card ID that represents the actual card information, used to process transactions safely without exposing real card details. | STRING | ||
| Issuer BIN | Bank Identification Number; the first six digits of the card that identify the issuing bank. | |||
| Global Merchant ID | The merchant ID that is assigned by Global. | STRING |
Comments
0 comments
Please sign in to leave a comment.