TAXGEOUPD_PARM(SQL Table) |
Index Back |
|---|---|
GeoCode Update Request Parm |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | RUN_DT | Date(10) | DATE | Run Date |
| 4 | RECORD_GEO_OWNER | Character(2) | VARCHAR2(2) NOT NULL |
Record Owner
AP=Accounts Payable BI=Billing OM=Order Management PO=Purchasing |
| 5 | RECNAME_GEO | Character(15) | VARCHAR2(15) NOT NULL |
Address Record for Geo Update
Prompt Table: %EDITTABLE |
| 6 | DEFAULT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Default Options
D=Default O=Override Default Value: O |
| 7 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 8 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 9 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 10 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 11 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 12 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 13 | AUTO_FILL | Character(1) | VARCHAR2(1) NOT NULL |
Auto Fill Address
N=NO Y=YES Default Value: N |
| 14 | PB_EXCEPTION_RPT | Character(1) | VARCHAR2(1) NOT NULL | Print Exception Report |
| 15 | UPD_GEO_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Update GEO Option
0=Upgrade 1=Specific Address Record 2=All Tax Address Records Default Value: 1 |
| 16 | GEO_SELECT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Geocode Select Option
0=Write to Exception Table 1=First in the List Default Value: 0 |