| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_BI_BR_VW
|
| 3 |
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
Prompt Table:
BI_BANK_R_VW
|
| 4 |
BILL_INQUIRY_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Bill Inquiry Phone
Prompt Table:
BI_INQPHONE_VW
|
| 5 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table:
AR_TRMS_VW
|
| 6 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 7 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Form
Prompt Table:
BI_IVC_FORM_VW
|
| 8 |
DST_ID_AR |
Character(10) |
VARCHAR2(10) NOT NULL |
Specifies the general ledger ChartField combination that is affected when subsequent activity such as a payment occurs for the item.
Prompt Table:
DST_CODE_AR_VW
|
| 9 |
DST_ID_DFR |
Character(10) |
VARCHAR2(10) NOT NULL |
Deferred Distribution Code
Prompt Table:
DST_CODE_DFR_VW
|
| 10 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table:
BI_SPECIALIST
|
| 11 |
BILLING_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Authority
Prompt Table:
BI_AUTH_EF_VW
|
| 12 |
BILL_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill By Identifier
Prompt Table:
BI_BILL_BY_VW
|
| 13 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table:
BI_CYCLE_VW
|
| 14 |
INSTALL_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Installment Plan ID
Prompt Table:
BI_INSTALL_VW
|
| 15 |
ORIGIN_ID_BILLING |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Origin ID
Prompt Table:
ORIGIN_B_EXT_VW
|
| 16 |
GROUP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.
Prompt Table:
%EDITTABLE
|
| 17 |
PYMNT_TERMS_CD2 |
Character(5) |
VARCHAR2(5) NOT NULL |
Settlement Terms Code used in Vendor Rebate Agreement (For AR)
Prompt Table:
BI_IMMED_PYT_VW
|
| 18 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 19 |
LAST_UPDATE_DTTM |
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.
|
| 20 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 21 |
COLLECTOR |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
Prompt Table:
COLLECTOR_TBL
|
| 22 |
CR_ANALYST |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
Prompt Table:
CR_ANALYST_TBL
|