ACIFTEMPL – No description in the Lawson data dictionary
- System
- Activity Management (AC)
- Prefix
ATE- Primary key
RUN-GROUP,ACTIVITY-GRP,ACTIVITY- Fields
- 39
- Updated by
- 2 programs
- Referenced by
- 2 programs
ACIFTEMPL is a Lawson Activity Management table (prefix ATE); no description in the lawson data dictionary. It is indexed by RUN-GROUP, ACTIVITY-GRP, ACTIVITY (ATESET1); alternate indexes: ATESET2. It is updated by AC56.1 and AC560 and referenced by AC70.1 and AC71.1. The table has 39 fields, 2 indexes and 0 documented relations.
About ACIFTEMPL
No description in the Lawson data dictionary.
Fields (39)
Column = COBOL field name without the ATE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ATE-RUN-GROUP PKRUN_GROUP | Alpha 15 | Run Group and Seq Number are the keys to the file. They should be used to group records together for interfacing. | AC56.1 |
ATE-ACTIVITY-GRP PKACTIVITY_GRP | Alpha 15 | The activity group is the overall project. | AC56.1, AC560 |
ATE-ACTIVITY PKACTIVITY | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | AC56.1 |
ATE-GRP-DESCGRP_DESC | Alpha 30 (Lower Case) | This field displays the description. | AC56.1, AC560 |
ATE-GRP-TEMPLATEGRP_TEMPLATE | Alpha 15 | The name of the template the detail records are associated to. | AC56.1 |
ATE-ACT-DESCACT_DESC | Alpha 30 (Lower Case) | This field displays the description. | AC56.1 |
ATE-ACT-TEMPLATEACT_TEMPLATE | Alpha 15 | The name of the template the detail records are associated to. | AC56.1 |
ATE-PARENT-ACTVPARENT_ACTV | Alpha 15 | The parent activity field contains the activity name of the member parent. | AC56.1 |
ATE-POSTING-FLAGPOSTING_FLAG | Alpha 1 | —
| AC56.1 |
ATE-LEVEL-DEPTHLEVEL_DEPTH | Numeric 1 | The number of variable levels pertaining to this record. | AC56.1 |
ATE-ACT-ATTR-TEMPLACT_ATTR_TEMPL | Alpha 12 | — | AC56.1 |
ATE-COPY-FROM-AGCOPY_FROM_AG | Alpha 15 | The activity group is the overall project. | AC56.1 |
ATE-COPY-FROM-ACTCOPY_FROM_ACT | Alpha 15 | Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. | AC56.1 |
ATE-CONTRACTCONTRACT | Alpha 15 | Activity Management contract. | AC56.1 |
ATE-CNT-DESCCNT_DESC | Alpha 30 (Lower Case) | This field displays the description. | AC56.1 |
ATE-CNT-TEMPLATECNT_TEMPLATE | Alpha 15 | The name of the template the detail records are associated to. | AC56.1 |
ATE-CNT-TYPECNT_TYPE | Alpha 1 | —
| AC56.1 |
ATE-CNT-ACCT-TEMPCNT_ACCT_TEMP | Alpha 15 | The name of the template the detail records are associated to. | AC56.1 |
ATE-AR-COMPANYAR_COMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | AC56.1 |
ATE-AR-CUSTOMERAR_CUSTOMER | Alpha 9 (Right Justified) | This field contains the number that represents a customer. | AC56.1 |
ATE-CUST-TEMPLATECUST_TEMPLATE | Alpha 15 | The name of the template the detail records are associated to. | AC56.1 |
ATE-AC-CUSTOMER-IDAC_CUSTOMER_ID | Alpha 5 | — | AC56.1 |
ATE-AG-CURRENCYAG_CURRENCY | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | AC56.1 |
ATE-ACT-CURRENCYACT_CURRENCY | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | AC56.1 |
ATE-DFLT-COMPANYDFLT_COMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | AC56.1 |
ATE-DFLT-ACCT-UNITDFLT_ACCT_UNIT | Alpha 15 | The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. | AC56.1 |
ATE-DFLT-ACCOUNTDFLT_ACCOUNT | Numeric 6 | This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. | AC56.1 |
ATE-DFLT-SUB-ACCTDFLT_SUB_ACCT | Numeric 4 | This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. | AC56.1 |
ATE-BEGIN-DATEBEGIN_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | AC56.1 |
ATE-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | AC56.1 |
ATE-CNT-CURRENCYCNT_CURRENCY | Alpha 5 | This field contains the company base currency code established in Company (GL10.1 ). | AC56.1 |
ATE-FIXED-EXCHANGEFIXED_EXCHANGE | Alpha 1 | — | AC56.1 |
ATE-EXCHANGE-RATEEXCHANGE_RATE | Signed 14.7 | — | AC56.1 |
ATE-CUST-PO-NBRCUST_PO_NBR | Alpha 22 | — | AC56.1 |
ATE-BANK-INST-CODEBANK_INST_CODE | Alpha 3 | A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction. | AC56.1 |
ATE-MAINT-RENEW-DTMAINT_RENEW_DT | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | AC56.1 |
ATE-GRP-ATTR-TEMPLGRP_ATTR_TEMPL | Alpha 12 | — | AC56.1 |
ATE-GRP-POP-TEMPLGRP_POP_TEMPL | Alpha 15 | The name of the template the detail records are associated to. | AC56.1 |
ATE-ACT-POP-TEMPLACT_POP_TEMPL | Alpha 15 | The name of the template the detail records are associated to. | AC56.1 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ATESET1 | RUN-GROUP, ACTIVITY-GRP, ACTIVITY | Primary | AC56.1, AC560, AC70.1, AC71.1 | |
ATESET2 | RUN-GROUP, ACTIVITY-GRP, LEVEL-DEPTH, PARENT-ACTV, ACTIVITY | KeyChange | AC560 |