PO_REQLOAD_CMT(SQL Table) |
Index Back |
|---|---|
PO Requisition Load Request |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 2 | LOADER_REQ_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Requisition Request ID |
| 3 | SYSTEM_SOURCE |
Character(3) | VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
Prompt Table: PO_REQLOAD_S_VW |
| 4 | LOADER_BU |
Character(5) | VARCHAR2(5) NOT NULL |
Requesting Loader Bus Unit
Prompt Table: PO_REQLOAD_R_VW |
| 5 | GROUP_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated. |
| 6 | COMMENT_SEQ |
Number(3,0) | SMALLINT NOT NULL |
Comment Nbr
Default Value: 1 |
| 7 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 8 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 9 | PUBLIC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Send to Vendor
Y/N Table Edit Default Value: N |
| 10 | ALLOW_MODIFY | Character(1) | VARCHAR2(1) NOT NULL |
Allow Modify Comments
Y/N Table Edit Default Value: Y |
| 11 | COMMENT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Comment Type
BF=Bid Factor CBF=Analysis Collab Bid Factor HDR=Header LIN=Line SHP=Ship To Location Default Value: LIN |
| 12 | RECV_VIEW_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Shown at Receipt
Y/N Table Edit Default Value: N |
| 13 | VCHR_VIEW_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Shown at Voucher
Y/N Table Edit Default Value: N |