SUBJECT_DTL_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	CONVER_SUBJECT	Character(30)	VARCHAR2(30) NOT NULL	Conversation Subject
3	BUSINESS_TRANS	Character(2)	VARCHAR2(2) NOT NULL	Business Transaction AR=Accounts Receivable BI=Billing DM=Deduction Management ES=EStore OM=Order Management
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	CONVER_SUB_TOPIC	Character(30)	VARCHAR2(30) NOT NULL	Subject Topic Prompt Table: SUB_TOPIC_TBL
6	CONVR_QUALIFIER_CD	Character(2)	VARCHAR2(2) NOT NULL	Conversation Qualifier Code BA=Buy Agremt BI=Invoice # CP=Cust Pay CT=Contract D=Document I=Item L=Lading P=PO Number PY=Payment ID QU=Quote RM=RMA SC=Case Num SO=Sale Order
7	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: ROLEUSER_VW
8	LOGGED_IN	Character(1)	VARCHAR2(1) NOT NULL	Use in eBill Payment Y/N Table Edit
9	SHORT_PAY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Short Pay N=No Y=Yes Default Value: N
10	ACTION_CODE	Character(4)	VARCHAR2(4) NOT NULL	Action Code ALRT=Alert CALL=Call the Customer CRDT=Review Customer Credit Limit DLTR=Dunning Letter DNGD=Downgrade Credit Rating FEBN=Follow up eBill Note HOLD=Place Customer on Hold OLTR=Send Other Letter POD=Proof of Delivery PRBK=Review Broken Promise Date PRFO=Review Promise Date REFR=Refer to Collection Agency STMT=Send Statement of Account WOFF=Write off Customer Balance Prompt Table: AR_ACTN_CD_DVW
11	ACTION_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Action Owner Prompt Table: AR_OPRID_DVW