Election Notice:  Monday, October 6, 2025 is the last day to register to vote for the November 4, 2025 Uniform Election  |  Visit VoteTexas.gov for more election information
Apostille/Authentication services available by appointment on Tuesdays and Fridays starting August 5.
EFFECTIVE SEPTEMBER 1, 2023, OUR LOBBY WALK-IN HOURS WILL BE 9 A.M. - 4 P.M. (CENTRAL), MONDAY - FRIDAY.

Uniform Commercial Code (UCC) Bulk Order File Layouts

(Rev.7/22/2025) Bulk Order Types

The bulk order types listed below will use the format detailed in the following sections:

  1. Master Unload (New Master Unload)
  2. Daily Filing Update

Bulk Order file generation and file formats

For bulk orders of type 1, a data file is generated on a monthly basis. Files are put in a specified directory on the server and are made available to clients upon purchase. For type 2, a file containing data and images is generated daily at 1:00 AM.

Bulk order data is now provided in JSON format. Each record type will be represented as a JSON object with the associated fields:

Each record’s structure will follow a defined JSON schema specific to the record code.

Record Code 1 – Master Record

Start
Position
End
Position
Length Description
1 1 1 Record Code = 1
2 18 17 Initial Filing Number
19 19 1 Filing Type (Appendix A)
20 20 1 Filing Status (A = Active, L = Lapsed)
21 28 8 Expiration Date (YYYYMMDD)
29 32 4 Total Page Count for Filing
33 52 20 Document Number of Initial Financing Statement Filing
Number
53 511 459 Filler

Record Code 2 – Organization Debtor File

Start
Position
End
Position
Length Description
1 1 1 Record Code = 2
2 18 17 Initial Filing Number
19 318 300 Organization Debtor Name
319 428 110 Organization Debtor Street Address
429 492 64 Organization Debtor City
493 494 2 Organization Debtor State
495 502 8 Organization Debtor Zip Code
503 508 6 Organization Debtor Zip Code Extension**
509 511 3 Organization Debtor Country Code

Record Code 3 – Individual Debtor File

Start
Position
End
Position
Length Description
1 1 1 Record Code = 3
2 18 17 Initial Filing Number
19 68 50 Individual Debtor Last Name
69 118 50 Individual Debtor First Name
119 168 50 Individual Debtor Middle Name
169 174 6 Individual Debtor Suffix
175 284 110 Individual Debtor Street Address
285 348 64 Individual Debtor City
349 350 2 Individual Debtor State
351 358 8 Individual Debtor Zip Code
359 364 6 Individual Debtor Zip Code Extension**
365 367 3 Individual Debtor Country Code
368 511 144 Filler

Record Code 4 – Organization Secured Party File

Start
Position
End
Position
Length Description
1 1 1 Record Code = 4
2 18 17 Initial Filing Number
19 318 300 Organization Secured Party Name
319 428 110 Organization Secured Party Street Address
429 492 64 Organization Secured Party City
493 494 2 Organization Secured Party State
495 502 8 Organization Secured Party Zip Code
503 508 6 Organization Secured Party Zip Code Extension**
509 511 3 Organization Secured Party Country Code

Record Code 5 – Individual Secured Party File

Start
Position
End
Position
Length Description
1 1 1 Record Code = 5
2 18 17 Initial Filing Number
19 68 50 Individual Secured Party Last Name
69 118 50 Individual Secured Party First Name
119 168 50 Individual Secured Party Middle Name
169 174 6 Individual Secured Party Suffix
175 284 110 Individual Secured Party Street Address
285 348 64 Individual Secured Party City
349 350 2 Individual Secured Party State
351 358 8 Individual Secured Party Zip Code
359 364 6 Individual Secured Party Zip Code Extension**
365 367 3 Individual Secured Party Country Code
368 511 144 Filler

Record Code 6 – Amendment File (or any other UCC3 filing)*

Start
Position
End
Position
Length Description
1 1 1 Record Code = 6
2 18 17 Initial Filing Number
19 30 12 Filing Number of Filing
31 34 4 Amendment Filing Type)
35 42 8 Filing Date (YYYYMMDD)
43 46 4 Filing Time (HH24MI)
47 50 4 Page Count of UCC3 Filing
51 58 8 Filing Entry Date (YYYYMMDD)
59 62 4 Filing Entry Time (HH24MI)
319 338 20 Document Number of UCC3 Filing
339 511 173 Filler

*Note: Master Record will be the initial filing and will be available in record code 6. For MR record: It will be UCC1’s filing number, document number, and page count. For all amendments (UCC3) it will be filing number, document number, and page count of UCC3 filing.

Record Code 9 – Trailer Record

Start
Position
End
Position
Length Description
1 1 1 Record Code = 9
2 13 12 Filing Number = "999999999999"
14 21 8 Count of code 1 records
22 29 8 Count of code 2 records
30 37 8 Count of code 3 records
38 45 8 Count of code 4 records
46 53 8 Count of code 5 records
54 61 8 Count of code 6 records
62 69 8 Count of code 7 records
70 79 10 Grand total of all records
(Exclusive of this, code 9, trailer record)
80 89 10 Date of file generation
90 506 417 Filler - Not Used

Appendix A

Initial Filing Type (UCC1 Type)


UCC_TYPE_ID UCC_TYPE
D The code of “D” is not a Filing Type. This indicates that the record was
deleted from the UCC index.
Blank Financing Statement
A Agricultural Lien
I Aircraft Maintenance Lien
G Contract Agricultural Lien
F Federal Lien
M Manufactured-Home Transaction
P Public-Finance Transaction
R Restitution Lien
T Transition Property Notice
S Transmitting Utility
U Utility Security Instrument
E Securitization Property Notice

Amendment Filing Type (UCC3 Type)

UCC_TYPE_ID UCC_TYPE
MR Master Record (the initial filing document, UCC1)*
AM Amendment, Master Amendment
A Assignment, Master Assignment
CC Change Collateral Amendment
CP Change Party Amendment
C Continuation
O Correction
IS Information Statement
J Judicial Finding of Fact
RV Revoked, Revoked edit
T Termination

*Master Record (the initial filing document, UCC1)is not an actual amendment type but is used to designate where the master record is inserted in the JSON file

**The Zip Code Extension field is not strictly required and is considered an arbitrary value.