|
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
UPDATED BY
BL00.1 BL01.1 BL06.1 BL120 BL121 BL122
BL123 BL130 BL20.1 BL20.3 BL200 BL201
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 BL98.1 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OIN-COMPANY Numeric 4 BL06.1
Element: Company 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 Alpha 4 BL06.1
Element: Invc 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
Element: Description The invoice type description.
OIN-INVC-CRED-FL Alpha 1 BL06.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 BL06.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 BL00.1 BL01.1
Element: All Flag Indicates whether this invoice type has BL06.1 BL120
ever been used. BL121 BL122
N = No BL123 BL130
Y = Yes BL20.1 BL20.3
BL200 BL201
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
BL98.1 WH20.7
OIN-INVC-ACT-FL Alpha 1 BL06.1
Element: Active Flag 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: Std Comm Line 1 of summary at top of page.
OIN-SUMM-TOP-COMM2 Alpha 4
Element: Std Comm Line 2 of summary at top of page.
OIN-SUMM-TOP-COMM3 Alpha 4
Element: Std Comm Line 3 of summary at top of page.
OIN-SUMM-TRL-COMM1 Alpha 4
Element: Std Comm Line 1 of summary at bottom of page.
OIN-SUMM-TRL-COMM2 Alpha 4
Element: Std Comm Line 2 of summary at bottom of page.
OIN-SUMM-TRL-COMM3 Alpha 4
Element: Std Comm Line 3 of summary at bottom of page.
OEINVCTYPE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OINSET1 COMPANY BL00.1 BL01.1
INVC-TYPE BL06.1 BL120
BL121 BL122
BL123 BL130
BL20.1 BL20.3
BL20.5 BL20.6
BL200 BL201
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
...
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
|