Interface to AP

APCheckExport

The following data elements can be used with the APCheckExport usage.

Data Element	Description
LiteralValue	Static value defined in the File Map.
Filler	Blank or reserved field used for spacing or formatting.
LineFeed	Inserts a line break in the export file.
CarrierID	Carrier identifier.
BillingDate	Billing date associated with the transaction.
AccOriginCode	Account origin code.
OperatingUnit	Operating unit identifier.
AccountID	Unique identifier for the account.
GPPubCode	Publication code used in Great Plains integration.
GPGLAcctNum	General ledger account number used in Great Plains.
GLDepartment	General ledger department identifier.
InvoiceDate	Date of the invoice.
DirectDepIndicator	Indicates whether the payment is processed as direct deposit.
Project	Project identifier associated with the transaction.
InvoiceAmount	Total invoice amount.
GLCompanyID	General ledger company identifier.
TotalRecCount	Total number of records in the export.
TermsCode	Payment terms code.
FiscalPeriod	Fiscal period associated with the transaction.
TotalCredBalAmt	Total credit balance amount.
DueDate	Payment due date.
RecordCount	Number of records in the current batch or section.
InvoiceCounter	Counter used to track invoice records.
LiabilityAccount	Liability account used for accounting entries.
FileNum	File sequence or identifier number.
FirstName	First name of the account holder or vendor.
ClearingAccount	Clearing account used for AP transactions.
FileType	Type of export file being generated.
LastName	Last name of the account holder or vendor.
AddressLine1	First line of the address.
RowCount	Number of rows processed or included.
OccupantSalutationID	Salutation identifier for the occupant.
AddressLine2	Second line of the address.
TotalAmount	Total monetary amount in the export.
HonorificID	Honorific identifier (for example, Mr, Ms).
AddressLine3	Third line of the address.
LwsnDepartment	Lawson department identifier.
MiddleInitial	Middle initial of the name.
AddressLine4	Fourth line of the address.
GLAccount	General ledger account number.
ZipExtension	ZIP/postal extension.
AddressLine5	Fifth line of the address.
OriginalAmt	Original transaction amount before adjustments.
PSVendorPrefix	Vendor prefix used in PeopleSoft integration.
AddressLine6	Sixth line of the address.
ProductID	Product identifier.
Phone	Primary phone number.
CityID	City identifier.
Description	Description associated with the transaction or record.
AreaCode	Area code of the phone number.
StateID	State identifier.
TaxID	Tax identification number.
PhoneExtension	Extension number for the phone.
ZipCode	ZIP/postal code.
LawsonAPCompany	Lawson Accounts Payable company identifier.
FiscalYear	Fiscal year associated with the transaction.
VendorCompanyID	Vendor company identifier.
LawsonAuthCode	Lawson authorisation code.
SSN	Social Security Number.
VendorID	Vendor identifier.
IncomeCode	Income classification code.
CreditBalanceAmount	Credit balance amount for the account.
BusinessUnit	Business unit identifier.

---

APVendorExport

The following data elements can be used with the APVendorExport usage.

Data Element	Description
LiteralValue	Static value defined in the File Map.
Filler	Blank or reserved field used for spacing or formatting.
LineFeed	Inserts a line break in the export file.
VendorCompanyID	Vendor company identifier.
VendorID	Vendor identifier.
LastName	Last name of the vendor or account holder.
FirstName	First name of the vendor or account holder.
CarrierID	Carrier identifier.
AreaCode	Area code of the phone number.
Phone	Primary phone number.
AddressLine1	First line of the address.
AddressLine2	Second line of the address.
AddressLine3	Third line of the address.
AddressLine4	Fourth line of the address.
AddressLine5	Fifth line of the address.
AddressLine6	Sixth line of the address.
PayMethod	Payment method for the vendor.
BankNumber	Bank routing or identification number.
TaxID	Tax identification number.
TaxType	Type of tax identifier.
OccupantEmail	Email address of the occupant.
CityID	City identifier.
StateID	State identifier.
ZipCode	ZIP/postal code.
BillingDate	Billing date associated with the record.
SSN	Social Security Number.
PSVendorPrefix	Vendor prefix used in PeopleSoft integration.
MiddleInitial	Middle initial of the name.
HonorificID	Honorific identifier (for example, Mr, Ms).
OccupantSalutationID	Salutation identifier for the occupant.
PhoneExtension	Extension number for the phone.
ZipExtension	ZIP/postal extension.
BankAccountNumber	Bank account number.
BankAccountType	Type of bank account (for example, checking or savings).
TotalRecCount	Total number of records in the export.
TotalCredBalAmt	Total credit balance amount.

---

APTotExport

The following data elements can be used with the APTotExport usage.

Data Element	Description
TodayDate	Current system date at the time of export.
TotalCredBalAmt	Total credit balance amount included in the export.
TotalRecCount	Total number of records included in the export.
LiteralValue	Static value defined in the File Map.
Filler	Blank or reserved field used for spacing or formatting.
LineFeed	Inserts a line break in the export file.