| 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 | Original Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GLE_MCA_DTE_OGJAHR | Allow NULL? |
| 4 | BELNR | Original Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | GLE_MCA_DTE_OBELNR | Allow NULL? |
| 5 | BUZEI | Original Line Item | nvarchar | 3 | 0 | NUMC | (N'000') | No | | GLE_MCA_DTE_OBUZEI | Allow NULL? |
| 6 | KURSF | Exchange rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURSF | |
| 7 | KURS2 | Exchange Rate for the Second Local Currency | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURS2 | |
| 8 | KURS3 | Exchange Rate for the Third Local Currency | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURS3 | |
| 9 | KURSX | Market Data Exchange Rate | decimal | 28 | 14 | DEC | ((0)) | Yes | | GLE_FXR_DTE_RATEX28 | |
| 10 | KUR1X | Market Data Exchange Rate 2 | decimal | 28 | 14 | DEC | ((0)) | Yes | | GLE_FXR_DTE_RATE2X28 | |
| 11 | KUR2X | Market Data Exchange Rate 3 | decimal | 28 | 14 | DEC | ((0)) | Yes | | GLE_FXR_DTE_RATE3X28 | |
| 12 | KURSF_INT | Exchange rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURSF | |
| 13 | KURS2_INT | Exchange Rate for the Second Local Currency | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURS2 | |
| 14 | KURS3_INT | Exchange Rate for the Third Local Currency | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURS3 | |
| 15 | KURSX_INT | Market Data Exchange Rate | decimal | 28 | 14 | DEC | ((0)) | Yes | | GLE_FXR_DTE_RATEX28 | |
| 16 | KUR1X_INT | Market Data Exchange Rate 2 | decimal | 28 | 14 | DEC | ((0)) | Yes | | GLE_FXR_DTE_RATE2X28 | |
| 17 | KUR2X_INT | Market Data Exchange Rate 3 | decimal | 28 | 14 | DEC | ((0)) | Yes | | GLE_FXR_DTE_RATE3X28 | |