| # |
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:
SP_SETID_NONVW
|
| 2 |
PRCS_OPTION_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Processing Option ID
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
SHIP_TYPE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table:
SHIP_METHOD
|
| 6 |
FREIGHT_TERMS |
Character(10) |
VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table:
FREIGHT_TERMS
|
| 7 |
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
|
| 8 |
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: N
|
| 9 |
DISP_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
Default Value: PRN
|
| 10 |
RFQ_DISP_MTHD |
Character(3) |
VARCHAR2(3) NOT NULL |
RFQ Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
Default Value: PRN
|
| 11 |
CNTRCT_DISP_MTHD |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Dispatch Method
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
Default Value: PRN
|
| 12 |
RTV_DISP_MTHD |
Character(3) |
VARCHAR2(3) NOT NULL |
RTV Dispatch Method
EDX=Electronic Document Exchange
EML=Email Dispatch
FAX=Fax Transmission
PHN=Phone Dispatch
PRN=Print
Default Value: PRN
|
| 13 |
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
Prompt Table:
PO_ACCT_IND_VW
|
| 14 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date
|
| 15 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
Prompt Table:
DST_CNTRL_VW
|
| 16 |
CHECK_INV_QTY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Inventory Available Qty
Y/N Table Edit
Default Value: N
|
| 17 |
PARTIAL_QTY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Qtys Can Ship
Y/N Table Edit
Default Value: N
|
| 18 |
COMBO_EDIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Combinations
Y/N Table Edit
Default Value: N
|
| 19 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
Default Value: G
|
| 20 |
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
Default Value: 1
|
| 21 |
TRFT_RULE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Arbitration Rule Code.
Prompt Table:
FRT_RULE_VW
Set Control Field: PRCS_OPTION_ID
|
| 22 |
FRT_CHRG_METHOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
|
| 23 |
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
|
| 24 |
AUTO_ROUND_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatic UOM Round Option
1=No Warning
2=Warning
3=Error
Default Value: 1
|
| 25 |
DISP_CO_BU_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Transmit Change Orders
Y/N Table Edit
Default Value: Y
|
| 26 |
OPEN_PERIOD_EDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Open Period
E=Error
N=None
W=Warning
Default Value: N
|
| 27 |
ITM_NOT_STOCK_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Item Not Stocked at Inv Unit
E=Error out
P=Source to PO
Default Value: E
|
| 28 |
POA_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to store whether a not a Purchase Order Ack is required. (stored at PO BU and Vendor Loc level)
D=Default to PO BU Settings
N=POA NOT Required
Y=POA Required
Y/N Table Edit
Default Value: N
|
| 29 |
DAYS_HRS_AFTER |
Character(1) |
VARCHAR2(1) NOT NULL |
Days or Hours
D=Days
H=Hours
Default Value: D
|
| 30 |
ACK_ALERT_DISP |
Number(3,0) |
SMALLINT NOT NULL |
Stores # of days after a PO dispatch that a POA should be recieved. Used in POA Alerts
Default Value: 999
|
| 31 |
DAYS_HRS_BEFORE |
Character(1) |
VARCHAR2(1) NOT NULL |
Days or Hours
D=Days
H=Hours
Default Value: D
|
| 32 |
ACK_ALERT_SHIP |
Number(3,0) |
SMALLINT NOT NULL |
Stores # of days prior to shipment that a POA should be recieved. Used in POA Alerts
Default Value: 999
|
| 33 |
POA_CO_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
field to store if a poa is required after a change order.
Y/N Table Edit
Default Value: N
|
| 34 |
POA_SCHED_EARLY |
Number(3,0) |
SMALLINT NOT NULL |
POA tolerance field for days schedule change can be moved before original schedule date
Default Value: 0
|
| 35 |
POA_SCHED_LATE |
Number(3,0) |
SMALLINT NOT NULL |
POA tolerance field for days schedule change can be moved after original schedule date
Default Value: 0
|
| 36 |
POA_QTY_OVER |
Number(3,0) |
SMALLINT NOT NULL |
POA tolerance field for %qty change can be over
Default Value: 999
|
| 37 |
POA_QTY_UNDER |
Number(3,0) |
SMALLINT NOT NULL |
POA tolerance field for %qty change can be under
Default Value: 999
|
| 38 |
POA_PRICE_OVER |
Number(3,0) |
SMALLINT NOT NULL |
POA tolerance field for %price change can be over
Default Value: 999
|
| 39 |
POA_PRICE_UNDER |
Number(3,0) |
SMALLINT NOT NULL |
POA tolerance field for %price change can be under
Default Value: 999
|
| 40 |
CC_DISP_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
ProCard Dispatch Option
A=Default
B=Include Masked Card Info
C=Contact Buyer
D=Contact Cardholder
E=Charge to Card on File
F=No Reference
Default Value: B
|
| 41 |
DFLT_AMTONLY_DNR |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Amount Only PO
Y/N Table Edit
Default Value: N
|
| 42 |
PO_GROUP_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Purchasing Group Option
Y/N Table Edit
Default Value: N
|
| 43 |
ALLOC_PO_GROUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Purchasing Group
Y/N Table Edit
Default Value: N
|
| 44 |
ALLOW_PCD_PO_CLOSE |
Character(1) |
VARCHAR2(1) NOT NULL |
12/07/19 MANINSRI PSFTPO-5336_PcardProcessing
Y/N Table Edit
Default Value: Y
|