PREMPBANK – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
PEB
Primary key
EBANK-ID, CA-INST-NBR, CA-TRANSIT-NBR
Fields
12
Updated by
22 programs
Referenced by
0 programs

PREMPBANK is a Lawson Payroll table (prefix PEB); no description in the lawson data dictionary. It is indexed by EBANK-ID, CA-INST-NBR, CA-TRANSIT-NBR (PEBSET1); alternate indexes: PEBSET2, PEBSET3, PEBSET4 and PEBSET5. It is related 1:1 to INSTCTRYCD. It is updated by BN66.1, PR12.1, PR12.3, PR12.4, PR140, PR160, PR189, PR195 and 14 more. The table has 12 fields, 5 indexes and 1 documented relation.

About PREMPBANK

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the PEB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PEB-EBANK-ID PK
EBANK_ID		Numeric 9Contains the receiving DFI routing number.BN66.1, PR12.1, PR12.3, PR12.4, PR140, PR160, PR189, PR195 +14 more
#PEB-BANK-NAME
BANK_NAME		Alpha 30 (Lower Case)Contains the name of the bank.BN66.1, PR12.1, PR12.3, PR12.4, PR140, PR160, PR189, PR195 +14 more
#PEB-CA-INST-NBR PK
CA_INST_NBR		Numeric 4Contains the value that identifies the Canadian institution for the employees financial institution.BN66.1, PR12.1, PR12.3, PR12.4, PR140, PR160, PR189, PR195 +14 more
#PEB-CA-TRANSIT-NBR PK
CA_TRANSIT_NBR		Numeric 5Contains the Canadian transit number for the employees financial institution.BN66.1, PR12.1, PR12.3, PR12.4, PR140, PR160, PR189, PR195 +14 more
#PEB-COUNTRY-CODE SET2
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).BN66.1, PR12.1, PR12.3, PR12.4, PR140, PR160, PR189, PR195 +14 more
#PEB-ADDR1
ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.BN66.1, PR12.1, PR12.3, PR12.4, PR140, PR160, PR189, PR195 +13 more
#PEB-ADDR2
ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.BN66.1, PR12.1, PR12.3, PR12.4, PR140, PR160, PR189, PR195 +13 more
#PEB-ADDR3
ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.BN66.1, PR12.1, PR12.3, PR12.4, PR140, PR160, PR189, PR195 +13 more
#PEB-ADDR4
ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.BN66.1, PR12.1, PR12.3, PR12.4, PR140, PR160, PR189, PR195 +13 more
#PEB-ZIP
ZIP		Alpha 10This field contains the postal code of the address.BN66.1, PR12.1, PR12.3, PR12.4, PR140, PR160, PR189, PR195 +13 more
#PEB-IN-MICR-NO SET3
IN_MICR_NO		Numeric 9—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
#PEB-IFSC SET4
IFSC		Alpha 11—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PEBSET1
  1. EBANK-ID
  2. CA-INST-NBR
  3. CA-TRANSIT-NBR
PrimaryBN66.1, PR12.1, PR12.3, PR12.4, PR140, PR160, PR189, PR195 +14 more
PEBSET2
  1. COUNTRY-CODE
  2. EBANK-ID
  3. CA-INST-NBR
  4. CA-TRANSIT-NBR
PR712
PEBSET3
  1. IN-MICR-NO
  2. EBANK-ID
  3. CA-INST-NBR
  4. CA-TRANSIT-NBR
—
PEBSET4
  1. IFSC
  2. EBANK-ID
  3. CA-INST-NBR
  4. CA-TRANSIT-NBR
BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
PEBSET5
  1. EBANK-ID ↓
  2. CA-INST-NBR
  3. CA-TRANSIT-NBR
SubsetWhere COUNTRY-CODE = "IN"BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
INSTCTRYCDPREMPBANK

One to one (1) — lookups and parents

RelationTableRulesConditionField map
InstctrycdINSTCTRYCDRequired
PEB-COUNTRY-CODE→INT-COUNTRY-CODE

Programs

Updated by (22)