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 |