APS_OUT_AET

(SQL Table)
Index Back

Temp record for Msg Pub Driver

# 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 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
6 STARTDATETIME DateTime(26) TIMESTAMP Start Datetime
7 ENDDATETIME DateTime(26) TIMESTAMP End Datetime
8 CURRENT_DATE1 Date(10) DATE 12/20/01 EGS (CN#PL900-1): Added 10/07/02 JC (CN#PL880-1): Added FROM_DATE label
9 CURRENT_OPT Character(1) VARCHAR2(1) NOT NULL 08/07/02 EGS (CN#PL880-1): Added. 10/18/02 JC (CN#PL880-1):Added FROM label
1=Date
2=Offset

Default Value: 2

10 CURRENT_OFFSET Signed Number(6,0) DECIMAL(5) NOT NULL 09/05/01 EGS (CN#PL900-1): Added. 10/07/02 JC (CN#PL880-1): Added FROM_OFFSET label
11 START_OFFSET Signed Number(6,0) DECIMAL(5) NOT NULL Start Fence

Default Value: -30

12 START_DT Date(10) DATE Start Date
13 END_OFFSET Signed Number(6,0) DECIMAL(5) NOT NULL End Fence

Default Value: 365

14 END_DT Date(10) DATE End Date
15 APS_HIST_OFFSET Signed Number(6,0) DECIMAL(5) NOT NULL History Start Offset
16 HIST_START_DT Date(10) DATE Historical Start Date
17 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
18 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
19 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

Prompt Table: SP_SETID_NONVW

20 INCL_QUOTES Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

21 QUOTE_PERCENT Number(3,0) SMALLINT NOT NULL Quote Percentage
22 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. "

Prompt Table: APS_BASE_CUR_VW

23 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.

Prompt Table: APS_RT_TYPE_VW

24 APS_CONSTRAIN_ITM Number(5,0) INTEGER NOT NULL Constrained Item Fence
25 APS_FIXED_PROD_FNC Number(5,0) INTEGER NOT NULL Constrained Item Fence
26 APS_ITM_GRP_OPT Character(4) VARCHAR2(4) NOT NULL Item Group Option
0001=Item Family
0002=Item Group
27 EARLY_FENCE Signed Number(6,0) DECIMAL(5) NOT NULL Early Fence
28 LATE_FENCE Signed Number(6,0) DECIMAL(5) NOT NULL Late Fence

Default Value: 365

29 CAP_FENCE_OFF Signed Number(6,0) DECIMAL(5) NOT NULL Capacity Fence

Default Value: 365

30 APS_BASE_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

31 APS_BEGINV_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

32 APS_CALENDAR_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

33 APS_CONFIG_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

34 APS_CUSTOMER_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

35 APS_DISTRIB_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

36 APS_FORECAST_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

37 APS_MFG_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

38 APS_PURCHASE_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

39 APS_SAFETY_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

40 APS_SALESORD_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

41 APS_SALESORDH_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

42 APS_SUPPLIER_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

43 APS_TRANSFER_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

44 APS_WORKORD_FLG Character(1) VARCHAR2(1) NOT NULL APS Integration Flag

Y/N Table Edit

Default Value: Y

45 APS_EXPORT_DIR Character(254) VARCHAR2(254) NOT NULL Export Directory
46 APS_RVRS_QRTN_FLG Character(1) VARCHAR2(1) NOT NULL Reversing Qurantine

Y/N Table Edit

Default Value: N

47 SPL_FREEZE_PEGGED Character(1) VARCHAR2(1) NOT NULL 11/02/2004 NRA: Added

Y/N Table Edit

Default Value: Y

48 MULTI_PROC Character(1) VARCHAR2(1) NOT NULL 06/11/02 EGS (CN#PL900-1): Added.
49 MAX_ROW Number(9,0) DECIMAL(9) NOT NULL Max Number of Rows
50 SPL_KEY_SEPARATOR Character(1) VARCHAR2(1) NOT NULL Key Field Seperator

Default Value: \

51 APS_EXPORT_DIRFILE Character(254) VARCHAR2(254) NOT NULL Export Directory
52 MESSAGE_PARM Character(254) VARCHAR2(254) NOT NULL Message Parameter Text
53 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
54 EXPORT_COUNT Number(10,0) DECIMAL(10) NOT NULL Export Record Count
55 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter
56 COUNTER1 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
57 APS_HORIZON_DT Date(10) DATE End Date