RETURNHDR FILE
Return Header
The Return Header file contains the return header record.
REFERENCED BY
BL00.1 BL199 BLI2.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTN-COMPANY Numeric 4
Company This field contains the company number.
RTN-AUTH-NO Numeric 10
Auth No This field contains the authorization
number of the user who is entering the
return.
RTN-DATE Numeric 8 (yyyymmdd)
Date This field contains the system date
when the return was created.
RTN-USER-ID Alpha 10 (Lower Case)
User ID Name This field contains the name of the
user who entered the return.
RTN-CUSTOMER Alpha 9 (Right Justified)
Customer Number This field contains the number that
represents a customer.
RTN-BILL-TO Numeric 4
Bill To This field contains the bill-to
customer number from the original order.
RTN-SHIP-TO Numeric 4
Ship-to Code This field contains the number
representing the ship to customer.
RTN-DROPSHIP-FL Alpha 1
Dropship Flag 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 Alpha 5
Location Code This field contains a valid stock
location within the company inventory.
RTN-POSTING-DATE Numeric 8 (yyyymmdd)
Posting Date This field contains the date assigned
to the journal entry for posting.
RTN-CUST-RET-REF Alpha 10
Cust Ret Ref
RTN-CUST-REQ-ACT Alpha 1
Cust Req Act This field indicates whether a customer
wants a credit or replacement of goods
on a return.
C = Credit
R = Replacement
RTN-REASON-CODE Alpha 4
Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
RTN-ORIG-INVC-PRE Alpha 2
Orig Invc Pre This field contains the prefix of the
original invoice against which the
return is being made.
RTN-ORIG-INVC-NBR Numeric 8
Orig Invc Nbr This field contains the number of the
original invoice against which the
return is being made.
RTN-INVC-PREFIX Alpha 2
Invoice Prefix 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 Numeric 8
Invc Number 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 Numeric 8
Order Number Each order is assigned a unique number.
Order numbers are either manually or
system assigned based on a company-level
option.
RTN-SHIPMENT-NBR Numeric 10
Shipment Number 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 Alpha 5
Process Level This field contains the process level.
RTN-INVC-TYPE Alpha 4
Invoice Type This field contains the invoice type
assigned to the return. The type must
be a credit memo.
RTN-CURRENCY-CODE Alpha 5
Currency Code This field contains the company's base
currency code established in the Lawson
General Ledger system.
RTN-CONTACT Alpha 20
Primary Contact This field contains the name of the
main contact.
RTN-INT-PREFIX Alpha 6
Int Prefix This field contains the international
telephone prefix of the contact at the
customer site for which the return is
being entered.
RTN-PHONE-NMBR Alpha 15
Telephone Number This field contains the telephone
number of the contact at the customer
site from which the inventory is being
returned.
RTN-PHONE-EXT Alpha 5
Telephone Extension This field contains the contact's
telephone extension number.
RTN-STATUS Numeric 1
Status This field displays the status of the
transaction.
0 = Entered
1 = Released
9 = Closed
RTN-LAST-SEQ Numeric 3
Last Sequence This field contains the number used to
increment the line number.
RTN-LAST-COMM-SEQ Numeric 3
Last Comment This is the sequence number of the last
Sequence Number comment line entered for this
requisition line.
RTN-LAST-LINE-NBR Numeric 6
Last Line Number This field contains the number of the
last line item added to the document. It
is used to determine what the next line
number is when you add another
item.
RTN-UND-ITEM-CNT Numeric 3
Und Item Cnt This field contains a count of items
that have not been selected for return.
RTN-UND-CM-CNT Numeric 4
Und Cm Cnt This field contains a count of returns
that have not selected whether or not to
create a credit memo.
RTN-CM-CNT Numeric 3
Cm Cnt This field contains the number of items
to be included on a credit memo.
RTN-AUTO-APP-FL Alpha 1
Auto App Fl
RTN-CREATE-CM-CD Alpha 1
Create Cm Cd
RTN-EP-TYPE Alpha 5
Ep Type
RTN-EP-ACCOUNT Alpha 32
Ep Account
RTN-EP-EXP-DATE Numeric 8 (yyyymmdd)
Ep Exp Date
RETURNHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTNSET1 COMPANY BL00.1 BL199
AUTH-NO BLI2.1
RTNSET2 COMPANY KeyChange, Subset
INVC-PREFIX Where INVC-PREFIX != Spaces
INVC-NUMBER Or INVC-NUMBER != Zeroes
RTNSET3 COMPANY KeyChange
LOCATION
STATUS
AUTH-NO
RTNSET4 COMPANY KeyChange
CUSTOMER
STATUS
AUTH-NO
RETURNHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
Or RTN-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 RTN-ORIG-INVC-NBR != Zeroes
RTN-COMPANY -> OEI-COMPANY
RTN-ORIG-INVC-PRE -> OEI-INVC-PREFIX
RTN-ORIG-INVC-NBR -> OEI-INVC-NUMBER
Shipto SHIPTO Required
When RTN-SHIP-TO != Zeroes
RTN-COMPANY -> SHP-COMPANY
RTN-CUSTOMER -> SHP-CUSTOMER
RTN-SHIP-TO -> SHP-SHIP-TO
|
