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
BL206 BL80.1 PHI3.1
UPDATED BY
BL01.1 BL06.1 BL121 BL123 BL200 BL201
BL30.1 BL30.2 BL30.3 BL30.5 BL31.1 BL31.2
BL31.3 BL31.5 BL31.7 BL32.1 BL32.2 BL32.3
BL32.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIN-COMPANY Numeric 4 BL06.1
Company The company number represents an
established company and is entered on
all function codes.
OIN-INVC-TYPE Alpha 4 BL06.1
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) BL06.1
Invoice Type The invoice type description.
Description
OIN-INVC-CRED-FL Alpha 1 BL06.1
Invc Cred Fl Flag indicating whether or not this
invoice type is a credit invoice.
Y = Yes
N = No
OIN-INVC-RTRN-FL Alpha 1 BL06.1
Return to Stock 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 BL01.1 BL06.1
Invoice Type Used Indicates whether this invoice type has BL121 BL123
Flag ever been used. BL200 BL201
N = No BL30.1 BL30.2
Y = Yes BL30.3 BL30.5
BL31.1 BL31.2
BL31.3 BL31.5
BL31.7 BL32.1
BL32.2 BL32.3
BL32.4
OIN-INVC-ACT-FL Alpha 1 BL06.1
Invoice Type Used Indicates whether this invoice type
Flag code is active.
A = Active
I = Inactive
OIN-FORMAT-FL Alpha 1
Format Fl Select Yes to use alternate invoice
format.
Y = Yes
N = No
OIN-SUMMARY-FL Alpha 1
Summary Fl Select Yes to print summary page.
Y = Yes
N = No
OIN-SUMM-TOP-COMM1 Alpha 4
Summ Top Comm1 Line 1 of summary at top of page.
OIN-SUMM-TOP-COMM2 Alpha 4
Summ Top Comm2 Line 2 of summary at top of page.
OIN-SUMM-TOP-COMM3 Alpha 4
Summ Top Comm3 Line 3 of summary at top of page.
OIN-SUMM-TRL-COMM1 Alpha 4
Summ Trl Comm1 Line 1 of summary at bottom of page.
OIN-SUMM-TRL-COMM2 Alpha 4
Summ Trl Comm2 Line 2 of summary at bottom of page.
OIN-SUMM-TRL-COMM3 Alpha 4
Summ Trl Comm3 Line 3 of summary at bottom of page.
OEINVCTYPE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OINSET1 COMPANY BL01.1 BL06.1
INVC-TYPE BL121 BL123
BL200 BL201
BL206 BL30.1
BL30.2 BL30.3
BL30.5 BL31.1
BL31.2 BL31.3
BL31.5 BL31.7
BL32.1 BL32.2
BL32.3 BL32.4
BL80.1 PHI3.1
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
|
