Table PAYMENTH
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
PAYMENTH | PYH | Payment header | A/P-A/R accounting |
Key | Description | Duplicates | Activity code |
---|---|---|---|
PYH0 | NUM | No | |
PYH1 | FRMFLG+FRMNUM+FRMLIN | Yes | |
PYH2 | PAYLOT+PAYLOTLIG+NUM | No | |
PYH3 | PAYTYP-NUM | No | |
PYH4 | DUDDAT+NUM | No | |
PYH5 | ACCDAT | Yes | REGBC |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACC | Account | GAC | [GAC]GAC0=COA;ACC | Block | ||||
ACCDAT | Accounting date | D | ||||||
ACCNUMTRE | Internal number | 11 | UNQ | |||||
ACS | Access code | ACS | [ACS]ACS0=[PYH]ACS | Block | ||||
AMTBAN | Bank amount | MD1 | ||||||
AMTCUR | Amount | MD1 | ||||||
AMTNYTBIL | Note P/R amount | MD1 | ||||||
AUUID | Single identifier | AUUID | ||||||
BAN | Bank | BAN | [BAN]BAN0=[PYH]BAN | Block | ||||
BANDAT | Bank date | D | KIT | |||||
BANPAYTPY | Bank amount | MD1 | ||||||
BDFECOCOD | Economic reason | PBDECO | [PBDECO]PBDECO0=[PYH]BDFECOCOD | BSRA | ||||
BDFMVTCOD | BDF movement code | ADI | [ADI]CODE=307;BDFMVTCOD | Block | ||||
BDFPAYCOD | BDF payment code | ADI | [ADI]CODE=308;BDFPAYCOD | Block | ||||
BICCOD | BIC code | A | 11 | VII | ||||
BID | Bank account number | BID | ||||||
BIDCRY | Bank acct. country | CRY | [TCY]TCY0=[PYH]BIDCRY | Block | ||||
BILDAT | Date created | D | ||||||
BILVCR | Draft no. | VCR | ||||||
BPAADDLIG | Address line | 3 | A | 35 | ||||
BPAINV | Address | ADR | ||||||
BPANAM | Company name | NAM | ||||||
BPR | BP | BPR | [BPR]BPR0=[PYH]BPR | Block | ||||
BPRREF | Drawee reference | A | 10 | |||||
BPRSAC | Control | SAC | ||||||
BPRTYP | BP type | M | 15 | 644 | ||||
BSITRS | Bank statement | A | 30 | BSI | ||||
CASHVATNUM | Communication number | A | 250 | KPO | ||||
CHQBAN | Pay-by branch | A | 10 | |||||
CHQNUM | Check number | A | 15 | |||||
CHQTYP | Check type | M | 15 | 654 | ||||
COA | Chart code | COA | [COA]COA0=[PYH]COA | Block | ||||
COMDAT | Communication date | D | KPO | |||||
CPY | Company | CPY | [CPY]CPY0=[PYH]CPY | Block | ||||
CRDAUZ | Authorization number | A | 10 | |||||
CRDEXYDAT | Validity date | D | ||||||
CRDNUM | Bank card number | A | 16 | |||||
CRDTYP | Card type | ADI | [ADI]CODE=314;CRDTYP | Block | ||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
CRY | Country | CRY | [TCY]TCY0=[PYH]CRY | Block | ||||
CRYNAM | Country name | A | 30 | |||||
CSHVATRGM | Tax rule | M | 4 | 1 | KPO | |||
CTY | City | A | 30 | |||||
CUR | Currency | CUR | [TCU]TCU0=[PYH]CUR | Block | ||||
CURRAT | Currency rate | DCB | 11 | |||||
DES | Description | DES | ||||||
DUDDAT | Due date | D | ||||||
EDTNUM | Query no. | L | 8 | |||||
EPANATPAY | Payment nature | ADI | [ADI]CODE=313;EPANATPAY | Block | VII | |||
EPARENPAY | Payment reason | A | 140 | VII | ||||
EXPNUM | Export number | L | 8 | |||||
FCY | Site | FCY | [FCY]FCY0=[PYH]FCY | Block | ||||
FIY | Fiscal year | C | 2 | |||||
FLGEND | Endorsed flag | C | 4 | KAG | ||||
FRMDAT | Slip date | D | ||||||
FRMFCY | Note site | FCY | [FCY]FCY0=[PYH]FRMFCY | Block | ||||
FRMFLG | Slip type | M | 15 | 685 | ||||
FRMLIN | Summary line | C | 4 | |||||
FRMNUM | Slip no. | VCR | ||||||
FRMREF | Remittance reference | REF | ||||||
FRMTYP | Discount type | M | 15 | 655 | ||||
FRMUSR | Note user | A | 5 | |||||
MIDBICCOD | Intermediary bank BIC code | A | 11 | VII | ||||
MIDCRY | Intermediary bank country | CRY | [TCY]TCY0=[PYH]MIDCRY | Block | VII | |||
MIDPAB1 | Intermediary bank name | A | 35 | VII | ||||
MIDPAB2 | Intermediary bank address 1 | A | 35 | VII | ||||
MIDPAB3 | Intermediary bank address 2 | A | 35 | VII | ||||
MIDPAB4 | Intermediary bank address 3 | A | 35 | VII | ||||
NUM | Payment no. | VCR | ||||||
NUMORD | Payment order | A | 1 | KAG | ||||
ORIDAT | Source date | D | ||||||
PAB1 | Paying bank 1 | A | 35 | |||||
PAB2 | Paying bank 2 | A | 35 | |||||
PAB3 | Paying bank 3 | A | 35 | VII | ||||
PAB4 | Paying bank 4 | A | 35 | VII | ||||
PABAMTPRT | Partial amount | MD1 | ||||||
PABFLG | Accepted | M | 4 | 1 | ||||
PABREN | Non accepted reason | ADI | [ADI]CODE=305;PABREN | Block | ||||
PAM | Payment method | TAM | [TAM]TAM0=PAM;[V]GSUPCLE | Block | ||||
PAYAPPDAT | Approval date | ADATIM | ||||||
PAYAPPFLG | Approved | M | 4 | 1 | ||||
PAYAPPUSR | Approver | AUS | [AUS]CODUSR=[PYH]PAYAPPUSR | Other | ||||
PAYLOT | Batch code | VCR | ||||||
PAYLOTLIG | Batch line | C | 4 | |||||
PAYNUMEND | Endorsed payment | A | 1 | KAG | ||||
PAYTYP | Transaction | TPY | [TPY]TPY0=PAYTYP;[V]GSUPCLE | Block | ||||
PER | Period | C | 2 | |||||
POSCOD | Postal code | POS | ||||||
PST | Posted | C | 1 | |||||
PURTYP | Purchase type | M | 15 | 646 | ||||
REF | Reference | REF | ||||||
REGLP | Bank/Cash line no. | C | 4 | REGBC | ||||
REGNUM | Bank/Cash reg. no. | A | 10 | REGBC | ||||
RENNOTPAY | Late payment reason | ADI | [ADI]CODE=310;RENNOTPAY | Block | ||||
SAT | County | SAT | ||||||
SENBPR | Sender | A | 1 | KAG | ||||
SENCRN | Site tax ID no. | A | 1 | KAG | ||||
SENORI | Initial issuer | A | 1 | KAG | ||||
SNS | Sign | M | 15 | 632 | ||||
STA | Status | M | 30 | 689 | ||||
STAFLG | Status flags | 11 | M | 4 | 1 | |||
SUP1 | Extra field 1 | A | 20 | |||||
SUP2 | Extra field 2 | A | 20 | |||||
SUP3 | Extra field 3 | A | 20 | |||||
SWIIPI | IPI code | A | 20 | KSW | ||||
SWISUP1 | Instruction key EZAG | M | 15 | 3660 | KSW | |||
SWISUP2 | Instruction key DTA | M | 15 | 3659 | KSW | |||
SWISUP3 | Bank charge bearer | M | 15 | 3658 | KSW | |||
TFBDAT | Bank file | D | ||||||
TFBFIL | Bank file | A | 15 | |||||
UMRNUM | Mandate reference | MDT | [MDT]MDT0=CPY;UMRNUM | Block | SDD | |||
UMRSEQ | Sequence | A | 30 | SDD | ||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | A | 5 | |||||
VALDAT | Value date | D | ||||||
VATSTA | Status | M | 15 | 3619 | KPO |