| 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 | SRCDOC_COMP | Source Item Sender Component | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | FARR_RAI_SRCCO | Allow NULL? |
| 3 | SRCDOC_LOGSYS | Logical System of the Source Item | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | FARR_RAI_SRCLS | Allow NULL? |
| 4 | SRCDOC_TYPE | Source Document Item Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | FARR_RAI_SRCTY | Allow NULL? |
| 5 | SRCDOC_ID | Source Item ID | nvarchar | 35 | 0 | CHAR | (N' ') | No | | FARR_RAI_SRCID | Allow NULL? |
| 6 | TIMESTAMP_UTC | Timestamp UTC for Revenue Accounting Item | decimal | 15 | 0 | DEC | ((0)) | No | | FARR_RAI_TMSTMP | |
| 7 | KEYPP | Subarea for Parallelization | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FARR_KEYPP | Allow NULL? |
| 8 | RAIC_TYPE | Revenue Accounting Item Class Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | FARR_RAIC_TYPE | Allow NULL? |
| 9 | RAIC | Revenue Accounting Item Class | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FARR_RAIC | Allow NULL? |
| 10 | STATUS | Status of Revenue Accounting Item | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_RAI_STATUS | Allow NULL? |
| 11 | CHHIST | History Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_CHHIST | Allow NULL? |
| 12 | HEADER_ID | Header ID of Source Document for Revenue Accouting Item | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | FARR_HEADER_ID | Allow NULL? |
| 13 | ITEM_ID | Item ID of Source Document for Revenue Accouting Item | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | FARR_ITEM_ID | Allow NULL? |
| 14 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 15 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BU_PARTNER | Allow NULL? |
| 16 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 17 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 18 | HWAER | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | HWAER | Allow NULL? |
| 19 | HWAE2 | Currency Key of Second Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | HWAE2 | Allow NULL? |
| 20 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | HWAE3 | Allow NULL? |
| 21 | QUANTITY | Quantity | decimal | 18 | 6 | QUAN | ((0)) | Yes | | FARR_QUANTITY | |
| 22 | QUANTITY_UNIT | Quantity Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | FARR_QUANTITY_UNIT | Allow NULL? |
| 23 | ORIGDOC_COMP | Original Item Sender Component | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | FARR_RAI_ORICO | Allow NULL? |
| 24 | ORIGDOC_LOGSYS | Logical System of the Original Item | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FARR_RAI_ORILS | Allow NULL? |
| 25 | ORIGDOC_TYPE | Original Item Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FARR_RAI_ORITY | Allow NULL? |
| 26 | ORIGDOC_ID | Original Item ID | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | FARR_RAI_ORIID | Allow NULL? |
| 27 | DUE_DATE | Invoice Due Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FARR_DUE_DATE | Allow NULL? |
| 28 | FINAL_INVOICE | Indicator for Final Invoice | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_FINAL_INVOICE | Allow NULL? |
| 29 | QUANTITY_REL | Quantity Relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_QUANTREL | Allow NULL? |
| 30 | POSTING_DATE | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 31 | REVERSAL | Reversal | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_REVERSAL | Allow NULL? |
| 32 | RAI_ERROR | Error During Revenue Accounting Item Creation | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_RAI_ERROR | Allow NULL? |
| 33 | INVOICE_TYPE | Invoice Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | FARR_INVOICE_TYPE | Allow NULL? |
| 34 | INITIAL_LOAD | Initial Load | char | 1 | 0 | CHAR | (N' ') | Yes | | FARR_INITIAL_LOAD | Allow NULL? |
| 35 | LOG_HANDLE | Application Log: Log Handle | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | BALLOGHNDL | Allow NULL? |
