ARFO_PRFAGI_CGR (SQL Table)	Index Back
Cust Aging - Cust Group list AR Financial Operation Customer Aging - Customer Group selection list

ARFO_PRFAGI_CGR

(SQL Table)

Cust Aging - Cust Group list

AR Financial Operation Customer Aging - Customer Group selection list

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: ARFO_PRF_AGING.OPRID

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETCU_NONVW

3 CUST_GRP_TYPE Character(4) VARCHAR2(4) NOT NULL Customer Group Type
ACCT=Accounting
ALOC=Allocation Group
BO=Backorder/Reservations
CDT=Canceled Debt Reporting
CLMB=Claimback Contract
COLL=Collection
DD=Direct Debit
DRFT=Draft
FCST=Forecasting
FRT=Freight
PBIL=Pay/Bill Management
PRC=Pricing
PRUL=Pricing Arbitration Plan
RPT=Reporting
SCON=Buying Agreement
SSRC=Alternate Sources Of Supply
TAX=Tax
TRPT=Transportation
Prompt Table: CUST_CGRP_TP_VW

4 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
Prompt Table: CUST_CGRP_GP_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: ARFO_PRF_AGING.OPRID
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETCU_NONVW
3	CUST_GRP_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Customer Group Type ACCT=Accounting ALOC=Allocation Group BO=Backorder/Reservations CDT=Canceled Debt Reporting CLMB=Claimback Contract COLL=Collection DD=Direct Debit DRFT=Draft FCST=Forecasting FRT=Freight PBIL=Pay/Bill Management PRC=Pricing PRUL=Pricing Arbitration Plan RPT=Reporting SCON=Buying Agreement SSRC=Alternate Sources Of Supply TAX=Tax TRPT=Transportation Prompt Table: CUST_CGRP_TP_VW
4	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group Prompt Table: CUST_CGRP_GP_VW