|
RETURNLINE FILE
Return Line
The Return Line file contains the lines entered on a return.
REFERENCED BY
IC11.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTL-COMPANY Numeric 4
Element: Company This field contains the company number.
RTL-AUTH-NO Numeric 10
Element: Auth No This field contains the authorization
number of the user who is entering the
return.
RTL-LINE-NBR Numeric 6
Element: Line Nbr This field contains the line number.
RTL-CUSTOMER Alpha 9 (Right Justified)
Element: Customer This field contains the number that
represents a customer.
RTL-ORDER-NBR Numeric 8
Element: Order Nbr This field contains the order number.
RTL-LOCATION Alpha 5
Element: Location This field contains a valid stock
location within the company inventory.
RTL-DATE Numeric 8 (yyyymmdd)
Element: Date This field contains the system date
when the return was created.
RTL-ITEM Alpha 32
Element: Item This field contains the item
identifier.
RTL-DESCRIPTION Alpha 30 (Lower Case)
Element: Description This field contains the item
description.
RTL-LINE-TYPE Alpha 1
Element: Line Type This field contains the type of
inventory on this line.
I = Inventoried
N = Non-Stock
X = Special
RTL-REASON-CODE Alpha 4
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
RTL-SHIP-TO Numeric 4
Element: Ship To This field contains the number
representing the ship to customer.
RTL-QUANTITY Signed 13.4
Element: Quantity This field contains the return quantity
in sell unit of measure.
RTL-SELL-UOM Alpha 4
Element: Uom This field contains the stock unit of
measure for the item. If entered, it
must be a valid stock unit of measure
for this item. If not entered, the
default stock unit of measure for this
item is assigned.
RTL-INVC-CW-QTY Signed 13.4
Element: Quantity This field contains the invoice catch
weight quantity. This field is valid
only for catch weight items. This is
used in extended price calculation, but
quantity is used for pricing.
RTL-INVEN-CW-QTY Signed 13.4
Element: Quantity This field contains the inventory catch
weight quantity. This field is used
only for credit memo catch weight items,
if the item is returned to inventory.
This is defaulted from invoice catch
weight quantity.
RTL-ENTERED-PRICE Signed 18.5
Element: Intl Cost This field contains the price of the
line in original billing currency.
RTL-STD-COST Signed 18.5
Element: Intl Cost This field contains the cost of the
item that is being returned if the
company is using standard costing.
RTL-SELL-TO-STOCK Signed 13.7
Element: Sell To Stock This field contains a conversion factor
for converting the line amount from sell
to stock unit of measure.
RTL-UNIT-PRICE Signed 18.5
Element: Intl Cost This field contains the unit price in
company base currency.
RTL-BASE-PRICE Signed 18.5
Element: Intl Cost This field contains the base price from
the order.
RTL-SPR-UOM Alpha 4
Element: Uom This field contains the sell pricing
unit of measure.
RTL-SPR-TO-STOCK Signed 13.7
Element: Sell To Stock This field contains the conversion
factor from price to stock unit of
measure.
RTL-ENT-UNIT-COST Signed 18.5
Element: Intl Cost This field contains the entered unit
cost for the return line.
RTL-UNIT-COST Signed 18.5
Element: Intl Cost This field contains the approved unit
cost for this invoice line item in
company base currency.
RTL-ACTIVITY Alpha 15
Element: Activity This field contains the activity for
the sales account.
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in Project Accounting.
Direct costs are posted to activities,
and indirect costs are allocated to
activities based on activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
RTL-ACCT-CATEGORY Alpha 5
Element: Acct Category This field contains the account
category for the sales account.
Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in Project Accounting.
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 Account Assignment
(AC07.1).
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.
RTL-ACTIVITY-C Alpha 15
Element: Activity This field contains the activity for
the Cost (COGS) account.
Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in Project Accounting.
Direct costs are posted to activities,
and indirect costs are allocated to
activities based on activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
RTL-ACCT-CATEG-C Alpha 5
Element: Acct Category This field contains the account
category for the Cost (COGS) account.
Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in Project Accounting.
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 Account Assignment
(AC07.1).
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.
RTL-ATN-OBJ-ID-C Numeric 12
Element: Obj Id This field contains the system-defined
object ID representing the Activity
Management commitment for Cost (COGS).
RTL-CUST-REQ-ACT Alpha 1
Element: Cust Req Act This field indicates whether the
customer wants a credit memo issued or
replacement of goods.
C = Credit Memo
R = Replacement
RTL-RESTK-CHG-CODE Alpha 16
Element: Restk Chg CodeThis field contains the add-on charge
code indicating whether you want to
charge the customer for restocking.
RTL-INV-DISP-CD Alpha 1
Element: Inv Disp Cd This field indicates where to place
returned items.
R = Return To Stock
S = Scrap
I = Ignore
RTL-CREATE-CM-CD Alpha 1
Element: All Flag This field indicates whether or not to
create a credit memo.
Y = Yes
N = No
RTL-DETAIL-QTY Signed 13.4
Element: Quantity This field contains the summation of
all detail line quantity in stock unit
of measure.
RTL-SLS-ACCT-UNIT Alpha 15
Element: Acct Unit This field contains the sales
accounting unit to post to.
RTL-SLS-ACCOUNT Numeric 6
Element: Account This field contains the sales account
to post to.
RTL-SLS-SUB-ACCT Numeric 4
Element: Sub Acct This field contains the sales
subaccount to post to.
RTL-OFF-ACCT-UNIT Alpha 15
Element: Acct Unit This field contains the COGS offset
account unit to post to.
RTL-OFF-ACCOUNT Numeric 6
Element: Account This field contains the COGS offset
account to post to.
RTL-OFF-SUB-ACCT Numeric 4
Element: Sub Acct This field contains the COGS offset
subaccount to post to.
RTL-CGS-ACCT-UNIT Alpha 15
Element: Acct Unit This field contains the COGS account
unit to post to.
RTL-CGS-ACCOUNT Numeric 6
Element: Account This field contains the COGS account to
post to.
RTL-CGS-SUB-ACCT Numeric 4
Element: Sub Acct This field contains the COGS subaccount
to post to.
RTL-CV-ACCT-UNIT Alpha 15
Element: Acct Unit This field contains the cost variance
accounting unit.
RTL-CV-ACCOUNT Numeric 6
Element: Account This field contains the cost variance
account.
RTL-CV-SUB-ACCT Numeric 4
Element: Sub Acct This field contains the cost variance
subaccount.
RTL-PO-NUMBER Alpha 14 (Right Justified)
Element: Po Number This field contains the number
representing the purchase order.
RTL-PO-CODE Alpha 4
Element: Po Code This is the purchase order code.
RTL-STATUS Numeric 1
Element: Status This field contains the return status.
0 = Entered
1 = Released
9 = Closed
RTL-AVERAGE-COST Signed 18.5
Element: Intl Cost This field contains the cost of the
item that is being returned if the
company is using average costing.
RTL-SOH-QTY Signed 13.4
Element: Quantity This field contains the desired
quantity.
RETURNLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTLSET1 COMPANY IC11.1
AUTH-NO
LINE-NBR
RTLSET2 COMPANY
CUSTOMER
ITEM
SHIP-TO
DATE
AUTH-NO
LINE-NBR
RTLSET3 ATN-OBJ-ID-C KeyChange, Subset
Where ATN-OBJ-ID-C != Zeroes
RTLSET4 COMPANY KeyChange
ITEM
STATUS
AUTH-NO
LINE-NBR
RTLSET5 COMPANY KeyChange
REASON-CODE
STATUS
AUTH-NO
LINE-NBR
RTLSET6 COMPANY
LINE-NBR
AUTH-NO
RETURNLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cogs Account GLMASTER Not Required
Valid When RTL-CGS-ACCT-UNIT != Spaces
Or RTL-CGS-ACCOUNT != Zeroes
Or RTL-CGS-SUB-ACCT != Zeroes
RTL-COMPANY -> -COMPANY
RTL-CGS-ACCT-UNIT -> -ACCT-UNIT
RTL-CGS-ACCOUNT -> -ACCOUNT
RTL-CGS-SUB-ACCT -> -SUB-ACCOUNT
Cogs Offset GLMASTER Not Required
Valid When RTL-OFF-ACCT-UNIT != Spaces
Or RTL-OFF-ACCOUNT != Zeroes
Or RTL-OFF-SUB-ACCT != Zeroes
RTL-COMPANY -> GLM-COMPANY
RTL-OFF-ACCT-UNIT -> GLM-ACCT-UNIT
RTL-OFF-ACCOUNT -> GLM-ACCOUNT
RTL-OFF-SUB-ACCT -> GLM-SUB-ACCOUNT
Coline COLINE Not Required
Valid When RTL-ORDER-NBR != Zeroes
RTL-COMPANY -> COL-COMPANY
RTL-ORDER-NBR -> COL-ORDER-NBR
RTL-LINE-NBR -> COL-LINE-NBR
Glsystem GLSYSTEM Required
RTL-COMPANY -> GLS-COMPANY
Iccompany ICCOMPANY Required
RTL-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
RTL-COMPANY -> ICL-COMPANY
RTL-LOCATION -> ICL-LOCATION
Itemloc ITEMLOC Not Required
Valid When RTL-LINE-TYPE = "I"
RTL-COMPANY -> ITL-COMPANY
RTL-LOCATION -> ITL-LOCATION
RTL-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When RTL-LINE-TYPE != "X"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
RTL-ITEM -> ITE-ITEM
Oecompany OECOMPANY Required
RTL-COMPANY -> OEC-COMPANY
Oeinvcline OEINVCLINE Required
When RTN-ORIG-INVC-PRE != Spaces
Or RTN-ORIG-INVC-NBR != Zeroes
RTL-COMPANY -> OIL-COMPANY
RTN-ORIG-INVC-PRE -> OIL-INVC-PREFIX
RTN-ORIG-INVC-NBR -> OIL-INVC-NUMBER
RTL-LINE-NBR -> OIL-LINE-NBR
Oemisc OEMISC Not Required
Valid When RTL-RESTK-CHG-CODE != Spaces
RTL-COMPANY -> OEM-COMPANY
RTL-RESTK-CHG-CODE -> OEM-MISC
RTN-CURRENCY-CODE -> OEM-CURRENCY-CODE
Oereason OEREASON Required
When RTL-REASON-CODE != Spaces
RTL-COMPANY -> OER-COMPANY
RTL-REASON-CODE -> OER-REASON-CODE
Reason OEREASON Required
When RTL-REASON-CODE != Spaces
RTL-COMPANY -> OER-COMPANY
RTL-REASON-CODE -> OER-REASON-CODE
Returnhdr RETURNHDR Required
RTL-COMPANY -> RTN-COMPANY
RTL-AUTH-NO -> RTN-AUTH-NO
Sales Account GLMASTER Required
RTL-COMPANY -> GLM-COMPANY
RTL-SLS-ACCT-UNIT -> GLM-ACCT-UNIT
RTL-SLS-ACCOUNT -> GLM-ACCOUNT
RTL-SLS-SUB-ACCT -> GLM-SUB-ACCOUNT
RETURNLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bins WHSHLDTL
Valid When ITE-LOT-TRACK-FL = "N"
And ITL-BIN-TRACK-FL = "Y"
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-LINE-NBR -> WHD-LINE-NBR
WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Lots WHSHLDTL
Valid When ITE-LOT-TRACK-FL = "Y"
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-LINE-NBR -> WHD-LINE-NBR
WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Oeshipdtl WHSHLDTL
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-LINE-NBR -> WHD-LINE-NBR
WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Serials WHSHLDTL
Valid When ITE-SER-TRACK-FL = "R"
Or ITE-SER-TRACK-FL = "I"
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-LINE-NBR -> WHD-LINE-NBR
WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Sohdetail SOHDETAIL
RTL-COMPANY -> SDT-COMPANY
RTL-LOCATION -> SDT-LOCATION
RTL-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
Uoms WHSHLDTL
Valid When ITE-MULT-UOMS > Zeroes
RTL-COMPANY -> WHD-COMPANY
RTL-LOCATION -> WHD-LOCATION
RTN-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
RTL-LINE-NBR -> WHD-LINE-NBR
WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
|