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
AC15.1 BL122 BL123 BL206 BL80.1 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE113 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 OE251 OE510 OE810 OE920
SA100 SA110 SA300 WH20.2 WH20.7
UPDATED BY
AC115 BL06.1 BL120 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 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 BL520
BL820 BL92.1 BL940 BL964 OE114 OE129
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE51.1 OE830 OE950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIN-COMPANY Numeric 4 BL06.1 BL964
Company The company number represents an
established company and is entered on
all function codes.
OIN-INVC-TYPE Alpha 4 BL06.1 BL964
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 BL964
Invoice Type The invoice type description.
Description
OIN-INVC-CRED-FL Alpha 1 BL06.1 BL964
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 BL964
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 AC115 BL06.1
Invoice Type Used Indicates whether this invoice type has BL120 BL130
Flag ever been used. BL20.1 BL20.3
N = No BL21.2 BL21.5
Y = Yes BL29.1 BL29.2
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 BL520
BL820 BL92.1
BL940 BL964
OE114 OE129
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE51.1 OE830
OE950
OIN-INVC-ACT-FL Alpha 1 BL06.1 BL964
Invoice Type Used Indicates whether this invoice type
Flag code is active.
A = Active
I = Inactive
OIN-FORMAT-FL Alpha 1 BL06.1 BL964
Format Fl Select Yes to use alternate invoice
format.
Y = Yes
N = No
OIN-SUMMARY-FL Alpha 1 BL06.1 BL964
Summary-Fl Select Yes to print summary page.
Y = Yes
N = No
OIN-SUMM-TOP-COMM1 Alpha 4 BL06.1 BL964
Summ Top Comm1 Line 1 of summary at top of page.
OIN-SUMM-TOP-COMM2 Alpha 4 BL06.1 BL964
Summ Top Comm2 Line 2 of summary at top of page.
OIN-SUMM-TOP-COMM3 Alpha 4 BL06.1 BL964
Summ Top Comm3 Line 3 of summary at top of page.
OIN-SUMM-TRL-COMM1 Alpha 4 BL06.1 BL964
Summ Trl Comm1 Line 1 of summary at bottom of page.
OIN-SUMM-TRL-COMM2 Alpha 4 BL06.1 BL964
Summ Trl Comm2 Line 2 of summary at bottom of page.
OIN-SUMM-TRL-COMM3 Alpha 4 BL06.1 BL964
Summ Trl Comm3 Line 3 of summary at bottom of page.
OEINVCTYPE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OINSET1 COMPANY AC115 AC15.1
INVC-TYPE BL06.1 BL120
BL122 BL123
BL130 BL20.1
BL20.3 BL206
BL21.2 BL21.5
BL29.1 BL29.2
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 BL520
BL80.1 BL820
...
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
|