PC_REV_MNGMT (SQL Table)	Index Back
Billing and Revenue Summary Summary table resulting from the Billing and Revenue Management summary process. Rows are copied from PROJ_RESOURCE and summarized by Business Unit, Project, Activity, Customer, Contract Number, and General Ledger Distribution Status. Amounts are in transaction currencies. The process limits rows to analysis types included in the analysis groups 'PSREV', 'BLD', and 'UNBLD'.

PC_REV_MNGMT

(SQL Table)

Billing and Revenue Summary

Summary table resulting from the Billing and Revenue Management summary process. Rows are copied from PROJ_RESOURCE and summarized by Business Unit, Project, Activity, Customer, Contract Number, and General Ledger Distribution Status. Amounts are in transaction currencies. The process limits rows to analysis types included in the analysis groups 'PSREV', 'BLD', and 'UNBLD'.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

4 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

5 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

6 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.

7 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal

8 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code

9 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
3	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
4	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
5	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
6	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.
7	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal
8	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code
9	FOREIGN_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.