F1 REFRESH F2 ADD F3 CHANGE F4 INQUIRY F8 MENU Data FieldsZIPCODE key field COUNTY CODE CITY NAME ZIP STATUS STATE required RVSN DATE display only CITY CODE Zip Code ZIP Description Ke ID: 852563
Download Pdf The PPT/PDF document "ZX0020 Zip Code TableRequired table Code..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
1 ZX0020 Zip Code TableRequired table. Cod
ZX0020 Zip Code TableRequired table. Codes defined by colleges. Use the Zip Code Table to identify city, county, and state information for each zip code. The Zip Code Table is used throughout FMS, SMS, and PPMS to assign the city and state to addresses. City and state fields on the screens are always "display only."For a complete list of zip codes, run the DataExpress procedure ZX0020R (from Group Inform, Account PLIB). User Function Keys F1 REFRESH F2 ADD F3 CHANGE F4 INQUIRY F8 MENU Data FieldsZIPCODE (key field) COUNTY CODE CITY NAME ZIP STATUS STATE (required) RVSN DATE (display only) CITY CODE Zip Code (ZIP) Description Key field. A postal zip code. The zip code is entered in the first five positions of Length 9 characters 5 digits City/Town Name (CITY) Description The name of the city or town associated with a zip code. Length 20 characters State
2 (ST) Description Entry required. The s
(ST) Description Entry required. The state abbreviation for the state associated with a zip code. Length 2 characters City/Town Code (CITYCD) Description A code representing the city associated with a zip code. Length 4 digits Edits Must be valid on the City Code Table (ZX0030). County Code (COUNTYCD) Description A code representing the county associated with a zip code. Length 2 digits Edits Must be valid on the County Code Table (ZX0040). Zip Status (EDITSTAT) Description Entry required. A code indicating the status of a zip code. Values Defined by SBCTCITD as follows: A Active (default) L Limited I Inactive D Delete Revision Date (RVSNDATE) Description Display only. A date assigned by the system indicating when the current record was changed or added. Data SetsAdditions and changes madeon this screen may update the following data sets:Zip Code Table (ZIPTB