| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TYPE | Source of the change in the transaction figures | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | KONTO | General Ledger Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | RTCUR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 7 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | POPER | Posting period | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | SHBKZ | Special G/L Indicator | char | 1 | 0 | | | | Allow NULL? |
| 10 | TSLVT_S | Converted transaction figure in item currency | decimal | 15 | 2 | | | | |
| 11 | TSLVT_E | Items/subledger total in item currency | decimal | 15 | 2 | | | | |
| 12 | TSLVT_D | Item currency difference | decimal | 15 | 2 | | | | |
| 13 | LCVT1_S | Converted transaction figure in first local currency | decimal | 15 | 2 | | | | |
| 14 | LCVT1_E | Items/subledger total in first local currency | decimal | 15 | 2 | | | | |
| 15 | LCVT1_D | First local currency difference | decimal | 15 | 2 | | | | |
| 16 | LCVT2_S | Converted transaction figure in second local currency | decimal | 15 | 2 | | | | |
| 17 | LCVT2_E | Items/subledger total in second local currency | decimal | 15 | 2 | | | | |
| 18 | LCVT2_D | Second local currency difference | decimal | 15 | 2 | | | | |
| 19 | LCVT3_S | Converted transaction figure in third local currency | decimal | 15 | 2 | | | | |
| 20 | LCVT3_E | Items/subledger total in third local currency | decimal | 15 | 2 | | | | |
| 21 | LCVT3_D | Third local currency difference | decimal | 15 | 2 | | | | |
| 22 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |