BUSINESS_UNITPO_IDLINE_NBRDefault Value: 1
SCHED_NBRDefault Value: 1
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: %EDIT_UOM
A=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
X=Canceled
PV_PODIS_SC_TMP(SQL Table) |
Index Back |
|---|---|
Staging table for ScheduleLineTemporary Staging Table Ord ScheduleLine 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 | SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL |
Schedule Number
Default Value: 1 |
| 5 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |
| 6 | 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 |
| 7 | SCHED_TRANSPORT_ID | Character(15) | VARCHAR2(15) NOT NULL | Schdule Line Transport Id |
| 8 | SHCD_TRANS_MODE_CD | Character(34) | VARCHAR2(34) NOT NULL | Transport Mode Code |
| 9 | SCHD_TRANS_MEAN_CD | Character(58) | VARCHAR2(58) NOT NULL | |
| 10 | TRANS_CARRIER_ID | Character(64) | VARCHAR2(64) NOT NULL | Transport carrier Id |
| 11 | SHIP_INSTRUCTIONS | Long Character | CLOB | Shipping Instructions |
| 12 | CUST_SHP_CNTCT_NBR | Character(24) | VARCHAR2(24) NOT NULL | |
| 13 | ORD_RQST_DLVDT_CHR | Character(30) | VARCHAR2(30) NOT NULL | Requested Delivery Date |
| 14 | SHIPTO_ATTN_TO | Character(30) | VARCHAR2(30) NOT NULL | Receipent Name2 |
| 15 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 16 | SHIPTO_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Recepient Party Name1 |
| 17 | SHIPTO_ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Recepient Street |
| 18 | SHIPTO_ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Recepient Street Suppliment 1 |
| 19 | SHIPTO_ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Recepient Street Suppliment 2 |
| 20 | 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 ************************************************************************************ |
| 21 | SHIPTO_POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Recepient POSTAL |
| 22 | SHIPTO_CITY | Character(30) | VARCHAR2(30) NOT NULL | Recepient City |
| 23 | SHIPTO_STATE | Character(6) | VARCHAR2(6) NOT NULL | Ship To State |
| 24 | SHIPTO_COUNTRY | Character(30) | VARCHAR2(30) NOT NULL | Recepient Country |
| 25 | SHIP_TO_CNT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Recepient Contact name |
| 26 | CONTACT_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Recepient Phone |
| 27 | CONTACT_EMAIL | Character(70) | VARCHAR2(70) NOT NULL | Recepient Email Id |
| 28 | CONTACT_FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Nbr |
| 29 | PRICE_PO | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Purchase Order Price |
| 30 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 31 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 32 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL | Freight Terms Code |
| 33 | REVISION | Character(4) | VARCHAR2(4) NOT NULL | 01/27/2000 RML Added "As of" label |
| 34 | CANCEL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Cancel Status
A=Active C=Closed D=Denied H=Hold O=Open P=Pending Approval X=Canceled |
| 35 | IN_PROCESS | Character(1) | VARCHAR2(1) NOT NULL | Process |