| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PARTNR | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | BUSINESS_Y | Fiscal year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | BAL_SH_CUR | Balance Sheet Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | GEN_MEET_D | Date of Annual Stockholders Meeting | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | BU_Y_BEGIN | Fiscal Year Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | BU_Y_END | Fiscal Year End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | ANNUAL_ACC | Year-End Closing | char | 1 | 0 | | | | Allow NULL? |
| 9 | ANNU_ACC_D | Year-End Closing Date for Fiscal Year | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | CONS_FST_D | Date of Consolidated Financial Statements of Group Company | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | CAPI_STOCK | Amount of Authorized Capital Stock for Company | decimal | 15 | 2 | | | | |
| 12 | SHAR_STOCK | Amount of Issued Stock Capital for Company | decimal | 15 | 2 | | | | |
| 13 | PRSH_STOCK | Amount of Participation Certificates Outstanding for Company | decimal | 15 | 2 | | | | |
| 14 | EQUITY | Amount of Equity Capital for Company | decimal | 15 | 2 | | | | |
| 15 | GROSS_AMNT | Gross Premium | decimal | 15 | 2 | | | | |
| 16 | NET_AMOUNT | Net Premium | decimal | 15 | 2 | | | | |
| 17 | TURNOVER | Amount of Annual Sales for Company | decimal | 15 | 2 | | | | |
| 18 | NET_INCOME | Amount of Annual Net Income/Net Loss for Company | decimal | 15 | 2 | | | | |
| 19 | DIV_DIS_AM | Dividend/Profit Distribution Amount for Company | decimal | 15 | 2 | | | | |
| 20 | DEBTS_FACT | Debt Ratio in Years | decimal | 6 | 3 | | | | |
| 21 | DIS_PROFIT | Amount of Annual Profit/Loss for Organization | decimal | 15 | 2 | | | | |
| 22 | BAL_AMOUNT | Amount of Balance Sheet Total for Company | decimal | 15 | 2 | | | | |
| 23 | STAFF_COUNT | Number of Employees in Company | nvarchar | 7 | 0 | | | | Allow NULL? |
| 24 | CAP_RES | Amount of Capital Reserve for Company | decimal | 15 | 2 | | | | |
| 25 | REV_RES_LEG | Amount of Legal Revenue Reserves for Company | decimal | 15 | 2 | | | | |
| 26 | REV_RES_OWN_SHR | Revenue Reserves for Own Stock | decimal | 15 | 2 | | | | |
| 27 | REV_RES_BY_LAWS | Amount of Statutory Revenue Reserve for Company | decimal | 15 | 2 | | | | |
| 28 | REV_RES_OTHERS | Amount of Other Revenue Reserves for Company | decimal | 15 | 2 | | | | |
| 29 | FORW_PROFIT_LOSS | Amount of Profit/Loss Carried Forward for Company | decimal | 15 | 2 | | | | |
| 30 | LIABILIT_SECOND | Amount of Subordinated Liabilities for Company | decimal | 15 | 2 | | | | |
| 31 | RET_TOT_CAP_EMPL | Return on Total Capital Employed for Company in Percent | decimal | 5 | 2 | | | | |
| 32 | REDUC_LONG_TERM | Debt Clearance Period in Years | decimal | 5 | 2 | | | | |
| 33 | COEFF_FINANCE | Financing Coefficient for Company in Percent | decimal | 5 | 2 | | | | |
| 34 | EQUITY_CAPIT | Equity Ratio of Company in Percent | decimal | 5 | 2 | | | | |
