|
Field Name |
Type and Number of Characters |
Format |
Notes |
|
HEADER Row Format |
|
|
One row per file |
|
Input Row No |
Numeric 10 |
9999999999 |
|
|
Record Type |
Character 1 |
|
“H” = Header |
|
Current FY |
Character 6 |
|
|
|
Current Pd |
Numeric 2 |
99 |
|
|
Company ID |
Character 10 |
|
|
|
!ASSET Row Format: |
|
|
One row per asset |
|
Input Row No |
Numeric 10 |
9999999999 |
|
|
Record Type |
Character 1 |
|
“A” = Asset |
|
Asset ID |
Character 10 |
|
|
|
Item No |
Numeric 5 |
99999 |
|
|
Template No |
Character 30 |
|
|
|
Template Rev No |
Character 3 |
|
|
|
Short Desc |
Character 30 |
|
|
|
Long Desc |
Character 60 |
|
|
|
Addt'l Desc |
Character 254 |
|
|
|
Classification Code |
Character 6 |
|
|
|
Property Type |
Character 6 |
|
|
|
Depr Status |
Character 1 |
|
“D” (Depreciable) or “N” (Non-Depreciable) |
|
Record Status |
Character 1 |
|
“A” (Active), “I” (Inactive), or “D” (Disposal) |
|
Depr Based on |
Character 1 |
|
“Y” (Years), “U” (Units), or “L” (Lease Pds) |
|
Vendor |
Character 12 |
|
|
|
Vendor Name |
Character 25 |
|
|
|
Manufacturer ID |
Character 10 |
|
|
|
Manufacturer Name |
Character 30 |
|
|
|
Model No |
Character 30 |
|
|
|
Condition |
Character 1 |
|
“N” (New) or “U” (Used) |
|
City |
Character 25 |
|
|
|
State/Province |
Character 15 |
|
|
|
Postal Code |
Character 10 |
|
|
|
County |
Character 25 |
|
|
|
Country |
Character 8 |
|
|
|
Location Group |
Character 8 |
|
|
|
Location 1 Code |
Character 8 |
|
|
|
Location 2 Code |
Character 8 |
|
|
|
Location 3 Code |
Character 8 |
|
|
|
Accumulated Depreciation Account Code |
Character 6 |
|
|
|
Depr Expense Acct Alloc Code |
Character 6 |
|
|
|
Tag Number |
Character 30 |
|
|
|
Acquisition Date |
Date 8 |
|
|
|
Purchase Order Date |
Date 8 |
|
|
|
Purchase Order No |
Character 10 |
|
|
|
Purchase Order Rel No |
Numeric 3 |
999 |
|
|
Purchase Order Line No |
Numeric 4 |
9999 |
|
|
Receipt Date |
Date 8 |
|
|
|
Packing Slip |
Character 15 |
|
|
|
Invoice Date |
Date 8 |
|
|
|
Invoice No |
Character 15 |
|
|
|
Voucher Date |
Date 8 |
|
|
|
Voucher No |
Numeric 9 |
999999999 |
|
|
Serial No |
Character 20 |
|
|
|
Acquisition Fiscal Year |
Character 6 |
|
|
|
Acquisition Period |
Numeric 2 |
99 |
|
|
Acquisition Subperiod |
Numeric 2 |
99 |
|
|
Units Quantity No |
Numeric 4 |
9999 |
|
|
Unit of Measure |
Character 10 |
|
|
|
Unit Price |
Numeric 14, 2 |
999999999999.99 |
|
|
Sales Tax |
Numeric 14, 2 |
999999999999.99 |
|
|
Shipping/Handling |
Numeric 14, 2 |
999999999999.99 |
|
|
Transportation |
Numeric 14, 2 |
999999999999.99 |
|
|
Other Cost |
Numeric 14, 2 |
999999999999.99 |
|
|
Amount Posted Curr Pd |
Numeric 14, 2 |
999999999999.99 |
|
|
Estimated Units Useful Life |
Numeric 9 |
999999999 |
|
|
Unit of Measure Description |
Character 10 |
|
|
|
Std Depr Rt Per Unit of Usage |
Numeric 14, 4 |
999999999999.9999 |
|
|
Prior Units Used |
Numeric 14 |
999999999999.9999 |
|
|
Current Units Used |
Numeric 14 |
999999999999.9999 |
|
|
Capitalized Lease |
Character 1 |
|
|
|
Lease Start Date |
Date 8 |
|
|
|
Lease End Date |
Date 8 |
|
|
|
Total No Periods |
Numeric 3 |
999 |
Leases |
|
Monthly Lease Payment |
Numeric 14, 2 |
999999999999.99 |
|
|
Lease Pds Remaining |
Numeric 3 |
999 |
|
|
Disposal Date |
Date 8 |
|
|
|
Disposal Fiscal Year |
Character 6 |
|
|
|
Disposal Period |
Numeric 2 |
99 |
|
|
Disposal Subperiod |
Numeric 2 |
99 |
|
|
Disposal Price |
Numeric 14, 2 |
999999999999.99 |
|
|
Disposal Description |
Character 30 |
|
|
|
(This is not displayed on screen as a field) |
Character 3 |
|
NULL Disposal Journal Code (Column ASSET.DISP_S_JNL_CD) |
|
Disposal Post Seq No |
Numeric |
|
Post Sequence Number Assigned during Disposal Posting |
|
Disposal Entry Type |
Character 6 |
|
“MANUAL”, “SYSTEM,” or “PREPRO” |
|
Depr Method Code |
Character 6 |
|
|
|
Useful Life |
Numeric 4 |
9999 |
|
|
Auto Calculate Depreciation |
Character 1 |
|
“Y” (Yes) or “N” (No) |
|
Salvage Percent |
Numeric 7,6 |
9999999.999999 |
Maximum value = 100 |
|
Salvage Value |
Numeric 14, 2 |
999999999999.99 |
|
|
FYTD Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Prior FY Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Current Pd Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Annual Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Depr Start Date |
Date 8 |
|
|
|
In-Service Date |
Date 8 |
|
|
|
Cur Depr Year |
Numeric 2 |
99 |
|
|
Days/Pds Remaining |
Numeric 3 |
999 |
|
|
Amt Taken Purch YTD |
Numeric 14, 2 |
999999999999.99 |
|
|
Asset Account |
Character 15 |
|
|
|
Asset Organization |
Character 20 |
|
|
|
Asset Project |
Character 30 |
|
|
|
Asset Ref 1 |
Character 20 |
|
|
|
Asset Ref 2 |
Character 20 |
|
|
|
(This is not displayed on screen as a field) |
Numeric 14, 2 |
999999999999.99 |
ASSET.B1_DP_DEPR_NY_AMT |
|
Post Seq No |
Numeric |
|
NULL |
|
Disposal Posting Date |
Date 8 |
|
|
|
Disposal Posting User |
Character 20 |
|
|
|
Receipt |
Character 10 |
|
|
|
Voucher Line No |
Numeric 5 |
99999 |
|
|
Non-Depr Post Disposal to G/L |
Character 1 |
|
“Y” (Yes) or “N” (No) |
|
Disposal Doc No |
Character 20 |
|
|
|
Subclass Code |
Character 6 |
|
|
|
Employee |
Character 12 |
|
|
|
Disposal Type |
Character 6 |
|
|
|
UID |
Character 78 |
|
|
|
UID Type |
Character 5 |
|
|
|
Issuing Agency Code |
Character 3 |
|
|
|
Enterprise Identifier |
Character 13 |
|
|
|
Cage ID |
Character 5 |
|
|
|
!ASSET_OTH_BK_DEPR Row Format: |
|
|
No row or one row per asset |
|
Input Row |
Numeric 10 |
9999999999 |
|
|
Record Type |
Character 1 |
|
“B” = Asset Other Book |
|
Asset ID |
Character 10 |
|
|
|
Item No |
Numeric 5 |
99999 |
|
|
!BOOK2 |
|
|
|
|
Book 2 Depr Method Code |
Character 6 |
|
|
|
Book 2 Useful Life |
Numeric 4 |
9999 |
|
|
Book 2 Auto Calc Depr |
Character 1 |
|
“Y” (Yes) or “N” (No) |
|
Book 2 Salvage Percent |
Numeric 7,6 |
9999999.999999 |
Maximum value = 100 |
|
Book 2 Salvage Value |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 2 FYTD Depr |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 2 Prior FY Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 2 Amt To Depreciate |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 2 Annual Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 2 Total Cost |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 2 Depr Start Date |
Date 8 |
|
|
|
Book 2 In-Service Date |
Date 8 |
|
|
|
Book 2 Curr Depr Yr |
Numeric 2 |
99 |
|
|
Book 2 Days/Pds Remaining |
Numeric 3 |
999 |
|
|
Book 2 Amt Taken Purchase YTD |
Numeric 14, 2 |
999999999999.99 |
|
|
(This is not displayed on screen as a field) |
Numeric 14, 2 |
999999999999.99 |
ASSET_OTH_BK_DEPR.B2_DP_DEPR_NY_AMT |
|
!BOOK3 |
|
|
|
|
Book 3 Depr Method Code |
Character 6 |
|
|
|
Book 3 Useful Life |
Numeric 4 |
9999 |
|
|
Book 3 Auto Calc Depr |
Character 1 |
“Y” (Yes) or “N” (No) |
|
|
Book 3 Salvage Percent |
Numeric 7,6 |
9999999.999999 |
Maximum value = 100 |
|
Book 3 Salvage Value |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 3 FYTD Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 3 Prior FY Depr Amount |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 3 Current Pd Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 3 Annual Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 3 Total Cost |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 3 Depr Start Date |
Date 8 |
|
|
|
Book 3 In-Service Date |
Date 8 |
|
|
|
Book 3 Curr Depr Yr |
Numeric 2 |
99 |
|
|
Book 3 Days/Pds Remaining |
Numeric 3 |
999 |
|
|
Book 3 Amt Taken Purchase YTD |
Numeric 14, 2 |
999999999999.99 |
|
|
(This is not displayed as a field on the screen) |
Numeric 14, 2 |
999999999999.99 |
ASSET_OTH_BK_DEPR.B3_DP_DEPR_NY_AMT |
|
!BOOK4 |
|
|
|
|
Book 4 Depr Method Code |
Character 6 |
|
|
|
Book 4 Useful Life |
Numeric 4 |
9999 |
|
|
Book 4 Auto Calc Depr |
Character 1 |
|
“Y” (Yes) or “N” (No) |
|
Book 4 Salvage Percent |
Numeric 7,6 |
9999999.999999 |
Maximum value = 100 |
|
Book 4 Salvage Value |
Numeric 14, 2 |
999999999999.99 |
|
|
Book FYTD Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 4 Prior FY Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 4 Current Pd Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 4 Annual Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 4 Total Cost |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 4 Depr Start Date |
Date 8 |
|
|
|
Book 4 In-Service Date |
Date 8 |
|
|
|
Book 4 Curr Depr Yr |
Numeric 2 |
99 |
|
|
Book 4 Days/Pds Remaining |
Numeric 3 |
999 |
|
|
Book 4 Amt Taken Purch YTD |
Numeric 14, 2 |
999999999999.99 |
|
|
(This is not displayed as a field on the screen) |
Numeric 14, 2 |
999999999999.99 |
ASSET_OTH_BK_DEPR.B4_DP_DEPR_NY_AMT |
|
!BOOK5 |
|
|
|
|
Book 5 Depr Method Code |
Character 6 |
|
|
|
Book 5 Useful Life |
Numeric 4 |
9999 |
|
|
Book 5 Auto Calc Depr |
Character 1 |
|
“Y” (Yes) or “N” (No) |
|
Book 5 Salvage Percent |
Numeric 7,6 |
9999999.999999 |
Maximum value = 100 |
|
Book 5 Salvage Value |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 5 FYTD Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 5 Prior FY Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 5 Current Pd Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 5 Annual Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 5 Total Cost |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 5 Depr Start Date |
Date 8 |
|
|
|
Book 5 In-Service Date |
Date 8 |
|
|
|
Book 5 Curr Depr Yr |
Numeric 2 |
99 |
|
|
Book 5 Days/Pds Remaining |
Numeric 3 |
999 |
|
|
Book 5 Amt Taken Purch YTD |
Numeric 14, 2 |
999999999999.99 |
|
|
(This is not displayed as a field on the screen) |
Numeric 14, 2 |
999999999999.99 |
ASSET_OTH_BK_DEPR.B5_DP_DEPR_NY_AMT |
|
!BOOK6 |
|
|
|
|
Book 6 Depr Method Code |
Character 6 |
|
|
|
Book 6 Useful Life |
Numeric 4 |
9999 |
|
|
Book 6 Auto Calc Rate |
Character 1 |
“Y” (Yes) or “N” (No) |
|
|
Book 6 Salvage Percent |
Numeric 7,6 |
9999999.999999 |
Maximum value = 100 |
|
Book 6 Salvage Value |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 6 FYTD Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 6 Prior FY Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 6 Current Pd Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 6 Annual Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 6 Total Cost |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 6 Depr Start Date |
Date 8 |
|
|
|
Book 6 In-Service Date |
Date 8 |
|
|
|
Book 6 Curr Depr Yr |
Numeric 2 |
99 |
|
|
Book 6 Days/Pds Remaining |
Numeric 3 |
999 |
|
|
Book 6 Amt Taken Purch YTD |
Numeric 14, 2 |
999999999999.99 |
|
|
(This is not displayed as a field on the screen) |
Numeric 14, 2 |
999999999999.99 |
ASSET_OTH_BK_DEPR.B6_DP_DEPR_NY_AMT |
|
!BOOK7 |
|
|
|
|
Book 7 Depr Method Code |
Character 6 |
|
|
|
Book 7 Useful Life |
Numeric 4 |
9999 |
|
|
Book 7 Auto Calc Depr |
Character 1 |
|
“Y” (Yes) or “N” (No) |
|
Book 7 Salvage Percent |
Numeric 7,6 |
9999999.999999 |
Maximum value = 100 |
|
Book 7 Salvage Value |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 7 FYTD Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 7 Prior FY Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 7 Current Pd Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 7 Annual Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 7 Total Cost |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 7 Depr Start Date |
Date 8 |
|
|
|
Book 7 In-Service Date |
Date 8 |
|
|
|
Book 7 Curr Depr Yr |
Numeric 2 |
99 |
|
|
Book 7 Days/Pds Remaining |
Numeric 3 |
999 |
|
|
Book 7 Amt Taken Purch YTD |
Numeric 14, 2 |
999999999999.99 |
|
|
(This is not displayed as a field on the screen) |
Numeric 14, 2 |
999999999999.99 |
ASSET_OTH_BK_DEPR.B7_DP_DEPR_NY_AMT |
|
!BOOK8 |
|
|
|
|
Book 8 Depr Method Code |
Character 6 |
|
|
|
Book 8 Useful Life |
Numeric 4 |
9999 |
|
|
Book 8 Auto Calc Depr |
Character 1 |
|
“Y” (Yes) or “N” (No) |
|
Book 8 Salvage Percent |
Numeric 7,6 |
9999999.999999 |
Maximum value = 100 |
|
Book 8 Salvage Value |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 8 FYTD Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 8 Prior FY Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 8 Current Pd Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 8 Annual Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 8 Total Cost |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 8 Depr Start Date |
Date 8 |
|
|
|
Book 8 In-Service Date |
Date 8 |
|
|
|
Book 8 Curr Depr Yr |
Numeric 2 |
99 |
|
|
Book 8 Days/Pds Remaining |
Numeric 3 |
999 |
|
|
Book 8 Amt Taken Purch YTD |
Numeric 14, 2 |
999999999999.99 |
|
|
(This is not displayed as a field on the screen) |
Numeric 14, 2 |
999999999999.99 |
ASSET_OTH_BK_DEPR.B8_DP_DEPR_NY_AMT |
|
!BOOK9 |
|
|
|
|
Book 9 Depr Method Code |
Character 6 |
|
|
|
Book 9 Useful Life |
Numeric 4 |
9999 |
|
|
Book 9 Auto Calc Depr |
Character 1 |
|
“Y” (Yes) or “N” (No) |
|
Book 9 Salvage Percent |
Numeric 7,6 |
9999999.999999 |
Maximum value = 100 |
|
Book 9 Salvage Value |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 9 FYTD Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 9 Prior FY Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 9 Current Pd Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 9 Annual Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 9 Total Cost |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 9 Depr Start Date |
Date 8 |
|
|
|
Book 9 In-Service Date |
Date 8 |
|
|
|
Book 9 Curr Depr Yr |
Numeric 2 |
99 |
|
|
Book 9 Days/Pds Remaining |
Numeric 3 |
999 |
|
|
Book 9 Amt Taken Purch YTD |
Numeric 14, 2 |
999999999999.99 |
|
|
(This is not displayed as a field on the screen) |
Numeric 14, 2 |
999999999999.99 |
ASSET_OTH_BK_DEPR.B9_DP_DEPR_NY_AMT |
|
!BOOK10 |
|
|
|
|
Book 10 Depr Method Code |
Character 6 |
|
|
|
Book 10 Useful Life |
Numeric 4 |
9999 |
|
|
Book 10 Auto Calc Depr |
Character 1 |
|
“Y” (Yes) or “N” (No) |
|
Book 10 Salvage Percent |
Numeric 7,6 |
9999999.999999 |
Maximum value = 100 |
|
Book 10 Salvage Value |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 10 FYTD Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 10 Prior FY Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 10 Current Pd Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 10 Annual Depreciation |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 10 Total Cost |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 10 Depr Start Date |
Date 8 |
|
|
|
Book 10 In-Service Date |
Date 8 |
|
|
|
Book 10 Curr Depr Yr |
Numeric 2 |
99 |
|
|
Book 10 Days/Pds Remaining |
Numeric 3 |
999 |
|
|
Book 10 Amt Taken Purch YTD |
Numeric 14, 2 |
999999999999.99 |
|
|
(This is not displayed as a field on the screen) |
Numeric 14, 2 |
999999999999.99 |
ASSET_OTH_BK_DEPR.B10_DP_DEPR_NY_AMT |
|
ASSET OTHER INFO/ASSET BOOKS DISPOSAL Row Format: |
|
|
One row per asset |
|
Input Row |
Numeric 10 |
9999999999 |
|
|
Record Type |
Character 1 |
|
“O” = Other |
|
Asset ID |
Character 10 |
|
|
|
Item No |
Numeric 5 |
99999 |
|
|
Notes |
Character 254 |
|
|
|
Year Built |
Numeric 4 |
9999 |
|
|
Nat Stock No |
Character 20 |
|
|
|
Govt Field 1 |
Character 30 |
|
|
|
Govt Field 2 |
Character 30 |
|
|
|
Govt Field 3 |
Character 30 |
|
|
|
Govt Field 4 |
Character 30 |
|
|
|
Govt Field 5 |
Character 30 |
|
|
|
Govt Field 6 |
Character 30 |
|
|
|
Govt Field 7 |
Character 30 |
|
|
|
Govt Field 8 |
Character 30 |
|
|
|
Govt Field 9 |
Character 30 |
|
|
|
Govt Field 10 |
Character 30 |
|
|
|
Govt Field 11 |
Character 30 |
|
|
|
Govt Field 12 |
Character 30 |
|
|
|
Govt Field 13 |
Character 30 |
|
|
|
Govt Field 14 |
Character 30 |
|
|
|
Govt Field 15 |
Character 30 |
|
|
|
G/L Book Depr Adj Amount |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 2 Depr Adj |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 3 Depr Adj |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 4 Depr Adj |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 5 Depr Adj |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 6 Depr Adj |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 7 Depr Adj |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 8 Depr Adj |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 9 Depr Adj |
Numeric 14, 2 |
999999999999.99 |
|
|
Book 10 Depr Adj |
Numeric 14, 2 |
999999999999.99 |
|
|
!UDEF (User Defined Tables) Row Format |
|
|
No row or multiple rows per asset |
|
Input Row |
Numeric 10 |
9999999999 |
|
|
Record Type |
Character 1 |
|
“U” = User Defined |
|
Asset ID |
Character 10 |
|
|
|
Item No |
Numeric 5 |
99999 |
|
|
Text Value |
Character 30 |
|
GENL_UDEF.UDEF_TXT |
|
Validated Text Value |
Character 20 |
|
GENL_UDEF.UDEF_ID |
|
Date Value |
Date 8 |
|
GENL_UDEF.IDEF_DT |
|
Numeric Value |
Numeric 14, 2 |
999999999999.99 |
GENL_UDEF.UDEF_AMT |
|
Label |
Character 20 |
|
UDEF_LBL.UDEF_LBL |