| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DUNS | DUNS Number | nvarchar | 9 | 0 | | | | Allow NULL? |
| 3 | DUNS4 | DUNS+4 | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | CAGE | CAGE Code | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | BUSNAME | Legal Business Name | nvarchar | 120 | 0 | | | | Allow NULL? |
| 6 | DBANAME | Doing Business As | nvarchar | 60 | 0 | | | | Allow NULL? |
| 7 | TAXID | CCR TaxID | nvarchar | 9 | 0 | | | | Allow NULL? |
| 8 | SSN | Social Security Number | nvarchar | 9 | 0 | | | | Allow NULL? |
| 9 | REGSTAT | Current Registration Status | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | EXPDATE | Registration Expiration Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | DIVNAME | Division Name | nvarchar | 60 | 0 | | | | Allow NULL? |
| 12 | DIVNUM | Division Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | URL | Uniform Resource Locator | nvarchar | 200 | 0 | | | | Allow NULL? |
| 14 | BUSSTART | Business start date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | EMPLNUM | Number of employees | nvarchar | 15 | 0 | | | | Allow NULL? |
| 16 | LOCEMPLNUM | Location Employee Number | nvarchar | 15 | 0 | | | | Allow NULL? |
| 17 | FISCEND | Fiscal Year End Close Date (MMDD) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | REVENUE | Revenue | nvarchar | 15 | 0 | | | | Allow NULL? |
| 19 | LOCREVENUE | Location Revenue | nvarchar | 15 | 0 | | | | Allow NULL? |
| 20 | COSECLVL | Company Security Level | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | EMSECLVL | Highest Employee Security Level | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | ORGTYP | Organization Type Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | DELFEDDEBT | Obsolete field (do not use) - Delinquent Federal Debt | char | 1 | 0 | | | | Allow NULL? |
| 24 | NOPUBDISPLAY | Obsolete field (do not use) - No Public Display Flag | char | 1 | 0 | | | | Allow NULL? |
| 25 | XUSNAM | User name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 26 | XDATE | Last CCR Extract Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | XTIME | Last CCR Extract Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 28 | MPIN | Marketing Partner Identification Number | nvarchar | 9 | 0 | | | | Allow NULL? |
| 29 | FININST | Financial Institution | nvarchar | 30 | 0 | | | | Allow NULL? |
| 30 | ABAROUTE | American Bankers Association Routing Number | nvarchar | 9 | 0 | | | | Allow NULL? |
| 31 | ACCNTNO | Account Number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 32 | ACCNTYP | Account Type | char | 1 | 0 | | | | Allow NULL? |
| 33 | LOCKBOX | Lock Box | nvarchar | 20 | 0 | | | | Allow NULL? |
| 34 | AUTHDATE | Authorization Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | EDIVAN | Value Added Network | nvarchar | 60 | 0 | | | | Allow NULL? |
| 36 | EDIISAQ | ISA Qualifier | nvarchar | 2 | 0 | | | | Allow NULL? |
| 37 | EDIISASQ | ISA Sender Qualifier | nvarchar | 15 | 0 | | | | Allow NULL? |
| 38 | EDIGS02 | GS02 Identifier | nvarchar | 15 | 0 | | | | Allow NULL? |
| 39 | EDIREC820 | Receive 820 | char | 1 | 0 | | | | Allow NULL? |
| 40 | DBUPDATE | Last Update Date from Dun and Bradstreet | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | DBBUSNAME | D&B Monitoring: Legal Business Name | nvarchar | 120 | 0 | | | | Allow NULL? |
| 42 | DBDBANAME | D&B Monitoring: Doing Business As | nvarchar | 60 | 0 | | | | Allow NULL? |
| 43 | DBMONST | Dun and Bradstreet Monitoring Status | nvarchar | 20 | 0 | | | | Allow NULL? |
| 44 | DBBUSST | Dun and Bradstreet Current Business Status | char | 1 | 0 | | | | Allow NULL? |
| 45 | REGDATE | Registration date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 46 | STATEINC | State of Incorporation | nvarchar | 2 | 0 | | | | Allow NULL? |
| 47 | COUNTRYINC | Country of Incorporation | nvarchar | 3 | 0 | | | | Allow NULL? |
