AP_CFOP_AET

(SQL Table)
Index Back

CFO Portal AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
3 TMP_FLD Character(1) VARCHAR2(1) NOT NULL Field for holding temp data
4 FROM_DATE Date(10) DATE From Date
5 TO_DATE Date(10) DATE To Date
6 COUNT_1 Number(3,0) SMALLINT NOT NULL Count Work Field
7 COUNT_2 Number(3,0) SMALLINT NOT NULL Count Work Field
8 FROM_YEAR Number(4,0) SMALLINT NOT NULL From Year
9 TO_YEAR Number(4,0) SMALLINT NOT NULL To Year
10 START_YEAR Signed Number(5,0) DECIMAL(4) NOT NULL Start Year
11 FROM_MONTH Number(2,0) SMALLINT NOT NULL From Month
12 TO_MONTH Number(2,0) SMALLINT NOT NULL To Monthly View
13 MONTH_START Number(3,0) SMALLINT NOT NULL month start
14 PERIOD_AP Character(6) VARCHAR2(6) NOT NULL Period
15 CURRENCY_CD_IN Character(3) VARCHAR2(3) NOT NULL Inventory GL Base Currency
16 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.