CACODEREL FILE
Allocation Code Interface
This file contains the non-Lawson allocation code interface records.
REFERENCED BY
CA260
UPDATED BY
CA160 CA60.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CDR-RUN-GROUP Alpha 15 CA60.1
Element: Run Group Run Group and Seq Number are the keys
to the file. They should be used to
group records together for interfacing.
CDR-SEQ-NUMBER Numeric 6 CA60.1
Element: Sequence NumbeA unique number assigned to each record
to be interfaced into the Lawson system.
CDR-ALLOC-CODE Alpha 12 CA60.1
Element: Allocation CodThe allocation code name as defined by
CA05 (Allocation Codes).
CDR-OLD-COMPANY Alpha 35 CA60.1
Element: Old Company The old company structure associated
with the Lawson Company/Accounting Unit.
CDR-VALUE Numeric 13 CA60.1
Element: Value The value determines the percentage
allocated to the company and accounting
unit. The percentage is calculated by
dividing the line value by the total
value.
CACODEREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CDRSET1 RUN-GROUP CA160 CA60.1
SEQ-NUMBER
CDRSET2 ALLOC-CODE KeyChange CA160
OLD-COMPANY
RUN-GROUP
SEQ-NUMBER
CDRSET3 RUN-GROUP KeyChange CA160 CA260
ALLOC-CODE
OLD-COMPANY
SEQ-NUMBER
CACODEREL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Old Company GLCOMPREL Required
CDR-OLD-COMPANY -> GCR-OLD-COMPANY
|
