Table SPAMOD1801
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SPAMOD1801 | SPM1801 | Spanish form 180 | Financials | KSP |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SPM1801 | CPY+FIY+PER+NUMDECL+NIFP | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BASE | Amount | DCB | 11.2 | |||||
| BUIBLO | Block | A | 3 | |||||
| BUICALNUM | Qualification code | A | 3 | |||||
| BUICODPOS | Zip code | A | 5 | |||||
| BUICODPRO | Province code | A | 2 | |||||
| BUICOM | Complementary field | A | 40 | |||||
| BUIESCA | Staircase | A | 3 | |||||
| BUILOC | Location | M | 12 | 3611 | ||||
| BUILOCNAM | Location | A | 30 | |||||
| BUIMUNI | City | A | 30 | |||||
| BUIMUNICOD | Code | A | 5 | |||||
| BUINUMCASA | Street number | A | 3 | |||||
| BUIPLAN | Floor | A | 3 | |||||
| BUIPORTAL | Portal | A | 3 | |||||
| BUIPUERTA | Door | A | 3 | |||||
| BUISTREET | Street | A | 50 | |||||
| BUITIPNUM | Type of location | A | 3 | |||||
| BUIVIA | Type | A | 5 | |||||
| CDRREF | Cadastre | A | 20 | |||||
| CODPROV | Province code | A | 2 | |||||
| CPY | Company | CPY | [CPY]CPY0=[SPM1801]CPY | Delete | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[SPM1801]CREUSR | Other | ||||
| EDEVENGO | Accrual FY | A | 4 | |||||
| FIY | Fiscal year | A | 4 | |||||
| MODALIDAD | Payment method | A | 1 | |||||
| NIFP | Tax identification | A | 9 | |||||
| NIFREP | Representative TIN | A | 9 | |||||
| NUMDECL | Declaration number | C | 4 | |||||
| PER | Period | A | 2 | |||||
| PORETENC | % | DCB | 2.2 | |||||
| PROVINCIA | Province | A | 2 | |||||
| RAZSOCP | Beneficiary | A | 30 | |||||
| RETENCION | Withholding | DCB | 11.2 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[SPM1801]UPDUSR | Other |