Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Column Header Namescolumn lettersRequired field?

Type, Length,

Format

TableDescription
unitAYes


reporterEmailAddressBYes


acquisitionTypeCodeCYesVarchar2(1)

descriptionDYes


organizationOwnerChartOfAccountsCodeEYes


organizationOwnerAccountNumberFYes


agencyNumberG



inventoryStatusCodeHYes


conditionCodeIYes


capitalAssetDescriptionJYes


capitalAssetTypeCodeKYes


vendorNameL



manufacturerNameM



manufacturerModelNumberN



organizationTextO



createDatePYes


campusCodeQYes


buildingCodeRYes


buildingRoomNumberS



locationQuantityTYes


serialNumberU



organizationInventoryNameV



organizationAssetTypeIdentifierW



governmentTagNumberX



campusTagNumberY



nationalStockNumberZ



representativeUniversalIdentifierAA



chartOfAccountsCodeABYes


accountNumberACYes


subAccountNumberAD



financialObjectCodeAEYes


financialSubObjectCodeAF



projectCodeAG



organizationReferenceIdAH



expenditureFinancialSystemOriginationCodeAI



expenditureFinancialDocumentNumberAJ



expenditureFinancialDocumentTypeCodeAK



purchaseOrderNumberAL



requisitionNumberAM



expenditureFinancialDocumentPostedDateAN



postingPeriodCodeAO



amountAPYes


approvalMethodAQ



FiscalYearAR



...