| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
STATERECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
AE default state record name
|
| 3 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 5 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 6 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 7 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 8 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 9 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 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 |
START_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Starting Invoice Number
|
| 15 |
END_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Ending Invoice Number
|
| 16 |
STARTING_DT |
Date(10) |
DATE |
Bills Added On or After
|
| 17 |
CONSOLIDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidate Headers
|
| 18 |
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
|
| 19 |
BI_CURCNV_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Conversion Action
B=Estimate and Finalize
E=Estimate
F=Finalize
|
| 20 |
DIRECT_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Invoicing
|
| 21 |
RANGE_SELECTION_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Range Selection ID
|
| 22 |
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.
|
| 23 |
BUS_UNIT_EXP |
Character(8) |
VARCHAR2(8) NOT NULL |
Business Unit Expression
Default Value: =
|
| 24 |
ACTION_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Action Flag
A=Action
|
| 25 |
CUR_RT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Exchange Rate Source
T=Use Exchange Rate Tables
U=User Specified
|
| 26 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 27 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 28 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 29 |
RATE_MULT_IU |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 30 |
RATE_DIV_IU |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 31 |
RATE_MULT_XEU |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 32 |
RATE_DIV_XEU |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 33 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 34 |
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. "
|
| 35 |
BASE_CURRENCY_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency To
|
| 36 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 37 |
CURRENCY_CD_XEU |
Character(3) |
VARCHAR2(3) NOT NULL |
Euro Currency
|
| 38 |
BUSINESS_UNIT_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT
|
| 39 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 40 |
LINE_DST_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Revenue Sequence Number
|
| 41 |
GROSS_EXTENDED_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 42 |
GROSS_EXTENDED_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended
|
| 43 |
NET_EXTENDED_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amount
|
| 44 |
NET_EXTENDED_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amount
|
| 45 |
TOT_DISCOUNT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Discount Amount
|
| 46 |
TOT_SURCHARGE_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amount
|
| 47 |
TOT_LINE_DST_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Dist Amount
|
| 48 |
TOT_LINE_DFR_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Contract Liability Amt
|
| 49 |
TOT_LINE_UAR_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Contract Asset Amount
|
| 50 |
TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount (base)
|
| 51 |
VAT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amount in Base Curr
|
| 52 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amt in Base Curr
|
| 53 |
TOT_DISCOUNT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Discount Amount
|
| 54 |
TOT_SURCHARGE_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Surcharge Amount
|
| 55 |
TOT_LINE_DST_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Line Dist Amount
|
| 56 |
TOT_LINE_DFR_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Contract Liability Amt
|
| 57 |
TOT_LINE_UAR_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Contract Asset Amount
|
| 58 |
TAX_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount - Euro
|
| 59 |
VAT_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amount - Euro Currency
|
| 60 |
VAT_BASIS_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amount in Euro Curr
|
| 61 |
AMOUNT_TO_APPLY |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Left to Apply
|
| 62 |
DISC_SUR_LVL |
Number(2,0) |
SMALLINT NOT NULL |
Discount/Surcharge Level
|
| 63 |
LVL_SUBTOTAL_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Level Subtotal
|
| 64 |
TOTAL_LVL_DISC_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Level Discount Total
|
| 65 |
TOTAL_LVL_SUR_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Level Surcharge Total
|
| 66 |
LVL_SUBTOTAL_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Level Subtotal
|
| 67 |
TOTAL_LVL_DISC_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Level Discount Total
|
| 68 |
TOTAL_LVL_SUR_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Level Surcharge Total
|
| 69 |
AMOUNT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 70 |
MULTICURRENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Multi-Currency
|
| 71 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 72 |
INVOICE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 73 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 74 |
DATA_PARTITION_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Partition Option
0=No Partitioning
1=By Business Unit
Default Value: 0
|
| 75 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 76 |
RND_ADJ |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Rounding Adjustment
|
| 77 |
MESSAGE_SEQ |
Number(9,0) |
DECIMAL(9) NOT NULL |
Message Sequence
|
| 78 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 79 |
BI_RECCOUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
BI Rec Count
|
| 80 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 81 |
COUNTER2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 2
|
| 82 |
COUNTER3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 3
|
| 83 |
ERROR_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Error Type
ERR=Stop
NON=None
WAR=Warning
|
| 84 |
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)
|
| 85 |
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
|
| 86 |
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.
|
| 87 |
BU_BLANK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Blank Business Unit Flag
|
| 88 |
EXD_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Duty in Base Currency
|
| 89 |
STX_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
SALES TAX IN BASE CURR
|
| 90 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 91 |
VAT_AMT_RVC_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Reverse Charge Amount in Base Currency
|
| 92 |
VAT_AMT_RVC_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Customer Amount
|
| 93 |
DTTM_FROM |
DateTime(26) |
TIMESTAMP |
From Date/Time
|
| 94 |
INVOICE_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Date Option
P=Processing Date
U=User Defined
|
| 95 |
SQL_STMT |
Long Character(8192) |
CLOB |
An internal work field that contains SQL text that is to be utilized in treasury application processing.
|