| # |
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 |
PRCSNAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 4 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 5 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 6 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 7 |
LANGUAGE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Language Option
O=Specified Language
R=Recipient's Language
|
| 8 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 9 |
PREFERRED_LANGUAGE |
Character(3) |
VARCHAR2(3) NOT NULL |
Preferred Language
ARA=Arabic
CFR=Canadian French
CZE=Czech
DAN=Danish
DUT=Dutch
E=English
ENG=English
ESP=Spanish
F=French
FIN=Finnish
FRA=French
GER=German
HUN=Hungarian
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
NOR=Norwegian
POL=Polish
POR=Portuguese
RUS=Russian
SVE=Swedish
THA=Thai
UKE=UK English
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|
| 10 |
REPORT_LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 11 |
PREVIOUS_LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 12 |
SQLTEXT |
Long Character(14000) |
CLOB |
SQL Statement Text
|
| 13 |
FS_MAP_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Map ID
|
| 14 |
FS_MAP_RET |
Number(4,0) |
SMALLINT NOT NULL |
Result
|
| 15 |
FS_RET_DESRC |
Character(254) |
VARCHAR2(254) NOT NULL |
Result Description
|
| 16 |
FILE_PATH_NAME |
Character(254) |
VARCHAR2(254) NOT NULL |
File Path
|
| 17 |
FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 18 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 19 |
RECREATE_FILE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag that indicates whether the federal highway extract file is to be recreated.
|
| 20 |
EIVC_COPY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
E-Invoice Copy Indicator
N=Original Elec Invoice File
O=Cannot Generate EIVC File
Y=Copy Electronic Invoice File
|
| 21 |
ERROR_MESSAGE |
Character(254) |
VARCHAR2(254) NOT NULL |
For Standard Journal (SJE)
|
| 22 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 23 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 24 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 25 |
FROM_INVOICE |
Character(30) |
VARCHAR2(30) NOT NULL |
From Invoice Number
|
| 26 |
TO_INVOICE |
Character(30) |
VARCHAR2(30) NOT NULL |
To Invoice Number
|
| 27 |
FROM_CUSTOMER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
From Customer ID
|
| 28 |
TO_CUSTOMER_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
To Customer ID
|
| 29 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 30 |
STD_NOTE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Note Code
|
| 31 |
NOTES_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Notes Sequence Num
|
| 32 |
NOTE_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Note Type
|
| 33 |
TEXT254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Text
|
| 34 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 35 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 36 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 37 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 38 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 39 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 40 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 41 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 42 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 43 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 44 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 45 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 46 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 47 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 48 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 49 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 50 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 51 |
BUILDING |
Character(10) |
VARCHAR2(10) NOT NULL |
Building #
|
| 52 |
FLOOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Floor #
|
| 53 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 54 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 55 |
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.
|
| 56 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 57 |
INVOICE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Invoice Type
ACR=Credit Bill
ADJ=Adjustment Only bill
ARB=Rebill Bill
PRF=Pro Forma Invoice
RAD=Regular bill with adjustments
REG=Regular Bill
|
| 58 |
ORI_INVOICE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Original Invoice Type
|
| 59 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 60 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 61 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|
| 62 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 63 |
BANK_ACCT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
An account attribute that describes the ostensible purposes of a given bank/counterparty account.
01=Time Deposit
03=Checking Account
05=Stock
06=Bond
07=Life Insurance Value
08=Retirement Account
10=Business Account
11=Trust Fund Account
12=Stock & Bond Account
13=Life Insurance Acct
CA=Current Account
CH=Charges Account
DA=Demand Deposit
LN=Loan
RD=Return Items on DDA
RS=Return Items-Savings
SA=Settlement Account
SV=Savings Account
Z=Mutually Defined
|
| 64 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 65 |
BRANCH_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Branch Name
|
| 66 |
VAT_DCLRTN_DT |
Date(10) |
DATE |
"Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". "
|
| 67 |
VAT_CALC_GROSS_NET |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net
|
| 68 |
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
|
| 69 |
VAT_EXCPTN_CERTIF |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
|
| 70 |
VAT_EXCPTN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated
|
| 71 |
VAT_RGSTRN_BUYER |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies a customers VAT Registration ID for a particular country.
|
| 72 |
VAT_RGSTRN_SELLER |
Character(20) |
VARCHAR2(20) NOT NULL |
Seller's VAT Registration
|
| 73 |
BILL_SPECIALIST_NM |
Character(40) |
VARCHAR2(40) NOT NULL |
Specialist Name
|
| 74 |
SPECIALIST_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 75 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
|
| 76 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
|
| 77 |
TAX_CD_VAT_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
|
| 78 |
TOT_VAT_BASIS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Basis Amount
|
| 79 |
TOT_VAT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 80 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 81 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 82 |
SUM_TOT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Extended Amount
|
| 83 |
SUM_TOT_DISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Discounts
|
| 84 |
SUM_TOT_SUR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Surcharges
|
| 85 |
SUM_TOT_VAT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 86 |
NET_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
|
| 87 |
DISC_SUR_LVL |
Number(2,0) |
SMALLINT NOT NULL |
Discount/Surcharge Level
|
| 88 |
CUST_COUNTRY_2CHAR |
Character(2) |
VARCHAR2(2) NOT NULL |
Customer 2-Char Country Code
|
| 89 |
CUST_IS_EU_CTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Is Customer Country EU
|
| 90 |
CUST_PARTY_ID |
Character(35) |
VARCHAR2(35) NOT NULL |
Customer Party ID
|
| 91 |
CUST_PARTY_ID_NM |
Character(35) |
VARCHAR2(35) NOT NULL |
Customer Party ID Name
|
| 92 |
CUST_CID_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
Customer CID Number
|
| 93 |
CUST_SRT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
Customer SRT Number
|
| 94 |
CUST_TIN_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
Customer TIN Number
|
| 95 |
CUST_NIF_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
Customer NIF Number
|
| 96 |
CUST_VAT_RGSTRN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Customer VAT Reg ID
|
| 97 |
GLBU_COUNTRY_2CHAR |
Character(2) |
VARCHAR2(2) NOT NULL |
GL BU 2-Char Country Code
|
| 98 |
GLBU_IS_EU_CTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Is GL BU Country EU
|
| 99 |
GLBU_PARTY_ID |
Character(35) |
VARCHAR2(35) NOT NULL |
GL BU Party ID
|
| 100 |
GLBU_PARTY_ID_NM |
Character(35) |
VARCHAR2(35) NOT NULL |
GL BU Party ID Name
|
| 101 |
GLBU_CID_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
GL BU CID Number
|
| 102 |
GLBU_SRT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
GL BU SRT Number
|
| 103 |
GLBU_TIN_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
GL BU TIN Number
|
| 104 |
GLBU_NIF_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
GL BU NIF Number
|
| 105 |
GLBU_VAT_RGST_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Registration Name
|
| 106 |
GLBU_VAT_RGSTRN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
GL BU VAT Reg ID
|
| 107 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 108 |
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. "
|
| 109 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 110 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 111 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 112 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 113 |
EXCHANGE_RATE |
Number(18,4) |
DECIMAL(17,4) NOT NULL |
Exchange Rate
|
| 114 |
INVOICE_CLASS |
Character(2) |
VARCHAR2(2) NOT NULL |
Invoice Class
|
| 115 |
RESIDENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Resident
|
| 116 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 117 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 118 |
VAT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amount in Base Curr
|
| 119 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amt in Base Curr
|
| 120 |
NET_EXTENDED_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amount
|
| 121 |
SUM_TOT_DISC_SUR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Allowance Total Amount
|
| 122 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 123 |
INVOICE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 124 |
DISC_SUR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifier
|