Table 18123253 EOS Arch. Purch. Req. Header

Table 18123253 EOS Arch. Purch. Req. Header

Fields

EOS Worksheet Template Name (1)

Code[10]

TableRelation: "Req. Wksh. Template"

Worksheet Template Name

EOS Journal Batch Name (2)

Code[10]

TableRelation: "Requisition Wksh. Name".Name WHERE("Worksheet Template Name" = FIELD("EOS Worksheet Template Name"))

Journal Batch Name

EOS Description (6)

Text[50]

Description

EOS Original Vendor No. (9)

Code[20]

TableRelation: Vendor

Original Vendor No.

EOS Status (11)

Option

Open (0) , "Awaiting Approval" (1) , Approved (2) , Closed (3)

Status: it can be Open, Completed,Approved,Close

EOS Location Code (17)

Code[10]

TableRelation: Location

Location Code

EOS Applier (21)

Code[20]

TableRelation: Resource

Applier

EOS No. (100)

Code[20]

No.

EOS Approval Level (105)

Integer

Approval Level

EOS Creation Date (110)

Date

Creation Date

EOS Comment (115)

Boolean

FieldClass: FlowField

CalcFormula: Exist("EOS Purch. Comment Line" WHERE("EOS Document Type" = CONST("Arch. Purch. Request"), "EOS No." = FIELD("EOS No.")))

Comment

EOS Vendor Name (120)

Text[100]

Vendor Name

EOS Vendor Name 2 (125)

Text[50]

Vendor Name 2

EOS No. Series (130)

Code[20]

TableRelation: "No. Series"

No. Series

EOS User ID (135)

Code[50]

TableRelation: User."User Name"

User ID

EOS Dimension Code (140)

Code[20]

TableRelation: Dimension

Dimension Code

EOS Dimension Value (145)

Code[20]

Dimension Value

EOS Amount LCY (150)

Decimal

FieldClass: FlowField

CalcFormula: sum("EOS Archived Purch. Req. Line"."EOS Cost Amount" where("EOS Purch. Requisition No." = field("EOS No.")))

Amount LCY

EOS Has Blanket Order (155)

Option

No (0) , Yes (1) , " " (2)

Has Blanket Order

Shortcut Dimension 1 Code (180)

Code[20]

TableRelation: "Dimension Value".Code WHERE("Global Dimension No." = CONST(1), Blocked = CONST(false))

Shortcut Dimension 2 Code (185)

Code[20]

TableRelation: "Dimension Value".Code WHERE("Global Dimension No." = CONST(2), Blocked = CONST(false))

Dimension Set ID (480)

Integer

TableRelation: "Dimension Set Entry"

EOS Fully Archived (1000)

Boolean

FieldClass: FlowField

CalcFormula: - Exist("EOS Purch. Request Header" WHERE("EOS No." = FIELD("EOS No.")))

Fully Archived

EOS Job No. (18004287)

Code[20]

TableRelation: Job

Job No.

EOS Document Class Code (18123252)

Code[10]

TableRelation: "EOS046 PRQ Document Class"."Document Class Code"

Methods

GetCaption

procedure GetCaption(AdditionalText: Text[1024]) ResultText: Text[100]

Concatenate the Archived Purcase Request No with the descripion

Parameters / Return Value

  • AdditionalText Text[1024]

    Text[1024]: Additional text to add into the caption

  • Returns Text[100]

    Text: Concatenated text (Max 100 character)

ShowDocDim

procedure ShowDocDim()

Events

OnBeforeShowDocDim

local procedure OnBeforeShowDocDim(var ArchPurchReqHeader: Record "EOS Arch. Purch. Req. Header"; xArchPurchReqHeader: Record "EOS Arch. Purch. Req. Header"; var IsHandled: Boolean)

Parameters / Return Value

  • ArchPurchReqHeader Record "EOS Arch. Purch. Req. Header"

  • xArchPurchReqHeader Record "EOS Arch. Purch. Req. Header"

  • IsHandled Boolean


EOS Labs -