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.

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
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
IN_MICR_NO		Numeric 9—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
PEB-IFSC
IFSC		Alpha 11—BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PEBSET1EBANK-ID, CA-INST-NBR, CA-TRANSIT-NBRPrimaryBN66.1, PR12.1, PR12.3, PR12.4, PR140, PR160, PR189, PR195 +14 more
PEBSET2COUNTRY-CODE, EBANK-ID, CA-INST-NBR, CA-TRANSIT-NBRPR712
PEBSET3IN-MICR-NO, EBANK-ID, CA-INST-NBR, CA-TRANSIT-NBR—
PEBSET4IFSC, EBANK-ID, CA-INST-NBR, CA-TRANSIT-NBRBN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more
PEBSET5EBANK-ID*, CA-INST-NBR, CA-TRANSIT-NBRSubsetWhere COUNTRY-CODE = "IN"BN66.1, PR12.1, PR12.3, PR140, PR160, PR189, PR195, PR29.1 +12 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
InstctrycdINSTCTRYCDRequiredPEB-COUNTRY-CODE → INT-COUNTRY-CODE

Programs

Updated by (22)