| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | CERDT | Certification Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | CERNO | Certification Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | AWTYP | Reference Transaction | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | AWSYS | Logical System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | AWKEY | Reference Key | nvarchar | 20 | 0 | | | | Allow NULL? |
| 7 | AWPOS | Reference line item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | FINSRC | Financing Source | nvarchar | 31 | 0 | | | | Allow NULL? |
| 9 | OPERA | Operation Identification | nvarchar | 24 | 0 | | | | Allow NULL? |
| 10 | GROSS | Gross Amount of Document Line | decimal | 15 | 2 | | | | |
| 11 | NET | Net amount of document line | decimal | 15 | 2 | | | | |
| 12 | DOCAMT | Eligible Amount of Document Line | decimal | 15 | 2 | | | | |
| 13 | PREV_S | Relevant Previously Certified Amount (Previous Runs) | decimal | 15 | 2 | | | | |
| 14 | PREV_T | Total Previously Certified Contribution (Previous Runs) | decimal | 15 | 2 | | | | |
| 15 | APP_AMT | Apportionment amount | decimal | 15 | 2 | | | | |
| 16 | CERTIF_SYS | System Proposal of Certified Amount | decimal | 15 | 2 | | | | |
| 17 | CERTIF | Certified Amount (User Input Field) | decimal | 15 | 2 | | | | |
| 18 | RUNAMT | Certified Contribution | decimal | 15 | 2 | | | | |
| 19 | PART_PAY | Partial payment | char | 1 | 0 | | | | Allow NULL? |
| 20 | CURR | Currency of the Financing Source | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | CCDAT | Currency Conversion Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | PAYDT | Payment Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | DOCGRP | Document Group | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | COMPL | Document Line Item Completely Certified | char | 1 | 0 | | | | Allow NULL? |
| 27 | FINALZ | Certification Finalized for Expenditure Documents | char | 1 | 0 | | | | Allow NULL? |
| 28 | SIMULATION | Flag for Simulation Run | char | 1 | 0 | | | | Allow NULL? |
| 29 | IGNORE_LINE | Ignore Line | char | 1 | 0 | | | | Allow NULL? |
| 30 | CHECKED_LINE | Line checked | char | 1 | 0 | | | | Allow NULL? |
| 31 | CORRECTION | Flag for Correction Run | char | 1 | 0 | | | | Allow NULL? |
| 32 | CORR_CERDT | Correction/corrected certification date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | CORR_CERNO | Correction/corrected certification number | nvarchar | 6 | 0 | | | | Allow NULL? |
