| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
CON_IVC_NUM_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Consolidated Invoice Number ID
|
| 3 |
CON_INV_NUM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Manual Line Numbering
|
| 4 |
SQL_STMT |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|
| 5 |
SQL_STMT_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
An internal work field that contains SQL text that is to be utilized in treasury application p
|
| 6 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
|
| 7 |
LOC_DOC_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Letter of Credit Document ID
|
| 8 |
INTERUNIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit
N=No
Y=Yes
|
| 9 |
IST_TXN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No
Y=Yes
|
| 10 |
DIRECT_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Invoicing
|
| 11 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
|
| 12 |
AE_STEP |
Character(8) |
VARCHAR2(8) NOT NULL |
Name
|
| 13 |
VAT_TXN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create VAT Transaction
|
| 14 |
HDR_TRANS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Header Transaction Type
CRC=Credit Card Transaction
HAR=HDR AR Transaction
MSC=Miscellaneous Bill Header Flds
VAT=VAT Transaction
|
| 15 |
BIIVC_IU_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
|
| 16 |
IU_INTER_TMPLT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Key to the interunit template record. Assigned to a GLBU on the GL business unit table.
|
| 17 |
IU_LEGAL_ENT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
The business unit that represents the legal entity to which the GL Unit belongs. May have the same value as the GL Unit if it is its own legal entity.
|
| 18 |
PRINT_IVC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Invoice
|
| 19 |
GEN_AR_ITEM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate AR Open Item
|
| 20 |
GEN_AP_VCHR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate AP Voucher
|
| 21 |
BUSINESS_UNIT_LAST |
Character(5) |
VARCHAR2(5) NOT NULL |
Last Business_Unit
|
| 22 |
LAST_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Last invoice
|
| 23 |
COUNTER2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 2
|
| 24 |
AMT10 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 10
|
| 25 |
AMT11 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 11
|
| 26 |
AMT12 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 12
|
| 27 |
AMT13 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 13
|
| 28 |
AMT14 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 14
|
| 29 |
AMT15 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 15
|
| 30 |
AMT16 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 16
|
| 31 |
AMT17 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount 17
|
| 32 |
ENTRY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
|
| 33 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 34 |
ORIG_QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Original Quantity
|
| 35 |
TOT_LINE_DST_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Dist Amount
|
| 36 |
ORIG_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Original Line number
|
| 37 |
ORIG_DST_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Original Revenue Seq Number
|
| 38 |
ENTRY_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
|
| 39 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
|
| 40 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 41 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 42 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 43 |
RMA_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
RMA Number
|
| 44 |
PRIOR_ADJ_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prior Adjustment Line Seq
|
| 45 |
LAST_NOTE_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Last note sequence number
|
| 46 |
LATEST_LINE_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Latest Line Sequence
|
| 47 |
DEMAND_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
|
| 48 |
ORDER_NO |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a customer order number that appears as a reference on a receivables pending item.
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
|
| 49 |
IDENTIFIER |
Character(18) |
VARCHAR2(18) NOT NULL |
Identifier
|
| 50 |
IDENTIFIER_TBL |
Character(3) |
VARCHAR2(3) NOT NULL |
Table Identifier
A=Asset ID
CON=Contracts
D=Discount Table
G=Generic Identifier
ID=PS/Billing Charge Id
ITM=PS/Inventory Item ID
LAB=Labor type
PDA=Product Alias
PRD=PS/Product Id
PRM=PS/Promotion Code
S=Surcharge Table
SVC=Service
UPC=UPC
UPN=Universal Item ID
|
| 51 |
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.
|
| 52 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 53 |
LONGNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Long Name
|
| 54 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 55 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 56 |
PAID_REFERENCE |
Character(30) |
VARCHAR2(30) NOT NULL |
Pre-payment Reference
|
| 57 |
BI_PAID_AT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Paid at Source Indicator
0=Unpaid
1=Customer Deposit Applied
2=Partially Paid
9=Fully Paid
|
| 58 |
OPEN_ITEM_KEY |
Character(30) |
VARCHAR2(30) NOT NULL |
Open Item Key
|
| 59 |
JRNL_LN_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
|
| 60 |
CUST_DEPOSIT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer Deposit ID
|
| 61 |
UNIT_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 62 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 63 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 64 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 65 |
NOTE_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Note Type
|
| 66 |
STD_NOTE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Note Code
|
| 67 |
INTERNAL_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Internal Only Flag
N=No
Y=Yes
|
| 68 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 69 |
PVN_GEN_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
PVN Generation Level field used to store the Level on which a Public Voucher needs to be generated for a contract
C=Contract Number
CL=Contract Number/Contract Line
CP=Contract Number/Project
|
| 70 |
PUBLIC_VOUCHER_NBR |
Number(6,0) |
INTEGER NOT NULL |
Public Voucher Number
|
| 71 |
HOLD_NBR_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Hold Number of Days
|
| 72 |
TEXT254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|
| 73 |
RANGE_TO_30 |
Character(30) |
VARCHAR2(30) NOT NULL |
Range To
|
| 74 |
STATE_SHIP_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship From State
|
| 75 |
STATE_SHIP_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship To State
|