ACRETAIN

REFERENCED BY
AC121 AC123 AC130 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC32.1 AC37.1 AC490 BR120
BR121 BR123 BR151 BR152 BR156 BR20.1
BR20.2 BR20.3 BR20.4 BR20.5 BR202 BR21.1
BR420 BR450 BR521


UPDATED BY
AC300 BR02.1 BR02.2 BR02.3 BR122 BR140
BRIP.1 BR00.1 BR10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RET-ACTIVITY
Element: Activity
Alpha 15
The contract or posting activity associated with the retainer.
BR02.1
RET-RETAIN-ID
Element: Retain Id
Numeric 6
The Retainer Sequence defined for the activity in BR02. This is a user defined number that is unique by activity.
BR02.1
RET-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BR02.1
RET-RETAINER-TYPE
Element: Retainer Type
Alpha 1
The Retainer Type specified on BR02. The values are: F= First L= Last S=Specific
F = First
L = Last
S = Specific
BR02.1
RET-AMOUNT
Element: Intl Amt
Signed 18.2
BR02.1 BR02.2
RET-APPLIED-AMT
Element: Intl Amt
Signed 18.2
The amount that has been applied to the retainer.
AC300 BRIP.1
RET-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Activity (AC10.1).
BR02.1
RET-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
1 = Hold
2 = Applied
3 = Apply to Next
AC300 BR02.1
BR122 BR140
BRIP.1
RET-RETAIN-GL-CD
Element: Retain Gl Cd
Alpha 4
The retainer GL Code specified in the Contract (BR10).
RET-ACCT-CATEGORY
Element: Acct Category
Alpha 5
The retainer account category specified in the Contract (BR10).
RET-RETAIN-RULE
Element: Retain Rule
Alpha 1
The apply to rule specified in the Retainer (BR02). The values are: 1 = Apply to all Activities 2 = Apply to Retainer Activity
BR02.1
RET-HIH-OBJ-ID
Element: Obj Id
Numeric 12
The processed invoice object Identification.
AC300 BR02.3
BR122


ACRETAIN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RETSET1 ACTIVITY
RETAIN-ID
...
AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC300 AC32.1
AC37.1 AC490
BR00.1 BR02.1
BR02.2 BR02.3
BR10.1 BR120
BR121 BR122
BR123 BR140
BR151 BR152
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5


ACRETAIN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
RET-ACCT-CATEGORY->AAX-ACCT-CATEGORY
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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acretainx ACRETAINX
RET-ACTIVITY->REX-ACTIVITY
RET-RETAIN-ID->REX-RETAIN-ID
  REX-RETAIN-CODE


File created: Thu Jun 09 02:11:12 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.