APRPTBLINC – No description in the Lawson data dictionary

System: Accounts Payable (AP)
Prefix: RIC
Primary key: SOURCE, YEAR-PAID, RIC-OBJ-ID
Fields: 26
Updated by: 6 programs
Referenced by: 4 programs

APRPTBLINC is a Lawson Accounts Payable table (prefix RIC); no description in the lawson data dictionary. It is indexed by SOURCE, YEAR-PAID, RIC-OBJ-ID (RICSET1); alternate indexes: RICSET2, RICSET3, RICSET4 and RICSET5. It is related 1:1 to CBPAYMENT. It is updated by AP115, AP170, AP190, AP45.3, CB300 and CB56.2 and referenced by AP144, AP145, AP146 and AP245. The table has 26 fields, 5 indexes and 1 documented relation.

About APRPTBLINC

No description in the Lawson data dictionary.

Fields (26)

Column = COBOL field name without the RIC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`RIC-SOURCE` PK SOURCE	Alpha 3	—	AP170, AP45.3, CB56.2
`RIC-YEAR-PAID` PK YEAR_PAID	Numeric 4	—	AP170, AP45.3, CB56.2
`RIC-RIC-OBJ-ID` PK RIC_OBJ_ID	Numeric 12	—	AP170, AP45.3, CB56.2
`RIC-INCOME-CODE` INCOME_CODE	Alpha 4	—	AP170, AP45.3, CB56.2
`RIC-TAX-ID` TAX_ID	Alpha 20	—	AP170, AP45.3, CB56.2
`RIC-PAYMENT-DATE` PAYMENT_DATE	Numeric 8 (yyyymmdd)	—	AP170, AP45.3, CB56.2
`RIC-PAID-AMT` PAID_AMT	Signed 18.2	—	AP170, AP45.3, CB56.2
`RIC-REPORTABLE-AMT` REPORTABLE_AMT	Signed 18.2	—	AP170, AP45.3, CB56.2
`RIC-TRAN-CURRENCY` TRAN_CURRENCY	Alpha 5	—	AP170, AP45.3, CB56.2
`RIC-TRANS-NBR` TRANS_NBR	Alpha 10 (Right Justified)	—	AP170, AP45.3, CB56.2
`RIC-COMPANY` COMPANY	Numeric 4	—	AP170, AP45.3, CB56.2
`RIC-PROC-LEVEL` PROC_LEVEL	Alpha 5	—	AP170, AP45.3, CB56.2
`RIC-VENDOR-GROUP` VENDOR_GROUP	Alpha 4	—	AP170, AP45.3, CB56.2
`RIC-VENDOR` VENDOR	Alpha 9 (Right Justified)	—	AP115, AP45.3
`RIC-PAYEE-NAME` PAYEE_NAME	Alpha 80 (Lower Case)	—	AP170, AP45.3, CB56.2
`RIC-ADDR1` ADDR1	Alpha 30 (Lower Case)	—	AP170, AP45.3, CB56.2
`RIC-ADDR2` ADDR2	Alpha 30 (Lower Case)	—	AP170, AP45.3, CB56.2
`RIC-ADDR3` ADDR3	Alpha 30 (Lower Case)	—	AP170, AP45.3, CB56.2
`RIC-ADDR4` ADDR4	Alpha 30 (Lower Case)	—	AP170, AP45.3, CB56.2
`RIC-CITY-ADDR5` CITY_ADDR5	Alpha 18 (Lower Case)	—	AP170, AP45.3, CB56.2
`RIC-STATE-PROV` STATE_PROV	Alpha 2	—	AP170, AP45.3, CB56.2
`RIC-POSTAL-CODE` POSTAL_CODE	Alpha 10 (Lower Case)	—	AP170, AP45.3, CB56.2
`RIC-CASH-CODE` CASH_CODE	Alpha 4	—	AP170, CB56.2
`RIC-BANK-INST-CODE` BANK_INST_CODE	Alpha 3	—	AP170, CB56.2
`RIC-TRANS-IDENT` TRANS_IDENT	Numeric 10	—	AP170, CB56.2
`RIC-TIN-TYPE` TIN_TYPE	Numeric 1	—	AP170, AP45.3, CB56.2

Indexes (5)

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

Index	Keys	Flags	Used in
`RICSET1`	`SOURCE`, `YEAR-PAID`, `RIC-OBJ-ID`	Primary	AP115, AP145, AP146, AP190, AP45.3, CB300, CB56.2
`RICSET2`	`COMPANY`, `PAYMENT-DATE`, `PROC-LEVEL`, `VENDOR`, `PAYEE-NAME`, `TAX-ID`, `SOURCE`, `YEAR-PAID`, `RIC-OBJ-ID`	KeyChange	AP145, AP146, AP245, AP45.3
`RICSET3`	`VENDOR-GROUP`, `VENDOR`, `PAYMENT-DATE`, `PAYEE-NAME`, `SOURCE`, `YEAR-PAID`, `RIC-OBJ-ID`	KeyChange	AP115, AP144
`RICSET4`	`TAX-ID`, `PAYMENT-DATE`, `SOURCE`, `YEAR-PAID`, `RIC-OBJ-ID`	KeyChange	AP45.3
`RICSET5`	`PAYMENT-DATE`, `SOURCE`, `YEAR-PAID`, `PAYEE-NAME`, `RIC-OBJ-ID`	KeyChange	AP45.3

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Cbpayment	CBPAYMENT	Required		`RIC-CASH-CODE` → `CBM-CASH-CODE`, `RIC-BANK-INST-CODE` → `CBM-BANK-INST-CODE`, `RIC-TRANS-IDENT` → `CBM-TRANS-IDENT`

Programs

Updated by (6)

AP115 Vendor Merge
AP170 Payment Closing
AP190 Invoice Reinstatement
AP45.3 Non-AP Reportable Income Adjustment
CB300 History Purge
CB56.2 CB Reportable Income Adjustments

Referenced by (4)

AP144 Tax Identification Notification
AP145 1099 Forms Creation
AP146 1099 Tape Creation
AP245 Reportable Income Report