Table SFOOTINV
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SFOOTINV | SFI | Invoicing elements | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SFI0 | SFINUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCCOD | Accounting code | CAC | [CAC]CAC0=11;ACCCOD;[V]GSUPCLE | Block | ||||
| ACTCLCBAS | Action calcul. | A | 10 | |||||
| AMTCOD | Amount code | M | 10 | 269 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BPCORI | Original customer | M | 15 | 2218 | ||||
| BRDRUL | Split rule | 8 | M | 15 | 473 | |||
| CCE | Dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CLCBAS | Calculation basis | M | 15 | 2219 | ||||
| CLCDEB | Intrastat taken into account | M | 18 | 2208 | DEB | |||
| CLCORD | Calculation order | C | 2 | |||||
| CLCVACITM | Tax level selection | TVI | [TVI]TVI0=CLCVACITM;[V]GSUPCLE | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CUR | Currency | CUR | [TCU]TCU0=[SFI]CUR | Block | ||||
| DACBPC | Customer entry | C | 2 | |||||
| DACDLV | Delivery entry | C | 2 | |||||
| DACINV | Invoice entry | C | 2 | |||||
| DACORD | Order entry | C | 2 | |||||
| DEFVAL | Default value | DCB | 11.4 | |||||
| DEPFLG | Subject to discount | M | 4 | 1 | ||||
| DESAXX | Description | AX2 | ||||||
| DESVCR | Destination document | 8 | M | 15 | 476 | |||
| DIE | Dimension type code | DIE | [DIE]DIE0=[SFI]DIE | Block | ANA | |||
| DSP | Distribution | DSP | [DSP]DSP0=DSP;1 | Block | ||||
| DSPLIN | Distribution | M | 15 | 475 | ||||
| EXCTAXRUL | Special levy basis | M | 4 | 1 | ||||
| EXPNUM | Export number | L | 8 | |||||
| GRUFLG | Grouping | 8 | M | 15 | 474 | |||
| GRURUL | Grouping rule | 8 | M | 15 | 472 | |||
| INCDCR | Increase/Decrease | M | 10 | 254 | ||||
| INVFOOBRD | Split no. | SFI | [SFI]SFI0=[SFI]INVFOOBRD | Other | ||||
| INVFOOGRU | Grouping no. | SFI | [SFI]SFI0=[SFI]INVFOOGRU | Other | ||||
| ITMREF | Product | ITM | [ITM]ITM0=[SFI]ITMREF | Block | ||||
| LANDESSHO | Descriptions | A | 50 | |||||
| MISRULSTD | Sundry std rule | M | 15 | 463 | ||||
| MISRULUSR | User rule | M | 15 | 464 | ||||
| ORIVCR | Source document | 8 | M | 15 | 476 | |||
| PRGCLCBAS | Program calcul. | A | 10 | |||||
| PROCOD | Processing mode | M | 15 | 271 | ||||
| SFINUM | Invoicing element | SFI | [SFI]SFI0=[SFI]SFINUM | Other | ||||
| SFINUMCAR | Alpha no. | A | 3 | |||||
| SHOAXX | Short description | AX1 | ||||||
| SPETAXRUL | Special tax basis | M | 4 | 1 | ||||
| SSTCOD | SST tax code | ADI | [ADI]CODE=203;SSTCOD | Block | LTA | |||
| TRFDLY | Include in ord-deliv | M | 8 | 442 | ||||
| TRFINV | Include in ord-inv | M | 8 | 442 | ||||
| TSDMAX | Maximum threshold | MD1 | ||||||
| TSDMIN | Minimum threshold | MD1 | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VACITM | Element tax level | TVI | [TVI]TVI0=VACITM;[V]GSUPCLE | Block | ||||
| VALTYP | Value type | M | 6 | 2227 | ||||
| VATRUL | Tax rule | M | 10 | 283 |