|
|
ACSUBPAY FILE
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 Numeric 4 AC42.1
Element: Company 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.
SBP-VENDOR Alpha 9 (Right Justified) AC42.1
Element: Vendor The vendor's identification code.
SBP-INVOICE Alpha 22 AC42.1
Element: Invoice Used to identify the invoice.
SBP-SUFFIX Numeric 3 AC42.1
Element: Suffix This is the suffix for the invoice.
SBP-VOUCHER-NBR Alpha 10 AC42.1
Element: Voucher Nbr
SBP-AUTH-CODE Alpha 3 AC42.1
Element: Auth Code A user-defined code representing a
person or department responsible for
approving a registered invoice.
SBP-PROC-LEVEL Alpha 5 AC42.1
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
SBP-INVOICE-TYPE Alpha 1 AC42.1
Element: Invoice Type 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.
SBP-INV-CURRENCY Alpha 5 AC42.1
Element: To Base Curr
SBP-INVOICE-DTE Numeric 8 (yyyymmdd) AC42.1
Element: Invoice Dte
SBP-DESCRIPTION Alpha 30 (Lower Case) AC42.1
Element: Description This field displays the description.
SBP-BASE-INV-AMT Signed 18.2 AC42.1
Element: Intl Amt
SBP-DISCOUNT-RT Percent 5.3 (Percent) AC42.1
Element: Discount Rt
SBP-DISC-DATE Numeric 8 (yyyymmdd) AC42.1
Element: Date This field displays the system date
when this was created.
SBP-DUE-DATE Numeric 8 (yyyymmdd) AC42.1
Element: Due Date The transaction due date.
SBP-REMIT-TO-CODE Alpha 4 AC42.1
Element: Remit To Code A user-defined code that represents a
vendor's remittance address.
SBP-REC-STATUS Numeric 1
Element: Rec Status The record status.
SBP-CREATE-DATE Numeric 8 (yyyymmdd) AC42.1
Element: Create Date The creation date.
SBP-DISTRIB-DATE Numeric 8 (yyyymmdd) AC42.1
Element: Date This field displays the system date
when this was created.
SBP-CREATION-TIME Numeric 6 (hhmmss) AC42.1
Element: Creation Time The creation time.
SBP-VENDOR-GROUP Alpha 4 AC42.1
Element: Vendor Group A vendor group represents a group of
vendors that can be shared by one or
more companies.
SBP-DISCOUNT-CODE Alpha 10 AC42.1
Element: Discount Code A user-defined code that represents a
general ledger discount account.
SBP-APPROVED-FLAG Alpha 1 AC42.1
Element: Approved Flag
SBP-APPRV-OPERATOR Alpha 10 AC42.1
Element: Operator This field is used to store the login
id of the person who entered the record.
SBP-OBJ-ID Numeric 12 AC42.1
Element: Obj Id 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.
SBP-TERMS-CD Alpha 5 AC42.1
Element: Term Code A user-defined code representing a
method of determining invoice due and
discount dates.
SBP-REASON-CODE Alpha 4 AC42.1
Element: Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
SBP-HANDLING-CODE Alpha 4 AC42.1
Element: Handling Code
SBP-ACTIVITY Alpha 15 AC42.1
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
SBP-ACCT-CATEGORY Alpha 5 AC42.1
Element: Acct Category 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
SBP-DIST-COMPANY Numeric 4 AC42.1
Element: Company 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.
SBP-DIS-ACCT-UNIT Alpha 15 AC42.1
Element: Acct Unit 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.
SBP-DIS-ACCOUNT Numeric 6 AC42.1
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
SBP-DIS-SUB-ACCT Numeric 4 AC42.1
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
SBP-SEGMENT-BLOCK Alpha 103 AC42.1
Element: Segment Block 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.
SBP-RCPT-INV-DATE Numeric 8 (yyyymmdd) AC42.1
Element: Date This field displays the system date
when this was created.
SBP-TRAN-DISC-AMT Signed 18.2 AC42.1
Element: Intl Amt
SBP-TRAN-ALOW-AMT Signed 18.2 AC42.1
Element: Intl Amt
SBP-ANTICIPATION Alpha 1 AC42.1
Element: Anticipation The anticipation flag.
SBP-CONTROL-GROUP Numeric 8 AC42.1
Element: Control Group This field displays the journal entry
number used for process control of the
journal entry detail.
SBP-TRANS-TYPE Alpha 1 AC42.1
Element: Trans Type Determines if amounts or units are
processed in each transaction.
SBP-LAST-REC-SEQ Numeric 6 AC42.1
Element: Last Rec Seq
SBP-PO-NUMBER Alpha 14 (Right Justified) AC42.1
Element: Po Number PO Number that will be passed to the AP
system. It will not be edited against
data in the PO system.
SBP-PO-RELEASE Numeric 4 AC42.1
Element: Po Release The purchase order release number
associated with the invoice.
SBP-PO-CODE Alpha 4 AC42.1
Element: Po Code Purchase order number code. Used to
keep purchase orders unique. Can be
used for reporting purposes.
ACSUBPAY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SBPSET1 COMPANY AC42.1
VENDOR
INVOICE
SUFFIX
ACSUBPAY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
