Lawson Insight Technical Documentation |
|
SIOEBCIUPD
SIOEBCIUPD FILE
UPDATED BY
WH130 WH132 WH190 WH20.7 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 WH33.5 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SIB-COMPANY Numeric 4 WH130 WH132
Element: Company The company number represents an WH190 WH20.7
established company and is entered on WH30.1 WH30.2
all function codes. WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
SIB-ORDER-NBR Numeric 8 WH130 WH132
Element: Order Number This field contains the order number. WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
SIB-LINE-NBR Numeric 6 WH130 WH132
Element: Line Number This field contains the line number. WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
SIB-SIEB-UPD-CODE Alpha 4 WH130 WH132
Element: Sieb Upd Code COLP WH190 WH20.7
CORE WH30.1 WH30.2
RELH WH30.3 WH30.4
BO WH31.1 WH31.2
REPL WH31.3 WH31.4
PICK WH32.1 WH32.2
SHIP WH32.3 WH32.4
CORR WH33.5 WH34.1
CLOS WH34.2 WH34.3
CANC WH34.4 WH40.1
WH40.2 WH520
WH830
SIB-ROW-ID Alpha 15 (Lower Case) WH130 WH132
Element: Row Id WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
SIB-DATE Numeric 8 (yyyymmdd) WH130 WH132
Element: Date This field displays the system date WH190 WH20.7
when this was created. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
SIB-TIME Numeric 8 WH130 WH132
Element: Time This field is updated automatically to WH190 WH20.7
indicate the time that the GL entry was WH30.1 WH30.2
created. It is system-maintained. WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
SIB-ORDER-SOURCE Alpha 2 WH130 WH132
Element: Order Source WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
SIB-LOCATION Alpha 5 WH130 WH132
Element: Location Code This field contains a valid stocking WH190 WH20.7
location within the company inventory. WH30.1 WH30.2
WH30.3 WH30.4
WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
SIB-SHIPMENT-NBR Numeric 10 WH130 WH132
Element: Shipment NumbeThis field contains the shipment WH190 WH20.7
number. One order can have several WH30.1 WH30.2
shipment numbers if the items of the WH30.3 WH30.4
order were not shipped at the same time. WH31.1 WH31.2
WH31.3 WH31.4
WH32.1 WH32.2
WH32.3 WH32.4
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
SIB-SHIPPED-QTY Signed 13.4 WH130 WH190
Element: Quantity WH32.1 WH32.2
WH32.4
SIB-SHIP-DATE Numeric 8 (yyyymmdd) WH190 WH32.1
Element: Date This field contains the ship date. If WH32.2 WH32.4
left blank, the system date defaults.
SIB-CARRIER Alpha 9 (Right Justified) WH190 WH32.1
Element: Vendor ID WH32.2 WH32.4
SIB-FREIGHT-CODE Alpha 2 WH190 WH32.1
Element: Add On Cost Code WH32.2 WH32.4
SIB-FRT-CHG-CURR Signed 15.2 WH190 WH32.1
Element: Frt Charge WH32.2 WH32.4
SIB-BOL-NBR Alpha 22 WH190 WH32.1
Bill of Lading This field contains the Bill of Lading WH32.2 WH32.4
Number number.
SIB-TRANS-ID Alpha 20 WH190 WH32.1
Element: Trans Id WH32.2 WH32.4
SIB-BACKORD-QTY Signed 13.4
Element: Quantity
SIB-REPLACE-ITEM Alpha 32
Element: Item Number
SIB-CXL-QTY Signed 13.4 WH20.7
Element: Quantity
SIB-CXL-DATE Numeric 8 (yyyymmdd) WH20.7
Element: Date
SIB-CXL-REASON Alpha 4 WH20.7
Element: Cb Reason
SIB-OPERATOR Alpha 10 WH20.7
Element: Operator Code This field is used to store the login
id of the person who entered the record.
SIB-ORDER-QTY Signed 13.4 WH20.7
Element: Quantity
SIB-ITEM Alpha 32
Element: Item Number This field contains the item
identifier.
SIB-MESSAGE Alpha 60 (Lower Case) WH130 WH132
Element: Message WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
SIB-UPDATE-FLAG Alpha 1
Element: Update Flag Y = Yes-Updated and Sent to Siebel
SIOEBCIUPD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SIBSET1 COMPANY WH130 WH132
ORDER-NBR WH190 WH20.7
LINE-NBR WH30.1 WH30.2
SIEB-UPD-CODE WH30.3 WH30.4
LOCATION WH31.1 WH31.2
SHIPMENT-NBR WH31.3 WH31.4
ROW-ID WH32.1 WH32.2
DATE WH32.3 WH32.4
TIME WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
SIBSET2 SIEB-UPD-CODE KeyChange, Subset
DATE Where UPDATE-FLAG != "Y"
TIME
COMPANY
ORDER-NBR
LINE-NBR
LOCATION
SHIPMENT-NBR
ROW-ID
SIBSET3 SIEB-UPD-CODE KeyChange
ROW-ID
COMPANY
ORDER-NBR
LINE-NBR
LOCATION
SHIPMENT-NBR
DATE
TIME
SIBSET4 UPDATE-FLAG KeyChange
DATE
TIME
SIEB-UPD-CODE
COMPANY
ORDER-NBR
LINE-NBR
LOCATION
SHIPMENT-NBR
ROW-ID
|