TAXGEOUPD_AET

(SQL Table)
 Index Back

Geocode Update AET Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
3 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
6 RUN_DT Date(10) DATE Run Date
7 RECORD_GEO_OWNER Character(2) VARCHAR2(2) NOT NULL Record Owner
AP=Accounts Payable
BI=Billing
OM=Order Management
PO=Purchasing
8 RECNAME_GEO Character(15) VARCHAR2(15) NOT NULL Address Record for Geo Update
9 DEFAULT_OPT Character(1) VARCHAR2(1) NOT NULL Default Options
D=Default
O=Override

Default Value: O

10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

11 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
12 CITY Character(30) VARCHAR2(30) NOT NULL City
13 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
14 COUNTY Character(30) VARCHAR2(30) NOT NULL County
15 COUNTY_OTHER Character(30) VARCHAR2(30) NOT NULL County Other
16 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

17 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other
18 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
19 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

20 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
21 TAX_VENDOR Character(1) VARCHAR2(1) NOT NULL Tax Provider
A=Taxware
N=None
V=Vertex
22 AUTO_FILL Character(1) VARCHAR2(1) NOT NULL Auto Fill Address
N=NO
Y=YES
23 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
24 UPD_GEO_OPT Character(1) VARCHAR2(1) NOT NULL Update GEO Option
0=Upgrade
1=Specific Address Record
2=All Tax Address Records
25 GEO_SELECT_OPT Character(1) VARCHAR2(1) NOT NULL Geocode Select Option
0=Write to Exception Table
1=First in the List
26 TAX_UPGRADE_STATUS Character(1) VARCHAR2(1) NOT NULL Tax Vendor Upgrade Status
0=Not Run or Not Successful
1=Successful
9=Upgrade Not Necessary
27 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
28 RECALIAS Character(15) VARCHAR2(15) NOT NULL Record Alias
29 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
30 SQL_STMT_800 Long Character(800) VARCHAR2(800) SQL_Stmt_800
31 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine
32 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
33 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
34 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
35 KEY1_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 1 Field Value
36 KEY2_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 2 Field Value
37 KEY3_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 3 Field Value
38 KEY4_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 4 Field Value
39 KEY5_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 5 Field Value
40 KEY6_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Created by MLE
41 KEY7_FLD_VAL Character(50) VARCHAR2(50) NOT NULL Key 7 Field Value
42 RPT_FIELDVALUE_01 Character(30) VARCHAR2(30) NOT NULL Name of Field
43 RPT_FIELDVALUE_02 Character(30) VARCHAR2(30) NOT NULL Name of Field
44 RPT_FIELDVALUE_03 Character(30) VARCHAR2(30) NOT NULL Name of Field
45 RPT_FIELDVALUE_04 Character(30) VARCHAR2(30) NOT NULL Name of Field
46 RPT_FIELDVALUE_05 Character(30) VARCHAR2(30) NOT NULL Name of Field
47 RPT_FIELDVALUE_06 Character(30) VARCHAR2(30) NOT NULL Name of Field
48 RPT_FIELDVALUE_07 Character(30) VARCHAR2(30) NOT NULL Name of Field
49 SQL_TEXT Character(254) VARCHAR2(254) NOT NULL SQL Text
50 FLDC1A Character(35) VARCHAR2(35) NOT NULL Sel Comp 1 CHAR Field, NameA
51 FLDC2A Character(35) VARCHAR2(35) NOT NULL Sel Comp 2 CHAR Field, Value A
52 FLDC3A Character(35) VARCHAR2(35) NOT NULL Sel Comp 3 CHAR Field, Value A
53 FLDC4A Character(35) VARCHAR2(35) NOT NULL Sel Comp 4 CHAR Field, Value A
54 FLDC5A Character(35) VARCHAR2(35) NOT NULL Sel Comp 5 CHAR Field, Value A
55 FLDC6A Character(35) VARCHAR2(35) NOT NULL Sel Comp 6 CHAR Field, Value A
56 FLDC7A Character(35) VARCHAR2(35) NOT NULL Sel Comp 7 CHAR Field, Value A
57 EFFDT Date(10) DATE Effective Date

Default Value: %date

58 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
59 SELECT_CLAUSE Character(254) VARCHAR2(254) NOT NULL Select Clause
60 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
61 SQLROWS Number(5,0) INTEGER NOT NULL SQL Rows
62 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause
63 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
64 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Fieldname 2
65 FIELDNAME3 Character(18) VARCHAR2(18) NOT NULL Field Name
66 FIELDNAME4 Character(18) VARCHAR2(18) NOT NULL Field Name
67 FIELDNAME5 Character(18) VARCHAR2(18) NOT NULL Field Name
68 FIELDNAME6 Character(18) VARCHAR2(18) NOT NULL Field Name
69 FIELDNAME7 Character(18) VARCHAR2(18) NOT NULL Field Name
70 COUNTRY3 Character(3) VARCHAR2(3) NOT NULL Country
71 CITY3 Character(30) VARCHAR2(30) NOT NULL City
72 STATE3 Character(6) VARCHAR2(6) NOT NULL State
73 USE_LOC_COUNTY Character(30) VARCHAR2(30) NOT NULL Use location county
74 POSTAL3 Character(12) VARCHAR2(12) NOT NULL Postal Code
75 IN_CITY_LMT_OTHER Character(1) VARCHAR2(1) NOT NULL In City Limit Other
76 POSTAL4 Character(12) VARCHAR2(12) NOT NULL Postal Code