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

COMPANY..B3970320 Table Definition

(COMPANY..BSSI_POP_Dist_Original_Hist)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
POPRCTNM char(17)
''
POP Receip...(more) Join Now POP40100.POPRCTNM
SEQNUMBR int
0
Sequence N...(more) Join Now POP10340.SEQNUMBR
ACTINDX int
0
Account In...(more) Join Now UPR40500.ACTINDX
join ... more text available
CRDTAMNT numeric(19,5)
0.00
Credit Amo...(more) Join Now POP10390.CRDTAMNT
ORCRDAMT numeric(19,5)
0.00
Field Type...(more) Join Now SVC35630.ORCRDAMT
DEBITAMT numeric(19,5)
0.00
Debit Amou...(more) Join Now POP10390.DEBITAMT
ORDBTAMT numeric(19,5)
0.00
Field Type...(more) Join Now SVC35630.ORDBTAMT
DistRef char(31)
''
Distributi...(more) Join Now POP10700.DistRef
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
TRXSORCE char(13)
''
Transactio...(more) Join Now
CURRNIDX smallint
0
Currency I...(more) Join Now POP10100.CURRNIDX
join ... more text available
XCHGRATE numeric(19,7)
0.00
Field Type...(more) Join Now
VENDORID char(15)
''
Vendor ID ...(more) Join Now POP10100.VENDORID
join ... more text available
CURNCYID char(15)
''
Currency I...(more) Join Now POP10100.CURNCYID
join ... more text available
RATETPID char(15)
''
A valid Ra...(more) Join Now
EXGTBLID char(15)
''
Exchange T...(more) Join Now POP10100.EXGTBLID
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now POP10100.EXCHDATE
TIME1 datetime
'1/1/1900'
Time Time...(more) Join Now POP10100.TIME1
RATECALC smallint
0
Rate Calc ...(more) Join Now POP10100.RATECALC
DENXRATE numeric(19,7)
0.00
Field Type...(more) Join Now SVC35600.DENXRATE
MCTRXSTT smallint
0
MC Transac...(more) Join Now POP10100.MCTRXSTT
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