Table SOI
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SOI | SOI | Statement creation | A/P-A/R accounting |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SOI0 | SOINUM | No | |
| SOI1 | FWDSOI | Yes | |
| SOI2 | CPY+FCY+BPR+SOIDAT+SOINUM | No | |
| SOI3 | CPY+BPR+CUR+SOINUM | No | |
| SOI4 | TYPSOI+NUMSOI+SOINUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AMTCUR | Amount in currency | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BILVCR | Draft no. | VCR | ||||||
| BPR | BP | BPR | [BPR]BPR0=[SOI]BPR | Block | ||||
| BPRTYP | BP type | M | 15 | 644 | ||||
| CPY | Company | CPY | [CPY]CPY0=[SOI]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation author | A | 5 | |||||
| CUR | Currency | CUR | [TCU]TCU0=[SOI]CUR | Block | ||||
| DUDDAT | Due date | D | ||||||
| DUDNBR | Number of due dates | C | 4 | |||||
| EXPNUM | Export number | L | 8 | |||||
| FCY | Site | FCY | [FCY]FCY0=[SOI]FCY | Block | ||||
| FLGFUP | Reminder | M | 4 | 1 | ||||
| FLGFWD | To carry forward | M | 4 | 1 | ||||
| FLGFWDSOI | Statement carryfwd. | M | 4 | 1 | ||||
| FLGPAZ | Pay approval | M | 15 | 510 | ||||
| FLGPST | Posted | M | 4 | 1 | ||||
| FWDSOI | Carry-foward stmnt. | VCR | ||||||
| NUMSOI | Document no. | VCR | ||||||
| OD | Generate MO | M | 4 | 1 | ||||
| PAM | Payment method | TAM | [TAM]TAM0=PAM;[V]GSUPCLE | Block | ||||
| SAC | Control | SAC | ||||||
| SOICOD | Statement code | A | 3 | |||||
| SOIDAT | Statement date | D | ||||||
| SOINUM | Statement number | VCR | ||||||
| TPYPAYCUR | Paid | MD1 | ||||||
| TYPSOI | Entry type | GTE | [GTE]GTE0=TYPSOI;[V]GSUPCLE | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change author | A | 5 |