VND_LOAD_EC_TAO(SQL Table) |
Index Back |
|---|---|
Item Loader itm_supplier etc. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ECQUEUEINSTANCE |
Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. |
| 3 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 4 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 7 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 8 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 9 | ITM_ID_VNDR |
Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
| 10 | UNIT_OF_MEASURE |
Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 11 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | QTY_MIN |
Number(16,4) | DECIMAL(15,4) NOT NULL | Minimum Quantity |
| 13 | ITM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Item Status
A=Active D=Discntued H=Hold I=Inactive X=To be Del |
| 14 | ACCEPT_ALL_UOM | Character(1) | VARCHAR2(1) NOT NULL | Accept Any UOM |
| 15 | ACCEPT_ALL_SHIPTO | Character(1) | VARCHAR2(1) NOT NULL | Accept Any Ship To |
| 16 | QTY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Quantity to Use for Prices
L=Line Quantity S=Schedule Quantity |
| 17 | PRICE_DT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Date to Use for Prices
D=Due Date P=PO Date |
| 18 | PRICE_CAN_CHANGE | Character(1) | VARCHAR2(1) NOT NULL |
Price Can Be Changed on Order
N=No Y=Yes |
| 19 | VNDR_CATALOG_ID | Character(20) | VARCHAR2(20) NOT NULL | Vendor's Catalog Number |
| 20 | EFFDT_CATALOG |
Date(10) | DATE | Catalog Effective Date |
| 21 | LEAD_TIME | Number(3,0) | SMALLINT NOT NULL | Lead Time Days |
| 22 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 23 | DFLT_UOM | Character(1) | VARCHAR2(1) NOT NULL | Vendor Default UOM |
| 24 | PRICE_VNDR | Number(16,5) | DECIMAL(15,5) NOT NULL | Vendor Price |
| 25 | QTY_PRECISION | Character(1) | VARCHAR2(1) NOT NULL |
Quantity Precision
D=Decimal W=Whole Nbr |
| 26 | ROUND_TOL | Signed Number(12,4) | DECIMAL(10,4) NOT NULL | Rounding Tolerance |
| 27 | UPDATE_ITEM | Character(1) | VARCHAR2(1) NOT NULL | Update Inventory Item |
| 28 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 29 | PV_CP_PART_EXT | Character(50) | VARCHAR2(50) NOT NULL | CUP Part Extension |
| 30 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 31 | FILEPATH | Character(30) | VARCHAR2(30) NOT NULL | File Information |
| 32 | FILE_EXTENSION | Character(4) | VARCHAR2(4) NOT NULL | File Extension |
| 33 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 34 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |