| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
|
| 2 |
VOUCHER_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Numbering
Y/N Table Edit
Default Value: N
|
| 3 |
VCHR_NUM_LAST_USED |
Number(8,0) |
INTEGER NOT NULL |
Last Voucher Number
|
| 4 |
GRP_AP_ID_LASTUSED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Group ID last assigned
|
| 5 |
GRP_AP_NUM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Id Auto Numbering Option
Y/N Table Edit
Default Value: N
|
| 6 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BUPRCR_NONVW
|
| 7 |
BU_PSGL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Using PS/GL
Y/N Table Edit
Default Value: N
|
| 8 |
POST_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Option
Y/N Table Edit
Default Value: Y
|
| 9 |
POST_DT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Date Indicator
A=Use Accounting Date
C=Use Current Date
P=Post All Transactions
S=Use Specific Date
Default Value: C
|
| 10 |
POST_THRU_DT |
Date(10) |
DATE |
Post Thru Date
|
| 11 |
COMBINE_PYMNT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Combine Pymnt Option
Y/N Table Edit
Default Value: N
|
| 12 |
DB_NUMBER |
Character(9) |
VARCHAR2(9) NOT NULL |
DUNS Number
|
| 13 |
PO_NUM_LAST_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Encumbrance Number
|
| 14 |
PO_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Orders
Y/N Table Edit
Default Value: N
|
| 15 |
REQ_NUM_LAST_USED |
Number(10,0) |
DECIMAL(10) NOT NULL |
Last Pre Encumbrance Number
|
| 16 |
REQ_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Requisitions
Y/N Table Edit
Default Value: N
|
| 17 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
Prompt Table:
DST_CNTRL_TBL
|
| 18 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 19 |
POST_UNAPPRV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Unapproved Vouchers
Y/N Table Edit
Default Value: Y
|
| 20 |
POST_UNMATCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Unmatched Vouchers
Y/N Table Edit
Default Value: Y
|
| 21 |
CNTRCT_REL_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Release Date Option
A=Any Date
C=Current Date
N=No Date
P=Period End Dt
S=Specific Dt
Default Value: C
|
| 22 |
CONTRACT_REL_DT |
Date(10) |
DATE |
Contract Release Date
|
| 23 |
REVALUE_OPTION |
Character(4) |
VARCHAR2(4) NOT NULL |
Revaluation Posting Option
BUS=Business Unit
VCHR=Voucher
VNDR=Supplier
Default Value: VCHR
|
| 24 |
ASSTN_ALG_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Document Association
Prompt Table:
AP_ASSTN_ALGHDR
|
| 25 |
HOL_PROC_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing level
B=Specify Calendar at Bank level
U=Specify Calendar
Default Value: B
|
| 26 |
USE_BUS_DAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Business Day
Y/N Table Edit
Default Value: N
|
| 27 |
GO_NXT_PRV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Go Next or Prior Business Day
N=Next Business Day
P=Prior Business Day
Default Value: P
|
| 28 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
Prompt Table:
BUS_CAL_HOL_DFN
|
| 29 |
HIDE_SUT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hide Sales Use Tax
Y/N Table Edit
Default Value: N
|
| 30 |
HIDE_VAT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hide Value Added Tax
Y/N Table Edit
Default Value: N
|
| 31 |
VCHR_SUT_MSG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales and Use Tax Edit Message
E=Error Message
N=No Message
W=Warning Message
Default Value: W
|
| 32 |
VCHR_VAT_MSG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Value Added Tax Edit Message
E=Error Message
N=No Messages
W=Warning Message
Default Value: W
|
| 33 |
SBI_DOC_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
SBI Numbering Option
D=Default from Higher Level
G=Group Vouchers (Auto-Num)
I=Individual Voucher (Auto-Num)
P=Individual Vchr-Invoice Number
Default Value: D
|
| 34 |
ERS_OPT_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Option
D=Default from Higher Level
N=No ERS
Y=Allow ERS
Default Value: D
|
| 35 |
ERS_INV_DT_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Invoice Date
D=Default from Higher Level
F=Freight Terms
R=Receipt Date
Default Value: D
|
| 36 |
ERS_TAX_TYPE_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
ERS Tax Type
B=Sales Tax
D=Default from Higher Level
N=No Taxes
U=Use Tax
V=Value Added Tax
Default Value: D
|
| 37 |
VCHR_MTCH_ADJ_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Match Exception Adjustment Opt
A=Automatic Generate
N=None
S=Stage
Default Value: N
|
| 38 |
VCHR_TAX_ADJ_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Tax Adjustment Option
A=Automatic
N=None
P=Pending
S=Stage to Pending File
Default Value: N
|
| 39 |
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
|
| 40 |
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
|
| 41 |
RTV_VCHR_ADJ_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Adjust Option
A=Create Adjustment
N=No adjustment
S=Stage to Pending File
Default Value: N
|
| 42 |
RTV_DEBIT_MEMO |
Character(1) |
VARCHAR2(1) NOT NULL |
RTV Debit Memo
Y/N Table Edit
Default Value: N
|
| 43 |
VCHR_BLD_DEFN |
Character(10) |
VARCHAR2(10) NOT NULL |
Voucher Build Criteria
Prompt Table:
VCHR_BLD_DEFN
|
| 44 |
RECEIPT_DELAY_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Receipt Delay Days
|
| 45 |
MTCH_ADJ_DELAY_DAY |
Number(3,0) |
SMALLINT NOT NULL |
Match Adjust Delay Days
|
| 46 |
PAY_TRM_BSE_DT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Terms Basis Date Type
A=Acct Date
C=Doc Date
I=Inv Date
R=Recpt Date
S=Ship Date
U=User Date
Default Value: I
|
| 47 |
CUR_EXC_DT_SRC_DFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cur Exc Dt Src Default
A=Accounting Dt
D=Default
I=Invoice Dt
Default Value: D
|
| 48 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table:
SHIPTO_VW
|
| 49 |
COPYTO_GROSS_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Gross Amount to Voucher
Y/N Table Edit
Default Value: Y
|
| 50 |
EARLY_PY_RSN_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Early Payment Reason Code
Prompt Table:
XPYM_RSN_SY_VW
|
| 51 |
TSYMBOL_ATTRIB |
Character(16) |
VARCHAR2(16) NOT NULL |
Treasury Symbol Attribute
|
| 52 |
LATE_PY_RSN_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Late Payment Reason Code
Prompt Table:
XPYM_RSN_SY_VW
|
| 53 |
LATE_CHRG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Late Charge Option
C=Compute Charges
N=Not Applicable
Default Value: N
|
| 54 |
LATE_CHRG_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Late Charge Code
Prompt Table:
LATE_CHRG_VW
|
| 55 |
APPL_CREDIT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Auto Credit Application
A=Allow Auto Credit Application
N=No Auto Credit Application
Default Value: N
|
| 56 |
REAL_TIME_POST |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Real-Time Posting
Y/N Table Edit
Default Value: N
|
| 57 |
POST_TO_GL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Post to Ledger
Y/N Table Edit
Default Value: N
|
| 58 |
POST_PREPAID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prepayment Application
Y/N Table Edit
Default Value: N
|
| 59 |
GFEE_RUN_EEG |
Character(1) |
VARCHAR2(1) NOT NULL |
Checkbox to determine whether to run Entry Event during a batch process.
Y/N Table Edit
|
| 60 |
LARGE_VCHR_DEFN |
Number(8,0) |
INTEGER NOT NULL |
Large Voucher Definition
Default Value: 200
|
| 61 |
PROCESS_LINES_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process order lines online
Y/N Table Edit
Default Value: N
|
| 62 |
TAX_VENDOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Provider
A=Taxware
N=None
V=Vertex
Default Value: N
|
| 63 |
TAX_COMPANY |
Character(5) |
VARCHAR2(5) NOT NULL |
Company for Tax Suppliers
|
| 64 |
TAX_DIVISION |
Character(5) |
VARCHAR2(5) NOT NULL |
Division for Tax Suppliers
|
| 65 |
ULTIMATE_USE_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Ultimate Use Code
Prompt Table:
SUT_USE_CD
Set Control Field: SETID
|
| 66 |
INCLUDE_FREIGHT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Freight Product Code
Y/N Table Edit
Default Value: Y
|
| 67 |
FRGHT_PRODUCT_CD |
Character(18) |
VARCHAR2(18) NOT NULL |
Freight Product Code
|
| 68 |
TAX_POST_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Posting Option. This will control what types of transactions are written to the Vertex Register or TaxWare Audit file. Options Are:
For Accrued Transactions Only. Only Use Tax Applicable and Direct Pay Transaction lines will be written to the Tax Software reporting files.
For Taxable Transactions, any taxable transaction line, whether it is Sales Tax, Use Tax, or Direct Pay will be written to the Tax Software reporting files. For all transactions, all transactions whether Taxable or Non-Taxable will be written to the Tax Software reporting files.
A=All Transactions
R=Accrued Transactions Only
T=Taxable Transactions Only
|
| 69 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table:
FREIGHT_TERMS
Set Control Field: BUSINESS_UNIT
|
| 70 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
Set Control Field: BUSINESS_UNIT
|
| 71 |
MATCH_APPRV_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Matching for Voucher Approval
Y/N Table Edit
Default Value: N
|
| 72 |
SUMM_TOL_PCT_OVER |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Tolerance Percent Over
|
| 73 |
SUMM_TOL_PCT_UNDER |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Tolerance Percent Under
|
| 74 |
SUMM_TOL_AMT_OVER |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tolerance Amount over
|
| 75 |
SUMM_TOL_AMT_UNDER |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tolerance Amount Under
|
| 76 |
SUMM_TOL_CUR_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Tolerance Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 77 |
SUMM_TOL_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Tolerance Currency Rate Type
Prompt Table:
CUR_RT_TYPE_TBL
|
| 78 |
SUMM_TOL_MISC_CHG |
Character(10) |
VARCHAR2(10) NOT NULL |
Tolerance Misc Charge Code
Prompt Table:
VCHR_MISC_CD_VW
Set Control Field: BUSINESS_UNIT
|
| 79 |
MATCH_DELAY_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Match Delay Days
|
| 80 |
DST_COPY_PO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Template
Y/N Table Edit
Default Value: N
|
| 81 |
PTRMS_COPY_PO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Terms
Y/N Table Edit
Default Value: N
|
| 82 |
VLOC_COPY_PO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier Location
Y/N Table Edit
Default Value: N
|
| 83 |
DISPLAY_GLN |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow GLN Display
N=No
Y=Yes
Default Value: N
|