|
|
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 ID The vendor's identification code.
SBP-INVOICE Alpha 22 AC42.1
Element: Invoice NumberUsed to identify the invoice.
SBP-SUFFIX Numeric 3 AC42.1
Element: Invoice SuffixThis is the suffix for the invoice.
SBP-VOUCHER-NBR Alpha 10 AC42.1
Element: Voucher
SBP-AUTH-CODE Alpha 3 AC42.1
Element: Authority CodeA user-defined code representing a
person or department responsible for
approving a registered invoice.
SBP-PROC-LEVEL Alpha 5 AC42.1
Element: Process Level The process level represents a
reporting level 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
To Company Base
Currency
SBP-INVOICE-DTE Numeric 8 (yyyymmdd) AC42.1
Element: Invoice Date
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 Rate
SBP-DISC-DATE Numeric 8 (yyyymmdd) AC42.1
Element: Date
SBP-DUE-DATE Numeric 8 (yyyymmdd) AC42.1
Element: Due Date The transaction due date.
SBP-REMIT-TO-CODE Alpha 4 AC42.1
Remit To Location A user-defined code that represents a
Code vendor's remittance address.
SBP-REC-STATUS Numeric 1
Element: Record Status The record status.
SBP-CREATE-DATE Numeric 8 (yyyymmdd) AC42.1
Element: Creation Date The creation date.
SBP-DISTRIB-DATE Numeric 8 (yyyymmdd) AC42.1
Element: Date The date used for posting the
transactions to the general ledger.
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
SBP-APPRV-OPERATOR Alpha 10 AC42.1
Element: Operator Code
SBP-OBJ-ID Numeric 12 AC42.1
Object This is the object identifier. It is
Identification 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: Terms Code
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: Account CategoAccount 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 The company number used for posting the
transaction. A valid intercompany
relationship must be defined in the
Lawson General Ledger system.
SBP-DIS-ACCT-UNIT Alpha 15 AC42.1
Element: Accounting UniThe general ledger distribution
accounting unit. Select a valid
accounting unit if you want the
interface program to create general
ledger transactions for transaction with
a record status of '1' and '2' only. A
transaction will be created to this
account and an offset transaction to the
cash account will occur.
SBP-DIS-ACCOUNT Numeric 6 AC42.1
Element: Account Required if the distribution accounting
unit field is not blank. The general
ledger distribution account.
SBP-DIS-SUB-ACCT Numeric 4 AC42.1
Element: Subaccount The general ledger distribution
subaccount.
SBP-SEGMENT-BLOCK Alpha 103 AC42.1
Element: User Analysis 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
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 FThe anticipation flag.
SBP-CONTROL-GROUP Numeric 8 AC42.1
Element: Control GroupsThis field displays the journal entry
number used for process control of the
journal entry detail.
SBP-TRANS-TYPE Alpha 1 AC42.1
Element: Transaction TyDetermines 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 NumThe 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
|
