| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUS_UNIT_TBL_FS
|
| 2 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table:
VOUCHER
|
| 3 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 4 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 5 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 6 |
VOUCHER_STYLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
|
| 7 |
ENTRY_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
C=Complete
D=Through batch defaults
E=Edited by Batch Voucher Module
L=Reviewed through Maintenance
M=Modified
O=Open
P=Postable
R=Recycle
S=Scheduled for Payment
T=Template Voucher
X=Deleted
|
| 8 |
TOTAL_DISTRIBS |
Number(5,0) |
INTEGER NOT NULL |
Total Number of Distributions
|
| 9 |
MAX_DISTRIB_LINE |
Number(5,0) |
INTEGER NOT NULL |
Highest Distribution Line
|
| 10 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table:
BUS_UNIT_PM_VW
|
| 11 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table:
%EDITTABLE14
|
| 12 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Prompt Table:
%EDITTABLE15
|
| 13 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
Prompt Table:
%EDITTABLE16
|
| 14 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 15 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 16 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 17 |
MERCH_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Merchandise Amount
|
| 18 |
ITM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Item SetID
|
| 19 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
%EDITTABLE13
|
| 20 |
QTY_VCHR |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Vouchered
|
| 21 |
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.
|
| 22 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
UNITS_TBL
|
| 23 |
UNIT_PRICE |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Unit Price
|
| 24 |
FRGHT_PRORATE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Freight Charges
Y/N Table Edit
Default Value: Y
|
| 25 |
DSCNT_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Discount
Y/N Table Edit
Default Value: Y
|
| 26 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
Y/N Table Edit
Default Value: N
|
| 27 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 28 |
WTHD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
Y/N Table Edit
Default Value: VENDOR.WTHD_SW
|
| 29 |
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
|
| 30 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 31 |
FINAL_REF_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Reference Indicator
Y/N Table Edit
|
| 32 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
Prompt Table:
BUS_UNIT_PM_VW
|
| 33 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
Prompt Table:
%EDITTABLE12
|
| 34 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receipt Line
Prompt Table:
%EDITTABLE8
|
| 35 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
Prompt Table:
%EDITTABLE9
|
| 36 |
MATCH_LINE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Line Option
E=ERS
F=Full Match
N=Don't Match
Default Value: N
|
| 37 |
DISTRIB_MTHD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribute by
A=Amount
Q=Quantity
Default Value: A
|
| 38 |
VCHR_AMT_FORCE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Force Unit Price
Y/N Table Edit
Default Value: N
|
| 39 |
AMT_ONLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount Only
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 40 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 41 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 42 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 43 |
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
|
| 44 |
ECTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
|
| 45 |
ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
|
| 46 |
ECTRANSINOUTSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
|
| 47 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table:
SHIPTO_TBL
|
| 48 |
SUT_BASE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
Prompt Table:
SHIPTO_TBL
|
| 49 |
TAX_CD_SUT |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code - Sales and Use Tax
Prompt Table:
TAX_SALE_VW
|
| 50 |
ULTIMATE_USE_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Ultimate Use Code
Prompt Table:
SUT_USE_CD
|
| 51 |
SUT_EXCPTN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales/Use Tax Exception Type
D=Direct Pay
E=Exempt/Exonerated
N=None
|
| 52 |
SUT_EXCPTN_CERTIF |
Character(20) |
VARCHAR2(20) NOT NULL |
Sales/Use Tax Exception Certif
|
| 53 |
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
Default Value: E
|
| 54 |
WTHD_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid for the Withholding Code
Prompt Table:
SP_SETID_NONVW
|
| 55 |
WTHD_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Code
Prompt Table:
WTHD_CD_HDR
|
| 56 |
NATURE_OF_TXN1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Nature of Transaction 1
|
| 57 |
NATURE_OF_TXN2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Nature of Transaction 2
|
| 58 |
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
|
| 59 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
Prompt Table:
VAT_USE_TBL
|
| 60 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
|
| 61 |
BUSINESS_UNIT_RTV |
Character(5) |
VARCHAR2(5) NOT NULL |
RTV Business Unit
|
| 62 |
RTV_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Return To Vendor ID
|
| 63 |
RTV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Return To Vendor Line
|
| 64 |
FISCAL_REGIME |
Character(6) |
VARCHAR2(6) NOT NULL |
Fiscal Regime
Prompt Table:
IST_FRGM_AP_VW
|
| 65 |
KK_PROCESS_PRIOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Prior Document
Y/N Table Edit
|
| 66 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 67 |
CATEGORY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category ID
|
| 68 |
TAX_CD_SUT_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Sales/Use Tax Code Percent
|
| 69 |
FREIGHT_SUT_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Rate
|
| 70 |
TITLE_PASSAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Title Passage
B=Buyer's Destination-Ship To
I=Intermediate Consignee
S=Seller's Origination-Ship From
|
| 71 |
TAX_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return
|
| 72 |
TAX_TRANS_SUB_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Sub Type
1=Property
2=Freight
3=Service
4=Rental or Lease
5=Expense
6=Misc
N=None
|
| 73 |
TAX_JOB_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Job Number
|
| 74 |
TAX_USER_AREA |
Character(25) |
VARCHAR2(25) NOT NULL |
Used for tax calculation by tax vendor.
|
| 75 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 76 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 77 |
FREIGHT_SUT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SUT Amount on Freight
|
| 78 |
FRGT_SUT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight SUT Basis Amount
|
| 79 |
MISC_SUT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc Charge SUT Basis Amount
|
| 80 |
DSCN_SUT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount SUT Basis Amount
|
| 81 |
SUT_PRODUCT_CD |
Character(18) |
VARCHAR2(18) NOT NULL |
Product Alias
|
| 82 |
SUT_FREIGHT_CD |
Character(18) |
VARCHAR2(18) NOT NULL |
Product Alias
|
| 83 |
SUT_CALC_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SUT Calculation Basis Amount
|
| 84 |
SALETX_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calculated Sales Tax Amount
|
| 85 |
TAX_VAT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include VAT
N=No
Y=Yes
|
| 86 |
TAX_MISC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Misc Charges
|
| 87 |
TAX_FRGHT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Freight
|
| 88 |
TAX_DSCNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Discount
|
| 89 |
USER_LINE_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 1
|
| 90 |
CUSTOM_C100_B1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 1
|
| 91 |
CUSTOM_C100_B2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 2
|
| 92 |
CUSTOM_C100_B3 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 3
|
| 93 |
CUSTOM_C100_B4 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 4
|
| 94 |
CUSTOM_DATE_B |
Date(10) |
DATE |
Custom Date
|
| 95 |
CUSTOM_C1_B |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 2
|
| 96 |
USER_SCHED_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 1
|
| 97 |
CUSTOM_C100_C1 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 1
|
| 98 |
CUSTOM_C100_C2 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 2
|
| 99 |
CUSTOM_C100_C3 |
Character(100) |
VARCHAR2(100) NOT NULL |
Custom Field 3
|
| 100 |
CUSTOM_DATE_C1 |
Date(10) |
DATE |
Custom Date 1
|
| 101 |
CUSTOM_DATE_C2 |
Date(10) |
DATE |
Custom Date 2
|
| 102 |
CUSTOM_C1_C |
Character(1) |
VARCHAR2(1) NOT NULL |
Custom Character 2
|
| 103 |
BUSINESS_UNIT_WO |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit Work Order
Prompt Table:
SP_BU_WM_NONVW
|
| 104 |
WO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Work Order Identification
Prompt Table:
%EDIT_WO_ID
|
| 105 |
WO_TASK_ID |
Number(5,0) |
INTEGER NOT NULL |
Task Number
Prompt Table:
%EDIT_WO_TASK
|
| 106 |
RSRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Order Management Resource Types
1=Labor
2=Tools
3=Material
|
| 107 |
RES_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Resource Line No.
Prompt Table:
%EDIT_RES_LINE
|
| 108 |
MFG_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer ID
|
| 109 |
MFG_ITM_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
Manufacturer's Item ID
|
| 110 |
UPN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Universal Product Number Format Type
|
| 111 |
UPN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Universal Product Number
|
| 112 |
CNTRCT_ID |
Character(25) |
VARCHAR2(25) NOT NULL |
Buying Agreement ID
|
| 113 |
CNTRCT_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Buying Agreement Line Nbr
|
| 114 |
RELEASE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Release Number
|
| 115 |
VERSION_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Version number
|
| 116 |
CAT_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Contract Category Line Number
|