SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
Default Value: BUS_UNIT_OPT_AR.FORMAT_CURRENCY
Prompt Table: CURRENCY_CD_TBL
F=First
L=Last
S=Specify
Default Value: F
Prompt Table: BUS_UNIT_TBL_AR
Prompt Table: CUST_BU_PP_VW
AR_PP_DTL_OPTNS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | 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: BUS_UNIT_OPT_AR.FORMAT_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 3 | INV_TOL_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | Invoice Tolerance Amount |
| 4 | INV_TOL_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Invoice Tolerance Percent |
| 5 | DISC_TOL_AMT | Number(16,2) | DECIMAL(15,2) NOT NULL | Tolerance Amount |
| 6 | DISC_TOL_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Discount Tolerance Percent |
| 7 | LAST_ENTRY_DATE | Date(10) | DATE | Last Entry Date |
| 8 | PP_CNTRL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Used in Payment Predictor tab, under Business Unit options
F=First L=Last S=Specify Default Value: F |
| 9 | PP_MAIN_BU | Character(5) | VARCHAR2(5) NOT NULL |
Main Control Account BU
Prompt Table: BUS_UNIT_TBL_AR |
| 10 | PP_MAIN_CUSTID | Character(15) | VARCHAR2(15) NOT NULL |
Main Control Account Custid
Prompt Table: CUST_BU_PP_VW |