| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 AP_DFLT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Session Default Types
A=All Users
C=Primary Permission List
O=User ID
|
| 2 |
OPRCLASS |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator Class
Prompt Table:
OPRCLASS_VW
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 4 |
AP_SESSION_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Name
|
| 5 |
ACTIVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Flag
A=Active
I=Inactive
Default Value: A
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_AP_NONVW
|
| 7 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VNDR_ACTIVE_VW
|
| 8 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
VNDR_LOC_AP_VW
|
| 9 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
VNDR_ADD2_AP_VW
|
| 10 |
GRP_AP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Control Group ID
Prompt Table:
GRP_AP_OPR_VW2
|
| 11 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
Prompt Table:
ORIGIN_AP
|
| 12 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 13 |
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
|
| 14 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
Prompt Table:
CURR_TXN_VW
|
| 15 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 16 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 17 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 18 |
VCHR_BLD_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Voucher Build Code
Prompt Table:
VCHR_BLD_CODE
|
| 19 |
VCHR_DFLT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Defaults
D=Use Defaults
N=No Defaults
Default Value: D
|
| 20 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
Prompt Table:
DST_CNTRL_VW
|
| 21 |
MISC_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Prompt Table:
VCHR_MISC_CD_VW
|
| 22 |
SALETX_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Prompt Table:
VCHR_STX_CD_VW
|
| 23 |
FRGHT_CHARGE_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Prompt Table:
VCHR_FRG_CD_VW
|
| 24 |
VCHR_QV_TEMPLATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Quick Invoice Template
C=Complete
M=Summary
S=Simple
|
| 25 |
CONF_MISC_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Miscellaneous Amt Options
D=Display
G=Gray
H=Hide
Default Value: D
|
| 26 |
CONF_FRGT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Freight Amt Options
D=Display
G=Gray
H=Hide
Default Value: D
|
| 27 |
CONF_SLTX_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Tax Amt Option
D=Display
G=Gray
H=Hide
Default Value: D
|
| 28 |
CONF_VAT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Amount Option
D=Display
G=Gray
H=Hide
Default Value: D
|
| 29 |
CONF_PO_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchase Order Options
D=Display
G=Gray
H=Hide
Default Value: D
|
| 30 |
CONF_RECV_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Receiver Options
D=Display
G=Gray
H=Hide
Default Value: D
|
| 31 |
VCHR_TTL_LINES |
Number(5,0) |
INTEGER NOT NULL |
Lines Entered
|
| 32 |
TOTAL_DISTRIBS |
Number(5,0) |
INTEGER NOT NULL |
Total Number of Distributions
|