Module List > Module ASI tables ASI25851
You are currently viewing the COMPANY database.
Change

COMPANY..ASI25851 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
USERID char

The user t...(more) Join Now
join ... more text available
CUSTNMBR char

Customer N...(more) Join Now PA01101.CUSTNMBR
join ... more text available
DOCNUMBR char

Document N...(more) Join Now RM20102.DOCNUMBR
RMDTYPAL smallint

RM Documen...(more) Join Now RM20102.RMDTYPAL
BACHNUMB char

Batch Numb...(more) Join Now
join ... more text available
TAXDTLID char

Tax Detail...(more) Join Now PM30300.TAXDTLID
TXDTLDSC char


TAXAMNT numeric

Tax Amount...(more) Join Now PA11801.TAXAMNT
STAXAMNT numeric


FRTTXAMT numeric

Freight Ta...(more) Join Now PTE30500.FRTTXAMT
MSCTXAMT numeric

Misc Tax A...(more) Join Now PTE30500.MSCTXAMT
TAXDTSLS numeric


TDTTXSLS numeric


ORTAXAMT numeric

Originatin...(more) Join Now PTE30501.ORTAXAMT
ORSLSTAX numeric


ORFRTTAX numeric

Originatin...(more) Join Now PTE30500.ORFRTTAX
ORMSCTAX numeric

Originatin...(more) Join Now PTE30500.ORMSCTAX
ORTOTSLS numeric


ORTXSLS numeric


DISPTAXAMNT numeric


DISPSLSTAX numeric


DISPFRTTAX numeric


DISPMSCTAX numeric


DISPTOTSLS numeric


DISPTXSLS numeric


TXDTLPCH char


ACTINDX int

Account In...(more) Join Now WO010702.ACTINDX
join ... more text available
CURRNIDX smallint

Currency I...(more) Join Now RM20102.CURRNIDX
join ... more text available
TRXSORCE char

Transactio...(more) Join Now
BKOUTTAX tinyint


POSTED tinyint


SEQNUMBR int

Sequence N...(more) Join Now HR2EMP02.SEQNUMBR
TXDETRTP char


TTAXSSTR char


DCTTSSTR char


TXAMTSTR char


DCTXASTR char


DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3