| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | TERMSCHL | Meter Reading Unit | nvarchar | 8 | 0 | CHAR | (N' ') | No | | ABLEINHEIT | Allow NULL? |
| 3 | TERMTEXT | Text for schedule master record | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | BEZEICH | Allow NULL? |
| 4 | PERIODEW | Period length: months | decimal | 2 | 0 | DEC | ((0)) | Yes | | PERIODEW | |
| 5 | PERIODET | Period category | char | 1 | 0 | CHAR | (N' ') | Yes | | PERIODET | Allow NULL? |
| 6 | EPER_ABL | Interval between meter reading and end of meter reading per. | decimal | 3 | 0 | DEC | ((0)) | Yes | | I_ENDPEABL | |
| 7 | AUF_ABL | Interval between order creation and scheduled reading date | decimal | 3 | 0 | DEC | ((0)) | Yes | | I_AUFTRABL | |
| 8 | DOWNL_ABL | Interval between download and meter reading | decimal | 3 | 0 | DEC | ((0)) | Yes | | I_DOWNLABL | |
| 9 | DRUCK_ABL | Days between printout of meter reading orders and MR | decimal | 3 | 0 | DEC | ((0)) | Yes | | I_DRUCKABL | |
| 10 | ANSCH_AUF | Interval between MR announcement and order creation | decimal | 3 | 0 | DEC | ((0)) | Yes | | I_ANSCHAUF | |
| 11 | AUKSA_AUF | Interval btw. customer MR order printout and order creation | decimal | 3 | 0 | DEC | ((0)) | Yes | | I_AUKSAAUF | |
| 12 | ZLEISTE | Permissible combinations of billing class/division category | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | E_ZLEISTE | Allow NULL? |
| 13 | PORTION | Portion | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | TE420 | PORTION | Allow NULL? |
| 14 | ABLESER | Meter reader number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TE115 | ABLESER | Allow NULL? |
| 15 | ABLZEIT | Meter reading time in hours | decimal | 5 | 1 | DEC | ((0)) | Yes | | ABLZEIT | |
| 16 | BELGNABL | Create meter reading documents for reg. not to be read | char | 1 | 0 | CHAR | (N' ') | Yes | | BELGNABL | Allow NULL? |
| 17 | AZVORABL | Number of previous meter readings | decimal | 2 | 0 | DEC | ((0)) | Yes | | AZVORABL | |
| 18 | FORMULAR | Form for meter reading order | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | EFRM | BELEGFORM | Allow NULL? |
| 19 | ZUSMIT | Meter reading together with allocated main MR unit | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | E_ZUSMIT | Allow NULL? |
| 20 | DECKBLAT | Form for cover sheet | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | EFRM | DCKBLTFORM | Allow NULL? |
| 21 | KSA_FORM | Form for customer meter reading order | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | EFRM | KSA_FORM | Allow NULL? |
| 22 | ANSCH_FORM | Form for meter reading announcement | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | EFRM | ANSCH_FORM | Allow NULL? |
| 23 | MDENR | Number for mobile data entry (MDE) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | MDENR | Allow NULL? |
| 24 | ZUORDKZ | Main meter reading unit | char | 1 | 0 | CHAR | (N' ') | Yes | | E_ZUORDKZ | Allow NULL? |
| 25 | MUENZZ | Slot/chip meter | char | 1 | 0 | CHAR | (N' ') | Yes | | MUENZZ | Allow NULL? |
| 26 | ABLKAR | Meter Reading Interval in Days | decimal | 2 | 0 | DEC | ((0)) | Yes | | ABLKART | |
| 27 | STANDKAR | Entry Interval in Days | decimal | 2 | 0 | DEC | ((0)) | Yes | | STANDKART | |
| 28 | ANSCHKAR | Interval (in days) for notification and MRO creation | decimal | 3 | 0 | DEC | ((0)) | Yes | | ANSCHKAR | |
| 29 | ABLART | Meter reading by customer | char | 1 | 0 | CHAR | (N' ') | Yes | | ABLART | Allow NULL? |
| 30 | EROEDAT | Creation date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EROEDAT | Allow NULL? |
| 31 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 32 | AENDDATE | Change date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AENDDATE | Allow NULL? |
| 33 | AENDNAM | Last changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENDNAM | Allow NULL? |
| 34 | ABLFIRMA | Number of heating costs subcontractor for meter reading | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ABLFIRMA | Allow NULL? |
| 35 | VERTRKL1 | Billing class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | EAKLASSE | E_AKLASSE | Allow NULL? |
| 36 | SPARTENTY1 | Division category | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | E_SPARTYP | Allow NULL? |
| 37 | VERTRKL2 | Billing class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | EAKLASSE | E_AKLASSE | Allow NULL? |
| 38 | SPARTENTY2 | Division category | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | E_SPARTYP | Allow NULL? |
| 39 | VERTRKL3 | Billing class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | EAKLASSE | E_AKLASSE | Allow NULL? |
| 40 | SPARTENTY3 | Division category | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | E_SPARTYP | Allow NULL? |
| 41 | VERTRKL4 | Billing class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | EAKLASSE | E_AKLASSE | Allow NULL? |
| 42 | SPARTENTY4 | Division category | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | E_SPARTYP | Allow NULL? |
| 43 | VERTRKL5 | Billing class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | EAKLASSE | E_AKLASSE | Allow NULL? |
| 44 | SPARTENTY5 | Division category | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | E_SPARTYP | Allow NULL? |
| 45 | IDENT | Factory Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFACD | WFCID | Allow NULL? |
| 46 | SAPKAL | Correct Non-Workday | char | 1 | 0 | CHAR | (N' ') | Yes | | CORR_OPT | Allow NULL? |
| 47 | STICHTAG | Key Date in Billing on a Monthly Basis | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | E_STICHTAG | Allow NULL? |
| 48 | DOWN_FORM | Form for download | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | EFRM | DOWN_FORM | Allow NULL? |
| 49 | TS_DYN | Dynamic scheduling | char | 1 | 0 | CHAR | (N' ') | Yes | | TS_DYN | Allow NULL? |
| 50 | ADV_BILL | Meter reading unit is for contracts billed in advance | char | 1 | 0 | CHAR | (N' ') | Yes | | ADV_BILL | Allow NULL? |
| 51 | TAGE | Number of days for period length | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PORT_TAGE | Allow NULL? |
| 52 | AUF_KAL | Use FC for Interval: Order Creation to Planned Meter Reading | char | 1 | 0 | CHAR | (N' ') | Yes | | AUF_KAL | Allow NULL? |
| 53 | DRU_KAL | Use FC for Interval: Printing MR Orders to Meter Reading | char | 1 | 0 | CHAR | (N' ') | Yes | | DRUCK_KAL | Allow NULL? |
| 54 | DOW_KAL | Use FC for Interval: Download to Meter Reading | char | 1 | 0 | CHAR | (N' ') | Yes | | DOWNL_KAL | Allow NULL? |
| 55 | ANK_KAL | Use FC for Interval: MR Announcement to Order Creation | char | 1 | 0 | CHAR | (N' ') | Yes | | ANSCH_KAL | Allow NULL? |
| 56 | KND_KAL | Use FC for Interval: Printing MR Orders to Meter Reading | char | 1 | 0 | CHAR | (N' ') | Yes | | AUKSA_KAL | Allow NULL? |
| 57 | ABL_Z | Meter Reading Center | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TE426 | ABL_Z | Allow NULL? |
| 58 | BEGRU | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BEGRU | Allow NULL? |
| 59 | PS_USE | Use Meter Reading Unit for Payment Schema | char | 1 | 0 | CHAR | (N' ') | Yes | | PS_USE | Allow NULL? |
| 60 | OSB_GROUP | On-Site Billing Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TE555 | E_OSB_GROUP | Allow NULL? |
