APDISCACC FILE
Discount
The Accounts Payable Discount
REFERENCED BY
AP260 AP195 MA01.1
UPDATED BY
AP176 AP180 AP181 AP190 AP198 AP28.1
AP28.2 AP300 AP45.1 APDS.1 AP305
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DSK-COMPANY Numeric 4 AP180 AP181
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
Vendor ID The vendor's identification code. AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-INVOICE Alpha 22 AP180 AP181
Invoice Number Invoice number. AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-SUFFIX Numeric 3 AP180 AP181
Invoice Suffix The invoice suffix. AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-CANCEL-SEQ Numeric 4 AP180 AP181
Cancel Sequence The 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
Sequence Number An automatically assigned sequence AP190 AP28.1
number. AP28.2 AP45.1
APDS.1
DSK-VOID-SEQ Numeric 4 AP180 AP181
Void Sequence The 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 15.2 AP180 AP181
Discount Amount 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
Base Discount Amount The discount amount in company base AP190 AP28.1
currency. AP28.2 AP45.1
APDS.1
DSK-PROCESS-LEVEL Alpha 5 AP180 AP181
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
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
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
Subsystem GL This is a subsystem GL interface AP181 AP190
Interface ID 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
Journal Book The journal book assigned to the AP190 AP28.1
transaction. AP28.2 AP45.1
APDISCACC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DSKSET1 COMPANY AP176 AP190
VENDOR AP198 AP260
INVOICE AP300 AP305
SUFFIX APDS.1
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
DISC-TYPE
DSKSET2 STATUS KeyChange AP176 AP195
COMPANY MA01.1
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
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
|