| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
Set Control Field: SETID
|
| 2 |
DUN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Dunning ID
Prompt Table:
DUNNING_TBL
|
| 3 |
OC_ADMIN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Overdue Charge Admin ID
Prompt Table:
OC_ADMIN_VW
|
| 4 |
OC_PNLTY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Overdue Charge Penalty ID
Prompt Table:
OC_PNLTY_VW
|
| 5 |
OC_FIN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Overdue Charge Finance ID
Prompt Table:
OC_FIN_VW
|
| 6 |
FC_DOC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Fin Chg Document Identifier
|
| 7 |
ST_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Statement ID
Prompt Table:
STATEMENT_TBL
|
| 8 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_AR_BR_VW
|
| 9 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table:
BANK_AR_R_VW
|
| 10 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table:
AR_TRMS_VW
|
| 11 |
GRACE_DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Due Grace Days
|
| 12 |
GRACE_DISC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Discount Grace Days
|
| 13 |
RETENTION_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Closed Item Retention Days
|
| 14 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
CAL_DETL_VW
|
| 15 |
AGING_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Aging ID
Prompt Table:
AGING_TBL
|
| 16 |
PP_METHOD |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment Predictor Method
Prompt Table:
PP_MET_TBL
|
| 17 |
CALC_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
The calculation data horizons for a given data set within the Position tools.
Prompt Table:
CALC_PER_AR_VW
|
| 18 |
CALC_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
The calculation year for a given data set within the Position tools.
Prompt Table:
CAL_DOFY_VW
|
| 19 |
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
|
| 20 |
REF_QUALIFIER_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Reference Qualifier Code
Prompt Table:
AR_FLD_REF_TBL
|
| 21 |
DED_DUE_DATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Deduction Due Date
D=Acctng Dt
I=Item Date
Default Value: D
|
| 22 |
TRANSFER_DATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Transfer Date
A=Item Date
S=System
|
| 23 |
PAYMENT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
Prompt Table:
AR_PAY_MTHD_VW
|
| 24 |
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.
Prompt Table:
CURRENCY_CD_TBL
|
| 25 |
SYNC_BUDGET_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate whether to use the same budget date for both recognized and collected bucket
N=No
Y=Yes
Default Value: Y
|
| 26 |
AR_SOURCE_TRAN |
Character(10) |
VARCHAR2(10) NOT NULL |
Transaction Type
Prompt Table:
AR_SRCTRN_RE_VW
|
| 27 |
AR_SOURCE_TRAN_DJ |
Character(10) |
VARCHAR2(10) NOT NULL |
Misc Payment Transaction Type
Prompt Table:
AR_SRCTRN_DJ_VW
|
| 28 |
PARTIAL_PY_DIS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Payment Disabled SW
Y/N Table Edit
Default Value: N
|
| 29 |
USE_AR_DSP_CUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Its value means whether or not use a Display Currency in AR.
N=NO
Y=YES
Default Value: N
|
| 30 |
DISPLAY_CUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Currency
B=Business Unit Currency
C=Customer Default Currency
O=Other
Default Value: B
|
| 31 |
DSP_CUR_CD_INQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Inquire Display Currency Code
Prompt Table:
CURRENCY_CD_TBL
Set Control Field: CURRENCY_CD
|
| 32 |
DC_RT_TYPE_INQ |
Character(5) |
VARCHAR2(5) NOT NULL |
Inquire Rate Type
Prompt Table:
RT_TYPE_TBL
Set Control Field: RT_TYPE
|
| 33 |
DSP_CUR_CD_WSH |
Character(3) |
VARCHAR2(3) NOT NULL |
Worksheet Disp. Currency Code
Prompt Table:
CURRENCY_CD_TBL
Set Control Field: CURRENCY_CD
|
| 34 |
DC_RT_TYPE_WSH |
Character(5) |
VARCHAR2(5) NOT NULL |
Worksheet Rate Type
Prompt Table:
RT_TYPE_TBL
Set Control Field: RT_TYPE
|
| 35 |
EFFDT_OPT_WSH |
Character(1) |
VARCHAR2(1) NOT NULL |
Worksheet Effect. Date Option
A=Accounting Date
O=Other
T=As of Today
Default Value: T
|
| 36 |
RVL_PROCESS_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
This field provides options to process Revaluation in the AR product. The processing level can be chosen to revaluate at Business Unit, Cust ID or ITEM level.
B=Business Unit
C=Customer ID
I=Item
|
| 37 |
HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
Default Value: N
|
| 38 |
HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before/after Holiday
|
| 39 |
HOL_PROC_OVERFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow due date in next month
Default Value: Y
|
| 40 |
BILLING_ALC |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Agency Location Code
Prompt Table:
AGENCY_LOC_CD
|
| 41 |
RECEIVABLE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Receivable Type code for SF220 Reporting
Prompt Table:
REC_TYPE_TBL
|
| 42 |
ENTITY_CODE |
Character(9) |
VARCHAR2(9) NOT NULL |
Entity Code for SF 220 Reporting
Prompt Table:
ENTITY_TBL
|
| 43 |
MRL_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Revenue Line
N=No Manual Distribution
Y=Allow Manual Distribution
Default Value: Y
|
| 44 |
ACCOUNTING_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Date Option
A=All
S=Some
V=Value
Y/N Table Edit
Default Value: N
|
| 45 |
AR_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Accounts Recievable Specialist - person responsible for an action on an item.
Prompt Table:
AR_SPECIALST_VW
|
| 46 |
ORDER_NO_UPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Number Update
Default Value: N
|
| 47 |
PO_UPD |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Number Update
Default Value: N
|
| 48 |
CONTRACT_NO_UPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Number Update
Default Value: N
|
| 49 |
AUTOMNT_METHOD |
Character(15) |
VARCHAR2(15) NOT NULL |
Automatic Maintenance Method
Prompt Table:
AUTOMNT_MET_TBL
|
| 50 |
MATCH_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Across Business Units
|
| 51 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
Default Value: G
|
| 52 |
VAT_SVC_PERFRM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
Default Value: 1
|
| 53 |
MAX_WRITE_OFF_AMT |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Maximum amount allowed for write off on worksheet
|
| 54 |
MAX_WRITE_OFF_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Write off Tolerance Days from Deduction date
|
| 55 |
MAX_WRITE_OFF_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Write off Tolerance Percentage of amount
|
| 56 |
IPAC_SENDER_DO |
Character(5) |
VARCHAR2(5) NOT NULL |
Sender Disbursing Office
|
| 57 |
DEDUCTION_STATUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Deduction Status
C=Closed
I=In Process
O=Created/Opened
W=On Worksheet
Prompt Table:
DEDUCTION_TBL
|
| 58 |
CHART_EDIT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Chartfield Edit Option
D=Default from Higher Level
K=Reject w/ edit error
N=No Edits
R=Recycle
S=Use suspense account
W=Warning
Default Value: K
|
| 59 |
COMBO_EDIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Combinations
|
| 60 |
BUDGET_DT_OVER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Date Override
Y/N Table Edit
Default Value: N
|
| 61 |
PRENOTE_WAIT_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Prenote Wait Days (U.S.)
|
| 62 |
AR_WO_WF_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Write-Off Workflow
N=Disabled
Y=Enabled
Default Value: N
|
| 63 |
AR_WO_RF_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Refund Workflow
N=Disabled
Y=Enabled
Default Value: N
|
| 64 |
AR_ZERO_PY_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Zero Amount Payments in Deposit Entry.
N=Disabled
Y=Enabled
Default Value: N
|
| 65 |
AR_REF_DJ_ENABLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Reference in Direct Journal.
N=Disabled
Y=Enabled
|
| 66 |
ORIGIN_ID_PENSION |
Character(5) |
VARCHAR2(5) NOT NULL |
Pension Origin ID
Prompt Table:
ORIGIN_P_EXT_VW
|
| 67 |
GROUP_TYPE_PENSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.
Prompt Table:
GROUP_TYPE_I_VW
|
| 68 |
PAYMENT_PLN_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Plan Options
|
| 69 |
MAXIMUM_INSTALL |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Installemnts
|
| 70 |
MIN_SOURCE_BAL |
Number(10,0) |
DECIMAL(10) NOT NULL |
Minimum Source Balance
|
| 71 |
PLAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan type
A=Custom
C=Fixed Monthly Amounts
D=Number of Months
Default Value: D
|
| 72 |
PROCESSING_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing fee
F=Fixed Amount
P=Percentage of Plan Balance
Default Value: F
|
| 73 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 74 |
VIEW_STMT_IMAG_CWB |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to determine if Statment Images will be generated to be displayed as attachment at Collection Workbench in Receivables
N=No
Y=Yes
Default Value: Y
|
| 75 |
AR_WO_CF_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used to enable/disable ChartField override for write-offs.
N=Disabled
Y=Enabled
Default Value: N
|
| 76 |
DISP_ITEM_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Disputed Items Option
N=No
Y=Yes
|
| 77 |
VIEW_DUN_IMAG_CWB |
Character(1) |
VARCHAR2(1) NOT NULL |
View Dunning Image
N=No
Y=Yes
Default Value: Y
|
| 78 |
AR_CONTRCT_MSG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Notify if Revenue Missing
Y/N Table Edit
Default Value: N
|
| 79 |
IPAC_SUBCATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
IPAC Transaction Subcategory Code
A1=Buy/Sell
A2=Expenditure Non-Exch
A3=Custodial Exchange
A4=Custodial Non-Exch
A5=Capital
A6=Benefits
A7=Investments
A8=Borrowings
A9=Other
|
| 80 |
AR_FROM_EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
From Email Address
|