Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SHIPTO


                              SHIPTO FILE

                        Customer Ship To Address

The Customer Ship To Address file stores customer ship to information,
including the  ship-to address and specific order processing rules for the
ship-to location.  Any customer can have multiple ship-to records set up and
one ship to can be defined as a default.

REFERENCED BY

AR08.1    AR10.1    AR120     AR501     AR550     BL121
BL125     BL202     BL290     BL31.1    BL31.2    BL31.3
BL31.5    BL31.7    BL32.3    BL32.4    BL320     BL80.1
BL90.1    BLI2.1    IC02.1    TX40.1    WH130     WH132
WH140     WH190     WH21.2    WH210     WH224     WH225
WH30.1    WH30.2    WH30.3    WH30.4    WH31.1    WH31.2
WH31.3    WH31.4    WH32.1    WH32.2    WH32.3    WH32.4
WH33.5    WH34.1    WH34.2    WH34.3    WH34.4    WH40.1
WH40.2    WH520     WH830

UPDATED BY

BL02.1    BL120     BL122     BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL802
BL820     BL92.1    TX140     WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SHP-COMPANY            Numeric 4                                 BL02.1  BL802
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

SHP-CUSTOMER           Alpha 9  (Right Justified)                BL02.1  BL802
Element: Customer      Customer number representing a unique
                       customer.

SHP-SHIP-TO            Numeric 4                                 BL02.1  BL802
Element: Ship To       User-defined code identifying a
                       customer's ship-to number.

SHP-NAME               Alpha 30  (Lower Case)                    BL02.1  BL290
Element: Name          This field displays the ship to's         BL320   BL80.1
                       address name.                             BL802   WH21.2
                                                                 WH210

SHP-CONTACT            Alpha 30  (Lower Case)
Element: Name          Displays the company description.

SHP-ADDR1              Alpha 30  (Lower Case)                    BL02.1  BL80.1
Element: Addr1         First line of address information for a   BL802
                       customer's ship-to location.

SHP-ADDR2              Alpha 30  (Lower Case)                    BL02.1  BL80.1
Element: Addr1         Second line of address information for    BL802
                       a customer's ship-to location.

SHP-ADDR3              Alpha 30  (Lower Case)                    BL02.1  BL80.1
Element: Addr1         Third line of address information for a   BL802
                       customer's ship-to location.

SHP-ADDR4              Alpha 30  (Lower Case)                    BL02.1  BL80.1
Element: Addr1         Fourth line of address information for    BL802
                       a customer's ship-to location.

SHP-CITY               Alpha 18  (Lower Case)                    BL02.1  BL80.1
Element: City          City name of a customer's ship-to         BL802
                       location.

SHP-STATE              Alpha 2                                   BL02.1  BL80.1
Element: State         State abbreviation of a customer's        BL802
                       ship-to location.

SHP-ZIP                Alpha 10                                  BL02.1  BL80.1
Element: Zip           Zip code of a customer's ship-to          BL802
                       location.

SHP-COUNTRY            Alpha 30  (Lower Case)                    BL02.1  BL80.1
Element: Country       Country name for a customer's ship-to     BL802
                       location.

SHP-COUNTY             Alpha 25  (Lower Case)                    BL02.1  BL802
Element: County        The county for the company address.       TX140

SHP-TAX-EXEMPT-CD      Alpha 1                                   BL02.1  BL802
Element: Tax Exempt Cd Code indicating the taxing status of a
                       customer's ship-to location. If a
                       customer ship-to is defined as exempt,
                       any order placed for this ship-to
                       location will be exempt regardless of
                       the taxing status of the item ordered.
                       E = Exempt
                       T = Taxable

SHP-TAX-CODE           Alpha 10                                  BL02.1  BL802
Element: Tax Code      A user-defined code representing the      TX140
                       tax authorities this ship-to pays sales
                       tax to. Tax codes are set up in the Tax
                       system.

SHP-FREIGHT-CODE       Alpha 2                                   BL02.1  BL802
Element: Freight Code  Freight code indicating if a freight
                       charge is to be assessed for orders
                       placed using this ship-to location.
                       Freight codes are set up in the Billing
                       system.

SHP-CARRIER            Alpha 9  (Right Justified)                BL02.1  BL202
Element: Vendor        This field contains the carrier vendor    BL802
                       number. Must be a valid vendor in the
                       Accounts Payable system.

SHP-BRK-CHRG-FL        Alpha 1                                   BL02.1  BL802
Element: All Flag      This flag indicates whether this
                       customer ship-to is subject to broken
                       case charges.
                       Y = Yes
                       N = No

SHP-BACK-ORD-FL        Alpha 1                                   BL02.1  BL802
Element: Back Ord Fl   Flag indicating whether backorders are
                       allowed when placing orders for this
                       ship-to location.
                       Y = Yes
                       N = No

SHP-SHIP-COMP-FL       Alpha 1                                   BL02.1  BL802
Element: Ship Comp Fl  Flag indicating if orders for this
                       customer ship-to must only be shipped
                       when the order is completely filled. If
                       Yes is selected, the orders can only be
                       shipped when all lines on the order can
                       be shipped in total together.
                       Y = Yes
                       N = No

SHP-PK-PRIORITY        Numeric 2                                 BL02.1  BL802
Element: Pk Priority

SHP-POD-REQ-FL         Alpha 1                                   BL02.1  BL802
Element: Pod Req Fl    POD required flag. Indicates whether
                       this customer's ship-to requires that a
                       Proof of Delivery form accompany the
                       shipment. The shipment will not be
                       billed until the POD form is returned or
                       the POD grace period expires.
                       Y = Yes
                       N = No

SHP-POD-GRACE-PER      Numeric 3                                 BL02.1  BL802
Element: Age Periods

SHP-DEF-LOCATION       Alpha 5                                   BL02.1  BL802
Element: Location      Default location from which the items
                       on orders placed for this customer
                       ship-to should be allocated, picked, and
                       shipped.

SHP-DEF-METHOD         Alpha 10                                  BL02.1  BL802
Element: Def Method    Default method indicating how orders
                       placed for this customer ship-to should
                       be shipped. Method prints on the
                       invoice, BL122 (Invoice and Register
                       Print).

SHP-USED-FL            Alpha 1                                   BL02.1  BL120
Element: Used Fl       Flag indicating whether this ship-to      BL122   BL130
                       location has ever been used.              BL20.1  BL20.3
                       N = No                                    BL21.2  BL21.5
                       Y = Yes                                   BL29.1  BL29.2
                                                                 BL520   BL802
                                                                 BL820   BL92.1
                                                                 WH20.7

SHP-ACTIVE-FLAG        Alpha 1                                   BL02.1  BL802
Element: Active Flag   This flag indicates the active or
                       inactive status of this ship-to code.
                       A = Active
                       I = Inactive

SHP-TERRITORY          Alpha 4                                   BL02.1  BL802
Element: Territory     Sales territory in which this customer
                       ship-to location is located.

SHP-SALESMAN           Numeric 4                                 BL02.1  BL802
Element: Salesman      Sales representative for this customer
                       ship-to location.

SHP-SALESMAN-2         Numeric 4                                 BL02.1  BL802
Element: Salesman      Secondary sales representative for this
                       customer ship-to location.

SHP-COMM-SPLIT         Percent 5.3  (Percent)                    BL02.1  BL802
Element: Comm Split    Percentage of the total order value
                       used as the basis for the second sales
                       representative's commission.

SHP-TERMS-CD           Alpha 5                                   BL02.1  BL802
Element: Term Code     Payment terms code established for this
                       customer ship-to number. Terms codes are
                       set up in the Terms system and determine
                       the due date of the invoices produced
                       for orders placed for this ship-to.

SHP-LIST-NAME          Alpha 14                                  BL02.1  BL802
Element: List Name     Name of the price list that will be
                       used to price items ordered for this
                       customer ship-to.

SHP-LAST-CMNT-SEQ      Numeric 3
Element: Seq           This is the sequence number identifying
                       the last comment line tied to the
                       customer ship-to.

SHP-SHIP-TO-EDI        Alpha 16                                  BL02.1  BL802
Element: Ship To Edi   Used to cross reference the Lawson
                       ship-to number used on EDI transactions
                       if different.

SHP-COUNTRY-CODE       Alpha 2                                   BL02.1  BL802
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

SHP-REGION             Alpha 2                                   BL02.1  BL802
Element: Region        The region code, if applicable for the
                       country. Used by Intrastat. Must be
                       defined in IN02.1 (Region Maintenance)


SHP-E-MAIL-ADDRESS     Alpha 60  (Lower Case)
Element: Email Address e-mail address.

SHP-VENDOR             Alpha 9  (Right Justified)                BL02.1  BL802
Element: Vendor        The vendor's identification code.



SHP-PURCH-FR-LOC       Alpha 4                                   BL02.1  BL802
Element: Purch Fr Loc  The vendor's purchase from location.

SHP-EC-CTRY-NBR        Numeric 3                                 BL02.1
Element: Ec Ctry Nbr   The European Community Country number;
                       leave blank if not a member of the
                       European Community.

SHP-ISO-CTRY-NBR       Numeric 3                                 BL02.1
Element: Iso Ctry Nbr  The ISO country number.

SHP-FOB-CODE           Alpha 3                                   BL02.1  BL802
Element: Fob Code      The user defined Free On Board Code.

SHP-PORT-CD            Alpha 5                                   BL02.1  BL802
Element: Port Cd       The Intrastat port code.  Must be
                       define
                       in IN04.1 (Port Maintenance)

SHP-MEMO-TERM          Alpha 5                                   BL02.1
Element: Memo Term     The terms code used for a credit memo
                       when a ship to is present.

                         SHIPTO FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SHPSET1   COMPANY                                                AR08.1  AR10.1
          CUSTOMER                                               AR120   AR501
          SHIP-TO                                                AR550   BL02.1
                                                                 BL120   BL121
                                                                 BL122   BL125
                                                                 BL130   BL20.1
                                                                 BL20.3  BL20.5
                                                                 BL20.6  BL202
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL290   BL31.1
                                                                 BL31.2  BL31.3
                                                                 BL31.5  BL31.7
                                                                 BL32.3  BL32.4
                                                                 BL320   BL520
                                                                 ...

SHPSET2   COMPANY       Subset                                   BL02.1  BL120
          CUSTOMER      Where SHIP-TO-EDI != Spaces              BL122   BL130
          SHIP-TO-EDI                                            BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  IC02.1
                                                                 WH20.2  WH20.7

                         SHIPTO FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ap Company     APCOMPANY    Required
                            When SHP-CARRIER != Spaces

                            SHP-COMPANY         -> CPY-COMPANY

Arcomp         ARCOMP       Required

                            SHP-COMPANY         -> ACO-COMPANY

Arcustgrp      ARCUSTGRP    Required

                            ACO-CUST-GROUP      -> ACG-CUST-GROUP

Arcustomer     ARCUSTOMER   Required

                            SHP-COMPANY         -> ACM-COMPANY
                            SHP-CUSTOMER        -> ACM-CUSTOMER

Carrier        APVENMAST    Required
                            When SHP-CARRIER != Spaces

                            CPY-VENDOR-GROUP    -> VEN-VENDOR-GROUP
                            SHP-CARRIER         -> VEN-VENDOR

Custdesc       CUSTDESC     Required

                            ACO-CUST-GROUP      -> CUD-CUST-GROUP
                            SHP-CUSTOMER        -> CUD-CUSTOMER

Freight Code   OEFRTCODE    Required
                            When SHP-FREIGHT-CODE != Spaces

                            SHP-COMPANY         -> OFR-COMPANY
                            SHP-FREIGHT-CODE    -> OFR-FRT-CODE

Location       ICLOCATION   Required
                            When SHP-DEF-LOCATION != Spaces

                            SHP-COMPANY         -> ICL-COMPANY
                            SHP-DEF-LOCATION    -> ICL-LOCATION

Method         OEMETHOD     Required
                            When SHP-DEF-METHOD != Spaces

                            SHP-COMPANY         -> OMT-COMPANY
                            SHP-DEF-METHOD      -> OMT-METHOD

Oecompany      OECOMPANY    Required

                            SHP-COMPANY         -> OEC-COMPANY

Oefrtcode      OEFRTCODE    Required
                            When SHP-FREIGHT-CODE != Spaces

                            SHP-COMPANY         -> OFR-COMPANY
                            SHP-FREIGHT-CODE    -> OFR-FRT-CODE

Salesrep1      SALESREP     Required
                            When SHP-SALESMAN != Zeroes

                            SHP-COMPANY         -> SAW-COMPANY
                            SHP-SALESMAN        -> SAW-SALESMAN

Salesrep2      SALESREP     Required
                            When SHP-SALESMAN-2 != Zeroes

                            SHP-COMPANY         -> SAW-COMPANY
                            SHP-SALESMAN-2      -> SAW-SALESMAN

Tax Code       TXTAXCODE    Required
                            When SHP-TAX-CODE != Spaces

                            SHP-COMPANY         -> TAC-COMPANY
                            SHP-TAX-CODE        -> TAC-TAX-CODE

Terms          TERMS        Required
                            When SHP-TERMS-CD != Spaces

                            SHP-TERMS-CD        -> TMS-TERMS-CD

Territory      TERITORY     Required
                            When SHP-TERRITORY != Spaces

                            SHP-COMPANY         -> TRY-COMPANY
                            SHP-TERRITORY       -> TRY-TERRITORY

Txtaxcode      TXTAXCODE    Required
                            When SHP-TAX-CODE != Spaces

                            SHP-COMPANY         -> TAC-COMPANY
                            SHP-TAX-CODE        -> TAC-TAX-CODE