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