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 |