| 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 | ITCLG | Consolidation chart of accounts | nvarchar | 2 | 0 | CHAR | (N' ') | No | TF120 | FC_ITCLG | Allow NULL? |
| 3 | COIAC | Activity: Push-down Goodwill Posted Data | nvarchar | 2 | 0 | CHAR | (N' ') | No | | FC_COIACPUAP | Allow NULL? |
| 4 | PUARESI | Push-down Goodwill Reserves: FS Item | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_PUARESI | Allow NULL? |
| 5 | PUAREST | Push-down Goodwill Reserves: Subitem Category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_PUAREST | Allow NULL? |
| 6 | PUARESS | Push-down Goodwill Reserves: Subitem | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_PUARESS | Allow NULL? |
| 7 | GWAAMDI | Item for the amortization of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_GWAAMDI | Allow NULL? |
| 8 | GWAAMDT | Subitem category for the amortization of goodwill | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_GWAAMDT | Allow NULL? |
| 9 | GWAAMDS | Subitem for the amortization of goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_GWAAMDS | Allow NULL? |
| 10 | NGAAMDI | Item for the amortization of negative goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_NGAAMDI | Allow NULL? |
| 11 | NGAAMDT | Subitem category for amortization of negative goodwill | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_NGAAMDT | Allow NULL? |
| 12 | NGAAMDS | Subitem for the amortization of negative goodwill | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_NGAAMDS | Allow NULL? |