OEINVCTYPE – Invoice Type
- System
- Billing (BL)
- Prefix
OIN- Primary key
COMPANY,INVC-TYPE- Fields
- 15
- Updated by
- 2 programs
- Referenced by
- 0 programs
OEINVCTYPE is the Invoice Type table in Lawson Billing (prefix OIN). It is indexed by COMPANY, INVC-TYPE (OINSET1). It is related 1:1 to OECOMPANY and OECOMMHDR. It is updated by WH20.2 and WH20.7. The table has 15 fields, 1 index and 7 documented relations.
About OEINVCTYPE
No description in the Lawson data dictionary.
Fields (15)
Column = COBOL field name without the OIN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
OIN-COMPANY PKCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | — |
OIN-INVC-TYPE PKINVC_TYPE | Alpha 4 | A user-defined code identifying a specific type of invoice that users want to define. For instance, CRED may define a credit memo invoice when used in the system. | — |
OIN-INVC-DESCINVC_DESC | Alpha 30 (Lower Case) | The invoice type description. | — |
OIN-INVC-CRED-FLINVC_CRED_FL | Alpha 1 | Flag indicating whether or not this invoice type is a credit invoice.
| — |
OIN-INVC-RTRN-FLINVC_RTRN_FL | Alpha 1 | Flag indicating whether this invoice type will allow returns to stock. Used with credit type invoices.
| — |
OIN-INVC-USED-FLINVC_USED_FL | Alpha 1 | Indicates whether this invoice type has ever been used.
| WH20.2, WH20.7 |
OIN-INVC-ACT-FLINVC_ACT_FL | Alpha 1 | Indicates whether this invoice type code is active.
| — |
OIN-FORMAT-FLFORMAT_FL | Alpha 1 | Select Yes to use alternate invoice format.
| — |
OIN-SUMMARY-FLSUMMARY_FL | Alpha 1 | Select Yes to print summary page.
| — |
OIN-SUMM-TOP-COMM1SUMM_TOP_COMM1 | Alpha 4 | Line 1 of summary at top of page. | — |
OIN-SUMM-TOP-COMM2SUMM_TOP_COMM2 | Alpha 4 | Line 2 of summary at top of page. | — |
OIN-SUMM-TOP-COMM3SUMM_TOP_COMM3 | Alpha 4 | Line 3 of summary at top of page. | — |
OIN-SUMM-TRL-COMM1SUMM_TRL_COMM1 | Alpha 4 | Line 1 of summary at bottom of page. | — |
OIN-SUMM-TRL-COMM2SUMM_TRL_COMM2 | Alpha 4 | Line 2 of summary at bottom of page. | — |
OIN-SUMM-TRL-COMM3SUMM_TRL_COMM3 | Alpha 4 | Line 3 of summary at bottom of page. | — |
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 |
|---|---|---|---|---|
OINSET1 | COMPANY, INVC-TYPE | Primary | WH20.2, WH20.7 |
Relations
One to one (7) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Oecompany | OECOMPANY | Required | OIN-COMPANY → OEC-COMPANY | |
| Top Comm 1 | OECOMMHDR | Not Required | OIN-COMPANY → OCH-COMPANY, OIN-SUMM-TOP-COMM1 → OCH-STD-COMM | |
| Top Comm 2 | OECOMMHDR | Not Required | OIN-COMPANY → OCH-COMPANY, OIN-SUMM-TOP-COMM2 → OCH-STD-COMM | |
| Top Comm 3 | OECOMMHDR | Not Required | OIN-COMPANY → OCH-COMPANY, OIN-SUMM-TOP-COMM3 → OCH-STD-COMM | |
| Trl Comm 1 | OECOMMHDR | Not Required | OIN-COMPANY → OCH-COMPANY, OIN-SUMM-TRL-COMM1 → OCH-STD-COMM | |
| Trl Comm 2 | OECOMMHDR | Not Required | OIN-COMPANY → OCH-COMPANY, OIN-SUMM-TRL-COMM2 → OCH-STD-COMM | |
| Trl Comm 3 | OECOMMHDR | Not Required | OIN-COMPANY → OCH-COMPANY, OIN-SUMM-TRL-COMM3 → OCH-STD-COMM |