PO_CANCEL_WK4(SQL Table) |
Index Back |
---|---|
Temp Table used in PO Cancel |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
4 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
5 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
6 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
7 | DST_ACCT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment |
8 | QTY_REQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Requisition Quantity |
9 | QTY_REQ_STD | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Requested Stand. UOM |
10 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |
11 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
12 | DISTRIB_MTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by
A=Amount Q=Quantity |
13 | AMT_OPEN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Open Amount |
14 | AMT_OPEN_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Open Base |
15 | BUSINESS_UNIT_REQ | Character(5) | VARCHAR2(5) NOT NULL | Requesting Business Unit |
16 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
17 | REQ_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Line Number |
18 | REQ_SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Requisition Schedule Number |
19 | REQ_DISTRIB_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Distrib Number |