|
General Ledger transaction Import tables |
  
|
|
General Ledger transaction Import tables |
|
Fields marked * may NOT be left blank. All other fields may be left blank.
Both import tables use the common GlImportID field to relate the master and detail records of transactions. Each transaction being imported must have a unique GlImportID.
GlImport table
Common information for a transaction. Each transaction has one record in this table.
GlImportID*
This field relates a master record to the detail records for a transaction.
GlType*
Specifies a valid GlType.
GlTransDate*
This must be a date that is open for General Ledger transaction entry and importing.
Reference
This field may be any value.
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 GlImportID.
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.
GlImportDetail table
Transaction details. Each transaction has two or more records in this table.
GlImportID*
This field relates each detail record to the corresponding master record for that transaction.
AccountID*
Specifies a valid General Ledger AccountID.
Amount*
This field specifies the Amount being distributed to the AccountID.
Debit amounts are positive and Credit amounts are negative.
The sum of all Debits and Credits for the transaction must net to zero. That is, the sum of the Amount(s) in the related GlImportDetail records for a valid transaction is zero.
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.