Table PYHCAS
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PYHCAS | PCH | Treasury interface | Financials | CASIN |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PCH1 | REGNUM+ACCNUM+REGLIN | Yes | |
| PCH2 | NUMPCH | Yes | |
| PCH3 | REGNUM+RVSACCNUM+REGLIN | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACC | Account | GAC | [GAC]GAC0=COA;ACC | Block | ||||
| ACCDAT | Accounting date | D | ||||||
| ACCNUM | Internal number | UNQ | ||||||
| AMTBAN | Bank amount | MD1 | ||||||
| AMTCUR | Operation amount | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BAN | Bank | BAN | [BAN]BAN0=[PCH]BAN | Block | ||||
| BPR | BP | BPR | [BPR]BPR0=[PCH]BPR | Block | ||||
| BUDG | Setup | A | 128 | |||||
| CDC | Setup | A | 128 | |||||
| CHQNUM | Check number | A | 15 | |||||
| COA | Chart of accounts | COA | [COA]COA0=[PCH]COA | Block | ||||
| CODRIF | Setup | A | 128 | |||||
| CPTA | Setup | A | 128 | |||||
| CPY | Company | CPY | [CPY]CPY0=[PCH]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CUR | Currency | CUR | [TCU]TCU0=[PCH]CUR | Block | ||||
| CURBAN | Account currency | CUR | [TCU]TCU0=[PCH]CURBAN | Block | ||||
| DAT | Date | D | ||||||
| DATPCH | Date | D | ||||||
| DESCR | Setup | A | 128 | |||||
| DOPE | Operation date | D | ||||||
| DUDDAT | Due date | D | ||||||
| FCY | Site | FCY | [FCY]FCY0=[PCH]FCY | Block | ||||
| FIC | File | FIC | 30 | |||||
| FLG | Indicator | M | 4 | 1 | ||||
| FRMNUM | Slip no. | VCR | ||||||
| ISOCOD | ISO code | A | 3 | |||||
| LCR | Parameters | A | 128 | |||||
| NASS | Check number | A | 128 | |||||
| NUMPCH | Identifier | L | 8 | |||||
| NUMVCR | Accounting document | VCR | ||||||
| PAM | Payment method | TAM | [TAM]TAM0=PAM;[V]GSUPCLE | Block | ||||
| PAYTYP | Payment type | TPY | [TPY]TPY0=PAYTYP;[V]GSUPCLE | Block | ||||
| REF | Parameters | A | 128 | |||||
| REFXRT | Setup | A | 128 | |||||
| REGLIN | Line number | UNQ | ||||||
| REGNUM | Payment no. | VCR | ||||||
| RVSACCNUM | Reversal | UNQ | ||||||
| SAC | Control | SAC | ||||||
| SNS | Sign | C | 2 | |||||
| TRANS | Parameters | A | 128 | |||||
| TRECOD | Treasury interface | A | 16 | |||||
| TYPVCR | Entry type | GTE | [GTE]GTE0=TYPVCR;[V]GSUPCLE | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PCH]UPDUSR | Other | ||||
| VALDAT | Value date | D |