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

COMPANY..pc00758 Table Definition

(COMPANY..pcbPOTransactionTemp )

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
zProcessUserID char
''

zProjectID char
''

zProjectDescription char
''

zTaskID char
''

zTaskDescription char
''

zTransactionNumber int
0

zTransactionDate datetime
'1900-01-01'

zUserID char
''

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

zSubCostCategory smallint
0

zSubCostCategoryString char
''

zDepartmentID char
''

zTransactionDescription char
''

zAccountIndex int
0

zAccountNumberString char
''

zPONumber char
''

zPOLineNumber int
0

zVendorID char
''

zQty numeric
0.00

zUnitCost numeric
0.00

zOriginatingUnitCost numeric
0.00

zCostAmt numeric
0.00

zOriginatingCostAmt numeric
0.00

zUnitPrice numeric
0.00

zItemID char
''

zItemDescription char
''

zUofM char
''

See I... more text available
zUserDefinedDate datetime
'1900-01-01'

zUserDefinedDate2 datetime
'1900-01-01'

zUserDefinedString char
''

zUserDefinedString2 char
''

zUserDefinedCurrency numeric
0.00

zUserDefinedCurrency2 numeric
0.00

zNoteIndex numeric
0.00

zInventoryIndex int
0

zQtyReceived numeric
0.00

zQtyInvoiced numeric
0.00

zBudgetTransactionNumber int
0

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
zBillingDescriptionText text
''

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