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

COMPANY..pc30101 Table Definition

(COMPANY..pcPOReceiptTransactionTemp )

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
zProcessUserID char(15)
''

zProcessType char(15)
''

zPONumber char(17)
''

zPOLineNumber int
0

zReceiptNumber char(21)
''

zReceiptLineNumber int
0

zInvoiceNumber char(21)
''

zInvoiceLineNumber int
0

zDocumentType smallint
0

zDocumentStatus smallint
0

zOrigPOTrxNumber int
0

zVendorID char(15)
''

zVoucherNumber char(21)
''

zProjectID char(21)
''

zTaskID char(21)
''

zTransactionNumber int
0

zTransactionDate datetime
'1/1/1900'

zUserID char(15)
''

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

zSubCostCategory smallint
0

zSubCostCategoryString char(15)
''

zDepartmentID char
''

zTransactionDescription char(61)
''

zBillingDescriptionLine1 char(51)
''

zBillingDescriptionLine2 char(51)
''

zBillingDescriptionLine3 char(51)
''

zBillingDescriptionLine4 char(51)
''

zAccountIndex int
0

zAccountNumberString char(41)
''

zQty numeric(19,5)
0.00

zQtyAvailable numeric(19,5)
0.00

zQtyApply numeric(19,5)
0.00

zUnitCost numeric(19,5)
0.00

zOriginatingUnitCost numeric(19,5)
0.00

zCostAmt numeric(19,5)
0.00

zOriginatingCostAmt numeric(19,5)
0.00

zUnitPrice numeric(19,5)
0.00

zItemID char(31)
''

zLocationCode char
''

zItemDescription char(51)
''

zUofM char(9)
''

See I... more text available
zUserDefinedDate datetime
'1/1/1900'

zUserDefinedDate2 datetime
'1/1/1900'

zUserDefinedString char(21)
''

zUserDefinedString2 char(21)
''

zUserDefinedCurrency numeric(19,5)
0.00

zUserDefinedCurrency2 numeric(19,5)
0.00

zNoteIndex numeric(19,5)
0.00

zInventoryIndex int
0

zBillingDescriptionText text
''

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