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 The company number represents an AP190 AP28.1
established company and is entered on AP28.2 AP45.1
all function codes. APDS.1
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 Number AP190 AP28.1
AP28.2 AP45.1
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
Element: Date AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-TRAN-DISC-AMT Signed 15.2 AP180 AP181
Element: Actual Disc The discount amount in the currency of AP190 AP28.1
the transaction. AP28.2 AP45.1
APDS.1
DSK-BASE-DISC-AMT Signed 15.2 AP180 AP181
Element: Actual Disc 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
MA70.1 MA75.1
1 = Open
2 = Posted
DSK-GLT-OBJ-ID Numeric 12 AP176 AP180
Object AP181 AP190
Identification AP28.1 AP28.2
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
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
|