| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
TRANS_DATE |
Date(10) |
DATE NOT NULL |
Transaction Date
|
| 5 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
Default Value: 1
|
| 6 |
RELEASE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Release Type
P=Purchase Order
V=Voucher
|
| 7 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1
|
| 8 |
CNTRCT_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Buying Agreement Line Nbr
|
| 9 |
RECV_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Receiving Required
N=Optional
X=Do Not
Y=Required
Default Value: N
|
| 10 |
INSPECT_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Inspection Required
N=No
Y=Yes
|
| 11 |
ROUTING_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Inspection Routing ID
|
| 12 |
UNIT_PRC_TOL |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Unit Price Tolerance
|
| 13 |
PCT_UNIT_PRC_TOL |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Unit Price Tolerance
|
| 14 |
INVENTORY_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Inventory Item
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 15 |
RFQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
RFQ ID
|
| 16 |
RFQ_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
RFQ Line
|
| 17 |
LEAD_TIME |
Number(3,0) |
SMALLINT NOT NULL |
Lead Time Days
|
| 18 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 19 |
TOTAL_DISTRIBS |
Number(5,0) |
INTEGER NOT NULL |
Total Number of Distributions
|
| 20 |
MAX_DISTRIB_LINE |
Number(5,0) |
INTEGER NOT NULL |
Highest Distribution Line
|
| 21 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 22 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 23 |
ITM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Item SetID
|
| 24 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 25 |
STATISTIC_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
|
| 26 |
UNIT_PRICE |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Unit Price
|
| 27 |
DSCNT_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Discount
|
| 28 |
WTHD_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid for the Withholding Code
|
| 29 |
WTHD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
|
| 30 |
WTHD_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Code
|
| 31 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 32 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
|
| 33 |
VAT_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Applicable
Y/N Table Edit
|
| 34 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 35 |
TAX_CD_VAT |
Character(8) |
VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
Prompt Table:
VAT_HEADER_VW
|
| 36 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
Prompt Table:
VAT_TXN_CD
|
| 37 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table:
SHIPTO_TBL
|
| 38 |
SUT_BASE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
Prompt Table:
SHIPTO_TBL
|
| 39 |
TAX_CD_SUT |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code - Sales and Use Tax
Prompt Table:
TAX_SALE_VW
|
| 40 |
SUT_EXCPTN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales/Use Tax Exception Type
D=Direct Pay
E=Exempt/Exonerated
N=None
|
| 41 |
SUT_EXCPTN_CERTIF |
Character(20) |
VARCHAR2(20) NOT NULL |
Sales/Use Tax Exception Certif
|
| 42 |
SUT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales/Use Tax Applicability
D=Direct Pay
E=Item is Exempt
S=Sales Tax Applicable
U=Use Tax Applicable
X=Purchaser Is Exonerated
|
| 43 |
ULTIMATE_USE_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Ultimate Use Code
Prompt Table:
SUT_USETRN_VW
|
| 44 |
VAT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
|
| 45 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
Prompt Table:
VAT_USE_TBL
|
| 46 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 47 |
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
|
| 48 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
|
| 49 |
AMT_ONLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount Only
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 50 |
UNIT_PRC_TOL_L |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Unit Price Tolerance - Under
|
| 51 |
PCT_UNIT_PRC_TOL_L |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Unit Price Tolerance - Under
|
| 52 |
MILESTONE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Milestone Line Number
|
| 53 |
RETENTION_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Retention
E=Retain on Each Payment
F=Retain on First Payment
L=Retain on Last Payment
N=No Retention
|
| 54 |
RETENTION_AMT |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Retention Amount
|
| 55 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table:
MANUFACTURER
|
| 56 |
MFG_ITM_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer's Item ID
Prompt Table:
ITEM_MFG_ID_VW
|
| 57 |
UPN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Universal Product Number Format Type
Prompt Table:
%EDITTABLE39
|
| 58 |
UPN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Universal Product Number
Prompt Table:
%EDIT_VALUE
|
| 59 |
VNDR_CATALOG_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Vendor's Catalog Number
|
| 60 |
ITM_ID_VNDR |
Character(50) |
VARCHAR2(50) NOT NULL |
Vendor Item ID
|
| 61 |
USER_LINE_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 1
|
| 62 |
CUSTOM_C100_B1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 1
|
| 63 |
CUSTOM_C100_B2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 2
|
| 64 |
CUSTOM_C100_B3 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 3
|
| 65 |
CUSTOM_C100_B4 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 4
|
| 66 |
CUSTOM_DATE_B |
Date(10) |
DATE |
Custom Date
|
| 67 |
CUSTOM_C1_B |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 2
|