| 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_CLR | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 3 | BELNR_CLR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | BELNR_D | Allow NULL? |
| 4 | GJAHR_CLR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 5 | INDEX_CLR | Sequential Number for Clearing Information | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | INDEX_CLR | Allow NULL? |
| 6 | AGZEI | Clearing Item | decimal | 5 | 0 | DEC | ((0)) | Yes | | AGZEI | |
| 7 | AGBUZ | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BUZEI | Allow NULL? |
| 8 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 9 | CLRIN | Type of Clearing in Table AUSZ_CLR | char | 1 | 0 | CHAR | (N' ') | Yes | | CLRINF | Allow NULL? |
| 10 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 11 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 12 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 13 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BUZEI | Allow NULL? |
| 14 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SHKZG | Allow NULL? |
| 15 | DMBTR | Amount in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBTR | |
| 16 | DMBE2 | Amount in Second Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBE2 | |
| 17 | DMBE3 | Amount in Third Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBE3 | |
| 18 | WRBTR | Amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WRBTR | |
| 19 | DIFHW | Amount Difference in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DIFHW | |
| 20 | DIFH2 | Amount Difference in Second Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DIFH2 | |
| 21 | DIFH3 | Amount Difference in Third Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DIFH3 | |
| 22 | DIFFW | Amount Difference in Foreign Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DIFFW | |
| 23 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | SKNTO | |
| 24 | SKNT2 | Cash Discount Amount in Second Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | SKNT2 | |
| 25 | SKNT3 | Cash Discount Amount in Third Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | SKNT3 | |
| 26 | WSKTO | Cash discount amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WSKTO | |
| 27 | BDIFF | Valuation Difference | decimal | 13 | 2 | CURR | ((0)) | Yes | | BDIFF | |
| 28 | BDIF2 | Valuation Difference for the Second Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | BDIF2 | |
| 29 | BDIF3 | Valuation Difference for the Third Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | BDIF3 | |
| 30 | RDIFF | Exchange Rate Gain/Loss Realized | decimal | 13 | 2 | CURR | ((0)) | Yes | | RDIFF | |
| 31 | RDIF2 | Exchange Rate Difference Realized for Second Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | RDIF2 | |
| 32 | RDIF3 | Exchange Rate Difference Realized for Third Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | RDIF3 | |
| 33 | KOART | Account Type | char | 1 | 0 | CHAR | (N' ') | Yes | | KOART | Allow NULL? |
| 34 | UMSKZ | Special G/L Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | * | UMSKZ | Allow NULL? |
| 35 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | UZAWE | Allow NULL? |
