Lawson Insight Technical Documentation |
|
ACRETAIN
ACRETAIN FILE
REFERENCED BY
AC121 AC123 AC130 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC32.1 AC37.1 AC490 BR120
BR121 BR20.1 BR20.2 BR20.3 BR20.4 BR20.5
BR202 BR21.1 BR420 BR450 BR521
UPDATED BY
AC300 AC310 BR02.1 BR02.2 BR02.3 BR122
BRIP.1 BR00.1 BR10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RET-ACTIVITY Alpha 15 BR02.1
Element: Activity The contract or posting activity
associated with the retainer.
RET-RETAIN-ID Numeric 6 BR02.1
Element: Retain Id The Retainer Sequence defined for the
activity in BR02. This is a user
defined number that is unique by
activity.
RET-DESCRIPTION Alpha 30 (Lower Case) BR02.1
Element: Description This field displays the description.
RET-RETAINER-TYPE Alpha 1 BR02.1
Element: Retainer Type The Retainer Type specified on BR02.
The values are:
F= First
L= Last
S=Specific
F = First
L = Last
S = Specific
RET-AMOUNT Signed 18.2 BR02.1 BR02.2
Element: Intl Amt This is the amounts by period for the
specified record.
RET-APPLIED-AMT Signed 18.2 AC300 BRIP.1
Element: Intl Amt The amount that has been applied to the
retainer.
RET-CURRENCY-CODE Alpha 5 BR02.1
Element: Currency Code This field contains the company base
currency code established in Activity
(AC10.1).
RET-STATUS Numeric 1 AC300 BR02.1
Element: Status This field displays the status of the BR122 BRIP.1
transaction.
1 = Hold
2 = Applied
3 = Apply to Next
RET-RETAIN-GL-CD Alpha 4
Element: Retain Gl Cd The retainer GL Code specified in the
Contract (BR10).
RET-ACCT-CATEGORY Alpha 5
Element: Account CategoThe retainer account category specified
in the Contract (BR10).
RET-RETAIN-RULE Alpha 1 BR02.1
Element: Retain Rule The apply to rule specified in the
Retainer (BR02).
The values are:
1 = Apply to all Activities
2 = Apply to Retainer Activity
RET-HIH-OBJ-ID Numeric 12 AC300 BR02.3
Object The processed invoice object BR122
Identification Identification.
ACRETAIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RETSET1 ACTIVITY AC121 AC123
RETAIN-ID AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC300 AC310
AC32.1 AC37.1
AC490 BR00.1
BR02.1 BR02.2
BR02.3 BR10.1
BR120 BR121
BR122 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR202 BR21.1
BR420 BR450
...
RETSET2 ACTIVITY KeyChange
RETAIN-ID*
ACRETAIN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
RET-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acactivity ACACTIVITY Required
RET-ACTIVITY -> ACV-ACTIVITY
Acbill ACBILL Required
RET-ACTIVITY -> ACI-ACTIVITY
Acglcode ACGLCODE Not Required
RET-RETAIN-GL-CD -> AGC-AC-GL-CODE
ACRETAIN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acretainx ACRETAINX
RET-ACTIVITY -> REX-ACTIVITY
RET-RETAIN-ID -> REX-RETAIN-ID
REX-RETAIN-CODE
|