ARFO_PRF_DBTIT(SQL Table) |
Index Back |
|---|---|
Doubtful Items User PreferenceAR Financial Operation Doubtful Items User Preference |
| # | 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 | BU_SELECT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Business Units
A=All S=Specific Default Value: A |
| 3 | DISPLAY_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Display Currency
Prompt Table: CURRENCY_CD_TBL |
| 4 | DSP_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Rate Type
Prompt Table: RT_TYPE_TBL |
| 5 | RT_RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL | Market Rate Index |
| 6 | CUST_SELECT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Customer Select Flag
A=All G=Customer Groups S=Specific Default Value: A |
| 7 | CUST_LEVEL_QRY | Character(1) | VARCHAR2(1) NOT NULL |
Customer Level
C=Corporate N=No Relationship P=Correspondence R=Remit From Default Value: N |
| 8 | CUSTOMER_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Customer SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETCU_NONVW |
| 9 | BLK_CUST_GRP | Character(1) | VARCHAR2(1) NOT NULL |
Include Blank Customer Group
N=NO Y=YES Default Value: N |
| 10 | TRANS_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Currency
Prompt Table: CURRENCY_CD_TBL |
| 11 | RESP_PART_OPT | Character(1) | VARCHAR2(1) NOT NULL |
RESP_PART_OPT
A=AR Specialist B=Broker C=Collector R=Credit Analyst S=Sales Person Default Value: C |
| 12 | RESP_ALL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
All Flag
A=All S=Specific Default Value: A |
| 13 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |