| 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 | * | MANDT | Allow NULL? |
| 2 | BILLDOCNO | Number of Billing Document | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | | BILLDOCNO_KK | Allow NULL? |
| 3 | REFDOCNO | Document Number in External System | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | REFDOCNO_KK | Allow NULL? |
| 4 | LOG_SYSTEM | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TBDLS | LOGSYS | Allow NULL? |
| 5 | APPLK | Application area | char | 1 | 0 | CHAR | (N' ') | Yes | | APPLK_KK | Allow NULL? |
| 6 | SRCPROCESS | Origin Process of Billing Document | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | TFK2641 | SRCPROCESS_KK | Allow NULL? |
| 7 | SRCDOCTYPE | Source Document Type of Billing Document | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | SRCDOCTYPE_INVBI_KK | Allow NULL? |
| 8 | TECHDOCTYPE | Type of Technical Billing/Invoicing Document | char | 1 | 0 | CHAR | (N' ') | Yes | | TECHDOCTYPE_KK | Allow NULL? |
| 9 | DOCTYPE | Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TFK2600 | DOCTYPE_KK | Allow NULL? |
| 10 | TARGPROCESS | Target Process That Invoices the Source Document | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFK2642 | TARGPROCESS_KK | Allow NULL? |
| 11 | GPART | Business Partner Number for Billing and Invoicing | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | BUT000 | GPART_CI_KK | Allow NULL? |
| 12 | VKONT | Contract Account Number for Billing and Invoicing | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | FKKVK | VKONT_CI_KK | Allow NULL? |
| 13 | MDCAT | Type of Master Data for Billing and Invoicing | char | 1 | 0 | CHAR | (N' ') | Yes | | MDCAT_CI_KK | Allow NULL? |
| 14 | GPART_INV | Alternative Business Partner for Invoicing | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPART_INV_KK | Allow NULL? |
| 15 | VKONT_INV | Alternative Contract Account for Invoicing | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | VKONT_INV_KK | Allow NULL? |
| 16 | DATE_FROM | Start of Document Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BILL_PERIOD_FROM_KK | Allow NULL? |
| 17 | DATE_TO | End of Document Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BILL_PERIOD_TO_KK | Allow NULL? |
| 18 | BILL_BASEDATE | Baseline Date for Period Assignment in Billing | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BILL_BASEDATE_KK | Allow NULL? |
| 19 | SIMULATED | Billing Document Is Simulated | char | 1 | 0 | CHAR | (N' ') | Yes | | SIMULATED_KK | Allow NULL? |
| 20 | BILL_CURR | Currency of Billing Document | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BILL_CURR_KK | Allow NULL? |
| 21 | INV_CURR | Target Currency of Invoicing | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | INV_CURR_KK | Allow NULL? |
| 22 | TAX_DET_TYPE | Type of Tax Calculation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TAX_DET_TYPE_KK | Allow NULL? |
| 23 | TAX_DATE_TYPE | Type of Tax Date | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TAX_DATE_TYPE_KK | Allow NULL? |
| 24 | INV_CATEGORY | Invoicing Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFK2604 | INV_CATEGORY_KK | Allow NULL? |
| 25 | SEPARATE_INV | Control of Invoicing Unit | char | 1 | 0 | CHAR | (N' ') | Yes | | SEPARATE_INV_KK | Allow NULL? |
| 26 | INVOICE_FIRST | Target Date for Invoicing | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | INVOICE_FIRST_KK | Allow NULL? |
| 27 | REVREASON | Reversal Reason for Billing Document | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BILL_REVREASON_KK | Allow NULL? |
| 28 | REVERSALDOC | Number of Reversal Document for Billing Document | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | REVERSALBILLDOC_KK | Allow NULL? |
| 29 | REVERSEDDOC | Number of Reversed Billing Document | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | REVERSEDBILLDOC_KK | Allow NULL? |
| 30 | ADJUSTMENTDOC | Number of Adjustment Billing Document | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | ADJUSTMENTBILLDOC_KK | Allow NULL? |
| 31 | ADJUSTEDDOC | Number of Adjusted Billing Document | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | * | ADJUSTEDBILLDOC_KK | Allow NULL? |
| 32 | CORRCAT | Category of Invoice Correction | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CORRCAT_KK | Allow NULL? |
| 33 | TRIGDELETED | Invoicing Order Deleted | char | 1 | 0 | CHAR | (N' ') | Yes | | TRIGDELETED_KK | Allow NULL? |
| 34 | XINFBILL | Additional Statement in Another Invoice for Information Only | char | 1 | 0 | CHAR | (N' ') | Yes | | XINFBILL_KK | Allow NULL? |
| 35 | INVLOCK | Billing Document Is Locked for Invoicing | char | 1 | 0 | CHAR | (N' ') | Yes | | INVLOCK_KK | Allow NULL? |
| 36 | ADD_GROUP | Grouping of Additional Items | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ADD_GROUP_KK | Allow NULL? |
| 37 | XINVBILL_X | Billing Document Contains Links to Reference Objects | char | 1 | 0 | CHAR | (N' ') | Yes | | XINVBILL_X_KK | Allow NULL? |
| 38 | RECNUM | Total Number of Items of a Billing Document | int | 10 | 0 | INT4 | ((0)) | Yes | | BILLDOC_RECNUM_KK | Allow NULL? |
| 39 | CRNAME | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CRNAM | Allow NULL? |
| 40 | CRDATE | Date on Which Billing Document Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BILLCRDATE_KK | Allow NULL? |
| 41 | CRTIME | Time at Which Billing Document Was Created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BILLCRTIM_KK | Allow NULL? |
| 42 | BILLRUNNO | Internal Number of Billing Run | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BILLRUNNO_KK | Allow NULL? |
| 43 | BILLTYPE | Billing Type | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | BILLTYPE_KK | Allow NULL? |
| 44 | BILLCYCLE | Billing Cycle | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BILLCYCLE_KK | Allow NULL? |
| 45 | BILLGROUP | Billing Group | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | BILLGROUP_KK | Allow NULL? |
| 46 | BILLTO | Time of Billing | decimal | 15 | 0 | DEC | ((0)) | Yes | | BILLTASKBILLTO_KK | |
| 47 | TASKTYPE | Billing Order Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TASKTYPE_KK | Allow NULL? |
| 48 | HOTBILLING | Express Billing | char | 1 | 0 | CHAR | (N' ') | Yes | | HOTBILLING_KK | Allow NULL? |
| 49 | BILLPROCEDURE | Billing Procedure | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BILLPROCEDURE_KK | Allow NULL? |
| 50 | BILL_PROCESS | Billing Process | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFK8110 | BILL_PROCESS_KK | Allow NULL? |
| 51 | BILL_TYPE | Billing Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TFK8112 | BILL_TYPE_KK | Allow NULL? |
| 52 | PREPAID_INCL | Document Contains Prepaid Items | char | 1 | 0 | CHAR | (N' ') | Yes | | PREPAID_INCL_KK | Allow NULL? |
| 53 | PPREFILL_INCL | Document Contains Items for Prepaid Refill | char | 1 | 0 | CHAR | (N' ') | Yes | | PPREFILL_INCL_KK | Allow NULL? |
| 54 | PTSRL | Partner Settlement Rule | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PTSRL_KK | Allow NULL? |
