RQHBOD – No description in the Lawson data dictionary
- System
- Requisitions (RQ)
- Prefix
RBB- Primary key
COMPANY,REQ-NUMBER- Fields
- 8
- Updated by
- 2 programs
- Referenced by
- 11 programs
RQHBOD is a Lawson Requisitions table (prefix RBB); no description in the lawson data dictionary. It is indexed by COMPANY, REQ-NUMBER (RBBSET1); alternate indexes: RBBSET2. It is related 1:1 to REQHEADER. It is updated by RQ300 and RQBD.1 and referenced by IC83.1, PO00.1, RQ01.1, RQ04.1, RQ10.1, RQ12.1, RQ13.1, RQ13.2 and 3 more. The table has 8 fields, 2 indexes and 1 documented relation.
About RQHBOD
No description in the Lawson data dictionary.
Fields (8)
Column = COBOL field name without the RBB- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#RBB-COMPANY PKCOMPANY | Numeric 4 | — | RQBD.1 |
#RBB-REQ-NUMBER PKREQ_NUMBER | Numeric 7 | — | RQBD.1 |
#RBB-BOD-ACCT-ENT SET2BOD_ACCT_ENT | Alpha 22 (Lower Case) | — | RQBD.1 |
#RBB-BOD-LOCATION SET2BOD_LOCATION | Alpha 22 (Lower Case) | — | RQBD.1 |
#RBB-BOD-DOC-ID SET2BOD_DOC_ID | Alpha 100 (Lower Case) | — | RQBD.1 |
#RBB-BOD-SORBOD_SOR | Alpha 1 | —
| RQBD.1 |
#RBB-BOD-REVISION SET2BOD_REVISION | Alpha 22 (Lower Case) | — | RQBD.1 |
#RBB-BOD-VAR-IDBOD_VAR_ID | Alpha 22 (Lower Case) | — | RQBD.1 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RBBSET1 |
| Primary | IC83.1, PO00.1, RQ01.1, RQ04.1, RQ10.1, RQ12.1, RQ13.1, RQ13.2 +6 more | |
RBBSET2 |
| RQBD.1, RQBD.2 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Reqheader | REQHEADER | Required |
|