| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 5 |
BUS_UNIT_EXP |
Character(8) |
VARCHAR2(8) NOT NULL |
Business Unit Expression
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 7 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
|
| 8 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 9 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 10 |
CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
|
| 11 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
|
| 12 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
|
| 13 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
|
| 14 |
CONSOLIDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidate Headers
|
| 15 |
INVOICE_RANGE_OPT |
Character(3) |
VARCHAR2(3) NOT NULL |
Invoice Range Option
ALI=All Invoiced Bills
ALL=All
CUS=Cust ID
CYC=Bill Cycle
DT=Date Bill Added
DTI=Date
GRP=Copy Group ID
INV=Invoice ID
MUL=Multi-Select Table
PVN=Public Voucher Number
RGP=Reprint Group
SEL=Range ID
SHP=Ship ID
SRC=Bill Source
TYP=Bill Type
|
| 16 |
START_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Starting Invoice Number
|
| 17 |
END_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Ending Invoice Number
|
| 18 |
STARTING_DT |
Date(10) |
DATE |
Bills Added On or After
|
| 19 |
RANGE_SELECTION_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Range Selection ID
|
| 20 |
ADD_DT |
Date(10) |
DATE |
Customer Added On
|
| 21 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 22 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 23 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
|
| 24 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 25 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 26 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 27 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 28 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 29 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 30 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 31 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 32 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 33 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 34 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 35 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 36 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 37 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 38 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 39 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 40 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 41 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 42 |
EXS_TAX_CMPNT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Component Code
|
| 43 |
EXS_TAX_RATE_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Tax Rate Sequence
|
| 44 |
EXS_TAX_RATE_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Tax Rate Percentage
|
| 45 |
EXS_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount
|
| 46 |
EXS_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount Base Currency
|
| 47 |
EXD_DST_ACCT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Excise Distribution Account Type. This field is used to assign chart fields for a particular tax location and will have various translate values.
CNCA=Cenvat Clearing Account
CNCG=Cenvat on Capital Goods
CNCI=Cenvat Clearing Imports ACD
CNHA=Cenvat utilization on Hold Acc
CNHC=Cenvat Hold on Capital Goods
CNHS=Cenvat Hold for Sub Contractin
CNRM=Cenvat on Raw Materials
CNSU=Cenvat Suspense Account
CSDN=Custom Duty Non-Recoverable
EXDC=Excise Dty recovd from Customr
EXDE=Excise Duty Expenses
KKC=Krishi Kalyan Cess on Purchase
KKCP=Krishi Kalyan Cess on Sales
PLAA=PLA Account
SBC=Swachh Bharat Cess on Purchase
SBCP=Swachh Bharat Cess on Sales
SERV=Service Tax
SST=Suspense Service Tax
|
| 48 |
ACCT_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Date
R=Run Date
U=User Date
|
| 49 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 50 |
BUDGET_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
|
| 51 |
BUDGET_LINE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
->
SL - 15-AUG-2002
MISC_CRITERIA label has been added
<-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning
|
| 52 |
GL_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal
|
| 53 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 54 |
DST_ID_GST |
Character(10) |
VARCHAR2(10) NOT NULL |
GST Distribution Code
|
| 55 |
DST_ID_SUT |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales/Use Distribution Code
|
| 56 |
TAX_VENDOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Provider
A=Taxware
N=None
V=Vertex
|
| 57 |
TAX_AUTHORITY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Authority
|
| 58 |
COMMITMENT_CNTL_BI |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on BI
|
| 59 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 60 |
BI_PRELD_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre Load GL process status
0=In Process
1=Complete CF Inheritance
2=Complete Inter/Intra Proc
3=Complete Combo Edit Proc
4=Complete Preld Process
|
| 61 |
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.
|
| 62 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
|
| 63 |
CONSOL_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Billing business unit associated with a consolidated bill.
|
| 64 |
CONSOL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Specifies the invoice identifier associated with a consolidated bill.
|
| 65 |
ADJ_LINE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjustment Line Type
ACR=Adjustment Credit Line
ADJ=Adjustment
ARB=Adjustment Rebill Line
REG=Regular bill line (not adjust)
|
| 66 |
VAT_DCLRTN_POINT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
|
| 67 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 68 |
TEMPLATE_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Template Invoice ID
|
| 69 |
ERROR_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Error Type
ERR=Stop
NON=None
WAR=Warning
|
| 70 |
BI_RECCOUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
BI Rec Count
|
| 71 |
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.
|
| 72 |
BIDFR_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.
|
| 73 |
DST_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 74 |
ACCT_ENTRY_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Account Entry Type
|
| 75 |
DISC_SUR_LVL |
Number(2,0) |
SMALLINT NOT NULL |
Discount/Surcharge Level
|
| 76 |
DISC_SUR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifier
|
| 77 |
LINE_DST_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Revenue Sequence Number
|
| 78 |
CFSTRING1 |
Long Character(1000) |
VARCHAR2(1000) |
ChartField String
|
| 79 |
CFSTRING2 |
Long Character(1000) |
VARCHAR2(1000) |
ChartField String
|
| 80 |
CUST_VNDR_AFFILIAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Vendor Affiliate
|
| 81 |
BUSINESS_UNIT_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
|
| 82 |
AFFILIATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Affiliate
|
| 83 |
LINE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Line Type 1
ADV=Advance Billing
BAE=Billed Amount in Excess
BRT=Billing Retainage
DAPP=Cust Deposit Applied
DEP=Customer Deposit
DISC=Discount Line
DREF=Cust Deposit Refunded
DRFF=Cust Deposit Refund Fee
FRGT=Freight (Surcharge)
MISC=Miscellaneous Charge
PYCV=Payment with Corporate Voucher
RAE=Reclaimed Amount in Excess
REV=Revenue Line
RSTK=Restock (Surcharge)
SUR=Surcharge Line
UTL=Utilization Line
|
| 84 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDIT_BU_PC
|
| 85 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDIT_PROJECT
|
| 86 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 87 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC
|
| 88 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC
|
| 89 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC
|
| 90 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC
|
| 91 |
PC_INSTALLED |
Character(1) |
VARCHAR2(1) NOT NULL |
Projects installed flag
|
| 92 |
UPD_PC_FOR_AR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update AR with PC Chartfield
|
| 93 |
UPD_PC_FOR_VT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update VT with PC Chartfield
|
| 94 |
COMBO_EDIT_BATCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Combo Edit Batch
|
| 95 |
COMBO_EDIT_ONLINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Combo Edit Online
|
| 96 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
Default Value: 0
|
| 97 |
DST_ID_USETAX |
Character(10) |
VARCHAR2(10) NOT NULL |
Use Tax Distribution Code
|
| 98 |
DST_ID_UT_OFFSET |
Character(10) |
VARCHAR2(10) NOT NULL |
Use Tax Offset Distribution Co
|
| 99 |
BI_USE_PC_CFS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Project ChartFields
|
| 100 |
FIELD_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Exists
|
| 101 |
FOREIGN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
|
| 102 |
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.
|
| 103 |
UPD_PC_FOR_GST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update GST with PC Chartfield
|
| 104 |
TOTAL_LINE_COUNT |
Number(7,0) |
INTEGER NOT NULL |
Total Lines
|
| 105 |
TOTAL_COUNT_FLG_ON |
Number(7,0) |
INTEGER NOT NULL |
Total Lines
|
| 106 |
ON_OFF_BOTH_FLAG |
Character(4) |
VARCHAR2(4) NOT NULL |
On off both flag
|
| 107 |
TOT_CNT_TYP_FLG_ON |
Number(7,0) |
INTEGER NOT NULL |
Total Lines
|