| # |
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 |
CRCARD_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Credit Card Profile ID
Prompt Table:
AR_CRCARD_PRFL
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 7 |
EXCL_FIN_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Overdue Charges
Y/N Table Edit
Default Value: N
|
| 8 |
EXCL_DISP_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Disputed Items
Y/N Table Edit
Default Value: N
|
| 9 |
EXCL_CREDIT_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Credit Items
Y/N Table Edit
Default Value: N
|
| 10 |
EXCL_CLCT_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Collection Items
Y/N Table Edit
Default Value: N
|
| 11 |
EXCL_CLCT_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Customers in Collection
Y/N Table Edit
Default Value: N
|
| 12 |
EXCL_DISP_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Customers in Dispute
Y/N Table Edit
Default Value: N
|
| 13 |
APPROVAL_DR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Debit Approval Limit
|
| 14 |
APPROVAL_CR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Credit Approval Limit
|
| 15 |
CC_APPROV_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Approval Currency
Default Value: BUS_UNIT_OPT_AR.FORMAT_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 16 |
CC_CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Exchange Rate Type
Default Value: BUS_UNIT_OPT_AR.RT_TYPE
Prompt Table:
RT_TYPE_TBL
|
| 17 |
CC_LOWER_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Low Value Lower Limit
|
| 18 |
CC_UPPER_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Low Value Upper Limit
|
| 19 |
WORKSHEET_CREATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Worksheet
A=No Action
B=Build Worksheet
C=Clear Worksheet
Y/N Table Edit
Default Value: N
|
| 20 |
WRITE_OFF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Write-Off Small Balance
Y/N Table Edit
Default Value: N
|
| 21 |
ENTRY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
|
| 22 |
REASON_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Reason Code
Prompt Table:
AUTO_RSN_WAU_VW
Set Control Field: SETID
|
| 23 |
ENTRY_TYPE_DB |
Character(5) |
VARCHAR2(5) NOT NULL |
Debit Entry Type
|
| 24 |
REASON_CODE_DB |
Character(4) |
VARCHAR2(4) NOT NULL |
Over Payment Reason Code
Prompt Table:
AUTO_RSN_WAO_VW
Set Control Field: SETID
|