RETURNHDR

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTNSET1 COMPANY
AUTH-NO
BLI2.1
RTNSET2 COMPANY
INVC-PREFIX
INVC-NUMBER
KeyChange, Subset
WhereINVC-PREFIX !=Spaces
OrINVC-NUMBER !=Zeroes
WH20.7
RTNSET3 COMPANY
LOCATION
STATUS
AUTH-NO
KeyChange
RTNSET4 COMPANY
CUSTOMER
STATUS
AUTH-NO
KeyChange


RETURNHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
RTN-COMPANY->ACO-COMPANY (ACOSET1)
Arcustomer ARCUSTOMER Required
RTN-COMPANY->ACM-COMPANY
RTN-CUSTOMER->ACM-CUSTOMER
Billto BILLTO Required
When RTN-BILL-TO !=Zeroes
ACO-CUST-GROUP->ABS-CUST-GROUP
RTN-CUSTOMER->ABS-CUSTOMER
RTN-BILL-TO->ABS-BILL-TO
Cucodes CUCODES Required
When RTN-CURRENCY-CODE !=Spaces
RTN-CURRENCY-CODE->CUC-CURRENCY-CODE
Custdesc CUSTDESC Required
ACO-CUST-GROUP->CUD-CUST-GROUP
RTN-CUSTOMER->CUD-CUSTOMER
Custorder CUSTORDER Not Required
RTN-COMPANY->COR-COMPANY
RTN-ORDER-NBR->COR-ORDER-NBR
Iclocation ICLOCATION Required
RTN-COMPANY->ICL-COMPANY
RTN-LOCATION->ICL-LOCATION
Oecompany OECOMPANY Required
RTN-COMPANY->OEC-COMPANY
Oeinvctype OEINVCTYPE Required
RTN-COMPANY->OIN-COMPANY
RTN-INVC-TYPE->OIN-INVC-TYPE
Oeinvoice OEINVOICE Required
When RTN-INVC-PREFIX !=Spaces
OrRTN-INVC-NUMBER !=Zeroes
RTN-COMPANY->OEI-COMPANY
RTN-INVC-PREFIX->OEI-INVC-PREFIX
RTN-INVC-NUMBER->OEI-INVC-NUMBER
Oeproclev OEPROCLEV Required
RTN-COMPANY->OEP-COMPANY
RTN-PROCESS-LEVEL->OEP-PROCESS-LEVEL
Oereason OEREASON Required
When RTN-REASON-CODE !=Spaces
RTN-COMPANY->OER-COMPANY
RTN-REASON-CODE->OER-REASON-CODE
Orig Invoice OEINVOICE Required
When -ORIG-INVC-NBR !=Spaces
RTN-COMPANY->OEI-COMPANY
RTN-ORIG-INVC-PRE->OEI-INVC-PREFIX
RTN-ORIG-INVC-NBR->OEI-INVC-NUMBER
Shipto SHIPTO Required
When -SHIP-TO !=Spaces
RTN-COMPANY->SHP-COMPANY
RTN-CUSTOMER->SHP-CUSTOMER
RTN-SHIP-TO->SHP-SHIP-TO


RETURNHDR FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Returnline RETURNLINE
RTN-COMPANY->RTL-COMPANY
RTN-AUTH-NO->RTL-AUTH-NO
  RTL-LINE-NBR


File created: Thu Jun 09 11:21:47 2016

Home
Contact Us



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