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

COMPANY..B3950340 Table Definition

(COMPANY..BSSI_RM_Original_Distribution_WORK)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
TRXSORCE char(13)
''
Transactio...(more) Join Now
POSTED tinyint
0

POSTEDDT datetime
'1/1/1900'
Posted Date The system date at the time the transaction iso psted
PSTGSTUS smallint
0
Posting St...(more) Join Now SOP10100.PSTGSTUS
CHANGED tinyint
0
Changed Se...(more) Join Now POP10140.CHANGED
DOCNUMBR char(21)
''
Document N...(more) Join Now RM20102.DOCNUMBR
DCSTATUS smallint
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
RMDTYPAL smallint
0
RM Documen...(more) Join Now RM20102.RMDTYPAL
SEQNUMBR int
0
Sequence N...(more) Join Now POP10340.SEQNUMBR
CUSTNMBR char(15)
''
Customer N...(more) Join Now POP10100.CUSTNMBR
join ... more text available
DSTINDX int
0

DEBITAMT numeric(19,5)
0.00
Debit Amou...(more) Join Now POP10390.DEBITAMT
CRDTAMNT numeric(19,5)
0.00
Credit Amo...(more) Join Now POP10390.CRDTAMNT
PROJCTID char(15)
''

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
CATEGUSD smallint
0

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