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.

Field / columnTypeDescription & valuesUpdated by
IFT-COMPANY PK
COMPANY		Numeric 4—AP170
IFT-DATE
DATE		Numeric 8 (yyyymmdd)—AP170
IFT-VENDOR
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IFTSET1COMPANY, BATCH-NBR, PAYMENT-SEQ, CASH-CODE, BANK-INST-CODE, TRANS-IDENT, TRANS-NBRPrimary—
IFTSET2COMPANY, DATE, BATCH-NBR, PAYMENT-SEQ, CASH-CODE, BANK-INST-CODE, VENDOR, TRANS-NBR, TRANS-IDENTSubsetWhere UPDATE-DATE = Zeroes—

Programs

Updated by (1)