Table 18123254 EOS Archived Purch. Req. Line
Obsolete
Removed: Use new table “EOS Purch. Req. Line Archive”, which has a different primary key (19.0)Table 18123254 EOS Archived Purch. Req. Line
Fields
EOS Worksheet Template Name (1)
Code[20]
Worksheet Template Name
EOS Journal Batch Name (2)
Code[10]
Journal Batch Name
EOS Line No. (3)
Integer
Line No.
EOS Type (4)
Option
" " (0) , "G/L Account" (1) , Item (2)
Type: it can be G/L Account,Item
EOS No. (5)
Code[20]
TableRelation: if ("EOS Type" = const("G/L Account")) "G/L Account" else if ("EOS Type" = const(Item)) Item
No.
EOS Description (6)
Text[100]
Description
EOS Description 2 (7)
Text[50]
Description 2
EOS Quantity (8)
Decimal
Quantity
EOS Vendor No. (9)
Code[20]
TableRelation: Vendor
Vendor No.
EOS Direct Unit Cost (10)
Decimal
Direct Unit Cost
EOS Due Date (12)
Date
Due Date
EOS Requester ID (13)
Code[50]
TableRelation: User."User Name"
Requester ID
EOS Confirmed (14)
Boolean
Confirmed
EOS Shortcut Dimension 1 Code (15)
Code[20]
TableRelation: "Dimension Value".Code where("Global Dimension No." = const(1))
Shortcut Dimension 1 Code
EOS Shortcut Dimension 2 Code (16)
Code[20]
TableRelation: "Dimension Value".Code where("Global Dimension No." = const(2))
Shortcut Dimension 2 Code
EOS Location Code (17)
Code[10]
TableRelation: Location where("Use As In-Transit" = const(false))
Location Code
EOS Recurring Method (18)
Option
"Fixed" (1) , Variable (2)
Recurring Method
EOS Expiration Date (19)
Date
Expiration Date
EOS Recurring Frequency (20)
DateFormula
Recurring Frequency
EOS Order Date (21)
Date
Order Date
EOS Vendor Item No. (22)
Text[20]
Vendor Item No.
EOS Sales Order No. (23)
Code[20]
TableRelation: "Sales Header"."No." where("Document Type" = const(Order))
Sales Order No.
EOS Sales Order Line No. (24)
Integer
Sales Order Line No.
EOS Sell-to Customer No. (25)
Code[20]
TableRelation: Customer
Sell-to Customer No.
EOS Ship-to Code (26)
Code[10]
TableRelation: "Ship-to Address".Code where("Customer No." = field("EOS Sell-to Customer No."))
Ship-to Code
EOS Order Address Code (28)
Code[10]
TableRelation: "Order Address".Code where("Vendor No." = field("EOS Vendor No."))
Order Address Code
EOS Currency Code (29)
Code[10]
TableRelation: Currency
Currency Code
EOS Currency Factor (30)
Decimal
Currency Factor
EOS Reserved Quantity (31)
Decimal
Reserved Quantity
EOS Dimension Set ID (480)
Integer
TableRelation: "Dimension Set Entry"
Dimension Set ID
EOS Prod. Order No. (5401)
Code[20]
TableRelation: "Production Order"."No." where(Status = const(Released))
Prod. Order No.
EOS Variant Code (5402)
Code[10]
TableRelation: if ("EOS Type" = const(Item)) "Item Variant".Code where("Item No." = field("EOS No."))
Variant Code
EOS Bin Code (5403)
Code[20]
TableRelation: Bin.Code where("Location Code" = field("EOS Location Code"), "Item Filter" = field("EOS No."), "Variant Filter" = field("EOS Variant Code"))
Bin Code
EOS Qty. per Unit of Measure (5404)
Decimal
Qty. per Unit of Measure
EOS Unit of Measure Code (5407)
Code[10]
TableRelation: if ("EOS Type" = const(Item)) "Item Unit of Measure".Code where("Item No." = field("EOS No.")) else "Unit of Measure"
Unit of Measure Code
EOS Quantity (Base) (5408)
Decimal
Quantity (Base)
EOS Reserved Qty. (Base) (5431)
Decimal
Reserved Qty. (Base)
EOS Demand Type (5520)
Integer
TableRelation: AllObj."Object ID" where("Object Type" = const(Table))
Demand Type
EOS Demand Subtype (5521)
Option
"0" (0) , "1" (1) , "2" (2) , "3" (3) , "4" (4) , "5" (5) , "6" (6) , "7" (7) , "8" (8) , "9" (9)
Demand Subtype
EOS Demand Order No. (5522)
Code[20]
Demand Order No.
EOS Demand Line No. (5525)
Integer
Demand Line No.
EOS Demand Ref. No. (5526)
Integer
Demand Ref. No.
EOS Status (5527)
Option
"0" (0) , "1" (1) , "2" (2) , "3" (3) , "4" (4) , "5" (5) , "6" (6) , "7" (7) , "8" (8) , "9" (9) , "10" (10)
Status
EOS Demand Date (5530)
Date
Demand Date
EOS Demand Quantity (5532)
Decimal
Demand Quantity
EOS Demand Quantity (Base) (5533)
Decimal
Demand Quantity (Base)
EOS Needed Quantity (5538)
Decimal
Needed Quantity
EOS Needed Quantity (Base) (5539)
Decimal
Needed Quantity (Base)
EOS Reserve (5540)
Boolean
Reserve
EOS Qty. per UOM (Demand) (5541)
Decimal
Qty. per UOM (Demand)
EOS Unit Measure Code (Demand) (5542)
Code[10]
TableRelation: if ("EOS Type" = const(Item)) "Item Unit of Measure".Code where("Item No." = field("EOS No."))
Unit Measure Code (Demand)
EOS Supply From (5552)
Code[20]
TableRelation: if ("EOS Replenishment System" = const(Purchase)) Vendor else if ("EOS Replenishment System" = const(Transfer)) Location where("Use As In-Transit" = const(false))
Supply From
EOS Original Item No. (5553)
Code[20]
TableRelation: Item
Original Item No.
EOS Original Variant Code (5554)
Code[10]
TableRelation: "Item Variant".Code where("Item No." = field("EOS Original Item No."))
Original Variant Code
EOS Level (5560)
Integer
Level
EOS Demand Qty. Available (5563)
Decimal
Demand Qty. Available
EOS User ID (5590)
Code[50]
TableRelation: User."User Name"
User ID
EOS Item Category Code (5701)
Code[20]
TableRelation: if ("EOS Type" = const(Item)) "Item Category"
Item Category Code
EOS Nonstock (5702)
Boolean
Nonstock
EOS Purchasing Code (5703)
Code[10]
TableRelation: Purchasing
Purchasing Code
EOS Product Group Code (5705)
Code[10]
Obsolete
Removed: Product Groups became first level children of Item Categories. ()Product Group Code
EOS Transfer-from Code (5706)
Code[10]
TableRelation: Location where("Use As In-Transit" = const(false))
Transfer-from Code
EOS Transfer Shipment Date (5707)
Date
Transfer Shipment Date
EOS Line Discount % (7002)
Decimal
Line Discount %
EOS Discount Text (7003)
Text[30]
Discount Text
EOS Standard Task Code (12180)
Code[10]
TableRelation: "Standard Task"
Standard Task Code
EOS WIP Item (12183)
Boolean
WIP Item
EOS UoM for Pricelist (12184)
Code[10]
TableRelation: "Unit of Measure"
UoM for Pricelist
EOS Pricelist Cost (12187)
Decimal
Pricelist Cost
EOS Purch. Requisition No. (18004280)
Code[20]
TableRelation: "EOS Arch. Purch. Req. Header"."EOS No."
Purch. Requisition No.
EOS Document Type (18004281)
Option
Quote (0) , "Order" (1) , Invoice (2) , "Credit Memo" (3) , "Blanket Order" (4) , "Return Order" (5)
Document Type it can be: Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order
EOS Document No. (18004282)
Code[20]
TableRelation: "Purchase Header"."No." where("Document Type" = field("EOS Document Type"))
Document No.
EOS Document Line No. (18004283)
Integer
TableRelation: "Purchase Line"."Line No." where("Document Type" = field("EOS Document Type"), "Document No." = field("EOS Document No."))
Document Line No.
EOS Selected (18004284)
Boolean
Selected
EOS Last Update Source (18004286)
RecordId
Last Update Source
EOS Job No. (18004287)
Code[20]
TableRelation: Job
Job No.
EOS Routing No. (99000750)
Code[20]
TableRelation: "Routing Header"
Routing No.
EOS Operation No. (99000751)
Code[10]
TableRelation: "Prod. Order Routing Line"."Operation No." where(Status = const(Released), "Prod. Order No." = field("EOS Prod. Order No."), "Routing No." = field("EOS Routing No."))
Operation No.
EOS Work Center No. (99000752)
Code[20]
TableRelation: "Work Center"
Work Center No.
EOS Prod. Order Line No. (99000754)
Integer
TableRelation: "Prod. Order Line"."Line No." where(Status = const(Finished), "Prod. Order No." = field("EOS Prod. Order No."))
Prod. Order Line No.
EOS MPS Order (99000755)
Boolean
MPS Order
EOS Planning Flexibility (99000756)
Option
Unlimited (0) , "None" (1)
Planning Flexibility: it can be Unlimited,None
EOS Routing Reference No. (99000757)
Integer
Routing Reference No.
EOS Gen. Prod. Posting Group (99000882)
Code[20]
TableRelation: "Gen. Product Posting Group"
Gen. Prod. Posting Group
EOS Gen. Bus. Posting Group (99000883)
Code[20]
TableRelation: "Gen. Business Posting Group"
Gen. Bus. Posting Group
EOS Low-Level Code (99000884)
Integer
Low-Level Code
EOS Prod. BOM Version Code (99000885)
Code[20]
TableRelation: "Production BOM Version"."Version Code" where("Production BOM No." = field("EOS Production BOM No."))
Prod. BOM Version Code
EOS Routing Version Code (99000886)
Code[20]
TableRelation: "Routing Version"."Version Code" where("Routing No." = field("EOS Routing No."))
Routing Version Code
EOS Routing Type (99000887)
Option
Serial (0) , Parallel (1)
Routing Type
EOS Original Quantity (99000888)
Decimal
Original Quantity
EOS Finished Quantity (99000889)
Decimal
Finished Quantity
EOS Remaining Quantity (99000890)
Decimal
Remaining Quantity
EOS Original Due Date (99000891)
Date
Original Due Date
EOS Scrap % (99000892)
Decimal
Scrap %
EOS Starting Date (99000894)
Date
Starting Date
EOS Starting Time (99000895)
Time
Starting Time
EOS Ending Date (99000896)
Date
Ending Date
EOS Ending Time (99000897)
Time
Ending Time
EOS Production BOM No. (99000898)
Code[20]
TableRelation: "Production BOM Header"."No." where(Status = const(Certified))
Production BOM No.
EOS Indirect Cost % (99000899)
Decimal
Indirect Cost %
EOS Overhead Rate (99000900)
Decimal
Overhead Rate
EOS Unit Cost (99000901)
Decimal
Unit Cost
EOS Cost Amount (99000902)
Decimal
Cost Amount
EOS Replenishment System (99000903)
Option
Purchase (0) , "Prod. Order" (1) , Transfer (2) , Quote (10)
Replenishment System
EOS Ref. Order No. (99000904)
Code[20]
TableRelation: if ("EOS Ref. Order Type" = const("Prod. Order")) "Production Order"."No." where(Status = field("EOS Ref. Order Status")) else if ("EOS Ref. Order Type" = const(Purchase)) "Purchase Header"."No." where("Document Type" = const(Order)) else if ("EOS Ref. Order Type" = const(Transfer)) "Transfer Header"."No." where("No." = field("EOS Ref. Order No."))
Ref. Order No.
EOS Ref. Order Type (99000905)
Option
" " (0) , Purchase (1) , "Prod. Order" (2) , Transfer (3)
Ref. Order Type
EOS Ref. Order Status (99000906)
Option
Planned (1) , "Firm Planned" (2) , Released (3)
Ref. Order Status
EOS Ref. Line No. (99000907)
Integer
Ref. Line No.
EOS No. Series (99000908)
Code[20]
TableRelation: "No. Series"
No. Series
EOS Exp. Operation Cost Amt. (99000909)
Decimal
Exp. Operation Cost Amt.
EOS Exp. Component Cost Amt. (99000910)
Decimal
Exp. Component Cost Amt.
EOS Finished Qty. (Base) (99000911)
Decimal
Finished Qty. (Base)
EOS Remaining Qty. (Base) (99000912)
Decimal
Remaining Qty. (Base)
EOS Related to Planning Line (99000913)
Integer
Related to Planning Line
EOS Planning Level (99000914)
Integer
Planning Level
EOS Planning Line Origin (99000915)
Option
" " (0) , "Action Message" (1) , Planning (2) , "Order Planning" (3)
Planning Line Origin: it can be Action Message,Planning,Order Planning
EOS Action Message (99000916)
Option
" " (0) , New (1) , "Change Qty." (2) , Reschedule (3) , "Resched. & Chg. Qty." (4) , Cancel (5)
Action Message: it can be New,Change Qty.,Reschedule,Resched. & Chg. Qty.,Cancel`
EOS Accept Action Message (99000917)
Boolean
Accept Action Message
EOS Net Quantity (Base) (99000918)
Decimal
Net Quantity (Base)
EOS Starting Date-Time (99000919)
DateTime
Starting Date-Time
EOS Ending Date-Time (99000920)
DateTime
Ending Date-Time
EOS Order Promising ID (99000921)
Code[20]
Order Promising ID
EOS Order Promising Line No. (99000922)
Integer
Order Promising Line No.
EOS Order Promising Line ID (99000923)
Integer
Order Promising Line ID
Methods
CalcLineAmount
procedure CalcLineAmount(): Decimal
Calc the line amount of curernt record
Parameters / Return Value
Returns
DecimalDecimal: the line amount
LookupShortcutDimCode
procedure LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])
Lookup Shortcut Dimension Code
Parameters / Return Value
FieldNumber
IntegerInteger
ShortcutDimCode
Code[20]Code[20]
ShowShortcutDimCode
procedure ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
Show Shortcut Dimension Code
Parameters / Return Value
ShortcutDimCode
Code[20]Code[20]
ShowDimensions
procedure ShowDimensions()
Show Dimensions
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.