Lawson Insight Technical Documentation |
|
COSGBLK
COSGBLK FILE
OE User Analysis
This file stores user analysis values for order header-, line-, and add-on
charge- related records.
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 AR21.6 IC28.1
MA180 MA41.2 MA41.7 MA43.1 MA43.2 MA43.3
MA43.9 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 MA67.1 MA67.2 MA70.1
MA75.1 MA80.1 MAI1.1 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO25.1 PO25.5 PO25.6
PO25.7 PO27.2 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 POI3.1
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQIE.1
WH20.2 WH20.7 WO30.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OSG-COMPANY Numeric 4 AP125 AP126
Element: Company The company number represents an AP131 AP20.1
established company and is entered on AP20.2 AP20.3
all function codes. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
AR21.6 IC28.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
PO29.1 PO30.1
PO30.2 PO30.3
...
OSG-ORDER-NBR Numeric 8 AP125 AP126
Element: Order Number This field contains the order number. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
AR21.6 IC28.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
PO29.1 PO30.1
PO30.2 PO30.3
...
OSG-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the line number. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
AR21.6 IC28.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
PO29.1 PO30.1
PO30.2 PO30.3
...
OSG-SEQ Numeric 3 AP125 AP126
Element: Sequence NumbeThis field contains the record sequence AP131 AP20.1
number. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
AR21.6 IC28.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
PO29.1 PO30.1
PO30.2 PO30.3
...
OSG-SEGMENT-BLOCK Alpha 103 AP125 AP126
Element: User Analysis This field identifies the user analysis AP131 AP20.1
values included in the transaction. AP20.2 AP20.3
AP20.4 AP20.5
You can either type up to four values AP20.7 AP23.1
or use Define (F6) to open the User AP25.1 AP25.2
Analysis Entry subform. Use this subform AP26.1 AP27.1
to select the user analysis values you AP30.4 API1.1
want to include in the transaction. If AR21.6 IC28.1
you choose to type values, use commas to MA180 MA41.2
separate them. For example: MA41.7 MA43.1
value1,value2,value3,value4 MA43.2 MA43.3
MA43.9 MA530
There are three conditions that affect MA531 MA60.2
how you can select user analysis values. MA60.3 MA60.5
See the User Analysis Entry form help or MA61.1 MA66.2
the Strategic Ledger procedures manual MA66.3 MA67.1
for additional information. MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.1 PO21.2
PO21.3 PO21.4
PO21.5 PO22.1
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
PO29.1 PO30.1
PO30.2 PO30.3
...
COSGBLK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OSGSET1 COMPANY AP125 AP126
ORDER-NBR AP131 AP20.1
LINE-NBR AP20.2 AP20.3
SEQ AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
AR21.6 IC28.1
MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
...
COSGBLK FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Coline COLINE Not Required
OSG-COMPANY -> COL-COMPANY
OSG-ORDER-NBR -> COL-ORDER-NBR
OSG-LINE-NBR -> COL-LINE-NBR
Comisc COMISC Not Required
OSG-COMPANY -> CMC-COMPANY
OSG-ORDER-NBR -> CMC-ORDER-NBR
OSG-LINE-NBR -> CMC-LINE-NBR
OSG-SEQ -> CMC-SEQ
Custorder CUSTORDER Not Required
OSG-COMPANY -> COR-COMPANY
OSG-ORDER-NBR -> COR-ORDER-NBR
|