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