Table "Job Archive"

ID 5135
Namespace: Microsoft.Projects.Project.Archive

Properties

Name Value
Caption Project Archive
DataCaptionFields 1,3,5047
DrillDownPageID Page Microsoft.Projects.Project.Archive."Job Archive List"
LookupPageID Page Microsoft.Projects.Project.Archive."Job Archive List"
DataClassification CustomerContent

Fields

Name Type Description
"No." Code[20]
"Search Description" Code[100]
Description Text[100]
"Description 2" Text[50]
"Bill-to Customer No." Code[20]
"Creation Date" Date
"Starting Date" Date
"Ending Date" Date
Status Enum Microsoft.Projects.Project.Job."Job Status"
"Person Responsible" Code[20]
"Global Dimension 1 Code" Code[20]
"Global Dimension 2 Code" Code[20]
"Job Posting Group" Code[20]
Blocked Enum Microsoft.Projects.Project.Job."Job Blocked"
"Last Date Modified" Date
Comment Boolean
"Customer Disc. Group" Code[20]
"Customer Price Group" Code[10]
"Location Code" Code[10]
"Bin Code" Code[20]
"Language Code" Code[10]
"Scheduled Res. Qty." Decimal
"Resource Filter" Code[20]
"Posting Date Filter" Date
"Resource Gr. Filter" Code[20]
"Scheduled Res. Gr. Qty." Decimal
"Bill-to Name" Text[100]
"Bill-to Address" Text[100]
"Bill-to Address 2" Text[50]
"Bill-to City" Text[30]
"Bill-to County" Text[30]
"Bill-to Post Code" Code[20]
"No. Series" Code[20]
"Bill-to Country/Region Code" Code[10]
"Bill-to Name 2" Text[50]

Specifies an additional part of the name of the customer who pays for the project.

"Task Billing Method" Enum Microsoft.Projects.Project.Setup."Task Billing Method"
Reserve Enum Microsoft.Inventory.Tracking."Reserve Method"
Image Media
"Ship-to Phone No." Text[30]
"WIP Method" Code[20]
"Currency Code" Code[10]
"Bill-to Contact No." Code[20]
"Bill-to Contact" Text[100]
"Planning Date Filter" Date
"WIP Posting Date" Date
"Invoice Currency Code" Code[10]
"Exch. Calculation (Cost)" Option
"Exch. Calculation (Price)" Option
"Allow Schedule/Contract Lines" Boolean
Complete Boolean
"Next Invoice Date" Date
"Apply Usage Link" Boolean
"WIP Posting Method" Option
"Calc. Recog. Sales Amount" Decimal
"Calc. Recog. Costs Amount" Decimal
"Calc. Recog. Sales G/L Amount" Decimal
"Calc. Recog. Costs G/L Amount" Decimal
"Over Budget" Boolean
"Project Manager" Code[50]
"Sell-to Customer No." Code[20]
"Sell-to Customer Name" Text[100]
"Sell-to Customer Name 2" Text[50]

Specifies an additional part of the name of the customer who will receive the products and be billed by default.

"Sell-to Address" Text[100]
"Sell-to Address 2" Text[50]
"Sell-to City" Text[30]
"Sell-to Contact" Text[100]
"Sell-to Post Code" Code[20]
"Sell-to County" Text[30]
"Sell-to Country/Region Code" Code[10]
"Sell-to Phone No." Text[30]
"Sell-to E-Mail" Text[80]
"Sell-to Contact No." Code[20]
"Ship-to Code" Code[10]
"Ship-to Name" Text[100]
"Ship-to Name 2" Text[50]
"Ship-to Address" Text[100]
"Ship-to Address 2" Text[50]
"Ship-to City" Text[30]
"Ship-to Contact" Text[100]
"Ship-to Post Code" Code[20]
"Ship-to County" Text[30]
"Ship-to Country/Region Code" Code[10]
"No. of Archived Versions" Integer
"Source Doc. Exists" Boolean
"Last Archived Date" DateTime
"External Document No." Code[35]
"Payment Method Code" Code[10]
"Payment Terms Code" Code[10]
"Your Reference" Text[35]
"Interaction Exist" Boolean
"Time Archived" Time
"Date Archived" Date
"Archived By" Code[50]
"Version No." Integer
"Price Calculation Method" Enum Microsoft.Pricing.Calculation."Price Calculation Method"
"Cost Calculation Method" Enum Microsoft.Pricing.Calculation."Price Calculation Method"
"Completely Picked" Boolean
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

Methods

DisplayMap

procedure DisplayMap()

ShouldSearchForCustomerByName

procedure ShouldSearchForCustomerByName(CustomerNo: Code[20]): Boolean

Parameters

Name Type Description
CustomerNo Code[20]

Returns

Type Description
Boolean

ShipToNameEqualsSellToName

procedure ShipToNameEqualsSellToName(): Boolean

Returns

Type Description
Boolean

ShipToAddressEqualsSellToAddress

procedure ShipToAddressEqualsSellToAddress(): Boolean

Returns

Type Description
Boolean

BillToAddressEqualsSellToAddress

procedure BillToAddressEqualsSellToAddress(): Boolean

Returns

Type Description
Boolean

Events

OnAfterShipToAddressEqualsSellToAddress

[IntegrationEvent(False,False)]
local procedure OnAfterShipToAddressEqualsSellToAddress(var JobArchive: Record "Job Archive", var Result: Boolean)

Parameters

Name Type Description
JobArchive Table Microsoft.Projects.Project.Archive."Job Archive"
Result Boolean

See also