| 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 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | BELNR_D | Allow NULL? |
| 4 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 5 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BUZEI | Allow NULL? |
| 6 | CURTP | Currency Type and Valuation View | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CURTP | Allow NULL? |
| 7 | BWBER | Valuation Area for FI Year-End Closing | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | BWBER | Allow NULL? |
| 8 | METHD | Valuation Methods in Financial Accounting | nvarchar | 3 | 0 | CHAR | (N' ') | No | | UMBWM | Allow NULL? |
| 9 | DATUM | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DATUM | Allow NULL? |
| 10 | RUNID | Run ID | nvarchar | 2 | 0 | NUMC | (N'00') | No | | FAGL_RUNID | Allow NULL? |
| 11 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 12 | BWSHB | Valuation Difference | decimal | 15 | 2 | CURR | ((0)) | Yes | | BWSHB | |
| 13 | REVERSE_ID | Reversed by Run ID | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FAGL_REVERSE_ID | Allow NULL? |
| 14 | FCV_STATUS | Status of Foreign Currency Valuation | char | 1 | 0 | CHAR | (N' ') | No | | FAGL_FCV_STATUS | Allow NULL? |
| 15 | VALRUNKEY | Identification Number of Valuation Run | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | FAGL_FCV_RUNKEY | Allow NULL? |
| 16 | VALTRGTPL_ACCT | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAKNR | Allow NULL? |
| 17 | VALTRGTPL_TYPE | Use P&L Target Account for Expenses/Revenues | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_FCV_PLTYPE | Allow NULL? |
| 18 | RXDRUNKEY | Identification Number of Valuation Run | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | FAGL_FCV_RUNKEY | Allow NULL? |
| 19 | RXDXKDFT | Indicator: Post translations for exchange rate differences ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XKDFT | Allow NULL? |
| 20 | VALTRGTBA_ACCT | Adjustment Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KORRK | Allow NULL? |
| 21 | VALRUNKEY_NRNR | Number range number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NRNR | Allow NULL? |
| 22 | RXDRUNKEY_NRNR | Number range number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NRNR | Allow NULL? |
