ACSUBPAY

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SBPSET1 COMPANY
VENDOR
INVOICE
SUFFIX
AC42.1


ACSUBPAY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
SBP-COMPANY->CPY-COMPANY
Approclev APPROCLEV Required
SBP-COMPANY->APR-COMPANY
SBP-PROC-LEVEL->APR-PROC-LEVEL
Apvenmast APVENMAST Required
SBP-VENDOR-GROUP->VEN-VENDOR-GROUP
SBP-VENDOR->VEN-VENDOR


ACSUBPAY FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apinvoice APINVOICE
SBP-COMPANY->API-COMPANY
SBP-VENDOR->API-VENDOR
SBP-INVOICE->API-INVOICE
SBP-SUFFIX->API-SUFFIX
  API-CANCEL-SEQ


File created: Thu Jun 09 11:04:14 2016

Home
Contact Us



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