AUC_DFLT_TBL(SQL Table) |
Index Back |
---|---|
Event Line Defaults TableUsed 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 |