Table GRANTS
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
GRANTS | GRT | Subsidies | Fixed Assets | GRT |
Key | Description | Duplicates | Activity code |
---|---|---|---|
GRT0 | GRAREF | No | |
GRT1 | CPY+GRAREF | No | |
GRT2 | CPY+FCY+GRAREF | No | |
GRT3 | CPY+FCY+INVPLN | Yes |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACCCOD | Accounting code | CAC | [CAC]CAC0=[V]GVML_COGSUBV;ACCCOD;[V]GSUPCLE | Block | ||||
APPROVDAT | Agreement date | D4 | ||||||
AUUID | Single identifier | AUUID | ||||||
CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
CPY | Company | CPY | [CPY]CPY0=[GRT]CPY | Delete | ||||
CRBGRAAMT | Reintegrtd amount | MD1 | ||||||
CRBGRACUM | Reintegration total | MD1 | ||||||
CREDAT | Date created | D4 | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
CUR | Currency | CUR | [TCU]TCU0=[GRT]CUR | Block | ||||
DES | Description | DCO | ||||||
DES2 | Description 2 | DCO | ||||||
DIE | Dimension type code | DIE | [DIE]DIE0=[GRT]DIE | Block | ANA | |||
DSP | Distribution | DSP | [DSP]DSP0=DSP;1 | Block | ||||
EXPNUM | Export number | L | 8 | |||||
FCY | Site | FCY | [FCY]FCY0=[GRT]FCY | Block | ||||
GRAAMT | Subsidy amount | MD1 | ||||||
GRAFLGFRC | Subsidy amt forcing flag | M | 4 | 1 | ||||
GRAORG | Organization | ADI | [ADI]CODE=617;GRAORG | Block | ||||
GRAREF | Subsidy reference | GRT | ||||||
GRASTA | Status | MM | 1 | 3225 | ||||
GRATYP | Subsidy type | MM | 25 | 3181 | ||||
INVFLGFRC | Capt forcing amount flag | M | 4 | 1 | ||||
INVGRAAMT | FA subsidy amt | MD1 | ||||||
INVGRARAT | Subsidised inv % | RAT | ||||||
INVPLN | Invest project | ADI | [ADI]CODE=614;INVPLN | Block | ||||
MAXGRAAMT | Subsidy cap | MD1 | ||||||
REAFLGFRC | Act forcing amt flag | M | 4 | 1 | ||||
REAGRAAMT | Act investment amt | MD1 | ||||||
REFTAB1 | Reference FF1 | C | 4 | |||||
REFTAB10 | Reference FF10 | C | 4 | |||||
REFTAB2 | Reference FF2 | C | 4 | |||||
REFTAB3 | Reference FF3 | C | 4 | |||||
REFTAB4 | Reference FF4 | C | 4 | |||||
REFTAB5 | Reference FF5 | C | 4 | |||||
REFTAB6 | Reference FF6 | C | 4 | |||||
REFTAB7 | Reference FF7 | C | 4 | |||||
REFTAB8 | Reference FF8 | C | 4 | |||||
REFTAB9 | Reference FF9 | C | 4 | |||||
TOBERECAMT | Subs amt to be received | MD1 | ||||||
UPDDAT | Change date | D4 | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | A | 5 | |||||
USRFLDA1 | Free field 1 | ADI | [ADI]CODE=REFTAB1;USRFLDA1 | Block | ||||
USRFLDA10 | Free field 10 | ADI | [ADI]CODE=REFTAB10;USRFLDA10 | Block | ||||
USRFLDA2 | Free field 2 | ADI | [ADI]CODE=REFTAB2;USRFLDA2 | Block | ||||
USRFLDA3 | Free field 3 | ADI | [ADI]CODE=REFTAB3;USRFLDA3 | Block | ||||
USRFLDA4 | Free field 4 | ADI | [ADI]CODE=REFTAB4;USRFLDA4 | Block | ||||
USRFLDA5 | Free field 5 | ADI | [ADI]CODE=REFTAB5;USRFLDA5 | Block | ||||
USRFLDA6 | Free field 6 | ADI | [ADI]CODE=REFTAB6;USRFLDA6 | Block | ||||
USRFLDA7 | Free field 7 | ADI | [ADI]CODE=REFTAB7;USRFLDA7 | Block | ||||
USRFLDA8 | Free field 8 | ADI | [ADI]CODE=REFTAB8;USRFLDA8 | Block | ||||
USRFLDA9 | Free field 9 | ADI | [ADI]CODE=REFTAB9;USRFLDA9 | Block | ||||
USRFLDC1 | Free field 1 coef | COE | ||||||
USRFLDC2 | Fr field coeff 2 | COE | ||||||
USRFLDD1 | Free field date 1 | D4 | ||||||
USRFLDD2 | Free field date 2 | D4 | ||||||
USRFLDD3 | Free field date 3 | D4 | ||||||
USRFLDD4 | Free field date 4 | D4 | ||||||
USRFLDM1 | Free field amount 1 | MD1 | ||||||
USRFLDM2 | Free field amount 2 | MD1 | ||||||
USRFLDM3 | Free field amount 3 | MD1 | ||||||
USRFLDM4 | Free field amount 4 | MD1 | ||||||
USRFLDM5 | Free field amount 5 | MD1 | ||||||
USRFLDM6 | Free field 6 amount | MD1 |