| aaSubLedgerHdrID |
int
0
|
|
|
|
|
| aaSubLedgerDistID |
int
0
|
|
|
|
|
| INTERID |
char(5)
''
|
|
|
|
|
| CorrespondingUnit |
char(5)
''
|
|
|
|
|
| ACTINDX |
int
0
|
Account In...(more) Join Now
|
UPR40500.ACTINDX
|
|
join ... more text available
|
| DISTTYPE |
smallint
0
|
|
Distribution
Type
|
Integer Value
|
Sales /
Invoices
|
Sched
Payments
|
Debit
Memos
|
Finance
Charges
|
Service
Repairs
|
Warranty
|
Credit
Memos
|
Returns
|
Cash
Receipts
|
|
Cash
|
1
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
Terms Taken
|
2
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
Accts Rec
|
3
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
Writeoffs
|
4
|
|
na
|
|
|
|
|
*
|
*
|
*
|
|
Terms Avail
|
5
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
GST
|
6
|
|
na
|
|
|
|
|
*
|
*
|
*
|
|
PPS
|
7
|
|
na
|
|
|
|
|
*
|
*
|
*
|
|
Other
|
8
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
*
|
|
Sales
|
9
|
*
|
na
|
|
|
|
|
|
|
|
|
Trade
|
10
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
|
|
Freight
|
11
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
|
|
Miscellaneous
|
12
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
|
|
Taxes
|
13
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
|
|
COGS
|
14
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
|
|
Inventory
|
15
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
|
|
Finance Chrg
|
16
|
|
na
|
|
*
|
|
|
|
|
|
|
Returns
|
17
|
|
na
|
|
|
|
|
|
*
|
|
|
Debit Memo
|
18
|
|
na
|
*
|
|
|
|
|
|
|
|
Credit Memo
|
19
|
|
na
|
|
|
|
|
*
|
|
|
|
Service
|
20
|
|
na
|
|
|
*
|
|
|
|
|
|
Warr Exp
|
21
|
|
na
|
|
|
|
*
|
|
|
|
|
Warr Sls
|
22
|
|
na
|
|
|
|
*
|
|
|
|
|
Comm Exp
|
23
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
|
|
Comm Pay
|
24
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
|
|
Unit Acc
|
25
|
*
|
na
|
*
|
*
|
*
|
*
|
*
|
*
|
*
|
|
ROUND
|
26
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
RZGain
|
27
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
RZLOSS
|
28
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
URZGain
|
29
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
URZLoss
|
30
|
*
|
na
|
*
|
*
|
*
|
|
*
|
*
|
*
|
|
RVLPD030.DISTTYPE
|
|
|
| ACCTTYPE |
smallint
0
|
|
|
|
|
| aaBrowseType |
smallint
0
|
The values...(more) Join Now
|
|
|
|
| DECPLACS |
smallint
0
|
|
|
|
|
| DEBITAMT |
numeric(19,5)
0.00
|
Debit Amou...(more) Join Now
|
POP10390.DEBITAMT
|
|
|
| CRDTAMNT |
numeric(19,5)
0.00
|
Credit Amo...(more) Join Now
|
POP10390.CRDTAMNT
|
|
|
| ORDBTAMT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
SVC35630.ORDBTAMT
|
|
|
| ORCRDAMT |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
SVC35630.ORCRDAMT
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
POP10100.CURNCYID
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
POP10100.CURRNIDX
|
|
join ... more text available
|
| RATETPID |
char(15)
''
|
A valid Ra...(more) Join Now
|
|
|
|
| EXGTBLID |
char(15)
''
|
Exchange T...(more) Join Now
|
POP10100.EXGTBLID
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Field Type...(more) Join Now
|
SVC35600.XCHGRATE
|
|
|
| EXCHDATE |
datetime
'1/1/1900'
|
Exchange D...(more) Join Now
|
POP10100.EXCHDATE
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time Time...(more) Join Now
|
POP10100.TIME1
|
|
|
| RTCLCMTD |
smallint
0
|
Rate calcu...(more) Join Now
|
MC40300.RTCLCMTD
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Field Type...(more) Join Now
|
SVC35600.DENXRATE
|
|
|
| MCTRXSTT |
smallint
0
|
MC Transac...(more) Join Now
|
POP10100.MCTRXSTT
|
|
|
| SEQNUMBR |
int
0
|
Sequence N...(more) Join Now
|
IV10400.SEQNUMBR
|
|
|
| GLPOSTDT |
datetime
'1/1/1900'
|
Date that ...(more) Join Now
|
RM20101.GLPOSTDT
|
|
|
| aaCustID |
char(15)
''
|
|
|
|
|
| aaVendID |
char(15)
''
|
|
|
|
|
| aaSiteID |
char(11)
''
|
|
|
|
|
| aaItemID |
char(31)
''
|
|
|
|
|
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
UPR00100.EMPLOYID
|
|
join ... more text available
|
| aaAssetID |
char
''
|
|
|
|
|
| aaCopyStatus |
smallint
0
|
|
|
|
|
| aaWinWasOpen |
tinyint
0
|
|
|
|
|
| aaBookID |
char
''
|
|
|
|
|
| POSTED |
tinyint
0
|
|
|
|
|
| HISTORY |
tinyint
0
|
|
|
|
|
| aaDistErrors |
binary(4)
0
|
|
|
|
|
| APTVCHNM |
char(21)
''
|
|
|
|
|
| APTODCTY |
smallint
0
|
|
|
|
|
| aaFutureDist |
int
0
|
|
|
|
|
| aaOffsetAcct |
tinyint
0
|
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Item Numbe...(more) Join Now
|
IV10201.ITEMNMBR
|
|
join ... more text available
|
| TRXLOCTN |
char(11)
''
|
p>TRX Loca...(more) Join Now
|
IV10201.TRXLOCTN
|
|
|
| BINNMBR |
char(21)
''
|
|
|
|
|
| TRNSTLOC |
char(11)
''
|
|
|
|
|
| TRXQTY |
numeric(19,5)
0.00
|
TRX QTY: T...(more) Join Now
|
|
|
|
| PYRLRTYP |
smallint
0
|
1 = Regula...(more) Join Now
|
B3980230.PYRLRTYP
|
|
|
| TRXNUMBER |
int
0
|
|
|
|
|
| aaChangeDate |
datetime
'1/1/1900'
|
|
|
|
|
| aaChangeTime |
datetime
'1/1/1900'
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|