| # |
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:
SETID_TBL
|
| 2 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 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 |
POST_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Option
Y/N Table Edit
Default Value: Y
|
| 6 |
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: D
|
| 7 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 8 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 9 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
CUR_RT_TYPE_TBL
|
| 10 |
DUP_INVOICE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Invoice Indicator
D=Default from Higher Level
S=Specify at this Level
Default Value: D
|
| 11 |
DUP_INVOICE_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Duplicate Invoice Severity
K=Reject
R=Recycle
W=Warning
Default Value: K
|
| 12 |
DUP_INV_NUM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Number
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 13 |
DUP_INV_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Date
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 14 |
DUP_INV_VENDOR_NUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Vendor ID
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 15 |
DUP_INV_GROSS_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Gross Amount
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 16 |
DUP_INV_BUS_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 17 |
DUP_INV_COMB_CODE |
Number(3,0) |
SMALLINT NOT NULL |
Dupl Invoice Combination Code
|
| 18 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_CD_VW
|
| 19 |
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_TBL
|
| 20 |
GRP_AP_POST_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Option
1=Post Vouchers as Group
2=Post Vouchers Individually
Default Value: 1
|
| 21 |
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: D
|
| 22 |
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: D
|
| 23 |
COMBO_EDIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Combinations
Y/N Table Edit
Default Value: N
|
| 24 |
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
|
| 25 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
Prompt Table:
PYMNT_HNDL_TBL
|
| 26 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
Prompt Table:
DST_CNTRL_VW
|
| 27 |
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: D
|
| 28 |
BUSPROCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table:
BUSPROCNAME_VW
|
| 29 |
APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table:
APPR_RULE_HDR
|
| 30 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table:
SHIPTO_TBL
|
| 31 |
SUT_BASE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
Prompt Table:
SHIPTO_TBL
|
| 32 |
SHIP_LOC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship To/End Location Flag
D=Default from Higher Level
S=Specify at this Level
Default Value: D
|
| 33 |
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: D
|
| 34 |
SALETX_TOL_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Sales Tax Tolerance Percent
|
| 35 |
SALETX_TOL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Tolerance Amount
|
| 36 |
SALETX_TOL_CUR_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Sales Tax Tolerance Curr Code
Prompt Table:
CURRENCY_CD_TBL
|
| 37 |
SALETX_TOL_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Sales Tax Tolerance Rate Type
Prompt Table:
RT_TYPE_TBL
|
| 38 |
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
|
| 39 |
DOC_TYPE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Type Flag
D=Default from Higher Level
S=Specify at This level
Default Value: D
|
| 40 |
DFT_SIGHT_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Draft Sight Code
Prompt Table:
APD_SIGHTCD_TBL
|
| 41 |
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
|
| 42 |
PAY_SCHEDULE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Schedule Type
MAN=Manual
OTH=Other Non Transportation
TRN=Transportation
|
| 43 |
LATE_CHRG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Charges
D=Default from Higher Level
S=Specify
Default Value: D
|
| 44 |
LATE_CHRG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Charge Option
C=Compute Charges
N=Not Applicable
Default Value: N
|
| 45 |
LATE_CHRG_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Late Charge Code
Prompt Table:
LATE_CHRG_VW
|
| 46 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 47 |
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
|
| 48 |
ULTIMATE_USE_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Ultimate Use Code
Prompt Table:
SUT_USE_CD
|
| 49 |
ULT_USE_CD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ultimate Use Code
D=Default from higher
S=Specified
Default Value: D
|
| 50 |
MATCH_DELAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
To indicate whether Match Delay Days is specified at this level or to be defaulted from higher level in the AP defaulting hierarchy.
D=Default from Higher Level
S=Specified at This Level
Default Value: D
|
| 51 |
MATCH_DELAY_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Match Delay Days
|