Return Line

The Return Line file contains the lines entered on a return.

REFERENCED BY

BLI2.1

WH20.7

UPDATED BY

IC11.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
RTL-COMPANY Element: Company	Numeric 4 This field contains the company number.
RTL-AUTH-NO Element: Auth No	Numeric 10 This field contains the authorization number of the user who is entering the return.
RTL-LINE-NBR Element: Line Nbr	Numeric 6 This field contains the line number.
RTL-CUSTOMER Element: Customer	Alpha 9 (Right Justified) This field contains the number that represents a customer.
RTL-ORDER-NBR Element: Order Nbr	Numeric 8 This field contains the order number.
RTL-LOCATION Element: Location	Alpha 5 This field contains a valid stock location within the company inventory.
RTL-DATE Element: Date	Numeric 8 (yyyymmdd) This field contains the system date when the return was created.
RTL-ITEM Element: Item	Alpha 32 This field contains the item identifier.
RTL-DESCRIPTION Element: Description	Alpha 30 (Lower Case) This field contains the item description.
RTL-LINE-TYPE Element: Line Type	Alpha 1 This field contains the type of inventory on this line. I = Inventoried N = Non-Stock X = Special
RTL-REASON-CODE Element: Reason Code	Alpha 4 This field contains the reason code, which indicates the cause for credit memos.
RTL-SHIP-TO Element: Ship To	Numeric 4 This field contains the number representing the ship to customer.
RTL-QUANTITY Element: Quantity	Signed 13.4 This field contains the return quantity in sell unit of measure.
RTL-SELL-UOM Element: Uom	Alpha 4 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 Element: Quantity	Signed 13.4 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 Element: Quantity	Signed 13.4 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 Element: Intl Cost	Signed 18.5 This field contains the price of the line in original billing currency.
RTL-STD-COST Element: Intl Cost	Signed 18.5 This field contains the cost of the item that is being returned if the company is using standard costing.
RTL-SELL-TO-STOCK Element: Sell To Stock	Signed 13.7 This field contains a conversion factor for converting the line amount from sell to stock unit of measure.
RTL-UNIT-PRICE Element: Intl Cost	Signed 18.5 This field contains the unit price in company base currency.
RTL-BASE-PRICE Element: Intl Cost	Signed 18.5 This field contains the base price from the order.
RTL-SPR-UOM Element: Uom	Alpha 4 This field contains the sell pricing unit of measure.
RTL-SPR-TO-STOCK Element: Sell To Stock	Signed 13.7 This field contains the conversion factor from price to stock unit of measure.
RTL-ENT-UNIT-COST Element: Intl Cost	Signed 18.5 This field contains the entered unit cost for the return line.
RTL-UNIT-COST Element: Intl Cost	Signed 18.5 This field contains the approved unit cost for this invoice line item in company base currency.
RTL-ACTIVITY Element: Activity	Alpha 15 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 Element: Acct Category	Alpha 5 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 Element: Activity	Alpha 15 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 Element: Acct Category	Alpha 5 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 Element: Obj Id	Numeric 12 This field contains the system-defined object ID representing the Activity Management commitment for Cost (COGS).
RTL-CUST-REQ-ACT Element: Cust Req Act	Alpha 1 This field indicates whether the customer wants a credit memo issued or replacement of goods. C = Credit Memo R = Replacement
RTL-RESTK-CHG-CODE Element: Restk Chg Code	Alpha 16 This field contains the add-on charge code indicating whether you want to charge the customer for restocking.
RTL-INV-DISP-CD Element: Inv Disp Cd	Alpha 1 This field indicates where to place returned items. R = Return To Stock S = Scrap I = Ignore
RTL-CREATE-CM-CD Element: All Flag	Alpha 1 This field indicates whether or not to create a credit memo. Y = Yes N = No
RTL-DETAIL-QTY Element: Quantity	Signed 13.4 This field contains the summation of all detail line quantity in stock unit of measure.
RTL-SLS-ACCT-UNIT Element: Acct Unit	Alpha 15 This field contains the sales accounting unit to post to.
RTL-SLS-ACCOUNT Element: Account	Numeric 6 This field contains the sales account to post to.
RTL-SLS-SUB-ACCT Element: Sub Acct	Numeric 4 This field contains the sales subaccount to post to.
RTL-OFF-ACCT-UNIT Element: Acct Unit	Alpha 15 This field contains the COGS offset account unit to post to.
RTL-OFF-ACCOUNT Element: Account	Numeric 6 This field contains the COGS offset account to post to.
RTL-OFF-SUB-ACCT Element: Sub Acct	Numeric 4 This field contains the COGS offset subaccount to post to.
RTL-CGS-ACCT-UNIT Element: Acct Unit	Alpha 15 This field contains the COGS account unit to post to.
RTL-CGS-ACCOUNT Element: Account	Numeric 6 This field contains the COGS account to post to.
RTL-CGS-SUB-ACCT Element: Sub Acct	Numeric 4 This field contains the COGS subaccount to post to.
RTL-CV-ACCT-UNIT Element: Acct Unit	Alpha 15 This field contains the cost variance accounting unit.
RTL-CV-ACCOUNT Element: Account	Numeric 6 This field contains the cost variance account.
RTL-CV-SUB-ACCT Element: Sub Acct	Numeric 4 This field contains the cost variance subaccount.
RTL-PO-NUMBER Element: Po Number	Alpha 14 (Right Justified) This field contains the number representing the purchase order.
RTL-PO-CODE Element: Po Code	Alpha 4 This is the purchase order code.
RTL-STATUS Element: Status	Numeric 1 This field contains the return status. 0 = Entered 1 = Released 9 = Closed
RTL-AVERAGE-COST Element: Intl Cost	Signed 18.5 This field contains the cost of the item that is being returned if the company is using average costing.
RTL-SOH-QTY Element: Quantity	Signed 13.4 This field contains the desired quantity.
RTL-LAST-MISC-SEQ Element: Seq	Numeric 3
RTL-LAST-COMM-SEQ Element: Seq	Numeric 3
RTL-GLBL-LINE-TYPE Element: Glbl Line Type	Alpha 15
RTL-FREIGHT-TOT Element: Freight Total	Signed 18.2
RTL-INSURANCE-TOT Element: Insurance Tot	Signed 18.2
RTL-CSTMS-TOT Element: Cstms Total	Signed 18.2
RTL-OTHER-AOC-TOT Element: Other Aoc Tot	Signed 18.2

RETURNLINE FILE INDEX

RETURNLINE FILE RELATIONS

ONE TO ONE RELATIONS

RETURNLINE FILE RELATIONS

ONE TO MANY RELATIONS

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