Return Header
The Return Header file contains the return header record.
REFERENCED BY
BLI2.1 | WH130 | WH132 | WH190 | WH20.7 | WH30.1 |
WH30.2 | WH30.3 | WH30.4 | WH31.1 | WH31.2 | WH31.3 |
WH31.4 | WH32.1 | WH32.2 | WH32.3 | WH32.4 | WH32.5 |
WH33.5 | WH34.1 | WH34.2 | WH34.3 | WH34.4 | WH40.1 |
WH40.2 | WH520 | WH830 |
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 |
|
|
RTN-GLBL-DOC-TYPE Element: Glbl Doc Type | Alpha 10 |
|
|
RTN-TEMP-HOLD Element: Temp Hold | Alpha 1 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
RTNSET1 |
COMPANY AUTH-NO |
|
| ||||||||||||||||||||||||||||||||||
RTNSET2 |
COMPANY INVC-PREFIX INVC-NUMBER |
|
| ||||||||||||||||||||||||||||||||||
RTNSET3 |
COMPANY LOCATION STATUS AUTH-NO |
|
|||||||||||||||||||||||||||||||||||
RTNSET4 |
COMPANY CUSTOMER STATUS AUTH-NO |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Arcomp | ARCOMP |
Required
| |||||||||||||||||||||
Arcustomer | ARCUSTOMER |
Required
| |||||||||||||||||||||
Billto | BILLTO |
Required
| |||||||||||||||||||||
Cucodes | CUCODES |
Required
| |||||||||||||||||||||
Custdesc | CUSTDESC |
Required
| |||||||||||||||||||||
Custorder | CUSTORDER |
Not Required
| |||||||||||||||||||||
Iclocation | ICLOCATION |
Required
| |||||||||||||||||||||
Oecompany | OECOMPANY |
Required
| |||||||||||||||||||||
Oeinvctype | OEINVCTYPE |
Required
| |||||||||||||||||||||
Oeinvoice | OEINVOICE |
Required
| |||||||||||||||||||||
Oeproclev | OEPROCLEV |
Required
| |||||||||||||||||||||
Oereason | OEREASON |
Required
| |||||||||||||||||||||
Orig Invoice | OEINVOICE |
Required
| |||||||||||||||||||||
Shipto | SHIPTO |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Returnline | RETURNLINE |
| ||||||||||||
Returnmisc | RETURNMISC |
|
All trademarks and registered trademarks are the property of their
respective owners.