|
|
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
Element: Company This field contains the company number.
RTN-AUTH-NO Numeric 10
Element: Auth No This field contains the authorization
number of the user who is entering the
return.
RTN-DATE Numeric 8 (yyyymmdd)
Element: Date This field contains the system date
when the return was created.
RTN-USER-ID Alpha 10 (Lower Case)
Element: User This field contains the name of the
user who entered the return.
RTN-CUSTOMER Alpha 9 (Right Justified)
Element: Customer This field contains the number that
represents a customer.
RTN-BILL-TO Numeric 4
Element: Bill To This field contains the bill-to
customer number from the original order.
RTN-SHIP-TO Numeric 4
Element: Ship To This field contains the number
representing the ship to customer.
RTN-DROPSHIP-FL Alpha 1
Element: Dropship Fl 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
Element: Location This field contains a valid stock
location within the company inventory.
RTN-POSTING-DATE Numeric 8 (yyyymmdd)
Element: Posting Date This field contains the date assigned
to the journal entry for posting.
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
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
RTN-ORIG-INVC-PRE Alpha 2
Element: Invc Prefix This field contains the prefix of the
original invoice against which the
return is being made.
RTN-ORIG-INVC-NBR Numeric 8
Element: Invc Number This field contains the number of the
original invoice against which the
return is being made.
RTN-INVC-PREFIX Alpha 2
Element: Invc 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
Element: 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
Element: Order Nbr 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
Element: Shipment Nbr 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
Element: Process Level This field contains the process level.
RTN-INVC-TYPE Alpha 4
Element: Invc Type This field contains the invoice type
assigned to the return. The type must
be a credit memo.
RTN-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company's base
currency code established in General
Ledger.
RTN-CONTACT Alpha 20
Element: Contact This field contains the name of the
main contact.
RTN-INT-PREFIX Alpha 6
Element: Phone 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
Element: Phone 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
Element: Phone Ext This field contains the contact's
telephone extension number.
RTN-STATUS Numeric 1
Element: Status This field displays the status of the
transaction.
0 = Entered
1 = Released
9 = Closed
RTN-LAST-SEQ Numeric 3
Element: Seq This field contains the number used to
increment the line number.
RTN-LAST-COMM-SEQ Numeric 3
Element: Seq This field contains the record sequence
number.
RTN-LAST-LINE-NBR Numeric 6
Element: Line Nbr This field contains the line number.
RTN-UND-ITEM-CNT Numeric 3
Element: Invoice Count This field contains a count of items
that have not been selected for return.
RTN-UND-CM-CNT Numeric 4
Element: 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
Element: Invoice Count This field contains the number of items
to be included on a credit memo.
RTN-AUTO-APP-FL Alpha 1
Element: Auto App Fl
RTN-CREATE-CM-CD Alpha 1
Element: All Flag
RTN-EP-TYPE Alpha 5
Element: Ep Type
RTN-EP-ACCOUNT Alpha 32
Element: Ep Account
RTN-EP-EXP-DATE Numeric 8 (yyyymmdd)
Element: 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 -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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Returnline RETURNLINE
RTN-COMPANY -> RTL-COMPANY
RTN-AUTH-NO -> RTL-AUTH-NO
RTL-LINE-NBR
|
