BUTBLOM_TEO1

(SQL Table)
 Index Back

CCU TEO temp table

CCU temporary table for BUS_UNIT_TBL_OM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 ACC_DST_RULE_CD Character(10) VARCHAR2(10) NOT NULL Accrued Rev Dist Rule

Prompt Table: DST_RULE_OM

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

Prompt Table: DSTCD_REV_OM_VW

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

Default Value: N

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

Prompt Table: ALT_SOURCE_VW

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

Prompt Table: JRNLGEN_APPL_ID

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Prompt Table: SP_BU_AP_NONVW

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

Prompt Table: SP_BU_BI_NONVW

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

Prompt Table: SP_BUIN_NONVW

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

Y/N Table Edit

Default Value: N

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

Prompt Table: %EDITTABLE

15 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
16 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source

Prompt Table: %EDITTABLE2

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

Default Value: A

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

Prompt Table: LOCATION_TBL

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

Prompt Table: %EDITTABLE4

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

Prompt Table: DSTCD_REV_OM_VW

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

Prompt Table: DST_RULE_OM

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

Default Value: 1

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

Default Value: O

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N

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

Prompt Table: CURRENCY_CD_TBL

33 CUST_PURCH_RANGE Number(3,0) SMALLINT NOT NULL Purchase History (Months)
34 CUST_SHIP_RANGE Number(3,0) SMALLINT NOT NULL Ship History for RMAs (Months)
35 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

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

Prompt Table: DS_NETHDR_TBL

38 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

39 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

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

Prompt Table: DST_CODE_CDP_VW

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

Prompt Table: DSTCD_DIS_OM_VW

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

Prompt Table: DSTCD_REV_OM_VW

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

Prompt Table: DSTCD_SUR_OM_VW

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

Prompt Table: DST_CODE_CV_VW

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

Prompt Table: DST_RULE_OM

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

Default Value: N

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Prompt Table: HOLD_CD

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

Default Value: NO

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

Default Value: 10

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

Default Value: 1

83 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

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Default Value: 100

90 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

91 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

92 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

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

Default Value: G

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

Default Value: 2

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

Default Value: NO

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

Default Value: 1

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

Default Value: 1

99 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

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

Default Value: 0

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

Default Value: 0

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

Default Value: 0

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

Default Value: 0

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

Default Value: 0

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

Default Value: 0

106 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

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

Default Value: NO

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

Default Value: NO

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

Default Value: NO

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

Default Value: NO

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

Default Value: NO

112 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

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

Default Value: NO

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

Y/N Table Edit

Default Value: Y

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

Default Value: NO

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

Default Value: NO

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

Prompt Table: %EDITTABLE3

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

Prompt Table: %EDITTABLE3

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

Default Value: 1

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

Default Value: 1

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

Prompt Table: ORD_GROUP

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

Prompt Table: PRODITEM_INV_VW

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

Prompt Table: PRICE_ADJ_CD_VW

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

Default Value: BG

131 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

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

Prompt Table: REASON_SHIP_VW

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

Prompt Table: CHANGE_HRSN_VW

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

Prompt Table: PRODITEM_INV_VW

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

Prompt Table: PRODITEM_INV_VW

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

Prompt Table: SP_BUIN_NONVW

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

Prompt Table: RMA_RETURN_TYPE

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

Prompt Table: PRODITEM_INV_VW

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

Default Value: O

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

Prompt Table: BI_BILL_BY

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

Prompt Table: DSTCD_REV_OM_VW

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

Prompt Table: DST_RULE_OM

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

Default Value: 1

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

Default Value: 0

146 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

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

Prompt Table: SCM_CC_GROUP_VW

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

Y/N Table Edit

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

Default Value: N

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

Default Value: N

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

Prompt Table: PRODITEM_INV_VW

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

Prompt Table: PRODITEM_INV_VW

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

Prompt Table: STCUST_VW

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

Prompt Table: STCUST_VW

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

Default Value: N

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

Prompt Table: STCUST_VW

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

Prompt Table: TRFT_TRNSPT_VW

161 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

162 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

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

Default Value: C

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

Default Value: 50

165 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

166 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

167 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code