DMS_ITEM (SQL Table)	Index Back
Debt Management Services (DMS) Items stored in this table are automatically or manually to be referred to DMS.

DMS_ITEM

(SQL Table)

Debt Management Services (DMS)

Items stored in this table are automatically or manually to be referred to DMS.

Parent record: CUST_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BUARDS_NONVW

2 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: CUST_SRCH_VW
Set Control Field: BUSINESS_UNIT

3 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.

4 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line

5 REFERRAL_TYPE Character(4) VARCHAR2(4) NOT NULL Referral Type
P1.0=Passthrough
X1.0=Cross-Servicing
Default Value: X1.0

6 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

7 BAL_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code - Bal Amount

8 MANUALSELECTION Character(1) VARCHAR2(1) NOT NULL Manual Selection

9 SECURED_DEBT Character(1) VARCHAR2(1) NOT NULL Secured Debt
S=Secured
U=Unsecured

10 ADMIN_DEBT_CLASS Character(3) VARCHAR2(3) NOT NULL Admin. Debt Classification
EMA=Employee Advance
FEE=Fee
FIN=Fine
GRT=Grant
MSC=Miscellaneous Debt
OVP=Overpayment
PEN=Penalty

11 PROGRAM_ID Character(8) VARCHAR2(8) NOT NULL Program ID

12 SELECTED_FLAG Character(1) VARCHAR2(1) NOT NULL Selected Flag
N=Not Selected
Y=Seleted
Y/N Table Edit
Default Value: N

13 ADJUSTMENT_DT Date(10) DATE Adjustment Date

14 REFERRAL_DATE Date(10) DATE This date will be updated by the program when it is referred in the outbound file to DMS.It is used as key criteria in sending subsequent adjustment file

15 BAL_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Balance - Base Currency

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUARDS_NONVW
2	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: CUST_SRCH_VW Set Control Field: BUSINESS_UNIT
3	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
4	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
5	REFERRAL_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Referral Type P1.0=Passthrough X1.0=Cross-Servicing Default Value: X1.0
6	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
7	BAL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code - Bal Amount
8	MANUALSELECTION	Character(1)	VARCHAR2(1) NOT NULL	Manual Selection
9	SECURED_DEBT	Character(1)	VARCHAR2(1) NOT NULL	Secured Debt S=Secured U=Unsecured
10	ADMIN_DEBT_CLASS	Character(3)	VARCHAR2(3) NOT NULL	Admin. Debt Classification EMA=Employee Advance FEE=Fee FIN=Fine GRT=Grant MSC=Miscellaneous Debt OVP=Overpayment PEN=Penalty
11	PROGRAM_ID	Character(8)	VARCHAR2(8) NOT NULL	Program ID
12	SELECTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selected Flag N=Not Selected Y=Seleted Y/N Table Edit Default Value: N
13	ADJUSTMENT_DT	Date(10)	DATE	Adjustment Date
14	REFERRAL_DATE	Date(10)	DATE	This date will be updated by the program when it is referred in the outbound file to DMS.It is used as key criteria in sending subsequent adjustment file
15	BAL_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance - Base Currency