| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BASE_LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 5 |
ASSN_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.
|
| 6 |
AE_VERSION |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Version
|
| 7 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 8 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 9 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 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 |
CRSPD_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 12 |
CRSPD_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Correspondence Customer
|
| 13 |
ITEM |
Character(30) |
VARCHAR2(30) NOT NULL |
Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
|
| 14 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 15 |
DUN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Dunning ID
|
| 16 |
DUN_ID_NUM |
Number(8,0) |
INTEGER NOT NULL |
Dunning Number
|
| 17 |
DUN_GROUP |
Character(2) |
VARCHAR2(2) NOT NULL |
Dunning Group
%=All Groups
A=Group A
B=Group B
C=Group C
D=Group D
|
| 18 |
DUN_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dunning Hold
|
| 19 |
DUN_PROMPT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid Used to track Dun Setid
|
| 20 |
DUN_LEVEL |
Character(2) |
VARCHAR2(2) NOT NULL |
Dunning Level
|
| 21 |
DUN_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dunning Method
A=Dunning by Action List
D=Dunning by Days
L=Dunning by Level
|
| 22 |
DUN_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Dunning Sequence Number
|
| 23 |
DUN_INTERVAL |
Number(3,0) |
SMALLINT NOT NULL |
Dunning Interval
|
| 24 |
START_DAY |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Start Day
|
| 25 |
END_DAY |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
End Day
|
| 26 |
LETTER_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies a type of correspondence used for follow-up letters or dunning notices. A letter code is associated with a customizable template to facilitate form letters.
|
| 27 |
LC_AMT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Dunning Letter Charge Amount
|
| 28 |
INCLUDE_FC |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Finance Charge
|
| 29 |
INCLUDE_DC |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Dunning Letter Charge Indicator
N=Not Include Letter Charge
Y=Include Letter Charge
|
| 30 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 31 |
NO_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
No Hold
N=No
Y=Yes
|
| 32 |
DUN_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Dunning Flag
|
| 33 |
PREV_DUN_LVL |
Character(5) |
VARCHAR2(5) NOT NULL |
Previous Dun Level
|
| 34 |
PREV_CRSPD_CUSTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Previous CRSPD Customer ID
|
| 35 |
LTR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Letter Set ID
|
| 36 |
LTR_DUN_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Letter Dun ID
|
| 37 |
LTR_DUN_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
Letter DUN Level
|
| 38 |
LTR_LETTER_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Letter CD
|
| 39 |
LTR_CRSPD_CUSTID |
Character(15) |
VARCHAR2(15) NOT NULL |
Dunning Letter CRSPD Customer
|
| 40 |
LETTER_CD_VAR |
Character(3) |
VARCHAR2(3) NOT NULL |
Letter Code Variable
|
| 41 |
DUN_PREFERENCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Dunning Letter Severity Preference: Select 'H' if prefer to send the most severe letter to a customer when the customer may be qualified for different levels of dunning letters for various delinquent items. Select 'L' for the lowest level of letter to be sent.
H=Use Severest Dunning Letter
L=Use Modest Dunning Letter
|
| 42 |
USE_AR_DSP_CUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Its value means whether or not use a Display Currency in AR.
N=NO
Y=YES
Y/N Table Edit
Default Value: N
|
| 43 |
DISPLAY_CUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Currency
B=Business Unit Currency
C=Customer Default Currency
O=Other
Default Value: BUS_UNIT_OPT_AR.DISPLAY_CUR
|
| 44 |
DSP_CUR_CD_WSH |
Character(3) |
VARCHAR2(3) NOT NULL |
Worksheet Disp. Currency Code
Default Value: BUS_UNIT_OPT_AR.DSP_CUR_CD_WSH
Prompt Table:
CURRENCY_CD_TBL
Set Control Field: CURRENCY_CD
|
| 45 |
DC_RT_TYPE_WSH |
Character(5) |
VARCHAR2(5) NOT NULL |
Worksheet Rate Type
Default Value: BUS_UNIT_OPT_AR.DC_RT_TYPE_WSH
Prompt Table:
RT_TYPE_TBL
Set Control Field: RT_TYPE
|
| 46 |
EFFDT_OPT_WSH |
Character(1) |
VARCHAR2(1) NOT NULL |
Worksheet Effect. Date Option
A=Accounting Date
O=Other
T=As of Today
Default Value: BUS_UNIT_OPT_AR.EFFDT_OPT_WSH
|
| 47 |
CUR_EFFDT |
Date(10) |
DATE |
Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
|
| 48 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 49 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 50 |
AE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exists
|
| 51 |
ITEM_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Item Count
|
| 52 |
CUST_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Count of customers
|
| 53 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 54 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 55 |
CNTCT_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence Number
|
| 56 |
CRSPD_ORIG |
Character(2) |
VARCHAR2(2) NOT NULL |
Correspondence Orgin
|
| 57 |
DELIVERY_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivery Method
E=Email
F=Fax
P=Print
|
| 58 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 59 |
FAX |
Character(24) |
VARCHAR2(24) NOT NULL |
Fax Number
|
| 60 |
PRINTER |
Character(20) |
VARCHAR2(20) NOT NULL |
Printer Specification
|
| 61 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
|
| 62 |
AG_PRINT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Acceptgiro Print Flag - Yes/No
|
| 63 |
AG_REF_NBR |
Number(16,0) |
DECIMAL(16) NOT NULL |
Payment Reference Number
|
| 64 |
AG_REF_CHR |
Character(16) |
VARCHAR2(16) NOT NULL |
Payment Reference Number
|
| 65 |
BUSINESS_UNIT_2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Non-Joint Venture BU
|
| 66 |
RD_ITEM_CNT |
Number(8,0) |
INTEGER NOT NULL |
Item Count used in the Receivable Dunning process.
|
| 67 |
RD_CUST_CNT |
Number(8,0) |
INTEGER NOT NULL |
Customer Count used in the Receivable Dunning process
|
| 68 |
CHECK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Work field used to store status values
|
| 69 |
SETID_CUST_IFC |
Character(5) |
VARCHAR2(5) NOT NULL |
Set ID
|
| 70 |
CUST_ID_IFC |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer ID
|
| 71 |
BUSINESS_UNIT_IFC |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 72 |
BURST_VAL |
Character(100) |
VARCHAR2(100) NOT NULL |
Burst Field Value
|
| 73 |
BURST_VAL_CWB |
Character(100) |
VARCHAR2(100) NOT NULL |
Burst Field Value
|
| 74 |
DUN_DT |
Date(10) |
DATE |
Specifies the date that a dunning letter is sent. This date is generated by the Dunning SQR.
|
| 75 |
SECURITY_CLEARANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Security Clearance
0=Not Required
1=Classified
2=Secret
3=Top Secret
4=Sensitive Compartmented Info
5=Q Sensitive
6=Q Non-Sensitive
7=L (Atomic Energy Act)
8=Other
|
| 76 |
SECURITY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Security
C=Permission List Level Security
N=No Security
O=User ID Level Security
|
| 77 |
SECURITY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Secured Row
|
| 78 |
SECURITY_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Security Option
|
| 79 |
ITEM_SOURCE |
Character(30) |
VARCHAR2(30) NOT NULL |
Item Source ID
|
| 80 |
ITEM_SOURCE_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Source Line
|