<taGLTransactionLineInsert>
Element |
Datatype |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
BACHNUMB |
string |
15 |
Y |
Not applicable |
Batch number |
JRNENTRY |
i4 |
4 |
Y |
Not applicable |
Journal entry number |
SQNCLINE |
number |
21 |
N |
0 |
Sequence line |
ACTINDX |
i4 |
4 |
N |
0 |
Account index |
CRDTAMNT |
number |
21 |
Y |
Not applicable |
Credit amount |
DEBITAMT |
number |
21 |
Y |
Not applicable |
Debit amount |
ACTNUMST |
string |
75 |
N |
<blank> |
Account string |
DSCRIPTN |
string |
30 |
N |
<blank> |
Description |
ORCTRNUM |
string |
20 |
N |
<blank> |
Originating control number |
ORDOCNUM |
string |
20 |
N |
<blank> |
Originating document number |
ORMSTRID |
string |
30 |
N |
<blank> |
Originating master ID |
ORMSTRNM |
string |
64 |
N |
<blank> |
Originating master name |
ORTRXTYP |
i4 |
2 |
N |
0 |
Originating transaction type |
OrigSeqNum |
i4 |
4 |
N |
0 |
Originating sequence number |
ORTRXDESC |
string |
30 |
N |
<blank> |
Originating transaction description |
TAXDTLID |
string |
15 |
N |
<blank> |
Tax detail ID |
TAXAMNT |
number |
21 |
N |
0 |
Tax amount |
TAXACTNUMST |
string |
75 |
N |
<blank> |
Tax account string |
DOCDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Document date |
CURNCYID |
string |
15 |
N |
<blank> |
Currency ID |
XCHGRATE |
number |
21 |
N |
0 |
Exchange rate |
RATETPID |
string |
15 |
N |
<blank> |
Rate type ID |
EXPNDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Expiration date |
EXCHDATE |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Exchange date |
EXGTBDSC |
string |
30 |
N |
<blank> |
Exchange ID description |
EXTBLSRC |
string |
50 |
N |
<blank> |
Exchange rate source |
RATEEXPR |
i4 |
2 |
N |
Default from setup |
Rate expiration: 0=None 1=Daily; 2=Weekly; 3=Bi-weekly; 4=Semiweekly; 5=Monthly; 6=Quarterly; 7=Annually; 8=Miscellaneous; 9=None; |
DYSTINCR |
i4 |
2 |
N |
Default from setup |
Days to increment--used only when RATEEXPR=8 |
RATEVARC |
number |
21 |
N |
0 |
Rate variance |
TRXDTDEF |
i4 |
2 |
N |
Default from setup |
Transaction date default: 0=Exact date; 1=Next date; 2=Previous date |
RTCLCMTD |
i4 |
2 |
N |
Default from setup |
Rate calculation method: 0=Multiply; 1=Divide |
PRVDSLMT |
i4 |
2 |
N |
0 |
Previous days limits |
DATELMTS |
i4 |
2 |
N |
0 |
Date limits: 0=Unlimited; 1=Limited |
TIME1 |
datetime |
8 bytes (19 to 23 chars) |
N |
<blank> |
Time 1 |
RequesterTrx |
i4 |
2 |
N |
0 |
Requester transaction: 0=False; 1=True (if True it populates the requester shadow table) |
USRDEFND1 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND2 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND3 |
string |
50 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND4 |
string |
8000 |
N |
<blank> |
User-defined field--developer use only |
USRDEFND5 |
string |
8000 |
N |
<blank> |
User-defined field--developer use only |
This node uses document exchange for updates. All existing values are overwritten with the value specified by the update document. If a field in the update is blank, the existing value is changed to be blank.