| 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 | | J_3RF_BELNR_D | Allow NULL? |
| 4 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 5 | XBLNR | Reference document number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | J_3RF_XBLNR | Allow NULL? |
| 6 | BLDAT | Document date in document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RF_BLDAT | Allow NULL? |
| 7 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 8 | LIFNR | Account number of the vendor or creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | J_3RF_LIFNR | Allow NULL? |
| 9 | NAME1 | Name 1 | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | NAME1_GP | Allow NULL? |
| 10 | DMBTR | Amount in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBTR | |
| 11 | DMBTR_WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 12 | WRBTR | Amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WRBTR | |
| 13 | WRBTR_WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 14 | FLG_BELNR_ALL | DE For state of Invoice document | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RF_IBOOK_F_ALL | Allow NULL? |
| 15 | KURSF | Exchange rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURSF | |
| 16 | BLDAT_REV | Reversal date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RF_BLDAT_REV | Allow NULL? |
| 17 | BLDAT_REV_DOC | Document date of reversed document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RF_BLDAT_REV_DOC | Allow NULL? |
| 18 | BUDAT_REV_DOC | Posting date of reversed document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RF_BUDAT_REV_DOC | Allow NULL? |
| 19 | BELNR_REV_DOC | System number of reversed document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | J_3RF_BELNR_REV_DOC | Allow NULL? |
| 20 | BLART_REV_DOC | Type of the reversed document | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | J_3RF_BLART_REV_DOC | Allow NULL? |
| 21 | XBLNR_REV_DOC | External number reversed document | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | J_3RF_XBLNR_REV_DOC | Allow NULL? |
| 22 | STGRD_REV_DOC | Reversal reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | J_3RF_STGRD_REV_DOC | Allow NULL? |
