|
|
REASON FILE
Reason Code
The Reason Code file contains the approved reasons that explain why inventory
transactions were made. These reasons can also be used to explain physical
inventory count variances.
REFERENCED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 CXCP.1 IC01.1 IC20.2 IC21.2
IC217 IC22.2 IC229 IC23.2 IC24.2 IC28.1
IC284 IC500 IC574 IC72.1 IC73.1 IC74.1
IC76.1 IC90.1 MA180 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 MA67.1
MA67.2 MA70.1 MA75.1 MA80.1 MAI1.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
OE111 OE113 OE114 OE116 OE129 OE13.2
OE13.3 OE13.5 OE13.6 OE14.4 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE510 OE530 OE81.1 OE810 OE830 OE90.1
OE90.2 PO100 PO101 PO122 PO131 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO274 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 POI3.1 POIE.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ35.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
WO132 WO140
UPDATED BY
IC17.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REA-COMPANY Numeric 4 IC17.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.
REA-REASON-CODE Alpha 4 IC17.1
Element: Reason Code This field contains the reason code
that indicates the cause for credit
memos. It is also allowed on debit
memos, and used to indicate the reason
for a return on a return to vendor.
REA-DESCRIPTION Alpha 30 (Lower Case) IC17.1 IC22.2
Element: Description This field contains the description of
the reason code.
REA-DESCRIPTION2 Alpha 30 (Lower Case) IC17.1
Element: Description This field contains the second line of
the description.
REA-ACCOUNT Numeric 6 IC17.1
Element: Account This field contains the general ledger
account that defaults as the offset
account number on inventory transactions
when the reason code is entered on a
transaction.
REA-SUB-ACCOUNT Numeric 4 IC17.1
Element: Subaccount This field contains the general ledger
subaccount that defaults as the offset
subaccount number if the reason code is
entered on an inventory transaction.
REA-ACTIVE-STATUS Alpha 1 IC17.1
Element: Status This field contains the status for the
reason code to control the use of the
code.
A = Active
I = Inactive
REA-REASON-TYPE Alpha 2 IC17.1
Element: Reason Type This field identifies the class of the
reason code. This classification is used
in the Case Carts system for reporting.
" " = None
1 = Waste
2 = Returns
REASON FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
REASET1 COMPANY AP125 AP126
REASON-CODE AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC01.1
IC17.1 IC20.2
IC21.2 IC217
IC22.2 IC229
IC23.2 IC24.2
...
REASON FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
REA-COMPANY -> ICC-COMPANY
|
