PO_CANCEL_WK4(SQL Table) |
Index Back |
---|---|
Temp Table used in PO Cancel |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
3 | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order | |
4 | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] | |
5 | Number(3,0) | SMALLINT NOT NULL | Schedule Number | |
6 | 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 | Character(5) | VARCHAR2(5) NOT NULL | Requesting Business Unit | |
16 | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID | |
17 | Number(5,0) | INTEGER NOT NULL | Requisition Line Number | |
18 | Number(3,0) | SMALLINT NOT NULL | Requisition Schedule Number | |
19 | Number(5,0) | INTEGER NOT NULL | Requisition Distrib Number |