|
Accounts Receivable transaction Import tables |
  
|
|
Accounts Receivable transaction Import tables |
|
Fields marked * may NOT be left blank. All other fields may be left blank.
Both import tables use the common ArImportID field to relate the master and detail records of transactions. Each transaction being imported must have a unique ArImportID.
ArImport table
Common information for a transaction. Each transaction has one record in this table.
ArImportID*
This field relates a master record to the detail records for a transaction.
ArType*
A valid ArType is one that is tagged for Importing in the ArType table.
CustomerID*
Specifies the Customer.
When strict Customer entry/import enforcement is checked on the Entry Control tabsheet of the Company maintenance task then the Customer must be tagged as Active.
ArTransDate*
This must be a date that is open for Accounts Receivable transaction entry and importing.
Reference
This field may be any value.
ArAmount*
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 ArType.
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 ArImportID.
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.
ArImportDetail table
Transaction details. Each transaction has one or more records in this table.
ArImportID*
This field relates each detail record to the corresponding master record for that transaction.
AccountID*
Specifies the Account.
JobID
When Job Costing is installed this field is available to specify a JobID 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 ArImport record together with the total Debit or Credit sum of the Amount(s) in the related ArImportDetail records for a transaction must net out to zero.
For example, if an ArImport record has an ArType of Invoice and an Amount of 217.00 then the total of the Amount fields in the related ArImportDetail records must be (217.00) in order for the transaction to be in balance. That is, the Debit of 217.00 in the ArImport record must be offset by Credits in ArImportDetail totaling (217.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.