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

COMPANY..ASI25831 Table Definition

(COMPANY..)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CMPANYID smallint

Company ID...(more) Join Now WPPU0114.CMPANYID
join ... more text available
USERID char

The user t...(more) Join Now
join ... more text available
PABILLTRXT smallint


PADocnumber20 char


PADOCDT datetime


PAPD datetime


BACHNUMB char

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

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

Transactio...(more) Join Now
PAuserid char


LSTEDTDT datetime

Last Edit ...(more) Join Now ICJC9000.LSTEDTDT
LSTUSRED char


PABill_HDR_Errors binary


PABill_Distribution_Er binary


PAREFNO char


CUSTNMBR char

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


TXRGNNUM char

Tax Regist...(more) Join Now EDCVAT41.TXRGNNUM
CSTPONBR char


PRBTADCD char

Primary Bi...(more) Join Now PA01101.PRBTADCD
join ... more text available
PYMTRMID char

Payment Te...(more) Join Now RM50105.PYMTRMID
SY033... more text available
PABILLFORMAT char

The defaul...(more) Join Now PA01101.PABILLFORMAT
PACOMM char


CURNCYID char

Currency I...(more) Join Now RM20102.CURNCYID
join ... more text available
CURRNIDX smallint

Currency I...(more) Join Now RM20102.CURRNIDX
join ... more text available
RTCLCMTD smallint

Rate calcu...(more) Join Now MC40300.RTCLCMTD
XCHGRATE numeric

Exchange R...(more) Join Now MC00100.XCHGRATE
DENXRATE numeric

Exchange R...(more) Join Now PTE30501.DENXRATE
PAUD1 char

PA User De...(more) Join Now PA11801.PAUD1
PAUD2 char

PA User De...(more) Join Now PA11801.PAUD2
CASHAMNT numeric

Cash Amoun...(more) Join Now PTE30500.CASHAMNT
ORCASAMT numeric

Originatin...(more) Join Now PTE30500.ORCASAMT
CBKIDCSH char


CASHDATE datetime


DCNUMCSH char


CHEKAMNT numeric

Check Amou...(more) Join Now PTE30500.CHEKAMNT
ORCHKAMT numeric

Originatin...(more) Join Now PTE30500.ORCHKAMT
CBKIDCHK char


CHEKNMBR char


CHEKDATE datetime


DCNUMCHK char


CRCRDAMT numeric

Credit Car...(more) Join Now PTE30500.CRCRDAMT
ORCCDAMT numeric

Originatin...(more) Join Now PTE30500.ORCCDAMT
CRCRDNAM char


RCTNCCRD char


CRCARDDT datetime

Credit Car...(more) Join Now PTE30500.CRCARDDT
DCNUMCRD char


DSCPCTAM smallint

Discount P...(more) Join Now PA01101.DSCPCTAM
DSCDLRAM numeric


ORDDLRAT numeric

Originatin...(more) Join Now PTE30500.ORDDLRAT
DISAVAMT numeric

Discount A...(more) Join Now ICJC9000.DISAVAMT
ORDAVAMT numeric


DISCAMNT numeric


DISCDATE datetime

Discount D...(more) Join Now PTE30500.DISCDATE
DISTKNAM numeric

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


DISCRTND numeric

Discount R...(more) Join Now ICJC9000.DISCRTND
PAOrigDiscRetAmt numeric


PADISCRETAMT numeric


PAODISCRETAMT numeric


PABillingAmount numeric


PAOrigBillAmount numeric


TRDISAMT numeric

Trade Disc...(more) Join Now PA11801.TRDISAMT
ORTDISAM numeric


PA_Freight_Amount numeric


PAOrigFreightAmt numeric


FRTTXAMT numeric

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

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


PAOrigMiscAmt numeric


MSCTXAMT numeric

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

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


PAOrigTotalTaxAmt numeric


PABACKBILL numeric


PAOrigBackoutBillAmt numeric


BKTFRTAM numeric

Backout Fr...(more) Join Now ICJC9001.BKTFRTAM
ORBKTFRT numeric


BKTMSCAM numeric

Backout Mi...(more) Join Now ICJC9001.BKTMSCAM
ORBKTMSC numeric


DOCAMNT numeric

Source Doc...(more) Join Now RVLPD026.DOCAMNT
ORDOCAMT numeric

Orig Docum...(more) Join Now RVLPD026.ORDOCAMT
DUEDATE datetime

Due Date T...(more) Join Now MOP1071.DUEDATE
APPLDAMT numeric


ORAPPAMT numeric


PALastDateApplied datetime


SLPRSNID char

Salesperso...(more) Join Now PA01101.SLPRSNID
join ... more text available
SALSTERR char

Sales Terr...(more) Join Now PA01101.SALSTERR
join ... more text available
TAXSCHID char


join ... more text available
COMDLRAM numeric

Field Type...(more) Join Now ICJC9000.COMDLRAM
ORCOMAMT numeric


COMAPPTO smallint

Commission...(more) Join Now PA01101.COMAPPTO
LNITMSEQ int

Line Item ...(more) Join Now PA11801.LNITMSEQ
CUTOFDAT datetime


SHIPMTHD char


join ... more text available
MSCSCHID char


join ... more text available
MISCTXBL smallint


FRTSCHID char

Freight Sc...(more) Join Now RM30101.FRTSCHID
join ... more text available
FRGTTXBL smallint


PARetentionFeeAmount numeric

PA Retenti...(more) Join Now PA01101.PARetentionFeeAmount
PAOrigRetentionFeeAmt numeric


PAtotbillings numeric


PAOrigTotalBilings numeric


PARetainer_Fee_Amount numeric

PA Project...(more) Join Now PA01101.PARetainer_Fee_Amount
PAOrigRetainerFeeAmt numeric


ADDRESS1 char


ADDRESS2 char


COUNTRY char


CITY char


STATE char


ZIP char


DCSTATUS smallint


PAlastprtby char


PAlastprtdate datetime


PAsfid smallint


PASFile char


PYMTRCVD numeric


ORPMTRVD numeric


BALNCDUE numeric


Outstanding_Amount numeric


PAOOUTSTANDINGAMT numeric


ORIGIN smallint


CNTCPRSN char

Contact Pe...(more) Join Now PA01101.CNTCPRSN
ADRSCODE char

Address Co...(more) Join Now PA01101.ADRSCODE
PRSTADCD char


join ... more text available
STADDRCD char


DOCHDR 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