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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#OIN-COMPANY PK
COMPANY		Numeric 4Identifies 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 PK
INVC_TYPE		Alpha 4A 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-DESC
INVC_DESC		Alpha 30 (Lower Case)The invoice type description.—
#OIN-INVC-CRED-FL
INVC_CRED_FL		Alpha 1Flag indicating whether or not this invoice type is a credit invoice.
  • Y Yes
  • N No
—
#OIN-INVC-RTRN-FL
INVC_RTRN_FL		Alpha 1Flag indicating whether this invoice type will allow returns to stock. Used with credit type invoices.
  • N No
  • Y Yes
—
#OIN-INVC-USED-FL
INVC_USED_FL		Alpha 1Indicates whether this invoice type has ever been used.
  • N No
  • Y Yes
WH20.2, WH20.7
#OIN-INVC-ACT-FL
INVC_ACT_FL		Alpha 1Indicates whether this invoice type code is active.
  • A Active
  • I Inactive
—
#OIN-FORMAT-FL
FORMAT_FL		Alpha 1Select Yes to use alternate invoice format.
  • Y Yes
  • N No
—
#OIN-SUMMARY-FL
SUMMARY_FL		Alpha 1Select Yes to print summary page.
  • Y Yes
  • N No
—
#OIN-SUMM-TOP-COMM1
SUMM_TOP_COMM1		Alpha 4Line 1 of summary at top of page.—
#OIN-SUMM-TOP-COMM2
SUMM_TOP_COMM2		Alpha 4Line 2 of summary at top of page.—
#OIN-SUMM-TOP-COMM3
SUMM_TOP_COMM3		Alpha 4Line 3 of summary at top of page.—
#OIN-SUMM-TRL-COMM1
SUMM_TRL_COMM1		Alpha 4Line 1 of summary at bottom of page.—
#OIN-SUMM-TRL-COMM2
SUMM_TRL_COMM2		Alpha 4Line 2 of summary at bottom of page.—
#OIN-SUMM-TRL-COMM3
SUMM_TRL_COMM3		Alpha 4Line 3 of summary at bottom of page.—

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.

IndexKeysFlagsConditionUsed in
OINSET1
  1. COMPANY
  2. INVC-TYPE
PrimaryWH20.2, WH20.7

Relations

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

One to one (7) — lookups and parents

RelationTableRulesConditionField map
OecompanyOECOMPANYRequired
OIN-COMPANY→OEC-COMPANY
Top Comm 1OECOMMHDRNot Required
OIN-COMPANY→OCH-COMPANY
OIN-SUMM-TOP-COMM1→OCH-STD-COMM
Top Comm 2OECOMMHDRNot Required
OIN-COMPANY→OCH-COMPANY
OIN-SUMM-TOP-COMM2→OCH-STD-COMM
Top Comm 3OECOMMHDRNot Required
OIN-COMPANY→OCH-COMPANY
OIN-SUMM-TOP-COMM3→OCH-STD-COMM
Trl Comm 1OECOMMHDRNot Required
OIN-COMPANY→OCH-COMPANY
OIN-SUMM-TRL-COMM1→OCH-STD-COMM
Trl Comm 2OECOMMHDRNot Required
OIN-COMPANY→OCH-COMPANY
OIN-SUMM-TRL-COMM2→OCH-STD-COMM
Trl Comm 3OECOMMHDRNot Required
OIN-COMPANY→OCH-COMPANY
OIN-SUMM-TRL-COMM3→OCH-STD-COMM

Programs

Updated by (2)