INTFC_PREAMTMP1

(SQL Table)
Index Back

AM's Pre-Intfc Temp 1 Table

# 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.
4 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
5 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.
6 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
7 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
8 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
9 TRANS_DT Date(10) DATE Transaction Date
10 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
11 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type
12 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
13 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
14 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
15 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
16 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
17 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
18 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
19 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
20 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
21 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line
22 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence
23 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
24 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
25 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
26 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
27 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
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
31 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
32 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
33 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
34 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
35 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
36 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
37 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
38 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
39 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
40 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
41 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
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
56 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
57 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
58 SALETX_CD Character(8) VARCHAR2(8) NOT NULL Sales Tax Code
59 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
60 USETAX_CD Character(8) VARCHAR2(8) NOT NULL Use Tax Code
61 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
62 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
63 INVOICE_DT Date(10) DATE Invoice Date
64 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
65 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
66 ASSET_UE Character(1) VARCHAR2(1) NOT NULL Asset User Entered

Y/N Table Edit

67 SOURCE_TXN Character(4) VARCHAR2(4) NOT NULL Source Transaction
68 CAP_NUM Character(15) VARCHAR2(15) NOT NULL Capital Acquisition Plan #
69 CAP_SEQUENCE Number(3,0) SMALLINT NOT NULL CAP Sequence
70 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
71 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
72 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
73 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
74 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
75 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
76 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
77 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
78 VAT_INV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amt Base Curr
79 VAT_NRCVR_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT NonRecoverable Amount
80 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr
81 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label