Lawson Insight Technical Documentation |
|
APDISCACC
APDISCACC FILE
Discount
The Accounts Payable Discount
REFERENCED BY
AP136 MA01.1
UPDATED BY
AP176 AP177 AP180 AP181 AP190 AP195
AP28.1 AP28.2 AP300 AP45.1 APDS.1 MA70.1
MA75.1 AP198 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 The vendor's identification code. AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-INVOICE Alpha 22 AP180 AP181
Element: Invoice Invoice number. AP190 AP28.1
AP28.2 AP45.1
APDS.1
DSK-SUFFIX Numeric 3 AP180 AP181
Element: Suffix The invoice suffix. AP190 AP28.1
AP28.2 AP45.1
APDS.1 MA70.1
MA75.1
DSK-CANCEL-SEQ Numeric 4 AP180 AP181
Element: Seq Nbr An automatically assigned sequence AP190 AP28.1
number. AP28.2 AP45.1
APDS.1
DSK-SEQ-NBR Numeric 4 AP180 AP181
Element: Seq Nbr An automatically assigned sequence AP190 AP28.1
number. AP28.2 AP45.1
APDS.1
DSK-VOID-SEQ Numeric 4 AP180 AP181
Element: Seq Nbr The sequence number assigned to voided AP190 AP28.1
payments. AP28.2 AP45.1
APDS.1
DSK-POST-DATE Numeric 8 (yyyymmdd) AP180 AP181
Element: Post Date The date general ledger entries for the AP190 AP195
transaction will be posted to the AP28.1 AP28.2
general ledger. AP45.1 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
MA70.1 MA75.1
1 = Open
2 = Posted
DSK-GLT-OBJ-ID Numeric 12 AP176 AP180
Element: Obj Id This is the object identifier. It is AP181 AP190
used to relate commitments or posted AP28.1 AP28.2
transactions back to the originating AP45.1 APDS.1
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-JRNL-BOOK-NBR Alpha 12 AP180 AP181
Element: Jrnl Book Nbr The journal book assigned to the AP190 AP28.1
transaction. AP28.2 AP45.1
DSK-API-OBJ-ID Numeric 12
Element: Obj Id 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 Numeric 1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
DSK-PROC-LEVEL Alpha 5
Element: Process Level This field contains the process level,
which is the reporting hierarchy 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 AP136 AP176
VENDOR AP190 AP195
INVOICE AP198 AP300
SUFFIX AP305 APDS.1
CANCEL-SEQ MA70.1 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
|