| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | FIKRS | Financial Management Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | FINUSE | Application of Secondary Source Funds | nvarchar | 16 | 0 | | | | Allow NULL? |
| 4 | DATAB | FM: Valid from date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | DATBIS | FM: Valid to date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | ERFNAME | FIFM: Created by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | ERFDAT | FIFM: Entry Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | AENNAME | FIFM: Name of Last Person to Make a Change | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | AENDAT | FIFM: Changed on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | DEPT_REG | Treasury Account Symbol - Department Regular | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | DEPT_TRAN | Treasury Account Symbol - Department Transfer | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | FISCAL_YR | Not More Closely Defined Area, Possibly Used for Patchlevels | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | MAIN_ACCT | Treasury Account Symbol - Main Account | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | SUB_ACCT | Treasury Account Symbol - Subaccount | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | SPLIT_NUM | Treasury Account Symbol - account split sequence number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | FACTSII_REL | Relevant for FACTS II | char | 1 | 0 | | | | Allow NULL? |
| 17 | PREPARERID | Preparer ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | CERTIFIERID | Certifier ID | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | GTAS_REL | GTAS Relevant Indicator | char | 1 | 0 | | | | Allow NULL? |
| 20 | SUBLEVL | Sublevel Prefix (SP) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 21 | AGENCID | Agency Identifier (AID) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | ALTRAID | Allocation Transfer Agency Identifier (ATA) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | BEGPER | Beginning Period of Availability (BPOA) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | ENDPER | Ending Period of Availability (EPOA) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | AVTYPE | Availability Type Code (A) | char | 1 | 0 | | | | Allow NULL? |
