APDISCACC

Discount

The Accounts Payable Discount

REFERENCED BY
MA01.1


UPDATED BY
AP115 AP136 AP176 AP177 AP180 AP181
AP190 AP195 AP198 AP28.1 AP28.2 AP300
AP305 AP45.1 APDS.1 MA70.1 MA75.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DSK-COMPANY
Element: Company
Numeric 4
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.
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AP115 AP180
AP181 AP190
AP28.1 AP28.2
AP45.1 APDS.1
DSK-INVOICE
Element: Invoice
Alpha 22
Invoice number.
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-SUFFIX
Element: Suffix
Numeric 3
The invoice suffix.
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
APDS.1 MA70.1
MA75.1
DSK-CANCEL-SEQ
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-VOID-SEQ
Element: Seq Nbr
Numeric 4
The sequence number assigned to voided payments.
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-POST-DATE
Element: Post Date
Numeric 8 (yyyymmdd)
The date general ledger entries for the transaction will be posted to the general ledger.
AP180 AP181
AP190 AP195
AP28.1 AP28.2
AP45.1 APDS.1
DSK-TRAN-DISC-AMT
Element: Intl Amt
Signed 18.2
The discount amount in the currency of the transaction.
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-BASE-DISC-AMT
Element: Intl Amt
Signed 18.2
The discount amount in company base currency.
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-DISC-TYPE
Element: Discount Type
Alpha 1
Indicates the discount type. Valid values are: M = Match R = Reverse
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-STATUS
Element: Status
Numeric 1
The transaction status. Valid values are: 1 = Open 2 = Posted
AP176 AP180
AP181 AP190
AP28.1 AP28.2
AP45.1 APDS.1
MA70.1 MA75.1
DSK-GLT-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is 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.
AP176 AP180
AP181 AP190
AP28.1 AP28.2
AP45.1 APDS.1
DSK-JRNL-BOOK-NBR
Element: Jrnl Book Nbr
Alpha 12
The journal book assigned to the transaction.
AP180 AP181
AP190 AP28.1
AP28.2 AP45.1
DSK-API-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is 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.
DSK-TRAN-BASE-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
DSK-PROC-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
DSK-PULL-FOR-FR-FL
Element: Pull For Fr Fl
Alpha 1
AP176 AP177


APDISCACC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DSKSET1 COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
DISC-TYPE
AP115 AP136
AP176 AP190
AP195 AP198
AP300 AP305
APDS.1 MA70.1
MA75.1
DSKSET2 STATUS
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
KeyChange
AP176 AP195
MA01.1
DSKSET3 COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
SEQ-NBR
VOID-SEQ
DISC-TYPE
Subset
Where(PULL-FOR-FR-FL ="Y")
AP177


APDISCACC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:07:20 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.