REASON

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 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
REA-COMPANY
Element: Company
Numeric 4
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
Element: Reason Code
Alpha 4
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
Element: Description
Alpha 30 (Lower Case)
This field contains the description of the reason code.
REA-DESCRIPTION2
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
REA-ACCOUNT
Element: Account
Numeric 6
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
Element: Sub Acct
Numeric 4
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
Element: Active Status
Alpha 1
This field contains the status for the reason code to control the use of the code.
A = Active
I = Inactive
REA-REASON-TYPE
Element: Reason Type
Alpha 2
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
REASON-CODE
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136


REASON FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company ICCOMPANY Required
REA-COMPANY->ICC-COMPANY


File created: Wed Jun 08 20:49:41 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.