|
Accounts Payable transaction Import tables |
  
|
|
Accounts Payable transaction Import tables |
|
Fields marked * may NOT be left blank. All other fields may be left blank.
Both import tables use the common ApImportID field to relate the master and detail records of transactions. Each transaction being imported must have a unique ApImportID.
ApImport table
Common information for a transaction. Each transaction has one record in this table.
ApImportID*
This field relates a master record to the detail records for a transaction.
SupplierID*
Specifies the Supplier.
ApType*
A valid ApType is one that is tagged for Importing in the ApType table.
ApTransDate*
This must be a date that is open for Accounts Payable transaction entry and importing.
Reference
This field may be any value.
ApAmount*
This field may be zero or any positive amount. It may not be negative. The system will determine whether the amount is a Debit or Credit based on the ApType.
Notes
This field may be any value.
OriginUserID
This field may be any UserID value. When specified the Origin UserID of the posted transaction will be the specified value. When blank the Origin UserID of the posted transaction will be the UserID of the User running the Import task.
OriginTaskID
This field may be any TaskID value. When specified the Origin TaskID of the posted transaction will be the specified value. When blank the Origin TaskID of the posted transaction will be the TaskID of the Import task.
OriginTransID
This field may be any TransID value. When specified the Origin TransID of the posted transaction will be the specified value. When blank the Origin TransID of the posted transaction will be the ApImportID.
OriginBatchID
This field may be any BatchID value. When specified the Origin BatchID of the posted transaction will be the specified value. When blank the Origin BatchID of the posted transaction will also be blank.
ErrorID
This field is reserved for the Import task. Do not insert any value into this field. Any value in this field will be ignored and written over.
ApImportDetail table
Transaction details. Each transaction has one or more records in this table.
ApImportID*
This field relates each detail record to the corresponding master record for that transaction.
AccountID*
Specifies the Account.
When strict Accounts Payable entry/import enforcement is checked on the Entry Control tabsheet of the Company maintenance task then the Account must be tagged as being eligible for Accounts Payable entry.
JobID
When Job Costing is installed this field is available to specify a JobID when applicable.
CostID
When Job Costing is installed this field is available to specify a CostID when applicable.
Amount*
This field specifies the Amount being distributed to the AccountID.
Debit amounts are positive and Credit amounts are negative.
The sum of all the Debits and Credits for the transaction must net out to zero. That is, the Debit or Credit represented by the Amount in the ApImport record together with the total Debit or Credit sum of the Amount(s) in the related ApImportDetail records for a transaction must net out to zero.
For example, if an ApImport record has an ApType of Invoice and an Amount of 125.00 then the total of the Amount fields in the related ApImportDetail records must be 125.00 in order for the transaction to be in balance. That is, the Credit of 125.00 in the ApImport record must be offset by Debits in ApImportDetail totaling 125.00.
ErrorID
This field is reserved for the Import task. Do not insert any value into this field. Any value in this field will be ignored and written over.