INRPTTBL – No description in the Lawson data dictionary

System
Tax (TX)
Prefix
IFT
Primary key
COMPANY, BATCH-NBR, PAYMENT-SEQ, CASH-CODE, BANK-INST-CODE, TRANS-IDENT, TRANS-NBR
Fields
16
Updated by
1 program
Referenced by
0 programs

INRPTTBL is a Lawson Tax table (prefix IFT); no description in the lawson data dictionary. It is indexed by COMPANY, BATCH-NBR, PAYMENT-SEQ, CASH-CODE, BANK-INST-CODE, TRANS-IDENT, TRANS-NBR (IFTSET1); alternate indexes: IFTSET2. It is updated by AP170. The table has 16 fields, 2 indexes and 0 documented relations.

About INRPTTBL

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the IFT- 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
#IFT-COMPANY PK
COMPANY		Numeric 4—AP170
#IFT-DATE SET2
DATE		Numeric 8 (yyyymmdd)—AP170
#IFT-VENDOR SET2
VENDOR		Alpha 9 (Right Justified)—AP170
#IFT-BATCH-NBR PK
BATCH_NBR		Numeric 6——
#IFT-PAYMENT-SEQ PK
PAYMENT_SEQ		Numeric 6——
#IFT-CASH-CODE PK
CASH_CODE		Alpha 4—AP170
#IFT-BANK-INST-CODE PK
BANK_INST_CODE		Alpha 3—AP170
#IFT-TRANS-IDENT PK
TRANS_IDENT		Numeric 10—AP170
#IFT-PAYMENT-AMT
PAYMENT_AMT		Signed 18.2—AP170
#IFT-COUNTRY-CODE
COUNTRY_CODE		Alpha 2—AP170
#IFT-VAT-EXEMPT
VAT_EXEMPT		Alpha 1—AP170
#IFT-UPDATE-DATE
UPDATE_DATE		Numeric 8 (yyyymmdd)——
#IFT-UPDATE-TIME
UPDATE_TIME		Numeric 8——
#IFT-TRANS-NBR PK
TRANS_NBR		Alpha 10 (Right Justified)—AP170
#IFT-PAY-GROUP
PAY_GROUP		Alpha 4—AP170
#IFT-SYSTEM
SYSTEM		Alpha 2—AP170

Indexes (2)

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
IFTSET1
  1. COMPANY
  2. BATCH-NBR
  3. PAYMENT-SEQ
  4. CASH-CODE
  5. BANK-INST-CODE
  6. TRANS-IDENT
  7. TRANS-NBR
Primary—
IFTSET2
  1. COMPANY
  2. DATE
  3. BATCH-NBR
  4. PAYMENT-SEQ
  5. CASH-CODE
  6. BANK-INST-CODE
  7. VENDOR
  8. TRANS-NBR
  9. TRANS-IDENT
SubsetWhere UPDATE-DATE = Zeroes—

Programs

Updated by (1)