ACSUBPAY FILE
UPDATED BY
AC42.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SBP-COMPANY Numeric 4 AC42.1
Company The company number represents an
established company and is entered on
all function codes.
SBP-VENDOR Alpha 9 (Right Justified) AC42.1
Vendor ID The vendor's identification code.
SBP-INVOICE Alpha 22 AC42.1
Invoice Number Used to identify the invoice.
SBP-SUFFIX Numeric 3 AC42.1
Invoice Suffix This is the suffix for the invoice.
SBP-VOUCHER-NBR Alpha 10 AC42.1
Voucher
SBP-AUTH-CODE Alpha 3 AC42.1
Authority Code A user-defined code representing a
person or department responsible for
approving a registered invoice.
SBP-PROC-LEVEL Alpha 5 AC42.1
Process Level The process level represents a
reporting level below company.
SBP-INVOICE-TYPE Alpha 1 AC42.1
Invoice Type
SBP-INV-CURRENCY Alpha 5 AC42.1
Invoice Currency
SBP-INVOICE-DTE Numeric 8 (yyyymmdd) AC42.1
Invoice Date
SBP-DESCRIPTION Alpha 30 (Lower Case) AC42.1
Description This field displays the description.
SBP-BASE-INV-AMT Signed 15.2 AC42.1
Base Invoice Amount
SBP-DISCOUNT-RT Percent 5.3 (Percent) AC42.1
Discount Rate
SBP-DISC-DATE Numeric 8 (yyyymmdd) AC42.1
Discount Date
SBP-DUE-DATE Numeric 8 (yyyymmdd) AC42.1
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
Record Status The record status.
SBP-CREATE-DATE Numeric 8 (yyyymmdd) AC42.1
Creation Date The creation date.
SBP-DISTRIB-DATE Numeric 8 (yyyymmdd) AC42.1
Distribution Date The date used for posting the
transactions to the general ledger.
SBP-CREATION-TIME Numeric 6 (hhmmss) AC42.1
Creation Time The creation time.
SBP-VENDOR-GROUP Alpha 4 AC42.1
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
Discount Code A user-defined code that represents a
general ledger discount account.
SBP-APPROVED-FLAG Alpha 1 AC42.1
Approved
SBP-APPRV-OPERATOR Alpha 10 AC42.1
Approval Operator
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
Terms Code
SBP-REASON-CODE Alpha 4 AC42.1
Reason Code This field contains the reason code,
which indicates the cause for credit
memos.
SBP-HANDLING-CODE Alpha 4 AC42.1
Handling Code
SBP-ACTIVITY Alpha 15 AC42.1
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
Account 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.
SBP-DIST-COMPANY Numeric 4 AC42.1
Distribution 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
Accounting Unit The 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
Account Number Required if the distribution accounting
unit field is not blank. The general
ledger distribution account.
SBP-DIS-SUB-ACCT Numeric 4 AC42.1
Subaccount Number The general ledger distribution
subaccount.
SBP-SEGMENT-BLOCK Alpha 103 AC42.1
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
Rcpt Inv Date
SBP-TRAN-DISC-AMT Signed 15.2 AC42.1
Discount Amount
SBP-TRAN-ALOW-AMT Signed 15.2 AC42.1
Allowable Amount
SBP-ANTICIPATION Alpha 1 AC42.1
Anticipation Flag The anticipation flag.
SBP-CONTROL-GROUP Numeric 8 AC42.1
Control Groups This field displays the journal entry
number used for process control of the
journal entry detail.
SBP-TRANS-TYPE Alpha 1 AC42.1
Transaction Type Determines if amounts or units are
processed in each transaction.
SBP-LAST-REC-SEQ Numeric 6 AC42.1
Last Rec Seq
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
|
