| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | GJAHR | Posting year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR_KK | Allow NULL? |
| 4 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SH_OPBEL_KK | Allow NULL? |
| 5 | VBELN | IS-M/SD: Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | ISPVBELN | Allow NULL? |
| 6 | ISPBUPER | Fiscal Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | MONAT | Allow NULL? |
| 7 | WAERK | SD Document Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERK | Allow NULL? |
| 8 | FKART | Billing Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FKART | Allow NULL? |
| 9 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FKDAT | Allow NULL? |
| 10 | KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | KALSM_D | Allow NULL? |
| 11 | KUNAG | Sold-to party | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNAG | Allow NULL? |
| 12 | KUNRG | Payer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNRG | Allow NULL? |
| 13 | KUNRE | Bill-to party | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNRE | Allow NULL? |
| 14 | ISPSFAKT | IS-M: Number of Billing Document Reversed | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISPSFAKT | Allow NULL? |
| 15 | ISPJSTORN | IS-M: Reversal Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | JSTORN | Allow NULL? |
| 16 | ISPSTOGRD | IS-M: Billing Document Reversal Reason | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | JSTOGRDF | Allow NULL? |
| 17 | ISPXJSIND | Repeat Billing After Reversal | char | 1 | 0 | CHAR | (N' ') | Yes | | XJSIND | Allow NULL? |
| 18 | VBTYP | SD document category | char | 1 | 0 | CHAR | (N' ') | Yes | | VBTYP | Allow NULL? |
| 19 | NETWR | Value of invoice | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TXW_NETWR | Allow NULL? |
| 20 | ISPBRTWR | IS-M/SD: Gross Value of Billing Document in Doc. Currency | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | ISMSD_TXW_BRTWR | Allow NULL? |
| 21 | KNUMV | Number of the document condition | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KNUMV | Allow NULL? |
| 22 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKORG | Allow NULL? |
| 23 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 24 | LAND1 | Country of Destination | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LLAND | Allow NULL? |
| 25 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | STCEG | Allow NULL? |
| 26 | STCEG_H | Origin of sales tax ID number | char | 1 | 0 | CHAR | (N' ') | Yes | | STCEG_H | Allow NULL? |
| 27 | STCEG_L | Country of Sales Tax ID Number | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | STCEG_L | Allow NULL? |
| 28 | ISPZLSCH | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | * | DZLSCH | Allow NULL? |
| 29 | SAMMG | IS-M: Group Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISPSAMMG | Allow NULL? |
| 30 | ISPJUEBART | IS-M: Transfer Type | char | 1 | 0 | CHAR | (N' ') | Yes | | JUEBART | Allow NULL? |
| 31 | ISPUEBNR | IS-M: Number of Transfer Run to FI | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISPUEBNR | Allow NULL? |
| 32 | AWREF | Reference Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWREF | Allow NULL? |
