| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KTOPL | Chart of Accounts | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | BWBER | Valuation Area for FI Year-End Closing | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | HKONT | General Ledger Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 6 | LKORR | Local Account for Adjusting Receivables/Payables | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | LSBEW | Local Account for Loss from Valuation | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | LHBEW | Local Account for Gain from Valuation | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | LSREA | Local Account for Realized Exchange Rate Losses | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | LHREA | Local Account for Realized Exchange Gains | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | LSTRA | Local Account for Loss from Translation | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | LHTRA | Local Account for Gain from Translation | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | LSTRV | Local Account for Clearing Translation Gain | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | LHTRV | Local Account for Clearing Translation Loss | nvarchar | 10 | 0 | | | | Allow NULL? |