|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Elster Run
Table Name: OELS
Table Description: Elster Run
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| RunId | Run Number | Int | 11 | - | Â | Â | Â |
| VersionNum | Version Number | nVarChar | 13 | - | Â | Â | Â |
| DateType | Date Type | VarChar | 1 | - | Â | P | Posting Date |
| Â | Â | Â | Â | Â | Â | D | Document Date |
| Â | Â | Â | Â | Â | Â | V | VAT Date |
| Â | Â | Â | Â | Â | Â | C | System Date |
| FromDate | Date From | Date | 8 | - | Â | Â | Â |
| ToDate | Date To | Date | 8 | - | Â | Â | Â |
| CreditMemo | Credit Memos | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | Y | Yes |
| Status | Status | VarChar | 1 | - | Â | Â | Â |
| CompnyName | Company Name | nVarChar | 200 | - | Â | Â | Â |
| CountyCode | County Code | nVarChar | 100 | - | Â | Â | Â |
| TaxOffice | Tax Office | nVarChar | 100 | - | Â | Â | Â |
| TaxNum | Tax Number | nVarChar | 32 | - | Â | Â | Â |
| CreateTime | Creation Time | Int | 6 | - | Â | Â | Â |
| UpdateDate | Date of Update | Date | 8 | - | Â | Â | Â |
| UpdateTime | Update Time | Int | 6 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| UserSign2 | Updating User | Int | 6 | OUSR | Â | Â | Â |
| RevAutoDeb | Revoke Automatic Debit | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AmenReturn | Amended Return | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| CreOffPref | Credit Offer Prefer | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Documents | Documents | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| TestRun | Test Run | VarChar | 1 | - | Â | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Street | Street | nVarChar | 100 | - | Â | Â | Â |
| City | City | nVarChar | 100 | - | Â | Â | Â |
| ZipCode | Zip Code | nVarChar | 20 | - | Â | Â | Â |
| Block | Block | nVarChar | 100 | - | Â | Â | Â |
| Descript | Description | nVarChar | 100 | - | Â | Â | Â |
| NoteType | Supplementary Note Type | VarChar | 1 | - | Â | Â | Â |
| Note | Supplementary Note | nVarChar | 100 | - | Â | Â | Â |
| SpecialAdP | Special Advance Payment | Num | 19.6 | - | Â | Â | Â |
| InputData | Input Data | Text | 16 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | RunId |