ACSUBPAY – Activity Subcontractor
- System
- Activity Management (AC)
- Prefix
SBP- Primary key
COMPANY,VENDOR,INVOICE,SUFFIX- Fields
- 45
- Updated by
- 1 program
- Referenced by
- 0 programs
ACSUBPAY is the Activity Subcontractor table in Lawson Activity Management (prefix SBP). It is indexed by COMPANY, VENDOR, INVOICE, SUFFIX (SBPSET1). It is related 1:1 to APCOMPANY, APPROCLEV and APVENMAST and 1:M to APINVOICE. It is updated by AC42.1. The table has 45 fields, 1 index and 4 documented relations.
About ACSUBPAY
No description in the Lawson data dictionary.
Fields (45)
Column = COBOL field name without the SBP- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#SBP-COMPANY PKCOMPANY | 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. | AC42.1 |
#SBP-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | AC42.1 |
#SBP-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice. | AC42.1 |
#SBP-SUFFIX PKSUFFIX | Numeric 3 | This is the suffix for the invoice. | AC42.1 |
#SBP-VOUCHER-NBRVOUCHER_NBR | Alpha 10 | — | AC42.1 |
#SBP-AUTH-CODEAUTH_CODE | Alpha 3 | A user-defined code representing a person or department responsible for approving a registered invoice. | AC42.1 |
#SBP-PROC-LEVELPROC_LEVEL | Alpha 5 | This field contains the process level, which is the reporting hierarchy below company. | AC42.1 |
#SBP-INVOICE-TYPEINVOICE_TYPE | Alpha 1 | THis field will be filled in from the Invoice based on PO number. This is a carrier for the field. The PORECEIVE file will have to be updated with this field. | AC42.1 |
#SBP-INV-CURRENCYINV_CURRENCY | Alpha 5 | — | AC42.1 |
#SBP-INVOICE-DTEINVOICE_DTE | Numeric 8 (yyyymmdd) | — | AC42.1 |
#SBP-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | AC42.1 |
#SBP-BASE-INV-AMTBASE_INV_AMT | Signed 18.2 | — | AC42.1 |
#SBP-DISCOUNT-RTDISCOUNT_RT | Percent 5.3 (Percent) | — | AC42.1 |
#SBP-DISC-DATEDISC_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | AC42.1 |
#SBP-DUE-DATEDUE_DATE | Numeric 8 (yyyymmdd) | The transaction due date. | AC42.1 |
#SBP-REMIT-TO-CODEREMIT_TO_CODE | Alpha 4 | A user-defined code that represents a vendor's remittance address. | AC42.1 |
#SBP-REC-STATUSREC_STATUS | Numeric 1 | The record status. | — |
#SBP-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | The creation date. | AC42.1 |
#SBP-DISTRIB-DATEDISTRIB_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | AC42.1 |
#SBP-CREATION-TIMECREATION_TIME | Numeric 6 (hhmmss) | The creation time. | AC42.1 |
#SBP-VENDOR-GROUPVENDOR_GROUP | Alpha 4 | A vendor group represents a group of vendors that can be shared by one or more companies. | AC42.1 |
#SBP-DISCOUNT-CODEDISCOUNT_CODE | Alpha 10 | A user-defined code that represents a general ledger discount account. | AC42.1 |
#SBP-APPROVED-FLAGAPPROVED_FLAG | Alpha 1 | — | AC42.1 |
#SBP-APPRV-OPERATORAPPRV_OPERATOR | Alpha 10 | This field is used to store the login id of the person who entered the record. | AC42.1 |
#SBP-OBJ-IDOBJ_ID | Numeric 12 | This 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. | AC42.1 |
#SBP-TERMS-CDTERMS_CD | Alpha 5 | A user-defined code representing a method of determining invoice due and discount dates. | AC42.1 |
#SBP-REASON-CODEREASON_CODE | Alpha 4 | This field contains the reason code, which indicates the cause for credit memos. | AC42.1 |
#SBP-HANDLING-CODEHANDLING_CODE | Alpha 4 | — | AC42.1 |
#SBP-ACTIVITYACTIVITY | 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. | AC42.1 |
#SBP-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | Account 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 thru | AC42.1 |
#SBP-DIST-COMPANYDIST_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. | AC42.1 |
#SBP-DIS-ACCT-UNITDIS_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. | AC42.1 |
#SBP-DIS-ACCOUNTDIS_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. | AC42.1 |
#SBP-DIS-SUB-ACCTDIS_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. | AC42.1 |
#SBP-SEGMENT-BLOCKSEGMENT_BLOCK | Alpha 103 | This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information. | AC42.1 |
#SBP-RCPT-INV-DATERCPT_INV_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | AC42.1 |
#SBP-TRAN-DISC-AMTTRAN_DISC_AMT | Signed 18.2 | — | AC42.1 |
#SBP-TRAN-ALOW-AMTTRAN_ALOW_AMT | Signed 18.2 | — | AC42.1 |
#SBP-ANTICIPATIONANTICIPATION | Alpha 1 | The anticipation flag. | AC42.1 |
#SBP-CONTROL-GROUPCONTROL_GROUP | Numeric 8 | This field displays the journal entry number used for process control of the journal entry detail. | AC42.1 |
#SBP-TRANS-TYPETRANS_TYPE | Alpha 1 | Determines if amounts or units are processed in each transaction. | AC42.1 |
#SBP-LAST-REC-SEQLAST_REC_SEQ | Numeric 6 | — | AC42.1 |
#SBP-PO-NUMBERPO_NUMBER | Alpha 14 (Right Justified) | PO Number that will be passed to the AP system. It will not be edited against data in the PO system. | AC42.1 |
#SBP-PO-RELEASEPO_RELEASE | Numeric 4 | The purchase order release number associated with the invoice. | AC42.1 |
#SBP-PO-CODEPO_CODE | Alpha 4 | Purchase order number code. Used to keep purchase orders unique. Can be used for reporting purposes. | AC42.1 |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
SBPSET1 |
| Primary | AC42.1 |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Apcompany | APCOMPANY | Required |
| |||||||
| Approclev | APPROCLEV | Required |
| |||||||
| Apvenmast | APVENMAST | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Apinvoice | APINVOICE |
|
Programs
Updated by (1)
- AC42.1 Subcontractor Time and Material Entry