C3TAXRET – No description in the Lawson data dictionary

System
C3 (C3)
Prefix
C3T
Primary key
COMPANY, C3T-TRANS-TYPE, RECORD-TYPE, VENDOR, INVOICE, ORDER-NUMBER, ORDER-LINE-NBR, BR-TAX-TYPE
Fields
28
Updated by
2 programs
Referenced by
4 programs

C3TAXRET is a Lawson C3 table (prefix C3T); no description in the lawson data dictionary. It is indexed by COMPANY, C3T-TRANS-TYPE, RECORD-TYPE, VENDOR, INVOICE, ORDER-NUMBER, ORDER-LINE-NBR, BR-TAX-TYPE (C3TSET1); alternate indexes: C3TSET2 and C3TSET3. It is related 1:1 to APINVOICE. It is updated by PO30.1 and WH32.1 and referenced by MA540, MA61.1, MAI1.1 and WH20.7. The table has 28 fields, 3 indexes and 1 documented relation.

About C3TAXRET

No description in the Lawson data dictionary.

Fields (28)

Column = COBOL field name without the C3T- 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 / columnTypeDescription & valuesUpdated by
#C3T-COMPANY PK
COMPANY		Numeric 4—PO30.1, WH32.1
#C3T-C3T-TRANS-TYPE PK
C3T_TRANS_TYPE		Alpha 2—PO30.1, WH32.1
#C3T-RECORD-TYPE PK
RECORD_TYPE		Alpha 2—PO30.1, WH32.1
#C3T-VENDOR PK
VENDOR		Alpha 9 (Right Justified)—PO30.1, WH32.1
#C3T-INVOICE PK
INVOICE		Alpha 22—PO30.1, WH32.1
#C3T-SUFFIX
SUFFIX		Numeric 3—PO30.1, WH32.1
#C3T-CANCEL-SEQ
CANCEL_SEQ		Numeric 4—PO30.1, WH32.1
#C3T-SHIPMENT-NBR
SHIPMENT_NBR		Numeric 10—PO30.1, WH32.1
#C3T-LOCATION
LOCATION		Alpha 5—PO30.1, WH32.1
#C3T-ORDER-LINE-NBR PK
ORDER_LINE_NBR		Numeric 6—PO30.1, WH32.1
#C3T-BR-TAX-TYPE PK
BR_TAX_TYPE		Alpha 15—PO30.1, WH32.1
#C3T-PO-NUMBER SET3
PO_NUMBER		Alpha 14 (Right Justified)—PO30.1, WH32.1
#C3T-ORDER-NUMBER PK
ORDER_NUMBER		Numeric 8—PO30.1, WH32.1
#C3T-REC-NUMBER
REC_NUMBER		Numeric 10—PO30.1, WH32.1
#C3T-TAX-LINE
TAX_LINE		Numeric 6—PO30.1, WH32.1
#C3T-TAX-CODE
TAX_CODE		Alpha 10—PO30.1, WH32.1
#C3T-TAX-BASE
TAX_BASE		Signed 18.2—PO30.1, WH32.1
#C3T-TAX-RATE
TAX_RATE		Signed 7.3—PO30.1, WH32.1
#C3T-TAX-AMOUNT
TAX_AMOUNT		Signed 18.2—PO30.1, WH32.1
#C3T-TAX-RECOV-AMT
TAX_RECOV_AMT		Signed 18.2—PO30.1, WH32.1
#C3T-TAX-INC-AMT
TAX_INC_AMT		Signed 18.2—PO30.1, WH32.1
#C3T-TAX-DISC-AMT
TAX_DISC_AMT		Signed 18.2—PO30.1, WH32.1
#C3T-INTST-TAX-DIFF
INTST_TAX_DIFF		Signed 18.2—PO30.1, WH32.1
#C3T-TAX-CLASS
TAX_CLASS		Signed 18.2—PO30.1, WH32.1
#C3T-GLBL-LINE-TYPE
GLBL_LINE_TYPE		Alpha 15—PO30.1, WH32.1
#C3T-BOD-ACCT-ENT
BOD_ACCT_ENT		Alpha 22—PO30.1, WH32.1
#C3T-BOD-LOCATION
BOD_LOCATION		Alpha 22—PO30.1, WH32.1
#C3T-BOD-DOC-ID
BOD_DOC_ID		Alpha 100—PO30.1, WH32.1

Indexes (3)

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.

IndexKeysFlagsConditionUsed in
C3TSET1
  1. COMPANY
  2. C3T-TRANS-TYPE
  3. RECORD-TYPE
  4. VENDOR
  5. INVOICE
  6. ORDER-NUMBER
  7. ORDER-LINE-NBR
  8. BR-TAX-TYPE
PrimaryMA540, MA61.1, MAI1.1, PO30.1, WH32.1
C3TSET2
  1. COMPANY
  2. C3T-TRANS-TYPE
  3. RECORD-TYPE
  4. VENDOR
  5. ORDER-NUMBER
  6. ORDER-LINE-NBR
  7. BR-TAX-TYPE
SubsetWhere C3T-TRANS-TYPE = "IN"PO30.1, WH20.7, WH32.1
C3TSET3
  1. COMPANY
  2. C3T-TRANS-TYPE
  3. RECORD-TYPE
  4. VENDOR
  5. PO-NUMBER
  6. ORDER-LINE-NBR
  7. BR-TAX-TYPE
SubsetWhere C3T-TRANS-TYPE = "RC"—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ApinvoiceAPINVOICENot Required
C3T-COMPANY→API-COMPANY (APISET1)
C3T-VENDOR→API-VENDOR
C3T-INVOICE→API-INVOICE
C3T-SUFFIX→API-SUFFIX
C3T-CANCEL-SEQ→API-CANCEL-SEQ

Programs

Updated by (2)

Referenced by (4)