INTFC_APAM2_AET(SQL Table) |
Index Back |
|---|---|
AE Cache for 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 | TRANS_DT | Date(10) | DATE |
Transaction Date
Default Value: %DATE |
| 7 | ACCOUNTING_DT | Date(10) | DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %DATE |
| 8 | AM_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
AM Distribution Status
D=Distributed I=Ignore M=Modified N=Not Distributed P=Pending V=Reversed |
| 9 | INTFC_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Trans Load Type |
| 10 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 11 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 12 | PO_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Purchase Order Line Number |
| 13 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 14 | PO_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | PO Distribution Line Number |
| 15 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 16 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 17 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 18 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 19 | RECV_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Receiver Distrib Line |
| 20 | DISTRIB_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Sequence |
| 21 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 22 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 23 | UNPOST_SEQ | Number(2,0) | SMALLINT NOT NULL | Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1". |
| 24 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 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 | COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Cost Type |
| 31 | FINANCIAL_ASSET_SW | Character(1) | VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap Y=Capitalize |
| 32 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 33 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 34 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 35 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 36 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 37 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 38 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 39 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 40 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 41 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 42 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 43 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 44 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 45 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 46 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 47 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 48 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL |
Qty Interface
Default Value: 1 |
| 49 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
| 50 | SALETX_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Sales Tax |
| 51 | SALETX_CD | Character(8) | VARCHAR2(8) NOT NULL | Sales Tax Code |
| 52 | USETAX_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Use Tax |
| 53 | USETAX_CD | Character(8) | VARCHAR2(8) NOT NULL | Use Tax Code |
| 54 | FRGHT_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Freight Charges |
| 55 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 56 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 57 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 58 | CAP_NUM | Character(15) | VARCHAR2(15) NOT NULL | Capital Acquisition Plan # |
| 59 | CAP_SEQUENCE | Number(3,0) | SMALLINT NOT NULL | CAP Sequence |
| 60 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 61 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 62 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 63 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 64 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 65 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 66 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 67 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |
| 68 | PREV_DISTRIB_LINE | Character(30) | VARCHAR2(30) NOT NULL | Previous Distribution Line |
| 69 | INTFC_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Interface Line Number |
| 70 | PREV_ENTRY | Character(30) | VARCHAR2(30) NOT NULL | PREVIOUS ENTRY |
| 71 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 72 | DSCNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amount |
| 73 | DSCNT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Discount Amount |
| 74 | CSD_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty NonRecovery Amount |
| 75 | CSD_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty NonRecovery Amount |
| 76 | CSD_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Recovery Amount |
| 77 | CSD_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Recovery Amount |
| 78 | EXD_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise NonRcvry Amount |
| 79 | EXD_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Non Recovery |
| 80 | EXD_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Recovery Amount |
| 81 | EXD_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Recovery Amount |
| 82 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 83 | FREIGHT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Freight Amount |
| 84 | FREIGHT_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 85 | FREIGHT_AMT_NP_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Freight Amount |
| 86 | MISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 87 | MISC_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Misc. Amount |
| 88 | MISC_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 89 | MISC_AMT_NP_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Misc. Amount |
| 90 | SALETX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 91 | SALETX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Sales Tax Amount |
| 92 | SALETX_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 93 | SALETX_AMT_NP_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Sales Tax Amount |
| 94 | STX_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Nonrecovery |
| 95 | STX_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tx Amt NonRecovery in Bse Curr |
| 96 | STX_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Recovery Amount |
| 97 | STX_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Recovery Amt in Base Curr |
| 98 | USETAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 99 | USETAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Use Tax Amount |
| 100 | USETAX_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Use Tax Amount |
| 101 | USETAX_AMT_NP_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Use Tax Amount |
| 102 | VAT_INV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amount |
| 103 | VAT_INV_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amt Base Curr |
| 104 | VAT_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt |
| 105 | VAT_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt in Base Curr |
| 106 | VAT_NRCVR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Non Recoverable |
| 107 | VAT_NRCVR_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT NonRecoverable Amount |
| 108 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 109 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 110 | 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. |
| 111 | TXN_COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Cost |
| 112 | VAT_SETID | Character(5) | VARCHAR2(5) NOT NULL | VAT SetID |
| 113 | VAT_USE_ID | Character(6) | VARCHAR2(6) NOT NULL | VAT Use Type |
| 114 | BUSINESS_UNIT_VAT | Character(5) | VARCHAR2(5) NOT NULL | Vat Apportionment Business Uni |
| 115 | CHARTFIELD_PR1_VAL | Character(20) | VARCHAR2(20) NOT NULL | Chartfield Priority 1 Value |
| 116 | CHARTFIELD_PR2_VAL | Character(20) | VARCHAR2(20) NOT NULL | Chartfield Priority 2 Value |
| 117 | VAT_RECOVERY_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Recovery Percent |
| 118 | VAT_CONSTRAINT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Constraint |
| 119 | VAT_TAXATION_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Taxation |
| 120 | VAT_ADMISSION_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Admission |
| 121 | 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. |
| 122 | CHANGE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Yes/No indicator |
| 123 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 124 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
| 125 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 126 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 127 | PO_GROUP_ID | Character(18) | VARCHAR2(18) NOT NULL | GroupID |
| 128 | PO_GRP_SEQ_NUM | Number(8,0) | INTEGER NOT NULL | Procurement Group Sequence |
| 129 | PRIMARY_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Primary Unit
N=No Y=Yes Y/N Table Edit Default Value: N |
| 130 | UNIT_ALLOC_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Unit Allocation Qty |
| 131 | UNIT_ALLOC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Unit Allocation Amt |
| 132 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 133 | SORT_ORDER_NUM | Number(2,0) | SMALLINT NOT NULL | Sort Order Number |