| 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 | TYPE | Source of the change in the transaction figures | nvarchar | 2 | 0 | CHAR | (N' ') | No | | EWU_CHTYPE | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 4 | KONTO | General Ledger Account | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | HKONT | Allow NULL? |
| 5 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | GSBER | Allow NULL? |
| 6 | RTCUR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | No | * | RTCUR | Allow NULL? |
| 7 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 8 | POPER | Posting period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | POPER | Allow NULL? |
| 9 | SHBKZ | Special G/L Indicator | char | 1 | 0 | CHAR | (N' ') | No | * | UMSKZ | Allow NULL? |
| 10 | TSLVT_S | Converted transaction figure in item currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | TSLVT_S | |
| 11 | TSLVT_E | Items/subledger total in item currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | TSLVT_E | |
| 12 | TSLVT_D | Item currency difference | decimal | 15 | 2 | CURR | ((0)) | Yes | | TSLVT_D | |
| 13 | LCVT1_S | Converted transaction figure in first local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | LCVT1_S | |
| 14 | LCVT1_E | Items/subledger total in first local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | LCVT1_E | |
| 15 | LCVT1_D | First local currency difference | decimal | 15 | 2 | CURR | ((0)) | Yes | | LCVT1_D | |
| 16 | LCVT2_S | Converted transaction figure in second local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | LCVT2_S | |
| 17 | LCVT2_E | Items/subledger total in second local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | LCVT2_E | |
| 18 | LCVT2_D | Second local currency difference | decimal | 15 | 2 | CURR | ((0)) | Yes | | LCVT2_D | |
| 19 | LCVT3_S | Converted transaction figure in third local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | LCVT3_S | |
| 20 | LCVT3_E | Items/subledger total in third local currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | LCVT3_E | |
| 21 | LCVT3_D | Third local currency difference | decimal | 15 | 2 | CURR | ((0)) | Yes | | LCVT3_D | |
| 22 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
