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.

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
BOD_ACCT_ENT
Alpha 22 (Lower Case)
YBK-BOD-LOCATION
BOD_LOCATION
Alpha 22 (Lower Case)
YBK-BOD-DOC-ID
BOD_DOC_ID
Alpha 100 (Lower Case)
YBK-BOD-SOR
BOD_SOR
Alpha 1
YBK-BOD-REVISION
BOD_REVISION
Alpha 22 (Lower Case)
YBK-BOD-VAR-ID
BOD_VAR_ID
Alpha 22 (Lower Case)

Indexes (2)

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

IndexKeysFlagsConditionUsed in
YBKSET1COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, BATCH-NBR, APP-SEQPrimaryAR09.1, AR09.4, AR10.1, AR11.1, AR12.1, AR12.2, AR13.1, AR13.2 +8 more
YBKSET2BOD-DOC-ID, BOD-ACCT-ENT, BOD-LOCATION, BOD-REVISION

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ArappliedARAPPLIEDRequiredYBK-COMPANYARA-COMPANY (ARASET1), YBK-TRANS-TYPEARA-TRANS-TYPE, YBK-INVOICEARA-INVOICE, YBK-PAYMENT-SEQARA-PAYMENT-SEQ, YBK-BATCH-NBRARA-BATCH-NBR, YBK-APP-SEQARA-APP-SEQ

Programs

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