Skip to content

UCC Example Lists:

UCC Bulk list include the following sheets:

Back

TRANSACTIONS

FieldData Type
TRANSACTIONIDNOT NULL NUMBER(18)
FILINGNUMBERNOT NULL NUMBER(18)
STARTDATENOT NULL DATE
LAPSEDATEDATE
OLDFILINGCODEVARCHAR2(50)
FORMTYPEVARCHAR2(50)
AMENDTYPEVARCHAR2(50)
AMENDACTIONVARCHAR2(50)
ENTEREDDATEDATE
RECEIVEDDATEDATE
APPROVEDDATEDATE
FILINGTYPEVARCHAR2(50)

COLLATERAL

FieldData Type
TRANSACTIONIDNOT NULL NUMBER(18)
FILINGNUMBERNOT NULL NUMBER(18)
COLLATERALACTIONNOT NULL VARCHAR2(18)
COLLATERALDESCVARCHAR2(4000)
EFFECTIVEDATEDATE

DEBTOR

FieldData Type
TRANSACTIONIDNOT NULL NUMBER(18)
FILINGNUMBERNUMBER(18)
ENTITYIDNOT NULL NUMBER(18)
ISDEBTORNOT NULL NUMBER(1)
ISBUSINESSNOT NULL NUMBER(1)
FIRSTNAMEVARCHAR2(14)
MIDDLENAMEVARCHAR2(14)
LASTNAMEVARCHAR2(14)
SUFFIXVARCHAR2(14)
ORGNAMEVARCHAR2(125)
ORGSEARCHNAMEVARCHAR2(125)
ISINTERNATIONALNOT NULL NUMBER(1)
ADDRESS1VARCHAR2(50)
ADDRESS2VARCHAR2(50)
ADDRESS3VARCHAR2(50)
ADDRESS4VARCHAR2(80)
CITYVARCHAR2(50)
STATEVARCHAR2(50)
ZIPVARCHAR2(10)
ORGTYPEVARCHAR2(50)
ORGJURISDICTIONVARCHAR2(50)
ORGIDVARCHAR2(20)
ACTIVE_INDNOT NULL NUMBER(1)
ENTEREDDATEDATE
TRUSTVARCHAR2(1)
MISCELLANEOUSVARCHAR2(500)

SECURED PARTY

FieldData Type
TRANSACTIONIDNOT NULL NUMBER(18)
FILINGNUMBERNUMBER(18)
ENTITYIDNOT NULL NUMBER(18)
ISBUSINESSNOT NULL NUMBER(1)
FIRSTNAMEVARCHAR2(14)
MIDDLENAMEVARCHAR2(14)
LASTNAMEVARCHAR2(14)
SUFFIXVARCHAR2(14)
ORGNAMEVARCHAR2(125)
ORGSEARCHNAMEVARCHAR2(125)
ISINTERNATIONALNOT NULL NUMBER(1)
ADDRESS1VARCHAR2(50)
ADDRESS2VARCHAR2(50)
ADDRESS3VARCHAR2(50)
ADDRESS4VARCHAR2(80)
CITYVARCHAR2(50)
STATEVARCHAR2(50)
ZIPVARCHAR2(10)
ORGTYPEVARCHAR2(50)
ORGJURISDICTIONVARCHAR2(50)
ORGIDVARCHAR2(20)
ACTIVE_INDNOT NULL NUMBER(1)
ENTEREDDATEDATE

Back