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 |