ORD_SCH_LOTK_VW (SQL View)	Index Back
Order Schedule Line Kit View Date Initials Issue # Description 041207 rcw ?????? New for lot allocation of Kit lines

ORD_SCH_LOTK_VW

(SQL View)

Order Schedule Line Kit View

Date Initials Issue # Description 041207 rcw ?????? New for lot allocation of Kit lines

SELECT DISTINCT S.BUSINESS_UNIT , S.ORDER_NO , S.ORDER_INT_LINE_NO , S.SCHED_LINE_NBR , D.PRODUCT_ID , S.SHIP_TO_CUST_ID , S.ACTIVITY_ID , S.ADDR_OVRD_LEVEL , S.ADDRESS_SEQ_NUM , S.AERP , S.ALLOW_OVERPICK_FLG , S.ANALYSIS_TYPE , S.ATP_DATE , S.BCKORDR_CNCL_FLAG , S.BUSINESS_UNIT_PC , S.CANCEL_DATE , S.CARRIER_ID , S.CARRIER_ID_EXP , S.CB_CONTRACT_ID , S.CCI_REQ_EXP , S.CNTCT_SEQ_SHIP , S.COMM_PCT , S.COMMSN_METHOD , S.COO_REQ_EXP , S.COUNTRY_LOC_BUYER , S.COUNTRY_LOC_SELLER , S.COUNTRY_SHIP_FROM , S.COUNTRY_SHIP_TO , S.COUNTRY_VAT_BILLFR , S.COUNTRY_VAT_BILLTO , S.COUNTRY_VAT_PERFRM , S.COUNTRY_VAT_SUPPLY , S.CS_STATUS , S.CURRENCY_CD , S.CURRENCY_CD_BASE , S.CUST_BILL_BACK_ALL , S.CUST_BBACK_ALL_BSE , S.CUST_DEPOSIT_ID , S.CUST_NET_PRICE , S.CUST_NET_PRC_BASE , S.CUST_OFF_INV_DISC , S.CUST_OFF_INV_BASE , S.CUST_PO_PRICE , S.CUST_PO_PRC_BASE , S.CUST_PICKUP , S.CUSTOMER_PO , S.CUSTOMER_PO_LINE , S.CUSTOMER_PO_SCHED , S.DELIVERY_ID , S.DEMAND_SENT , S.DEPOSIT_BU , S.DS_NETWORK_CODE , S.DISTRIB_TYPE , S.DOC_REFNUM , S.DROP_SHIP_FLAG , S.EIP_CTL_ID_SHIP , S.EOEP_PRCBASE_FLG , S.ERROR_DESCR , S.EXPORT , S.EXPORT_LIC_REQ , S.EXPORT_LIC_TYPE , S.EXPORT_LIC_APPL , S.EXPORT_APPL_DT , S.EXPORT_LIC_REC , S.EXPORT_REC_DT , S.EXPORT_LIC_NBR , S.EXPORT_LIC_EXPIRE , S.EXPORT_LIC_VALUE , S.EXPORT_LIC_QTY , S.EXS_TAX_TXN_TYPE , S.FREIGHT_TERMS , S.FREIGHT_TERMS_EXP , S.FROZEN_FLG , S.FRT_CHRG_METHOD , S.FRT_RULE_CD , S.GROUP_CODE , S.IMPORT_LIC_REQ , S.IMPORT_LIC_APPL , S.IMPORT_APPL_DT , S.IMPORT_LIC_REC , S.IMPORT_REC_DT , S.IMPORT_CERT_NBR , S.IMPORT_LIC_EXP , S.IN_LINE_BO_RULE , S.IN_LINE_RESV_RULE , S.IN_LN_RESV_BO_RULE , S.IN_ORDER_RESV_RULE , S.IN_FULFILL_STATE , S.INVALID_ARRV_DT , S.INVOICE , S.INVOICE_DT , S.IST_TXN_FLG , S.LIST_PRICE , S.LIST_PRICE_BASE , S.LOAD_ID , S.LOT_ALLOC_FLG , S.MAX_PICK_TOLERANCE , S.NAFTA_REQ_EXP , S.NET_UNIT_PRICE , S.NET_UNIT_PRICE_BSE , S.OMEC_NEW_SCHED , S.ORD_ACCEPT_LOC , S.ORD_ADJST_SCH_AMT , S.ORD_ADJST_SCH_BASE , S.ORD_ORIGIN_LOC , S.ORD_SCH_STATUS , S.PAYMENT_INDICATOR , S.PC_DISTRIB_STATUS , S.PICK_BATCH_ID , S.PO_DISTRIB_STATUS , S.PO_HOLD_FLAG , S.PREF_CARRIER_FLAG , S.PRICE_LIST_ID , S.PRICE_OVERRIDE , S.PRICE_OVERRIDE_BSE , S.PRICE_PROGRAM , S.PRICESET_PRICE , S.PRICESET_PRICE_BSE , S.PRICE_PROTECTED , S.PRICING_QTY , S.PRC_LIST_PRICE , S.PRC_LIST_PRICE_BSE , S.PRC_NET_UNIT_BSE , S.PRC_NET_UNIT_PRICE , S.PRIORITY_SHIP_FROM , S.PROJECT_ID , S.PT_SALE_FLG , S.PYMNT_TERMS_CD , S.QTY_PICKUP , CASE WHEN D.QTY_CODE = 'ORD' THEN D.QTY_PER ELSE %Round(%DecMult(S.QTY_SCHEDULED, D.QTY_PER) ,4) END , CASE WHEN D.QTY_CODE = 'ORD' THEN D.QTY_PER ELSE %Round(%DecMult(S.QTY_SCHED_ORIG, D.QTY_PER) ,4) END , S.REASON_CD , S.RECEIPT_NBR , S.REPLACEMENT_FLG , S.REQ_ARRIVAL_DTTM , S.REQ_ARRIVAL_ORIG , S.REQ_SHIP_DTTM , S.REQ_SHIP_ORIG , S.RESOURCE_CATEGORY , S.RESOURCE_SUB_CAT , S.RESOURCE_TYPE , S.ROUTE_CD , S.ROUTE_STOP_NBR , S.SCHED_ARRV_DTTM , S.SCHED_ARRV_ORIG , S.SCHED_SHIP_DTTM , S.SCHED_SHIP_ORIG , S.SED_REQ_EXP , S.SHIP_FROM_BU , S.SHIP_FROM_LOC , S.SHIP_ID_EST , S.SHIP_OVRD_QTY , S.SHIP_PARTIAL_FLAG , S.SHIP_PRIOR_FLAG , S.SHIP_PRIORITY_ID , S.SHIP_PRIORITY_EXP , S.SHIP_TYPE_ID , S.SHIP_TYPE_ID_EXP , S.SHIPPING_QTY , S.SHIPPING_VOLUME , S.SHIPPING_WEIGHT , S.SKIP_ATP , S.SKIP_LOT_ALLOC , S.SPECIAL_HANDLING , S.SRV_PERFORM_LOC , S.SSRC_BUS_UNIT , S.SSRC_KEY2 , S.SSRC_LINE_NBR , S.STATE_LOC_BUYER , S.STATE_LOC_SELLER , S.STATE_SHIP_FROM , S.STATE_SHIP_TO , S.STATE_VAT_DEFAULT , S.STATE_VAT_PERFRM , S.STD_DISCOUNT , S.STORE_LOC , S.STORE_NUMBER , S.SUPPLY_DOC_CREATED , S.SUPPORT_TEAM_CD , S.GEO_CODE , S.TAX_AMT , S.TAX_AMT_BSE , S.TAX_CD , S.TAX_CUST_GROUP , S.TAX_CUST_ID , S.TAX_DATE , S.TAX_DEPARTMENT , S.TAX_DIVISION , S.TAX_EXEMPT_CERT , S.TAX_EXEMPT_FLG , S.TAX_EXEMPT_RC , S.TAX_GROUP , S.TAX_JOB_NUM , S.TAX_JUR_IND , S.TAX_TRANS_TYPE , S.TAX_TRANS_SUB_TYPE , S.TAX_USER_AREA , S.TAX_PCT , S.TITLE_PASSAGE , S.TRFT_DISPOSITION , S.TRFT_SRC_TYPE , S.TRNSPT_LEAD_DAYS , S.TRNSPT_LEAD_HOURS , S.TRNSPT_LEAD_MIN , S.UNIT_COST_ALT , S.UNIT_MEASURE_SHIP , S.UNIT_MEASURE_VOL , S.UNIT_MEASURE_WT , S.VAT_AMT , S.VAT_AMT_BASE , S.VAT_AMT_RVC , S.VAT_AMT_RVC_BSE , S.VAT_APPLICABILITY , S.VAT_BASIS_AMT , S.VAT_BASIS_AMT_BSE , S.VAT_CALC_GROSS_NET , S.VAT_DCLRTN_POINT , S.VAT_DFLT_DONE_FLG , S.VAT_DST_ACCT_TYPE , S.VAT_ENTITY , S.VAT_EXCPTN_CERTIF , S.VAT_EXCPTN_TYPE , S.VAT_RECALC_FLG , S.VAT_RGSTRN_BUYER , S.VAT_ROUND_RULE , S.VAT_RVRSE_CHG_GDS , S.VAT_TRANS_AMT , S.VAT_TRANS_AMT_BSE , S.VAT_TREATMENT , S.VAT_TREATMENT_GRP , S.VAT_TXN_TYPE_CD , S.VAT_SERVICE_TYPE , S.VAT_SVC_SUPPLY_FLG , S.TAX_CD_VAT , S.TAX_CD_VAT_PCT , S.TAX_CD_VAT_RVC , S.TAX_CD_VAT_RVC_PCT , %subrec(ORD_CUSTOM_SBR, S) , S.DATETIME_ADDED , S.LASTUPDDTTM , S.LAST_MAINT_OPRID , S.SHIPPING_KIT_QTY , S.PROCESS_INSTANCE , 0 , D.PARENT_PROD_ID , D.INV_ITEM_ID , D.CONFIG_CODE , D.QTY_PER , D.QTY_CODE , D.KIT_LINE_NBR , P.PRODUCT_KIT_FLAG , P.CFG_KIT_FLAG , D.UNIT_OF_MEASURE FROM PS_ORD_SCHEDULE S , PS_ORD_LINE L , PS_SET_CNTRL_REC C , PS_MASTER_ITEM_TBL M , PS_PROD_ITEM P , PS_IN_DEMAND D WHERE S.ORD_SCH_STATUS = 'O' AND S.DEMAND_SENT = 'Y' AND S.SHIP_FROM_BU > ' ' AND D.IN_FULFILL_STATE BETWEEN '20' AND '70' AND L.BUSINESS_UNIT = S.BUSINESS_UNIT AND L.ORDER_NO = S.ORDER_NO AND L.ORDER_INT_LINE_NO = S.ORDER_INT_LINE_NO AND C.SETCNTRLVALUE = L.BUSINESS_UNIT AND C.RECNAME = 'MASTER_ITEM_TBL' AND M.SETID = C.SETID AND M.INV_ITEM_ID = D.INV_ITEM_ID AND M.LOT_CONTROL = 'Y' AND P.SETID = C.SETID AND P.PRODUCT_ID = L.PRODUCT_ID AND P.PRODUCT_KIT_FLAG = 'Y' AND S.BUSINESS_UNIT = D.SOURCE_BUS_UNIT AND %Join(COMMON_KEYS, ORD_SCHEDULE S, IN_DEMAND D, BUSINESS_UNIT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_OM

2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
Default Value: 1

4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

6 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
Prompt Table: CUST_SLDSHP_VW

7 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

8 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule

9 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
Prompt Table: CUST_ADDRSHP_VW

10 AERP Character(50) VARCHAR2(50) NOT NULL Automated Exporter Rptg Prgm

11 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
Y/N Table Edit
Default Value: N

12 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

13 ATP_DATE Date(10) DATE ATP Promise Date

14 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes

15 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

16 CANCEL_DATE Date(10) DATE Cancel Date

17 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
Prompt Table: CARRIER_ID

18 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
Prompt Table: CARRIER_ID

19 CB_CONTRACT_ID Character(25) VARCHAR2(25) NOT NULL Claimback Contract ID

20 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
N=No
Y=Yes

21 CNTCT_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Contact - Ship To
Prompt Table: OME_CNCT_SH_VW

22 COMM_PCT Number(6,2) DECIMAL(5,2) NOT NULL Commission %

23 COMMSN_METHOD Character(1) VARCHAR2(1) NOT NULL Commission Method
C=Commission Percent
P=Pro-Rata Percent

24 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
N=No
Y=Yes

25 COUNTRY_LOC_BUYER Character(3) VARCHAR2(3) NOT NULL Buyer's Location Country - May be either the VAT Entity or the Trading Partner

26 COUNTRY_LOC_SELLER Character(3) VARCHAR2(3) NOT NULL Seller's Location Country - May be either the VAT Entity or the Trading Partner

27 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).

28 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).

29 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).

30 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).

31 COUNTRY_VAT_PERFRM Character(3) VARCHAR2(3) NOT NULL Country Where Service Physically Performed

32 COUNTRY_VAT_SUPPLY Character(3) VARCHAR2(3) NOT NULL VAT Place of Supply Country

33 CS_STATUS Character(2) VARCHAR2(2) NOT NULL Counter sale status
PS=Pending Shipment
S=Shipped to Inventory

34 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

35 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

36 CUST_BILL_BACK_ALL Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer's bill-back allowance

37 CUST_BBACK_ALL_BSE Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer Bill Back Allow Base

38 CUST_DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Customer Deposit ID

39 CUST_NET_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Customer Net Price

40 CUST_NET_PRC_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Customer Net Price Base

41 CUST_OFF_INV_DISC Signed Number(18,5) DECIMAL(16,5) NOT NULL Customer Off-Inv Discount

42 CUST_OFF_INV_BASE Signed Number(18,5) DECIMAL(16,5) NOT NULL Cust Off Invoice Disc Base

43 CUST_PO_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL Customer PO Price

44 CUST_PO_PRC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Customer PO Price Base

45 CUST_PICKUP Character(1) VARCHAR2(1) NOT NULL Counter sale customer pickup flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N

46 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO

47 CUSTOMER_PO_LINE Character(11) VARCHAR2(11) NOT NULL Customer PO Line

48 CUSTOMER_PO_SCHED Character(11) VARCHAR2(11) NOT NULL Customer PO Schedule

49 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID

50 DEMAND_SENT Character(1) VARCHAR2(1) NOT NULL Demand Sent to INV
Default Value: N

51 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

52 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code

53 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

54 DOC_REFNUM Character(20) VARCHAR2(20) NOT NULL Counter sale document reference number

55 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
N=No
Y=Yes
Y/N Table Edit
Default Value: N

56 EIP_CTL_ID_SHIP Character(25) VARCHAR2(25) NOT NULL EIP Control ID

57 EOEP_PRCBASE_FLG Character(1) VARCHAR2(1) NOT NULL Pricing Base Flag
1=List Price
2=Cost
3=Buying Agreement
4=Alternate Cost

58 ERROR_DESCR Character(20) VARCHAR2(20) NOT NULL Error Description

59 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes
Y/N Table Edit
Default Value: N

60 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
NO=No
YES=Yes

61 EXPORT_LIC_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
GDST=General
SPEC=Specific

62 EXPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes

63 EXPORT_APPL_DT Date(10) DATE Application Date

64 EXPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes

65 EXPORT_REC_DT Date(10) DATE Date Received

66 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr

67 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date

68 EXPORT_LIC_VALUE Number(10,2) DECIMAL(9,2) NOT NULL License Value

69 EXPORT_LIC_QTY Number(6,0) INTEGER NOT NULL License Quantity

70 EXS_TAX_TXN_TYPE Character(4) VARCHAR2(4) NOT NULL Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond
DEWB=Direct Export Without Bond
DIMP=Direct Import
DOM=Domestic
LEB=Local Export With Bond
LEWB=Local Export Without Bond
LIMP=Local Import

71 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
Prompt Table: FREIGHT_TERMS

72 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
Prompt Table: FREIGHT_TERMS

73 FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL Frozen Flag
B=Both
N=No
Y=Yes

74 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity

75 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code

76 GROUP_CODE Number(5,0) INTEGER NOT NULL Group With Line

77 IMPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Import License Required
NO=No
YES=Yes

78 IMPORT_LIC_APPL Character(3) VARCHAR2(3) NOT NULL Applied For
NO=No
YES=Yes

79 IMPORT_APPL_DT Date(10) DATE Application Date

80 IMPORT_LIC_REC Character(3) VARCHAR2(3) NOT NULL License Received
NO=No
YES=Yes

81 IMPORT_REC_DT Date(10) DATE Date Received

82 IMPORT_CERT_NBR Character(18) VARCHAR2(18) NOT NULL Import License Nbr

83 IMPORT_LIC_EXP Date(10) DATE Expiration Date

84 IN_LINE_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Backorder Rule

85 IN_LINE_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation Rule

86 IN_LN_RESV_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation - Backorder

87 IN_ORDER_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Order Reservation Rule

88 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled

89 INVALID_ARRV_DT Character(1) VARCHAR2(1) NOT NULL Invalid arrival date indicator
Default Value: N

90 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

91 INVOICE_DT Date(10) DATE Invoice Date

92 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes

93 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price

94 LIST_PRICE_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price (base)

95 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

96 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation
Default Value: N

97 MAX_PICK_TOLERANCE Number(6,2) DECIMAL(5,2) NOT NULL Used to indicate the allowable percentage of overshipment for a customer or business unit.

98 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
N=No
Y=Yes

99 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price

100 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)

101 OMEC_NEW_SCHED Character(1) VARCHAR2(1) NOT NULL New field on the ORD_SCHEDULE record to indicate that a new schedule has been added to an order via either the sales order load ord sales order change load messages.
Default Value: N

102 ORD_ACCEPT_LOC Character(10) VARCHAR2(10) NOT NULL Order Acceptance
Prompt Table: LOCATION_TBL

103 ORD_ADJST_SCH_AMT Signed Number(19,4) DECIMAL(17,4) NOT NULL Adjustment Amount

104 ORD_ADJST_SCH_BASE Signed Number(19,4) DECIMAL(17,4) NOT NULL Adjustment Amount

105 ORD_ORIGIN_LOC Character(10) VARCHAR2(10) NOT NULL Order Origin
Prompt Table: LOCATION_TBL

106 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled
Default Value: O

107 PAYMENT_INDICATOR Character(2) VARCHAR2(2) NOT NULL Counter sale payment indicator
00=Invoice in Billing
01=Ready to Invoice
02=Not Ready to Invoice
03=Invoice in OM
04=Partial Payment
99=Canceled

108 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged
Default Value: N

109 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID

110 PO_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PO Distribution Status
0=Non-PO
1=Active
2=In-process
3=Error
4=Processed
5=Modified

111 PO_HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL PO Hold Flag
Default Value: N

112 PREF_CARRIER_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred Carrier flag
N=No Preferred Carrier
Y=Preferred Carrier

113 PRICE_LIST_ID Character(10) VARCHAR2(10) NOT NULL Price List ID

114 PRICE_OVERRIDE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Override

115 PRICE_OVERRIDE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Override (base)

116 PRICE_PROGRAM Character(10) VARCHAR2(10) NOT NULL Date Initials Issue Description 111701 dms F-CJORGENS-11 Add EXCL_PRICE_LBL

117 PRICESET_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Price Rule Price

118 PRICESET_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Priceset Rule (base)

119 PRICE_PROTECTED Character(1) VARCHAR2(1) NOT NULL Price Protected
Y/N Table Edit
Default Value: N

120 PRICING_QTY Number(16,4) DECIMAL(15,4) NOT NULL Pricing quantity.

121 PRC_LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price

122 PRC_LIST_PRICE_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price

123 PRC_NET_UNIT_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)

124 PRC_NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price

125 PRIORITY_SHIP_FROM Character(5) VARCHAR2(5) NOT NULL PRIORITY SHIP FROM BUSINESS UNIT

126 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

127 PT_SALE_FLG Character(1) VARCHAR2(1) NOT NULL Point of Sale Flag

128 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: AR_TRMS_VW

129 QTY_PICKUP Number(16,4) DECIMAL(15,4) NOT NULL Counter sale pickup quantity

130 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled

131 QTY_SCHED_ORIG Signed Number(16,4) DECIMAL(14,4) NOT NULL Original Qty Scheduled

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

133 RECEIPT_NBR Character(15) VARCHAR2(15) NOT NULL Receipt Number

134 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods
Default Value: NA

135 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival
Default Value: %datetime

136 REQ_ARRIVAL_ORIG DateTime(26) TIMESTAMP Original Req Arrival

137 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship
Default Value: %datetime

138 REQ_SHIP_ORIG DateTime(26) TIMESTAMP Original Req Ship

139 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

140 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

141 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

142 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.

143 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.

144 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm
Default Value: %datetime

145 SCHED_ARRV_ORIG DateTime(26) TIMESTAMP Original Sch Arrival

146 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
Default Value: %datetime

147 SCHED_SHIP_ORIG DateTime(26) TIMESTAMP Original Sch Ship

148 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
N=No
Y=Yes

149 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
Prompt Table: SP_BUIN_NONVW

150 SHIP_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Ship From Location
Prompt Table: LOCATION_TBL

151 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID

152 SHIP_OVRD_QTY Number(16,4) DECIMAL(15,4) NOT NULL Counter sale ship override quantity

153 SHIP_PARTIAL_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Schedules
N=Ship Partial No
Y=Ship Partial Yes

154 SHIP_PRIOR_FLAG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Request Date
N=Ship Prior No
Y=Ship Prior Yes

155 SHIP_PRIORITY_ID Character(6) VARCHAR2(6) NOT NULL Shipping Priority Code
Prompt Table: SHIP_PRIORITY

156 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority
Prompt Table: SHIP_PRIORITY

157 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
Prompt Table: SHIP_METHOD

158 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
Prompt Table: SHIP_METHOD

159 SHIPPING_QTY Number(17,4) DECIMAL(16,4) NOT NULL Shipping Quantity

160 SHIPPING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Volume

161 SHIPPING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight

162 SKIP_ATP Character(1) VARCHAR2(1) NOT NULL Flag that indicates that ATP calculation will be skipped during the online reservation process.
Y/N Table Edit
Default Value: N

163 SKIP_LOT_ALLOC Character(1) VARCHAR2(1) NOT NULL Flag that indicates that lot allocation will be skipped during the online reservation process.
Y/N Table Edit
Default Value: N

164 SPECIAL_HANDLING Character(1) VARCHAR2(1) NOT NULL Special Handling
N=No
Y=Yes
Default Value: N

165 SRV_PERFORM_LOC Character(10) VARCHAR2(10) NOT NULL Service Performance Location
Prompt Table: LOCATION_TBL

166 SSRC_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Supply Source business unit

167 SSRC_KEY2 Character(30) VARCHAR2(30) NOT NULL Supply Source key

168 SSRC_LINE_NBR Number(5,0) INTEGER NOT NULL Supply Source line number

169 STATE_LOC_BUYER Character(6) VARCHAR2(6) NOT NULL Buyer's Location State - May be either the VAT Entity or the Trading Partner

170 STATE_LOC_SELLER Character(6) VARCHAR2(6) NOT NULL Seller's Location State - May be either the VAT Entity or the Trading Partner

171 STATE_SHIP_FROM Character(6) VARCHAR2(6) NOT NULL Ship From State

172 STATE_SHIP_TO Character(6) VARCHAR2(6) NOT NULL Ship To State

173 STATE_VAT_DEFAULT Character(6) VARCHAR2(6) NOT NULL VAT Defaulting State

174 STATE_VAT_PERFRM Character(6) VARCHAR2(6) NOT NULL State Where Service Physically Performed

175 STD_DISCOUNT Signed Number(7,2) DECIMAL(5,2) NOT NULL Standard Discount

176 STORE_LOC Character(10) VARCHAR2(10) NOT NULL Store Location

177 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number

178 SUPPLY_DOC_CREATED Character(1) VARCHAR2(1) NOT NULL Flag to indicate that a supply document (po or req) has been created.
Y/N Table Edit
Default Value: N

179 SUPPORT_TEAM_CD Character(6) VARCHAR2(6) NOT NULL Support Team Code

180 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

181 TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount

182 TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount (base)

183 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
Prompt Table: TAX_HDR_TBL_VW

184 TAX_CUST_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Customer Group

185 TAX_CUST_ID Character(15) VARCHAR2(15) NOT NULL Tax Customer ID

186 TAX_DATE Date(10) DATE Tax Date

187 TAX_DEPARTMENT Character(5) VARCHAR2(5) NOT NULL Department used by Tax Vendors

188 TAX_DIVISION Character(5) VARCHAR2(5) NOT NULL Division for Tax Suppliers

189 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate

190 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
Y/N Table Edit
Default Value: N

191 TAX_EXEMPT_RC Character(2) VARCHAR2(2) NOT NULL Exempt Reason Code
01=Certificat

192 TAX_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Group

193 TAX_JOB_NUM Character(10) VARCHAR2(10) NOT NULL Job Number

194 TAX_JUR_IND Character(1) VARCHAR2(1) NOT NULL Tax jurisdiction indicator
1=Ship-To Location
2=Ship-From Location
3=Order Acceptance Location
4=Order Origin Location

195 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return

196 TAX_TRANS_SUB_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Sub Type
1=Property
2=Freight
3=Service
4=Rental or Lease
5=Expense
6=Misc
N=None

197 TAX_USER_AREA Character(25) VARCHAR2(25) NOT NULL Used for tax calculation by tax vendor.

198 TAX_PCT Number(7,4) DECIMAL(6,4) NOT NULL Tax Percent

199 TITLE_PASSAGE Character(1) VARCHAR2(1) NOT NULL Title Passage
B=Buyer's Destination-Ship To
I=Intermediate Consignee
S=Seller's Origination-Ship From

200 TRFT_DISPOSITION Character(1) VARCHAR2(1) NOT NULL Supply Source disposition
1=Direct Ship
2=Direct Receipt
Default Value: 1

201 TRFT_SRC_TYPE Character(1) VARCHAR2(1) NOT NULL Alternate Source Type
0=All Sources
1=Inventory Business Unit
2=Distribution Network
3=New Requisition
4=New Purchase Order
5=Existing Requisition
6=Existing Purchase Order
7=Existing Interunit Transfer
8=Existing Production Order
9=New Production Order

202 TRNSPT_LEAD_DAYS Number(3,0) SMALLINT NOT NULL Transportation Lead Tm (days)

203 TRNSPT_LEAD_HOURS Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Hours)

204 TRNSPT_LEAD_MIN Number(2,0) SMALLINT NOT NULL Transportation Lead Tm (Min)

205 UNIT_COST_ALT Signed Number(16,4) DECIMAL(14,4) NOT NULL Date Init. Issue # Description 092804 JJM F-CJORG-L1CX3 Sprinklebacks

206 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure

207 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM

208 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM

209 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.

210 VAT_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. It is expressed in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition for VAT_AMT.

211 VAT_AMT_RVC Signed Number(28,3) DECIMAL(26,3) NOT NULL Reverse Charge VAT Amount

212 VAT_AMT_RVC_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Reverse Charge Amount in Base Currency

213 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated

214 VAT_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.

215 VAT_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Basis Amt in Base Curr

216 VAT_CALC_GROSS_NET Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net

217 VAT_DCLRTN_POINT Character(1) VARCHAR2(1) NOT NULL A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time

218 VAT_DFLT_DONE_FLG Character(1) VARCHAR2(1) NOT NULL VAT Defaulting Done
N=Awaiting Defaulting
X=Do not default
Y=Defaulting Done
Default Value: N

219 VAT_DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.

220 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.

221 VAT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.

222 VAT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated

223 VAT_RECALC_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.

224 VAT_RGSTRN_BUYER Character(20) VARCHAR2(20) NOT NULL Specifies a customers VAT Registration ID for a particular country.

225 VAT_ROUND_RULE Character(1) VARCHAR2(1) NOT NULL " Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up

226 VAT_RVRSE_CHG_GDS Character(1) VARCHAR2(1) NOT NULL VAT Reverse Charge goods flag

227 VAT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.

228 VAT_TRANS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount in base currency against which the VAT is applicable

229 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment

230 VAT_TREATMENT_GRP Character(4) VARCHAR2(4) NOT NULL VAT Treatment Group

231 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.

232 VAT_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication

233 VAT_SVC_SUPPLY_FLG Character(1) VARCHAR2(1) NOT NULL VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed

234 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.

235 TAX_CD_VAT_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.

236 TAX_CD_VAT_RVC Character(8) VARCHAR2(8) NOT NULL Reverse Charge VAT Code

237 TAX_CD_VAT_RVC_PCT Signed Number(9,4) DECIMAL(7,4) NOT NULL Customer VAT Rate

238 CUSTOM_C10_A Character(10) VARCHAR2(10) NOT NULL Custom Char 10A

239 CUSTOM_C10_B Character(10) VARCHAR2(10) NOT NULL Custom Char 10B

240 CUSTOM_C20_A Character(20) VARCHAR2(20) NOT NULL Custom Char 20A

241 CUSTOM_C20_B Character(20) VARCHAR2(20) NOT NULL Custom Char 20B

242 CUSTOM_C30_A Character(30) VARCHAR2(30) NOT NULL Custom Char 30A

243 CUSTOM_C30_B Character(30) VARCHAR2(30) NOT NULL Custom Char 30B

244 CUSTOM_C40_A Character(40) VARCHAR2(40) NOT NULL Custom Char 40A

245 CUSTOM_C40_B Character(40) VARCHAR2(40) NOT NULL Custom Char 40B

246 CUSTOM_C80_A Character(80) VARCHAR2(80) NOT NULL Custom Char 80A

247 CUSTOM_C80_B Character(80) VARCHAR2(80) NOT NULL Custom Char 80B

248 CUSTOM_DTTM_A DateTime(26) TIMESTAMP Custom DateTime A

249 CUSTOM_DTTM_B DateTime(26) TIMESTAMP Custom DateTime B

250 CUSTOM_DTTM_C DateTime(26) TIMESTAMP Custom DateTime C

251 CUSTOM_DTTM_D DateTime(26) TIMESTAMP Custom DateTime D

252 CUSTOM_DTTM_E DateTime(26) TIMESTAMP Custom DateTime E

253 CUSTOM_DTTM_F DateTime(26) TIMESTAMP Custom DateTime F

254 CUSTOM_DTTM_G DateTime(26) TIMESTAMP Custom DateTime G

255 CUSTOM_DTTM_H DateTime(26) TIMESTAMP Custom DateTime H

256 CUSTOM_DTTM_I DateTime(26) TIMESTAMP Custom DateTime I

257 CUSTOM_DTTM_J DateTime(26) TIMESTAMP Custom DateTime J

258 CUSTOM_DTTM_K DateTime(26) TIMESTAMP Custom DateTime K

259 CUSTOM_DTTM_L DateTime(26) TIMESTAMP Custom DateTime L

260 CUSTOM_DTTM_M DateTime(26) TIMESTAMP Custom DateTime M

261 CUSTOM_DTTM_N DateTime(26) TIMESTAMP Custom DateTime N

262 CUSTOM_DTTM_O DateTime(26) TIMESTAMP Custom DateTime O

263 CUSTOM_DTTM_P DateTime(26) TIMESTAMP Custom DateTime P

264 CUSTOM_DTTM_Q DateTime(26) TIMESTAMP Custom DateTime Q

265 CUSTOM_DTTM_R DateTime(26) TIMESTAMP Custom DateTime R

266 CUSTOM_DTTM_S DateTime(26) TIMESTAMP Custom DateTime S

267 CUSTOM_DTTM_T DateTime(26) TIMESTAMP Custom DateTime T

268 CUSTOM_N12_A Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 A

269 CUSTOM_N12_B Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 B

270 CUSTOM_N12_C Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 C

271 CUSTOM_N12_D Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 D

272 CUSTOM_N12_E Number(12,0) DECIMAL(12) NOT NULL Custom Number 12 E

273 CUSTOM_N15_A Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 A

274 CUSTOM_N15_B Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 B

275 CUSTOM_N15_C Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 C

276 CUSTOM_N15_D Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 D

277 CUSTOM_N15_E Number(15,0) DECIMAL(15) NOT NULL Custom Number 15 E

278 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

279 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

280 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

281 SHIPPING_KIT_QTY Number(17,4) DECIMAL(16,4) NOT NULL Shipping Quantity

282 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

283 QTY_RELEASED Signed Number(17,4) DECIMAL(15,4) NOT NULL Planned Released Qty

284 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id

285 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

286 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

287 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity

288 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order

289 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number

290 PRODUCT_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Product Kit

291 CFG_KIT_FLAG Character(1) VARCHAR2(1) NOT NULL Configured Kit

292 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage