| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BILLACCOUNT | Billing Account Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | BILLACCREF | External Reference of Billing Account | nvarchar | 32 | 0 | | | | Allow NULL? |
| 4 | BILLACCREFCAT | External Reference Category of Billing Account | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | APPLK | Application area | char | 1 | 0 | | | | Allow NULL? |
| 6 | VKONT | Contract Account Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | GPART | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | | | | Allow NULL? |
| 9 | SUBAP | Subapplication in Contract Accounts Receivable and Payable | char | 1 | 0 | | | | Allow NULL? |
| 10 | BILLACCTYPE | Type of Billing Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | TS_FROM | Time Stamp for Start of Billing Account | decimal | 15 | 0 | | | | |
| 12 | TS_TO | Time Stamp for End of Billing Account | decimal | 15 | 0 | | | | |
| 13 | BILLACCTIMEZONE | Time Zone | nvarchar | 6 | 0 | | | | Allow NULL? |
| 14 | LOADTO | Time Stamp for End of EDR Transfer Period for Billing Acct | decimal | 15 | 0 | | | | |
| 15 | BILLEDTO | Time Stamp for End of Billing Period | decimal | 15 | 0 | | | | |
| 16 | BILLEDTOTEMP | Partially Billed To | decimal | 15 | 0 | | | | |
| 17 | BILLCYCLE | Billing Cycle | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | BILLGROUP | Billing Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | BC_VALIDTO | End of Billing Cycle | decimal | 15 | 0 | | | | |
| 20 | HOTBILLING | Express Billing | char | 1 | 0 | | | | Allow NULL? |
| 21 | BILLLOCKREASON | Reason for Billing Lock | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | BILLLOCKRELEASE | Reason for Releasing Billing Lock | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | KOFIZ | Account Determination ID | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | BEGRU | Authorization Group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | TARGPROCESS1 | Target Process That Invoices the Source Document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | CRNAME | Created By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 27 | CRTIMESTAMP | UTC Time Stamp for Creation | decimal | 15 | 0 | | | | |
| 28 | CHNAME | User Making Change | nvarchar | 12 | 0 | | | | Allow NULL? |
| 29 | CHTIMESTAMP | UTC Time Stamp of Last Change | decimal | 15 | 0 | | | | |
