INTFC_PRE_AM(SQL Table) |
Index Back |
---|---|
Pre-Interface Table to AMUsed 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 |