IN_DELIVERY_VW

(SQL View)
 Index Back

IN view of IN_DELIVERY


SELECT DISTINCT D.BUSINESS_UNIT , D.DELIVERY_ID , O.BUSINESS_UNIT , O.DEMAND_SOURCE , O.SOURCE_BUS_UNIT , O.ORDER_NO , %subrec(OM_DELIVERY_SBR, D) , %subrec(IN_DEL_FRT_SBR, F) , %subrec(IN_DTTIME_SBR, D) , S.SETID , O.FREIGHT_NET_PRC , O.CURRENCY_CD_DEF , O.FREIGHT_PRC_BASE , O.FRT_CURR_CD_BASE , 0 , O.FREIGHT_QUANTITY , O.FREIGHT_VOLUME , O.FREIGHT_WEIGHT , 0 , 0 , ' ' , ' ' , D.UNIT_MEASURE_VOL , D.UNIT_MEASURE_WT , D.UNIT_MEASURE_VOL , D.UNIT_MEASURE_WT , 1 , '60' , '70' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , ' ' , O.FREIGHT_BILLD_FLAG , 'N' , 'X' , 'N' , 'N' , 'N' , 'N' , ' ' , ' ' , 0 , 0 , 0 , 0 FROM PS_IN_DELIVERY D , PS_IN_DELIVERY_ORD O , PS_IN_DELIVERY_FRT F , PS_SET_CNTRL_REC S WHERE %Join(COMMON_KEYS, IN_DELIVERY D, IN_DELIVERY_FRT F) AND %Join(COMMON_KEYS, IN_DELIVERY_FRT F, IN_DELIVERY_ORD O) AND F.FREIGHT_APP = 'IN' AND O.SHIP_ID = ' ' AND (D.DELIVERY_STATUS = '70' OR D.DEPLETED_FLAG = 'Y') AND S.SETCNTRLVALUE = D.BUSINESS_UNIT AND S.RECNAME = 'MASTER_ITEM_TBL' UNION SELECT DISTINCT D.BUSINESS_UNIT , D.DELIVERY_ID , O.BUSINESS_UNIT , O.DEMAND_SOURCE , O.SOURCE_BUS_UNIT , O.ORDER_NO , %subrec(IN_DELIVERY_SBR, D) , %subrec(IN_DEL_FRT_SBR, F) , %subrec(IN_DTTIME_SBR, D) , P.SETID_INV_ITEM , 0 , ' ' , 0 , ' ' , 0 , 0 , P.SHIPPING_VOLUME , P.SHIPPING_WEIGHT , 0 , 0 , ' ' , ' ' , ' ' , ' ' , P.UNIT_MEASURE_VOL , P.UNIT_MEASURE_WT , 0 , '99' , '00' , 0 , 0 , 0 , 0 , 0 , 0 , 1 , 0 , ' ' , O.FREIGHT_BILLD_FLAG , 'N' , 'X' , 'N' , 'N' , 'N' , 'N' , ' ' , ' ' , 0 , 0 , 0 , 0 FROM PS_IN_DELIVERY D , PS_IN_DELIVERY_ORD O , PS_IN_DELPKGWV_VW P , PS_IN_DELIVERY_FRT F WHERE %Join(COMMON_KEYS, IN_DELIVERY D, IN_DELIVERY_FRT F) AND %Join(COMMON_KEYS, IN_DELIVERY D, IN_DELPKGWV_VW P) AND D.DELIVERY_STATUS IN ('20','60') AND D.DEL_PKG_STATUS = 'Y' AND %Join(COMMON_KEYS, IN_DELIVERY_FRT F, IN_DELIVERY_ORD O) AND F.FREIGHT_APP = 'IN' UNION SELECT DISTINCT D.BUSINESS_UNIT , D.DELIVERY_ID , O.BUSINESS_UNIT , O.DEMAND_SOURCE , O.SOURCE_BUS_UNIT , O.ORDER_NO , %subrec(IN_DELIVERY_SBR, D) , %subrec(IN_DEL_FRT_SBR, F) , %subrec(IN_DTTIME_SBR, D) , P.SETID_INV_ITEM , 0 , ' ' , 0 , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , ' ' , ' ' , ' ' , ' ' , P.UNIT_MEASURE_VOL , P.UNIT_MEASURE_WT , 0 , '99' , '00' , 0 , 0 , 0 , 0 , 0 , 0 , 2 , 0 , ' ' , O.FREIGHT_BILLD_FLAG , 'N' , 'X' , 'N' , 'N' , 'N' , 'N' , ' ' , ' ' , 0 , 0 , 0 , 0 FROM PS_IN_DELIVERY D , PS_IN_DELIVERY_ORD O , PS_IN_DELCNTWV_VW P , PS_IN_DELIVERY_FRT F WHERE %Join(COMMON_KEYS, IN_DELIVERY D, IN_DELIVERY_FRT F) AND %Join(COMMON_KEYS, IN_DELIVERY D, IN_DELCNTWV_VW P) AND %Join(COMMON_KEYS, IN_DELIVERY_FRT F, IN_DELIVERY_ORD O) AND F.FREIGHT_APP = 'IN' AND D.DELIVERY_STATUS IN ('20','60') UNION SELECT DISTINCT D.BUSINESS_UNIT , D.DELIVERY_ID , O.BUSINESS_UNIT , O.DEMAND_SOURCE , O.SOURCE_BUS_UNIT , O.ORDER_NO , %subrec(IN_DELIVERY_SBR, D) , %subrec(IN_DEL_FRT_SBR, F) , %subrec(IN_DTTIME_SBR, D) , S.SETID , 0 , ' ' , 0 , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 1 , '10' , '70' , 0 , 0 , 0 , 0 , 0 , 0 , 3 , 0 , ' ' , O.FREIGHT_BILLD_FLAG , 'N' , 'X' , 'N' , 'N' , 'N' , 'N' , ' ' , ' ' , 0 , 0 , 0 , 0 FROM PS_IN_DELIVERY D , PS_IN_DELIVERY_ORD O , PS_IN_DELIVERY_FRT F , PS_SET_CNTRL_REC S WHERE %Join(COMMON_KEYS, IN_DELIVERY D, IN_DELIVERY_FRT F) AND %Join(COMMON_KEYS, IN_DELIVERY_FRT F, IN_DELIVERY_ORD O) AND F.FREIGHT_APP = 'IN' AND D.DELIVERY_STATUS IN ('20','60') AND S.RECNAME = 'MASTER_ITEM_TBL' AND S.SETCNTRLVALUE = D.BUSINESS_UNIT UNION SELECT DISTINCT D.BUSINESS_UNIT , D.DELIVERY_ID , D.BUSINESS_UNIT , D.DEMAND_SOURCE , D.SOURCE_BUS_UNIT , D.ORDER_NO , %subrec(IN_DELIVERY_SBR, D) , %subrec(IN_DEL_FRT_SBR, F) , %subrec(IN_DTTIME_SBR, D) , P.SETID , 0 , ' ' , 0 , ' ' , 0 , 0 , 0 , 0 , 0 , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , '00' , '00' , 0 , 0 , 0 , 0 , 0 , 0 , 5 , 0 , ' ' , 'N' , 'N' , 'X' , 'N' , 'N' , 'N' , 'N' , ' ' , ' ' , 0 , 0 , 0 , 0 FROM PS_IN_DELIVERY D JOIN PS_SET_CNTRL_REC P ON P.SETCNTRLVALUE = D.BUSINESS_UNIT AND P.RECNAME = 'MASTER_ITEM_TBL' LEFT OUTER JOIN PS_IN_DELIVERY_FRT F ON %Join(COMMON_KEYS, IN_DELIVERY D, IN_DELIVERY_FRT F) AND F.FREIGHT_APP = 'IN' WHERE D.DELIVERY_STATUS IN ('90','99')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
3 SEL_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Select Business Unit
4 SEL_DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Select Demand Source
5 SEL_SOURCE_BU Character(5) VARCHAR2(5) NOT NULL Select Source Business Unit
6 SEL_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Select Order
7 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
8 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: CUST_ADDR_IN_VW

9 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

10 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
11 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
12 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
13 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
14 CITY Character(30) VARCHAR2(30) NOT NULL City
15 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
16 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
17 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
18 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
19 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
20 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
21 COUNTY Character(30) VARCHAR2(30) NOT NULL County
22 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

23 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
24 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
25 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

26 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: CARRIER_ID

27 COMMODITY_CD Character(10) VARCHAR2(10) NOT NULL Commodity Code

Prompt Table: COMMOD_CODE

28 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
29 DOC_REFNUM Character(20) VARCHAR2(20) NOT NULL Counter sale document reference number
30 FREIGHT_BILL_TYPE Character(2) VARCHAR2(2) NOT NULL Freight Bill Type
OE=Order Entry
SH=Shipping
31 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

32 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
33 HARMONIZED_CD Character(14) VARCHAR2(14) NOT NULL Harmonized Code

Prompt Table: HRMN_TARIFF_CD

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

Prompt Table: MST_ITM_PRPT_VW

35 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

Prompt Table: INV_ITEM_GROUP

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

Prompt Table: LOAD_INV

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

Prompt Table: LOCATION_SBU_VW

38 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

Prompt Table: IN_DLV_ORD_VW

39 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order
40 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_VW_BU

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

Prompt Table: ROUTE_INV_VW

42 SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date
43 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: CUST_SHP_INV_VW

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

Prompt Table: SHIP_METHOD

45 TMS_LOAD_STP_NBR Number(5,0) INTEGER NOT NULL Load Stop Number
46 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.
47 BILL_ONLY Character(1) VARCHAR2(1) NOT NULL Indicates a sales order is to be billed only, and not fulfilled through Inventory.

Default Value: N

48 DEL_PKG_STATUS Character(1) VARCHAR2(1) NOT NULL Delivery Contains Packages

Y/N Table Edit

Default Value: N

49 DEL_ORD_RESTRICTED Character(1) VARCHAR2(1) NOT NULL Deliveries restricted to order
N=Deliveries Not Restricted
Y=Deliveries Restricted to Order

Y/N Table Edit

Default Value: N

50 DELIVERY_ERROR Character(1) VARCHAR2(1) NOT NULL Delivery Error

Y/N Table Edit

Default Value: N

51 DELIVERY_STATUS Character(2) VARCHAR2(2) NOT NULL Delivery Status
00=Pending for Demand
10=Pending for Quote
20=Open
60=Closed for Shipment
70=Delivery Completed
90=Canceled
99=Unassigned

Default Value: 20

52 DEPLETED_FLAG Character(1) VARCHAR2(1) NOT NULL Determines whether a reserved order line has already a pick batch id assigned.

Default Value: N

53 FRT_COMMIT_BILLING Character(1) VARCHAR2(1) NOT NULL Freight Committed for Billing

Y/N Table Edit

Default Value: N

54 FRT_RATE_STATUS Character(2) VARCHAR2(2) NOT NULL Rate Status
00=None
10=Requested
20=Received

Default Value: 00

55 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code
56 FRT_BY_QTY Character(1) VARCHAR2(1) NOT NULL Freight by Order Quantity

Y/N Table Edit

Default Value: N

57 FRT_BY_VALUE Character(1) VARCHAR2(1) NOT NULL Freight by Order Value

Y/N Table Edit

Default Value: Y

58 FRT_BY_VOL Character(1) VARCHAR2(1) NOT NULL Freight by Shipping Volume

Y/N Table Edit

Default Value: Y

59 FRT_BY_WT Character(1) VARCHAR2(1) NOT NULL Freight by Shipping Weight

Y/N Table Edit

Default Value: Y

60 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
61 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
62 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
63 FREIGHT_ERROR Character(1) VARCHAR2(1) NOT NULL Freight Error

Y/N Table Edit

Default Value: N

64 FREIGHT_APPLY_APP Character(2) VARCHAR2(2) NOT NULL Identifier with regards to which product calculated freight for a delivery
IN=Inventory
OM=Order Management
65 MANIFEST_STATUS Character(2) VARCHAR2(2) NOT NULL Manifest Status
00=None
10=Requested
20=Received

Default Value: 00

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

Default Value: N

67 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
68 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
69 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
70 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
71 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

Default Value: 0

72 COMM_ARRV_DTTM DateTime(26) TIMESTAMP Communicated Arrival Datetime
73 COMM_SHIP_DTTM DateTime(26) TIMESTAMP Communicated Ship Datetime
74 FREIGHT_CALC_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Calculate Flag

Default Value: N

75 FREIGHT_CHARGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge
76 FREIGHT_CURRNCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
77 FRT_CHRG_AUDIT Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge
78 FRT_CHRG_OPEN Character(1) VARCHAR2(1) NOT NULL Freight can be modified

Y/N Table Edit

Default Value: Y

79 FRT_CHRG_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Freight Charge Override

Y/N Table Edit

Default Value: N

80 FRT_ROLLUP_IND Character(1) VARCHAR2(1) NOT NULL Freight Rollup Flag
1=Delivery
2=Rollup

Default Value: 1

81 FRT_REF_NO Character(30) VARCHAR2(30) NOT NULL Freight Reference Number
82 EXT_SHIP_ID Character(30) VARCHAR2(30) NOT NULL External Shipment Identifier
83 FRT_SRVC_DEFN Character(50) VARCHAR2(50) NOT NULL Freight Service Definition

Prompt Table: %EDITTABLE10

84 FRT_TYPE_CODE Character(10) VARCHAR2(10) NOT NULL Freight Type Code

Prompt Table: IN_FRT_DFLT

85 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
86 IN_FRT_USAGE Character(2) VARCHAR2(2) NOT NULL Indicator of internal or external freight
10=Internal
20=External
30=None
40=Both
87 RATE_SHOPPED Character(1) VARCHAR2(1) NOT NULL Delivery is Rate Shopped

Y/N Table Edit

Default Value: N

88 FREIGHT_NET_PRC Signed Number(29,4) DECIMAL(27,4) NOT NULL Freight Net Value
89 FREIGHT_PRC_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Freight Net Value (base)
90 FREIGHT_QUANTITY Number(17,4) DECIMAL(16,4) NOT NULL Freight Quantity
91 FREIGHT_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Volume
92 FREIGHT_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Weight
93 OVERRIDE_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Override Volume
94 OVERRIDE_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Override Weight
95 TOTAL_NBR_PIECES Number(6,0) INTEGER NOT NULL Total Number of Pieces
96 DTTIME_ADDED DateTime(26) TIMESTAMP Date Time Added
97 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.
98 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
99 SETID_INV_ITEM Character(5) VARCHAR2(5) NOT NULL Inv Items SETID
100 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount
101 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
102 EXT_NET_PRC_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Extended Net Price (base)
103 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
104 ORDERING_QTY Signed Number(18,4) DECIMAL(16,4) NOT NULL Ordering Quantity
105 SHIPPING_QTY Number(17,4) DECIMAL(16,4) NOT NULL Shipping Quantity
106 SHIPPING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Volume
107 SHIPPING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight
108 PACKING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Volume
109 PACKING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Packing Weight
110 DELIV_UOM_QTY Character(3) VARCHAR2(3) NOT NULL Delivery Order Qty UOM
111 DELIV_SHIP_UOM_QTY Character(3) VARCHAR2(3) NOT NULL Delivery Ship Qty UOM
112 DELIV_UOM_SHIP_VOL Character(3) VARCHAR2(3) NOT NULL Ship UOM for volume conversion
113 DELIV_UOM_SHIP_WT Character(3) VARCHAR2(3) NOT NULL Ship UOM for weight conversion
114 DELIV_UOM_VOL Character(3) VARCHAR2(3) NOT NULL Delivery Volume UOM
115 DELIV_UOM_WT Character(3) VARCHAR2(3) NOT NULL Delivery Weight UOM
116 NBR_DEMAND_LINES Number(4,0) SMALLINT NOT NULL Number of Demand Lines
117 MIN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
118 MAX_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
119 FREIGHT_CHARGE_CNV Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge (base)
120 FREIGHT_CHARGE_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge (base)
121 TOTAL_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Weight
122 TOTAL_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Volume
123 TOTAL_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Quantity
124 TOTAL_NET_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Net Amount
125 SELECTTYPE Number(1,0) SMALLINT NOT NULL Selection Type
126 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
127 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
128 FREIGHT_BILLD_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Amount Billed/Posted

Default Value: N

129 CONTAINER_FLAG Character(1) VARCHAR2(1) NOT NULL Containers Exist

Default Value: N

130 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted

Default Value: X

131 CARRIER_UPD Character(1) VARCHAR2(1) NOT NULL Used to mark that a Carrier ID update is pending.

Default Value: N

132 SHP_TYP_UPD Character(1) VARCHAR2(1) NOT NULL Used to mark that a Ship Type ID update is pending.

Default Value: N

133 SHP_DTTM_UPD Character(1) VARCHAR2(1) NOT NULL Used to mark Scheduled Shipping Date/Time update is pending.

Default Value: N

134 CUST_PICKUP Character(1) VARCHAR2(1) NOT NULL Counter sale customer pickup flag
N=No
Y=Yes
135 ERROR_CODE Character(10) VARCHAR2(10) NOT NULL Error Code
136 ERRORMSG Character(254) VARCHAR2(254) NOT NULL Error Message field
137 MAX_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Max Weight Capacity
138 MAX_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Ship Maximum Volume
139 MIN_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Minimum Weight
140 MIN_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Minimum Volume