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

COMPANY..ASI12318 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
Database_Operation smallint


Database_Operation_Group int


Database_Oper_GrSQNC smallint


KEYNUMBR smallint


BACHNUMB char

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

Batch Sour...(more) Join Now
PMNTNMBR char


CHEKBKID char

Checkbook ID Checkbook this transaction affects SY30500.CHEKBKID
join ... more text available
DOCDATE datetime

The date a...(more) Join Now RM20101.DOCDATE
DOCNUMBR char

Document N...(more) Join Now RM20102.DOCNUMBR
APPLDAMT numeric


CURTRXAM numeric


CHEKTOTL numeric


VENDORID char

Vendor ID:...(more) Join Now PM00200.VENDORID
join ... more text available
VENDNAME char

Vendor Nam...(more) Join Now RVLPD026.VENDNAME
COMMENT1 char


ADDRESS1 char


ADDRESS2 char


ADDRESS3 char


CITY char


STATE char


ZIPCODE char


COUNTRY char


VNDCHKNM char


SOURCDOC char

span style...(more) Join Now GL30000.SOURCDOC
DISTKNAM numeric

Discount T...(more) Join Now RM20102.DISTKNAM
DISAMTAV numeric

Discount A...(more) Join Now PTE30500.DISAMTAV
WROFAMNT numeric

Write Off ...(more) Join Now PA01101.WROFAMNT
CURNCYID char

Currency I...(more) Join Now RM20102.CURNCYID
join ... more text available
VOIDED tinyint


REPRNTED smallint


GSTDSAMT numeric

GST Discou...(more) Join Now ICJC9001.GSTDSAMT
PGRAMSBJ smallint


PPSTAXRT smallint


PPSAMDED numeric

PPS Amount...(more) Join Now ICJC9001.PPSAMDED
LDOCRMTC smallint


SDORMBY smallint


KEYFIELD char


AMWDSNBR char


NOTEINDX numeric

Note Index...(more) Join Now
join ... more text available
VCHRNMBR char

Voucher Nu...(more) Join Now PP100101.VCHRNMBR
CNTRLTYP smallint


DOCTYPE smallint

Document T...(more) Join Now PM30300.DOCTYPE
MODIFDT datetime

Date the r...(more) Join Now
MDFUSRID char

User that ...(more) Join Now
join ... more text available
PSTGSTUS smallint

Posting St...(more) Join Now SOP10100.PSTGSTUS
POSTEDDT datetime

Posted Date The system date at the time the transaction iso psted B3950340.POSTEDDT
PTDUSRID char


PMWRKMSG binary


PMWRKMS2 binary


PMDSTMSG binary


CHKCOMNT char


PSTGDATE datetime


STRGA255 char


STRGB255 char


SEPRMTNC tinyint


STBOVRFL tinyint


CTYSTZIP char


TotDocAmt numeric


TotAmtPaid numeric


TotCrdAmt numeric


TotalPaidTot numeric


TotNegTot numeric


TotCrdDocAmt numeric


TotTotDocAmt numeric


TotDiscTknAmt numeric


TotWOAmt numeric


TotPPSAmtDed numeric


TotGSTDiscAmt numeric


TotDiscTknTot numeric


TotWOTot numeric


Outstanding_Amount numeric


Net_Paid_Amount numeric


Electronic tinyint


PONUMBER char

PO Number ...(more) Join Now SEE30303.PONUMBER
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
AMTINWDS text


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