RMC18_SETUP_DTL (SQL Table)	Index Back
Reimbursable Agreement Detail Reimbursable Agreement Setup Details

RMC18_SETUP_DTL

(SQL Table)

Reimbursable Agreement Detail

Reimbursable Agreement Setup Details

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
Prompt Table: GL_ACCOUNT_TBL

4 RMC18_ACCT_TYPE Character(1) VARCHAR2(1) NOT NULL Reimbursable Agreement Amount
1=Advanced Amount
2=Advanced Amount Remaining
3=Billed Amount
4=Earned Amount
5=Unbilled Amount
6=Obligated Amount
7=Expended Amount
8=Collected Amount
9=Committed Amount
A=Apportioned Amount

5 RMC18_ACCT_ACTION Character(1) VARCHAR2(1) NOT NULL Account Action
1=Add Amounts from Account
2=Deduct Amounts from Account
Default Value: 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCOUNT_TBL
4	RMC18_ACCT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Reimbursable Agreement Amount 1=Advanced Amount 2=Advanced Amount Remaining 3=Billed Amount 4=Earned Amount 5=Unbilled Amount 6=Obligated Amount 7=Expended Amount 8=Collected Amount 9=Committed Amount A=Apportioned Amount
5	RMC18_ACCT_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Account Action 1=Add Amounts from Account 2=Deduct Amounts from Account Default Value: 1