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:
- Master Unload (New Master Unload)
- 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:
- Record Code 1. Master Record
- Record Code 2. Organization Debtor File
- Record Code 3. Individual Debtor File
- Record Code 4. Organization Secured Party File
- Record Code 5. Individual Secured Party File
- Record Code 6. Amendment File
- Record Code 9. Trailer Record
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.
