REQBOD – No description in the Lawson data dictionary
- System
- Requisitions (RQ)
- Prefix
RBA- Primary key
COMPANY,REQUESTER- Fields
- 8
- Updated by
- 2 programs
- Referenced by
- 10 programs
REQBOD is a Lawson Requisitions table (prefix RBA); no description in the lawson data dictionary. It is indexed by COMPANY, REQUESTER (RBASET1); alternate indexes: RBASET2. It is related 1:1 to REQUESTER. It is updated by RQ04.1 and RQBD.1 and referenced by IC83.1, PO00.1, RQ01.1, RQ10.1, RQ12.1, RQ13.1, RQ13.2, RQ35.1 and 2 more. The table has 8 fields, 2 indexes and 1 documented relation.
About REQBOD
No description in the Lawson data dictionary.
Fields (8)
Column = COBOL field name without the RBA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
RBA-COMPANY PKCOMPANY | Numeric 4 | — | RQBD.1 |
RBA-REQUESTER PKREQUESTER | Alpha 10 (Lower Case) | — | RQBD.1 |
RBA-BOD-ACCT-ENTBOD_ACCT_ENT | Alpha 22 (Lower Case) | — | IC83.1, RQ01.1, RQ04.1, RQ10.1, RQ12.1, RQ13.1, RQ13.2, RQ35.1 +3 more |
RBA-BOD-LOCATIONBOD_LOCATION | Alpha 22 (Lower Case) | — | IC83.1, RQ01.1, RQ04.1, RQ10.1, RQ12.1, RQ13.1, RQ13.2, RQ35.1 +3 more |
RBA-BOD-DOC-IDBOD_DOC_ID | Alpha 100 (Lower Case) | — | IC83.1, RQ01.1, RQ04.1, RQ10.1, RQ12.1, RQ13.1, RQ13.2, RQ35.1 +3 more |
RBA-BOD-SORBOD_SOR | Alpha 1 | —
| RQBD.1 |
RBA-BOD-REVISIONBOD_REVISION | Alpha 22 (Lower Case) | — | RQBD.1 |
RBA-BOD-VAR-IDBOD_VAR_ID | Alpha 22 (Lower Case) | — | RQBD.1 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RBASET1 | COMPANY, REQUESTER | Primary | IC83.1, PO00.1, RQ01.1, RQ04.1, RQ10.1, RQ12.1, RQ13.1, RQ13.2 +5 more | |
RBASET2 | BOD-DOC-ID, BOD-ACCT-ENT, BOD-LOCATION, BOD-REVISION | RQBD.1, RQBD.2 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Requester | REQUESTER | Required | RBA-COMPANY → REQ-COMPANY, RBA-REQUESTER → REQ-REQUESTER |