| 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 | RPLAN | Reorganization Plan | nvarchar | 10 | 0 | CHAR | (N' ') | No | FAGL_R_PL | FAGL_R_PLAN | Allow NULL? |
| 3 | KOART | Account Type | char | 1 | 0 | CHAR | (N' ') | No | | KOART | Allow NULL? |
| 4 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 5 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 6 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | BELNR_D | Allow NULL? |
| 7 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BUZEI | Allow NULL? |
| 8 | OBJ_TYPE_SUP | Object Type of the Higher-Level Object | nvarchar | 4 | 0 | CHAR | (N' ') | No | | FAGL_R_OBJ_TYPE_SUP | Allow NULL? |
| 9 | VAL1_SUP | Value of the First Key Field for the Higher-Level Object | nvarchar | 40 | 0 | CHAR | (N' ') | No | | FAGL_R_OBJ_VAL1_SUP | Allow NULL? |
| 10 | VAL2_SUP | Value of the Second Key Field for the Higher-Level Object | nvarchar | 20 | 0 | CHAR | (N' ') | No | | FAGL_R_OBJ_VAL2_SUP | Allow NULL? |
| 11 | VAL3_SUP | Value of the Third Key Field for the Higher-Level Object | nvarchar | 20 | 0 | CHAR | (N' ') | No | | FAGL_R_OBJ_VAL3_SUP | Allow NULL? |
| 12 | SEQNR | Sequence Number | nvarchar | 7 | 0 | NUMC | (N'0000000') | No | | FAGL_R_SEQNR_APAR | Allow NULL? |
| 13 | MDATTR_OLD | Old Master Data Attribute | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | FAGL_R_MDATTR_OLD | Allow NULL? |
| 14 | MDATTR_NEW | New Master Data Attribute | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | FAGL_R_MDATTR_NEW | Allow NULL? |
| 15 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 16 | PPRCTR | Partner Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PPRCTR | Allow NULL? |
| 17 | SEGMENT | Segment for Segmental Reporting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FB_SEGMENT | Allow NULL? |
| 18 | PSEGMENT | Partner Segment for Segmental Reporting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FB_PSEGMENT | Allow NULL? |
| 19 | SEGMENT_NEW | Segment for Segmental Reporting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FB_SEGMENT | Allow NULL? |
| 20 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 21 | BSTAT | Document Status | char | 1 | 0 | CHAR | (N' ') | Yes | | BSTAT_D | Allow NULL? |
| 22 | UMSKS | Special G/L Transaction Type | char | 1 | 0 | CHAR | (N' ') | Yes | | UMSKS | Allow NULL? |
| 23 | HKONT | General Ledger Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HKONT | Allow NULL? |
| 24 | VBUND | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | RASSC | Allow NULL? |
| 25 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 26 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CPUDT | Allow NULL? |
| 27 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REBZG | Allow NULL? |
| 28 | REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | REBZJ | Allow NULL? |
| 29 | REBZZ | Line Item in the Relevant Invoice | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | REBZZ | Allow NULL? |
| 30 | REBZT | Follow-On Document Type | char | 1 | 0 | CHAR | (N' ') | Yes | | REBZT | Allow NULL? |
| 31 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LIFNR | Allow NULL? |
| 32 | KUNNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNNR | Allow NULL? |
| 33 | WRBTR_BUZEI | Amount of Entire Line Item in Document Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | FAGL_R_DOCLN_WRBTR | |
| 34 | WAERS_BUZEI | Currency Key for Entire Line Item | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FAGL_R_DOCLN_WAERS | Allow NULL? |
| 35 | DMBTR_BUZEI | Amount of Entire Line Item in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | FAGL_R_DOCLN_DMBTR | |
| 36 | LDGRP | Ledger Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FAGL_LDGRP | Allow NULL? |
| 37 | BWBER | Valuation Area for FI Year-End Closing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BWBER | Allow NULL? |
| 38 | GEN_TIM | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 39 | GRP | Grouping for Entries Belonging Together (All Levels) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | FAGL_R_GRP | Allow NULL? |
| 40 | XDEL | Entry Was Deleted | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XDELETED | Allow NULL? |
| 41 | XCLEARED | Receivable or Payable Is Cleared | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_APAR_XCLEARED | Allow NULL? |
| 42 | STATUS | Object Status | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FAGL_R_OBJ_STATUS | Allow NULL? |
| 43 | XLEVEL1 | Object Was Artificially Made into First-Level Object | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XLEVEL1 | Allow NULL? |
| 44 | XHAS_SKV | Whether it has Cash Discount Clearing Line | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XHAS_SKV | Allow NULL? |
| 45 | XSKV | Cash Discount Clearing Item | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XSKV | Allow NULL? |
| 46 | XFC_VAL | Foreign Currency Valuation Balance | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_R_XFC_VAL | Allow NULL? |
