Table SPRICLINK
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
SPRICLINK | SPK | Sales price list search | Sales |
Key | Description | Duplicates | Activity code |
---|---|---|---|
SPK0 | CLE | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AUUID | Single identifier | AUUID | ||||||
BETCPY | Intercompany | M | 4 | 1 | ||||
BETFCY | Intersites | M | 4 | 1 | ||||
BPCGRU | Group customer | BPC | [BPC]BPC0=[SPK]BPCGRU | Other | ||||
BPCINV | Bill-to customer | BPC | [BPC]BPC0=[SPK]BPCINV | Other | ||||
BPTNUM | Carrier | BPT | [BPT]BPT0=[SPK]BPTNUM | Other | ||||
CLCAMT1 | Tax calculation basis 1 | MD1 | ||||||
CLCAMT2 | Tax calculation basis 2 | MD1 | ||||||
CLE | Key | A | 3 | |||||
CPY | Sales company | CPY | [CPY]CPY0=[SPK]CPY | Other | ||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | User | AUS | [AUS]CODUSR=[SPK]CREUSR | Other | ||||
CRY | Country | CRY | [TCY]TCY0=[SPK]CRY | Other | ||||
CSTTYP | Cost type | M | 15 | 219 | ||||
CUSORDREF | Customer order ref | A | 20 | |||||
ECCVALMAJ | Major version | ECS | ECC | |||||
ECCVALMIN | Minor version | EVL | ECC | |||||
EECICT | Incoterm | ICT | [ICTH]ICT0=[SPK]EECICT | Other | ||||
FOCITM | Free product | M | 4 | 1 | ||||
LINTYP | Line type | M | 20 | 423 | ||||
LINTYP_A | Line category | M | 30 | 469 | ||||
LINTYP_B | Product cat. | M | 30 | 470 | ||||
LINTYP_C | Component C. | M | 30 | 471 | ||||
MDL | Delivery mode | MDL | [TMD]TMD0=[SPK]MDL | Other | ||||
PCK | Packaging | PCK | [TPA]TPA0=[SPK]PCK | Other | ||||
PJT | Project | PJT | [PIM]PIM0=[SPK]PJT | Block | ||||
PJTNUM | Project number | PJT | [PIM]PIM0=[SPK]PJTNUM | Block | ||||
PLIBPRCNR | BP concerns | M | 15 | 2210 | ||||
PNTITMREF | Parent product | ITS | [ITS]ITS0=PNTITMREF | RTZ | ||||
PTE | Payment term | PTE | [TPT]TPT0=PTE;[V]GCURLEG;1 | Other | ||||
SALFCY | Sales site | FCY | [FCY]FCY0=[SPK]SALFCY | Other | ||||
SAT | Subdivision | SAT | ||||||
SOHTYP | Order type | TSO | [TSO]TSO0=SOHTYP;[V]GSUPCLE | Other | ||||
STOFCY | Shipment site | FCY | [FCY]FCY0=[SPK]STOFCY | Other | ||||
TSCCOD | Statistical group | ADI | [ADI]CODE=indice+30;TSCCOD(indice) | Other | STC | |||
TSICOD | Statistical group | ADI | [ADI]CODE=indice+20;TSICOD(indice) | Other | STI | |||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[SPK]UPDUSR | Other | ||||
USEPLC | Location reference | A | 30 | |||||
VACBPR | Tax rule | TVB | [TVB]TVB0=VACBPR;[V]GSUPCLE | Other |