ACIFPRDTL – No description in the Lawson data dictionary

System
AC Billing Revenue (BR)
Prefix
AFD
Primary key
CONTRACT, PRODUCT, PROD-VERSION, LINE-NBR
Fields
37
Updated by
3 programs
Referenced by
0 programs

ACIFPRDTL is a Lawson AC Billing Revenue table (prefix AFD); no description in the lawson data dictionary. It is indexed by CONTRACT, PRODUCT, PROD-VERSION, LINE-NBR (AFDSET1). It is updated by BR570, BR70.1 and BR70.2. The table has 37 fields, 1 index and 0 documented relations.

About ACIFPRDTL

No description in the Lawson data dictionary.

Fields (37)

Column = COBOL field name without the AFD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#AFD-CONTRACT PK
CONTRACT		Alpha 15Activity Management contract.BR70.1
#AFD-PRODUCT PK
PRODUCT		Alpha 15—BR70.1
#AFD-PROD-VERSION PK
PROD_VERSION		Alpha 10—BR70.1
#AFD-LINE-NBR PK
LINE_NBR		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.BR70.1
#AFD-USERS
USERS		Numeric 12—BR70.1
#AFD-INCLUDE-BASE
INCLUDE_BASE		Alpha 1—
  • Y Yes
  • N No
BR70.1
#AFD-DEFERRED-FL
DEFERRED_FL		Alpha 1—
  • Y Yes
  • N No
BR70.1
#AFD-TOT-DEF-AMT
TOT_DEF_AMT		Signed 18.2—BR70.1
#AFD-REASON-CODE
REASON_CODE		Alpha 4This field contains the reason code, which indicates the cause for credit memos.BR70.1
#AFD-ACTUAL-PRICE
ACTUAL_PRICE		Signed 18.2—BR70.1
#AFD-LIST-PRICE
LIST_PRICE		Signed 18.2—BR70.1
#AFD-DISCOUNT-PCT
DISCOUNT_PCT		Signed 8.5—BR70.1
#AFD-INV-NET-PRICE
INV_NET_PRICE		Signed 18.2—BR70.1
#AFD-DELIV-METHOD
DELIV_METHOD		Alpha 1—
  • S Shipped
  • H Hosted
  • E Electronic
  • L Loaded
  • 1 Method 1
  • 2 Method 2
  • 3 Method 3
BR70.1
#AFD-SHIP-DATE
SHIP_DATE		Numeric 8 (yyyymmdd)This field contains the ship date. If left blank, the system date defaults.BR70.1
#AFD-ANT-SHIP-DATE
ANT_SHIP_DATE		Numeric 8 (yyyymmdd)This field contains the ship date. If left blank, the system date defaults.BR70.1
#AFD-END-DATE
END_DATE		Numeric 8 (yyyymmdd)The end date for this effort period.BR70.1
#AFD-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
#AFD-LIST-NET-FLAG
LIST_NET_FLAG		Alpha 1—
  • 1 List
  • 2 Net
BR70.1
#AFD-SUITE
SUITE		Alpha 6—BR70.1
#AFD-USER-FIELD1
USER_FIELD1		Alpha 15 (Lower Case)—BR70.1, BR70.2
#AFD-USER-FIELD2
USER_FIELD2		Alpha 15 (Lower Case)—BR70.1, BR70.2
#AFD-USER-FIELD3
USER_FIELD3		Alpha 15 (Lower Case)—BR70.1, BR70.2
#AFD-SITE-LOCATION
SITE_LOCATION		Numeric 2—BR70.1, BR70.2
#AFD-REV-ACCT-CAT
REV_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
#AFD-REV-ACCOUNT
REV_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
#AFD-REV-SUB-ACCT
REV_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
#AFD-REV-GL-CD
REV_GL_CD		Alpha 4—BR70.1
#AFD-TOTAL-COST
TOTAL_COST		Signed 18.2—BR70.1, BR70.2
#AFD-CGSX-ACCT-CAT
CGSX_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, BR70.2
#AFD-CGSX-ACCOUNT
CGSX_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, BR70.2
#AFD-CGSX-SUB-ACCT
CGSX_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, BR70.2
#AFD-CGSX-GL-CD
CGSX_GL_CD		Alpha 4—BR70.1, BR70.2
#AFD-CGSL-ACCT-CAT
CGSL_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, BR70.2
#AFD-CGSL-ACCOUNT
CGSL_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, BR70.2
#AFD-CGSL-SUB-ACCT
CGSL_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, BR70.2
#AFD-CGSL-GL-CD
CGSL_GL_CD		Alpha 4—BR70.1, BR70.2

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AFDSET1
  1. CONTRACT
  2. PRODUCT
  3. PROD-VERSION
  4. LINE-NBR
PrimaryBR570, BR70.1, BR70.2

Programs

Updated by (3)