ACTEMPCUST – No description in the Lawson data dictionary

System
Activity Management (AC)
Prefix
AEU
Primary key
TEMPLATE
Fields
24
Updated by
1 program
Referenced by
2 programs

ACTEMPCUST is a Lawson Activity Management table (prefix AEU); no description in the lawson data dictionary. It is indexed by TEMPLATE (AEUSET1). It is updated by BR48.1 and referenced by AC56.1 and AC560. The table has 24 fields, 1 index and 0 documented relations.

About ACTEMPCUST

No description in the Lawson data dictionary.

Fields (24)

Column = COBOL field name without the AEU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
AEU-TEMPLATE PK
TEMPLATE
Alpha 15The name of the template the detail records are associated to.BR48.1
AEU-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field displays the description.BR48.1
AEU-COMPANY
COMPANY
Numeric 4Identifies 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.BR48.1
AEU-AC-CUSTOMER-ID
AC_CUSTOMER_ID
Alpha 5BR48.1
AEU-PROCESS-LEVEL
PROCESS_LEVEL
Alpha 5This field contains the process level, which is the reporting hierarchy below company.BR48.1
AEU-PERC-BILLABLE
PERC_BILLABLE
Signed 7.4This field determines the amount to be allocated. The percentage you define multiplied by the From Company account balance = the amount allocated. If you leave this field blank, 100 percent defaults.BR48.1
AEU-TAX-EXEMPT-CD
TAX_EXEMPT_CD
Alpha 1Code indicating the taxing status. E - Exempt, T - Taxable.
  • E Exempt
  • T Taxable
BR48.1
AEU-TAX-CODE
TAX_CODE
Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.BR48.1
AEU-INVC-PREFIX
INVC_PREFIX
Alpha 2This field contains the invoice prefix that is assigned from either the company or process level, depending on the invoice-level option chosen.BR48.1
AEU-CM-PREFIX
CM_PREFIX
Alpha 2BR48.1
AEU-INVC-OPTIONS
INVC_OPTIONS
Alpha 1
  • A Account Category
  • B Contract Category Group
  • C Attribute
  • D Resource
  • E Summary Account Category
BR48.1
AEU-INVC-FORMAT
INVC_FORMAT
Alpha 1
  • S Standard
  • C Custom
  • F Fax
  • E EDI
  • V Custom Vat
BR48.1
AEU-CUMULATIVE-FL
CUMULATIVE_FL
Alpha 1
  • Y Yes
  • N No
BR48.1
AEU-AR-INT-OPTION
AR_INT_OPTION
Alpha 1
  • S Summary
  • D Detail
  • A Activity
BR48.1
AEU-EXCEED-OPTION
EXCEED_OPTION
Alpha 1
  • E Exclude
  • I Include
BR48.1
AEU-INVC-SUMM-OPT
INVC_SUMM_OPT
Alpha 1
  • D Detail Only
  • S Invoice Summary Only
BR48.1
AEU-INVC-OPTION-2
INVC_OPTION_2
Alpha 1
  • A Account Category
  • B Contract Category Group
  • C Attribute
  • D Resource
  • E Summary Account Category
BR48.1
AEU-JURIS-CODE
JURIS_CODE
Alpha 3BR48.1
AEU-TAX-PRINT
TAX_PRINT
Alpha 1
  • M Multiple sum by code/level
  • S Single tax line
BR48.1
AEU-TAX-CALC-FLAG
TAX_CALC_FLAG
Alpha 1This flag determines whether tax will be calculated at a detail level or summary level. If calculated at a detail level, tax amounts will be calculated separately for each invoice line. If calculated at a summary level, taxable amount for a tax code for the whole invoice will be determined, and tax will be calculated on that summarized taxable amount.
  • 1 Detail
  • 2 Summary
BR48.1
AEU-FEE-EXCEED-OPT
FEE_EXCEED_OPT
Alpha 1
  • I Include
  • E Exclude
BR48.1
AEU-INVC-OPTION-3
INVC_OPTION_3
Alpha 1
  • A Account Category
  • B Contract Category Group
  • C Attribute
  • D Resource
  • E Summary Account Category
BR48.1
AEU-INVC-OPTION-4
INVC_OPTION_4
Alpha 1
  • A Account Category
  • B Contract Category Group
  • C Attribute
  • D Resource
  • E Summary Account Category
BR48.1
AEU-INVC-OPTION-5
INVC_OPTION_5
Alpha 1
  • A Account Category
  • B Contract Category Group
  • C Attribute
  • D Resource
  • E Summary Account Category
BR48.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AEUSET1TEMPLATEPrimaryAC56.1, AC560, BR48.1

Programs

Updated by (1)

Referenced by (2)