| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | NDJAR | Planned useful life in years | nvarchar | 3 | 0 | NUMC | (N'000') | No | | NDJAR | Allow NULL? |
| 2 | PROZ_TW | FI-AA: % rate for Japan net asset valuation (book value) | decimal | 4 | 3 | DEC | ((0)) | Yes | | AA_PROZJP1 | |
| 3 | PROZ_SLM | FI-AA: % rate for Japan net asset valuation (book value) | decimal | 4 | 3 | DEC | ((0)) | Yes | | AA_PROZJP4 | |
| 4 | PROZ_BW1 | FI-AA: % rate for val. of net assets Japan (theor.value 1yr) | decimal | 4 | 3 | DEC | ((0)) | Yes | | AA_PROZJP2 | |
| 5 | PROZ_BW2 | FI-AA: % rate for val. of net assets Japan (theor.val.>1yr) | decimal | 4 | 3 | DEC | ((0)) | Yes | | AA_PROZJP3 | |
| 6 | PROZ_SL2 | FI-AA: Percentage for Net Worth Valuation Japan (from 2007) | decimal | 4 | 3 | DEC | ((0)) | Yes | | AA_PROZJP5 | |
| 7 | PROZ_TW2 | FI-AA: Percentage for Net Worth Valuation Japan (from 2007) | decimal | 4 | 3 | DEC | ((0)) | Yes | | AA_PROZJP6 | |
| 8 | PROZ_REV | FI-AA: % Revised ab 2007 | decimal | 4 | 3 | DEC | ((0)) | Yes | | AA_PROZJP7 | |
| 9 | PROZ_GR | FI-AA: % rate for Japan net asset valuation (book value) | decimal | 6 | 5 | DEC | ((0)) | Yes | | AA_PROZJP8 | |
| 10 | PROZ_TW3 | Declined Balance Method Rate for 200% DBM | decimal | 6 | 5 | DEC | ((0)) | Yes | | AA_PROZJP9 | |
| 11 | PROZ_REV3 | Revised Depreciation Rate for 200% DBM | decimal | 6 | 5 | DEC | ((0)) | Yes | | AA_PROZJP10 | |
| 12 | PROZ_GR3 | Guarantee Rate for 200% DBM | decimal | 6 | 5 | DEC | ((0)) | Yes | | AA_PROZJP11 | |
