qbfdecn.sal-payearn

Pay Earnings


Table details

Area FinData
Dumpname payearn
Label Pay Earnings
Val.exp ?
Val.msg

Fields

Order Field Name x Label Datatype Format Initial Mand Description
85 acct-no X Acct No character xxxxxx-xx-x
70 ben-no X Ben No character x(6)
10 emp-no X Employee No character x(8)
50 irp-cde X IRP Code character x(4)
90 payslip-amt X Payslip Amount decimal-2 >>>,>>9.99- 0
40 payslip-grp X Payslip Group integer 99 0
30 payslip-no X Payslip No integer >>>>>>9 0
80 ref-no X Ref No character x(20)
20 run-no X Run No integer >>>>>>9 0
35 sal-cde X Salary Code character x(4)
100 sal-type X Salary Type integer 99 0
110 trn-no X Trans No character x(12)

Indexes

Index name Flags Fields Datatype
emp-no P emp-no (+) character
    run-no (+) integer
    sal-cde (+) character
acct-no acct-no (+) character
emp-irp emp-no (+) character
    irp-cde (+) character
run-no run-no (+) integer
sal-cde sal-cde (+) character
+ = Ascending - = Descending P = Primary U = Unique I = Inactive W = Wordindex

Related tables

Parent tables
acr-clntacct   prs-employee   sal-benefic   sal-salcde   sal-salrun  


generated 24-6-2026 08:28