| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SEQUENCE_NBR_6 |
Number(6,0) |
INTEGER NOT NULL |
Sequence
|
| 3 |
SEQUENCE_NBR_6B |
Number(6,0) |
INTEGER NOT NULL |
Sequence B
|
| 4 |
SEQUENCE_NUM_MAX |
Number(6,0) |
INTEGER NOT NULL |
Maximum Sequence Number
|
| 5 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 6 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 7 |
PO_LINE |
Number(3,0) |
SMALLINT NOT NULL |
Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF.
|
| 8 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_AM_NONVW
|
| 9 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 10 |
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.
|
| 11 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 12 |
CAPITALIZATION_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Capitalized
0=To Capitalize Later
1=To be Capitalized
2=Already Capitalized
3=Never Capitalize
4=Already Non Capitalized
5=Consolidated
Default Value: 1
|
| 13 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 14 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table:
PO_HDR_VW_AM
|
| 15 |
PO_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Purchase Order Line Number
|
| 16 |
PO_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
PO Distribution Line Number
|
| 17 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
|
| 18 |
REFERENCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Reference ID
|
| 19 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
SP_BU_AP_NONVW
|
| 20 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table:
VCHR_VW_AM
|
| 21 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 22 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 23 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 24 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VNDR_FS
|
| 25 |
VENDOR_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Supplier Name
|
| 26 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 27 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 28 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CURR_CD_AM_VW.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 29 |
TXN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 30 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 31 |
QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Interface
|
| 32 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 33 |
SALETX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Sales Tax Amount
|
| 34 |
SALETX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Sales Tax Code
|
| 35 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 36 |
USETAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Use Tax Amount
|
| 37 |
USETAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Use Tax Code
|
| 38 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 39 |
FREIGHT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Freight Amount
|
| 40 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 41 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 42 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
|
| 43 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
|
| 44 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 45 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
|
| 46 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
|
| 47 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
|
| 48 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
|
| 49 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
|
| 50 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
|
| 51 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
|
| 52 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
|
| 53 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
|
| 54 |
CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Category
Prompt Table:
CATEGORY_TBL
|
| 55 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type
Prompt Table:
COST_TYPE_TBL
|
| 56 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 57 |
MASTER_PROJECT |
Character(15) |
VARCHAR2(15) NOT NULL |
Master Project
|
| 58 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 59 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 60 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 61 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 62 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 63 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 64 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
Prompt Table:
AM_RECV_HDR_VW
|
| 65 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receipt Line
|
| 66 |
RECV_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Receiver Distrib Line
|
| 67 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
|
| 68 |
DISTRIB_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 69 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 70 |
INCENTIVE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Investment Incentive ID
|
| 71 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 72 |
MERCH_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Merchandise Amount
|
| 73 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 74 |
MISC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Misc. Amount
|
| 75 |
VAT_INV_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amt Base Curr
|
| 76 |
VAT_INV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amount
|
| 77 |
VAT_NRCVR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Non Recoverable
|
| 78 |
VAT_NRCVR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT NonRecoverable Amount
|
| 79 |
VAT_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt
|
| 80 |
VAT_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt in Base Curr
|
| 81 |
ADJUSTMENT_DT |
Date(10) |
DATE |
Adjustment Date
|
| 82 |
VAT_TRANS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Type
ADD=Addition
ADJ=Adjustment
|
| 83 |
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.
|
| 84 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 85 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 86 |
RT_EFFDT |
Date(10) |
DATE |
The effective date for a given item of market rate data.
|
| 87 |
VAT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
VAT SetID
|
| 88 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
|
| 89 |
BUSINESS_UNIT_VAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Vat Apportionment Business Uni
|
| 90 |
CHARTFIELD_PR1_VAL |
Character(20) |
VARCHAR2(20) NOT NULL |
Chartfield Priority 1 Value
|
| 91 |
CHARTFIELD_PR2_VAL |
Character(20) |
VARCHAR2(20) NOT NULL |
Chartfield Priority 2 Value
|
| 92 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 93 |
VAT_CONSTRAINT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Coefficient of Constraint
|
| 94 |
VAT_TAXATION_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Coefficient of Taxation
|
| 95 |
VAT_ADMISSION_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Coefficient of Admission
|
| 96 |
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.
|