PROCESS_INSTANCER=Run Control Page
W=WorkBench Page
N=No
Y=Yes
PO_CANCEL_AET(SQL Table) |
Index Back |
|---|---|
PO Cancel Cache RecPO002 Manufacturer Contract. Added new fields. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_DT | Date(10) | DATE | Run Date |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 7 | COMMITMENT_CNTL_PO | Character(1) | VARCHAR2(1) NOT NULL | Commitment Control on PO |
| 8 | WORKBENCH_ID | Character(10) | VARCHAR2(10) NOT NULL | WorkBench ID |
| 9 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
| 10 | DESCRLONG | Long Character | CLOB | Long Description |
| 11 | BATCH_ACTION | Character(1) | VARCHAR2(1) NOT NULL | Batch Action |
| 12 | BATCH_LOCATION | Character(1) | VARCHAR2(1) NOT NULL |
Batch Location
R=Run Control Page W=WorkBench Page |
| 13 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 14 | PO_LINE | Number(3,0) | SMALLINT NOT NULL | Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF. |
| 15 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 16 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 17 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 18 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 19 | RFQ_ID | Character(10) | VARCHAR2(10) NOT NULL | RFQ ID |
| 20 | RFQ_LINE_NBR | Number(5,0) | INTEGER NOT NULL | RFQ Line |
| 21 | QTY_ORDERED | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Order Qty |
| 22 | INSTALLED_SW | Character(1) | VARCHAR2(1) NOT NULL | Installed? |
| 23 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 24 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 25 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |
| 26 | RE_SOURCE_QTY | Character(1) | VARCHAR2(1) NOT NULL | Re-Source Requisition? |
| 27 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 28 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 29 | QTY_REQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Requisition Quantity |
| 30 | QTY_REQ_STD | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Requested Stand. UOM |
| 31 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 32 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 33 | AMT_LINE_RELEASED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Amt Released |
| 34 | QTY_LINE_RELEASED | Number(15,2) | DECIMAL(14,2) NOT NULL | Total Line Qty Released |
| 35 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 36 | BUDGET_DT_SW | Character(1) | VARCHAR2(1) NOT NULL | Show Budget Date |
| 37 | TMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Field for holding temp data |
| 38 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 39 | FIELDNAME_TARGET | Character(18) | VARCHAR2(18) NOT NULL | Allocations Target amount field |
| 40 | CHNG_TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Change Template |
| 41 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 42 | JOBCODE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Indicator |
| 43 | CAT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Contract Category Line Number |
| 44 | CNTRCT_ID_DST | Character(25) | VARCHAR2(25) NOT NULL | Contract ID To |