INTFC_PRE_AM

(SQL Table)
Index Back

Pre-Interface Table to AM

Used by the PO/AP/AM interface

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PRE_INTFC_ID Number(8,0) INTEGER NOT NULL Pre-Interface ID
2 PRE_INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Pre-Interface Line Number
3 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Default Value: %DATE

4 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.
5 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
6 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
7 LOAD_STATUS Character(3) VARCHAR2(3) NOT NULL /* -> JMZ. PSOFT. 11-OCT-2002 */ New Status were added : HLD and INP for Asset Management. /* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated
DON=Loaded
ERR=Errored
EXC=Excluded
HLD=On Hold
INP=In Process
NEW=Pending
PGI=PO Grp Incomplete
REP=Replaced
UNI=Unitized

Default Value: NEW

8 TRANS_DT Date(10) DATE Transaction Date

Default Value: %DATE

9 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

Default Value: %DATE

10 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type
11 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
12 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
13 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
14 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
15 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
16 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
17 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
18 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
19 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
20 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line
21 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence
22 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
23 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
24 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
25 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
26 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
27 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Default Value: NEXT

Prompt Table: AM_ACT_ASSET_VW

28 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
29 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
N=Non Cap
Y=Capitalize
30 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

31 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

32 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

33 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

34 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

35 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

36 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

37 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

38 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

39 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

40 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

41 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

42 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
43 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
44 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type
45 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
46 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
47 DESCR Character(30) VARCHAR2(30) NOT NULL Description
48 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
49 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
50 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
51 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
52 MODEL Character(30) VARCHAR2(30) NOT NULL Model
53 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian
54 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
55 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface

Default Value: 1

56 TXN_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Cost
57 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
58 SALETX_CD Character(8) VARCHAR2(8) NOT NULL Sales Tax Code
59 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
60 SALETX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount
61 USETAX_CD Character(8) VARCHAR2(8) NOT NULL Use Tax Code
62 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
63 USETAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount
64 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
65 FREIGHT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
66 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
67 INVOICE_DT Date(10) DATE Invoice Date
68 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
69 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
70 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #

Prompt Table: CAP_AM_OPEN_VW

71 CAP_SEQUENCE Number(3,0) SMALLINT NOT NULL CAP Sequence

Prompt Table: CAP_DET_AM_O_VW

72 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
73 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
74 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
75 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
76 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
77 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
78 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
79 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
80 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
81 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount
82 VAT_INV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amt Base Curr
83 VAT_NRCVR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non Recoverable
84 VAT_NRCVR_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT NonRecoverable Amount
85 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt
86 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr
87 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
88 MISC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount
89 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount
90 DSCNT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Discount Amount
91 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
92 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
93 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.
94 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
95 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID
96 VIN Character(18) VARCHAR2(18) NOT NULL VIN
97 ASSET_HEIGHT Number(13,3) DECIMAL(12,3) NOT NULL Asset Height
98 HEIGHT_UM Character(3) VARCHAR2(3) NOT NULL Asset Height Unit of Measure
99 ASSET_WIDTH Number(13,3) DECIMAL(12,3) NOT NULL Asset Width
100 WIDTH_UM Character(3) VARCHAR2(3) NOT NULL Asset Width Unit of Measure
101 ASSET_LENGTH Number(13,3) DECIMAL(12,3) NOT NULL Asset Length
102 LENGTH_UM Character(3) VARCHAR2(3) NOT NULL Asset Length Unit of Measure
103 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

Default Value: 0

104 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

Default Value: 0

105 VAT_SETID Character(5) VARCHAR2(5) NOT NULL VAT SetID
106 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
107 BUSINESS_UNIT_VAT Character(5) VARCHAR2(5) NOT NULL Vat Apportionment Business Uni
108 CHARTFIELD_PR1_VAL Character(20) VARCHAR2(20) NOT NULL Chartfield Priority 1 Value
109 CHARTFIELD_PR2_VAL Character(20) VARCHAR2(20) NOT NULL Chartfield Priority 2 Value
110 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
111 VAT_CONSTRAINT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Coefficient of Constraint
112 VAT_TAXATION_PCT Number(6,2) DECIMAL(5,2) NOT NULL Coefficient of Taxation
113 VAT_ADMISSION_PCT Number(6,2) DECIMAL(5,2) NOT NULL Coefficient of Admission
114 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
115 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
116 PO_GRP_SEQ_NUM Number(8,0) INTEGER NOT NULL Procurement Group Sequence
117 PRIMARY_UNIT Character(1) VARCHAR2(1) NOT NULL Primary Unit
N=No
Y=Yes

Y/N Table Edit

Default Value: N

118 UNIT_ALLOC_QTY Number(16,4) DECIMAL(15,4) NOT NULL Unit Allocation Qty
119 UNIT_ALLOC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Unit Allocation Amt
120 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description