| # |
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
Prompt Table:
SP_BU_AP_NONVW
|
| 2 |
GRP_AP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Control Group ID
Default Value: NEXT
Prompt Table:
GRP_AP
|
| 3 |
GROUP_TYPE_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Group Type
S=System Defined
U=User Defined
|
| 4 |
GROUP_DT |
Date(10) |
DATE |
Group Control Date
Default Value: %date
|
| 5 |
GRP_AP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status of Control Group
A=Assigned
E=Entry Set Aside
O=Open
R=Ready for Review
S=Supervisor Set Aside
V=Verified
Default Value: O
|
| 6 |
CTL_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Control Gross Amount
|
| 7 |
CTL_VOUCHERS |
Number(6,0) |
INTEGER NOT NULL |
Control Voucher Number
|
| 8 |
GRP_AP_TAPE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Run a Tape
Y/N Table Edit
Default Value: N
|
| 9 |
ASSIGNED_BY_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Group Assigned by
|
| 10 |
ASSIGNED_TO_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Assigned to
Prompt Table:
%EDTCHAR_USER1
|
| 11 |
DTTM_ASSIGNED |
DateTime(26) |
TIMESTAMP |
Date/Time Assigned
|
| 12 |
DTTM_DUE |
DateTime(26) |
TIMESTAMP |
Date/Time Due
|
| 13 |
DTTM_COMPLETE |
DateTime(26) |
TIMESTAMP |
Date/Time Completed
|
| 14 |
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
|
| 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 |
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
|
| 23 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 24 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 25 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
CUR_RT_TYPE_TBL
|
| 26 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
Prompt Table:
DST_CNTRL_VW
|
| 27 |
POST_TIMING |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Timing
G=Post Only when Group Balanced
V=Post Vouchers Individually
Default Value: V
|
| 28 |
POST_ACTION_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Group
D=Post on a Deferred basis
N=Do Not Post
P=Post Immediately
Default Value: P
|
| 29 |
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
|
| 30 |
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
|
| 31 |
COMBO_EDIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Combinations
Y/N Table Edit
Default Value: N
|
| 32 |
VOUCHER_NUM_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Numbering
Y/N Table Edit
Default Value: N
|
| 33 |
VCHR_NUM_BEGIN |
Number(8,0) |
INTEGER NOT NULL |
Starting From
|
| 34 |
VCHR_NUM_END |
Number(8,0) |
INTEGER NOT NULL |
Ending
|
| 35 |
VCHR_NUM_LAST_USED |
Number(8,0) |
INTEGER NOT NULL |
Last Voucher Number
|
| 36 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 37 |
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
|
| 38 |
BUSPROCNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table:
BUSPROCNAME_VW
|
| 39 |
APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table:
APPR_RULE_HDR
|
| 40 |
PYMNT_TIMING |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Timing
G=Pay Only when Group Balanced
V=Pay Vouchers Individually
Default Value: V
|
| 41 |
PAY_VERIFIED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Only Pay Verified Groups
Y/N Table Edit
Default Value: Y
|
| 42 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table:
SHIPTO_TBL
|
| 43 |
SUT_BASE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
Prompt Table:
SHIPTO_TBL
|
| 44 |
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
|
| 45 |
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
|
| 46 |
SALETX_TOL_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Sales Tax Tolerance Percent
|
| 47 |
SALETX_TOL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Tolerance Amount
|
| 48 |
SALETX_TOL_CUR_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Sales Tax Tolerance Curr Code
Prompt Table:
CURRENCY_CD_TBL
|
| 49 |
SALETX_TOL_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Sales Tax Tolerance Rate Type
Prompt Table:
CUR_RT_TYPE_TBL
|
| 50 |
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
|
| 51 |
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
|
| 52 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 53 |
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
|
| 54 |
ULTIMATE_USE_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Ultimate Use Code
Prompt Table:
SUT_USE_CD
|
| 55 |
ULT_USE_CD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ultimate Use Code
D=Default from higher
S=Specified
Default Value: D
|
| 56 |
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
|
| 57 |
MATCH_DELAY_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Match Delay Days
|