|
|
OEINVCTYPE FILE
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.
REFERENCED BY
PHI3.1
UPDATED BY
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIN-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
OIN-INVC-TYPE Alpha 4
Element: Invoice Type 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 Alpha 30 (Lower Case)
Element: Description The invoice type description.
OIN-INVC-CRED-FL Alpha 1
Element: All Flag Flag indicating whether or not this
invoice type is a credit invoice.
Y = Yes
N = No
OIN-INVC-RTRN-FL Alpha 1
Element: All Flag Flag indicating whether this invoice
type will allow returns to stock. Used
with credit type invoices.
N = No
Y = Yes
OIN-INVC-USED-FL Alpha 1 WH20.7
Element: All Flag Indicates whether this invoice type has
ever been used.
N = No
Y = Yes
OIN-INVC-ACT-FL Alpha 1
Element: Status Indicates whether this invoice type
code is active.
A = Active
I = Inactive
OIN-FORMAT-FL Alpha 1
Element: All Flag Select Yes to use alternate invoice
format.
Y = Yes
N = No
OIN-SUMMARY-FL Alpha 1
Element: All Flag Select Yes to print summary page.
Y = Yes
N = No
OIN-SUMM-TOP-COMM1 Alpha 4
Element: Standard CommeLine 1 of summary at top of page.
OIN-SUMM-TOP-COMM2 Alpha 4
Element: Standard CommeLine 2 of summary at top of page.
OIN-SUMM-TOP-COMM3 Alpha 4
Element: Standard CommeLine 3 of summary at top of page.
OIN-SUMM-TRL-COMM1 Alpha 4
Element: Standard CommeLine 1 of summary at bottom of page.
OIN-SUMM-TRL-COMM2 Alpha 4
Element: Standard CommeLine 2 of summary at bottom of page.
OIN-SUMM-TRL-COMM3 Alpha 4
Element: Standard CommeLine 3 of summary at bottom of page.
OEINVCTYPE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OINSET1 COMPANY PHI3.1 WH20.2
INVC-TYPE WH20.7
OEINVCTYPE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
