| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | LAUFD | Date on Which the Program Is to Be Run | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | LAUFI | Additional Identification | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | UMBWM | Valuation Methods in Financial Accounting | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | ZBUKR | Target Company Code for Evaluation | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | GRUPPE | Valuation Group | nvarchar | 40 | 0 | | | | Allow NULL? |
| 7 | KOART | Account Type | char | 1 | 0 | | | | Allow NULL? |
| 8 | KUNNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | HKONT | General Ledger Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | BWBER | Valuation Area for FI Year-End Closing | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | VBUND | Company ID | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | XBLNR | Reference Document Number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 19 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 20 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | ZFBDT | Baseline Date for Due Date Calculation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | FAEDT | Due Date for Net Payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | BLART | Document Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | BSCHL | Posting Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | MSCHL | Dunning key | char | 1 | 0 | | | | Allow NULL? |
| 28 | MANSP | Dunning block | char | 1 | 0 | | | | Allow NULL? |
| 29 | MABER | Dunning Area | nvarchar | 2 | 0 | | | | Allow NULL? |
| 30 | MADAT | Last dunned on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | UMSKS | Special G/L Transaction Type | char | 1 | 0 | | | | Allow NULL? |
| 32 | UMSKZ | Special G/L Indicator | char | 1 | 0 | | | | Allow NULL? |
| 33 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | | | | Allow NULL? |
| 34 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 35 | DMSHB | Amount in Local Currency with +/- Signs | decimal | 13 | 2 | | | | |
| 36 | WRSHB | Foreign Currency Amount with Signs (+/-) | decimal | 13 | 2 | | | | |
| 37 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | | | | Allow NULL? |
| 38 | REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 39 | REBZZ | Line Item in the Relevant Invoice | nvarchar | 3 | 0 | | | | Allow NULL? |
| 40 | LAND1 | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 41 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 42 | DMSHB_BAS | Base Amount in Local Currency | decimal | 13 | 2 | | | | |
| 43 | X_BSBM | Valuation Difference was Entered Separately | char | 1 | 0 | | | | Allow NULL? |
| 44 | WBRSL | Value Adjustment Key | nvarchar | 2 | 0 | | | | Allow NULL? |
| 45 | OVDUE | Days Overdue | nvarchar | 3 | 0 | | | | Allow NULL? |
| 46 | ZINSO | Debit interest rate | decimal | 7 | 3 | | | | |
| 47 | XMANU | Valuate items manually | char | 1 | 0 | | | | Allow NULL? |
| 48 | XEXTR | Indicator for External Valuation | char | 1 | 0 | | | | Allow NULL? |
| 49 | PWBTR | Flat-Rate Value for Value Adjustment | decimal | 15 | 2 | | | | |
| 50 | BWSHB_GROS | Gross Valuation Difference | decimal | 15 | 2 | | | | |
| 51 | BWSHB_OLD | Old Valuation Difference | decimal | 15 | 2 | | | | |
| 52 | BWSHB_NET | Valuation Difference | decimal | 15 | 2 | | | | |
| 53 | XCLEAR | Credit Memo(s) Offset (Cleared) Against Invoice | char | 1 | 0 | | | | Allow NULL? |
| 54 | FUTURE | Future | char | 1 | 0 | | | | Allow NULL? |
| 55 | RMVCT | Transaction Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 56 | BWSHB_NET_REM2 | Valuation Difference | decimal | 15 | 2 | | | | |
| 57 | BWSHB_GROS_REM2 | Gross Valuation Difference | decimal | 15 | 2 | | | | |
| 58 | BWSHB_OLD_REM2 | Old Valuation Difference | decimal | 15 | 2 | | | | |
| 59 | BWSHB_NET_REM3 | Valuation Difference | decimal | 15 | 2 | | | | |
| 60 | BWSHB_GROS_REM3 | Gross Valuation Difference | decimal | 15 | 2 | | | | |
| 61 | BWSHB_OLD_REM3 | Old Valuation Difference | decimal | 15 | 2 | | | | |
| 62 | FILKD | Account Number of the Branch | nvarchar | 10 | 0 | | | | Allow NULL? |
| 63 | XCUST_VERR | Single-Character Indicator | char | 1 | 0 | | | | Allow NULL? |
| 64 | CUST_VERR_TXT | Comment | nvarchar | 50 | 0 | | | | Allow NULL? |
| 65 | TXT | Comment | nvarchar | 50 | 0 | | | | Allow NULL? |
