Return Header

The Return Header file contains the return header record.

REFERENCED BY

WH20.7

BLI2.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
RTN-COMPANY Element: Company	Numeric 4 This field contains the company number.
RTN-AUTH-NO Element: Auth No	Numeric 10 This field contains the authorization number of the user who is entering the return.
RTN-DATE Element: Date	Numeric 8 (yyyymmdd) This field contains the system date when the return was created.
RTN-USER-ID Element: User	Alpha 10 (Lower Case) This field contains the name of the user who entered the return.
RTN-CUSTOMER Element: Customer	Alpha 9 (Right Justified) This field contains the number that represents a customer.
RTN-BILL-TO Element: Bill To	Numeric 4 This field contains the bill-to customer number from the original order.
RTN-SHIP-TO Element: Ship To	Numeric 4 This field contains the number representing the ship to customer.
RTN-DROPSHIP-FL Element: Dropship Fl	Alpha 1 This flag indicates whether goods being shipped by the vendor directly to a nonstandard location need to have the receiving process performed. Y = Yes N = No
RTN-LOCATION Element: Location	Alpha 5 This field contains a valid stock location within the company inventory.
RTN-POSTING-DATE Element: Posting Date	Numeric 8 (yyyymmdd) This field contains the date assigned to the journal entry for posting.
RTN-CUST-RET-REF Element: Cust Ret Ref	Alpha 10
RTN-CUST-REQ-ACT Element: Cust Req Act	Alpha 1 This field indicates whether a customer wants a credit or replacement of goods on a return. C = Credit R = Replacement
RTN-REASON-CODE Element: Reason Code	Alpha 4 This field contains the reason code, which indicates the cause for credit memos.
RTN-ORIG-INVC-PRE Element: Invc Prefix	Alpha 2 This field contains the prefix of the original invoice against which the return is being made.
RTN-ORIG-INVC-NBR Element: Invc Number	Numeric 8 This field contains the number of the original invoice against which the return is being made.
RTN-INVC-PREFIX Element: Invc Prefix	Alpha 2 This field contains the invoice prefix that is assigned from either the company or process level, depending on the invoice-level option chosen.
RTN-INVC-NUMBER Element: Invc Number	Numeric 8 This field contains the invoice number assigned by the system. Invoice numbers are assigned at the company or process level, depending on an invoice-level option on the company file.
RTN-ORDER-NBR Element: Order Nbr	Numeric 8 Each order is assigned a unique number. Order numbers are either manually or system assigned based on a company-level option.
RTN-SHIPMENT-NBR Element: Shipment Nbr	Numeric 10 This field contains the shipment number. One order can have several shipment numbers if the items of the order were not shipped at the same time.
RTN-PROCESS-LEVEL Element: Process Level	Alpha 5 This field contains the process level.
RTN-INVC-TYPE Element: Invc Type	Alpha 4 This field contains the invoice type assigned to the return. The type must be a credit memo.
RTN-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company's base currency code established in General Ledger.
RTN-CONTACT Element: Contact	Alpha 20 This field contains the name of the main contact.
RTN-INT-PREFIX Element: Phone Prefix	Alpha 6 This field contains the international telephone prefix of the contact at the customer site for which the return is being entered.
RTN-PHONE-NMBR Element: Phone	Alpha 15 This field contains the telephone number of the contact at the customer site from which the inventory is being returned.
RTN-PHONE-EXT Element: Phone Ext	Alpha 5 This field contains the contact's telephone extension number.
RTN-STATUS Element: Status	Numeric 1 This field displays the status of the transaction. 0 = Entered 1 = Released 9 = Closed
RTN-LAST-SEQ Element: Seq	Numeric 3 This field contains the number used to increment the line number.
RTN-LAST-COMM-SEQ Element: Seq	Numeric 3 This field contains the record sequence number.
RTN-LAST-LINE-NBR Element: Line Nbr	Numeric 6 This field contains the line number.
RTN-UND-ITEM-CNT Element: Invoice Count	Numeric 3 This field contains a count of items that have not been selected for return.
RTN-UND-CM-CNT Element: Und Cm Cnt	Numeric 4 This field contains a count of returns that have not selected whether or not to create a credit memo.
RTN-CM-CNT Element: Invoice Count	Numeric 3 This field contains the number of items to be included on a credit memo.
RTN-AUTO-APP-FL Element: Auto App Fl	Alpha 1
RTN-CREATE-CM-CD Element: All Flag	Alpha 1
RTN-EP-TYPE Element: Ep Type	Alpha 5
RTN-EP-ACCOUNT Element: Ep Account	Alpha 32
RTN-EP-EXP-DATE Element: Ep Exp Date	Numeric 8 (yyyymmdd)
RTN-FREIGHT-CDE Element: Freight Code	Alpha 2
RTN-FRT-CHARGE Element: Intl Amt	Signed 18.2
RTN-LAST-MISC-SEQ Element: Seq	Numeric 3
RTN-LINE-TOTAL Element: Intl Amt	Signed 18.2

RETURNHDR FILE INDEX

RETURNHDR FILE RELATIONS

ONE TO ONE RELATIONS

RETURNHDR FILE RELATIONS

ONE TO MANY RELATIONS

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