 |
Lawson Insight Technical Documentation |
|
APDISTRIB FILE
Invoice Distribution Header
The Invoice Distribution Header file contains invoice distribution records.
The presence of a tax code identifies the record as a tax distribution.
Distribution records that have an asset number or asset template assigned will
also have an associated record in the Asset Detail file.
REFERENCED BY
AP220 AP260 AP282 AP95.1 AP95.2 AP95.3
AP275
UPDATED BY
AP115 AP170 AP175 AP180 AP181 AP190
AP191 AP193 AP195 AP198 AP28.1 AP28.2
AP30.1 AP30.2 AP30.4 AP300 AP305 AP32.2
AP32.1 AP45.1 AP520 API1.1 API2.1 EE135
EE35.1 EE35.2 EE520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APD-COMPANY Numeric 4 AP170 AP180
Company The company number. Must be a valid AP181 AP190
record in the Accounts Payable Company AP191 AP260
file. AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APD-API-OBJ-ID Numeric 12 AP170 AP180
API Object ID A unique identifier assigned to this AP181 AP190
file record. AP191 AP193
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APD-VENDOR Alpha 9 (Right Justified) AP115 AP170
Vendor ID The vendor number. Must be a valid AP180 AP181
record in the Vendor file. AP190 AP191
AP260 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-INVOICE Alpha 22 AP115 AP170
Invoice Number The invoice number. Represents a unique AP180 AP181
identifier for the invoice. Must be a AP190 AP191
valid record in the Accounts Payable AP260 AP28.1
Invoice file. AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-SUFFIX Numeric 3 AP170 AP180
Invoice Suffix The invoice suffix number. Represents AP181 AP190
the occurrence value of the invoice. The AP191 AP193
suffix is assigned by the system to AP260 AP28.1
recurring invoices, employee advances, AP28.2 AP30.2
and prepayment credit memos. AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
APD-CANCEL-SEQ Numeric 4 AP170 AP180
Cancel Sequence The sequence number assigned upon the AP181 AP190
cancellation of a distributed invoice. AP191 AP260
The first sequence assigned is 9999. AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1
APD-DIST-SEQ-NBR Numeric 4 AP170 AP180
Distribution A unique sequence number assigned to AP181 AP190
Sequence Number the distribution record. AP191 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-DIST-TYPE Alpha 1 AP170 AP180
Distribution Type The distribution type. Valid values are: AP181 AP190
AP191 AP28.1
D = Distribution. AP28.2 AP30.2
I = Intercompany Distribution. (Not AP30.4 AP32.2
used for distributions that originate in AP45.1 AP520
the Accounts Payable system.) API1.1 API2.1
G = Gain/Loss Distribution. EE135 EE35.1
R = Tax/Reversal Distribution. EE35.2 EE520
APD-PROC-LEVEL Alpha 5 AP170 AP180
Process Level The process level associated with the AP181 AP190
distribution. Must be a valid record in AP191 AP28.1
the Accounts Payable Process Level file. AP28.2 AP30.1
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APD-POST-OPTION Alpha 1 AP170 AP180
Posting Option The general ledger posting option AP181 AP190
associated with the distribution record. AP191 AP28.1
Valid values are: AP28.2 AP30.2
AP30.4 AP32.2
D = Detail. AP45.1 AP520
S = Summary. API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-INVOICE-TYPE Alpha 1 AP170 AP180
Invoice Type The type of invoice associated with the AP181 AP190
distribution. Valid values are: AP191 AP28.1
AP28.2 AP30.2
Blank = Invoice. AP30.4 AP32.2
C = Credit Memo. AP45.1 AP520
D = Debit Memo. API1.1 API2.1
P = Prepayment. EE135 EE35.1
Y = Prepayment Credit Memo. EE35.2 EE520
A = Employee Advance.
M = Employee Advance Credit Memo.
E = Employee Expense.
APD-REC-STATUS Numeric 1 AP170 AP175
Record Status The distribution record status. Valid AP180 AP181
values are: AP190 AP191
AP193 AP28.1
0 = Unreleased. AP28.2 AP30.2
1 = Unposted (released). AP30.4 AP32.2
9 = Posted by AP175. AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-INV-CURRENCY Alpha 5 AP170 AP180
Invoice Currency The currency of the invoice. Must be a AP181 AP190
valid record in the Currency Code file. AP191 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-TAX-RATE Percent 7.5 (Percent) AP170 AP180
Tax Rate The tax rate applied to the invoice. AP181 AP190
AP191 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-CURR-RATE Signed 13.6 AP170 AP180
Currency Exchange The currency exchange rate applied to AP181 AP190
Rate the invoice. AP191 AP193
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APD-ORIG-BASE-AMT Signed 15.2 AP170 AP180
Base Distribution The amount of the distribution in AP181 AP190
Amount company base currency. AP193 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-BASE-ND Numeric 1 AP170 AP180
Base Currency Nbr The number of decimals positions AP181 AP190
of Decimals defined for the company base currency. AP191 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-ORIG-TRAN-AMT Signed 15.2 AP170 AP180
Distribution Amount The amount of the distribution in the AP181 AP190
currency of the invoice. AP191 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-TRAN-ND Numeric 1 AP170 AP180
Trans Curr Nbr of The number of decimals defined for the AP181 AP190
Decimals invoice currency. AP191 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-TO-BASE-AMT Signed 15.2 AP170 AP180
Distribution The amount of the distribution in the AP181 AP190
Company Base Amt distribution company's base currency. AP191 AP193
AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APD-TO-BASE-ND Numeric 1 AP170 AP180
Dist Company Nbr of The number of decimal positions defined AP181 AP190
Decimals for the distribution company's currency. AP191 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-TAXABLE-AMT Signed 15.2 AP170 AP180
Taxable Amount The taxable amount of the distribution. AP181 AP190
AP191 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-UNT-AMOUNT Signed 15.2 AP180 AP181
Unit Amount The total unit amount allocated to the AP190 AP191
expense distribution. AP28.1 AP28.2
AP30.2 AP30.4
AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APD-DIST-COMPANY Numeric 4 AP170 AP180
Distribution Company The distribution company assigned to AP181 AP190
the distribution. Must be a valid record AP191 AP28.1
in the General Ledger Company file and a AP28.2 AP30.2
valid relationship record must exist in AP30.4 AP32.2
the Intercompany Relationship file. AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-DIS-ACCT-UNIT Alpha 15 AP170 AP180
Accounting Unit The general ledger distribution AP181 AP190
accounting unit. Must be a valid record AP191 AP28.1
in the General Ledger Names file. AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-DIS-ACCOUNT Numeric 6 AP170 AP180
Account Number The general ledger distribution account AP181 AP190
number. Must be a valid record in the AP191 AP28.1
General Ledger Account Master file. AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-DIS-SUB-ACCT Numeric 4 AP170 AP180
Subaccount Number The general ledger distribution AP181 AP190
subaccount number. Must be a valid AP191 AP28.1
record in the General Ledger Account AP28.2 AP30.2
Master file. AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-DISTRIB-DATE Numeric 8 (yyyymmdd) AP170 AP180
Post Date The date used for posting the AP181 AP190
distribution to the general ledger. AP191 AP193
AP195 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-TAX-CODE Alpha 10 AP170 AP180
Tax Code The tax code assigned to the AP181 AP190
distribution. Represents tax AP191 AP28.1
information. If present, identifies the AP28.2 AP30.2
distribution as a tax distribution. Must AP30.4 AP32.2
be a valid tax code in the Lawson Tax AP45.1 AP520
system. API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-TAX-TYPE Alpha 1 AP170 AP180
Tax Type Indicates the type of tax defined for AP181 AP190
the Tax Code. Valid values are: AP191 AP28.1
AP28.2 AP30.2
I = Invoiced. Default value. The tax AP30.4 AP32.2
represents an increase to the invoice AP45.1 AP520
amount. API1.1 API2.1
EE135 EE35.1
A = Accrued. The tax does not increase EE35.2 EE520
the invoice amount.
APD-DESCRIPTION Alpha 30 (Lower Case) AP170 AP180
Description The distribution description. AP181 AP190
AP191 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-DST-REFERENCE Alpha 10 AP170 AP180
Reference The distribution reference. AP181 AP190
AP191 AP28.1
AP28.2 AP30.2
AP30.4 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-ACTIVITY Alpha 15 AP170 AP180
Activity The activity assigned to the AP181 AP190
distribution, if applicable. Used to AP191 AP28.1
group expense distribution amounts to AP28.2 AP30.2
track costs for projects, jobs, AP30.4 AP32.2
construction, and so on, without having AP45.1 AP520
to define additional general ledger API1.1 API2.1
account numbers. Must be a valid EE135 EE35.1
activity in the Lawson Activity EE35.2 EE520
Management system.
APD-ACCT-CATEGORY Alpha 5 AP180 AP181
Account Category The account category assigned to the AP190 AP28.1
distribution, if applicable. Used to AP28.2 AP30.2
group distributions under an activity. AP32.2 AP45.1
Must be a valid account category for the AP520 API1.1
activity in the Lawson Activity API2.1 EE135
Management system. EE35.1 EE35.2
EE520
APD-ACCR-CODE Alpha 4 AP170 AP180
Invoice Accrual Code The invoice accrual code associated AP181 AP190
with the distribution. Represents a AP191 AP28.1
general ledger accrual account. Must be AP28.2 AP30.1
a valid record in the Invoice Accrual AP30.2 AP30.4
Code file. AP32.2 AP45.1
AP520 API1.1
API2.1 EE135
EE35.1 EE35.2
EE520
APD-PO-NUMBER Alpha 14 (Right Justified) AP170 AP180
PO Number This field contains the number AP181 AP190
representing the purchase order. AP191 AP28.1
AP28.2 AP30.4
AP45.1 API1.1
API2.1
APD-PO-RELEASE Numeric 4 AP170 AP180
PO Release Number The purchase order release number AP181 AP190
associated with the distribution. Used AP191 AP28.1
to identify a purchase order release AP28.2 AP30.4
(created from a blanket or standing AP45.1 API1.1
order). API2.1
APD-PO-CODE Alpha 4 AP170 AP180
Purchase Order Code Purchase order number code. Used to AP181 AP190
keep purchase orders unique. Can also be AP28.1 AP28.2
used for reporting purposes. AP30.4 AP45.1
API1.1 API2.1
APD-PO-LINE-NBR Numeric 6 AP170 AP180
PO Line Number The purchase order line number AP181 AP190
associated with the distribution. AP191 AP28.1
AP28.2 AP30.4
AP45.1 API1.1
API2.1
APD-PO-AOC-CODE Alpha 2 AP180 AP181
Purchase Order Add Indicates whether this distribution AP190 AP28.1
On Cost record represents an add-on cost for a AP28.2 AP30.4
purchase order. Valid values are: AP45.1 AP520
API1.1 API2.1
Y = Yes.
N = No.
APD-GLT-OBJ-ID Numeric 12 AP175 AP180
GL Interface Object This is a subsystem GL interface AP181 AP190
ID identification number. It is used for AP193 AP28.1
Drill Around purposes. AP28.2 AP45.1
API1.1 API2.1
APD-ATN-OBJ-ID Numeric 12 AP170 AP175
Activity Interface A subsystem activity interface AP180 AP181
Object ID identification number. Used for Drill AP190 AP193
Around purposes. AP28.1 AP28.2
AP30.2 AP32.2
AP45.1 AP520
API1.1 API2.1
EE135 EE35.1
EE35.2 EE520
APD-ASSET-FLAG Alpha 1 AP170 AP180
Asset Exists Indicates whether an asset or asset AP181 AP190
repair record exists for the AP191 AP28.1
distribution. Valid values are: AP28.2 AP30.2
AP45.1 AP520
A = Asset. API1.1 API2.1
R = Repair Asset.
Blank = No asset information is defined
for the distribution.
APD-DIST-CODE Alpha 9 AP180 AP181
Distribution Code The distribution code assigned to the AP190 AP28.1
distribution. Used to split an expense AP28.2 AP45.1
distribution into multiple distribution API1.1 API2.1
lines. Must be a valid record in the
Distribution Code Header file.
APD-TAX-POINT Alpha 1 AP180 AP181
Tax Point Indicates when the tax amount is AP190 AP28.1
calculated for the invoice distribution, AP28.2 AP30.2
if applicable. Valid values are: AP32.2 AP45.1
AP520 API1.1
I = Invoice. API2.1
P = Payment.
APD-VAT-REVERSE-FL Alpha 1 AP180 AP181
VAT Reversal Used in AP190 (Invoice Reinstatement) AP190 AP28.1
to create reversing tax due general AP28.2 AP45.1
ledger records. This field is No if API1.1 API2.1
reversing tax transactions have not been
sent to the general ledger. When the
transactions are sent to the general
ledger, this field changes to Yes. Valid
values are:
N = No.
Y = Yes.
APD-DST-OBJ-ID Numeric 12 AP180 AP181
Distribution Object An object identifier to keep the record AP190 AP28.1
ID unique. AP28.2 AP30.4
AP45.1
APD-MA-CREATE-FL Alpha 1 AP180 AP181
Matching Creation Indicates the distribution was AP190 AP28.1
Flag generated during matching, as opposed to AP28.2 AP45.1
entered manually during invoicing. API1.1 API2.1
Also used during the match reversal
process to determine whether the
distribution should be deleted (match
distribution) or left untouched
(miscellaneous distribution).
APD-TAX-USAGE-CD Alpha 10 AP180 AP181
Tax Usage Cd The tax usage coe for the vendor. This AP190 AP28.1
filed is required if the AP Company AP28.2 AP30.2
inidcates that VAT reporting required. AP45.1 AP520
API1.1 API2.1
APD-TRAN-DIST-FLAG Alpha 1 AP30.2
Tran Dist Flag
APD-DIST-STATUS Derived
Distribution Status Indicates whether the distribution is
posted or unposted.
APDISTRIB FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APDSET1 API-OBJ-ID This index is used to access and create AP115 AP170
DIST-SEQ-NBR unique invoice distribution records. AP175 AP180
AP181 AP190
AP193 AP195
AP198 AP220
AP260 AP282
AP30.1 AP30.2
AP30.4 AP300
AP305 AP32.1
AP32.2 AP520
AP95.1 API1.1
API2.1
APDSET2 COMPANY This index is used to access invoice AP175 AP195
REC-STATUS distribution records used to create
PROC-LEVEL general ledger distribution and
DIS-ACCT-UNIT gain/loss transactions.
DIS-ACCOUNT KeyChange
DIS-SUB-ACCT
DISTRIB-DATE
API-OBJ-ID
DIST-SEQ-NBR
APDSET3 DIST-COMPANY This index is used to access invoice AP95.2 AP95.3
ACTIVITY distribution records associated with a
ACCT-CATEGORY specific project.
DISTRIB-DATE KeyChange
API-OBJ-ID
DIST-SEQ-NBR
APDSET4 DIST-COMPANY This index is used to access invoice AP275 AP95.2
DIS-ACCT-UNIT distribution records by the general AP95.3
DIS-ACCOUNT ledger account number the distributions
DIS-SUB-ACCT are being posted to.
DISTRIB-DATE KeyChange
API-OBJ-ID
DIST-SEQ-NBR
APDSET5 GLT-OBJ-ID This index is used to access invoice
API-OBJ-ID distribution records that need to
DIST-SEQ-NBR revalued by AP191 (Unrealized
Gain/Loss).
KeyChange, Subset
Where GLT-OBJ-ID != Zeroes
APDSET6 DST-OBJ-ID This index is used to access
distribution records that are linked to
a recurring journal entry in the Lawson
General Ledger System.
KeyChange, Subset
Where DST-OBJ-ID != Zeroes
APDSET8 COMPANY This index is used to access invoice
PO-NUMBER distribution records associated with a
PO-RELEASE specific purchase order's line item.
PO-CODE KeyChange, Subset
PO-LINE-NBR Where PO-NUMBER != Spaces
PO-AOC-CODE
API-OBJ-ID
DIST-SEQ-NBR
APDSET9 ATN-OBJ-ID This index is used to show the
COMPANY committed cost in Accounts Payable for
VENDOR the Projects system.
INVOICE KeyChange, Subset
SUFFIX Where ATN-OBJ-ID != Zeroes
CANCEL-SEQ
DIST-SEQ-NBR
APDISTRIB FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Actrans ACTRANS Not Required
APD-ATN-OBJ-ID -> ATN-OBJ-ID (ATNSET12)
Apcompany APCOMPANY Required
APD-COMPANY -> CPY-COMPANY
Apdistcompany GLSYSTEM Required
APD-DIST-COMPANY -> GLS-COMPANY
Apinvoice APINVOICE Required
APD-COMPANY -> API-COMPANY
APD-VENDOR -> API-VENDOR
APD-INVOICE -> API-INVOICE
APD-SUFFIX -> API-SUFFIX
APD-CANCEL-SEQ -> API-CANCEL-SEQ
Approclev APPROCLEV Required
APD-COMPANY -> APR-COMPANY
APD-PROC-LEVEL -> APR-PROC-LEVEL
Apuaval APUAVAL Not Required
"D" -> UAV-SEG-TYPE
APD-API-OBJ-ID -> UAV-API-OBJ-ID
APD-DIST-SEQ-NBR -> UAV-DIST-SEQ-NBR
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
APD-VENDOR -> VEN-VENDOR
Asset APASTDTL Not Required
APD-API-OBJ-ID -> APS-API-OBJ-ID
APD-DIST-SEQ-NBR -> APS-DIST-SEQ-NBR
Distribproc APPROCLEV Required
APD-COMPANY -> APR-COMPANY
APD-PROC-LEVEL -> APR-PROC-LEVEL
Dstusrfld APDSUSRFLD Not Required
APD-API-OBJ-ID -> DFL-API-OBJ-ID
APD-DIST-SEQ-NBR -> DFL-DIST-SEQ-NBR
Glmaster GLMASTER Required
APD-DIST-COMPANY -> GLM-COMPANY
APD-DIS-ACCT-UNIT -> GLM-ACCT-UNIT
APD-DIS-ACCOUNT -> GLM-ACCOUNT
APD-DIS-SUB-ACCT -> GLM-SUB-ACCOUNT
Glsystem Orig GLSYSTEM Required
APD-COMPANY -> GLS-COMPANY
Glsystem To GLSYSTEM Required
APD-DIST-COMPANY -> GLS-COMPANY
APDISTRIB FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sltrans SLTRANS
APD-GLT-OBJ-ID -> SLT-GLT-OBJ-ID
SLT-OBJ-ID
|