OEINVCTYPE

Invoice Type

This file stores the different invoice types set up by users. Every order or invoice processed in the system require an invoice type. These can be placed onto the order types as a default.
UPDATED BY
WH20.2 WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIN-COMPANY
Element: Company
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
Element: Invc 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-DESC
Element: Description
Alpha 30 (Lower Case)
The invoice type description.
OIN-INVC-CRED-FL
Element: All Flag
Alpha 1
Flag indicating whether or not this invoice type is a credit invoice.
Y = Yes
N = No
OIN-INVC-RTRN-FL
Element: All Flag
Alpha 1
Flag indicating whether this invoice type will allow returns to stock. Used with credit type invoices.
N = No
Y = Yes
OIN-INVC-USED-FL
Element: All Flag
Alpha 1
Indicates whether this invoice type has ever been used.
N = No
Y = Yes
WH20.2 WH20.7
OIN-INVC-ACT-FL
Element: Active Flag
Alpha 1
Indicates whether this invoice type code is active.
A = Active
I = Inactive
OIN-FORMAT-FL
Element: All Flag
Alpha 1
Select Yes to use alternate invoice format.
Y = Yes
N = No
OIN-SUMMARY-FL
Element: All Flag
Alpha 1
Select Yes to print summary page.
Y = Yes
N = No
OIN-SUMM-TOP-COMM1
Element: Std Comm
Alpha 4
Line 1 of summary at top of page.
OIN-SUMM-TOP-COMM2
Element: Std Comm
Alpha 4
Line 2 of summary at top of page.
OIN-SUMM-TOP-COMM3
Element: Std Comm
Alpha 4
Line 3 of summary at top of page.
OIN-SUMM-TRL-COMM1
Element: Std Comm
Alpha 4
Line 1 of summary at bottom of page.
OIN-SUMM-TRL-COMM2
Element: Std Comm
Alpha 4
Line 2 of summary at bottom of page.
OIN-SUMM-TRL-COMM3
Element: Std Comm
Alpha 4
Line 3 of summary at bottom of page.


OEINVCTYPE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OINSET1 COMPANY
INVC-TYPE
WH20.2 WH20.7


OEINVCTYPE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 11:09:35 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.