BUSINESS_UNITPO_IDLINE_NBRDefault Value: 1
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: %EDIT_UOM
PV_PODIS_LN_TMP(SQL Table) |
Index Back |
|---|---|
Staging table for Order LinesTemporary Staging Table Ord Lines for PO-CO Dispatch ************************************************************************************ Date Initials Reference # Description 11/29/07 Bob 1710082002 Added new field SHIPTO_ADDRESS4 to Fetch Ship To Address4 ************************************************************************************ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 4 | PV_CP_SPN | Character(50) | VARCHAR2(50) NOT NULL | Supplier Part Number |
| 5 | PV_CP_PART_EXT | Character(50) | VARCHAR2(50) NOT NULL | CUP Part Extension |
| 6 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 7 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |
| 8 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: %EDIT_UOM |
| 9 | MAX_BACK_ORD_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Max Back Order Qty |
| 10 | OFF_CATG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Off Catalog Flag |
| 11 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 12 | SHIPTO_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Recepient Party Name1 |
| 13 | SHIPTO_ATTN_TO | Character(30) | VARCHAR2(30) NOT NULL | Receipent Name2 |
| 14 | SHIPTO_ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Recepient Street |
| 15 | SHIPTO_ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Recepient Street Suppliment 1 |
| 16 | SHIPTO_ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Recepient Street Suppliment 2 |
| 17 | SHIPTO_ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Recepient Street Suppliment 4 ************************************************************************************ Date Initials Reference # Description 11/29/07 Bob 1710082002 Added new field to Fetch Ship To Address4 ************************************************************************************ |
| 18 | SHIPTO_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Recepient POSTAL |
| 19 | SHIPTO_CITY | Character(30) | VARCHAR2(30) NOT NULL | Recepient City |
| 20 | SHIPTO_STATE | Character(6) | VARCHAR2(6) NOT NULL | Ship To State |
| 21 | SHIPTO_COUNTRY | Character(30) | VARCHAR2(30) NOT NULL | Recepient Country |
| 22 | SHIP_TO_CNT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Recepient Contact name |
| 23 | CONTACT_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Recepient Phone |
| 24 | CONTACT_EMAIL | Character(70) | VARCHAR2(70) NOT NULL | Recepient Email Id |
| 25 | CONTACT_FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Nbr |
| 26 | PRICE_PO | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Purchase Order Price |
| 27 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 28 | ORD_TAX_TYPE_CD | Character(30) | VARCHAR2(30) NOT NULL | Order Tax category Code |
| 29 | ORD_TAX_PRCNT | Number(11,4) | DECIMAL(10,4) NOT NULL | Tax Percent |
| 30 | ORD_TAX_AMT | Signed Number(23,6) | DECIMAL(21,6) NOT NULL | Order Tax Amount |
| 31 | ORD_TAXABLE_AMT | Number(22,6) | DECIMAL(21,6) NOT NULL | Order taxable Amount |
| 32 | CHNG_LINE_NOTE | Character(254) | VARCHAR2(254) NOT NULL | change order processing |
| 33 | ORD_DTL_CHNG_CD | Character(64) | VARCHAR2(64) NOT NULL | Order Detail Change Code |
| 34 | IN_PROCESS | Character(1) | VARCHAR2(1) NOT NULL | Process |
| 35 | SHIPPING_AMT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Shipping Cost |
| 36 | SHIPPING_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Shipping Description |
| 37 | TAX_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Tax Description |
| 38 | CR_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | "See OM |
| 39 | CLASSIFICATION | Character(10) | VARCHAR2(10) NOT NULL | Classification |
| 40 | CLASSIFIC_DOMAIN | Character(10) | VARCHAR2(10) NOT NULL | Classification Domain |
| 41 | MFG_ITM_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer's Item ID |
| 42 | MFG_NAME | Character(60) | VARCHAR2(60) NOT NULL | Manufacturer Name |
| 43 | COMMENTS_2000 | Long Character | CLOB | Comment Text |
| 44 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 45 | MISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 46 | PV_ALL_CHARGES | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | All charges |