Lawson Insight Technical Documentation |
|
APDISCACC
APDISCACC FILE
Discount
The Accounts Payable Discount
REFERENCED BY
AP260 AP195 MA01.1
UPDATED BY
AP176 AP177 AP180 AP181 AP190 AP198
AP28.1 AP28.2 AP300 AP45.1 APDS.1 MA70.1
MA75.1 AP305
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DSK-COMPANY Numeric 4 AP180 AP181
Element: Company Identifies the AP company if the AP190 AP28.1
resource type = V. Identifies the HR AP28.2 AP45.1
company if the resource type = E. It is APDS.1
blank for type A, P or Q resources.
DSK-VENDOR Alpha 9 (Right Justified) AP180 AP181
Element: Vendor ID The vendor's identification code. AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-INVOICE Alpha 22 AP180 AP181
Element: Invoice NumberInvoice number. AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-SUFFIX Numeric 3 AP180 AP181
Element: Invoice SuffixThe invoice suffix. AP190 AP28.1
AP28.2 AP45.1
APDS.1 MA70.1
MA75.1
DSK-CANCEL-SEQ Numeric 4 AP180 AP181
Element: Sequence NumbeThe sequence number assigned upon a AP190 AP28.1
cancellation of a distributed invoice. AP28.2 AP45.1
The first sequence assigned is 9999. APDS.1
DSK-SEQ-NBR Numeric 4 AP180 AP181
Element: Sequence NumbeAn automatically assigned sequence AP190 AP28.1
number. AP28.2 AP45.1
APDS.1
DSK-VOID-SEQ Numeric 4 AP180 AP181
Element: Sequence NumbeThe sequence number assigned to voided AP190 AP28.1
payments. AP28.2 AP45.1
APDS.1
DSK-POST-DATE Numeric 8 (yyyymmdd) AP180 AP181
General Ledger The date general ledger entries for the AP190 AP28.1
Posting Date transaction will be posted to the AP28.2 AP45.1
general ledger. APDS.1
DSK-TRAN-DISC-AMT Signed 18.2 AP180 AP181
Element: Intl Amt The discount amount in the currency of AP190 AP28.1
the transaction. AP28.2 AP45.1
APDS.1
DSK-BASE-DISC-AMT Signed 18.2 AP180 AP181
Element: Intl Amt The discount amount in company base AP190 AP28.1
currency. AP28.2 AP45.1
APDS.1
DSK-PROCESS-LEVEL Alpha 5 AP180 AP181
Element: Process Level This field contains the process level, AP190 AP28.1
which is the reporting hierarchy below AP28.2 AP45.1
company. APDS.1
DSK-DISC-TYPE Alpha 1 AP180 AP181
Element: Discount Type Indicates the discount type. AP190 AP28.1
AP28.2 AP45.1
Valid values are: APDS.1
M = Match
R = Reverse
DSK-STATUS Numeric 1 AP176 AP180
Element: Status The transaction status. AP181 AP190
AP28.1 AP28.2
Valid values are: AP45.1 APDS.1
1 = Open
2 = Posted
DSK-GLT-OBJ-ID Numeric 12 AP176 AP180
Object This is a subsystem GL interface AP181 AP190
Identification identification number. It is used for AP28.1 AP28.2
Drill Around purposes. AP45.1 APDS.1
DSK-JRNL-BOOK-NBR Alpha 12 AP180 AP181
Element: Journal Book The journal book assigned to the AP190 AP28.1
transaction. AP28.2 AP45.1
DSK-API-OBJ-ID Numeric 12
Object
Identification
DSK-TRAN-BASE-ND Numeric 1
Account Currency
Code
DSK-PROC-LEVEL Alpha 5
Element: Process Level The process level represents a
reporting level below company.
DSK-PULL-FOR-FR-FL Alpha 1 AP176 AP177
Element: Pull For Fr Fl
APDISCACC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DSKSET1 COMPANY AP176 AP190
VENDOR AP198 AP260
INVOICE AP300 AP305
SUFFIX APDS.1 MA70.1
CANCEL-SEQ MA75.1
SEQ-NBR
VOID-SEQ
DISC-TYPE
DSKSET2 STATUS KeyChange AP176 AP195
COMPANY MA01.1
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
DSKSET3 COMPANY Subset AP177
VENDOR Where (PULL-FOR-FR-FL = "Y" )
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
DISC-TYPE
APDISCACC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apinvoice APINVOICE Required
DSK-COMPANY -> API-COMPANY
DSK-VENDOR -> API-VENDOR
DSK-INVOICE -> API-INVOICE
DSK-SUFFIX -> API-SUFFIX
DSK-CANCEL-SEQ -> API-CANCEL-SEQ
Appayment APPAYMENT Not Required
DSK-COMPANY -> APP-COMPANY
DSK-VENDOR -> APP-VENDOR
DSK-INVOICE -> APP-INVOICE
DSK-SUFFIX -> APP-SUFFIX
DSK-CANCEL-SEQ -> APP-CANCEL-SEQ
DSK-SEQ-NBR -> APP-SEQ-NBR
DSK-VOID-SEQ -> APP-VOID-SEQ
|