| 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 | ANLAGE | Installation | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | ANLAGE | Allow NULL? |
| 3 | ABRDATS | Scheduled Billing Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ABRDATS | Allow NULL? |
| 4 | ABRVORG | Billing Transaction | nvarchar | 2 | 0 | CHAR | (N' ') | No | | ABRVORG | Allow NULL? |
| 5 | VERTRAG | Contract | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VERTRAG | Allow NULL? |
| 6 | BILLDOCNO | Number of a billing document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | E_BELNR | Allow NULL? |
| 7 | INVDOCNO | Number of print document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | E_PRINTDOC | Allow NULL? |
| 8 | NETAMOUNT | Net amount of billing line item | decimal | 13 | 2 | CURR | ((0)) | Yes | | NETTOBTR | |
| 9 | TAXAMOUNT | Tax Amount Bill Line | decimal | 13 | 2 | CURR | ((0)) | Yes | | STEUERBTR | |
| 10 | CURRENCY | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TWAERS | Allow NULL? |
| 11 | TAXDATE | Tax Determination Date for On-Site Bill | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | E_OSB_TAX_DATE | Allow NULL? |
| 12 | DUEDATE | Due date for net payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDN_KK | Allow NULL? |
| 13 | DISCOUNT | Cash discount rate | decimal | 5 | 3 | DEC | ((0)) | Yes | | SKTPZ_KK | |
| 14 | DISCOUNTDATE | Due Date for Cash Discount | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDS_KK | Allow NULL? |
| 15 | PAYMENTFORMNO | Payment Form Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | NRZAS_KK | Allow NULL? |
| 16 | ONLY_NOTIFICAT | On-Site Billing - On-Site Document as Customer Information | char | 1 | 0 | CHAR | (N' ') | Yes | | E_OSB_NOTIFICATION | Allow NULL? |
| 17 | SYS_BILL_PRINT | Print On-Site Billing from the System | char | 1 | 0 | CHAR | (N' ') | Yes | | E_OSB_BILL_PRINT | Allow NULL? |
| 18 | EXBEL | Official Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | EXBEL_KK | Allow NULL? |
| 19 | CANCEL | Status of Official Document Number | char | 1 | 0 | CHAR | (N' ') | Yes | | EXSTA_KK | Allow NULL? |
| 20 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPART_KK | Allow NULL? |
| 21 | BRANCH | Branch | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BRANCH_KK | Allow NULL? |
| 22 | ATTRIBUTE1 | Attribute For Official Document Number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE_KK | Allow NULL? |
| 23 | ATTRIBUTE2 | Attribute For Official Document Number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE_KK | Allow NULL? |
| 24 | ATTRIBUTE3 | Attribute For Official Document Number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE_KK | Allow NULL? |
| 25 | ATTRIBUTE4 | Attribute For Official Document Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE20_KK | Allow NULL? |
| 26 | ATTRIBUTE5 | Attribute For Official Document Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ATTRIBUTE20_KK | Allow NULL? |
| 27 | OBJECT | Name of number range object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | NROBJ | Allow NULL? |
| 28 | SUBOBJECT | Number range object subobject value | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | NRSOBJ | Allow NULL? |
| 29 | NRRANGENR | Number range number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NRNR | Allow NULL? |
| 30 | TOYEAR | To fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | NRYEAR | Allow NULL? |
| 31 | DOCCLS | Document Class for Official Document Numbers | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | DOCCLS_KK | Allow NULL? |
| 32 | EXBELDATE | Date of Official Document Number Assignment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | E_OSB_EXBEL_DATE | Allow NULL? |
| 33 | EXBELUSED | Open Document Number Used in Invoicing | char | 1 | 0 | CHAR | (N' ') | Yes | | E_OSB_EXBEL_USED | Allow NULL? |
| 34 | STATE | Status of On-Site Billing Data | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | E_OSB_STATE | Allow NULL? |
| 35 | HASH | Hash Code | varbinary | 16 | 0 | RAW | | Yes | | HASHC_KK | |
| 36 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT_KK | Allow NULL? |
| 37 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 38 | OSB_GROUP | On-Site Billing Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | E_OSB_GROUP | Allow NULL? |
