Appendix: Field Derivations for the Billing Detail Workfile (F4812)

This appendix lists the tables that are used to derive information for creating transactions in the Billing Detail Workfile table (F4812) and the specific source of each field in the Billing Detail Workfile table.

Click to jump to parent topicTables Used by the Billing Detail Workfile

This list of table IDs and names identifies the sources specified in the subsequent table:

Table ID

Table Name

F0005

User Defined Codes

F0006

Business Unit Master

F0014

Payment Terms

F0101

Address Book Master

F0411

Accounts Payable Ledger

F06116

Employee Transaction Detail File

F0618

Employee Transaction History

F0724

Burden Distribution File

F069116

Payroll Transaction Constants

F0901

Account Master

F0911

Account Ledger

F1201

Asset Master File

F4111

Item Ledger File

F4311

Purchase Order Detail File

F4801

Work Order Master File

F48091

Billing System Constants

F48096

Billing Rate / Mark up Table

F4812

Billing Detail Workfile

F48127

Tax Derivation Information

F48S80

Segment Definition

F48S81

Burden Computation Method

F48S82

Burden Base Rules

F48S84

Pool Grouping Codes

F48S85

Burden Rates

F5201

Contract Master

F5202

Contract Billing Line Detail

F5212

T and M, Unit Price and Lumpsum Cross Reference Accounts

Click to jump to parent topicBilling Detail Workfile Field Sources

This table shows the source of the information for each field in the Billing Detail Workfile table (F4812). For many fields, the source depends on specific conditions and other retrieval information.

Data Item in the F4812 table

Conditions and Retrieval Information

Data Item/Source Table

WDAA (Amount)

Default

GLAA/F0911

 

GLDCT (Document Type) field in the F0911 record contains T2.

YTGPA (Gross Pay)/F0618 or F06116

 

GLDCT field in the F0911 record contains T2. The transaction relates to labor burden.

YSBDA (Burden Amount)/F0724

 

GLDCT field in the F0911 record contains T4.

YTRCPY (Recharge Amount)/F0618 or F06116

 

GLDCT field in the F0911 contains T5.

YTEQGR (Equipment Gross)/F0618 or F06116

WDAA2 (Foreign Cost Amount)

Currency is on.

Calculated

WDAA3 (Amount)

Burdening transactions

Calculated

WDACL0 (Rate Group)

GLASID (Serial Number) field in the F0911 record is not blank.

FAACL0/F1201

WDACR (Amount - Currency)

Burdening transactions

Calculated

WDADCI (Invoice Markup Amount)

WQGTYP (Generation Type) field in the F48096 record contains 1.

WQAA (Amount)/F48096

WDADCR (Revenue Markup)

WQGTYP (Generation Type) field in the F48096 record contains 2.

WQAA (Amount)/F48096

WDAGS (Suspend Aging)

 

Not used

WDAID (Account ID)

Default

GLAID/F0911

WDAID5 (Account ID)

Contract Billing

G6MCU, G6OBJ, and G6SUB (Business Unit, Object, and Subsidiary)/F5202

 

G6ACCO (Account Override Flag) field in the F5202 record is blank.

 

WDAID6 (Account ID)

 

Not used

WDAN8 (Address Number)

Default.

GLAN8/F0911

 

GLDCT (Document Type) field in the F0911 record contains T2, T4, or T5.

YTAN8/F0618 or F06116

WDAN8O (Customer/Receivable Address Number)

Default

MCAN80 for the related business unit/F0006

 

GLMCU (Business Unit) field in the F0911 record.

 
 

GLSBL (Subledger) field in the F0911 record is not blank.

WAAN8 (Address Number) for the related subledger/F4801

 

GLSBLT (Subledger Type) field in the F0911 record contains W.

 
 

WZCNBS (Customer Number Basis) field in the F48091 record contains 1.

 
 

Contract Billing

G4AN80/F5201

WDAREX (Exempt from Bill when Paid)

Contract Billing

WDAREX/F4812

WDBBF (Billing Basis Flag)

Default to 1 from Data Dictionary.

Not Used

WDBCI (Billing Control ID)

 

Automatically assigned with the Next Numbers facility (system 48. index 02)

WDBCTK (Batch Control Key)

 

Not Used

WDBDPN (Burden Pending)

 

Automatically assigned

WDBLKK (Block of Composition Key)

 

Not used

WDBPTX (Base Pay Transaction Number)

Stores the link between the base pay and the component pay records. Only valid on component pay transactions.

Derived from Payroll transactions (F06116 or F0618 table).

WDBRT (Revenue Rate)

WQGTYP (Generation Type) field in the F48096 record contains 2.

WQBRT (Billing Rate)/F48096

WDBRTI (Invoice Rate)

WQGTYP field in the F48096 record contains 1.

WQBRT/F48096

WDBTOL (Total Billed Amount)

 

Automatically calculated

WDBUF (Burdening Used Flag)

The base record has burdening transactions associated with it or the record is a burdening transaction.

Automatically assigned

WDCAP (Cap or Override Rate)

WQGTYP (Generation Type) field in the F48096 record contains 2.

WQCAP/F48096

WDCAP1 (Cap or Override Rate)

WQGTYP (Generation Type) field in the F48096 record contains 1.

WQCAP/F48096

WDCBLC (Coding Block Change)

 

Automatically assigned

WDCCOD (Component Code)

 

AFCCOD/F4860

For burdening transactions, this is the burden category from the segment from the F48S80 table.

WDCCR (Component Cost Rate Table)

WQCCR field in the F48096 record is not blank.

WQCCR/F48096

WDCIDS (Foreign Invoice Discount)

 

Calculated

WDCINR (Component Invoice Rate Table)

WQCINR field in the F48096 record is not blank.

WQCINR/F48096

WDCITA (Foreign Invoice Taxable Amount)

 

Calculated

WDCITL (Foreign Invoice Amount)

 

Calculated

WDCITX (Foreign Invoice Tax)

 

Calculated

WDCLNK (Component Link)

Components or burdening or both are attached.

Automatically assigned

WDCO (Company)

 

GLCO/F0911

WDCOCH (Contract Change Order Number)

Contract Billing

G6COCH/F5202

WDCPGP (Customer Price Group

 

Not Used

WDCRCD (Currency Code)

GLCO (Company) field in the F0911 record. Currency is on.

CCCRCD (Base Currency) / F0010 derived from the company of the business unit

WDCRCE (Currency Code)

Currency is on.

CCCRCD (Base Currency) / F0010 derived from the company of the business unit

WDCRCF (Currency Code)

Currency is on.

For Service Billing; AICRCD/F03012

For Contract Billing G4CRCD/F5201

WDCRR (Exchange Rate)

Currency is on.

Automatically assigned

WDCRRD (Exchange Rate - Divisor)

Currency is on.

Automatically assigned

WDCRRM (Mode F)

Currency is on.

For Service Billing; WZCRRM/F48091

For Contract Billing; G4CRRM/F5201

WDCRVR (Component Revenue Rate)

WQGTYP (Generation Type) field in the F48096 record contains 2.

WQCRVR/F48096

WDCTRY (Century)

 

GLCTRY/F0911

WDDAGO (Age Override Date - B)

 

WDDAGO

WDDC (Description Compr)

YTAN8 (Address Number) field in either the F0618 or F06116 record.

ABDC/F0101

WDDCP (Discount Percent)

WDAN80

PNDCP/F0014

 

(Customer/Receivable Address Number) field in the F4812 record.

 
 

ABATR (Receivable Y/N) field in the F0101 contains Y.

 

WDDCT (Document Type)

 

GLDCT/F0911

WDDCTI (Document Type)

Contract Billing

When Invoices are created.

Processing option for the Invoice Generation program (R52121)

 

Service Billing

When invoices are created.

Processing option for the Invoice Generation program (R48121)

WDDCTO (Order Type)

Contract Billing

G6DCTO/F5202

WDDEJ (Date Entered)

 

Automatically assigned

WDDGJ (G/L Date)

Contract Billing

When invoices are created.

Processing option for the Invoice Generation program (R52121)

 

Service Billing

When invoices are created.

Processing option for the Invoice Generation program (R48121)

WDDGL (G/L Date)

 

GLDGJ (G/L Date)/F0911

WDDI (Invoice Date)

GLICUT (Batch Type) field in the F0911 record contains V or W.

RPDGJ (G/L Date)/F0411

WDDOC (Document Number)

 

GLDOC/F0911

WDDOCM (Payment /Item Number)

 

Not used

WDDOCO (Order Number)

Contract Billing

G6DOCO/F5202

WDDOCZ (Order Number)

When invoices are created.

Automatically assigned with the Next Numbers facility (system 03. index 01)

WDDSVJ (Service/Tax Date)

Default.

GLDSVJ/F0911

 

GLICUT field contains V.

RPDSVJ/F0411

 

GLDSVJ and RPDSVJ fields are blank.

ILTRDJ (Order Date)/F4111

WDDWNL (Download Flag)

 

Automatically assigned.

WDELGC (Eligibility Code)

Default.

GMBILL (Billable - Y/N)/F0901

 

GLMCU, GLOBJ and GLSUB (Business Unit, Object Account, and Subsidiary) fields in the F0911 record.

 
 

Burden

GMBILL/F0901

 

YSMCU, YSOBJ, and YSSUB (Business Unit, Object Account, and Subsidiary) fields in the F0724 record.

 
 

WZPRRR (Journal Generation Control) field in the F48091 record contains 3 or 4. GMBILL field in the F0901 record contains 1, 2, 3, or 4.

GMBILL/F0901

 

WZPRRR field contains 3 or 4.

GMBILL/F0901

 

WZPRRR field in the F48091 record does not contain 3 or 4.

WZPRRR/F48091

WDEQCG (Equipment Worked)

GLDCT (Document Type) field in the F0911 record contains TE.

GLASID (Serial Number)/F0911

 

GLDCT field contains T5.

YTEQCG/F0618 or F06116

 

GLDCT field does not contain TE, T2, T4,or T5.

Blank

WDEQWO (Equipment Worked On)

GLDCT field contains TE.

Blank

 

GLDCT field contains T5.

YTEQWO/F0618 or F06116

 

GLDCT field does not contain TE, T2, T4, or T5.

GLASID (Serial Number)/F0911

WDERC (Equipment Rate Code)

GLDCT field contains TE.

GLALTY (ID Type)/F0911

 

GLDCT field contains T5.

YTERC/F0618 or F06116

 

GLDCT field does not contain TE, T2, T4, or T5.

Blank

WDERDB (Exchange Rate Date Basis)

Currency is on.

WZERDB / F48091

WDERDT (Date - Exchange Rate)

Currency is on.

Assigned based on Exchange Rate Date Basis

WDEXA (Explanation - Name A)

Default.

GLEXA/F0911

 

GLDCT field contains T2, T4, or T5.

ABALPH (Alpha Name)/F0101

 

YTAN8 (Address Number) field in either the F0618 or F06116 record.

 

WDEXR (Explanation - Remark)

WQEXR field in the F48096 record is blank.

GLEXR/F0911

 

GLDCT field does not contain T2, T4, or T5.

 
 

WQEXR field in the F48096 record is blank.

YTEXR/F0618 or F06116

 

GLDCT field contains T2, T4, or T5.

 
 

WQEXR field in the F48096 record is not blank.

WQEXR/F48096

 

Burden. Of these conditions, the one that the system finds first determines the source:

 
 

A) YSFRTY (Fringe Type) field in the F0724 record contains FB.

DRDL01 (Description) related to the fringe type /F0005

 

B) YSPTAX (Tax Type) field in the F0724 record is not blank.

DRDL01 related to the tax type/F0005

 

C) YSPDBA (PDBA Code) field in the F0724 record is greater than zero.

YCDL01/F069116

 

YCDL01 field in the F069116 record is not blank.

YCEXA (Explanation - Name A)/F069116

 

YCDL01 field in the F069116 record is blank.

 

WDEXR1 (Tax Explanation Code)

Contract Billing

G6EXR1/F5202 or processing option override from Invoice Generation (R52121)

 

Service Billing

WOEXR1/F48127

WDFBAS (Invoice Fee Basis)

 

Not Used

WDFEA (Foreign Extended Price)

 

Not Used

WDFRTN (Foreign Retainable)

Currency is on.

Calculated

WDFTOL (Foreign Total Billed)

Currency is on.

Calculated

WDFY (Fiscal Year)

 

GLFY/F0911

WDGLC (G/L Offset)

Service Billing: F48127

Contract Billing: F5202

F48127/F5202

WDHBIN (Historical Burdened Invoice Amount)

Populated on burdening records only.

Invoice amount in the F52G11 table.

WDHBRV (Historical Burdened Revenue Amount)

Populated on burdening records only.

Revenue amount in the F52G11 table.

WDHBTL (Revenue Amount - Historical)

When billing and base currency codes are different and the workfile exchange rate and invoice exchange rate are different, the system populates HBTL, HITL, HITX and HTAM with the workfile amounts prior to calculating the invoice with the new exchange rate.

Calculated

WDHITL (Total Invoiced Amount - Historical)

When billing and base currency codes are different and the workfile exchange rate and invoice exchange rate are different, the system populates HBTL, HITL, HITX and HTAM with the workfile amounts prior to calculating the invoice with the new exchange rate.

Calculated

WDHITX (Invoice Taxable Amount - Historical)

When billing and base currency codes are different and the workfile exchange rate and invoice exchange rate are different, the system populates HBTL, HITL, HITX and HTAM with the workfile amounts prior to calculating the invoice with the new exchange rate.

Calculated

WDHLD (Hold Code)

 

User Assigned

WDHMCU (Home Business Unit)

Default

GLHMCU/F0911

 

GLHMCU is blank.

FAMCU (Business Unit) related to the serial number/F1201

 

GLDCT (Document Type) field in the F0911 record does not contain T2, T4, or T5.

 
 

GLMCU field is blank.

 
 

GLASID (Serial Number) field in the F0911 record.

 
 

GLHMCU is blank.

RPMCU/F0411

 

GLICUT field contains either V or W.

 
 

GLDOC, GLDCT, and GLKCO fields.

 
 

GLHMCU is blank.

MCMCUS (Project Number)/F0006

 

GLICUT field contains G.

 
 

GLMCU in the F0911 record.

 
 

GLDCT contains T2, T4, or T5.

YTHMCU/F0618 or F06116

WDHTAM (Historical Tax Information)

When billing and base currency codes are different and the workfile exchange rate and invoice exchange rate are different, the system populates HBTL, HITL, HITX and HTAM with the workfile amounts prior to calculating the invoice with the new exchange rate.

Calculated

WDICU (Batch Number)

Assigned when invoice is created.

Automatically assigned with the Next Numbers facility (system 00. index 01)

WDICUA (Active Batch Number)

Assigned when invoice or revenue is created.

Automatically assigned with the Next Numbers facility (system 00. index 01)

WDICUJ (Revenue Batch Number)

Assigned when revenue is created.

Automatically assigned with the Next Numbers facility (system 00. index 01)

WDIDGJ (Invoice G/L Date)

Inv G/L Date assigned when invoice is created.

 

WDIDSC (Invoice Discount Amount)

 

Automatically calculated.

WDIJST (Invoice Journal Status)

 

Automatically calculated.

WDITAM (Invoice Tax)

 

Automatically calculated.

WDITM (Item Number (Short))

 

Not Used

WDITOL (Total Invoiced Amount)

 

Automatically calculated.

WDITXA (Invoice Taxable Amount)

 

Automatically calculated.

WDIVD (Invoice Date)

 

Automatically calculated.

WDJBCD (Job Type)

GLDCT (Document Type) field in the F0911 record does not contain T2, T4, or T5.

GLJBCD/F0911

 

GLDCT field contains T2, T4, or T5.

YTJBCD/F0618 or F06116

WDJBST (Job Step)

GLDCT field does not contain T2, T4, or T5.

GLJST/F0911

 

GLDCT field does not contain T2, T4, or T5.

YTJBST/F0618 or F06116

WDJELN (Journal Entry Line Number)

 

GLJELN/F0911

WDJMCU (Host Business Unit)

Default

MCMCUS (Project Number)/F0006

 

Contract Billing.

 
 

GLDCT (Document Type) field in the F0911 record contains T2, T4, or T5.

 
 

G4JMCU field in the F5201 record for the contract is not blank.

G4JMCU/F5201

 

A contract does not exist.

MCMCUS/F0006

WDJOBN (Workstation ID)

 

Automatically assigned.

WDJPGC (Job Pool Grouping Code)

WDMCU (Business Unit) field in the F4812 record.

MCRP12/F0006

WDJRSP (Journal Status Code)

 

Automatically assigned

WDJRST (Journal Status Code)

 

Automatically assigned

WDJTAX (Journaled Tax)

WDEXR1 (Tax Explanation Code) field in the F4812 record contains C, E, or V.

Automatically assigned

 

WDEXR1 field does not contain C, E, or V.

Automatically assigned

WDJTXF (Journaled Tax Foreign)

Currency is on.

Not used

WDKCO (Document Company)

 

GLKCO/F0911

WDKCOI (Document Company)

Contract Billing

G6KCOO/F5202

 

Service Billing

Document of Invoice GLCO/F0911

WDKCOO (Order Number Document Company)

Contract Billing

G6KCOO/F5202

 

Service Billing

GLCO/F0911

WDLNID (Line Number)

Contract Billing

G6LNID/F5202

WDLSPM (Payment Completed)

Revenue has been recognized

Automatically assigned

WDLSSQ (Last Sequence)

Create AR has been performed.

Automatically assigned

WDLT (Ledger Type)

 

GLLT/F0911/AA (Non-T and M - CB)

WDMCU (Business Unit)

Default.

GLMCU/F0911

 

Burden

YSMCU/F0724

WDMKRP (% Fee)

 

Not Used

WDNCTL (NTE Control Flag)

 

Not Used

WDOBJ (Object Account)

Default

GLOBJ/F0911

 

Burden

YSOBJ/F0724

WDODCT (Original Document Type)

 

GLODCT/F0911

WDODOC (Original Document Number)

 

GLODOC/F0911

WDOGNO (Original Line Number)

 

GLLNID (Line Number)/F0911

WDOKCO (Original Order Document)

 

GLOKCO/F0911

WDOPIM (Contract Billing Line)

Contract Billing

G6OPIM/F5202

WDOPSQ (Operations Sequence)

 

GLOPSQ/F0911

WDOSFX (Original Pay Item)

 

GLOSFX/F0911

WDPAID (Extended Cost/Price)

 

Not Used

WDPARS (Parent WO Number)

Retrieved from Work Order Master when Subledger is Completed

WAPARS / F4801

WDPCFG (Burden Flag)

Default

Blank

 

Burden record exists in F0724 table.

Automatically assigned 1

WDPCIM (Percentage)

Generation type is 1.

WQPERT (Percentage)/F48096

WDPCKO (Document Company)

 

GLPKCO (Purchase Order Document Company)/F0911

WDPCTN (Parent Contract Number)

Contract Billing

G4PCTN/F5201

WDPCTT (Parent Contract Type)

Contract Billing

G4PCTT/F5201

WDPDBA (PDBA Code)

Default

Blank

 

GLDCT (Document Type) field in the F0911 record contains T2, T4, or T5.

YTPDBA/F0618 or F06116

 

Burden

YSPDBA/F0724

WDPDCT (Purchase Order Document)

 

GLPDCT/F0911

WDPERT (Percentage)

Generation type is 2.

WQPERT (Percentage)/F48096

WDPID (Program ID)

 

Program name

WDPKCO (Purchase Order Document Company)

 

GLPKCO/F0911

WDPSMQ (Payment Sequence Number)

 

Not used.

WDPN (G/L Period Number)

 

GLPN/F0911

WDPO (P.O. Number)

 

GLPO/F0911

WDPRET (Percent Retainage)

Service Billing

WIPRET/F48127

WDPRGR (Item Price Group)

 

Not Used

WDPRIC (Unit Price)

 

Automatically calculated

WDPRIF (Unit Price - Foreign)

Currency is on and currency codes differ.

Calculated

WDPRSQ (Parent Sequence Number)

 

Automatically assigned

WDPRTF (Printed Flag)

 

Automatically assigned

WDPRTP (Pricing Type)

Populated on all workfile transactions associated with a contract during Workfile Generation.

Derived from the billing line of the contract (PRTP in the F5202 table)

WDPRTR (Transaction Number)

GLDCT (Document Type) field in the F0911 record contains T2, T4, or T5.

YTPRTR/F0618 or F06116

WDPSFX (Purchase Order Suffix)

 

GLPSFX/F0911

WDPTAX (Tax Type)

Default.

Blank

 

Burden.

YSPTAX/F0724

WDPTFG (Pass-Through Invoicing)

 

Not used

WDR001 (Bill Item Code)

 

GMR001 for the account number in the source transaction/F0901

WDR002 (Category Code 002)

 

GMR002 for the account number in the source transaction/F0901

WDR003 (Location)

 

GMR003 for the account number in the source transaction/F0901

WDRAG (Reburdening Adjustment Group)

Reburdening adjustment transactions

Automatically assigned

WDRAS (Reburdening Adjustment Status)

Reburdening adjustment transactions

Automatically assigned

WDRDJ (Release Date)

 

WDRDJ

WDRFBS (Revenue Fee Basis)

 

Automatically assigned

WDRGLC (Retention G/L Offset)

 

WIRGLC/F48128

WDRP11 (Category Code 011)

WDMCU (Business Unit) field in the F4812 record.

MCRP11/F0006

WDRP12 (Category Code 012)

WDHMCU (Home Business Unit) field in the F4812 record.

MCRP12/F0006

WDRTNG (Retainage)

 

Automatically calculated

WDRTPS (Retainage Prior)

 

Automatically calculated

WDSBAR (Reason Code)

UDC 48/AR Re-extend and NTE reason codes

WDSBAR

WDSBL (Subledger)

Service Billing

GLSBL/F0911

WDSBL5 (Subledger)

Contract Billing

G6SBL/F5202

WDSBL6 (Subledger)

 

Not used

WDSBLT (Subledger Type)

Service Billing

GLSBLT/F0911

WDSBSK (Summarization Key)

 

Automatically assigned

WDSBSQ (Sequence Number)

 

Automatically assigned

WDSBT5 (Subledger Type)

Contract Billing

G6SBLT/F5202

WDSBT6 (Subledger Type)

 

Not used

WDSCSQ (Secondary Sequence Number)

 

Automatically assigned

WDSFX (Pay Item)

 

Automatically assigned

WDSLNK (Split Link)

 

Automatically assigned

WDSUB (Subsidiary)

Default

GLSUB/F0911

 

Burden

YSSUB/F0724

WDSUBA (Alternate Subsidiary)

Retrieved from Account Master using MCU, OBJ, SUB

GMSUBA / F0901

WDTBDT (Table Basis Date)

WZEBAS (Date - Effectivity Basis) field in the F48091 record contains 1.

GLDGJ (G/L Date)/F0911

 

WZEBAS field contains 2.

GLDSVJ (Service/Tax Date)/F0911

WDTCLS (Classification)

Components (provisional burdens)

0

 

GLDCT (Document Type) field in the F0911 record contains either T2 or T4.

1

 

Burden

2

 

GLDCT field contains TE.

3

 

GLDCT field does not contain T2, T4, or T5.

 
 

A) Related records exist in both F0911 and F1202 tables. Both records have the same serial number (GLASID and FAASID, respectively).

3

 

B) GLICUT (Batch Type) field in the F0911 record contains N.

4

 

GLD0C, GLDCT, GLKCO, and GLDGL (Document Number, Type, Company, and G/L Date) fields in the F0911 record.

 
 

C) GLICUT field contains either V or W. GLD0C, GLDCT, and GLKCO fields in the F0911 record.

5

 

D) GLICUT field contains G. A related record exists in F0006 table.

6

 

None of the previous conditions are satisfied, and the GLPO (P.O. Number) field in the F0911 record is not blank.

5

 

SWMS

C Service Contracts

D Service Orders

E Claims

F Calls

 

WDTKA1 (Key Type - Acct Derivation Table 1)

 

Not Used

WDTKA2 (Key Type - Acct Derivation Table 2)

 

Not Used

WDTKA3 (Key Type - Acct Derivation Table 3)

 

Not Used

WDTKG1 (Key Type - G/L Offset Table)

From G/L Offset Table used

WITYKY / F48128

WDTKM1 (Key Type - Markup Table Type 1)

From Markup Table used

WQTYKY / F48096

WDTKM2 (Key Type - Markup Table Type 2)

From Markup Table used

WQTYKY / F48096

WDTKM3 (Key Type - Markup Table Type 3)

From Markup Table used

WQTYKY / F48096

WDTKT1 (Key Type - Tax Derivation Table)

From Tax Derivation Table used

WOTYKY / F48127

WDTOG (Taxable or Gross)

 

Value is 1.

 

F4812 record contains tax rate/area and explanation codes

 
 

Neither of the previous conditions exist.

Blank

WDTX (Purchasing Taxable)

 

Value is Y.

 

F4812 record contains tax rate/area and explanation codes.

 
 

Neither of the previous conditions exist.

Value is N.

WDTXA1 (Tax Rate/Areas)

Contract Billing

G6TXA1/F5202

 

Service Billing

WOTXA1/F48127

WDTYKY (Key Type)

 

Not used

WDU (Units)

Default

GLU/F0911

 

GLDCT (Document Type) field in the F0911 record contains either T2 or T4.

YTPHRW (Hours Worked)/F0618 or F06116

 

GLDCT field contains T5.

YTEQHR (Equipment Hours)/F0618 or F06116

WDUM (Unit of Measure)

Default.

GLUM/F0911

 

GLDCT field contains T2, T4, or T5.

HR

WDUPMJ (Date Updated)

 

Automatically assigned

WDUPMT (Time Last Updated)

 

Automatically assigned

WDUSER (User ID)

 

Automatically assigned

WDVGCOA (Order Acceptance Geocode)

Vertex is active.

Value of VGCSF

WDVGCSF (Ship From Geocode)

Vertex is active.

Geocode of MCU (Blank)

   

Geocode of AN8 of MCU (Blank)

   

Geocode of Address Book Number of Company of MCU(Blank)

WDVINV (Supplier Invoice Number)

When doc type is PV.

GLVINV/F0911

WDVOID (Void - V)

 

Automatically assigned

WDVVTC (Vertex Product Category)

Service Billing

Vertex is active.

VVTC/F48127

 

Contract Billing

Vertex is active.

VVTC/F5202

WDVVTY (Vertex Transaction Type)

Service Billing

Vertex is active.

VVTY/F48127

 

Contract Billing

Vertex is active.

VVTY/F5202

WDWR01 (Phase)

 

GLWR01/F0911

WDWR07 (Service Type)

GLSBL (Subledger) field in the F0911 record is blank.

WAWR07/F4801

 

GLSBLT (Subledger type) field contains W.