| 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 | Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | J_3RFTG_DOCJR_YEAR | Allow NULL? |
| 4 | NUM | Electronic Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | J_3RFTG_NUM | Allow NULL? |
| 5 | EXT_NUM | External Document Number | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | J_3RF_EXT_NUMBER | Allow NULL? |
| 6 | SRC_TYPE | Type of Source Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | J_3RF_DI_SOURCEDOC_TYP | Allow NULL? |
| 7 | VBELN_DLV | Delivery | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN_VL | Allow NULL? |
| 8 | VBELN_BDOC | Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN_VF | Allow NULL? |
| 9 | BELNR_FI | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | J_3RFTG_FI_DOC_NUM | Allow NULL? |
| 10 | GJAHR_FI | Accounting Document Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | J_3RFTG_DOCFI_YEAR | Allow NULL? |
| 11 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 12 | DATE_SEND | Send Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RFTG_SEND | Allow NULL? |
| 13 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 14 | PART_NAME | Partner Name | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | J_3RFINV_NAME | Allow NULL? |
| 15 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 16 | FWBTR | Gross Amount in Document Currency | decimal | 17 | 2 | DEC | ((0)) | Yes | | J_3RFTG_FWBTR | |
| 17 | FWSTE | Tax Amount in Document Currency | decimal | 17 | 2 | DEC | ((0)) | Yes | | J_3RFTG_FWSTE | |
| 18 | INN | Partner INN | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | J_3RFTG_INN | Allow NULL? |
| 19 | KPP | Partner KPP (Torg Electronic Documents) | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | J_3RFTG_KPP | Allow NULL? |
| 20 | DOC_STATUS | Document Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | J_3RFTG_DOC_STATUS | Allow NULL? |
| 21 | ATTACHMENTS | Flag: Entry Has Attachments | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3RFTG_ATTACHMENT | Allow NULL? |
| 22 | TORG2_STATUS | TORG-2 Document Status | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | J_3RF_TGXML_TORG2_STATUS | Allow NULL? |
| 23 | CRNAM | Creator Name (Torg Electronic Documents) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | J_3RFTG_CRNAME | Allow NULL? |
| 24 | CRDATE | Document Creation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RFTG_DOC_CR_DATE | Allow NULL? |
| 25 | CRTIME | Document Creation Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | J_3RFTG_DOC_CR_TIME | Allow NULL? |
| 26 | CHNAM | Name of Person Who Changed the Document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | J_3RFTG_CHNAME | Allow NULL? |
| 27 | CHDATE | Date When Document Was Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_3RFTG_DOC_CH_DATE | Allow NULL? |
| 28 | CHTIME | Time When Document Was Changed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | J_3RFTG_DOC_CH_TIME | Allow NULL? |
| 29 | PARNR | Message partner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | NA_PARNR | Allow NULL? |
| 30 | PARVW | Partner function (for example SH for ship-to party) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SNA_PARVW | Allow NULL? |
