AMPS_LVL2_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COST1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
| 3 | COST2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Cost |
| 4 | QUANTITY_PO | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Interface |
| 5 | QUANTITY_TMP1 | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 6 | PRE_INTFC_ID | Number(8,0) | INTEGER NOT NULL | Pre-Interface ID |
| 7 | PRE_INTFC_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Pre-Interface Line Number |
| 8 | 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. |
| 9 | INTFC_ID | Number(8,0) | INTEGER NOT NULL | Interface ID |
| 10 | INTFC_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Interface Line Number |
| 11 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 12 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 13 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 14 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 15 | PO_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Purchase Order Line Number |
| 16 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 17 | PO_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | PO Distribution Line Number |
| 18 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 19 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 20 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 21 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 22 | RECV_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Receiver Distrib Line |
| 23 | DISTRIB_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Sequence |
| 24 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 25 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 26 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 27 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 28 | BUSINESS_UNIT_AP2 | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 29 | VOUCHER_ID2 | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 30 | VOUCHER_LINE_NUM2 | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 31 | DISTRIB_LINE_NUM2 | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 32 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 33 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 34 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 35 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW |
| 36 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODUCT_BUGL_VW |
| 37 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_BUGL_VW |
| 38 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASSCF_BUGL_VW |
| 39 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW |
| 40 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUD_REF_BUGL_VW |
| 41 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
| 42 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
| 43 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
| 44 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CF1_BUGL_VW |
| 45 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW |
| 46 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW |
| 47 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 48 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 49 | COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Cost Type |
| 50 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
| 51 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 52 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 53 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 54 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 55 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
| 56 | MANUFACTURER | Character(60) | VARCHAR2(60) NOT NULL | Manufacturer Name |
| 57 | MODEL | Character(30) | VARCHAR2(30) NOT NULL | Model |
| 58 | VIN | Character(18) | VARCHAR2(18) NOT NULL | VIN |
| 59 | UPC_ID | Character(18) | VARCHAR2(18) NOT NULL | Uniform Product Code ID |
| 60 | CUSTODIAN | Character(30) | VARCHAR2(30) NOT NULL | Custodian |
| 61 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 62 | QTY_PO_AVAIL | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Available PO Qty |
| 63 | COST_PO | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
| 64 | SALETX_AMT_PO | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 65 | USETAX_AMT_PO | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 66 | FREIGHT_AMT_PO | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 67 | ASSET_UE_PO | Character(1) | VARCHAR2(1) NOT NULL | Asset User Entered |
| 68 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Interface |
| 69 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
| 70 | SALETX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 71 | SALETX_CD | Character(8) | VARCHAR2(8) NOT NULL | Sales Tax Code |
| 72 | USETAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 73 | USETAX_CD | Character(8) | VARCHAR2(8) NOT NULL | Use Tax Code |
| 74 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 75 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 76 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 77 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 78 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 79 | ASSET_UE | Character(1) | VARCHAR2(1) NOT NULL | Asset User Entered |
| 80 | SOURCE_TXN | Character(4) | VARCHAR2(4) NOT NULL | Source Transaction |
| 81 | CAP_NUM | Character(15) | VARCHAR2(15) NOT NULL | Capital Acquisition Plan # |
| 82 | CAP_SEQUENCE | Number(3,0) | SMALLINT NOT NULL | CAP Sequence |
| 83 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 84 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 85 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 86 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 87 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 88 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 89 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 90 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |
| 91 | VAT_INV_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amt Base Curr |
| 92 | VAT_NRCVR_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT NonRecoverable Amount |
| 93 | VAT_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt in Base Curr |
| 94 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 95 | ASSET_ID_PO | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 96 | ASSET_ID_AP | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 97 | TXN_COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Cost |
| 98 | SALETX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Sales Tax Amount |
| 99 | USETAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Use Tax Amount |
| 100 | FREIGHT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Freight Amount |
| 101 | VAT_INV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amount |
| 102 | VAT_NRCVR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Non Recoverable |
| 103 | VAT_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt |
| 104 | MISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 105 | MISC_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Misc. Amount |
| 106 | DSCNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amount |
| 107 | DSCNT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Discount Amount |
| 108 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 109 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 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 | INTFC_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Trans Load Type |
| 112 | CURRENT_COST | Number(15,4) | DECIMAL(14,4) NOT NULL | Current Purchase Cost |
| 113 | CURRENT_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | 02/2001 cel WV-802-1.0. Holds the build/snapshot current requested qty on the Supplier and Schedulers Schedule Workbench. (in std uom) |
| 114 | ASSET_CLASS | Character(10) | VARCHAR2(10) NOT NULL | Asset Class |
| 115 | CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Asset Category |
| 116 | NUM_RECORDS | Number(15,0) | DECIMAL(15) NOT NULL | Number of Records |
| 117 | SEQ_NBR_6 | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 118 | IN_SECONDS | Number(6,0) | INTEGER NOT NULL | Seconds |
| 119 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 120 | DESCR_LONG | Character(254) | VARCHAR2(254) NOT NULL | Long Description |
| 121 | IN_PHY_USE | Character(1) | VARCHAR2(1) NOT NULL | Describes if entity is in physical use. |
| 122 | VAT_SETID | Character(5) | VARCHAR2(5) NOT NULL | VAT SetID |
| 123 | VAT_USE_ID | Character(6) | VARCHAR2(6) NOT NULL | VAT Use Type |
| 124 | BUSINESS_UNIT_VAT | Character(5) | VARCHAR2(5) NOT NULL | Vat Apportionment Business Uni |
| 125 | CHARTFIELD_PR1_VAL | Character(20) | VARCHAR2(20) NOT NULL | Chartfield Priority 1 Value |
| 126 | CHARTFIELD_PR2_VAL | Character(20) | VARCHAR2(20) NOT NULL | Chartfield Priority 2 Value |
| 127 | VAT_RECOVERY_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Recovery Percent |
| 128 | VAT_CONSTRAINT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Constraint |
| 129 | VAT_TAXATION_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Taxation |
| 130 | VAT_ADMISSION_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Coefficient of Admission |
| 131 | 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. |
| 132 | PO_GROUP_ID | Character(18) | VARCHAR2(18) NOT NULL | GroupID |
| 133 | PO_GRP_SEQ_NUM | Number(8,0) | INTEGER NOT NULL | Procurement Group Sequence |
| 134 | PRIMARY_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Primary Unit
N=No Y=Yes Y/N Table Edit |
| 135 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 136 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 137 | NUM_ROWS | Number(18,0) | DECIMAL(18) NOT NULL | Number of Rows |
| 138 | COST_AMT_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost Amount |