AMIFCEDT_AET

(SQL Table)
Index Back

ComboEdit AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
5 PROCESSING_SEQ Number(5,0) INTEGER NOT NULL Processing Sequence
6 FROM_INTFC_ID Number(8,0) INTEGER NOT NULL From Interface ID
7 TO_INTFC_ID Number(8,0) INTEGER NOT NULL To Interface ID
8 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
9 LAST_ASSET_ID Number(12,0) DECIMAL(12) NOT NULL Last Asset ID Used
10 LAST_ASSET_ID_CHAR Character(12) VARCHAR2(12) NOT NULL
11 INCR_BY Signed Number(10,0) DECIMAL(9) NOT NULL Increment Number

Default Value: 1

12 PREV_INTFC_ID Number(8,0) INTEGER NOT NULL Previous Interface ID
13 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field for Hiding Groups
14 AMPHY_A_ROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.
15 AMPHY_A_ERR_ROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.
16 AMPHY_B_ROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.
17 AMLEASE_ROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.
18 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
19 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
20 DEFAULT_PROFILE_Y Character(1) VARCHAR2(1) NOT NULL Default Books from Profile

Default Value: N

21 DEFAULT_PROFILE_N Character(1) VARCHAR2(1) NOT NULL Default Books from Profile

Default Value: N

22 DEFAULT_PROFILE_G Character(1) VARCHAR2(1) NOT NULL Default Books from Profile

Default Value: N

23 DEFAULT_PROFILE_C Character(1) VARCHAR2(1) NOT NULL Default Books from Profile

Default Value: N

24 DEFAULT_PROFILE_B Character(1) VARCHAR2(1) NOT NULL Default Books from Profile

Default Value: N

25 CF_SEQNO_LAST Number(6,0) INTEGER NOT NULL Last Chartfield Sequence Numbe
26 IU_MAP_KEY Number(7,0) INTEGER NOT NULL InterUnit transfer map key
27 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
28 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
29 SETID_CAL_DETP Character(5) VARCHAR2(5) NOT NULL Calendar SetId
30 SETID_CONV_DT Character(5) VARCHAR2(5) NOT NULL Convention Detail SetId
31 SETID_DEPR_ALLOC Character(5) VARCHAR2(5) NOT NULL Depreciation Allocation SetId
32 SETID_DEPR_SCHED Character(5) VARCHAR2(5) NOT NULL Depreciation Schedule SetId
33 SETID_BOOK_DEFN Character(5) VARCHAR2(5) NOT NULL Book Definition SetId
34 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
35 SETID_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit SetId
36 SETID_PROFILE Character(5) VARCHAR2(5) NOT NULL Profile SetID
37 SETID_INV_ITEM Character(5) VARCHAR2(5) NOT NULL Inv Items SETID
38 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
39 RECNAME_PROFILEDET Character(15) VARCHAR2(15) NOT NULL Asset Book Profile - Detail
40 AMAUCTION_ROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.
41 RT_EFFDT Date(10) DATE The effective date for a given item of market rate data.
42 MULTI_CURR_FLAG Character(1) VARCHAR2(1) NOT NULL Multi-Currency
N=No
Y=Yes
43 FIRST_ROW Character(1) VARCHAR2(1) NOT NULL First Row
44 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes
45 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
46 PRIMARY_BOOK Character(10) VARCHAR2(10) NOT NULL AM Primary Book
47 LEDGERS_SYNC Character(1) VARCHAR2(1) NOT NULL Keep Ledgers in Sync
48 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index
49 BOOK_SEL Character(1) VARCHAR2(1) NOT NULL Book Select field for RowSel

Default Value: N

50 LED_GRP_DEFAULT Character(10) VARCHAR2(10) NOT NULL Default Journal Generator Ledger Group of a Business Unit
51 FLAG1 Character(1) VARCHAR2(1) NOT NULL Flag1
52 FLAG2 Character(1) VARCHAR2(1) NOT NULL Flag2
53 PROPERTY_ID Number(10,0) DECIMAL(10) NOT NULL Property ID
54 INSERT_LONG Long Character(4000) CLOB INSERT_LONG
55 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
56 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
57 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
58 CHART_EDIT_OPTION Character(1) VARCHAR2(1) NOT NULL Chartfield Edit Option
D=Default from Higher Level
K=Reject w/ edit error
N=No Edits
R=Recycle
S=Use suspense account
W=Warning
59 AMFIN_ERR_ROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.
60 AMFIN_ROWS Number(15,0) DECIMAL(15) NOT NULL Number of Rows fetched.