PRE_AM_STG(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 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PRE_INTFC_ID |
Number(8,0) | INTEGER NOT NULL | Pre-Interface ID |
| 3 | PRE_INTFC_LINE_NUM |
Number(8,0) | INTEGER NOT NULL | Pre-Interface Line Number |
| 4 | 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 |
| 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 Default Value: NEW |
| 9 | TRANS_DT | Date(10) | DATE |
Transaction Date
Default Value: %DATE |
| 10 | ACCOUNTING_DT | Date(10) | DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %DATE |
| 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 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Default Value: NEXT |
| 29 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 30 | FINANCIAL_ASSET_SW | Character(1) | VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap Y=Capitalize |
| 31 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 32 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 33 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 34 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 35 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 36 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 37 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 38 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 39 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 40 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 41 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 42 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 43 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 44 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 45 | COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Cost Type |
| 46 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
| 47 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 48 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 49 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 50 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 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 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
| 57 | SALETX_CD | Character(8) | VARCHAR2(8) NOT NULL | Sales Tax Code |
| 58 | USETAX_CD | Character(8) | VARCHAR2(8) NOT NULL | Use Tax Code |
| 59 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 60 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 61 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 62 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 63 | CAP_NUM | Character(15) | VARCHAR2(15) NOT NULL | Capital Acquisition Plan # |
| 64 | CAP_SEQUENCE | Number(3,0) | SMALLINT NOT NULL | CAP Sequence |
| 65 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 66 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 67 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 68 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 69 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 70 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 71 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 72 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |
| 73 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 74 | DSCNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amount |
| 75 | DSCNT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Discount Amount |
| 76 | CSD_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty NonRecovery Amount |
| 77 | CSD_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty NonRecovery Amount |
| 78 | CSD_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Recovery Amount |
| 79 | CSD_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Recovery Amount |
| 80 | EXD_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise NonRcvry Amount |
| 81 | EXD_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Non Recovery |
| 82 | EXD_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Recovery Amount |
| 83 | EXD_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Recovery Amount |
| 84 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 85 | FREIGHT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Freight Amount |
| 86 | FREIGHT_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 87 | FREIGHT_AMT_NP_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Freight Amount |
| 88 | MISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 89 | MISC_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Misc. Amount |
| 90 | MISC_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 91 | MISC_AMT_NP_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Misc. Amount |
| 92 | SALETX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 93 | SALETX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Sales Tax Amount |
| 94 | SALETX_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 95 | SALETX_AMT_NP_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Sales Tax Amount |
| 96 | STX_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Nonrecovery |
| 97 | STX_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tx Amt NonRecovery in Bse Curr |
| 98 | STX_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Recovery Amount |
| 99 | STX_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Recovery Amt in Base Curr |
| 100 | USETAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 101 | USETAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Use Tax Amount |
| 102 | USETAX_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Use Tax Amount |
| 103 | USETAX_AMT_NP_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Use Tax Amount |
| 104 | VAT_INV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amount |
| 105 | VAT_INV_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amt Base Curr |
| 106 | VAT_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt |
| 107 | VAT_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt in Base Curr |
| 108 | VAT_NRCVR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Non Recoverable |
| 109 | VAT_NRCVR_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT NonRecoverable Amount |
| 110 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 111 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 112 | 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. |
| 113 | TXN_COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Cost |
| 114 | VAT_SETID | Character(5) | VARCHAR2(5) NOT NULL | VAT SetID |
| 115 | VAT_USE_ID | Character(6) | VARCHAR2(6) NOT NULL | VAT Use Type |
| 116 | BUSINESS_UNIT_VAT | Character(5) | VARCHAR2(5) NOT NULL | Vat Apportionment Business Uni |
| 117 | CHARTFIELD_PR1_VAL | Character(20) | VARCHAR2(20) NOT NULL | Chartfield Priority 1 Value |
| 118 | CHARTFIELD_PR2_VAL | Character(20) | VARCHAR2(20) NOT NULL | Chartfield Priority 2 Value |
| 119 | VAT_RECOVERY_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Recovery Percent |
| 120 | VAT_CONSTRAINT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Constraint |
| 121 | VAT_TAXATION_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Taxation |
| 122 | VAT_ADMISSION_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Admission |
| 123 | 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. |
| 124 | PO_GROUP_ID | Character(18) | VARCHAR2(18) NOT NULL | GroupID |
| 125 | PRIMARY_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Primary Unit
N=No Y=Yes |
| 126 | UNIT_ALLOC_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Unit Allocation Qty |
| 127 | UNIT_ALLOC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Unit Allocation Amt |
| 128 | PO_GRP_SEQ_NUM | Number(8,0) | INTEGER NOT NULL | Procurement Group Sequence |
| 129 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 130 | SORT_ORDER_NUM | Number(2,0) | SMALLINT NOT NULL | Sort Order Number |
| 131 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |