OPR_DEF_TBL_AR(SQL Table) |
Index Back |
|---|---|
Operator Defaults - PS/AROperator Defaults - PS/AR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID Prompt Table: OPRID_VW |
| 2 | GROUP_BU | Character(5) | VARCHAR2(5) NOT NULL |
Represents the high level grouping of multiple general ledger business units.
Prompt Table: SP_BU2AR_NONVW |
| 3 | DEPOSIT_BU | Character(5) | VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
Prompt Table: SP_BU2AR_NONVW |
| 4 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 5 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 6 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 7 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 8 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 9 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 10 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 11 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 12 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
| 13 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 14 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 15 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 16 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 17 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: %EDIT_STATE |
| 18 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 19 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 20 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 21 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Int'l Prefix |
| 22 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 23 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Phone Extension |
| 24 | FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |
| 25 | ALT_NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Alternate Name 1 |
| 26 | ALT_NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Alternate Name 2 |
| 27 | DISC_TOLER_PERCENT | Number(2,0) | SMALLINT NOT NULL | Discount Tolerance Percent |
| 28 | DISC_TOLER_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Discount Tolerance |
| 29 | WO_PERCENT_UNDER | Number(2,0) | SMALLINT NOT NULL | Write Off Percent Under |
| 30 | WO_AMT_UNDER | Number(27,3) | DECIMAL(26,3) NOT NULL | Underpayment Write-Off |
| 31 | WO_PERCENT_OVER | Number(2,0) | SMALLINT NOT NULL | Write Off Percent Over |
| 32 | WO_AMT_OVER | Number(27,3) | DECIMAL(26,3) NOT NULL | Overpayment Write-Off |
| 33 | PAY_WS_WO_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Item Write-Off |
| 34 | MAX_WRITE_OFF_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Maximum amount allowed for write off on worksheet |
| 35 | MAX_REFUND_AMT | Number(27,3) | DECIMAL(26,3) NOT NULL | Maximum Refund Amount |
| 36 | MAX_WRITE_OFF_DAYS | Number(3,0) | SMALLINT NOT NULL | Write off Tolerance Days from Deduction date |
| 37 | MAX_WRITE_OFF_PCT | Number(3,0) | SMALLINT NOT NULL | Write off Tolerance Percentage of amount |
| 38 | WS_WOT_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Override Write off Tolerance
Y/N Table Edit |
| 39 | FORMAT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the currency that controls the precision of the amount totals for a group of pending items. If CONTROL_CURRENCY is entered then the same currency code should be used here.
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 40 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 41 | PHONE_PREFIX | Character(40) | VARCHAR2(40) NOT NULL | Dialing Prefix |
| 42 | PHONE_SUFFIX | Character(40) | VARCHAR2(40) NOT NULL | Dialing Suffix |
| 43 | AREA_CODE | Character(3) | VARCHAR2(3) NOT NULL | Dialing Area Code |
| 44 | COM_PORT | Character(1) | VARCHAR2(1) NOT NULL |
Communications Port
1=Comm Port 1 2=Comm Port 2 3=Comm Port 3 4=Comm Port 4 Default Value: 1 |
| 45 | AREA_CODE_AUTO | Character(1) | VARCHAR2(1) NOT NULL |
Automatic Area Code
1=1 + Auto N=Not Used Y=Auto Default Value: N |