| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
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:
CUSTOMER
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 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:
OM_TRMS_VW
|
| 6 |
PYMNT_TERMS_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Terms Basis Amount
1=User Amount 1
2=User Amount 2
G=Gross Voucher Amount
I=Item Amount
V=VAT Discountable Amount
|
| 7 |
GRACE_DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Due Grace Days
|
| 8 |
GRACE_DISC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Discount Grace Days
|
| 9 |
IMMEDIATE_PAYMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Immediate Payment Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 10 |
RETENTION_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Closed Item Retention Days
|
| 11 |
PP_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Predictor Hold
Y/N Table Edit
Default Value: N
|
| 12 |
PP_METHOD |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment Predictor Method
Prompt Table:
PP_MET_TBL
|
| 13 |
REF_QUALIFIER_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Reference Qualifier Code
Prompt Table:
AR_FLD_REF_VW
|
| 14 |
PARTIAL_PY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Payment Switch
Y/N Table Edit
Default Value: N
|
| 15 |
PO_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order Required
Y/N Table Edit
Default Value: N
|
| 16 |
BILL_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill By Identifier
Prompt Table:
BI_BILL_BY_VW
|
| 17 |
FREIGHT_BILL_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Freight Bill Type
OE=Order Entry
SH=Shipping
Default Value: SH
|
| 18 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table:
BI_CYCLE_VW
|
| 19 |
BILL_INQUIRY_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Bill Inquiry Phone
Prompt Table:
BI_INQPHN_VW
|
| 20 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table:
BI_TYPE_EF_VW
|
| 21 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table:
BI_SPCLST_VW
|
| 22 |
BILLING_AUTHORITY |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Authority
Prompt Table:
BI_AUTH_EF_VW
|
| 23 |
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_VW
|
| 24 |
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_VW
|
| 25 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Form
Prompt Table:
BI_IVC_FORM_VW
|
| 26 |
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
|
| 27 |
DRAFT_APPROVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
"Indicates whether or not a draft is pre-approved for payment by a bill-to customer. If the draft is pre-approved then it can be submitted to the customer's bank without the customer's sign-off. Otherwise the draft must be reviewed and approved by the customer before the enterprise can submit it to the bank for payment. This field is used only if the preferred payment method is ""Draft""."
P=Preapproved
R=Approval Required
|
| 28 |
DRAFT_DOC |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates whether or not (C or N) a draft document should be created for a Receivables item when the payment method is ""draft"". If the value is N then the system prints only a draft statement. If the value is C then the system creates a draft document. "
C=Create Document
N=Do Not Create Document
|
| 29 |
DRAFT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
A flag that indicates whether a draft is initiated by the vendor (1) or by the customer (2).
Prompt Table:
DRAFT_TYPE_TBL
|
| 30 |
DD_PROFILE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Profile ID for a Direct Debit
Prompt Table:
DD_PROFILE_TBL
|
| 31 |
DD_GROUP |
Character(2) |
VARCHAR2(2) NOT NULL |
Direct Debit Group
%=All Groups
A=Group A
B=Group B
C=Group C
D=Group D
|
| 32 |
PAYMENT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
Prompt Table:
OM_PAY_MTHD_VW
|
| 33 |
DIRECT_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Invoicing
Y/N Table Edit
Default Value: Y
|
| 34 |
CUSTOMER_PO |
Character(25) |
VARCHAR2(25) NOT NULL |
Customer PO
|
| 35 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 36 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 37 |
MICR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
MICR ID
Prompt Table:
REMIT_MICR_VW_C
|
| 38 |
CONSOL_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Consolidation Customer SetID
Prompt Table:
SP_SETID_NONVW
|
| 39 |
CONSOL_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Consolidation Customer ID
Prompt Table:
CUST_CONSOL_VW
|
| 40 |
CONSOL_KEY |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice Consolidation Key
|
| 41 |
INTERUNIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 42 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 43 |
AR_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Accounts Recievable Specialist - person responsible for an action on an item.
Prompt Table:
AR_SPCLST_VW
|
| 44 |
MAX_WRITE_OFF_AMT |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Maximum amount allowed for write off on worksheet
|
| 45 |
MAX_WRITE_OFF_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Write off Tolerance Days from Deduction date
|
| 46 |
MAX_WRITE_OFF_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Write off Tolerance Percentage of amount
|
| 47 |
HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
Default Value: N
|
| 48 |
HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before/after Holiday
|
| 49 |
HOL_PROC_OVERFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow due date in next month
Y/N Table Edit
Default Value: Y
|
| 50 |
REBATE_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Rebate Method
C=Pay by Check
M=Issue Credit Memo
N=No Rebate Method
Default Value: N
|
| 51 |
BI_PROMPT_CURR |
Character(1) |
VARCHAR2(1) NOT NULL |
Prompt for Billing Currency
Y/N Table Edit
Default Value: N
|
| 52 |
DEPOSIT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Deposit Percentage
|
| 53 |
DISPLAY_PRICES |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether to display prices.
Y/N Table Edit
Default Value: N
|
| 54 |
CRCARD_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Credit Card Profile ID
Prompt Table:
AR_CRCARD_PRFL
|
| 55 |
PRENOTE_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Prenotification Required
Y/N Table Edit
Default Value: N
|
| 56 |
PRENOTE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Prenotification Status
C=Confirmed
N=New
P=Pending
R=Rejected
S=Submitted
|
| 57 |
PRENOTE_DATE |
Date(10) |
DATE |
Prenotification Date
|
| 58 |
PRENOTE_WAIT_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Prenote Wait Days (U.S.)
|
| 59 |
REASON_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table:
REASON_CD
|
| 60 |
UPDATED_BY |
Character(4) |
VARCHAR2(4) NOT NULL |
This field describes how the Prenote Status was updated.
BANK=Receive Bank EFT File process
CRDD=Create Direct Debits process
DDWS=Direct Debit Worksheet
FEFT=Format EFT File process
FGDS=Financial Gateway - Dispatched
FGPD=Financial Gateway - Paid
FGRJ=Financial Gateway - Rejected
FGWY=Financial Gateway
USER=User
|
| 61 |
HOLD_NBR_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Hold Number of Days
|
| 62 |
FED_HWY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Federal Highway File
Y/N Table Edit
Default Value: N
|
| 63 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 64 |
DATE_LAST_MAINT |
Date(10) |
DATE |
Date Last Maintained
|
| 65 |
AGING_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Aging ID
Prompt Table:
AGING_TBL
|
| 66 |
EIVC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Invoice
Y/N Table Edit
Default Value: N
|
| 67 |
MAXIMUM_INSTALL |
Number(3,0) |
SMALLINT NOT NULL |
Maximum Installemnts
|
| 68 |
MIN_SOURCE_BAL |
Number(10,0) |
DECIMAL(10) NOT NULL |
Minimum Source Balance
|
| 69 |
PLAN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Plan type
A=Custom
C=Fixed Monthly Amounts
D=Number of Months
|
| 70 |
PROCESSING_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing fee
F=Fixed Amount
P=Percentage of Plan Balance
|