Module List > Module BS tables B3920102
You are currently viewing the COMPANY database.
Change

COMPANY..B3920102 Table Definition

(COMPANY..BSSI_PM_Original_Distribution_Paid_HIST)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
VCHRNMBR char(21)
''
Voucher Nu...(more) Join Now PM30600.VCHRNMBR
DSTSQNUM int
0

CNTRLTYP smallint
0

CRDTAMNT numeric(19,5)
0.00
Credit Amo...(more) Join Now POP10390.CRDTAMNT
DEBITAMT numeric(19,5)
0.00
Debit Amou...(more) Join Now POP10390.DEBITAMT
DSTINDX int
0

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
CHANGED tinyint
0
Changed Se...(more) Join Now POP10140.CHANGED
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
PSTGSTUS smallint
0
Posting St...(more) Join Now SOP10100.PSTGSTUS
VENDORID char(15)
''
Vendor ID ...(more) Join Now POP10100.VENDORID
join ... more text available
TRXSORCE char(13)
''
Transactio...(more) Join Now
PSTGDATE datetime
'1/1/1900'

INTERID char(5)
''

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
ORCRDAMT numeric(19,5)
0.00
Field Type...(more) Join Now SVC35630.ORCRDAMT
ORDBTAMT numeric(19,5)
0.00
Field Type...(more) Join Now SVC35630.ORDBTAMT
APTVCHNM char(21)
''

APTODCTY smallint
0

SPCLDIST smallint
0

DistRef char(31)
''
Distributi...(more) Join Now POP10700.DistRef
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
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
DECPLACS smallint
0

EXPNDATE datetime
'1/1/1900'
Expiration...(more) Join Now POP10330.EXPNDATE
ICCURRID char(15)
''

ICCURRIX smallint
0

DENXRATE numeric(19,7)
0.00
Field Type...(more) Join Now SVC35600.DENXRATE
MCTRXSTT smallint
0
MC Transac...(more) Join Now POP10100.MCTRXSTT
CorrespondingUnit char(5)
''

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