Lawson Insight Technical Documentation |
|
RETURNHDR
RETURNHDR FILE
Return Header
The Return Header file contains the return header record.
REFERENCED BY
BL00.1 BL199 BLI2.1 OE230 OE85.1 OE85.2
OE85.3 OE86.1 OE86.3 OE86.4 SA100
UPDATED BY
OE130 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE330 OE530 OE830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RTN-COMPANY Numeric 4 OE30.1 OE30.2
Element: Company This field contains the company number. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-AUTH-NO Numeric 10 OE30.1 OE30.2
Element: Auth No This field contains the authorization OE30.3 OE30.4
number of the user who is entering the OE30.5 OE30.6
return. OE30.7 OE30.9
OE530 OE830
RTN-DATE Numeric 8 (yyyymmdd) OE30.1 OE30.2
Element: Date This field contains the system date OE30.3 OE30.4
when the return was created. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-USER-ID Alpha 10 (Lower Case) OE30.1 OE30.2
Element: User This field contains the name of the OE30.3 OE30.4
user who entered the return. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-CUSTOMER Alpha 9 (Right Justified) OE30.1 OE30.2
Element: Customer NumbeThis field contains the number that OE30.3 OE30.4
represents a customer. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-BILL-TO Numeric 4 OE30.1 OE30.2
Element: Bill To This field contains the bill-to OE30.3 OE30.4
customer number from the original order. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-SHIP-TO Numeric 4 OE30.1 OE30.2
Element: Ship-to Code This field contains the number OE30.3 OE30.4
representing the ship to customer. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-DROPSHIP-FL Alpha 1
Element: 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 OE30.1 OE30.2
Element: Location Code This field contains a valid stock OE30.3 OE30.4
location within the company inventory. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-POSTING-DATE Numeric 8 (yyyymmdd) OE130 OE30.1
Element: Posting Date This field contains the date assigned OE30.2 OE30.3
to the journal entry for posting. OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE530
OE830
RTN-CUST-RET-REF Alpha 10
Element: Cust Ret Ref
RTN-CUST-REQ-ACT Alpha 1
Element: 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 OE30.1 OE30.2
Element: Reason Code This field contains the reason code, OE30.3 OE30.4
which indicates the cause for credit OE30.5 OE30.6
memos. OE30.7 OE30.9
OE530 OE830
RTN-ORIG-INVC-PRE Alpha 2 OE30.1 OE30.2
Element: Invoice PrefixThis field contains the prefix of the OE30.3 OE30.4
original invoice against which the OE30.5 OE30.6
return is being made. OE30.7 OE30.9
OE530 OE830
RTN-ORIG-INVC-NBR Numeric 8 OE30.1 OE30.2
Element: Invc Number This field contains the number of the OE30.3 OE30.4
original invoice against which the OE30.5 OE30.6
return is being made. OE30.7 OE30.9
OE530 OE830
RTN-INVC-PREFIX Alpha 2 OE30.1 OE30.2
Element: Invoice PrefixThis field contains the invoice prefix OE30.3 OE30.4
that is assigned from either the company OE30.5 OE30.6
or process level, depending on the OE30.7 OE30.9
invoice-level option chosen. OE530 OE830
RTN-INVC-NUMBER Numeric 8 OE30.1 OE30.2
Element: Invc Number This field contains the invoice number OE30.3 OE30.4
assigned by the system. Invoice numbers OE30.5 OE30.6
are assigned at the company or process OE30.7 OE30.9
level, depending on an invoice-level OE530 OE830
option on the company file.
RTN-ORDER-NBR Numeric 8 OE30.1 OE30.2
Element: Order Number Each order is assigned a unique number. OE30.3 OE30.4
Order numbers are either manually or OE30.5 OE30.6
system assigned based on a company-level OE30.7 OE30.9
option. OE530 OE830
RTN-SHIPMENT-NBR Numeric 10 OE30.1 OE30.2
Element: Shipment NumbeThis field contains the shipment OE30.3 OE30.4
number. One order can have several OE30.5 OE30.6
shipment numbers if the items of the OE30.7 OE30.9
order were not shipped at the same time. OE530 OE830
RTN-PROCESS-LEVEL Alpha 5 OE30.1 OE30.2
Element: Process Level This field contains the process level. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-INVC-TYPE Alpha 4 OE30.1 OE30.2
Element: Invoice Type This field contains the invoice type OE30.3 OE30.4
assigned to the return. The type must OE30.5 OE30.6
be a credit memo. OE30.7 OE30.9
OE530 OE830
RTN-CURRENCY-CODE Alpha 5 OE30.1 OE30.2
Element: Currency Code This field contains the company's base OE30.3 OE30.4
currency code established in the Lawson OE30.5 OE30.6
General Ledger system. OE30.7 OE30.9
OE530 OE830
RTN-CONTACT Alpha 20 OE30.1 OE30.2
Element: Primary ContacThis field contains the name of the OE30.3 OE30.4
main contact. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-INT-PREFIX Alpha 6 OE30.1 OE30.2
Telephone Country This field contains the international OE30.3 OE30.4
Code telephone prefix of the contact at the OE30.5 OE30.6
customer site for which the return is OE30.7 OE30.9
being entered. OE530 OE830
RTN-PHONE-NMBR Alpha 15 OE30.1 OE30.2
Element: Telephone NumbThis field contains the telephone OE30.3 OE30.4
number of the contact at the customer OE30.5 OE30.6
site from which the inventory is being OE30.7 OE30.9
returned. OE530 OE830
RTN-PHONE-EXT Alpha 5 OE30.1 OE30.2
Element: Telephone ExteThis field contains the contact's OE30.3 OE30.4
telephone extension number. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-STATUS Numeric 1 OE130 OE30.1
Element: Status This field displays the status of the OE30.2 OE30.3
transaction. OE30.4 OE30.5
0 = Entered OE30.6 OE30.7
1 = Released OE30.9 OE530
9 = Closed OE830
RTN-LAST-SEQ Numeric 3 OE30.1 OE30.2
Element: Sequence NumbeThis field contains the number used to OE30.3 OE30.4
increment the line number. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-LAST-COMM-SEQ Numeric 3 OE30.1 OE30.2
Element: Sequence NumbeThis is the sequence number of the last OE30.3 OE30.4
comment line entered for this OE30.5 OE30.6
requisition line. OE30.7 OE30.9
OE530 OE830
RTN-LAST-LINE-NBR Numeric 6
Element: 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 OE30.1 OE30.2
Element: Invoice Count This field contains a count of items OE30.3 OE30.4
that have not been selected for return. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-UND-CM-CNT Numeric 4 OE30.1 OE30.2
Element: Und Cm Cnt This field contains a count of returns OE30.3 OE30.4
that have not selected whether or not to OE30.5 OE30.6
create a credit memo. OE30.7 OE30.9
OE530 OE830
RTN-CM-CNT Numeric 3 OE30.1 OE30.2
Element: Invoice Count This field contains the number of items OE30.3 OE30.4
to be included on a credit memo. OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-AUTO-APP-FL Alpha 1
Element: Auto App Fl
RTN-CREATE-CM-CD Alpha 1 OE30.1 OE30.2
Element: All Flag OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-EP-TYPE Alpha 5 OE30.1 OE30.2
Element: Ep Type OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-EP-ACCOUNT Alpha 32 OE30.1 OE30.2
Element: Ep Account OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RTN-EP-EXP-DATE Numeric 8 (yyyymmdd) OE30.1 OE30.2
Element: Ep Exp Date OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE530 OE830
RETURNHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RTNSET1 COMPANY BL00.1 BL199
AUTH-NO BLI2.1 OE130
OE230 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE330
OE530 OE830
OE85.1 OE86.1
OE86.3 OE86.4
RTNSET2 COMPANY KeyChange, Subset SA100
INVC-PREFIX Where INVC-PREFIX != Spaces
INVC-NUMBER Or INVC-NUMBER != Zeroes
RTNSET3 COMPANY KeyChange OE85.2
LOCATION
STATUS
AUTH-NO
RTNSET4 COMPANY KeyChange OE85.3
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
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 -ORIG-INVC-NBR != Spaces
RTN-COMPANY -> OEI-COMPANY
RTN-ORIG-INVC-PRE -> OEI-INVC-PREFIX
RTN-ORIG-INVC-NBR -> OEI-INVC-NUMBER
Returnsgbk RETURNSGBK Not Required
RTN-COMPANY -> RSB-COMPANY
RTN-AUTH-NO -> RSB-AUTH-NO
Zeroes -> RSB-LINE-NBR
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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Returnline RETURNLINE
RTN-COMPANY -> RTL-COMPANY
RTN-AUTH-NO -> RTL-AUTH-NO
RTL-LINE-NBR
|