| 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: Settlement number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | JVBELN | 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 | OBJART | IS-M: Object type for document flow | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | LABART | Allow NULL? |
| 9 | ABDAT | IS-M: Settlement Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | JABDAT | Allow NULL? |
| 10 | KALSM | Sales and Distribution: Pricing Procedure in Pricing | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | KALSMASD | Allow NULL? |
| 11 | VERSGE | IS-M: Service Company | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VERSERVGES | Allow NULL? |
| 12 | GPNR_ZE | IS-M/SD: Business Partner Payee | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPNR_ZEMPF | Allow NULL? |
| 13 | JSABRN | IS-M: Number of Reversed Settlement | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | JSABRN | Allow NULL? |
| 14 | JSTORN | IS-M: Reversal Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | JSTORN | Allow NULL? |
| 15 | STOGRD | IS-M: Service Settlement Reversal Reason | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | JSTOGRD | Allow NULL? |
| 16 | JVBTYP | IS-M: Sales document category | char | 1 | 0 | CHAR | (N' ') | Yes | | JVBTYP | Allow NULL? |
| 17 | NETWR | Value of invoice | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TXW_NETWR | Allow NULL? |
| 18 | BRTWR | IS-M/SD: Gross Value of Billing Document in Doc. Currency | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | ISMSD_TXW_BRTWR | Allow NULL? |
| 19 | KNUMV | Number of the document condition | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KNUMV | Allow NULL? |
| 20 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EKORG | Allow NULL? |
| 21 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 22 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND1 | Allow NULL? |
| 23 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | STCEG | Allow NULL? |
| 24 | UEBNR | IS-M: Number of Transfer Run to FI | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ISPUEBNR | Allow NULL? |
| 25 | AWREF | Reference Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWREF | Allow NULL? |
