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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated 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 SET2 SET4
TAX_ID		Alpha 20—AP170, AP45.3, CB56.2
#RIC-PAYMENT-DATE SET2 SET3 SET4 SET5
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 SET2
COMPANY		Numeric 4—AP170, AP45.3, CB56.2
#RIC-PROC-LEVEL SET2
PROC_LEVEL		Alpha 5—AP170, AP45.3, CB56.2
#RIC-VENDOR-GROUP SET3
VENDOR_GROUP		Alpha 4—AP170, AP45.3, CB56.2
#RIC-VENDOR SET2 SET3
VENDOR		Alpha 9 (Right Justified)—AP115, AP45.3
#RIC-PAYEE-NAME SET2 SET3 SET5
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 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
RICSET1
  1. SOURCE
  2. YEAR-PAID
  3. RIC-OBJ-ID
PrimaryAP115, AP145, AP146, AP190, AP45.3, CB300, CB56.2
RICSET2
  1. COMPANY
  2. PAYMENT-DATE
  3. PROC-LEVEL
  4. VENDOR
  5. PAYEE-NAME
  6. TAX-ID
  7. SOURCE
  8. YEAR-PAID
  9. RIC-OBJ-ID
KeyChangeAP145, AP146, AP245, AP45.3
RICSET3
  1. VENDOR-GROUP
  2. VENDOR
  3. PAYMENT-DATE
  4. PAYEE-NAME
  5. SOURCE
  6. YEAR-PAID
  7. RIC-OBJ-ID
KeyChangeAP115, AP144
RICSET4
  1. TAX-ID
  2. PAYMENT-DATE
  3. SOURCE
  4. YEAR-PAID
  5. RIC-OBJ-ID
KeyChangeAP45.3
RICSET5
  1. PAYMENT-DATE
  2. SOURCE
  3. YEAR-PAID
  4. PAYEE-NAME
  5. RIC-OBJ-ID
KeyChangeAP45.3

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
CbpaymentCBPAYMENTRequired
RIC-CASH-CODE→CBM-CASH-CODE
RIC-BANK-INST-CODE→CBM-BANK-INST-CODE
RIC-TRANS-IDENT→CBM-TRANS-IDENT

Programs

Updated by (6)

Referenced by (4)