| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | GPART | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | KJAHR | Calendar year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | BON01 | Creditw. no. for January | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | BON02 | Creditworthiness number for February | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | BON03 | Creditworthiness number for March | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | BON04 | Creditworthiness number for April | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | BON05 | Creditworthiness number for May | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | BON06 | Creditw. no. for June | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | BON07 | Creditw.no. for July | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | BON08 | Creditw.no. for August | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | BON09 | Creditw.no. for September | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | BON10 | Creditw.no. for October | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | BON11 | Creditw.no. for November | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | BON12 | Creditworthiness number for December | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | BONMA | Manual Creditworthiness | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | BONVH | Creditworthiness factor as a percentage | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | BMADT | Date On Which Creditworthiness Was Manually Set | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | LFDNR | Sequential Number Of a Creditworthiness Entry | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | BONFR | Fixed Creditworthiness | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | BFRDT | Date on Which Creditworthiness was Fixed | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | BRLDT | Release Date of Fixed Creditworthiness | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | BNEXT | Value of External Creditworthiness Valuation | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | BEXDT | Date of Last Change to Rating | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | BCMTF | FI-CA Score Must Be Replicated to SAP Credit Management | char | 1 | 0 | | | | Allow NULL? |
| 26 | BONTF | FI-CA Creditworthiness Last Replicated to Credit Management | nvarchar | 4 | 0 | | | | Allow NULL? |
