| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 2 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 3 |
ST_ID_NUM |
Number(8,0) |
INTEGER NOT NULL |
Statement Number
|
| 4 |
MAX_ROWS_SCROLL |
Number(5,0) |
INTEGER NOT NULL |
Max Number of Rows in Scrolls
|
| 5 |
CHECK_PENDING_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
No Mult Pending Item Selection
Y/N Table Edit
Default Value: N
|
| 6 |
DUN_ID_NUM |
Number(8,0) |
INTEGER NOT NULL |
Dunning Number
|
| 7 |
OC_ID_NUM |
Number(8,0) |
INTEGER NOT NULL |
Overdue Charge Number
|
| 8 |
AR_IPAC |
Character(1) |
VARCHAR2(1) NOT NULL |
AR IPAC Interface
Y/N Table Edit
Default Value: N
|
| 9 |
AR_1099C_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
1099-c Reporting Option
Y/N Table Edit
Default Value: N
|
| 10 |
AR_DMS |
Character(1) |
VARCHAR2(1) NOT NULL |
DMS Interface
Y/N Table Edit
Default Value: N
|
| 11 |
AR_SF220_9 |
Character(1) |
VARCHAR2(1) NOT NULL |
Treasury Report On Receivables
Y/N Table Edit
Default Value: N
|
| 12 |
USE_MEMO_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Memo Status
Y/N Table Edit
Default Value: N
|
| 13 |
PARALLEL_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Parallel Processing Options
|
| 14 |
ACCT_OVW_OPTS_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Account Overview Balance Opts
|
| 15 |
SHOW_DED_BAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Deduction Balances
Default Value: Y
|
| 16 |
SHOW_DISPUTE_BAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Disputed Balances
Default Value: Y
|
| 17 |
SHOW_DOUBTFUL_BAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Doubtful Balances
Default Value: Y
|
| 18 |
SHOW_COLLECTN_BAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Collection Balances
Default Value: Y
|
| 19 |
SHOW_VENDOR_BAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Supplier Balances
Default Value: Y
|
| 20 |
SHOW_DRAFT_BAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Draft Balances
Default Value: Y
|
| 21 |
SHOW_HIGH_BAL_YTD |
Character(1) |
VARCHAR2(1) NOT NULL |
Show High Balance Year-to-date
Default Value: Y
|
| 22 |
SHOW_SALES_YTD |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Year-to-date Sales
Default Value: Y
|
| 23 |
SHOW_LY_SALES |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Last Years Sales
Default Value: Y
|
| 24 |
SHOW_CSTDEP_BAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Customer Deposit Balances
N=No
Y=Yes
|
| 25 |
COLLECT_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Collection Owner
Default Value: N
|
| 26 |
CREDIT_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Owner
Default Value: N
|
| 27 |
OTHER_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Other Owner
Default Value: N
|
| 28 |
 ALLOW_ESCALATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Esculation Flag
Y/N Table Edit
Default Value: N
|
| 29 |
CR_DISPUTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Disputed
Y/N Table Edit
Default Value: N
|
| 30 |
CR_INPROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit In Process
Y/N Table Edit
Default Value: N
|
| 31 |
CR_UNAPPLIED |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Unapplied
Y/N Table Edit
Default Value: N
|
| 32 |
MONITOR_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
Monitor Business Unit
Y/N Table Edit
Default Value: N
|
| 33 |
ASSN_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.
Prompt Table:
OPRID_VW
|
| 34 |
AR_INDIA_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable AR India Taxes
Y/N Table Edit
Default Value: N
|
| 35 |
TRACK_DJRNL_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Track Direct Journal Customer
Y/N Table Edit
Default Value: N
|
| 36 |
UNPOST_REASON |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason code for Unposted groups. For informational purposes.
Y/N Table Edit
Default Value: N
|
| 37 |
AR_CTA |
Character(1) |
VARCHAR2(1) NOT NULL |
CTA flag for AR
Y/N Table Edit
Default Value: N
|
| 38 |
AR_FULL_HIERARCHY |
Character(1) |
VARCHAR2(1) NOT NULL |
AR_FULL_HIERARCHY CHAR 1
Y/N Table Edit
Default Value: N
|
| 39 |
HIERARCHY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Hierarchy Type
C=Corporate
R=Remit From
Default Value: R
|
| 40 |
MULT_PAYMENTS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Payments for One Item
Y/N Table Edit
Default Value: N
|
| 41 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 42 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 43 |
AR_DEL_ATT_AUTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorize Delete Attachments
Y/N Table Edit
|
| 44 |
OVERRIDE_FROMEMAIL |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Send From Email
Y/N Table Edit
Default Value: N
|