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.

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 marked * are descending. 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

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