BUS_UNIT_TBL_OM

(SQL Table)
Index Back

OM Business Unit Table

This table stores the processing defaults for an Order Management Business Unit. Certain processing might happen "behind the scenes", and this table stores the directions and defaults used in processing Order Management transactions. i.e. what hold code to use when putting an order on hold for credit violations. Date Init. Issue # Description 081401 JJM F-CJORGENS-6 Added PROC_CR_CARD and PROC_CR_CARD_BG fields 081701 KTW F-CJORGENS-18 Added CALENDER_ID field 091301 dms F-CJORGENS-11 Add REASON_CD 091901 dms 8.4 Add RMA_BILL_BY_ID 112001 JJM F-CJORGENS-6 Del PROC_CR_CARD_BG field 112901 edw DI-AMAN-324 Chg add vw SP_BU_OM_NONVV 012802 sy Added field SRBT_BILL_BY_ID 112202 KTW F_DMULINAR-3 VAT on Services Add- PHYSICAL_NATURE, VAT_SVC_PERFRM_FLG Del- VAT_TXN_TYPE_CD VAT_DCLRTN_POINT 052504 dms F-KNANN-V59N4 Use subrecord, remove hold flags 092711 mp OM-92-MISC-01 Add OM_TEMPLATE_GR and OM_TEMPLATE_PP fields.

  • Parent Record Of OM_BU_HOLD_FLGS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_OM_NONVW

    2 ACC_DST_RULE_CD Character(10) VARCHAR2(10) NOT NULL Accrued Rev Dist Rule

    Prompt Table: DST_RULE_OM

    3 ACR_DST_ID_REV Character(10) VARCHAR2(10) NOT NULL Accrued Revenue

    Prompt Table: DSTCD_REV_OM_VW

    4 ADJUST_BAPRC_FLG Character(1) VARCHAR2(1) NOT NULL Buying Agreement Price Flag
    N=No
    Y=Yes

    Default Value: N

    5 ALT_SUPPLY_CD Character(10) VARCHAR2(10) NOT NULL Sourcing Arbitration Plan

    Prompt Table: ALT_SOURCE_VW

    6 APPL_JRNL_ID_CB Character(10) VARCHAR2(10) NOT NULL Accrued Revenue Journal Template

    Prompt Table: JRNLGEN_APPL_ID

    7 AUTO_RSRV_FLAG Character(1) VARCHAR2(1) NOT NULL Reserve at Save

    Y/N Table Edit

    Default Value: N

    8 AUTO_LOT_ALLOCATE Character(1) VARCHAR2(1) NOT NULL Lot Allocate at Save

    Y/N Table Edit

    Default Value: N

    9 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

    Prompt Table: SP_BU_AP_NONVW

    10 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

    Prompt Table: SP_BU_BI_NONVW

    11 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

    Prompt Table: SP_BUIN_NONVW

    12 BU_FSS_FLG Character(1) VARCHAR2(1) NOT NULL 02/15/06 EGS: Created

    Y/N Table Edit

    Default Value: N

    13 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier

    Prompt Table: %EDITTABLE

    14 BILL_MARK Character(1) VARCHAR2(1) NOT NULL Mark for Billing at Save
    N=Mark Bill Manually or by Batch
    Y=Marked at Order Save Time
    15 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source

    Prompt Table: %EDITTABLE2

    16 BU_STATUS_OM Character(1) VARCHAR2(1) NOT NULL Business Unit Status
    A=Active
    I=Inactive

    Default Value: A

    17 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL

    18 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

    Prompt Table: %EDITTABLE4

    19 CB_DST_ID_REV Character(10) VARCHAR2(10) NOT NULL Claimback Revenue

    Prompt Table: DSTCD_REV_OM_VW

    20 CB_DST_RULE_CD Character(10) VARCHAR2(10) NOT NULL Claimback Dist Rule

    Prompt Table: DST_RULE_OM

    21 COMMSN_LEVEL Character(1) VARCHAR2(1) NOT NULL Commissions Level
    0=No Commissions
    1=By Header
    2=By Schedule

    Default Value: 1

    22 CR_CHK_CORP Character(1) VARCHAR2(1) NOT NULL Corporate Credit Check
    N=Not Enabled Online
    O=Enabled Online

    Default Value: O

    23 CR_CHK_ORDER Character(1) VARCHAR2(1) NOT NULL Sales Order Entry

    Y/N Table Edit

    Default Value: Y

    24 CR_CHK_ORD_CUST Character(1) VARCHAR2(1) NOT NULL Customer ID Entry

    Y/N Table Edit

    Default Value: N

    25 CR_CHK_QUOTE Character(1) VARCHAR2(1) NOT NULL Quote Entry

    Y/N Table Edit

    Default Value: Y

    26 CR_CHK_QUO_CUST Character(1) VARCHAR2(1) NOT NULL Customer ID Entry

    Y/N Table Edit

    Default Value: N

    27 CR_CHK_FORCE Character(1) VARCHAR2(1) NOT NULL Force Credit Check

    Y/N Table Edit

    Default Value: N

    28 CR_OFF_ORDER Character(1) VARCHAR2(1) NOT NULL Sales Order

    Y/N Table Edit

    Default Value: Y

    29 CR_OFF_QUOTE Character(1) VARCHAR2(1) NOT NULL Quote

    Y/N Table Edit

    Default Value: N

    30 CS_PICK_SORT Character(2) VARCHAR2(2) NOT NULL Counter Sale Pick Plan Sort
    0=IBU/Line
    1=IBU/Loc
    31 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

    Prompt Table: CURRENCY_CD_TBL

    32 CUST_PURCH_RANGE Number(3,0) SMALLINT NOT NULL Purchase History (Months)
    33 CUST_SHIP_RANGE Number(3,0) SMALLINT NOT NULL Ship History for RMAs (Months)
    34 DEL_ORD_RESTRICTED Character(1) VARCHAR2(1) NOT NULL Deliveries restricted to order
    N=Deliveries Not Restricted
    Y=Deliveries Restricted to Order

    Default Value: Y

    35 DEPOSIT_PCT Number(6,2) DECIMAL(5,2) NOT NULL Deposit Percentage
    36 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code

    Prompt Table: DS_NETHDR_TBL

    37 DISPLAY_PICK_OPT Character(1) VARCHAR2(1) NOT NULL Display the Pick Plan on screen or send to print dialog box

    Y/N Table Edit

    Default Value: Y

    38 DISPLAY_RCPT_OPT Character(1) VARCHAR2(1) NOT NULL Display the Receipt on screen or send to print dialog box

    Y/N Table Edit

    Default Value: Y

    39 DST_ID_DEPOSIT Character(10) VARCHAR2(10) NOT NULL Sales Order Deposit distribution code

    Prompt Table: DST_CODE_CDP_VW

    40 DST_ID_DIS Character(10) VARCHAR2(10) NOT NULL Discount Distribution Code

    Prompt Table: DSTCD_DIS_OM_VW

    41 DST_ID_REV Character(10) VARCHAR2(10) NOT NULL Revenue Dist Code

    Prompt Table: DSTCD_REV_OM_VW

    42 DST_ID_SUR Character(10) VARCHAR2(10) NOT NULL Surcharge Distribution Code

    Prompt Table: DSTCD_SUR_OM_VW

    43 DST_ID_VOUCHER Character(10) VARCHAR2(10) NOT NULL Corporate Voucher distribution code

    Prompt Table: DST_CODE_CV_VW

    44 DST_RULE_CD Character(10) VARCHAR2(10) NOT NULL Dist Rule Code

    Prompt Table: DST_RULE_OM

    45 EIN_NUMBER Character(9) VARCHAR2(9) NOT NULL Exporter's EIN Number
    46 EXPORT_CHECK Character(1) VARCHAR2(1) NOT NULL Export Check
    A=All Orders
    E=Export Orders
    47 EXPORT_VENDOR Character(1) VARCHAR2(1) NOT NULL Used by OM/INV.
    N=No
    Y=Yes

    Default Value: N

    48 GEN_DEST_LIC_NBR Character(10) VARCHAR2(10) NOT NULL General Destination License
    49 HOLD_ARRV_DT Character(6) VARCHAR2(6) NOT NULL Arrival Date Window Hold
    50 HOLD_NO_BILL Character(6) VARCHAR2(6) NOT NULL No Bill To

    Prompt Table: HOLD_CD

    51 HOLD_NO_SOLD Character(6) VARCHAR2(6) NOT NULL No Sold To

    Prompt Table: HOLD_CD

    52 HOLD_NO_SHIP Character(6) VARCHAR2(6) NOT NULL No Ship To

    Prompt Table: HOLD_CD

    53 HOLD_CUST_CR Character(6) VARCHAR2(6) NOT NULL Exceeds Customer Credit

    Prompt Table: HOLD_CD

    54 HOLD_CUST_PICKUP Character(6) VARCHAR2(6) NOT NULL Customer Pick Up

    Prompt Table: HOLD_CD

    55 HOLD_CORP_CR Character(6) VARCHAR2(6) NOT NULL Exceeds Corporate Credit

    Prompt Table: HOLD_CD

    56 HOLD_OS_AR Character(6) VARCHAR2(6) NOT NULL Outstanding AR

    Prompt Table: HOLD_CD

    57 HOLD_CREDIT_CRD Character(6) VARCHAR2(6) NOT NULL Credit Card Hold

    Prompt Table: HOLD_CD

    58 HOLD_EXPORT_CANCEL Character(6) VARCHAR2(6) NOT NULL Order Cancelled by Export

    Prompt Table: HOLD_CD

    59 HOLD_EXPORT_CHECK Character(6) VARCHAR2(6) NOT NULL Order Not Checked by Export

    Prompt Table: HOLD_CD

    60 HOLD_EXPORT_HOLD Character(6) VARCHAR2(6) NOT NULL Order on Hold by Export

    Prompt Table: HOLD_CD

    61 HOLD_FREIGHT Character(6) VARCHAR2(6) NOT NULL Freight Hold

    Prompt Table: HOLD_CD

    62 HOLD_MAX_ORDER_AMT Character(6) VARCHAR2(6) NOT NULL Exceeds Maximum Order Amount

    Prompt Table: HOLD_CD

    63 HOLD_MAX_QTY Character(6) VARCHAR2(6) NOT NULL Exceeds Maximum Quantity

    Prompt Table: HOLD_CD

    64 HOLD_MIN_QTY Character(6) VARCHAR2(6) NOT NULL Less Than Minimum Quantity

    Prompt Table: HOLD_CD

    65 HOLD_MAX_MARGIN Character(6) VARCHAR2(6) NOT NULL Exceeds Maximum Margin

    Prompt Table: HOLD_CD

    66 HOLD_MIN_MARGIN Character(6) VARCHAR2(6) NOT NULL Less Than Minimum Margin

    Prompt Table: HOLD_CD

    67 HOLD_MARGIN_RULE Character(6) VARCHAR2(6) NOT NULL Margin Rule Hold

    Prompt Table: HOLD_CD

    68 HOLD_MIN_PRICE Character(6) VARCHAR2(6) NOT NULL < Minimum Selling Price

    Prompt Table: HOLD_CD

    69 HOLD_PRC_DPY Character(6) VARCHAR2(6) NOT NULL Price Discrepancy Hold

    Prompt Table: HOLD_CD

    70 HOLD_SCN_LN_AMT Character(6) VARCHAR2(6) NOT NULL 11092001 YB 8.4 ADDED LABEL ID (9461701)

    Prompt Table: HOLD_CD

    71 HOLD_SCN_MIN_QTY Character(6) VARCHAR2(6) NOT NULL 11092001 YB 8.4 ADDED LABELID(9461701)

    Prompt Table: HOLD_CD

    72 HOLD_SCN_MAX_QTY Character(6) VARCHAR2(6) NOT NULL 11092001 YB 8.4 ADDED LABELID(9461701)

    Prompt Table: HOLD_CD

    73 HOLD_NO_KIT_COMPS Character(6) VARCHAR2(6) NOT NULL No Product Kit Components

    Prompt Table: HOLD_CD

    74 HOLD_CUST_FSS Character(6) VARCHAR2(6) NOT NULL 02/15/06 EGS: Created
    75 HOLD_ORD_FSS Character(6) VARCHAR2(6) NOT NULL 02/15/06 EGS: Created
    76 HOLD_CP Character(6) VARCHAR2(6) NOT NULL Configuration Hold

    Prompt Table: HOLD_CD

    77 HOLD_PROCESS_OPT Character(2) VARCHAR2(2) NOT NULL Online Process
    BG=Background
    NO=None
    OL=Online

    Default Value: NO

    78 HOLD_COUNTRY_SHIP Character(6) VARCHAR2(6) NOT NULL No VAT Country Ship From
    79 HOLD_VMI Character(6) VARCHAR2(6) NOT NULL Supplier Managed Inventory
    80 IN_BEST_WAY_BTN Character(2) VARCHAR2(2) NOT NULL Best Way Freight Option
    10=Least Cost
    20=By Commit Date

    Default Value: 10

    81 IN_FRT_RATE_SHOP Character(1) VARCHAR2(1) NOT NULL Allow Freight Rate Shopping
    1=Never
    2=Optional
    3=Always

    Default Value: 1

    82 IN_FRT_USAGE Character(2) VARCHAR2(2) NOT NULL Indicator of internal or external freight
    10=Internal
    20=External
    30=None
    40=Both

    Default Value: 30

    83 IN_PREPAYMT_FLG Character(1) VARCHAR2(1) NOT NULL Incl Pending Payment in Credit

    Y/N Table Edit

    Default Value: N

    84 INC_DEPOSIT_FLG Character(1) VARCHAR2(1) NOT NULL Allow Deposit in Credit Check

    Y/N Table Edit

    Default Value: N

    85 INV_EXP_CANCEL Character(1) VARCHAR2(1) NOT NULL OK to ship - Export Cancel
    86 INV_EXP_CHECK Character(1) VARCHAR2(1) NOT NULL OK to ship - Export Check
    87 INV_EXP_HOLD Character(1) VARCHAR2(1) NOT NULL OK to ship - Export Hold
    88 MAX_SOURCE_LINES Number(5,0) INTEGER NOT NULL Maximum Source of Supply Rows

    Default Value: 100

    89 MM_ADJUST Character(1) VARCHAR2(1) NOT NULL Allow Margin Adjustment
    B=Sales Order & Quote
    N=Not Enabled
    Q=Quote Only
    S=Sales Order Only

    Default Value: N

    90 OMBI_ADJ_DSPLY_OPT Character(2) VARCHAR2(2) NOT NULL Total Order/Load Adjustment Display Option. This field determines whether total order and load price adjustments will be invoiced as individual invoice lines or as adjustments to lines for goods or services.
    01=Individual Invoice Lines
    02=Adjustments to Invoice Lines

    Default Value: 01

    91 OMBI_PRC_ADJ_OPT Character(1) VARCHAR2(1) NOT NULL Price Adjustment Detail Option
    1=Netted with Revenue
    2=As Account Distribution
    3=As Disc/Surch Detail

    Default Value: 2

    92 OPT_AVAIL Character(1) VARCHAR2(1) NOT NULL Availability Check Flag
    93 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services

    Default Value: G

    94 PO_UPDT_FENCE Character(2) VARCHAR2(2) NOT NULL Allow PO Changes Until
    1=Dispatched
    2=Due Date

    Default Value: 2

    95 PROC_ADDR_DISPLAY Character(2) VARCHAR2(2) NOT NULL Customer Address
    IN=Initialization
    NO=None

    Default Value: NO

    96 PROC_AVAIL_OPT Character(1) VARCHAR2(1) NOT NULL Availability Option - Online
    1=None
    2=Network
    3=Manual
    4=Automatic

    Default Value: 1

    97 PROC_AVAIL_OPT_BG Character(1) VARCHAR2(1) NOT NULL Availability Option - Batch
    1=None
    2=Network
    4=Automatic

    Default Value: 1

    98 PROC_CR_CARD Character(2) VARCHAR2(2) NOT NULL Process Credit Card Authorization Online Date Init. Issue # Description 08/14/01 JJM F-CJORGENS-6 Credit Card Enhancements - Created Field
    NO=Not Enabled
    OL=Enabled

    Default Value: OL

    99 PROC_DISP_BLL Character(1) VARCHAR2(1) NOT NULL Bill To Area
    0=Default
    1=Collapsed
    2=Open

    Default Value: 0

    100 PROC_DISP_HDR Character(1) VARCHAR2(1) NOT NULL Header Information Area
    0=Default
    1=Collapsed
    2=Open

    Default Value: 0

    101 PROC_DISP_OTS Character(1) VARCHAR2(1) NOT NULL Price Summary Area
    0=Default
    1=Collapsed
    2=Open

    Default Value: 0

    102 PROC_DISP_PUR Character(1) VARCHAR2(1) NOT NULL Purchase History Area
    0=Default
    1=Collapsed
    2=Open

    Default Value: 0

    103 PROC_DISP_SLD Character(1) VARCHAR2(1) NOT NULL Sold To Area
    0=Default
    1=Collapsed
    2=Open

    Default Value: 0

    104 PROC_DISP_SHP Character(1) VARCHAR2(1) NOT NULL Ship To Area
    0=Default
    1=Collapsed
    2=Open

    Default Value: 0

    105 PROC_EST_SHIP Character(2) VARCHAR2(2) NOT NULL Flag for how to process estimated shipments.
    NO=None
    OL=Field Change
    OS=Order Save

    Default Value: NO

    106 PROC_EST_SHIP_BG Character(2) VARCHAR2(2) NOT NULL Process Deliveries
    BG=Background
    NO=None

    Default Value: NO

    107 PROC_EX_CAL Character(2) VARCHAR2(2) NOT NULL Process Exception Calendars
    NO=None
    OL=Field Change
    OS=Order Save

    Default Value: NO

    108 PROC_EX_CAL_BG Character(2) VARCHAR2(2) NOT NULL Process Exception Calendars
    BG=Background
    NO=None

    Default Value: NO

    109 PROC_FREIGHT Character(2) VARCHAR2(2) NOT NULL Process Freight Charges
    MN=Manual
    NO=None
    OL=Online

    Default Value: NO

    110 PROC_FREIGHT_BG Character(2) VARCHAR2(2) NOT NULL Process PSFT Freight Charges
    BG=Background
    NO=None

    Default Value: NO

    111 PROC_LOAD_PRC Character(2) VARCHAR2(2) NOT NULL OM BU load pricing process flag
    MN=Manually
    NO=None
    OL=Order Save

    Default Value: NO

    112 PROC_LOAD_PRC_BG Character(2) VARCHAR2(2) NOT NULL OM BU load pricing background process flag
    BG=Background
    NO=None

    Default Value: NO

    113 PROC_SCON_MSG Character(1) VARCHAR2(1) NOT NULL Show Buying Agreement Message

    Y/N Table Edit

    Default Value: Y

    114 PROC_TRNSPT_LEAD Character(2) VARCHAR2(2) NOT NULL Process Transport Lead Times
    NO=None
    OL=Field Change
    OS=Order Save

    Default Value: NO

    115 PROC_TRNSPT_LT_BG Character(2) VARCHAR2(2) NOT NULL Process Transport Lead Times
    BG=Background
    NO=None

    Default Value: NO

    116 ORD_ACCEPT_LOC Character(10) VARCHAR2(10) NOT NULL Order Acceptance

    Prompt Table: %EDITTABLE3

    117 ORD_ORIGIN_LOC Character(10) VARCHAR2(10) NOT NULL Order Origin

    Prompt Table: %EDITTABLE3

    118 ORD_LINE_INCREMENT Number(3,0) SMALLINT NOT NULL Sales Order Line increment

    Default Value: 1

    119 ORD_SCHED_INCREMNT Number(3,0) SMALLINT NOT NULL Order Schedule Line Increment

    Default Value: 1

    120 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group

    Prompt Table: ORD_GROUP

    121 PENALTY_PROD_ID Character(18) VARCHAR2(18) NOT NULL Penalty Product ID

    Prompt Table: PRODITEM_INV_VW

    122 PLAN_EXP_CANCEL Character(1) VARCHAR2(1) NOT NULL Incl Planning - Export Cancel
    123 PLAN_EXP_CHECK Character(1) VARCHAR2(1) NOT NULL Incl Planning - Export Check
    124 PLAN_EXP_HOLD Character(1) VARCHAR2(1) NOT NULL Incl Planning - Export Hold
    125 PUR_EXP_CANCEL Character(1) VARCHAR2(1) NOT NULL Incl Purchasing - Export Cance
    126 PUR_EXP_CHECK Character(1) VARCHAR2(1) NOT NULL Incl Purchasing - Export Check
    127 PUR_EXP_HOLD Character(1) VARCHAR2(1) NOT NULL Incl Purchasing - Export Hold
    128 PRICE_ADJST_REASON Character(10) VARCHAR2(10) NOT NULL Price Adjustment Reason

    Prompt Table: PRICE_ADJ_CD_VW

    129 PRICE_PROCESS_OPT Character(2) VARCHAR2(2) NOT NULL Price processing option
    BG=Background
    OL=Online

    Default Value: BG

    130 PYMNT_TERMS_CD_RMA 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: AR_TRMS_VW
    Set Control Field: BUSINESS_UNIT

    131 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

    Prompt Table: REASON_SHIP_VW

    132 REASON_CD_HLD Character(10) VARCHAR2(10) NOT NULL Reason Code

    Prompt Table: CHANGE_HRSN_VW

    133 REBATE_PROD_ID Character(18) VARCHAR2(18) NOT NULL Rebate Product ID

    Prompt Table: PRODITEM_INV_VW

    134 REFUND_FEE_PCT Number(6,2) DECIMAL(5,2) NOT NULL Refund Fee Percent
    135 REFUND_FEE_PROD_ID Character(18) VARCHAR2(18) NOT NULL Deposit refund fee product ID

    Prompt Table: PRODITEM_INV_VW

    136 RETURN_TO_IBU Character(5) VARCHAR2(5) NOT NULL Return To IBU

    Prompt Table: SP_BUIN_NONVW

    137 RETURN_TYPE_CD Character(10) VARCHAR2(10) NOT NULL Return Type Code

    Prompt Table: RMA_RETURN_TYPE

    138 RESTOCK_PROD_ID Character(18) VARCHAR2(18) NOT NULL Restock Product ID

    Prompt Table: PRODITEM_INV_VW

    139 RMA_ADJ_BI_SRC Character(1) VARCHAR2(1) NOT NULL Billing source for RMAs
    I=INBU
    N=No RMAs
    O=OMBU

    Default Value: O

    140 RMA_BILL_BY_ID Character(10) VARCHAR2(10) NOT NULL RMA Bill By Identifier

    Prompt Table: BI_BILL_BY

    141 RMA_DST_ID_REV Character(10) VARCHAR2(10) NOT NULL RMA Revenue Dist Code

    Prompt Table: DSTCD_REV_OM_VW

    142 RMA_DST_RULE_CD Character(10) VARCHAR2(10) NOT NULL RMA Dist Rule Code

    Prompt Table: DST_RULE_OM

    143 RMA_LINE_INCREMENT Number(3,0) SMALLINT NOT NULL RMA Line Increment

    Default Value: 1

    144 ROLLING_DAYS Number(5,0) INTEGER NOT NULL Rolling Days

    Default Value: 0

    145 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.

    Default Value: 0

    Prompt Table: RT_TYPE_TBL

    146 SCM_CCI_GROUP Character(15) VARCHAR2(15) NOT NULL Credit Card Group

    Prompt Table: SCM_CC_GROUP_VW

    147 CC_TYPE_SELECT Character(1) VARCHAR2(1) NOT NULL Select Credit Card Type

    Y/N Table Edit

    148 SHIP_DATE_METHOD Character(1) VARCHAR2(1) NOT NULL Ship Date Calculation Method
    B=Backward
    F=Forward
    N=None

    Default Value: N

    149 SHIP_DATE_METH_BG Character(1) VARCHAR2(1) NOT NULL Ship Date Calculation Method
    B=Backward
    F=Forward
    N=None

    Default Value: N

    150 FREIGHT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Freight Product ID

    Prompt Table: PRODITEM_INV_VW

    151 MISC_CHRG_PROD_ID Character(18) VARCHAR2(18) NOT NULL Misc Charge Product ID

    Prompt Table: PRODITEM_INV_VW

    152 TAX_COMPANY Character(5) VARCHAR2(5) NOT NULL Company for Tax Suppliers
    153 TAX_DEPARTMENT Character(5) VARCHAR2(5) NOT NULL Department used by Tax Vendors
    154 TAX_DIVISION Character(5) VARCHAR2(5) NOT NULL Division for Tax Suppliers
    155 TEMPLATE_ORD Character(15) VARCHAR2(15) NOT NULL Project Template

    Prompt Table: STCUST_VW

    156 TEMPLATE_QUO Character(15) VARCHAR2(15) NOT NULL Project Template

    Prompt Table: STCUST_VW

    157 TAX_VENDOR Character(1) VARCHAR2(1) NOT NULL Tax Provider
    A=Taxware
    N=None
    V=Vertex

    Default Value: N

    158 TEMPLATE_RMA Character(15) VARCHAR2(15) NOT NULL Project Template

    Prompt Table: STCUST_VW

    159 TRNSPT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Transportion Arbitration Plan

    Prompt Table: TRFT_TRNSPT_VW

    160 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

    161 SRBT_BILL_BY_ID Character(10) VARCHAR2(10) NOT NULL The field identifies Sales Rebates and Penalty Bill By Id.

    Prompt Table: BI_BILL_BY

    162 VEND_DIRECT_COST Character(1) VARCHAR2(1) NOT NULL Supplier Direct Cost Source
    C=Cost Management
    P=Purchase Order

    Default Value: C

    163 MAX_ROW_OM_RCF Number(5,0) INTEGER NOT NULL Maximum Lines Displayed

    Default Value: 50

    164 OM_TEMPLATE_GR Character(12) VARCHAR2(12) NOT NULL Goods Receipt Default Template Id.

    Default Value: OM_GDSRCPT_M

    Prompt Table: OM_XPRPT_VW
    Set Control Field: REPORT_DEFN_ID

    165 OM_TEMPLATE_PP Character(12) VARCHAR2(12) NOT NULL Picking Plan Default Template Id.

    Default Value: OM_PCK_PLAN

    Prompt Table: OM_XPRPT_VW
    Set Control Field: REPORT_DEFN_ID