| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
CONDITION_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Condition ID
ACLA=Approaching Credit Limit
ACLD=Approaching Credit Limit Exp
CCEX=Approaching CC expiration date
CCHD=Cancel Credit Hold
CFLU=Conversation Follow Up
CHLD=Credit Hold Code Exists
COLL=Collection
CPDB=Customer Promise Date Broken
CPDR=Customer Promise Date Review
DEDN=Deduction Item
DISP=Disputed Item
EBIL=eBill selection by user
ECLA=Exceeded Credit Limit
ECLD=Exceed CR Limit Expiration Dt
ETRC=Entry Type / Reason Code
KSTE=Key Statistics Exceeded
LACD=Large Amount Coming Due
ONLN=Online selection by user
RISK=Risk Score
WBDC=Welcome Back Dormant Customer
WCNC=Welcome New Customer
|
| 3 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table:
CUSTOMER
|
| 4 |
CUSTOMER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer Group
Prompt Table:
CUST_CGRP_LNK
|
| 5 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 6 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 7 |
RULE_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Rule Level
C=Customer
G=Customer Group
S=SetID
|
| 8 |
SCHEDULE |
Character(10) |
VARCHAR2(10) NOT NULL |
Schedule ID
Prompt Table:
SCHEDULE_TBL
|
| 9 |
COND_OWNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Condition Owner
A=Credit Analyst
C=Collector
R=AR Specialist
S=Sales Person
|
| 10 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 11 |
DAY_AMOUNT_CHECK |
Character(1) |
VARCHAR2(1) NOT NULL |
Day/Amount Check
A=Amount Check
D=Days Check
N=No Check
|
| 12 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CUR_CD_ALL_VW
|
| 13 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 14 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 15 |
LAST_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a transaction was last modified
|
| 16 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 17 |
EXCL_CLCT_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Collection Items
Y/N Table Edit
Default Value: N
|
| 18 |
EXCL_DISP_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Disputed Items
Y/N Table Edit
Default Value: N
|
| 19 |
EXCL_CREDIT_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Credit Items
Y/N Table Edit
Default Value: N
|
| 20 |
EXCL_DED_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Deduction Items
Y/N Table Edit
|
| 21 |
EXCL_SMALL_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Items <
Y/N Table Edit
Default Value: N
|
| 22 |
CANCEL_CLCT_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Collection Customer
Y/N Table Edit
Default Value: N
|
| 23 |
CANCEL_DISP_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Is In Dispute
Y/N Table Edit
Default Value: N
|
| 24 |
CANCEL_CREDIT_TOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Has Credit Total
Y/N Table Edit
Default Value: N
|
| 25 |
CANCEL_SMALL_TOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Total <
Y/N Table Edit
Default Value: N
|
| 26 |
DOCUMENT_MINIMUM |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Document Minimum
|
| 27 |
DOC_MIN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Statements Document Minimum Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 28 |
ITEM_MINIMUM |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Item Minimum Amount
|
| 29 |
ITEM_MIN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Statements Item Minimum Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 30 |
INCLUDE_FC |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Finance Charge
Y/N Table Edit
Default Value: N
|
| 31 |
GRACE_DUN_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Grace days for dunning.
|
| 32 |
EXCL_GRACE_CR_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Grace Days to Cred Items
Y/N Table Edit
Default Value: N
|