| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
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.
Prompt Table:
CUST_SRCH_VW
Set Control Field: BUSINESS_UNIT
|
| 4 |
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.
|
| 5 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 6 |
ITEM_LINE_ORIG |
Number(6,0) |
INTEGER NOT NULL |
Original OC Item Line
|
| 7 |
REFERRAL_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Referral Type
P1.0=Passthrough
X1.0=Cross-Servicing
|
| 8 |
BANK_FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
Bank File Name
|
| 9 |
AGENCYID |
Character(9) |
VARCHAR2(9) NOT NULL |
New field used to store a proprietary DMS Agency_Id code.
|
| 10 |
NO_OF_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Used as criteria for the number of daily route scheduling option on the Route Calendar Maintenance Panel to determine every how many days calendar dates will be generated for the daily option.
Default Value: 180
|
| 11 |
COLLECTION_CD_PCA1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Collection Code - PCA1
Prompt Table:
COLLECTION_TBL
|
| 12 |
COLLECTION_CD_PCA2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Collection Code - PCA2
Prompt Table:
COLLECTION_TBL
|
| 13 |
COLLECTION_CD_JUDG |
Character(3) |
VARCHAR2(3) NOT NULL |
Collection Code Judgmnt Action
Prompt Table:
COLLECTION_TBL
|
| 14 |
BASIS_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Basis Date
A=As Of Date
D=Due Date
G=Acctg Date
I=Item Date
|
| 15 |
COLLECTION_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies a collection agency or the reason for placing a customer in collection. Collection status indicates that the customer is delinquent in making payments or the invoice is more than 120 days past due.
Prompt Table:
COLLECTION_TBL
|
| 16 |
BAL_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance - Base Currency
|
| 17 |
FC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a finance charge on an overdue receivables item. This amount is generated by the Finance Charge SQR.
|
| 18 |
OC_PNLTY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a finance charge on an overdue receivables item. This amount is generated by the Finance Charge SQR.
|
| 19 |
OC_ADMIN_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a finance charge on an overdue receivables item. This amount is generated by the Finance Charge SQR.
|
| 20 |
PRINCIPAL_BALANCE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The notional principal balance of a given deal transaction at commencement.
|
| 21 |
FC_DT |
Date(10) |
DATE |
Specifies the date a finance charge is generated for an overdue Receivables item. This date is maintained by the Finance Charge SQR.
|
| 22 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 23 |
OC_ADMIN_DT |
Date(10) |
DATE |
Specifies the date a finance charge is generated for an overdue Receivables item. This date is maintained by the Finance Charge SQR.
|
| 24 |
OC_PNLTY_DT |
Date(10) |
DATE |
Specifies the date a finance charge is generated for an overdue Receivables item. This date is maintained by the Finance Charge SQR.
|
| 25 |
TOTAL_BASE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Base Amount
|
| 26 |
PENNIES |
Number(3,2) |
DECIMAL(2,2) NOT NULL |
Pennies
|
| 27 |
LINE_ITEM_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Charge by Item Line
|
| 28 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 29 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 30 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 31 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 32 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 33 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 34 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 35 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 36 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 37 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 38 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 39 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 40 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 41 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 42 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 43 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 44 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 45 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 46 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business Phone
CAMP=Campus Phone
CELL=Cellular Phone
DORM=Dormitory Phone
FAX=FAX
HOME=Home Phone
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
|
| 47 |
COUNTRY_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Int'l Prefix
|
| 48 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 49 |
EXTENSION |
Character(6) |
VARCHAR2(6) NOT NULL |
Phone Extension
|
| 50 |
AREA_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Dialing Area Code
|
| 51 |
ASOF_DT |
Date(10) |
DATE |
As of Date
|
| 52 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 53 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 54 |
ITEMNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Item Name
|
| 55 |
OVERDUE_CHG_LINE |
Character(1) |
VARCHAR2(1) NOT NULL |
Overdue Charge Line
|
| 56 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 57 |
WORK_CNT2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 2
|
| 58 |
WORK_CNT3 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Work Count 3
|
| 59 |
WORK_CNT20 |
Number(20,0) |
DECIMAL(20) NOT NULL |
This field is a counter of 20 digits for general usage.
|
| 60 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 61 |
FILE_SEQ |
Number(9,0) |
DECIMAL(9) NOT NULL |
File Sequence Number
|
| 62 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 63 |
REMIT_FROM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 64 |
REMIT_FROM_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Remit From Customer
Prompt Table:
CUST_REM_A1S_VW
|
| 65 |
DMS_ACCOUNT_NUM1 |
Character(16) |
VARCHAR2(16) NOT NULL |
1st Account Number
|
| 66 |
DMS_ACCOUNT_NUM2 |
Character(16) |
VARCHAR2(16) NOT NULL |
2nd Account Number
|
| 67 |
DMS_ACCOUNT_NUM3 |
Character(16) |
VARCHAR2(16) NOT NULL |
3rd Account Number
|