RETURNMISC

OE Returns

REFERENCED BY
WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RMC-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.
RMC-AUTH-NO
Element: Auth No
Numeric 10
RMC-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
RMC-SEQ
Element: Seq
Numeric 3
This field contains the record sequence number.
RMC-MISC
Element: Misc
Alpha 16
RMC-CHARGE-TYPE
Element: Charge Type
Numeric 1
Indicates whether the charge is Lump Sum, Unit Price or Percentage.
RMC-ENT-UNIT-PRC
Element: Intl Cost
Signed 18.5
RMC-PRICE-PCT
Element: Cost Pct
Percent 5.3 (Percent)
Cost Percent. Percent to applied to unit cost of the item to arrive at the Add on charge cost.
RMC-ENT-PRICE
Element: Intl Amt
Signed 18.2
RMC-UNIT-COST
Element: Intl Cost
Signed 18.5
RMC-COST-PCT
Element: Cost Pct
Percent 5.3 (Percent)
Cost Percent. Percent to applied to unit cost of the item to arrive at the Add on charge cost.
RMC-COST
Element: Intl Cost
Signed 18.5
RMC-ALLOC-DISC
Element: Intl Amt
Signed 18.2
RMC-ORD-DISC-FL
Element: Ord Disc Fl
Alpha 1
RMC-SLS-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
RMC-SLS-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
RMC-SLS-SUB-ACCT
Element: Sub Account
Numeric 4
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
RMC-OFF-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
RMC-OFF-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
RMC-OFF-SUB-ACCT
Element: Sub Account
Numeric 4
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
RMC-CGS-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
RMC-CGS-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
RMC-CGS-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
RMC-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
RMC-ACCT-CATEGORY
Element: Acct Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru
RMC-ATN-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
RMC-ACTIVITY-C
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
RMC-ACCT-CATEG-C
Element: Acct Category
Alpha 5
Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru
RMC-ATN-OBJ-ID-C
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
RMC-CHARGE-CURR
Element: Intl Amt
Signed 18.2
RMC-TRACK-TYPE
Element: Aoc Type
Alpha 1

" " = Other AOC
I = Insurance
F = Freight
C = Customs Charges


RETURNMISC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RMCSET1 COMPANY
AUTH-NO
LINE-NBR
SEQ
WH20.7
RMCSET2 ATN-OBJ-ID
Subset
WhereATN-OBJ-ID !=Zeroes
RMCSET3 ATN-OBJ-ID-C
Subset
WhereATN-OBJ-ID-C !=Zeroes


RETURNMISC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
RMC-COMPANY->OEC-COMPANY (OECSET1)
Oemisc OEMISC Required
RMC-COMPANY->OEM-COMPANY
RMC-MISC->OEM-MISC
RTN-CURRENCY-CODE->OEM-CURRENCY-CODE
Returnhdr RETURNHDR Required
RMC-COMPANY->RTN-COMPANY
RMC-AUTH-NO->RTN-AUTH-NO
Returnline RETURNLINE Required
When RMC-LINE-NBR !=Zeroes
RMC-COMPANY->RTL-COMPANY
RMC-AUTH-NO->RTL-AUTH-NO
RMC-LINE-NBR->RTL-LINE-NBR


File created: Thu Jun 09 02:24:32 2016

Home
Contact Us



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