| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | RCLNT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | GL_SIRID | Record number of the line item record | nvarchar | 18 | 0 | CHAR | (N' ') | No | | GU_RECID | Allow NULL? |
| 3 | RLDNR | Ledger | nvarchar | 2 | 0 | CHAR | (N' ') | No | T881 | RLDNR | Allow NULL? |
| 4 | RRCTY | Record Type | char | 1 | 0 | CHAR | (N' ') | No | | RRCTY | Allow NULL? |
| 5 | RVERS | Version | nvarchar | 3 | 0 | CHAR | (N' ') | No | T894 | RVERS | Allow NULL? |
| 6 | RYEAR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 7 | RTCUR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | RTCUR | Allow NULL? |
| 8 | DRCRK | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | No | | SHKZG | Allow NULL? |
| 9 | POPER | Posting period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | POPER | Allow NULL? |
| 10 | DOCCT | Document Type | char | 1 | 0 | CHAR | (N' ') | No | | DOCCT | Allow NULL? |
| 11 | DOCNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | BELNR_D | Allow NULL? |
| 12 | DOCLN | Six-Character Posting Item for Ledger | nvarchar | 6 | 0 | CHAR | (N' ') | No | | DOCLN6 | Allow NULL? |
| 13 | RCOMP | Company | nvarchar | 6 | 0 | CHAR | (N' ') | No | T880 | RCOMP_D | Allow NULL? |
| 14 | SEQNR | Segment number within a cycle | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | SQNR | Allow NULL? |
| 15 | ROBUKRS | Original company code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | OBUKR | Allow NULL? |
| 16 | RACCT | Group Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | BILKT | Allow NULL? |
| 17 | RASSC | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | No | * | RASSC | Allow NULL? |
| 18 | LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | No | TBDLS | LOGSYS | Allow NULL? |
| 19 | RTYPE | Record Type | char | 1 | 0 | CHAR | (N' ') | No | | FB_ICRC_RTYPE | Allow NULL? |
| 20 | TSL | Value in Transaction Currency | decimal | 17 | 2 | CURR | ((0)) | No | | VTCUR9 | |
| 21 | SGTXT | Item Text | nvarchar | 50 | 0 | CHAR | (N' ') | No | | SGTXT | Allow NULL? |
| 22 | DOCTY | FI-SL Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | T889 | DOCTY | Allow NULL? |
| 23 | ACTIV | Business Transaction | nvarchar | 4 | 0 | CHAR | (N' ') | No | | GLVOR | Allow NULL? |
| 24 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BUDAT | Allow NULL? |
| 25 | WSDAT | Value Date for Currency Translation | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | WSDAT | Allow NULL? |
| 26 | REFDOCNR | Reference document number of an accounting document | nvarchar | 10 | 0 | CHAR | (N' ') | No | | REFBELNR | Allow NULL? |
| 27 | REFRYEAR | Reference fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | REFGJAHR | Allow NULL? |
| 28 | REFDOCLN | Six-digit number of the reference posting line | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | REFBUZEI6 | Allow NULL? |
| 29 | REFDOCCT | Reference document category | char | 1 | 0 | CHAR | (N' ') | No | | REFDOCCT | Allow NULL? |
| 30 | REFACTIV | FI-SL Business Reference Transaction | nvarchar | 4 | 0 | CHAR | (N' ') | No | | REFGLVOR | Allow NULL? |
| 31 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | CPUDT | Allow NULL? |
| 32 | CPUTM | Time of Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | CPUTM | Allow NULL? |
| 33 | USNAM | User name | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | USNAM | Allow NULL? |
| 34 | AWTYP | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | No | TTYP | AWTYP | Allow NULL? |
| 35 | AWORG | Reference Organizational Units | nvarchar | 10 | 0 | CHAR | (N' ') | No | | AWORG | Allow NULL? |
| 36 | DOCDT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BLDAT | Allow NULL? |
| 37 | REFNR | Reference Number | nvarchar | 30 | 0 | CHAR | (N' ') | No | | FB_ICRC_REFNR | Allow NULL? |
| 38 | GRREF | Document Group Number | nvarchar | 18 | 0 | CHAR | (N' ') | No | | FB_ICRC_GROUPREF | Allow NULL? |
| 39 | PSTAT | Processing Status | nvarchar | 3 | 0 | NUMC | (N'000') | No | | FB_ICRC_PSTAT | Allow NULL? |
| 40 | CSTAT | Communication Status | nvarchar | 3 | 0 | NUMC | (N'000') | No | | FB_ICRC_CSTAT | Allow NULL? |
| 41 | OSIRID | Record number of the line item record | nvarchar | 18 | 0 | CHAR | (N' ') | No | | GU_RECID | Allow NULL? |
| 42 | FAGL_RCLNT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | Yes | * | MANDT | Allow NULL? |
| 43 | FAGL_RYEAR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 44 | FAGL_DOCNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 45 | FAGL_RLDNR | Ledger | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | RLDNR | Allow NULL? |
| 46 | FAGL_RBUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 47 | FAGL_DOCLN | Six-Character Posting Item for Ledger | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | DOCLN6 | Allow NULL? |
