ACIFPRHDR – No description in the Lawson data dictionary

System
AC Billing Revenue (BR)
Prefix
AFP
Primary key
RUN-GROUP, CONTRACT
Fields
27
Updated by
2 programs
Referenced by
1 program

ACIFPRHDR is a Lawson AC Billing Revenue table (prefix AFP); no description in the lawson data dictionary. It is indexed by RUN-GROUP, CONTRACT (AFPSET1). It is updated by BR570 and BR70.1 and referenced by BR71.1. The table has 27 fields, 1 index and 0 documented relations.

About ACIFPRHDR

No description in the Lawson data dictionary.

Fields (27)

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

Field / columnTypeDescription & valuesUpdated by
AFP-RUN-GROUP PK
RUN_GROUP		Alpha 15Run Group and Seq Number are the keys to the file. They should be used to group records together for interfacing.BR70.1
AFP-CONTRACT PK
CONTRACT		Alpha 15Activity Management contract.BR70.1
AFP-CONT-DATE
CONT_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.BR70.1
AFP-CONT-STATUS
CONT_STATUS		Alpha 2—BR70.1
AFP-DEFERRED-FL
DEFERRED_FL		Alpha 1—
  • Y Yes
  • N No
BR70.1
AFP-DEFERRED-AMT
DEFERRED_AMT		Signed 18.2—BR70.1
AFP-REASON-CODE
REASON_CODE		Alpha 4This field contains the reason code, which indicates the cause for credit memos.BR70.1
AFP-DISCOUNT-PCT
DISCOUNT_PCT		Signed 8.5—BR70.1
AFP-PRODUCT-LIST
PRODUCT_LIST		Alpha 10—BR70.1
AFP-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.BR70.1
AFP-SERVICE-LOC
SERVICE_LOC		Numeric 4A user defined code identifying a customer's service location.BR70.1
AFP-MAINT-SCHEDULE
MAINT_SCHEDULE		Alpha 15—BR70.1
AFP-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.BR70.1
AFP-MAINT-PERCENT
MAINT_PERCENT		Signed 7.3The percentage determines how much retention is held. It can either be a percentage of each invoice, or it can be a percentage of a total.BR70.1
AFP-LIST-NET-FLAG
LIST_NET_FLAG		Alpha 1—
  • 1 List
  • 2 Net
BR70.1
AFP-BEGIN-DATE
BEGIN_DATE		Numeric 8 (yyyymmdd)The begin date for this effort period.BR70.1
AFP-END-DATE
END_DATE		Numeric 8 (yyyymmdd)The end date for this effort period.BR70.1
AFP-DFLT-COMPANY
DFLT_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.BR70.1
AFP-DFLT-ACCT-UNIT
DFLT_ACCT_UNIT		Alpha 15The 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.BR70.1
AFP-BILL-ACCT-CAT
BILL_ACCT_CAT		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruBR70.1
AFP-BILL-ACCOUNT
BILL_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.BR70.1
AFP-BILL-SUB-ACCT
BILL_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.BR70.1
AFP-BILL-GL-CD
BILL_GL_CD		Alpha 4—BR70.1
AFP-UNBL-ACCT-CAT
UNBL_ACCT_CAT		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruBR70.1
AFP-UNBL-ACCOUNT
UNBL_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.BR70.1
AFP-UNBL-SUB-ACCT
UNBL_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.BR70.1
AFP-UNBL-GL-CD
UNBL_GL_CD		Alpha 4—BR70.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
AFPSET1RUN-GROUP, CONTRACTPrimaryBR570, BR70.1, BR70.2, BR71.1

Programs

Updated by (2)

Referenced by (1)