| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | FIN_TECHDOCNO | Technical Identifier of a Document | nvarchar | 22 | 0 | CHAR | (N' ') | No | | FIN_TECHDOCNO | Allow NULL? |
| 3 | FIN_ITEMNO | Line Item Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | FIN_ITEMNO | Allow NULL? |
| 4 | FIN_GLITEMNO | Item Number of General Ledger Document | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | FIN_GLITEMNO | Allow NULL? |
| 5 | FIN_DRCRIND | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FIN_DRCRIND | Allow NULL? |
| 6 | FIN_GLACCT | G/L Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FIN_GLACCT | Allow NULL? |
| 7 | FIN_GLIND | Relevant for General Ledger | char | 1 | 0 | CHAR | (N' ') | Yes | | FIN_GLIND | Allow NULL? |
| 8 | FIN_ITEMTEXT | Document Item Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | FIN_ITEMTEXT | Allow NULL? |
| 9 | FIN_SEGMENT | Segment | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | FIN_SEGMENT | Allow NULL? |
| 10 | FIN_PROFITCTR | Profit Center | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | FIN_PROFITCTR | Allow NULL? |
| 11 | FIN_FUNCAREA | Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FIN_FUNCAREA | Allow NULL? |
| 12 | FIN_SEGMENT_P | Partner Segment | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | FIN_SEGMENT_P | Allow NULL? |
| 13 | FIN_PROFITCTR_P | Partner Profit Center | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | FIN_PROFITCTR_P | Allow NULL? |
| 14 | FIN_FUNCAREA_P | Partner Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FIN_FUNCAREA_P | Allow NULL? |
| 15 | FIN_AMTTRA | Amount in Transaction Currency | decimal | 23 | 2 | CURR | ((0)) | Yes | | FIN_AMTTRA | |
| 16 | FIN_CURRTRA | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FIN_CURRTRA | Allow NULL? |
| 17 | FIN_AMTCOMP | Amount in Local Currency | decimal | 23 | 2 | CURR | ((0)) | Yes | | FIN_AMTCOMP | |
| 18 | FIN_CURRCOMP | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FIN_CURRCOMP | Allow NULL? |
| 19 | FIN_AMTACCSYS | Amount in Accounting System Currency | decimal | 23 | 2 | CURR | ((0)) | Yes | | FIN_AMTACCSYS | |
| 20 | FIN_CURRACCSYS | Accounting System Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FIN_CURRACCSYS | Allow NULL? |
| 21 | FIN_AMTHARD | Amount in Hard Currency | decimal | 23 | 2 | CURR | ((0)) | Yes | | FIN_AMTHARD | |
| 22 | FIN_CURRHARD | Hard Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FIN_CURRHARD | Allow NULL? |
| 23 | FIN_AMTINDEX | Amount in Index-Based Currency | decimal | 23 | 2 | CURR | ((0)) | Yes | | FIN_AMTINDEX | |
| 24 | FIN_CURRINDEX | Index-Based Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FIN_CURRINDEX | Allow NULL? |
| 25 | FIN_AMTCOMPGLOB | Amount in Global Company Currency | decimal | 23 | 2 | CURR | ((0)) | Yes | | FIN_AMTCOMPGLOB | |
| 26 | FIN_CURRCOMPGLOB | Global Company Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | FIN_CURRCOMPGLOB | Allow NULL? |
| 27 | FIN_EEW_AMTAMT | Extension Include for Additional Currencies | char | 1 | 0 | CHAR | (N' ') | Yes | | FIN_EEW_AMT | Allow NULL? |
| 28 | FIN_QTYGL | Quantity in General Ledger | decimal | 23 | 3 | QUAN | ((0)) | Yes | | FIN_QTYGL | |
| 29 | FIN_UOMGL | Unit of Measure for General Ledger | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | FIN_UOMGL | Allow NULL? |
| 30 | FIN_ITEMSIGN | +/- Sign for a Line Item | char | 1 | 0 | CHAR | (N' ') | Yes | | FIN_ITEMSIGN | Allow NULL? |
| 31 | FIN_POSTYPE | Item Category | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | FIN_POSTYPE | Allow NULL? |
| 32 | FIN_JOURNAL | Journal | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | FIN_JOURNAL | Allow NULL? |
| 33 | FIN_GLTRATYPE | Transaction Type for General Ledger | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | FIN_GLTRATYPE | Allow NULL? |
| 34 | FIN_EEW_ACIT | Extension Point for Item of ACC Document | char | 1 | 0 | CHAR | (N' ') | Yes | | FIN_EEW_ACIT | Allow NULL? |
| 35 | FOBJ_TYPE_NAME | Name of an Object Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FOBJ_TYPE_NAME | Allow NULL? |
| 36 | FOBJ_OBJECT_ID | Object ID | varbinary | 16 | 0 | RAW | | Yes | | FOBJ_OBJECT_ID | |
| 37 | FOBJ_TYPE_NAME_P | Name of Partner Object Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FOBJ_TYPE_NAME_P | Allow NULL? |
| 38 | FOBJ_OBJECT_ID_P | Partner Object ID | varbinary | 16 | 0 | RAW | | Yes | | FOBJ_OBJECT_ID_P | |
| 39 | FIN_QTYREF | Quantity in Reference Unit of Measure | decimal | 23 | 3 | QUAN | ((0)) | Yes | | FIN_QTYREF | |
| 40 | FIN_UOMREF | Reference Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | FIN_UOMREF | Allow NULL? |
| 41 | FIN_QTYVAL | Valuation Quantity | decimal | 23 | 3 | QUAN | ((0)) | Yes | | FIN_QTYVAL | |
| 42 | FIN_UOMVAL | Valuation Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | FIN_UOMVAL | Allow NULL? |
| 43 | FIN_LOCATION | Location | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | FIN_LOCATION | Allow NULL? |
| 44 | FIN_CHARGEIND | Charge Indicator for Assets Accounts | char | 1 | 0 | CHAR | (N' ') | Yes | | FIN_CHARGEIND | Allow NULL? |
| 45 | FIN_EEW_ACITINV | Extension Point for LI in Material Inventory Journal | char | 1 | 0 | CHAR | (N' ') | Yes | | FIN_EEW_ACITINV | Allow NULL? |
| 46 | FIN_EEW_ACITINVR | Extension Point for Reporting in Material Inventory Journal | char | 1 | 0 | CHAR | (N' ') | Yes | | FIN_EEW_ACITINVR | Allow NULL? |
