| # |
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 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
ACCOUNTING_DT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Date Indicator
C=Use Current Date
D=Business Unit Default
P=Use Payment Date
S=Use Specific Date
Default Value: C
|
| 5 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 6 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 7 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 8 |
PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
Default Value: CHK
|
| 9 |
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:
PYMT_TR_EFF_VW
|
| 10 |
PYMNT_TERMS_CD_PPY |
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:
PYMT_TR_EFF_VW
|
| 11 |
DSCNT_ALWAYS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Always take discount
Y/N Table Edit
Default Value: Y
|
| 12 |
DSCNT_DELAY_DAYS |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Discount Delay Days
|
| 13 |
PYMNT_DELAY_DAYS |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Payment Delay Days
|
| 14 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
Prompt Table:
PYMNT_HNDL_TBL
|
| 15 |
DUP_INVOICE_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Invoice Severity
K=Reject
R=Recycle
W=Warning
Default Value: K
|
| 16 |
DUP_INV_NUM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Number
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 17 |
DUP_INV_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Date
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 18 |
DUP_INV_VENDOR_NUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Vendor ID
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 19 |
DUP_INV_GROSS_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Gross Amount
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 20 |
DUP_INV_BUS_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 21 |
DUP_INV_COMB_CODE |
Number(3,0) |
SMALLINT NOT NULL |
Dupl Invoice Combination Code
|
| 22 |
GRP_AP_POST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Option
1=Post Vouchers as Group
2=Post Vouchers Individually
Default Value: 2
|
| 23 |
VCHR_BALANCE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Balance Option
D=Default from Higher Level
K=Reject Unbalanced Vouchers
R=Recycle Unbalanced Vouchers
Default Value: K
|
| 24 |
CHART_EDIT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Chartfield Edit Option
D=Default from Higher Level
K=Reject w/ edit error
N=No Edits
R=Recycle
S=Use suspense account
W=Warning
Default Value: K
|
| 25 |
COMBO_EDIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Combinations
Y/N Table Edit
Default Value: N
|
| 26 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_CD_VW
|
| 27 |
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:
BANK_ACCT_VW19
|
| 28 |
VCHR_APPRVL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Approval Flag
D=Default from Higher Level
P=Pre-Approved
S=Virtual Approver
W=Approval Framework
Default Value: P
|
| 29 |
BUSPROCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table:
BUSPROCNAME_VW
|
| 30 |
APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table:
APPR_RULE_HDR
|
| 31 |
ROLENAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table:
ROLE_USRLST_VW
|
| 32 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table:
SHIPTO_TBL
|
| 33 |
SUT_BASE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
Prompt Table:
SHIPTO_TBL
|
| 34 |
SALETX_TOL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Tax Tolerance Flag
D=Default from Higher Level
S=Specify at this Level
Default Value: S
|
| 35 |
SALETX_TOL_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Sales Tax Tolerance Percent
|
| 36 |
SALETX_TOL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Tolerance Amount
|
| 37 |
SALETX_TOL_CUR_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Sales Tax Tolerance Curr Code
Prompt Table:
CURRENCY_CD_TBL
|
| 38 |
SALETX_TOL_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Sales Tax Tolerance Rate Type
Prompt Table:
CUR_RT_TYPE_TBL
|
| 39 |
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.
Prompt Table:
DOC_TYPE_TBL
|
| 40 |
RECEIPT_AWARE |
Character(1) |
VARCHAR2(1) NOT NULL |
Receipt Awareness Level
H=Find receipts by quantity
L=Use receipts on voucher only
M=Sum all receipts for PO
Default Value: M
|
| 41 |
PROCESS_PPV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Price Variance
Y/N Table Edit
Default Value: N
|
| 42 |
PROCESS_ERV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Exchange Rate Variance
Y/N Table Edit
Default Value: N
|
| 43 |
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
|
| 44 |
HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before/after Holiday
|
| 45 |
HOL_PROC_OVERFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow due date in next month
Y/N Table Edit
Default Value: N
|
| 46 |
RECALC_SUT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalculate Sales/Use Tax
Y/N Table Edit
Default Value: N
|
| 47 |
TAX_ADJ_DIFF_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
SUT Difference Opt
A=Accrue Difference
N=Not Applicable
S=Short Pay
Default Value: N
|
| 48 |
TAX_ADJ_LIMIT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment Limit Option
B=Both Over/Under
N=Not Applicable
O=Over
U=Under
Default Value: N
|
| 49 |
VCHR_TAX_ADJ_DFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales and Use Tax Adjustments
A=Automatic
D=Default
N=None
S=Stage to Pending File
Default Value: D
|
| 50 |
DFT_SIGHT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Draft Sight Code
Prompt Table:
APD_SIGHTCD_TBL
|
| 51 |
DFT_APPROVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Issue Approval Required
Y/N Table Edit
Default Value: Y
|
| 52 |
DATE_CALC_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Calculation Basis
A=Agricultural Commodities
D=Dairy
M=Meat
O=Poultry
P=Prompt Pay Basis 7 Days
Q=Prompt Pay Basis 14 Days
|
| 53 |
PAY_SCHEDULE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Schedule Type
MAN=Manual
OTH=Other Non Transportation
TRN=Transportation
|
| 54 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_VW4
|
| 55 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 56 |
VAT_SVC_PERFRM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
|
| 57 |
PREPAID_AUTO_APPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Apply Prepayment
Y/N Table Edit
Default Value: Y
|
| 58 |
AP_WF_RQSTR_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Workflow requestor option
L=Last Updated by user
O=Originator
Default Value: O
|
| 59 |
REQ_VALID_KKDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Require Valid Budget Check and Document Tolerance Check
Y/N Table Edit
Default Value: Y
|
| 60 |
ENABLE_DCM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Content Management Invoice Integration
Y/N Table Edit
Default Value: N
|
| 61 |
DCM_AUTO_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
DCM Auto Hold
H=All Invoices Must Be Reviewed
L=Process Valid Invoices
Default Value: H
|
| 62 |
DCM_NOTIFY_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Notification option
E=Email Notification
N=No Notification
Default Value: N
|
| 63 |
DCM_NOTIFY_ROLE |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table
Prompt Table:
ROLE_USRLST_VW
|
| 64 |
DCM_ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Default origin for Imaging invoices
Prompt Table:
ORIGIN_AP
|
| 65 |
DCM_AUTO_RUN |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Run Voucher Build
Y/N Table Edit
Default Value: N
|
| 66 |
DCM_INC_DIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Incomplete distribution
Y/N Table Edit
Default Value: N
|