|
|
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
|
