C3BODRET – No description in the Lawson data dictionary

System: C3 (C3)
Prefix: C3A
Primary key: COMPANY, TRANS-TYPE, RECORD-TYPE, VENDOR, INVOICE
Fields: 24
Updated by: 2 programs
Referenced by: 7 programs

C3BODRET is a Lawson C3 table (prefix C3A); no description in the lawson data dictionary. It is indexed by COMPANY, TRANS-TYPE, RECORD-TYPE, VENDOR, INVOICE (C3ASET1). It is related 1:1 to APINVOICE. It is updated by PO30.1 and WH32.1 and referenced by API1.1, MA43.1, MA54.1, MA54.2, MA54.3, MA540 and MAI1.1. The table has 24 fields, 1 index and 1 documented relation.

About C3BODRET

No description in the Lawson data dictionary.

Fields (24)

Column = COBOL field name without the C3A- 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
#`C3A-COMPANY` PK COMPANY	Numeric 4	—	PO30.1, WH32.1
#`C3A-TRANS-TYPE` PK TRANS_TYPE	Alpha 2	— `IN` Invoice `RC` Receipt	PO30.1, WH32.1
#`C3A-RECORD-TYPE` PK RECORD_TYPE	Alpha 2	— `HD` Header `LN` Line `AO` AOC	PO30.1, WH32.1
#`C3A-VENDOR` PK VENDOR	Alpha 9 (Right Justified)	—	PO30.1, WH32.1
#`C3A-INVOICE` PK INVOICE	Alpha 22	—	PO30.1, WH32.1
#`C3A-SUFFIX` SUFFIX	Numeric 3	—	PO30.1, WH32.1
#`C3A-CANCEL-SEQ` CANCEL_SEQ	Numeric 4	—	PO30.1, WH32.1
#`C3A-PO-NUMBER` PO_NUMBER	Alpha 14 (Right Justified)	—	PO30.1, WH32.1
#`C3A-PO-RELEASE` PO_RELEASE	Numeric 4	—	PO30.1, WH32.1
#`C3A-PO-CODE` PO_CODE	Alpha 4	—	PO30.1, WH32.1
#`C3A-LOCATION` LOCATION	Alpha 5	—	PO30.1, WH32.1
#`C3A-TO-BASE-CURR` TO_BASE_CURR	Alpha 5	—	—
#`C3A-CARRIER` CARRIER	Alpha 9 (Right Justified)	—	PO30.1, WH32.1
#`C3A-GLBL-DOC-TYPE` GLBL_DOC_TYPE	Alpha 10	—	PO30.1, WH32.1
#`C3A-FREIGHT-TOT` FREIGHT_TOT	Signed 18.2	—	PO30.1, WH32.1
#`C3A-INSRNC-TOT` INSRNC_TOT	Signed 18.2	—	PO30.1, WH32.1
#`C3A-CSTMS-TOT` CSTMS_TOT	Signed 18.2	—	PO30.1, WH32.1
#`C3A-OTHER-AOC-TOT` OTHER_AOC_TOT	Signed 18.2	—	PO30.1, WH32.1
#`C3A-MATCH-AMT` MATCH_AMT	Signed 18.2	—	PO30.1, WH32.1
#`C3A-TRAN-INV-AMT` TRAN_INV_AMT	Signed 18.2	—	PO30.1, WH32.1
#`C3A-MULT-PO-FLAG` MULT_PO_FLAG	Alpha 1	—	PO30.1, WH32.1
#`C3A-BOD-ACCT-ENT` BOD_ACCT_ENT	Alpha 22	—	PO30.1, WH32.1
#`C3A-BOD-LOCATION` BOD_LOCATION	Alpha 22	—	PO30.1, WH32.1
#`C3A-BOD-DOC-ID` BOD_DOC_ID	Alpha 100	—	PO30.1, WH32.1

Indexes (1)

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
`C3ASET1`	`COMPANY` `TRANS-TYPE` `RECORD-TYPE` `VENDOR` `INVOICE`	Primary		API1.1, MA43.1, MA54.1, MA54.2, MA54.3, MA540, MAI1.1, PO30.1 +1 more

Relations

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

One to one (1) — lookups and parents

Relation Table Rules Condition Field map

Apinvoice

APINVOICE

Not Required

`C3A-COMPANY`	→	`API-COMPANY`
`C3A-VENDOR`	→	`API-VENDOR`
`C3A-INVOICE`	→	`API-INVOICE`
`C3A-SUFFIX`	→	`API-SUFFIX`
`C3A-CANCEL-SEQ`	→	`API-CANCEL-SEQ`

Programs

Updated by (2)

PO30.1 PO Receiving
WH32.1 Shipping Feedback by Document

Referenced by (7)

API1.1 Add Invoice
MA43.1 Invoice Line Detail - Purchase Order
MA54.1 Invoice
MA54.2 Distribution
MA54.3 Invoice Line Detail
MA540 Invoice Interface
MAI1.1 Invoke for MAMATCH Object

C3BODRET – No description in the Lawson data dictionary

About C3BODRET

Fields (24) Copy as SQL

Indexes (1)

Relations

One to one (1) — lookups and parents

Programs

Updated by (2)

Referenced by (7)

Fields (24)