This appendix contains the following topics:
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 |
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. |