ARAPPLDBOD – No description in the Lawson data dictionary

System
Accounts Receivable (AR)
Prefix
YBK
Primary key
COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, BATCH-NBR, APP-SEQ
Fields
12
Updated by
0 programs
Referenced by
0 programs

ARAPPLDBOD is a Lawson Accounts Receivable table (prefix YBK); no description in the lawson data dictionary. It is indexed by COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, BATCH-NBR, APP-SEQ (YBKSET1); alternate indexes: YBKSET2. It is related 1:1 to ARAPPLIED. The table has 12 fields, 2 indexes and 1 documented relation.

About ARAPPLDBOD

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the YBK- 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
#YBK-COMPANY PK
COMPANY		Numeric 4——
#YBK-TRANS-TYPE PK
TRANS_TYPE		Alpha 1——
#YBK-INVOICE PK
INVOICE		Alpha 22——
#YBK-PAYMENT-SEQ PK
PAYMENT_SEQ		Numeric 6——
#YBK-BATCH-NBR PK
BATCH_NBR		Numeric 6——
#YBK-APP-SEQ PK
APP_SEQ		Numeric 7——
#YBK-BOD-ACCT-ENT SET2
BOD_ACCT_ENT		Alpha 22 (Lower Case)——
#YBK-BOD-LOCATION SET2
BOD_LOCATION		Alpha 22 (Lower Case)——
#YBK-BOD-DOC-ID SET2
BOD_DOC_ID		Alpha 100 (Lower Case)——
#YBK-BOD-SOR
BOD_SOR		Alpha 1——
#YBK-BOD-REVISION SET2
BOD_REVISION		Alpha 22 (Lower Case)——
#YBK-BOD-VAR-ID
BOD_VAR_ID		Alpha 22 (Lower Case)——

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
YBKSET1
  1. COMPANY
  2. TRANS-TYPE
  3. INVOICE
  4. PAYMENT-SEQ
  5. BATCH-NBR
  6. APP-SEQ
PrimaryAR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 +8 more
YBKSET2
  1. BOD-DOC-ID
  2. BOD-ACCT-ENT
  3. BOD-LOCATION
  4. BOD-REVISION
—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ArappliedARAPPLIEDRequired
YBK-COMPANY→ARA-COMPANY (ARASET1)
YBK-TRANS-TYPE→ARA-TRANS-TYPE
YBK-INVOICE→ARA-INVOICE
YBK-PAYMENT-SEQ→ARA-PAYMENT-SEQ
YBK-BATCH-NBR→ARA-BATCH-NBR
YBK-APP-SEQ→ARA-APP-SEQ

Programs

No Lawson programs are documented as updating or referencing this table.