AUC_DFLT_TBL

(SQL Table)
Index Back

Event Line Defaults Table

Used to store Sourcing event line Defaults

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: AUC_HDR.BUSINESS_UNIT

2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID

Default Value: AUC_HDR.AUC_ID

3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
5 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
6 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

7 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD

8 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIPTO_TBL

9 SHIP_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Ship From Location

Prompt Table: LOCATION_TBL

10 DEFAULT_OPT Character(1) VARCHAR2(1) NOT NULL Default Options
D=Default
O=Override

Default Value: D

11 AUC_ALT_UOM Character(1) VARCHAR2(1) NOT NULL Alternate Units of Measure
A=Any UOM
I=Only existing item/uom's
N=Not Allowed

Default Value: N

12 AUC_BF_DFLT_APPLY Character(1) VARCHAR2(1) NOT NULL Bid Factor Defaults Option
A=Apply Bid Factor Defaults
X=Do Not Apply - Disabled

Default Value: X

13 AUC_BF_DFLT_PRC_FL Character(1) VARCHAR2(1) NOT NULL Override Start Price Weight

Y/N Table Edit

Default Value: N

14 AUC_BF_START_WT Signed Number(10,5) DECIMAL(8,5) NOT NULL Start Price Weighting Default
15 AUC_BF_IGNORE_FLG Character(1) VARCHAR2(1) NOT NULL Ignore Setup Default Rules

Y/N Table Edit

Default Value: N

16 AUC_BF_DFLT_COPY Character(1) VARCHAR2(1) NOT NULL Append To on Copy From Event

Y/N Table Edit

Default Value: N