AGE_REQUEST_TMP

(SQL Table)
Index Back

Aging Program Work Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
4 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
5 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
6 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once
7 PROCESS_SUBCUST Character(1) VARCHAR2(1) NOT NULL Process Sub Customer
8 RUN_DT Date(10) DATE Run Date
9 AGING_ID Character(5) VARCHAR2(5) NOT NULL Aging ID
10 SETID Character(5) VARCHAR2(5) NOT NULL SetID
11 EFFDT Date(10) DATE Effective Date
12 BASIS_DT Character(1) VARCHAR2(1) NOT NULL Basis Date
A=As Of Date
D=Due Date
G=Acctg Date
I=Item Date
13 DISPUTE_AGING Character(1) VARCHAR2(1) NOT NULL Dispute Aging
A=Normal
C=Categorize
D=Vary by Disp Status
X=Exclude
14 DISPUTE_CATEGORY Character(2) VARCHAR2(2) NOT NULL Dispute Category