Importing Transaction Documents
The following section defines the field references used in the Document Information section of the *.DEF file:
| Table: tblTEDocument | ||||
|---|---|---|---|---|
| Context Section: CONTEXT,TRANSENTRY,HEADER,HDOC | ||||
| Field ID | Req'd | Field Length | Default Value | Notes |
|
TEDOC_SESSION |
Y |
14 |
Session ID |
|
|
TEDOC_TRANSOURCE |
Y |
3 |
Transaction Source Codes: API, APM, APC, ARB, ARM, ARP, ARC, ENC, ENL, JV, CD, CR, or BD. See Table 1. |
|
|
TEDOC_DOCNUM |
Y |
User Defined |
Receipt, Check, Voucher, Document, Invoice, or Credit Number |
|
|
TEDOC_DESCRIPTION |
Y |
User Defined |
Transaction Description |
|
|
TEDOC_PLAYER_ID |
Y |
User Defined |
Vendor or Customer ID. See note below. |
|
|
TEDOC_PLAYERTYPE |
N |
1 |
V |
V for Vendor; C for Customer |
|
TEDOC_1099TYPE |
Y |
4 |
1099 Type ID, such as MISC, DIV, INT, R, or W2G |
|
|
TEDOC_ADDRESS_ID |
Y |
User Defined |
|
Vendor Check Address ID for API, APM, APC, and CD. |
|
TEDOC_DOCDATE |
Y |
Date |
Current Date |
Can be 6, 8, or 10 digit date. |
|
TEDOC_DUEDATE |
Y |
Date |
Can be 6, 8, or 10 digit date. Valid for API or ARB only. |
|
|
TEDOC_MISCINFO |
N |
25 |
Deposit valid for CR or ARC. |
|
|
TEDOC_PAYMETHOD |
N |
20 |
|
Payment Method for ARC, such as Cash, Check, Credit Card. |
| TEDOC_AR_CR_TYPE | Y | 25 | Credit Type for ARM, such as Applied Credit, Prepayment. | |
|
TEDOC_REVERSE |
N |
5 |
NOREV |
Reverse, such as REV or NOREV. |
|
TEDOC_REVERSE |
Y |
Date |
Current Date |
Can be 6, 8, or 10 digit date. Valid for JV - Reverse in Current Document only. |
Note: The TEDOC_TRANSOURCE field is not used with the SampleT3ENL.DEF or SampleT3JV.DEF files.
The TEDOC_PLAYER_ID field is required for transactions with a transaction source code of API, APM, APC, ARB, ARM, ARC, ENC, or ENL. It is optional for CD or CR and is not used with JV or BD.