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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
C3T-COMPANY PKCOMPANY | Numeric 4 | — | PO30.1, WH32.1 |
C3T-C3T-TRANS-TYPE PKC3T_TRANS_TYPE | Alpha 2 | — | PO30.1, WH32.1 |
C3T-RECORD-TYPE PKRECORD_TYPE | Alpha 2 | — | PO30.1, WH32.1 |
C3T-VENDOR PKVENDOR | Alpha 9 (Right Justified) | — | PO30.1, WH32.1 |
C3T-INVOICE PKINVOICE | Alpha 22 | — | PO30.1, WH32.1 |
C3T-SUFFIXSUFFIX | Numeric 3 | — | PO30.1, WH32.1 |
C3T-CANCEL-SEQCANCEL_SEQ | Numeric 4 | — | PO30.1, WH32.1 |
C3T-SHIPMENT-NBRSHIPMENT_NBR | Numeric 10 | — | PO30.1, WH32.1 |
C3T-LOCATIONLOCATION | Alpha 5 | — | PO30.1, WH32.1 |
C3T-ORDER-LINE-NBR PKORDER_LINE_NBR | Numeric 6 | — | PO30.1, WH32.1 |
C3T-BR-TAX-TYPE PKBR_TAX_TYPE | Alpha 15 | — | PO30.1, WH32.1 |
C3T-PO-NUMBERPO_NUMBER | Alpha 14 (Right Justified) | — | PO30.1, WH32.1 |
C3T-ORDER-NUMBER PKORDER_NUMBER | Numeric 8 | — | PO30.1, WH32.1 |
C3T-REC-NUMBERREC_NUMBER | Numeric 10 | — | PO30.1, WH32.1 |
C3T-TAX-LINETAX_LINE | Numeric 6 | — | PO30.1, WH32.1 |
C3T-TAX-CODETAX_CODE | Alpha 10 | — | PO30.1, WH32.1 |
C3T-TAX-BASETAX_BASE | Signed 18.2 | — | PO30.1, WH32.1 |
C3T-TAX-RATETAX_RATE | Signed 7.3 | — | PO30.1, WH32.1 |
C3T-TAX-AMOUNTTAX_AMOUNT | Signed 18.2 | — | PO30.1, WH32.1 |
C3T-TAX-RECOV-AMTTAX_RECOV_AMT | Signed 18.2 | — | PO30.1, WH32.1 |
C3T-TAX-INC-AMTTAX_INC_AMT | Signed 18.2 | — | PO30.1, WH32.1 |
C3T-TAX-DISC-AMTTAX_DISC_AMT | Signed 18.2 | — | PO30.1, WH32.1 |
C3T-INTST-TAX-DIFFINTST_TAX_DIFF | Signed 18.2 | — | PO30.1, WH32.1 |
C3T-TAX-CLASSTAX_CLASS | Signed 18.2 | — | PO30.1, WH32.1 |
C3T-GLBL-LINE-TYPEGLBL_LINE_TYPE | Alpha 15 | — | PO30.1, WH32.1 |
C3T-BOD-ACCT-ENTBOD_ACCT_ENT | Alpha 22 | — | PO30.1, WH32.1 |
C3T-BOD-LOCATIONBOD_LOCATION | Alpha 22 | — | PO30.1, WH32.1 |
C3T-BOD-DOC-IDBOD_DOC_ID | Alpha 100 | — | PO30.1, WH32.1 |
Indexes (3)
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 |
|---|---|---|---|---|
C3TSET1 | COMPANY, C3T-TRANS-TYPE, RECORD-TYPE, VENDOR, INVOICE, ORDER-NUMBER, ORDER-LINE-NBR, BR-TAX-TYPE | Primary | MA540, MA61.1, MAI1.1, PO30.1, WH32.1 | |
C3TSET2 | COMPANY, C3T-TRANS-TYPE, RECORD-TYPE, VENDOR, ORDER-NUMBER, ORDER-LINE-NBR, BR-TAX-TYPE | Subset | Where C3T-TRANS-TYPE = "IN" | PO30.1, WH20.7, WH32.1 |
C3TSET3 | COMPANY, C3T-TRANS-TYPE, RECORD-TYPE, VENDOR, PO-NUMBER, ORDER-LINE-NBR, BR-TAX-TYPE | Subset | Where C3T-TRANS-TYPE = "RC" | — |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Apinvoice | APINVOICE | Not Required | C3T-COMPANY → API-COMPANY (APISET1), C3T-VENDOR → API-VENDOR, C3T-INVOICE → API-INVOICE, C3T-SUFFIX → API-SUFFIX, C3T-CANCEL-SEQ → API-CANCEL-SEQ |