PV_BUF_LN_TBL(SQL Table) |
Index Back |
---|---|
Mobile work fields.Buffer record for line |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
3 | ROUTING_ID | Character(10) | VARCHAR2(10) NOT NULL | Inspection Routing ID |
4 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
5 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
6 | RFQ_IND | Character(1) | VARCHAR2(1) NOT NULL |
RFQ Required
N=No Y=Yes |
7 | STOCKLESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Stockless Item
N=No Y=Yes |
8 | INSPECT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Inspection Required
N=No Y=Yes |
9 | AMT_ONLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Amount Only
N=No Y=Yes |
10 | ZERO_PRICE_IND | Character(1) | VARCHAR2(1) NOT NULL | Zero Price Indicator |
11 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
12 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
13 | ORIG_INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Used to identify the original item ordered, in case an item substitution has taken place. |
14 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
15 | DESCR254_MIXED2 | Character(254) | VARCHAR2(254) NOT NULL | Long Description |
16 | PV_SUBITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Substitute Item ID |
17 | REPLEN_OPT | Character(2) | VARCHAR2(2) NOT NULL |
Replenish Code
01=Standard 02=Stockless |
18 | VAT_SVC_PERFRM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location 2=Ship From Location 3=Buyer's Location 4=Supplier's Location |
19 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
20 | BUSINESS_UNIT_CP | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
21 | PV_SUG_VNDR_COMM | Character(254) | VARCHAR2(254) NOT NULL | Suggested Supplier Comments |
22 | CC_USE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Use Procurement Card |
23 | USE_CNTRCT | Character(1) | VARCHAR2(1) NOT NULL |
Use Contract if Available
N=No Y=Yes |
24 | CNTRCT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Buying Agreement Line Nbr |
25 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL | Contract Version number |
26 | CAT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Contract Category Line Number |
27 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
28 | CNTRCT_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
29 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
30 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
31 | ITM_ID_VNDR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
32 | VNDR_CATALOG_ID | Character(20) | VARCHAR2(20) NOT NULL | Vendor's Catalog Number |
33 | ITM_VNDR_PRIORITY | Number(3,0) | SMALLINT NOT NULL | Item Vendor Priority |
34 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
35 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
36 | STD_ID_NUM_VNDR | Character(20) | VARCHAR2(20) NOT NULL | Vendor ID Number |
37 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
38 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
39 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
40 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
41 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
42 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Int'l Prefix |
43 | CONTACT_NAME | Character(50) | VARCHAR2(50) NOT NULL | The individual contact name associated with a given bank/counterparty. |
44 | EXTENSION | Character(6) | VARCHAR2(6) NOT NULL | Phone Extension |
45 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
46 | PHONE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business Phone CAMP=Campus Phone CELL=Cellular Phone DORM=Dormitory Phone FAX=FAX HOME=Home Phone MAIN=Main OTR=Other PGR1=Pager 1 PGR2=Pager 2 TELX=Telex |
47 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
48 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
49 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
50 | MFG_ITM_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer's Item ID |
51 | UPN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | Universal Product Number Format Type |
52 | UPN_ID | Character(20) | VARCHAR2(20) NOT NULL | Universal Product Number |
53 | PO_GROUP_ID | Character(18) | VARCHAR2(18) NOT NULL | GroupID |
54 | PRIMARY_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Primary Unit
N=No Y=Yes |
55 | UNIT_ALLOC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Unit Allocation Amt |
56 | UNIT_ALLOC_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL | Unit Allocation Qty |
57 | CONSOLIDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Consolidate with other Reqs
N=No Y=Yes |
58 | CALC_PRICE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Calculate Price? |
59 | OVERRIDE_SUGG_VNDR | Character(1) | VARCHAR2(1) NOT NULL | Override Suggested Vendor |
60 | INVENTORY_SRC_FLG | Character(1) | VARCHAR2(1) NOT NULL | Inventory Source Flag |
61 | AUTO_SUB_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Auto Item Substitution
N=No S=Substituted by Sourcing Y=Yes |
62 | 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. |
63 | SOURCE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
AutoSource Status
A=Available C=Sourcing Complete E=Non-Price Error I=Sourcing In Process N=Non-Price Error P=Pricing Error |
64 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
65 | CATDESCR | Character(60) | VARCHAR2(60) NOT NULL | Category Description |
66 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL | Category Code |
67 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
68 | CP_TEMPLATE_ID | Character(10) | VARCHAR2(10) NOT NULL | Template ID Field |
69 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
70 | DESCR254_MIXED_STG | Character(254) | VARCHAR2(254) NOT NULL | Long Description |
71 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
72 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
73 | FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |
74 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
75 | LEAD_TIME | Number(3,0) | SMALLINT NOT NULL | Lead Time Days |
76 | LN_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Line Type
CAT=Catalog Item CUST=Custom Item DC=Direct Connect Item DCEX=Exchange Item DCPO=Punchout Item DCRT=Round Trip DCTP=Transparent Punchout Item DESR=Ad-hoc Item EF=Express Form Item OS=Order Sheet SDF=Supplemental Data Form SPRO=Service SR=ePro Special Request Item SRFC=Fixed Cost Service Item SRTM=Time and Material Service Item SRVC=Variable Cost Service Item |
77 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
78 | MFG_NAME | Character(60) | VARCHAR2(60) NOT NULL | Manufacturer Name |
79 | PRICE_LIST | Number(16,5) | DECIMAL(15,5) NOT NULL | Standard Price |
80 | PRICE_ORIG | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Original Price |
81 | PRICE_REQ | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Date Initials Issue Description 092107 dh F-AHAYT-95051 ePro change from number to Sign to allow negative |
82 | PV_QTY_REQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity on Requisition |
83 | PV_SEQNUM | Number(5,0) | INTEGER NOT NULL | Sequencial Number |
84 | PV_SUBITEM_FLG | Character(1) | VARCHAR2(1) NOT NULL | Use Substitute Item |
85 | PV_SUG_VNDR_GB | Character(1) | VARCHAR2(1) NOT NULL | Suggested Vendor GroupBox |
86 | PV_SUG_VNDR_GB2 | Character(1) | VARCHAR2(1) NOT NULL | Suggested Vendor GroupBox |
87 | PV_SUG_VNDR_PB | Character(1) | VARCHAR2(1) NOT NULL | Suggested Vendor Pushbutton |
88 | QTY_REQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Requisition Quantity |
89 | QTY_REQ_C | Character(15) | VARCHAR2(15) NOT NULL | Qty Req String |
90 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
91 | SUBITEM_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Substitute item Flag
0=No possible substitute 1=Item Sub. at SETID level 2=Item Sub. at Supp level A=Auto Substitution B=Manul and Auto Substitution M=Manual Substitution N=Do Not Use |
92 | SUB_ITEM_PB | Character(1) | VARCHAR2(1) NOT NULL | Substitute Items |
93 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
94 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
95 | USER_LINE_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
96 | CUSTOM_C100_B1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
97 | CUSTOM_C100_B2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
98 | CUSTOM_C100_B3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
99 | CUSTOM_C100_B4 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 4 |
100 | CUSTOM_DATE_B | Date(10) | DATE | Custom Date |
101 | CUSTOM_C1_B | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |