Activity Subcontractor

The ACSUBPAY file maintains subcontractor time and expense transactions. The primary program which updates this file is AC42 (Subcontractor Entry).
UPDATED BY

AC42.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
SBP-COMPANY Element: 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-VENDOR Element: Vendor	Alpha 9 (Right Justified) The vendor's identification code.	AC42.1
SBP-INVOICE Element: Invoice	Alpha 22 Used to identify the invoice.	AC42.1
SBP-SUFFIX Element: Suffix	Numeric 3 This is the suffix for the invoice.	AC42.1
SBP-VOUCHER-NBR Element: Voucher Nbr	Alpha 10	AC42.1
SBP-AUTH-CODE Element: Auth Code	Alpha 3 A user-defined code representing a person or department responsible for approving a registered invoice.	AC42.1
SBP-PROC-LEVEL Element: Process Level	Alpha 5 This field contains the process level, which is the reporting hierarchy below company.	AC42.1
SBP-INVOICE-TYPE Element: Invoice 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-CURRENCY Element: To Base Curr	Alpha 5	AC42.1
SBP-INVOICE-DTE Element: Invoice Dte	Numeric 8 (yyyymmdd)	AC42.1
SBP-DESCRIPTION Element: Description	Alpha 30 (Lower Case) This field displays the description.	AC42.1
SBP-BASE-INV-AMT Element: Intl Amt	Signed 18.2	AC42.1
SBP-DISCOUNT-RT Element: Discount Rt	Percent 5.3 (Percent)	AC42.1
SBP-DISC-DATE Element: Date	Numeric 8 (yyyymmdd) This field displays the system date when this was created.	AC42.1
SBP-DUE-DATE Element: Due Date	Numeric 8 (yyyymmdd) The transaction due date.	AC42.1
SBP-REMIT-TO-CODE Element: Remit To Code	Alpha 4 A user-defined code that represents a vendor's remittance address.	AC42.1
SBP-REC-STATUS Element: Rec Status	Numeric 1 The record status.
SBP-CREATE-DATE Element: Create Date	Numeric 8 (yyyymmdd) The creation date.	AC42.1
SBP-DISTRIB-DATE Element: Date	Numeric 8 (yyyymmdd) This field displays the system date when this was created.	AC42.1
SBP-CREATION-TIME Element: Creation Time	Numeric 6 (hhmmss) The creation time.	AC42.1
SBP-VENDOR-GROUP Element: Vendor Group	Alpha 4 A vendor group represents a group of vendors that can be shared by one or more companies.	AC42.1
SBP-DISCOUNT-CODE Element: Discount Code	Alpha 10 A user-defined code that represents a general ledger discount account.	AC42.1
SBP-APPROVED-FLAG Element: Approved Flag	Alpha 1	AC42.1
SBP-APPRV-OPERATOR Element: Operator	Alpha 10 This field is used to store the login id of the person who entered the record.	AC42.1
SBP-OBJ-ID Element: Obj 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-CD Element: Term Code	Alpha 5 A user-defined code representing a method of determining invoice due and discount dates.	AC42.1
SBP-REASON-CODE Element: Reason Code	Alpha 4 This field contains the reason code, which indicates the cause for credit memos.	AC42.1
SBP-HANDLING-CODE Element: Handling Code	Alpha 4	AC42.1
SBP-ACTIVITY Element: Activity	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-CATEGORY Element: Acct 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-COMPANY Element: 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-UNIT Element: 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-ACCOUNT Element: 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-ACCT Element: 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-BLOCK Element: Segment 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-DATE Element: Date	Numeric 8 (yyyymmdd) This field displays the system date when this was created.	AC42.1
SBP-TRAN-DISC-AMT Element: Intl Amt	Signed 18.2	AC42.1
SBP-TRAN-ALOW-AMT Element: Intl Amt	Signed 18.2	AC42.1
SBP-ANTICIPATION Element: Anticipation	Alpha 1 The anticipation flag.	AC42.1
SBP-CONTROL-GROUP Element: Control Group	Numeric 8 This field displays the journal entry number used for process control of the journal entry detail.	AC42.1
SBP-TRANS-TYPE Element: Trans Type	Alpha 1 Determines if amounts or units are processed in each transaction.	AC42.1
SBP-LAST-REC-SEQ Element: Last Rec Seq	Numeric 6	AC42.1
SBP-PO-NUMBER Element: Po 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-RELEASE Element: Po Release	Numeric 4 The purchase order release number associated with the invoice.	AC42.1
SBP-PO-CODE Element: Po Code	Alpha 4 Purchase order number code. Used to keep purchase orders unique. Can be used for reporting purposes.	AC42.1

ACSUBPAY FILE INDEX

ACSUBPAY FILE RELATIONS

ONE TO ONE RELATIONS

ACSUBPAY FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.