| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
SEARCH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Search ID
|
| 4 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
|
| 5 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 6 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 7 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 8 |
DST_ACCT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
07/20/04 st: added RCN for Advance Reconciliation
02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement
11/11/99 llr: Added ADVP for Payables Advance Payment
|
| 9 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 10 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 11 |
DISTRIB_MTHD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribute by
A=Amount
Q=Quantity
|
| 12 |
PRICE_PO |
Signed Number(17,5) |
DECIMAL(15,5) NOT NULL |
Purchase Order Price
|
| 13 |
QTY_PO |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Purchase Order Quantity
|
| 14 |
QTY_VCHR |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity Vouchered
|
| 15 |
QTY_RECEIVED |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Received Qty
|
| 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 |
MERCHANDISE_AMT_VC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Voucher Merchandise Amount
|
| 19 |
MERCH_AMT_VC_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Voucher Merchandise Amount
|
| 20 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 21 |
FREIGHT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Freight Amount
|
| 22 |
FREIGHT_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 23 |
FREIGHT_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Freight Amount
|
| 24 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 25 |
SALETX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Sales Tax Amount
|
| 26 |
SALETX_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 27 |
SALETX_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Sales Tax Amount
|
| 28 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 29 |
USETAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Use Tax Amount
|
| 30 |
USETAX_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Use Tax Amount
|
| 31 |
USETAX_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Use Tax Amount
|
| 32 |
VAT_INV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amount
|
| 33 |
VAT_INV_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amt Base Curr
|
| 34 |
VAT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
|
| 35 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amt in Base Curr
|
| 36 |
VAT_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt
|
| 37 |
VAT_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt in Base Curr
|
| 38 |
VAT_REBATE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Rebate Amt
|
| 39 |
VAT_REBATE_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Rebate Amt in Base Curr
|
| 40 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 41 |
MISC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Misc. Amount
|
| 42 |
MISC_AMT_NP |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 43 |
MISC_AMT_NP_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Misc. Amount
|
| 44 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 45 |
PO_ENCUM_NET |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Outstanding PO Encumbrance
|
| 46 |
PO_ENCUM_NET_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Outstanding PO Encumbrance Bse
|
| 47 |
MONETARY_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
|
| 48 |
MONETARY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Monetary Amount - VCHR BU Base
|
| 49 |
BUSINESS_UNIT_REQ |
Character(5) |
VARCHAR2(5) NOT NULL |
Requesting Business Unit
|
| 50 |
REQ_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Requisition ID
|
| 51 |
REQ_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Requisition Line Number
|
| 52 |
REQ_SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Requisition Schedule Number
|
| 53 |
REQ_DISTRIB_NBR |
Number(5,0) |
INTEGER NOT NULL |
Requisition Distrib Number
|
| 54 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 55 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 56 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 57 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_BUGL_VW
|
| 58 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 59 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 60 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 61 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 62 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 63 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 64 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 65 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 66 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 67 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 68 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 69 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 70 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 71 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 72 |
BUDGET_DT |
Date(10) |
DATE |
Budget Date
|
| 73 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 74 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 75 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 76 |
REPLEN_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Replenish Code
01=Standard
02=Stockless
|
| 77 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 78 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 79 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 80 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 81 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 82 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 83 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 84 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 85 |
KK_CLOSE_PRIOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Close Prior Transaction
|
| 86 |
DISTRIB_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Distribution Percentage
|
| 87 |
ROLL_STAT_R |
Character(1) |
VARCHAR2(1) NOT NULL |
Rolled
|
| 88 |
AMT_ONLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount Only
N=No
Y=Yes
|
| 89 |
ACTUAL_ROLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Actual Rollover
|