Module List > Module Olympic PC tables pc90410
You are currently viewing the COMPANY database.
Change

COMPANY..pc90410 Table Definition

(COMPANY..pcPMTransactionWork )

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
DOCTYPE smallint
0
Document T...(more) Join Now PM10000.DOCTYPE
VCHRNMBR char(21)
''
Voucher Nu...(more) Join Now POP30300.VCHRNMBR
VENDORID char(15)
''
Vendor ID:...(more) Join Now PM10000.VENDORID
join ... more text available
DOCNUMBR char(21)
''
Document N...(more) Join Now PM10000.DOCNUMBR
DOCDATE datetime
'1/1/1900'
The date a...(more) Join Now
PRCHAMNT numeric(19,5)
0.00
Purchases ...(more) Join Now
DOCAMNT numeric(19,5)
0.00
Source Doc...(more) Join Now
zDescription char(31)
''

zProjectID char(21)
''

zTaskID char(21)
''

zTransactionNumber int
0

zTransactionDate datetime
'1/1/1900'

zCostCategoryDDL smallint
0
Incomplete...(more) Join Now
zCostCategoryString char(15)
''

zSubCostCategory smallint
0

zSubCostCategoryString char(15)
''

zOrigName char(65)
''

zQty numeric(19,5)
0.00

zUnitCost numeric(19,5)
0.00

zCostAmt numeric(19,5)
0.00

zAccountNumberString char(41)
''

ACTDESCR char(51)
''
Account De...(more) Join Now GL00100.ACTDESCR
zBillingWorkQty numeric(19,5)
0.00

zUnitPrice numeric(19,5)
0.00

zRevenueAmt numeric(19,5)
0.00

zSalesAccountString char(41)
''

zBillingDescriptionLine1 char(51)
''

zBillingDescriptionLine2 char(51)
''

zBillingDescriptionText text
''

zBillingDescriptionLine3 char(51)
''

zBillingDescriptionLine4 char(51)
''

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