| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | IDENT | Broker Report Identification | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | SRCHKEY | Alternative Search Term for the Broker Report | nvarchar | 40 | 0 | | | | Allow NULL? |
| 4 | STATUS | Broker report status | char | 1 | 0 | | | | Allow NULL? |
| 5 | BROKER | Business Partner Number for Reporting Broker | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | BROOBJ | Broker Contract, Insurance Object for the Reporting Broker | nvarchar | 20 | 0 | | | | Allow NULL? |
| 7 | PERDFROM | Invoicing Period From (Broker Report) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | PERDTO | Invoicing Period to (Broker Report) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | REPTYPE | Broker Report Invoicing Type | char | 1 | 0 | | | | Allow NULL? |
| 10 | INITREAS | Trigger for Creating a Broker Report | char | 1 | 0 | | | | Allow NULL? |
| 11 | ORIGIN | Origin of Broker Report | char | 1 | 0 | | | | Allow NULL? |
| 12 | INITDATE | Date Info or Correspondence Received from Broker | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | XCORRREQU | Correspondence Request was Delivered | char | 1 | 0 | | | | Allow NULL? |
| 14 | PROC_TYPE | Broker Report: Processing Type | char | 1 | 0 | | | | Allow NULL? |
| 15 | XPOSPOSTED | Flag: Items Already Posted Before Report Closed | char | 1 | 0 | | | | Allow NULL? |
| 16 | XPOSREVERSED | Flag: Individual Items Reversed | char | 1 | 0 | | | | Allow NULL? |
| 17 | XSHFIKEY | Use Collective Reconciliation Key | char | 1 | 0 | | | | Allow NULL? |
| 18 | APPLC | Application area | char | 1 | 0 | | | | Allow NULL? |
| 19 | DOCSRC | Document Origin Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | FIKEY | Reconciliation Key for General Ledger | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | COMPCODE | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | BUISAREA | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | CLEARACC | Premium/Benefit Clearing Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | CURR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 25 | EXCHRATE | Exchange rate | decimal | 9 | 5 | | | | |
| 26 | POSTDATE | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | DOCDATE | Document Date in Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | VALDATE | Value date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | NUMBPOS | Broker Report: Number of Items | nvarchar | 6 | 0 | | | | Allow NULL? |
| 30 | MAXSUBPOS | Broker Report: Highest Assigned Subitem Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 31 | MAXXBLNR | Broker report - highest assigned ref no. for posted docs | nvarchar | 16 | 0 | | | | Allow NULL? |
| 32 | MAXSUMNO | Broker Report: Highest Assigned Number for Totals Postings | nvarchar | 16 | 0 | | | | Allow NULL? |
| 33 | MAXQUIND | Broker Report: Highest Assigned Fast Entry Index | nvarchar | 6 | 0 | | | | Allow NULL? |
| 34 | MAXGRPNUMB | Broker Report: Highest Assigned Grouping Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 35 | POSTSUM | Broker Report: Total of Amounts to be Posted | decimal | 15 | 2 | | | | |
| 36 | POSTCURR | Broker Report: Currency Key for Total Amount | nvarchar | 5 | 0 | | | | Allow NULL? |
| 37 | CTRLNUMBPOS | Control Total For Number Of Items In A Broker Report | nvarchar | 6 | 0 | | | | Allow NULL? |
| 38 | CTRLSUM | Broker Report Control Total | decimal | 15 | 2 | | | | |
| 39 | CTRLCURR | Currency of control totals for broker report | nvarchar | 5 | 0 | | | | Allow NULL? |
| 40 | CTRLSUM_NET | Net Control Total (Premiums - Commissions) for Broker Report | decimal | 15 | 2 | | | | |
| 41 | VERSION | Broker Report Version Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 42 | CREANAME | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 43 | CREADATE | Date on Which Record Was Created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 44 | CREATIME | Time at which the object was created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 45 | CHNGNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 46 | CHNGDATE | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 47 | CHNGTIME | Time at Which the Object Was Last Changed | nvarchar | 6 | 0 | | | | Allow NULL? |
