| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SVC_OPER_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Operation Group
CGRP=Inbound Customer Group
CONT=Inbound Contact
CUST=Inbound Customer
FCNT=Federal Registry - Contacts
FCST=Federal Registry - Customers
PCST=Inbound Pension Customer
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 3 |
DFLT_BEG_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Use default Start Sequence
D=Do Not Use Auto Numbering
N=Select Start Sequence
Y=Use Default Start Sequence
Default Value: D
|
| 4 |
BEG_SEQ |
Character(3) |
VARCHAR2(3) NOT NULL |
Beginning Sequence
Prompt Table:
%EDITTABLE
|
| 5 |
ZERO_PAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Zero Pad
Y/N Table Edit
Default Value: N
|
| 6 |
SUPPORT_TEAM_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Support Team Code
Prompt Table:
TEAMCD_SI_EF_VW
|
| 7 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 8 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 9 |
CR_ANALYST |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
Prompt Table:
CRANAL_SI_EF_VW
|
| 10 |
COLLECTOR |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
Prompt Table:
COLL_SI_EF_VW
|
| 11 |
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
Default Value: CHK
|
| 12 |
PARTIAL_PY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Payment Switch
Y/N Table Edit
Default Value: N
|
| 13 |
PP_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Predictor Hold
Y/N Table Edit
Default Value: Y
|
| 14 |
PP_METHOD |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment Predictor Method
Prompt Table:
PP_MET_TBL
|
| 15 |
ASSESS_OC_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Assess Overdue Charges
Y/N Table Edit
Default Value: N
|
| 16 |
OC_GROUP |
Character(2) |
VARCHAR2(2) NOT NULL |
Overdue Charge Group
%=All Overdue Charge Groups
A=Group A
B=Group B
C=Group C
D=Group D
|
| 17 |
OC_ADMIN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Overdue Charge Admin ID
Prompt Table:
OC_ADMIN_VW
|
| 18 |
OC_FIN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Overdue Charge Finance ID
Prompt Table:
OC_FIN_VW
|
| 19 |
OC_PNLTY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Overdue Charge Penalty ID
Prompt Table:
OC_PNLTY_VW
|
| 20 |
OC_ADMIN_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Overdue Charge Admin Hold
Y/N Table Edit
Default Value: Y
|
| 21 |
OC_FIN_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Overdue Charge Finance Hold
Y/N Table Edit
Default Value: Y
|
| 22 |
OC_PNLTY_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Overdue Charge Penalty Hold
Y/N Table Edit
Default Value: Y
|
| 23 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 24 |
DATE_LAST_MAINT |
Date(10) |
DATE |
Date Last Maintained
|
| 25 |
MESSAGE_DESCR |
Long Character |
CLOB |
Affected Transactions
|